init.d scripts

2015-10-25 Thread William Witt
Good morning, I’m trying to set drill up on a Hortonwrorks cluster. It works like a champ when I start it manually, so I want it to run on boot. Are there init.d scripts around that I can use, or some other start on boot install instructions? Will

Re: init.d scripts

2015-10-25 Thread William Witt
before is here: > > https://gist.github.com/jacques-n/8b963656955e961c4510 > > > -- > Jacques Nadeau > CTO and Co-Founder, Dremio > > On Sun, Oct 25, 2015 at 9:14 AM, William Witt > wrote: > >> Good morning, >> >> I’m trying to set drill up

JDBC connection stuck in an infinite loop

2015-10-29 Thread William Witt
Im connecting to a drillbit via JDBC connection inside of a web app. If the connection string is incorrect or if system can't connect for some reason it gets stuck in an infinite loop trying to connect. Is this a bug am I doing something wrong? Has anyone seen this before? Will Sent from my

Re: JDBC connection stuck in an infinite loop

2015-11-01 Thread William Witt
you use a direct > connection string instead of a zookeeper based connection? > On Oct 29, 2015 9:39 AM, "William Witt" wrote: > >> Im connecting to a drillbit via JDBC connection inside of a web app. If >> the connection string is incorrect or if system can't c

Overriding delimiter at runtime

2015-11-01 Thread William Witt
Is there a way to override the delimiter or Input format at runtime? Scenario: -User1 has an extension-less file, that it is pipe delimited -User2 also has an extension-less, but it is tab delimited Use cases: -Both users want to execute queries on these files concurrently -A single user wants to

Kerberos on Hive

2015-12-12 Thread William Witt
I’m trying to use Drill on a kerberized CDH cluster. I attempted to adapt the mapr directions [http://doc.mapr.com/display/MapR/Configuring+Drill+to+Use+Kerberos+with+Hive+Metastore] to my use case, but keeping getting a stack trace from drill when enabling sasl: 17:24:27.602 [qtp1083696596-

Re: Kerberos on Hive

2015-12-15 Thread William Witt
Sent from my iPhone > On Dec 12, 2015, at 4:41 PM, William Witt wrote: > > I’m trying to use Drill on a kerberized CDH cluster. I attempted to adapt > the mapr directions > [http://doc.mapr.com/display/MapR/Configuring+Drill+to+Use+Kerberos+with+Hive+Metastore] > t

Re: Kerberos on Hive

2015-12-21 Thread William Witt
ode etc.) in Drill's > classpath. I haven't tested this configuration, but it is worth a try. > > Thanks > Venki > > On Tue, Dec 15, 2015 at 7:31 PM, William Witt > wrote: > >> By the lack of response, I take it that Drill on a kerberized cluster has &g

Re: Using Drill with Kerberized HDFS

2016-01-15 Thread William Witt
I’ve been meaning to post a how to. Attached is a PDF, I’m not sure if i’ll make ti to the list however. William Witt CTO BigDataRevealed (formerly HadoopRevelaed) > On Jan 15, 2016, at 5:03 PM, Nathan Griffith wrote: > > Hello all, > > This question seems to come up fairly

Re: Using Drill with Kerberized HDFS

2016-01-15 Thread William Witt
l": “hive/@LOCAL.COM”, "hive.metastore.execute.setugi" : "true" } > On Jan 15, 2016, at 10:09 PM, Ted Dunning wrote: > > Pushing it to the list in imperfect form is a great way to encourage > participation. > > Do you have a non-pdf version? &

Re: Can Drill connect to an MS Access Database file using ODBC?

2016-01-19 Thread William Witt
I think the answer is no. It's theoretically possible to build a storage plugin to handle it using a library like jackcess, but I don't see it as a common need. Can you flesh out your use case a little? Will Sent from my iPhone > On Jan 19, 2016, at 8:36 PM, Peder Jakobsen | gmail > wrote: >

Re: Can Drill connect to an MS Access Database file using ODBC?

2016-01-19 Thread William Witt
It might be simpler to either “brew install mdbtools” or “apt-get install mdbtools” and use mdb-export [mdb file] [table name] > [table_name].csv Will > On Jan 19, 2016, at 9:19 PM, P Jakobsen wrote: > > Hi William, > > >> On Jan 19, 2016, at 9:48 PM, William Witt w

Re: Drill and Kerberos

2016-02-08 Thread William Witt
We have Drill running on a kerberized Cloudera cluster running. Configuration was a bit of a bear to work through, but it’s possible. The instructions we produced to were sent out to the community last month, but I can snd them to you direct if you’d like. William Wit CTO BigDataRevealed Inc.

Re: mass user realtime, high concurrency , hardware resource

2016-02-17 Thread William Witt
Either responses aren't getting back to this guy or its some form of SPAM. Perhaps they're expecting someone to respond back directly to their email address. Sent from my iPhone > On Feb 17, 2016, at 3:14 AM, cosdy wrote: > > hi, >i want to build a app which need for support sevaral hu