Hi Francis,
The code below worked for me. Also, I don’t know if it matters, but did you mean to create two cursors? — C import jaydebeapi import pandas as pd #Create the connection object conn = jaydebeapi.connect("org.apache.drill.jdbc.Driver", "jdbc:drill:drillbit=localhost:31010", ["admin", "password"], "/usr/local/share/drill/jars/jdbc-driver/drill-jdbc-all-1.12.0.jar",) #Create the Cursor Object curs = conn.cursor() #Execute the query curs.execute("SELECT * FROM cp.`employee.json` LIMIT 20") #Get the results curs.fetchall() #Read query results into a Pandas DataFrame df = pd.read_sql("SELECT * FROM cp.`employee.json` LIMIT 20", conn) > On Mar 18, 2018, at 23:41, Francis McGregor-Macdonald <fran...@mc-mac.com> > wrote: > > 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?