Hi Rahul, thanks for the answer. Yes it works fine from the server / command line client (sqlline / drill-localhost). An I am on windows using drill-jdbc-all-1.9.0.jar, trying from within several client programs (squirrel, sqlwb etc.) to eliminate them from the equation.
Regards, David -----Ursprüngliche Nachricht----- Von: rahul challapalli [mailto:[email protected]] Gesendet: Donnerstag, 30. März 2017 18:26 An: user <[email protected]> Betreff: 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 > > > >
