@mistercrunch if I write `select * from table` in SQL Lab, there is no error. If I write `select * from table fetch first 100 rows only`, I get the 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` When I click on the "Preview for tablename" tabs that appear in SQL Lab, 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` If you're interested in reproducing the problem, the [DB2 Express-C](https://hub.docker.com/r/ibmcom/db2express-c/) docker image is a quick way to get a DB2 database up and running with sample data and then you'll need to `pip install ibm_db` and `easy_install ibm_db_sa`. The SqlAlchemy URI for the default database will be `db2+ibm_db://db2inst1:[email protected]:50000/SAMPLE`. [ Full content available at: https://github.com/apache/incubator-superset/issues/5063 ] This message was relayed via gitbox.apache.org for [email protected]
