You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by GitBox <gi...@apache.org> on 2022/04/06 07:46:07 UTC
[GitHub] [superset] sujiplr opened a new issue, #19546: Error while saving Virtual data set using explore 1.5.0rc1
sujiplr opened a new issue, #19546:
URL: https://github.com/apache/superset/issues/19546
A clear and concise description of what the bug is.
#### How to reproduce the bug
Run query in SQLEditor and after getting the result try explore and save the data set then it will throw error.
### stack trace
Traceback (most recent call last):
File “/usr/local/lib/python3.8/site-packages/flask/app.py”, line 1950, in full_dispatch_request
rv = self.dispatch_request()
File “/usr/local/lib/python3.8/site-packages/flask/app.py”, line 1936, in dispatch_request
return self.view_functions[rule.endpoint](**req.view_args)
File “/usr/local/lib/python3.8/site-packages/flask_appbuilder/security/decorators.py”, line 148, in wraps
return f(self, *args, **kwargs)
File “/app/superset/utils/log.py”, line 245, in wrapper
value = f(*args, **kwargs)
File “/app/superset/views/core.py”, line 2227, in sqllab_viz
db.session.commit()
File “/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/scoping.py”, line 163, in do
return getattr(self.registry(), name)(*args, **kwargs)
File “/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/session.py”, line 1046, in commit
self.transaction.commit()
File “/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/session.py”, line 504, in commit
self._prepare_impl()
File “/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/session.py”, line 483, in _prepare_impl
self.session.flush()
File “/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/session.py”, line 2540, in flush
self._flush(objects)
File “/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/session.py”, line 2682, in _flush
transaction.rollback(_capture_exception=True)
File “/usr/local/lib/python3.8/site-packages/sqlalchemy/util/langhelpers.py”, line 68, in __exit__
compat.raise_(
File “/usr/local/lib/python3.8/site-packages/sqlalchemy/util/compat.py”, line 182, in raise_
raise exception
File “/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/session.py”, line 2642, in _flush
flush_context.execute()
File “/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/unitofwork.py”, line 422, in execute
rec.execute(self)
File “/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/unitofwork.py”, line 586, in execute
persistence.save_obj(
File “/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/persistence.py”, line 248, in save_obj
_finalize_insert_update_commands(
File “/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/persistence.py”, line 1432, in _finalize_insert_update_commands
mapper.dispatch.after_insert(mapper, connection, state)
File “/usr/local/lib/python3.8/site-packages/sqlalchemy/event/attr.py”, line 322, in __call__
fn(*args, **kw)
File “/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/events.py”, line 731, in wrap
fn(*arg, **kw)
File “/app/superset/connectors/sqla/models.py”, line 2031, in after_insert
SqlaTable.write_shadow_dataset(target, database, session)
File “/app/superset/connectors/sqla/models.py”, line 2385, in write_shadow_dataset
tables = load_or_create_tables(
File “/app/superset/connectors/sqla/utils.py”, line 221, in load_or_create_tables
columns = [
File “/app/superset/connectors/sqla/utils.py”, line 226, in <listcomp>
is_temporal=column[“type”].python_type.__name__.upper()
File “/usr/local/lib/python3.8/site-packages/sqlalchemy/sql/type_api.py”, line 410, in python_type
raise NotImplementedError()
NotImplementedError
2022-04-05 13:00:26,310:ERROR:superset.views.base:
Traceback (most recent call last):
File “/usr/local/lib/python3.8/site-packages/flask/app.py”, line 1950, in full_dispatch_request
rv = self.dispatch_request()
File “/usr/local/lib/python3.8/site-packages/flask/app.py”, line 1936, in dispatch_request
return self.view_functions[rule.endpoint](**req.view_args)
File “/usr/local/lib/python3.8/site-packages/flask_appbuilder/security/decorators.py”, line 148, in wraps
return f(self, *args, **kwargs)
File “/app/superset/utils/log.py”, line 245, in wrapper
value = f(*args, **kwargs)
File “/app/superset/views/core.py”, line 2227, in sqllab_viz
db.session.commit()
File “/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/scoping.py”, line 163, in do
return getattr(self.registry(), name)(*args, **kwargs)
File “/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/session.py”, line 1046, in commit
self.transaction.commit()
File “/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/session.py”, line 504, in commit
self._prepare_impl()
File “/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/session.py”, line 483, in _prepare_impl
self.session.flush()
File “/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/session.py”, line 2540, in flush
self._flush(objects)
File “/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/session.py”, line 2682, in _flush
transaction.rollback(_capture_exception=True)
File “/usr/local/lib/python3.8/site-packages/sqlalchemy/util/langhelpers.py”, line 68, in __exit__
compat.raise_(
File “/usr/local/lib/python3.8/site-packages/sqlalchemy/util/compat.py”, line 182, in raise_
raise exception
File “/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/session.py”, line 2642, in _flush
flush_context.execute()
File “/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/unitofwork.py”, line 422, in execute
rec.execute(self)
File “/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/unitofwork.py”, line 586, in execute
persistence.save_obj(
File “/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/persistence.py”, line 248, in save_obj
_finalize_insert_update_commands(
File “/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/persistence.py”, line 1432, in _finalize_insert_update_commands
mapper.dispatch.after_insert(mapper, connection, state)
File “/usr/local/lib/python3.8/site-packages/sqlalchemy/event/attr.py”, line 322, in __call__
fn(*args, **kw)
File “/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/events.py”, line 731, in wrap
fn(*arg, **kw)
File “/app/superset/connectors/sqla/models.py”, line 2031, in after_insert
SqlaTable.write_shadow_dataset(target, database, session)
File “/app/superset/connectors/sqla/models.py”, line 2385, in write_shadow_dataset
tables = load_or_create_tables(
File “/app/superset/connectors/sqla/utils.py”, line 221, in load_or_create_tables
columns = [
File “/app/superset/connectors/sqla/utils.py”, line 226, in <listcomp>
is_temporal=column[“type”].python_type.__name__.upper()
File “/usr/local/lib/python3.8/site-packages/sqlalchemy/sql/type_api.py”, line 410, in python_type
raise NotImplementedError()
NotImplementedError
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] villebro closed issue #19546: Error while saving Virtual data set using explore 1.5.0rc1
Posted by GitBox <gi...@apache.org>.
villebro closed issue #19546: Error while saving Virtual data set using explore 1.5.0rc1
URL: https://github.com/apache/superset/issues/19546
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org