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