Re: hive connection as generic jdbc

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

Re: hive connection as generic jdbc

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

Re: hive connection as generic jdbc

t; > > > > Hi Asim, > > > > > > I was able to connect to Hive 1.2 using jdbc storage plugin with two > > below > > > jars. You may give it a try with these jars. > > > > > > http://central.maven.org/maven2/org/apache/hive/hive- > > > service/1.1.1/hive-servi

Re: hive connection as generic jdbc

om: Asim Kanungo <asim...@gmail.com> > 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. > &g

Re: hive connection as generic jdbc

for this. Thanks, Arjun From: Asim Kanungo <asim...@gmail.com> 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

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 conn

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 repo for hive

Re: hive connection as generic jdbc

From: Asim Kanungo <asim...@gmail.com> 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 SLF4J bindings.

Re: hive connection as generic jdbc

/central.maven.org/maven2/org/apache/hive/hive- > jdbc/1.1.1/hive-jdbc-1.1.1-standalone.jar > > > Thanks, > > Arjun > > > From: Asim Kanungo <asim...@gmail.com> > Sent: Tuesday, March 13, 2018 11:47 AM > To: user@drill.apa

Re: hive connection as generic jdbc

/hive-jdbc-1.1.1-standalone.jar Thanks, Arjun From: Asim Kanungo <asim...@gmail.com> 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 g

Re: hive connection as generic jdbc

nungo <asim...@gmail.com> > 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 > &q

Re: hive connection as generic jdbc

Kanungo <asim...@gmail.com> 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

Re: hive connection as generic jdbc

OME/jars/3rdparty/jline-2.10.jar" > sqlline.SqlLine -d org.apache.hive.jdbc.HiveDriver -u "" -n > -p -e "show tables;" > > > Thanks, > > > Arjun > > > > ________ > From: Asim Kanungo <asim...@gmail.com>

Re: hive connection as generic jdbc

mail.com> Sent: Tuesday, 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&qu

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=http=pathdetail=mytruststore.jks=**", "username": "XXX", "password": "**", "enabled": true } Please note that

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

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

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

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

hive connection as generic jdbc

Hi Team, Can I connect to hive database as a generic jdbc protocol like I am doing for other RDBMS.Or DRILL can only connect to hive residing in the same cluster where Hadoop is installed. I am talking about the cases where DRILL is installed in one cluster and my Hadoop cluster is different.