Hello,
I am trying to use a SelectHiveQL processor using the following controller
configuration:
Database Connection URL - jdbc:hive://server:port/default
Hive Configuration Resources - /path/to/hive/hive-site.xml
When my processor goes to run the simple query, I get the following error
(copyi
Dan,
That is a catch-all error returned when (in case probably) something
is misconfigured. Are there more error lines below that in the log?
The driver class and all its dependencies are present in the Hive NAR,
so there is likely an underlying error that, while being propagated
up, returns the g
BasicDataSource.java:1437)
~[commons-dbcp-1.4.jar:1.4]
... 22 common frames omitted
Sorry about the formatting. Any ideas? Is there some way I can edit the Hive
Nar file?
-Dan
-Original Message-
From: Matt Burgess [mailto:mattyb...@apache.org]
Sent: Thursday, October 0
> ~[nifi-hive-processors-1.0.0.jar:1.0.0]
> ... 19 common frames omitted
> Caused by: java.sql.SQLException: No suitable driver
> at java.sql.DriverManager.getDriver(DriverManager.java:315)
> ~[na:1.8.0_45]
> at
> org.apache.commons.dbcp.BasicDataSource.crea
>> driver of class 'org.apache.hive.jdbc.HiveDriver' for connect URL
>> 'jdbc:hive://server:port/default'
>> at
>> org.apache.commons.dbcp.BasicDataSource.createConnectionFactory(BasicDataSource.java:1452)
>> ~[commons-dbcp-1.4.jar:1.4]
&g
for me? Or a specific
place I should look? The only mention of a url in hive-site.xml that I see is:
hive.metastore.uris
thrift://server:port
-Dan
From: Matt Burgess [mailto:mattyb...@gmail.com]
Sent: Thursday, October 06, 2016 5:17 PM
To: users@nifi.apache.org
Subject: Re: SelectHiveQL Err
nn...@humana.com]
Sent: Friday, October 07, 2016 9:25 AM
To: users@nifi.apache.org
Subject: RE: SelectHiveQL Error
Hi Matt,
When I try to change to jdbc:hive2://, I get a different error set of errors.
>Error getting Hive connection
>org.apache.commons.dbcp.SQLNestedException: Cannot create
>P
related processors? Which will
make things to work with all different version of hadoop.
Thanks,
Ram
From: Dan Giannone [mailto:dgiann...@humana.com]
Sent: Friday, October 07, 2016 9:49 AM
To: users@nifi.apache.org
Subject: RE: SelectHiveQL Error
It turns out the port needed to be changed for hive
am
>
> *From:* Dan Giannone [mailto:dgiann...@humana.com]
> *Sent:* Friday, October 07, 2016 9:49 AM
>
>
> *To:* users@nifi.apache.org
> *Subject:* RE: SelectHiveQL Error
>
>
>
> It turns out the port needed to be changed for hive server2 as well. That
> seemed to fix the be
asking all those Hadoop cluster
owners to be on same version is going be challenge.
Just my opinion:-)
Thanks,
Ram
From: Andrew Grande
Sent: Friday, October 07, 2016 6:14:07 PM
To: users@nifi.apache.org
Subject: Re: SelectHiveQL Error
I remember this error, it
be challenge.
>
> Just my opinion:-)
>
> Thanks,
> Ram
>
>
> From: Andrew Grande
> Sent: Friday, October 07, 2016 6:14:07 PM
> To: users@nifi.apache.org
> Subject: Re: SelectHiveQL Error
>
> I remember this error, it basically means your Hive is too old. There
uster they might be running any different versions and asking all those
> Hadoop cluster owners to be on same version is going be challenge.
>
> Just my opinion:-)
>
> Thanks,
> Ram
>
>
>
> From: Andrew Grande
> Sent: Friday, Octobe
Burgess [mailto:mattyb...@apache.org]
Sent: Friday, October 07, 2016 10:56 PM
To: users@nifi.apache.org
Subject: Re: SelectHiveQL Error
Another approach might be to allow the Hive processors to use a
DBCPConnectionPool instead of requiring a HiveConnectionPool (which is a
subclass). That would either
13 matches
Mail list logo