running converted dremio rpm about sqlalchemy_dremio HOT 7 CLOSED

Got the above sorted out. Using alien -i dremio-odbc-1.4.2.1003-1.x86_64.rpm instead of dremio-odbc-LATEST.x86_64.rpm works.

BTW, using dremio data sources in SQL Lab always returns error -

Shape_ of passed values is (100, 1), indices imply (100, 34). Any advice?

from sqlalchemy_dremio.

@thbeh Can you post the full trace? I haven't see that one. What version of superset are you using? The one that's stable is 0.36

from sqlalchemy_dremio.

Currently I am running 0.35.2.

from sqlalchemy_dremio.

Just upgraded to 0.36, same issue in SQL Lab.

Nothing much from the logs, only saw the below but job in dremio ran successfully. Any other logs to look at?

_2020-06-19 21:47:59,912:INFO:root:Query 7: Handling cursor
2020-06-19 21:47:59,913:DEBUG:root:[stats_logger] (timing) sqllab.query.time_executing_query | 579.898681640625
2020-06-19 21:47:59,925:DEBUG:root:Query 7: Fetching data for query object: {'changedOn': datetime.datetime(2020, 6, 19, 21, 47, 59, 329624), 'changed_on': '2020-06-19T21:47:59.329624', 'dbId': 2, 'db': 'dremio', 'endDttm': None, 'errorMessage': None, 'executedSql': 'SELECT i_category,\n d_year,\n d_moy,\n avg_monthly_sales,\n sum_sales,\n psum,\n nsum\nFROM consumption.query_57_curated\nLIMIT 100', 'id': 'u5RSHMzY', 'limit': 100, 'progress': 0, 'rows': None, 'schema': None, 'ctas': False, 'serverId': 7, 'sql': 'SELECT i_category,\n d_year,\n d_moy,\n avg_monthly_sales,\n sum_sales,\n psum,\n nsum\nFROM consumption.query_57_curated\nLIMIT 100', 'sqlEditorId': None, 'startDttm': Decimal('1592603278867.325000'), 'state': 'running', 'tab': '', 'tempTable': None, 'userId': 1, 'user': 'TH Beh', 'resultsKey': None, 'trackingUrl': None, 'extra': {'progress': 'Running statement 1 out of 1'}}
2020-06-19 21:47:59,930:DEBUG:root:[stats_logger] (timing) sqllab.query.time_fetching_results | 17.551025390625
2020-06-19 21:47:59,931:DEBUG:root:Query 7: Fetching cursor description

from sqlalchemy_dremio.

@thbeh Does the same query run in Dremio UI? Was the query submitted to Dremio at all? (You can check the jobs page)

from sqlalchemy_dremio.

Saw the job ran without issue in Dremio UI. The error only occurs in SQL Lab.

from sqlalchemy_dremio.

I refactor my Docker to use Postgres for backend and seems working now. Earlier I was using MySQL, not sure whether that could be the cause. Thanks

from sqlalchemy_dremio.