Hi Ted, No I tried that but the problem still exists. I have also tried this on other configurations (at home etc.) and it is a general problem (i.e. not related to my setup or choice of client).
Regards, David -----Original Message----- From: Ted Dunning [mailto:[email protected]] Sent: Mittwoch, 26. April 2017 23:59 To: user <[email protected]> Subject: Re: Quoting queries 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) < [email protected]> 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:[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 > > > > > > > > >
