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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
