Support Questions
Find answers, ask questions, and share your expertise

Connecting HIve with Nifi

Connecting HIve with Nifi

Explorer

Hi All,

We set up a hadoop cluster with 3 linux servers[say A,B,C]. In server A we have configured Apache Ambari and nifi in server B. We are planning to move data from mysql database to hive database. As a part of the flow, we are using Processors like ExecuteSQL ----> ConvertAvroToJSON ----> PutFile ---->ReplaceText ----->ConvertJSONToSQL ---->PutHiveQL [refer the attached file].

Currently we are running Ambari and Hive in Server A and trying to connect to it from Server B [nifi]. We are facing issue with connectivity with Hive.

Can someone please help us to resolve this?

Thanks in advance.

2 REPLIES 2

Re: Connecting HIve with Nifi

Mentor

Please provide the error you're getting

Re: Connecting HIve with Nifi

Explorer

Hi @Aditya Hegde,

Were u able to create a connection with Ambari on a different server? As we too are facing the same issue with connection form nifi to hive in Ambari. As the error states it cannot load the Database Driver, where as we have provided a jdbc driver and its path to fetch. We later on tried to create a connection with sql database and still facing the same issue as for hive. PFA of screenshot of the error while connecting to sql server database .

error-to-load-driver-class.png