Re: Apache Drill in 10 Minutes - Problems

2018-05-24 Thread Charles Givre
I love helpful error messages ;-) Can you check the classpath to see if there any additional classes that are there? I’ve gotten connection issues like this when I had a database driver in the CLASSPATH. Also take a look at this response:

RE: Apache Drill in 10 Minutes - Problems

2018-05-24 Thread Richardson, David
Thank you. This gives us a wonderful exception: java.lang.NullPointerException at org.apache.drill.exec.coord.local.LocalClusterCoordinator.update(LocalClusterCoordinator.java:98) at org.apache.drill.exec.server.Drillbit.close(Drillbit.java:228) at

Re: Apache Drill in 10 Minutes - Problems

2018-05-24 Thread Charles Givre
Hi Dave, Can you do the following: 1. Start Drill and execute the following query: !set verbose true 2. Then: !reconnect And send the complete output? > On May 24, 2018, at 11:05, Richardson, David > wrote: > > Hi Divya. > > I’ve tried both 1.10 and

RE: Apache Drill in 10 Minutes - Problems

2018-05-24 Thread Richardson, David
Hi Divya. I’ve tried both 1.10 and 1.11, they exhibit the same behaviour. To try to get to the root cause of the issue I removed everything from my PATH variable except for the path to the Java 8 JDK. Another colleague of mine (that is 3 of us now) has also tried the 10 minute tutorial and is

Re: How to deal with Parquet files containing no rows without Drill errors?

2018-05-24 Thread Vitalii Diravka
Hi Dave, The issue is not in joining, Drill can join empty schemaless table (for example empty JSON file or empty directory). DRILL-4517 is exactly describes the issue. You can add your test case with data to that jira ticket. Regarding workarounds, I am not aware of any. Kind regards Vitalii

How to deal with Parquet files containing no rows without Drill errors?

2018-05-24 Thread Dave Challis
We've got some processes that dump some reporting data as a bunch of parquet files, then runs queries involving joins with those tables (i.e. we have a main table which is always non-empty, then a number of link tables which join against which can be empty). The Parquet files contain schema

Re: Apache Drill in 10 Minutes - Problems

2018-05-24 Thread Divya Gehlot
hi David , Can you try with Drill 1.10 or Drill 1.11 version? Both works fine and I have tested it . Thanks, Divya On 23 May 2018 at 16:11, Richardson, David wrote: > Hi folk. > > > > My self and a colleague have both (independently) been trying the Apache >

How to Start Drill Service From Linux Non-root user

2018-05-24 Thread Surneni Tilak
Hi Team, May I know how to start drill service from a user which should not be root. What are the privileges that a non-root user should fulfill to start drill service. If I start the service as a root user then how to use the service specific to a particular user other than root. Best

RE: Apache Drill in 10 Minutes - Problems

2018-05-24 Thread Richardson, David
Hi Charles. Many thanks for your reply. The Drill service starts and only exits when I issue an !Quit command. How can I check the storage plugins? Dave. -Original Message- From: Charles Givre [mailto:cgi...@gmail.com] Sent: 23 May 2018 15:35 To: user Subject: Re: Apache Drill in 10