David, Did the jdbc driver that Kunal recommended solve your problem?
On Wed, Apr 26, 2017 at 12:29 AM, Lane David (ST-ESS/MKP3.2) < david.l...@de.bosch.com> wrote: > 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:david.l...@de.bosch.com] > Gesendet: Dienstag, 4. April 2017 09:27 > An: user@drill.apache.org > 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 | > david.l...@de.bosch.com > > 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:kkha...@mapr.com] > Gesendet: Freitag, 31. März 2017 23:30 > An: user@drill.apache.org > 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 <kkha...@mapr.com> > Sent: Friday, March 31, 2017 11:58:56 AM > To: user@drill.apache.org > 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:david.l...@de.bosch.com] > Sent: Friday, March 31, 2017 3:51 AM > To: user@drill.apache.org > 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:kkha...@mapr.com] > Gesendet: Donnerstag, 30. März 2017 20:04 > An: user <user@drill.apache.org> > 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 <challapallira...@gmail.com> > 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) < > david.l...@de.bosch.com> 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 | david.l...@de.bosch.com< > mailto: > > david.l...@de.bosch.com> > > > > Sitz: Stuttgart, Registergericht: Amtsgericht Stuttgart HRB 23118 > > Aufsichtsratsvorsitzender: Stefan Hartung; Geschäftsführung: Gert van > > Iperen, Andreas Bartz, Thomas Quante, Bernhard Schuster > > > > > > > > >
