python - superset不能加载数据

问题描述

问 题

在安装好superset后打算用命令superset load_examples加载示例数据，但是命令行内提示了这些错误，多次网页搜索不得结果。到底这是哪方面的错误？

         Traceback (most recent call last):
  File "/Users/cyaolong/.virtualenvs/env1/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1182, in _execute_context
    context)
  File "/Users/cyaolong/.virtualenvs/env1/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 470, in do_execute
    cursor.execute(statement, parameters)
sqlite3.OperationalError: no such table: logs

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "/Users/cyaolong/.virtualenvs/env1/lib/python3.6/site-packages/flask/app.py", line 1982, in wsgi_app
    response = self.full_dispatch_request()
  File "/Users/cyaolong/.virtualenvs/env1/lib/python3.6/site-packages/flask/app.py", line 1614, in full_dispatch_request
    rv = self.handle_user_exception(e)
  File "/Users/cyaolong/.virtualenvs/env1/lib/python3.6/site-packages/flask/app.py", line 1517, in handle_user_exception
    reraise(exc_type, exc_value, tb)
  File "/Users/cyaolong/.virtualenvs/env1/lib/python3.6/site-packages/flask/_compat.py", line 33, in reraise
    raise value
  File "/Users/cyaolong/.virtualenvs/env1/lib/python3.6/site-packages/flask/app.py", line 1612, in full_dispatch_request
    rv = self.dispatch_request()
  File "/Users/cyaolong/.virtualenvs/env1/lib/python3.6/site-packages/flask/app.py", line 1598, in dispatch_request
    return self.view_functions[rule.endpoint](**req.view_args)
  File "/Users/cyaolong/.virtualenvs/env1/lib/python3.6/site-packages/superset/models/core.py", line 772, in wrapper
    sesh.commit()
  File "/Users/cyaolong/.virtualenvs/env1/lib/python3.6/site-packages/sqlalchemy/orm/session.py", line 874, in commit
    self.transaction.commit()
  File "/Users/cyaolong/.virtualenvs/env1/lib/python3.6/site-packages/sqlalchemy/orm/session.py", line 461, in commit
    self._prepare_impl()
  File "/Users/cyaolong/.virtualenvs/env1/lib/python3.6/site-packages/sqlalchemy/orm/session.py", line 441, in _prepare_impl
    self.session.flush()
  File "/Users/cyaolong/.virtualenvs/env1/lib/python3.6/site-packages/sqlalchemy/orm/session.py", line 2139, in flush
    self._flush(objects)
  File "/Users/cyaolong/.virtualenvs/env1/lib/python3.6/site-packages/sqlalchemy/orm/session.py", line 2259, in _flush
    transaction.rollback(_capture_exception=True)
  File "/Users/cyaolong/.virtualenvs/env1/lib/python3.6/site-packages/sqlalchemy/util/langhelpers.py", line 66, in __exit__
    compat.reraise(exc_type, exc_value, exc_tb)
  File "/Users/cyaolong/.virtualenvs/env1/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 187, in reraise
    raise value
  File "/Users/cyaolong/.virtualenvs/env1/lib/python3.6/site-packages/sqlalchemy/orm/session.py", line 2223, in _flush
    flush_context.execute()
  File "/Users/cyaolong/.virtualenvs/env1/lib/python3.6/site-packages/sqlalchemy/orm/unitofwork.py", line 389, in execute
    rec.execute(self)
  File "/Users/cyaolong/.virtualenvs/env1/lib/python3.6/site-packages/sqlalchemy/orm/unitofwork.py", line 548, in execute
    uow
  File "/Users/cyaolong/.virtualenvs/env1/lib/python3.6/site-packages/sqlalchemy/orm/persistence.py", line 181, in save_obj
    mapper, table, insert)
  File "/Users/cyaolong/.virtualenvs/env1/lib/python3.6/site-packages/sqlalchemy/orm/persistence.py", line 835, in _emit_insert_statements
    execute(statement, params)
  File "/Users/cyaolong/.virtualenvs/env1/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 945, in execute
    return meth(self, multiparams, params)
  File "/Users/cyaolong/.virtualenvs/env1/lib/python3.6/site-packages/sqlalchemy/sql/elements.py", line 263, in _execute_on_connection
    return connection._execute_clauseelement(self, multiparams, params)
  File "/Users/cyaolong/.virtualenvs/env1/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1053, in _execute_clauseelement
    compiled_sql, distilled_params
  File "/Users/cyaolong/.virtualenvs/env1/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1189, in _execute_context
    context)
  File "/Users/cyaolong/.virtualenvs/env1/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1402, in _handle_dbapi_exception
    exc_info
  File "/Users/cyaolong/.virtualenvs/env1/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 203, in raise_from_cause
    reraise(type(exception), exception, tb=exc_tb, cause=cause)
  File "/Users/cyaolong/.virtualenvs/env1/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 186, in reraise
    raise value.with_traceback(tb)
  File "/Users/cyaolong/.virtualenvs/env1/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1182, in _execute_context
    context)
  File "/Users/cyaolong/.virtualenvs/env1/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 470, in do_execute
    cursor.execute(statement, parameters)
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) no such table: logs [SQL: 'INSERT INTO logs (action, user_id, dashboard_id, slice_id, json, dttm, dt, duration_ms, referrer) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)'] [parameters: ('import_dashboards', '1', None, 0, '{}', '2017-08-10 12:57:08.022755', '2017-08-10', 78.621, 'http://localhost:8088/superset/profile/cyaolong/')]

      

解决方案

已经解决了，其实是因为漏了操作superset db upgrade初始化数据库。

这篇关于python - superset不能加载数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！