Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Unable to execute HiveQL

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
Highlighted

Re: Unable to execute HiveQL

Expert Contributor

@Umer Umer

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

Highlighted

Re: Unable to execute HiveQL

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.

Don't have an account?
Coming from Hortonworks? Activate your account here