Error while saving Virtual data set using explore 1.5.0rc1

[sujiplr]

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_functionsrule.endpoint
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
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_functionsrule.endpoint
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
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