Re: Drill & Caravel

2016-05-18 Thread Boris Chmiel
Super interesting Le Mardi 17 mai 2016 14h56, John Omernik a écrit : So in addition to the docker env to play with drill and caravel at https://github.com/JohnOmernik/caraveldrill We also have a Dialect going at: https://github.com/JohnOmernik/sqlalchemy-drill Now, this dialect doesn

Re: query from hbase issue

2016-05-18 Thread Khurram Faraaz
So I tried to create the table using HBase API (with no data inserted into table) and I got the query plan for drill 1.7.0 Drill 1.7.0-SNAPSHOT commit ID : 09b26277 0: jdbc:drill:schema=dfs.tmp> describe browser_action2; +--++--+ | COLUMN_NAME | DATA_TYPE |

Re: query from hbase issue

2016-05-18 Thread qiang li
Hi Khurram, Thanks very much to reproduce it, so what's the conclusion? Any idea how to sovle it? 2016-05-18 17:02 GMT+08:00 Khurram Faraaz : > So I tried to create the table using HBase API (with no data inserted into > table) and I got the query plan for drill 1.7.0 > Drill 1.7.0-SNAPSHOT com

Re: query from hbase issue

2016-05-18 Thread Khurram Faraaz
Hello Qiang, Someone from our Drill team (in San Jose) will get back to you soon. I work from the India lab and I am in a different time zone as compared to San Jose office, some one from MapR San Jose will get back to you as soon as possible. Thanks, Khurram On Wed, May 18, 2016 at 3:09 PM, qia

Re: query from hbase issue

2016-05-18 Thread qiang li
Ok, Thanks very much. 2016-05-18 17:44 GMT+08:00 Khurram Faraaz : > Hello Qiang, > > Someone from our Drill team (in San Jose) will get back to you soon. I > work from the India lab and I am in a different time zone as compared to > San Jose office, some one from MapR San Jose will get back to yo

Re: WHERE clause comparison to maps or arrays not possible?

2016-05-18 Thread Andries Engelbrecht
Joe, Not sure I fully get the picture on your data, but you may want to see if pointing at the first element in an array and looking for nulls works in your case. I have used that in the past to eliminate records or elements from the result set in a subquery. Perhaps try something like this S

Re: Regarding Excel Files and Ms Access File.

2016-05-18 Thread Zelaine Fong
Sanjiv, As noted in the reply to your first email on this question, Drill does not currently have such a plugin. We're in the process of re-evaluating the release cadence of Drill, and will no longer be doing releases on a monthly cadence. At this time, we do not have a firm date for the next re

Re: Drill Issues

2016-05-18 Thread Chunhui Shi
Hi Sanjiv, 3) As to authentication in windows, I think you already got a proper reply, that is you have to implement your own authenticator. Depends on your windows environment, you can decide either call windows API to check user+password, or connect Active Directory either through LDAP or Kerbe

Re: Regarding Excel Files and Ms Access File.

2016-05-18 Thread Ted Dunning
Sanjiv, Would you like to help build such a plugin? One place to start would be the Apache POI project which would help you read Microsoft documents. >From there, you need to decide how you want to handle issues like multiple sheets, non-uniformly gridded data and such. At that point, it wouldn

Re: Regarding Excel Files and Ms Access File.

2016-05-18 Thread Antonio Romero (carnorom)
http://ucanaccess.sourceforge.net/site.html This would let you connect to Microsoft access via generic JDBC. Solves one big piece of your problem. I think there is something similar for Excel. Sent from my iPhone > On May 17, 2016, at 10:57 PM, "Sanjiv Kumar" wrote: > > This is my second mail

Re: remotely using drill - is this possible ?

2016-05-18 Thread M Gates
Looking to connect to a Hadoop edge node with drill installed on my laptop connecting through Knox to hive using jdbc. Anyone know if this is possible ? thanks M > On Apr 25, 2016, at 11:21 AM, M Gates wrote: > > > Wondering if there are any examples of connecting drill to hive through knox

Drill not running Group By query on Parquet files

2016-05-18 Thread bipin reddy
Hello, ​I have installed drill 1.6 and trying to run queries against parquet files. Issue no.1​: Jobs are failing with error, RESOURCE ERROR: Drill Remote Exception which is a memory error. I have increased the memory and still facing the same issue. The parameters that I changed are planner.mem