Support Questions

Find answers, ask questions, and share your expertise

Unable to execute HiveQL

New Contributor
I am using SelectHiveQL to query hive table and getting following error
SelectHiveQL[id=495eb94a-0160-1000-0000-000067e12ae0] Unable to execute HiveQL select query select * from DPI 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://172.25.58.130:10000/default: java.net.ConnectException: Connection refused). 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://172.25.58.130:10000/default: java.net.ConnectException: Connection refused)


44400-hiveql.jpg


					
				
			
			
				
			
			
			
			
			
			
			
		
2 REPLIES 2

Expert Contributor

@Umer Umer

can you start beeline (or any SQL tool like Squirrel) with the same connection string?

Super Guru

Can you ping that IP from the NiFi node? Is port 10000 exposed to outside users? Perhaps there is a firewall or that port is exposed as a different port to the outside world.

Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.