Thanks - got that !   For all who have similar issue - pls do following   DROP TABLE IF EXISTS categories; DROP TABLE IF EXISTS customers; DROP TABLE IF EXISTS departments; DROP TABLE IF EXISTS orders; DROP TABLE IF EXISTS order_items; DROP TABLE IF EXISTS products;   ......then exit your hive shell, and do 'hostname -i'   replace the IP address to the one you see from above command.   Should be fine. ... View more

I too have the same issue when running query in Hive shell or HUE Impala editor, please advise   Your query has the following error(s): AnalysisException: Failed to load metadata for table: default.order_items CAUSED BY: TableLoadingException: Problem reading Avro schema at: hdfs://216.121.78.162/user/examples/sqoop_import_order_items.avsc CAUSED BY: ConnectException: Call From i8936-cldramaster-01/10.102.231.2 to 216.121.78.162: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   HDFS is working OK.   [root@i8936-cldramaster-01 ~]# hadoop fs -ls /user/examples/sqoop_import_order_items.avsc -rw-r--r--   2 root supergroup        980 2015-03-25 07:08 /user/examples/sqoop_import_order_items.avsc ... View more