RE: drill error connecting to Hbase

2017-08-06 Thread Dor Ben Dov
Hi Kunal, I am assisting Shai with the drill, I followed you instructions but once I am running maven with the profile of cloudera aka 'cdh' I am receiving this [dor@dor-fedora64 drill]$ mvn -U -DskipTests clean install -Pcdh [INFO] Scanning for projects... Downloading: https://repository.cloude

Re: unable to run drill sql in shell script

2017-08-06 Thread Divya Gehlot
yes thats the first step I tried and when I start drill using thatI get below error : *Command *: apache-drill-1.11.0/bin/sqlline.bat -u \"jdbc:drill:zk=local\"" *Error :* $ sh drilltest.sh > Running query from bash > DRILL_ARGS - " -u \"jdbc:drill:zk localhost:2181\""" > Calculating HADOOP_CLAS

Re: pass parameters to Drill query in file

2017-08-06 Thread Divya Gehlot
I am talking about the parameters in the query itself like passing the tablename to the query or the directory parameters where the parquet file should be created Thanks, Divya On 3 August 2017 at 12:30, Kunal Khatua wrote: > If you just want to run the query with the parameters like "alter >

Drill JDBC connection on windows in embedded node

2017-08-06 Thread Divya Gehlot
Hi, I followed the this link to connect to drill in JDBC mode . *Have installed drill 1.11 on windows 10 in embedded mode .* Configurations which I used : *JDBC Driver* : apache-drill-1.11.0.tar\apache-drill-1.11.0\jars\jdbc-dr

Re: delimiter in column values

2017-08-06 Thread Divya Gehlot
Hi, Please find the response inline : 1. Your delimiter is a pipe in this example, and not a comma as originally seen in the attached file. For such seminars, either we modify the storage plugin, or rename the extension to 'psv' so that drill understands what the delimiter is. Delimeter the file