Sorry for the delay, the best way to check your queries provided it's Hive on Tez, which is pretty much standard these days since it's much faster than Hive on MR, is through Ambari Tez view. You can see the query, start and end time, and DAG details, counters, graphical view of used mappers and reducers, indeed very detailed information. Note that if you run Pig on Tez those queries will appear in the Tez view as well. Give it a try! ... View more

What's the output of "hostname" and "hostname -f" commands on your host where the error occurs? Also, cd to /etc/security/keytabs and run: "klist -kt hive.service.keytab", I suspect the principal stored in the keytab is wrong. ... View more

Great! Please up-vote and/or accept the answer which helped you. Tnx! ... View more

Your "credential" section looks wrong, it should be something like this: <property> <name>hcat.metastore.uri</name> <value>thrift://<host>:<port></value> </property> <property> <name>hcat.metastore.principal</name> <value>hive/<host>@<realm></value> </property> On every node where Oozie client is installed you can find good examples for all Oozie actions including Hive action in "/usr/hdp/current/oozie-client/doc/examples". Check file called apps/hive/workflow.xml.security under "examples" and modify job.properties to provide your "realm" and other required parameters. Also, in case of hive2 action be sure to test using HS2 server running in binary transport mode. There were some bugs in http mode on kerberized cluster. This applies only to hive2 action, the hive action you are trying should work on both transport modes. ... View more

Hi @vamsi valiveti I noticed that you ask a lot of questions but haven't accepted many answers in the last few months. So, if you don't mind let me tell you a few words how this work: Both questions and answers can be up-voted if the others find them helpful. Also, for each question one answer can be "accepted", usually by the user who asked the question, if that answer resolved the question or greatly helped the user to resolve the issue by himself. Accepted answers help HCC to better manage answered questions, and also help the others who search and find that question later to know that the accepted answer indeed works and can be trusted. So, it will be great if you accept one answer to this question, and some other questions you recently asked. Many thanks! ... View more

The output of STRSPLIT is a tuple, so if you want to provide its schema you need to explicitly say for example "t1:tuple", like below, and after that you can refer to it as t1.a1 and t1.a1of1. With FLATTEN you get rid of the tuple. So you can choose which way to declare it. grunt> b = FOREACH a generate STRSPLIT(a1,'\\u002E') as (t1:tuple(a1:chararray,a1of1:chararray)), a2, a3; grunt> describe b; b: {t1: (a1: chararray,a1of1: chararray),a2: chararray,a3: chararray} grunt> c = foreach b generate t1.a1, a3; ... View more