Re: QSQL via jdbc (python3 and JayDeBeApi) wraps with SELECT ... LIMIT 0

2018-03-20 Thread Charles Givre
gt; >>> This error looks familiar and might be because of the Python library >>> wrapping a select * around the original query. >>> >>> Using the JDBC driver directly doesn’t seem to show this problem. Drill >>> 1.13.0 is out now. Could you give a

Re: QSQL via jdbc (python3 and JayDeBeApi) wraps with SELECT ... LIMIT 0

2018-03-20 Thread Francis McGregor-Macdonald
> > 1.13.0 is out now. Could you give a try with that and confirm if the > > behavior is the same? > > > > -Original Message- > > From: Charles Givre > > Sent: Sunday, March 18, 2018 9:10 PM > > To: user@drill.apache.org > > Subject: Re: QSQL via

Re: QSQL via jdbc (python3 and JayDeBeApi) wraps with SELECT ... LIMIT 0

2018-03-19 Thread Kunal Khatua
his problem. Drill > 1.13.0 is out now. Could you give a try with that and confirm if the > behavior is the same? > > -Original Message- > From: Charles Givre > Sent: Sunday, March 18, 2018 9:10 PM > To: user@drill.apache.org > Subject: Re: QSQL via jdbc (python3 and JayDeBeA

Re: QSQL via jdbc (python3 and JayDeBeApi) wraps with SELECT ... LIMIT 0

2018-03-19 Thread Francis McGregor-Macdonald
..@gmail.com> > Sent: Sunday, March 18, 2018 9:10 PM > To: user@drill.apache.org > Subject: Re: QSQL via jdbc (python3 and JayDeBeApi) wraps with SELECT ... > LIMIT 0 > > Hi Francis, > > > The code below worked for me. Also, I don’t know if it matters, bu

RE: QSQL via jdbc (python3 and JayDeBeApi) wraps with SELECT ... LIMIT 0

2018-03-18 Thread Kunal Khatua
onfirm if the behavior is the same? -Original Message- From: Charles Givre Sent: Sunday, March 18, 2018 9:10 PM To: user@drill.apache.org Subject: Re: QSQL via jdbc (python3 and JayDeBeApi) wraps with SELECT ... LIMIT 0 Hi Francis, The code below worked for me. Also, I don’t know if it m

RE: QSQL via jdbc (python3 and JayDeBeApi) wraps with SELECT ... LIMIT 0

2018-03-18 Thread Kunal Khatua
Message- From: Charles Givre <cgi...@gmail.com> Sent: Sunday, March 18, 2018 9:10 PM To: user@drill.apache.org Subject: Re: QSQL via jdbc (python3 and JayDeBeApi) wraps with SELECT ... LIMIT 0 Hi Francis, The code below worked for me. Also, I don’t know if it matters, but did you

Re: QSQL via jdbc (python3 and JayDeBeApi) wraps with SELECT ... LIMIT 0

2018-03-18 Thread Charles Givre
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",