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 > > > >
