Support Questions

Find answers, ask questions, and share your expertise

Who agreed with this topic

impala in hue, analysisexception caused by java.net.ConnectException

avatar
New Contributor

Hello,

 

started the go-grid cluster tutorial.

First the mysql-rights did not work for the SQOOP tutorial, seems the host-specification for user 'retail_dba'@'%' did not work. So I explicitly added the ip-adresses of agents. Sqoop then worked fine, data loaded into HDFS.

 

Then loaded the AVRO metadata into HIVE, this seemed to work fine.

 

When running the IMPALA tutorial, the tables show up after "invalidate metadata" command.

 

But any query or anything else returns exceptions: 

 

AnalysisException: Failed to load metadata for table: default.categories

CAUSED BY: TableLoadingException: Problem reading Avro schema at: hdfs://216......... /user/examples/sqoop_import_categories.avsc

CAUSED BY: ConnectException Call From f6129-cldramaster-01/10.115........ to 216..........:8020 failed on connection exception: java.net.ConnectException: Connection refused; For more detail see: ......... [etc etc etc]

 

 

Tried to run the IMPALA-SHELL , but this resulted with same error:

 

Caused by: com.cloudera.impala.catalog.TableLoadingException: Problem reading Avro schema at: hdfs://216.121.116.82/user/examples/sqoop_import_categories.avsc CAUSED BY: ConnectException: Call From f6129-cldramaster-01/10.105.115.2 to 216.121.116.82:8020 failed on connection exception: java.net.ConnectException: Connection refused; For more details see: http://wiki.apache.org/hadoop/ConnectionRefused CAUSED BY: ConnectException: Connection refused

 

Please help, and push me in right direction, or solution to above problem!

 

(I'm curious as to if the DNS services are working correctly)

 

 

Who agreed with this topic