Re: Auto-splitting delimitted files

2015-05-20 Thread Ted Dunning
Drill loses locality information on anything but an HDFS oriented file system. That might be part of what you are observing. Having pre-split files should allow parallelism. Can you describe your experiments in more detail? Also, what specifically do you mean by CFS and GFS? Ceph and Gluster?

Re: Connection timeout 1.0.0

2015-05-20 Thread Davide Giannella
On 20/05/2015 15:37, Andries Engelbrecht wrote: > Drill in embedded mode does not use zookeeper. > > Have you tried to just run just bin/drill-embedded from the Drill Home > directory? this is what I did following the drill 10 minutes > This works fine for me on OSX, and I followed the docu

Re: character set support && hive 1.1.0(or 1.2.0) support

2015-05-20 Thread Hao Zhu
1. 0: jdbc:drill:zk=h2.poc.com:5181,h3.poc.com:5> select * from `chinese.csv`; +-+ | columns | +-+ | ["北京","1","2","3"] | +-+ 1 row selected (0.093 seconds) 0: jdbc:drill:zk=h2.poc.com:5181,h3.poc.com:5> select columns[2] fr

Auto-splitting delimitted files

2015-05-20 Thread Yousef Lasi
It appears that we will be implementing Drill before our Hadoop infrastructure is ready for production. A question that's come up related to deploying Drill on clustered Linux hosts (i.e. hosts with a shared file system but no HDFS) is whether Drill parallelization can take advantage of multipl

Join us Tues 26 May at Bay Area Apache Drill User Group event

2015-05-20 Thread Ellen Friedman
Come help celebrate Drill 1.0!! The Bay Area Apache Drill User Group will meet Tuesday May 26 hosted at Netflix. Location is Netflix 100 Winchester, Los Gatos Time: Social at 6:30pm, talks start at 7pm. Three speakers/ three talks: 1. Medha Samant, eBay on Apache Kylin + Drill 2. Jacques Nade

Re: Connection timeout 1.0.0

2015-05-20 Thread Jim Scott
You may also want to double check the /tmp directory that drill uses to keep the configuration information that zookeeper would normally hold and very you don't have bad permissions there. On Wed, May 20, 2015 at 9:58 AM, Kristine Hahn wrote: > Another possibility is the Drill process is running

Re: Connection timeout 1.0.0

2015-05-20 Thread Kristine Hahn
Another possibility is the Drill process is running from a previous installation and you need to kill it. Kristine Hahn Sr. Technical Writer 415-497-8107 @krishahn On Wed, May 20, 2015 at 7:56 AM, Kristine Hahn wrote: > Sorry you're having a problem. Did it work initially and then start to > g

Re: Connection timeout 1.0.0

2015-05-20 Thread Kristine Hahn
Sorry you're having a problem. Did it work initially and then start to give you the connection error? If so, try this: http://drill.apache.org/docs/starting-drill-on-linux-and-mac-os-x/#stopping-drill Kristine Hahn Sr. Technical Writer 415-497-8107 @krishahn On Wed, May 20, 2015 at 7:37 AM, Andr

Re: Connection timeout 1.0.0

2015-05-20 Thread Andries Engelbrecht
Drill in embedded mode does not use zookeeper. Have you tried to just run just bin/drill-embedded from the Drill Home directory? This works fine for me on OSX, and I followed the documentation outlined in http://drill.apache.org/docs/drill-in-10-minutes/ I didn’t use sudo to extract the

Kerberos enabled HDFS data source

2015-05-20 Thread Dulcan Vanhorn
I've been struggling to have any luck with getting drill to authorize properly in this case. Anyone had any luck with this? The documentation seems pretty sparse in this area. Will

Re: drill extendedJSON shell mode?

2015-05-20 Thread Kamesh
Hi Vince, We are working on enhancing extended JSON support for Drill. Please refer DRILL-2879 . On Wed, May 20, 2015 at 5:01 PM, Vince Gonzalez wrote: > Congrats on 1.0! > > Is there any way in Drill to parse extendedJSON in "shell" (as oppose

drill extendedJSON shell mode?

2015-05-20 Thread Vince Gonzalez
Congrats on 1.0! Is there any way in Drill to parse extendedJSON in "shell" (as opposed to strict) mode? According to http://docs.mongodb.org/manual/reference/mongodb-extended-json/#date $date needs to be a quoted string in "strict" mode. In shell mode, it can be a signed integer. This makes sens

character set support && hive 1.1.0(or 1.2.0) support

2015-05-20 Thread 王贤良
hello: for a hive table, the query is: select * from dim_province where province_name ='北京'; SYSTEM ERROR: org.apache.calcite.runtime.CalciteException: Failed to encode '北京' in character set 'ISO-8859-1' how to set utf-8? for hive 1.1.0( or 1.2.0), a pqrauet table ,the column

Re: Connection timeout 1.0.0

2015-05-20 Thread Davide Giannella
Thanks Andries, On 19/05/2015 23:51, Andries Engelbrecht wrote: > On OSX go to the directory where you want to install Drill and make sure the > user has full permissions on that directory. I already checked this aspect and even run drill with sudo. Nevertheless here's my permissions $ find apac