Skip to content

Apache superset - Error retrive db2 table information  #5063

@mariomarf

Description

@mariomarf

Make sure these boxes are checked before submitting your issue - thank you!

  • [ x ] I have checked the superset logs for python stacktraces and included it here as text if any
  • [ x ] I have reproduced the issue with at least the latest released version of superset
  • [ x ] I have checked the issue tracker for the same issue and I haven't found one similar

Superset version

0.25.5

Expected results

Table/column information

Actual results

"Error occurred while fetching table metadata".

Steps to reproduce

in "SQL Lab", select a db2 database --> Schema --> Table

LOG

2018-05-23 22:43:22,945:INFO:werkzeug:192.168.158.1 - - [23/May/2018 22:43:22] "GET /superset/table/2/ttis11_ms_od_gio/TISA%20%20%20%20/ HTTP/1.1" 500 -
Traceback (most recent call last):
File "/usr/lib/python2.7/site-packages/flask/app.py", line 1997, in call
return self.wsgi_app(environ, start_response)
File "/usr/lib/python2.7/site-packages/flask/app.py", line 1985, in wsgi_app
response = self.handle_exception(e)
File "/usr/lib/python2.7/site-packages/flask/app.py", line 1540, in handle_exception
reraise(exc_type, exc_value, tb)
File "/usr/lib/python2.7/site-packages/flask/app.py", line 1982, in wsgi_app
response = self.full_dispatch_request()
File "/usr/lib/python2.7/site-packages/flask/app.py", line 1614, in full_dispatch_request
rv = self.handle_user_exception(e)
File "/usr/lib/python2.7/site-packages/flask/app.py", line 1517, in handle_user_exception
reraise(exc_type, exc_value, tb)
File "/usr/lib/python2.7/site-packages/flask/app.py", line 1612, in full_dispatch_request
rv = self.dispatch_request()
File "/usr/lib/python2.7/site-packages/flask/app.py", line 1598, in dispatch_request
return self.view_functionsrule.endpoint
File "/usr/lib/python2.7/site-packages/flask_appbuilder/security/decorators.py", line 26, in wraps
return f(self, *args, **kwargs)
File "/usr/lib/python2.7/site-packages/superset/models/core.py", line 905, in wrapper
value = f(*args, **kwargs)
File "/usr/lib/python2.7/site-packages/superset/views/core.py", line 2253, in table
cols=columns, latest_partition=False),
File "/usr/lib/python2.7/site-packages/superset/models/core.py", line 722, in select_star
indent=indent, latest_partition=latest_partition, cols=cols)
File "/usr/lib/python2.7/site-packages/superset/db_engine_specs.py", line 256, in select_star
sql = my_db.compile_sqla_query(qry)
File "/usr/lib/python2.7/site-packages/superset/models/core.py", line 713, in compile_sqla_query
compiled = qry.compile(eng, compile_kwargs={'literal_binds': True})
File "", line 1, in

File "/usr/lib/python2.7/site-packages/sqlalchemy/sql/elements.py", line 442, in compile
return self._compiler(dialect, bind=bind, **kw)
File "/usr/lib/python2.7/site-packages/sqlalchemy/sql/elements.py", line 448, in _compiler
return dialect.statement_compiler(dialect, self, **kw)
File "/usr/lib/python2.7/site-packages/sqlalchemy/sql/compiler.py", line 453, in init
Compiled.init(self, dialect, statement, **kwargs)
File "/usr/lib/python2.7/site-packages/sqlalchemy/sql/compiler.py", line 219, in init
self.string = self.process(self.statement, **compile_kwargs)
File "/usr/lib/python2.7/site-packages/sqlalchemy/sql/compiler.py", line 245, in process
return obj._compiler_dispatch(self, **kwargs)
File "/usr/lib/python2.7/site-packages/sqlalchemy/sql/visitors.py", line 81, in _compiler_dispatch
return meth(self, **kw)
File "/usr/lib/python2.7/site-packages/ibm_db_sa-0.3.2-py2.7.egg/ibm_db_sa/base.py", line 351, in visit_select
sql_ori = compiler.SQLCompiler.visit_select(self, select, **kwargs)
File "/usr/lib/python2.7/site-packages/sqlalchemy/sql/compiler.py", line 1791, in visit_select
text += self.get_select_precolumns(select, **kwargs)
TypeError: get_select_precolumns() got an unexpected keyword argument 'literal_binds'

I hope that can help me.
Best regards
Mario

Metadata

Metadata

Assignees

No one assigned

    Labels

    inactiveInactive for >= 30 days

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions