Lane David (ST-ESS/MKP3.2)
2017-03-30 07:57:29 UTC
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 | ***@de.bosch.com<mailto:***@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
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 | ***@de.bosch.com<mailto:***@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