RE: Connecting Drill to Azure Data Lake

2016-08-01 Thread Kevin Verhoeven
"extensions": [ "tsv" ], "delimiter": "\t" }, "txt": { "type": "text", "extensions": [ "txt" ], "delimiter": "," }, &quo

Connecting Drill to Azure Data Lake

2016-07-29 Thread Kevin Verhoeven
Hi Drill Community, Has anyone attempted to connect Drill to the Azure Data Lake? Microsoft has implemented a WebHDFS API over Azure Data Lake, so Drill should be able to connect. I'm guessing this will be similar to s3. My initial attempts have failed, does anyone have any ideas or experience

RE: Drill query does not return all results from HBase

2016-03-21 Thread Kevin Verhoeven
] at java.lang.Thread.run(Thread.java:745) [na:1.7.0_71] Thanks, Kevin -Original Message- From: Kevin Verhoeven [mailto:kevin.verhoe...@ds-iq.com] Sent: Monday, March 21, 2016 11:33 AM To: adityakish...@gmail.com Cc: Kumiko Yada <kumiko.y...@ds-iq.com>; user@drill.apache.org; d...@drill.apac

RE: Drill query does not return all results from HBase

2016-03-21 Thread Kevin Verhoeven
: Monday, March 21, 2016 10:26 AM To: Kevin Verhoeven <kevin.verhoe...@ds-iq.com> Cc: Kumiko Yada <kumiko.y...@ds-iq.com>; user@drill.apache.org; d...@drill.apache.org; altekruseja...@gmail.com; Ki Kang <ki.k...@ds-iq.com> Subject: Re: Drill query does not return all results f

RE: Drill query does not return all results from HBase

2016-03-21 Thread Kevin Verhoeven
@ds-iq.com> Cc: user@drill.apache.org; d...@drill.apache.org; altekruseja...@gmail.com; Ki Kang <ki.k...@ds-iq.com>; Kevin Verhoeven <kevin.verhoe...@ds-iq.com> Subject: Re: Drill query does not return all results from HBase Finally managed to reproduce it with CDH distribution (So

RE: Drill Storage Plugin for HBase 1.0

2016-03-19 Thread Kevin Verhoeven
:18 AM, Kevin Verhoeven <kevin.verhoe...@ds-iq.com > wrote: > Currently the HBase Storage plugin supports HBase 0.98. Is there a > plan to update the storage plugin to support HBase 1.0? > > Thanks! > > Kevin >

RE: Drill Storage Plugin for HBase 1.0

2016-03-19 Thread Kevin Verhoeven
, threads: 1 } }, use.ip : false }, debug.error_on_leak: true, store.hbase.HBaseRecordReader: true } Thanks! Kevin From: Aditya [mailto:adityakish...@gmail.com] Sent: Wednesday, March 16, 2016 11:11 AM To: Kevin Verhoeven <kevin.verhoe...@ds-iq.com> Cc: use

RE: Drill Storage Plugin for HBase 1.0

2016-03-19 Thread Kevin Verhoeven
Thanks Aditya, There were no warnings/errors in the log, and the result of the count was 6724 (3362 + 3362). Kevin From: Aditya [mailto:adityakish...@gmail.com] Sent: Wednesday, March 16, 2016 4:48 PM To: Kevin Verhoeven <kevin.verhoe...@ds-iq.com> Cc: user@drill.apache.org Subject: Re:

Drill Storage Plugin for HBase 1.0

2016-03-15 Thread Kevin Verhoeven
Currently the HBase Storage plugin supports HBase 0.98. Is there a plan to update the storage plugin to support HBase 1.0? Thanks! Kevin

Drill query does not return all results from HBase

2015-12-21 Thread Kevin Verhoeven
We have a problem where a Drill query against HBase does not return all results. The following query should return over 100,000 rows, but we only get about 1,030 back. SELECT row_key FROM `hbase`.`customer_staged` WHERE customer_number = 800 If we scan directly using the hbase shell we see

Drill Installation on HBase RegionServers

2015-12-01 Thread Kevin Verhoeven
On a cluster, do I have to install a drillbit on every RegionServer or can I install a drillbit on a subset of the RegionServers? Thanks, Kevin

RE: Does Drill support High Available (HA) Hadoop?

2015-11-13 Thread Kevin Verhoeven
Sebastian, I was able to work around that bug by copying the hdfs-site-xml file into Drill's conf folder. Then restart the drillbit. The reason this works is inside the hdfs-site.xml file are definitions of the HDFS HA cluster. Hopefully Drill fixes this bug soon. Kevin -Original

Web Console Login page

2015-11-06 Thread Kevin Verhoeven
I am using Drill 1.2 on Ubunut 12.04. Following the configuration documentation I have setup authentication using pam. However, after successfully restarting the drillbit I am not presented with a login screen on the web console. My changes: I configured user authentication using pam. This

RE: Web Console Login page

2015-11-06 Thread Kevin Verhoeven
7-8107 @krishahn skype:krishahn On Fri, Nov 6, 2015 at 10:54 AM, Kevin Verhoeven <kevin.verhoe...@ds-iq.com> wrote: > I am using Drill 1.2 on Ubunut 12.04. Following the configuration > documentation I have setup authentication using pam. However, after > successfully restart