name`" } ], "child" : 2, "initialAllocation" :
> 100, "maxAllocation" : 1000000, "cost" : 100.0 }, { "pop" :
> "screen", "@id" : 0, "child" : 1, "initialAllocation" : 100,
> "maxAll
xpr" : "`id`" }, { "ref" : "`name`",
"expr" : "`name`" } ], "child" : 2, "initialAllocation" : 100,
"maxAllocation" : 100, "cost" : 100.0 }, { "pop" : "screen", "@id&
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
>
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
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
://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
-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
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
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
>
/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
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
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
.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
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
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"
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
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
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
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
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. Can
20 matches
Mail list logo