Hi Ted, I don't have time to do this and I'm not sure of the benefit. I'm not trying to be snide and I appreciate this is open source software and I have not paid for support etc. but even it does work with a self-written java program how does this help me or what does it mean? I have tried 3 "off the shelf" java clients and they all don't work with: in my opinion it would be worthwhile finding out why. There is even a help page that details how to get drill working with squirrel: https://drill.apache.org/docs/using-jdbc-with-squirrel-on-windows/
Regards, David -----Ursprüngliche Nachricht----- Von: Ted Dunning [mailto:[email protected]] Gesendet: Donnerstag, 27. April 2017 18:58 An: user <[email protected]> Betreff: Re: Quoting queries David, Did you specifically try the test that Kunal did (with a standalone JDBC client) On Thu, Apr 27, 2017 at 5:23 AM, Lane David (ST-ESS/MKP3.2) < [email protected]> wrote: > 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 > > > > > > > > > > > > > > >
