RE: Error Joining Two Tables In Apache Drill

2018-05-29 Thread Peter Edike
Ok... So I tried with the following query and this time, I get the following exception Query: select table2.product_code, table1.status from dfs.vtucare.tbl_transactions as table1 join dfs.vtucare.tbl_products as table2 on TO_NUMBER(table1.product_code, '##') = TO_NUMBER(table2.product_cod

Re: How to Start Drill Service From Linux Non-root user

2018-05-29 Thread Sorabh Hamirwasia
Hi Surneni, With respect to using the service specific to a particular user other than root, do you mean executing queries as a query user rather than Drill process user ? If yes then you need to enable impersonation for that on Drillbit side [1]. Later when you connect using client tool (like

Re: Apache Drill in 10 Minutes - Problems

2018-05-29 Thread Kunal Khatua
This is very odd. Out of the box, using Drill in embedded mode (i.e. zk=local)   works for me. I'm testing with Apache Drill 1.13.0 on Windows 10. Nothing fancy in my env var PATH. Everything points to JDK8. You're seeing this with a clean setup as well? (for an existing machine, you should rena

Re: Apache Drill in 10 Minutes - Problems

2018-05-29 Thread Shuporno Choudhury
Hi, Probably this might help: 1. Download *winutils.exe* and *hadoop.dll* from https://github.com/steveloughran/winutils/tree/master/hadoop-2.7.1/bin 2. Put these 2 files in the */bin* folder of Drill 3. Set *HADOOP_HOME* (in environment variable) to the the directory which contains the Drill */bi

RE: Apache Drill in 10 Minutes - Problems

2018-05-29 Thread Richardson, David
I’ve spent the whole morning going through some things. 1). The windows PATH variable only has the path to the Java JDK in it. 2). I’ve been through the class path output in the log file, and only has references to files under C:\Program Files\Apache Drill\apache-drill-1.13.0\jars 3). I tried