Re: Best way to set schema to handle different json structures

No i haven't. I'll give that a try. Thanks. Scott Kinney | DevOps stem | m 510.282.1299 100 Rollins Road, Millbrae, California 94030 This e-mail and/or any attachments contain Stem, Inc. confidential and proprietary information and material for the sole

Re: Best way to set schema to handle different json structures

Did you try creating a view with the merged schema? Then you can try running all your queries on top of that view. - Rahul On Mon, Jul 11, 2016 at 3:23 PM, Scott Kinney wrote: > We have several different json structures we want to run queries across. I > can take a

Best way to set schema to handle different json structures

We have several different json structures we want to run queries across. I can take a sample of each and merge the json together as python dictionaries then write that out to a file and have drill read that file first to set the schema but I dont think this will be very practical as we will

Re: Drill JDBC Interpreter: Connection Refused

Have you tried to connect to a drillbit directly from Zeppelin using the jdbc url jdbc:drill:drillbit=:31010? What does your drill-override.conf file look like? > On Jul 11, 2016, at 2:33 PM, Krishnaprasad A S > wrote: > > I can see all the 4 drillbits in ui. Aso

Re: Drill JDBC Interpreter: Connection Refused

I can see all the 4 drillbits in ui. Aso I tried the query in web ui before running it in zeppelin. In web ui it works currently. Then what may be the issue.? On Jul 12, 2016 3:00 AM, "Andries Engelbrecht" wrote: What happens if you try to connect to a drillbit

Re: Drill JDBC Interpreter: Connection Refused

What happens if you try to connect to a drillbit directly? This will help to see if it is a zk connection issue. Also I assume the dill cluster is up and running, and if you go to the webUI it shows all drillbits in the cluster connected and running. > On Jul 11, 2016, at 2:27 PM,

Re: Drill JDBC Interpreter: Connection Refused

I went through the same link before configuring the interpreter, also there is no security configured. On Jul 12, 2016 2:48 AM, "Andries Engelbrecht" wrote: > Do you have security configured on the Drill cluster? If so make sure to > add the user and password info for

Re: Drill JDBC Interpreter: Connection Refused

Do you have security configured on the Drill cluster? If so make sure to add the user and password info for the Drill connection. Some good info for configuring Zeppelin with Drill here https://community.mapr.com/docs/DOC-1493 --Andries > On Jul

Re: Drill JDBC Interpreter: Connection Refused

My drill runs in clustered mode, with 4 drillbits running in 4 nodes. I started it using drillbit.sh start command. On Jul 12, 2016 2:18 AM, "Andries Engelbrecht" wrote: > Are you running Drill in embedded mode or clustered mode? > > If in embedded mode you may want to

Re: Drill JDBC Interpreter: Connection Refused

Are you running Drill in embedded mode or clustered mode? If in embedded mode you may want to try to connect directly to the drillbit jdbc:drill:drillbit=:31010 It looks like you are trying to connect to a zk with a drill cluster, and your setup may just be embedded mode. --Andries > On Jul

Drill JDBC Interpreter: Connection Refused

hi, I'm trying to create a drill interpreter in zeppelin using the existing jdbc interpreter. *drill.url = jdbc:drill:zk=:2181/drill/drillbits1drill.driver = org.apache.drill.jdbc.Driver* my drillbit runs on the same server as of zeppelin. Added the dependency

Re: CHAR data type

I raised https://issues.apache.org/jira/browse/DRILL-4772 to fix the doc issue. Thanks Santosh. - Rahul On Mon, Jul 4, 2016 at 10:11 AM, Santosh Kulkarni < santoshskulkarn...@gmail.com> wrote: > Here is the link: > > https://drill.apache.org/docs/supported-data-types/ > > > > On Mon, Jul 4,

RE: Drill Hangout Topics for 07/12/2016

Please complete review of DRILL-4704: https://github.com/apache/drill/pull/517 Thanks, Dave Oshinsky -Original Message- From: Jinfeng Ni [mailto:j...@apache.org] Sent: Monday, July 11, 2016 11:49 AM To: dev; user Subject: Drill Hangout Topics for 07/12/2016 Hey, Just a reminder that

Re: Drill Hangout Topics for 07/12/2016

Can drill-4653 be reviewed? On Mon, Jul 11, 2016 at 8:49 AM, Jinfeng Ni wrote: > Hey, > > Just a reminder that we will have Drill hangout at 10am-11am, 07/12/16 PST. > > If you have any topics to discuss on tomorrow's hangout, please reply > this thread and list the topics you

Drill Hangout Topics for 07/12/2016

Hey, Just a reminder that we will have Drill hangout at 10am-11am, 07/12/16 PST. If you have any topics to discuss on tomorrow's hangout, please reply this thread and list the topics you want to discuss. I'll also collect topics at the beginning of the hangout. Thank you, Jinfeng