Hi all, just to bump this, is there anything that can be done here? At the moment I am reduced to executing queries on the command line and scraping the data together afterwards which is partly very time consuming.
Mit freundlichen Grüßen / Best regards David Lane -----Ursprüngliche Nachricht----- Von: Lane David (ST-ESS/MKP3.2) [mailto:[email protected]] Gesendet: Dienstag, 4. April 2017 09:27 An: [email protected] Betreff: AW: Quoting queries I don't have time to write a test program but I can confirm that the exact same problem with the same error message happens in Squirrel, SqlWorkbench (http://www.sql-workbench.net/) and intellij, so I'm pretty sure it's a JDBC driver problem. Mit freundlichen Grüßen / Best regards David Lane Product Management Cloud-based Services (ST-ESS/MKP3.2) Bosch Sicherheitssysteme GmbH | Postfach 11 11 | 85626 Grasbrunn | GERMANY | boschbuildingsecurity.com Tel. +49(89)6290-1674 | Fax +49(89)6290 | [email protected] Sitz: Stuttgart, Registergericht: Amtsgericht Stuttgart HRB 23118 Aufsichtsratsvorsitzender: Stefan Hartung; Geschäftsführung: Gert van Iperen, Andreas Bartz, Thomas Quante, Bernhard Schuster -----Ursprüngliche Nachricht----- Von: Kunal Khatua [mailto:[email protected]] Gesendet: Freitag, 31. März 2017 23:30 An: [email protected] Betreff: Re: Quoting queries I take that back. The issue looks more likely related to SQuirreL. It seems to be truncating anything after the '*' when submitting the query. I tried with a standalone JDBC program on Windows and it succeeded in submitting the full query and getting back the results from a remote Linux Drillbit in distributed mode. So, looks like a SQuirreL problem. Can you try with a standalone program and the Drill 1.10 JDBC driver (drill-jdbc-all-1.10.0*.jar) just to confirm that the issue is indeed in the JDBC driver and not the SQuirreL application? ________________________________ From: Kunal Khatua <[email protected]> Sent: Friday, March 31, 2017 11:58:56 AM To: [email protected] Subject: RE: Quoting queries This seems to be a windows JDBC client specific problem. Using SQuirreL, I tried with this on Windows while accessing a Linux server: select * from `nation_json/a/1/*/nation.json`; Error: PARSE ERROR: Lexical error at line 1, column 31. Encountered: <EOF> after : "`nation_json/a/1" SQL Query select * from `nation_json/a/1 ^ [Error Id: f67bb648-8ef2-418e-a53c-e8a835a4e3f9 on pssc-65.qa.lab:31010] SQLState: null ErrorCode: 0 The server profiles listing: http://<hostname>:8047/profiles/ Is showing that the query submitted was select * from `nation_json/a/1 This works from Sqlline (Linux client) when connecting to the Linux Drillbit. Please log a bug for this. Thanks -----Original Message----- From: Lane David (ST-ESS/MKP3.2) [mailto:[email protected]] Sent: Friday, March 31, 2017 3:51 AM To: [email protected] Subject: AW: Quoting queries BTW I tried with the 1.10 version on both sides (server and client) and I still get the same error. -----Ursprüngliche Nachricht----- Von: Kunal Khatua [mailto:[email protected]] Gesendet: Donnerstag, 30. März 2017 20:04 An: user <[email protected]> Betreff: Re: Quoting queries What is the client machine from where you're issuing the query? Is it Windows? Drill 1.10 has a fix for Windows wildcard: https://issues.apache.org/jira/browse/DRILL-4812 Can you try with that? Kunal Khatua Engineering [1490734684477_mapr.png] www.mapr.com<http://www.mapr.com/> ________________________________ From: rahul challapalli <[email protected]> Sent: Thursday, March 30, 2017 9:26:25 AM To: user Subject: Re: Quoting queries Hmm...strange. It works for me on drill 1.9.0 from the sqlline client. Can you try running it from sqlline just so that we can eliminate other tools trying to do some validation and failing? 0: jdbc:drill:zk=x.x.x.x:5181> select * from `a/b/c.json`; *+-----+* *| **id ** |* *+-----+* *| *1 * |* *+-----+* 1 row selected (0.209 seconds) 0: jdbc:drill:zk=x.x.x.x:5181> select * from `a/*/c.json`; *+-------+-----+* *| **dir0 ** | **id ** |* *+-------+-----+* *| *b * | *1 * |* *+-------+-----+* 1 row selected (0.233 seconds) On Thu, Mar 30, 2017 at 12:57 AM, Lane David (ST-ESS/MKP3.2) < [email protected]> wrote: > Hi all, > > we are experimenting with Drill at the moment. Everything is working > fine on the server and I can execute any queries I need there > successfully. I followed the instructions on the following page to get > it working from a client computer: > https://drill.apache.org/docs/using-jdbc-with-squirrel-on-windows/ > > This has also been successful and I can execute simple queries from > Squirrel. However I get various parse errors when certain other > patterns are used. > > The following works: > select * from `a/b/c.json`; > > The following doesn't: > select * from `a/*/c.json`; > > Error: PARSE ERROR: Lexical error at line 1, column 44. Encountered: > <EOF> after : "`a" > > I tried the following: > select * from `a/\*/c.json`; > Error: VALIDATION ERROR: From line 1, column 33 to line 1, column 60: > Table 'a/\*/c.json' not found > And various other combinations of \, /, ', etc. > > I have tried Squirrel, SQL WB, Intellij > > Anyone got this working? > > Mit freundlichen Grüßen / Best regards > > David Lane > > Product Management Cloud-based Services (ST-ESS/MKP3.2) Bosch > Sicherheitssysteme GmbH | Postfach 11 11 | 85626 Grasbrunn | GERMANY > | boschbuildingsecurity.com<http://boschbuildingsecurity.com> > Tel. +49(89)6290-1674 | Fax +49(89)6290 | [email protected]<mailto: > [email protected]> > > Sitz: Stuttgart, Registergericht: Amtsgericht Stuttgart HRB 23118 > Aufsichtsratsvorsitzender: Stefan Hartung; Geschäftsführung: Gert van > Iperen, Andreas Bartz, Thomas Quante, Bernhard Schuster > > > >
