Drill not running Group By query on Parquet files

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

Re: remotely using drill - is this possible ?

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

Re: Regarding Excel Files and Ms Access File.

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: > >

Re: Regarding Excel Files and Ms Access File.

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

Re: Drill Issues

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

Re: Regarding Excel Files and Ms Access File.

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: query from hbase issue

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

Re: query from hbase issue

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 >

Re: query from hbase issue

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: Drill & Caravel

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,

Re: Drill Issues

Hello Sanjiv, I work with the Drill team. I don't have your previous email (I joined the user group recently). I can take a look at your join query problem and your multiple columns having same name and same type issue. Please share/resend your earlier email, and I can take a look. Two things

Drill Issues

Hello I am facing some problem while using drill. I have also posted earlier my problem one by one, but didn't get any proper solution for that. This time again i am posting my problem. 1) Join Query Problem (for details check in April 16 with *subject*:- Regarding Join Query Problem) 2)