[NIFI] Cannot create PoolableConnectionFactory

[#1]

Hi,

I am trying to generate CSV file using SelectHiveQL follow by using PutDatabaseRecord to insert the following csv into Postgres database. I was able to do this process for almost a month now. however, one error occur while i didn't make any changes.

Scenario setting
My nifi is standalone version 1.6 and running on VM1 (centos7)
My hiveserver is running on ambari HDP version 2.6.2.0 on VM2 (centos7)

The thing i have done up until now is
1. Restart all services both nifi and hiveserver
2. verify that hive2 is working by accessing locally (see in the attatchment)
3. Both VM can communicate to each other

Ps. As i mentioned the flow is working with this setting but suddenly it stop working.

nifi-app.log

2018-06-17 13:33:56,017 ERROR [Timer-Driven Process Thread-9] o.a.nifi.processors.hive.SelectHiveQL SelectHiveQL[id=97e3ef64-0163-1000-335a-d5259eb2bd52] Unable to execute HiveQL select query select * from celltower due to org.apache.nifi.processor.exception.ProcessException: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Could not open client transport with JDBC Uri: jdbc:hive2://x.x.x.x:10000/default: java.net.ConnectException: Connection timed out (Connection timed out)). No FlowFile to route to failure: org.apache.nifi.processor.exception.ProcessException: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Could not open client transport with JDBC Uri: jdbc:hive2://x.x.x.x:10000/default: java.net.ConnectException: Connection timed out (Connection timed out))
org.apache.nifi.processor.exception.ProcessException: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Could not open client transport with JDBC Uri: jdbc:hive2://x.x.x.x:10000/default: java.net.ConnectException: Connection timed out (Connection timed out)) 

Regards,

[#2]

Can anyone at Cloudera/Horton aswer this??? Having same issues.