ExecuteSQL - Hive Error

timestationapp — Tue, 05 Apr 2016 17:35:30 GMT

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

Re: ExecuteSQL - Hive Error

mburgess — Tue, 05 Apr 2016 18:44:25 GMT

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-86B9B3BEA31B@gmail.com%3E

question Re: ExecuteSQL - Hive Error in Archives of Support Questions (Read Only)

ExecuteSQL - Hive Error

Re: ExecuteSQL - Hive Error