Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

ExecuteSQL - Hive Error

avatar
New Contributor

Hi,

I have a simple NIFI Flow to read results from HIVE tables,please find the image below.

ExecuteSQL throws exception when tried to issue simple HIVEQL like 'show tables' or 'select * from <tablename>.

Database Connection Pooling Service is set with HIVE credentials and its status is "Enabled".

'hive-jdbc-x.x.x-standalone.jar' is used for Database DriverJar Url in configuration of DCPS.

'hadoop-common-x.x.x.jar' is set as part of system CLASSPATH.

Can any point out whats missing to make this simple flow workable.

NIFI 0.6.0 is used.

Thanks in adv,

Regards,

Time

hivejdbc.png

1 ACCEPTED SOLUTION

avatar
Master Guru

Even with the standalone JAR, ExecuteSQL will not work with Hive due to the Hive JDBC driver not implementing some of the JDBC API calls made by ExecuteSQL. There is a Jira case to add Hive support: https://issues.apache.org/jira/browse/NIFI-981.

There are some workarounds described in the following nifi-users email (from the archive): https://mail-archives.apache.org/mod_mbox/nifi-users/201601.mbox/%3C43A01CF2-2CC6-4A01-8836-86B9B3BE...

View solution in original post

1 REPLY 1

avatar
Master Guru

Even with the standalone JAR, ExecuteSQL will not work with Hive due to the Hive JDBC driver not implementing some of the JDBC API calls made by ExecuteSQL. There is a Jira case to add Hive support: https://issues.apache.org/jira/browse/NIFI-981.

There are some workarounds described in the following nifi-users email (from the archive): https://mail-archives.apache.org/mod_mbox/nifi-users/201601.mbox/%3C43A01CF2-2CC6-4A01-8836-86B9B3BE...