HttpClient error with SelectHiveQL NiFi Processor

Hello,

---

@NagendraKumar My Indigo Cardwrote:

We are facing the HttpClient error when we try to fetch data from the Hive using the  SelectHiveQL NiFi Processor.

Please find the error details below and help us resolve this with your expertise. 

Controller Service - HiveConnectionPool

Database Connection URL: jdbc:hive2://localhost:10000/default;principal=hive@test@xyz.com
Hive Configuration Resources: /etc/hive/conf/hive-site.xml,/etc/hadoop/conf/core-site.xml

 

NiFi Processor - SelectHiveQL 

Error Message :

SelectHiveQL[id=23er-1234-9999-4444-17] org.apache.nifi.processors.hive.SelectHiveQL$$Lambda$2132/2007351143@6ab4a383 failed to process due to java.lang.NoClassDefFoundError: org/apache/http/client/HttpClient
- Caused by: java.lang.ClassNotFoundException: org.apache.http.client.HttpClient; rolling back session: {}

SelectHiveQL[id=sge33-1234-9999-21-33] Processing halted: yielding [1 sec]: java.lang.NoClassDefFoundError: org/apache/http/client/HttpClient
- Caused by: java.lang.ClassNotFoundException: org.apache.http.client.HttpClient

 

 

---

Your NiFi isn't talking to Hive properly.

It sounds like there's a missing piece in your software that's stopping them from connecting.

Let's fix it:

1. Check the connections: Make sure everything is plugged in correctly (figuratively speaking).
2. Look for missing software: You might need to add something to NiFi to make it work.
3. Restart NiFi: Sometimes, a simple restart can fix weird computer problems.

If this doesn't work, you might need to ask for more help from NiFi experts.

Let me know if you need more help!