Re: Using Drill with EMR

Hello TJ, welcome to the Drill community! To be honest we only recently enabled drill to run distributed queries in EC2 and other cloud providers, by removing a dependency that required UDP multicast, a feature unsupported between nodes on EC2 and Google CE. As such, we have not done a lot of test

Re: We're now a TLP

Andrew This is an awesome article and a great validation for the value proposition Drill is trying offer. Thank you. -Neeraja On Wed, Dec 3, 2014 at 8:16 AM, Andrew Brust < andrew.br...@bluebadgeinsights.com> wrote: > Here's the piece: > > http://research.gigaom.com/2014/12/apache-drill-drills-u

Re: Client-only installation

Thanks for the info. However, this looks like a bloated full installation for all the drill component. Is there a thinner way to do it with the sqlline jar and the drill fat jar file? Theoretically it should work. (the drill odbc jar worked with SQuirrel SQL) On Wed, Dec 3, 2014 at 3:06 PM, Sudh

Re: JDBC with SQuirreL, anybody made it work?

Thanks for the detailed info. Sent from my iPhone > On Dec 4, 2014, at 7:44 AM, Carol McDonald wrote: > > here is an example using casts and a view, cast , regexp_replace > > use dfsl; > create view `v.clicks_csv` as select cast(columns[0] as int) as id, > cast(columns[1] as int) as session,

Re: JDBC with SQuirreL, anybody made it work?

here is an example using casts and a view, cast , regexp_replace use dfsl; create view `v.clicks_csv` as select cast(columns[0] as int) as id, cast(columns[1] as int) as session, regexp_replace(cast(columns[2] as varchar(10)),'"','') as category, regexp_replace(cast(columns[3] as character(2)),'"'

Re: JDBC with SQuirreL, anybody made it work?

why not 3 strings ? SELECT columns[0] as id1, columns[1] as id2, columns[2] as id3, FROM dfs.data.`test.csv`; On Wed, Dec 3, 2014 at 1:23 PM, Li HM wrote: > using columns[0] worked. > > Is there a way to case the whole row "*" into a single string? > > On Wed, Dec 3, 2014 at 2:11 AM, Steven Phi

Re: Using Drill with EMR

Wow and here comes a node.js talent! Sent from my iPhone > On Dec 4, 2014, at 10:26 PM, TJ Holowaychuk wrote: > > Hello, your documentation recommends contacting via an EMR configuration – > so here I am :). Excited to give it a test drive! > > -- > TJ Holowaychuk > Engineer > Segment

Using Drill with EMR

Hello, your documentation recommends contacting via an EMR configuration – so here I am :). Excited to give it a test drive! -- TJ Holowaychuk Engineer Segment

Re: Client-only installation

Could you please describe the steps on how you guys made it work? Thanks! On Tue, Dec 2, 2014 at 8:18 PM, Li HM wrote: > Thanks Sudhakar. > > I don't see any attachment though. Could you please send the file to me? > > On Tue, Dec 2, 2014 at 7:18 PM, Sudhakar Thota wrote: >> Li, >> >> It worked

Re: JDBC with SQuirreL, anybody made it work?

using columns[0] worked. Is there a way to case the whole row "*" into a single string? On Wed, Dec 3, 2014 at 2:11 AM, Steven Phillips wrote: > I haven't really tried squirrel, but it would seem that it doesn't handle > repeated types? > > Instead of select(*), could you try > > select columns[

Re: Client-only installation

Sorry Li, not sure why you cannot see the attachment. Here is the content in the attachement. 1. Downloaded the tar file from http://apache.claz.org/incubator/drill/drill-0.6.0-incubating/apache-drill-0.6.0-incubating.tar.gz as per instructions on https://cwiki.apache.org/confluence/display/DRILL

RE: We're now a TLP

Here's the piece: http://research.gigaom.com/2014/12/apache-drill-drills-up-to-top-level-project/ -Original Message- From: CHALLA [mailto:bizcha...@gmail.com] Sent: Wednesday, December 3, 2014 6:01 AM To: user@drill.apache.org Cc: d...@drill.apache.org; drill-u...@incubator.apache.org;