Hi @Matt Burgess, I am facing the same problem and the solution you suggested is not working for me. Can u provide with some alternative solution. Configuration and error is given below. Nor the solution by Matt Clarke is working for us. ... View more

We are facing another issue regarding the hive connection pool of which screenshot is attached below and in this we are using HDF version of Nifi. Can you help with this? ... View more

Thanks for replying @Matt Burgess. We are facing error with the location path for the driver as in the screenshot.dbcpconnection-error.png Is there a free download for the HDF version of NiFi? And will this help in connection of NiFi from local system to the Ambari on Server. ... View more

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 ... View more

Hi @Matt Burgess, AS per our latest comment, I am using Apache NiFi 1.4.0 and HDP 2.6. But we are still not able to connect to Hive from NiFi. We tried adding libraries in the lib folder, the result of it is NiFi doesn't get launch. Could you please help us? Thank you. Regards, Khushboo Mehta. , Hi, I am using Hortonworks NiFi 1.4.0 and HDP of v2.6. But still facing issues while routing a file from NiFi to Hive. Thank you. Regards, Khushboo Mehta ... View more