Re: hive connection as generic jdbc

name`" } ], "child" : 2, "initialAllocation" : > 100, "maxAllocation" : 1000000, "cost" : 100.0 }, { "pop" : > "screen", "@id" : 0, "child" : 1, "initialAllocation" : 100, > "maxAll

Re: hive connection as generic jdbc

xpr" : "`id`" }, { "ref" : "`name`", "expr" : "`name`" } ], "child" : 2, "initialAllocation" : 100, "maxAllocation" : 1000000, "cost" : 100.0 }, { "pop" : "screen", "@id&

Re: hive connection as generic jdbc

cessfully. I would let Drill experts to comment on any possible > > solution for this. > > > > Thanks, > > > > Arjun > > > > > > > > ____ > > From: Asim Kanungo > > Sent: Friday, March 16, 2018 4:51 AM >

Re: hive connection as generic jdbc

m Kanungo > Sent: Friday, March 16, 2018 4:51 AM > To: user@drill.apache.org > Subject: Re: hive connection as generic jdbc > > " as Thanks Arjun > I am able to use this and got a success message for adding the storage > plugin. > > But while querying, I am getting a

Re: hive connection as generic jdbc

ssible solution for this. Thanks, Arjun From: Asim Kanungo Sent: Friday, March 16, 2018 4:51 AM To: user@drill.apache.org Subject: Re: hive connection as generic jdbc " as Thanks Arjun I am able to use this and got a success message for adding the

Re: hive connection as generic jdbc

://central.maven.org/maven2/org/apache/hive/hive- > jdbc/1.1.1/hive-jdbc-1.1.1.jar > > Thanks, > > Arjun > > > > > From: Arjun kr > Sent: Wednesday, March 14, 2018 1:05 PM > To: user@drill.apache.org > Subject: Re: hive con

Re: hive connection as generic jdbc

-1.1.1.jar Thanks, Arjun From: Arjun kr Sent: Wednesday, March 14, 2018 1:05 PM To: user@drill.apache.org Subject: Re: hive connection as generic jdbc Looks like hive-jdbc-1.1.1-standalone.jar has 'slf4j-log4j' bundled.You may try cloning below rep

Re: hive connection as generic jdbc

2.2.4.2.jar' Thanks, Arjun From: Asim Kanungo Sent: Wednesday, March 14, 2018 9:06 AM To: user@drill.apache.org Subject: Re: hive connection as generic jdbc Hi Arjun, With that I am getting error while starting the drill bit. SLF4J: Class path contains multiple SLF4

Re: hive connection as generic jdbc

apache/hive/hive- > jdbc/1.1.1/hive-jdbc-1.1.1-standalone.jar > > > Thanks, > > Arjun > > > From: Asim Kanungo > Sent: Tuesday, March 13, 2018 11:47 AM > To: user@drill.apache.org > Subject: Re: hive connection as generic jdbc >

Re: hive connection as generic jdbc

/hive-jdbc-1.1.1-standalone.jar Thanks, Arjun From: Asim Kanungo Sent: Tuesday, March 13, 2018 11:47 AM To: user@drill.apache.org Subject: Re: hive connection as generic jdbc Hi Arjun, I have tried it, but no luck. I am still getting the INSTANCE error (Caused

Re: hive connection as generic jdbc

y, March 13, 2018 10:48 AM > To: user@drill.apache.org > Subject: Re: hive connection as generic jdbc > > Hi Arjun, > > I have tried with the hive jdbc uber jar and able to make a successful > connection. > java -cp > "hive-jdbc-uber-2.6.3.0-235.jar:sqlline-1.1.9-drill-r7.j

Re: hive connection as generic jdbc

Kanungo Sent: Tuesday, March 13, 2018 10:48 AM To: user@drill.apache.org Subject: Re: hive connection as generic jdbc Hi Arjun, I have tried with the hive jdbc uber jar and able to make a successful connection. java -cp "hive-jdbc-uber-2.6.3.0-235.jar:sqlline-1.1.9-drill-r7.jar:jline-2.1

Re: hive connection as generic jdbc

.jar" > sqlline.SqlLine -d org.apache.hive.jdbc.HiveDriver -u "" -n > -p -e "show tables;" > > > Thanks, > > > Arjun > > > > ____________ > From: Asim Kanungo > Sent: Tuesday, March 13, 2018 8:37 AM > T

Re: hive connection as generic jdbc

day, March 13, 2018 8:37 AM To: user@drill.apache.org Subject: Re: hive connection as generic jdbc Thanks Kunal... Here are the details. { "type": "jdbc", "driver": "org.apache.hive.jdbc.HiveDriver", "url": "jdbc:hive2://knox address:port/d

Re: hive connection as generic jdbc

Thanks Kunal... Here are the details. { "type": "jdbc", "driver": "org.apache.hive.jdbc.HiveDriver", "url": "jdbc:hive2://knox address:port/default?ssl=true&transportMode=http&httpPath=pathdetail&sslTrustStore=mytruststore.jks&trustStorePassword=**", "username": "XXX", "password"

Re: hive connection as generic jdbc

I'm not sure how this is resolved since Hive is directly accessed by Drill using the Hive storage plugin, instead of via the JDBC storage plugin. Perhaps you can share the parameters of the JDBC storage plugin you used, so that folks more familiar with the JDBC storage plugin can help. I'll see wha

Re: hive connection as generic jdbc

Hi Kunal, I have tried the steps and getting the below error:- 2018-03-08 22:39:59,234 [qtp433826182-75] ERROR o.a.d.e.server.rest.StorageResources - Unable to create/ update plugin: test org.apache.drill.common.exceptions.ExecutionSetupException: Failure setting up new storage plugin configurati

Re: hive connection as generic jdbc

Thanks Kunal for clarifying... I am still learning the things, so as per my first project I am trying to create a successful connection. I will work on the optimization in the second phase. Thanks for your valuable tips, let me try to create the hive connection through JDBC then. I suppose I need t

Re: hive connection as generic jdbc

You should be able to connect to a Hive cluster via JDBC. However, the benefit of using Drill co-located on the same cluster is that Drill can directly access the data based on locality information from Hive and process across the  distributed FS cluster. With JDBC, any filters you have, will (m