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 2018/08/26 22:19:08 UTC
[GitHub] benjaminsingleton commented on issue #5063: Apache superset - Error
retrive db2 table information
benjaminsingleton commented on issue #5063: Apache superset - Error retrive db2 table information
URL: https://github.com/apache/incubator-superset/issues/5063#issuecomment-416076848
@mariomarf Have you been successful in using Superset with a DB2 database? After making manual fixes to the ibm_db_sa package (see this [issue](https://github.com/ibmdb/python-ibmdb/issues/320)), I still run into lots of issues due to SQL Lab parsing the query and adding `LIMIT` clauses, when DB2 expects `FETCH FIRST X ROWS ONLY`. For example, if after running a query I click on the tab for "Preview for [database]", I get the following error:
`
ibm_db_dbi::ProgrammingError: SQLNumResultCols failed: [IBM][CLI Driver][DB2/LINUXX8664] SQL0104N An unexpected token "LIMIT 1000000" was found following "FIRST 100 ROWS ONLY". Expected tokens may include: "<space>". SQLSTATE=42601 SQLCODE=-104
`
I'll open a separate issue, but I'm not sure if it's an external bug with ibm_db_sa or Superset.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org