ealtuna commented on issue #10136:
URL:
https://github.com/apache/incubator-superset/issues/10136#issuecomment-647753684
> A stacktrace would help if you can provide it.
INFO:werkzeug:127.0.0.1 - - [18/Jun/2020 17:58:34] "GET
/superset/schemas/2/false/ HTTP/1.1" 200 -
(pyodbc.Error) ('HY000', '[HY000] [Dremio][Connector] (1040) Dremio failed
to execute the query: SELECT TABLE_NAME FROM INFORMATION_SCHEMA."TABLES" WHERE
TABLE_SCHEMA = :schema\n[30038]Query execution error. Details:[ \nPARSE ERROR:
Failure parsing the query.\n\nSQL Query SELECT TABLE_NAME FROM
INFORMATION_SCHEMA."TABLES" WHERE TABLE_SCHEMA = :schema\nstartLine
1\nstartColumn 71\nendLine 1\nendColumn 71\nSQL Query SELECT TABLE_NAME FROM
INFORMATION_SCHEMA."TABLES" WHERE TAB...[see log] (1040) (SQLPrepare)')
[SQL: SELECT TABLE_NAME FROM INFORMATION_SCHEMA."TABLES" WHERE TABLE_SCHEMA
= :schema]
[parameters: {'schema': 'MySchema'}]
(Background on this error at: http://sqlalche.me/e/dbapi)
Traceback (most recent call last):
File
"/Users/userhome/Documents/repository/venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py",
line 1284, in _execute_context
cursor, statement, parameters, context
File
"/Users/userhome/Documents/repository/venv/lib/python3.7/site-packages/sqlalchemy/engine/default.py",
line 590, in do_execute
cursor.execute(statement, parameters)
pyodbc.Error: ('HY000', '[HY000] [Dremio][Connector] (1040) Dremio failed to
execute the query: SELECT TABLE_NAME FROM INFORMATION_SCHEMA."TABLES" WHERE
TABLE_SCHEMA = :schema\n[30038]Query execution error. Details:[ \nPARSE ERROR:
Failure parsing the query.\n\nSQL Query SELECT TABLE_NAME FROM
INFORMATION_SCHEMA."TABLES" WHERE TABLE_SCHEMA = :schema\nstartLine
1\nstartColumn 71\nendLine 1\nendColumn 71\nSQL Query SELECT TABLE_NAME FROM
INFORMATION_SCHEMA."TABLES" WHERE TAB...[see log] (1040) (SQLPrepare)')
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File
"/Users/userhome/Documents/repository/venv/lib/python3.7/site-packages/superset/models/core.py",
line 479, in get_all_table_names_in_schema
database=self, inspector=self.inspector, schema=schema
File
"/Users/userhome/Documents/repository/venv/lib/python3.7/site-packages/superset/db_engine_specs/base.py",
line 623, in get_table_names
tables = inspector.get_table_names(schema)
File "<string>", line 2, in get_table_names
File
"/Users/userhome/Documents/repository/venv/lib/python3.7/site-packages/sqlalchemy/util/deprecations.py",
line 139, in warned
return fn(*args, **kwargs)
File
"/Users/userhome/Documents/repository/venv/lib/python3.7/site-packages/sqlalchemy/engine/reflection.py",
line 203, in get_table_names
self.bind, schema, info_cache=self.info_cache
File "<string>", line 2, in get_table_names
File
"/Users/userhome/Documents/repository/venv/lib/python3.7/site-packages/sqlalchemy/engine/reflection.py",
line 52, in cache
ret = fn(self, con, *args, **kw)
File
"/Users/userhome/Documents/repository/venv/lib/python3.7/site-packages/sqlalchemy_dremio/base.py",
line 200, in get_table_names
result = connection.execute(sql, **params)
File
"/Users/userhome/Documents/repository/venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py",
line 2244, in execute
return connection.execute(statement, *multiparams, **params)
File
"/Users/userhome/Documents/repository/venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py",
line 1012, in execute
return self._execute_text(object_, multiparams, params)
File
"/Users/userhome/Documents/repository/venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py",
line 1187, in _execute_text
parameters,
File
"/Users/userhome/Documents/repository/venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py",
line 1324, in _execute_context
e, statement, parameters, cursor, context
File
"/Users/userhome/Documents/repository/venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py",
line 1518, in _handle_dbapi_exception
sqlalchemy_exception, with_traceback=exc_info[2], from_=e
File
"/Users/userhome/Documents/repository/venv/lib/python3.7/site-packages/sqlalchemy/util/compat.py",
line 178, in raise_
raise exception
File
"/Users/userhome/Documents/repository/venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py",
line 1284, in _execute_context
cursor, statement, parameters, context
File
"/Users/userhome/Documents/repository/venv/lib/python3.7/site-packages/sqlalchemy/engine/default.py",
line 590, in do_execute
cursor.execute(statement, parameters)
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
