Unable to instantiate org.apache.hive.hcatalog.common.HiveClientCache$CacheableHiveMetaStoreClient

[#1]

Hi All,

I'm getting this error below while writing data to a Hive table using NiFi's PutHiveStreaming processor.

NiFi version is 1.0.0 and HDP is 2.3.4.0; I saw another thread where this error occurs in a Windows environment, but our NiFi and HDP are hosted on Linux.

Thanks.

2017-03-07 10:24:09,234 ERROR [NiFi logging handler] org.apache.nifi.StdErr [Timer-Driven Process Thread-9] ERROR org.apache.nifi.processors.hive.PutHiveStreaming - PutHiveStreaming[id=015a1000-2600-129d-1dc2-b20f16685c5c] PutHiveStreaming[id=015a1000-2600-129d-1dc2-b20f16685c5c] failed to process session due to com.google.common.util.concurrent.UncheckedExecutionException: java.lang.RuntimeException: Unable to instantiate org.apache.hive.hcatalog.common.HiveClientCache$CacheableHiveMetaStoreClient

[#2]

Is there anything else in the logs after that, perhaps a "Caused by" section?

[#3]

@Matt Burgess this is what I see:

2017-03-09 14:06:53,516 ERROR [NiFi logging handler] org.apache.nifi.StdErr [Timer-Driven Process Thread-2] ERROR org.apache.nifi.processors.hive.PutHiveStreaming - PutHiveStreaming[id=015a1000-2600-129d-1dc2-b20f16685c5c] PutHiveStreaming[id=015a1000-2600-129d-1dc2-b20f16685c5c] failed to process due to com.google.common.util.concurrent.UncheckedExecutionException: java.lang.RuntimeException: Unable to instantiate org.apache.hive.hcatalog.common.HiveClientCache$CacheableHiveMetaStoreClient; rolling back session: com.google.common.util.concurrent.UncheckedExecutionException: java.lang.RuntimeException: Unable to instantiate org.apache.hive.hcatalog.common.HiveClientCache$CacheableHiveMetaStoreClient
2017-03-09 14:06:53,520 ERROR [NiFi logging handler] org.apache.nifi.StdErr com.google.common.util.concurrent.UncheckedExecutionException: java.lang.RuntimeException: Unable to instantiate org.apache.hive.hcatalog.common.HiveClientCache$CacheableHiveMetaStoreClient

[#4]

Hi @Raj B

Can you validate you're connecting to the Hive hive.metastore.uris?

Do you have Kerberos enabled?

[#5]

Hi @Ryan Cicak, I checked the metastore URI, it was not correct, so I fixed that, but now I'm getting a different error; no Kerberos on my setup; and our HDP is HA

This error is similar to what @Matt Burgess pointed to as an issue at onetime in the past - NIFI-2873, but that issue should be resolved in NiFi 1.1.0 and above; I am trying this in NiFi 1.1.2, but still same issue as pre-1.1.0

Any thoughts ??