I was able to resolve the above issue by selecting hcat under credentials tab. But after that when I tried executing the workflow it gets stuck with repeated log as : HeartBeat HeartBeat...   Not sure whether it tries also now to connect to hive to fire a query also or not.   My shell script contains a single line as : echo "total:`hive -e 'select count(*) from tblname;'`" Kindly guide. ... View more

I tried to run directly from Hue editor, but still the same issue:   Caused by: MetaException(message:Could not connect to meta store using any of the URIs provided. Most recent failure: org.apache.thrift.transport.TTransportException: GSS initiate failed This time I didn't added any credentials and it automatically got added as below: credentials {u'hcat': {'xml_name': u'hcat', 'properties': [('hcat.metastore.uri', u'thrift://*********'), ('hcat.metastore.principal', u'hive/********')]}, u'hive2': {'xml_name': u'hive2', 'properties': [('hive2.jdbc.url', 'jdbc:hive2://*******'), ('hive2.server.principal', 'hive/*******')]}, u'hbase': {'xml_name': u'hbase', 'properties': []}}     ... View more

When I try to execute a hive query from a shell script I get a below error: Exception in thread "main" java.lang.RuntimeException: java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient I'm also passing credentails in my script as below: <credentials> <credential name="hive2" type="hive2"> <property> <name>hive2.jdbc.url</name> <value>${hiveUrl}</value> </property> <property> <name>hive2.server.principal</name> <value>${hivePrincipal}</value> </property> </credential> </credentials> Not sure what needs to be passed more to make a connection. Anyhelp in this would be great.thanks! ... View more