AW: Quoting queries

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 -

Re: Wrong alias name in Window function

Thank you Arina. I tried your query, and the create query statement fails with the following stack (on a fresh 1.10 installation, mac), any ideas? Regarding my issue, I'm working on re-creating it. SYSTEM ERROR: URISyntaxException: Relative path in absolute URI: wifi-03-30-2017__00:03

Re: JDBC disconnections over remote networks

Hi Wesley I don't believe the G1GC would be the issue here. The Client libraries have an internal buffer which is, most likely, getting full. Your problem sounds similar to https://issues.apache.org/jira/browse/DRILL-5217 ; though it is JDBC related and not the ODBC (C++ client). The problem h

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 ___

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

Re: JDBC disconnections over remote networks

I haven't used G1GC in any of my testing. So I cannot comment much on whether it would be helpful or not. On Thu, Mar 30, 2017 at 8:35 AM, Wesley Chow wrote: > Sorry I haven't had time to look into this much and fix our logging setup, > but I did try explicitly setting JVM heap values in the cli

Re: JDBC disconnections over remote networks

Sorry I haven't had time to look into this much and fix our logging setup, but I did try explicitly setting JVM heap values in the client rather than relying on the default allocation and after a few runs it does seem that fixed it. I'm going to cautiously say that was the issue. Thanks! Would it

Quoting queries

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