Hi all,
I am attempting to send a query from python3 via JayDeBeApi and am
encountering the issue that the SQL is enclosed in a SELECT * FROM $myquery
LIMIT 0
With:
conn = jaydebeapi.connect("org.apache.drill.jdbc.Driver",
"jdbc:drill:drillbit=$mycluster:$myport",
["$username", "$password"],
"/tmp/drill-jdbc-all-1.12.0.jar")
curs = conn.cursor()
curs = conn.cursor()
curs.execute('SHOW DATABASES')
... the query hits Drill as:
SELECT * FROM (SHOW DATABASES) LIMIT 0
A select * from mytable limit 100 also has the same issue.
Drill is version 1.12
This also occurs with other queries. I found
https://issues.apache.org/jira/browse/DRILL-5136 which looks similar and
lists "Client - ODBC" (not JDBC)
Has anyone else encountered this?
