When all Hive services are restarted in Ambari, ThriftConnectionPool controller service in NiFi doesn't reconnect and any processors using it fail on attached exception.
After restarting the controller service is working again and Hive calls are successful.
See if we can trap the query exception if hive is down and handle it correctly