venkat
1
Unable to query through python client if sql statement contains comments.
Error: ODBC error
state: HY000
native error code: 1040
message: [Dremio][Connector] (1040) Dremio failed to execute the query: SELECT
– b.apr_retail as apr_retail_Oct2018…[see log]
ODBC driver should not be interpreting the query. Does the exact same query works in the UI?
venkat
3
Thanks Laurent, Yes, it works fine in Dremio UI but same query fails when I run through Python Client API.
Would it be possible to share and attach the profile of the failed query? (see https://www.dremio.com/tutorials/share-query-profile-dremio/)