Re: JDBC SQL parse error on CTAS

2017-04-25 Thread Zelaine Fong
>> query appears to have broken the parser's semantics. So it is possible >> that you need some escape characters to handle the query, without which, >> Python might be altering the query. >> >> >> Kunal >> >> >> From: Wesle

Re: JDBC SQL parse error on CTAS

2017-04-25 Thread Wesley Chow
t where the >> query appears to have broken the parser's semantics. So it is possible >> that you need some escape characters to handle the query, without which, >> Python might be altering the query. >> >> >> Kunal >> >>

Re: JDBC SQL parse error on CTAS

2017-04-24 Thread Wesley Chow
the query > appears to have broken the parser's semantics. So it is possible that you > need some escape characters to handle the query, without which, Python > might be altering the query. > > > Kunal > > ________ > From: Wesley Chow >

Re: JDBC SQL parse error on CTAS

2017-04-24 Thread Zelaine Fong
escape characters to handle the query, without which, Python might be altering the query. Kunal From: Wesley Chow Sent: Monday, April 24, 2017 2:33:14 PM To: user@drill.apache.org Subject: JDBC SQL parse error on CTAS

Re: JDBC SQL parse error on CTAS

2017-04-24 Thread Kunal Khatua
n the parser's semantics. So it is possible that you need some escape characters to handle the query, without which, Python might be altering the query. Kunal From: Wesley Chow Sent: Monday, April 24, 2017 2:33:14 PM To: user@drill.apache.org Subject: JDBC

JDBC SQL parse error on CTAS

2017-04-24 Thread Wesley Chow
I'm seeing a funny issue where issuing SELECT statements through the JDBC driver is fine, but when I prepend them with CREATE TABLE AS, I start getting parse errors. If I copy+paste the query string into sqlline the CTAS works. When the thing breaks, it gives me an exception with message like: SQL