There was a known issue with empty partitions/files/tables: https://issues.apache.org/jira/browse/HIVE-13394 Is your case such a case? ... View more

Hi Antonio Arfe Can you connect to HiveServer2 via beeline with your connection string? If you can, the error may suggest that an yarn app is not starting for some reason. You can verify that by visiting resource manager UI. ... View more

I see you are using constant value for partition column. You might be hitting this issue: https://issues.apache.org/jira/browse/HIVE-12893 ... View more

Just curious. How did you conclude that it is a permission issue: The error shows that "Unable to move sourcehdfs://sandbox.hortonworks.com:8020/apps/hive/warehouse/cards.db/categories/part-m-00000.gz to destinationhdfs://sandbox.hortonworks.com:8020/apps/hive/warehouse/cards.db/categories/part-m-00000.gz FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask" That says nothing about permission. Did you take a look at yarn app log? ... View more

you may want to set tez.session.client.timeout.secs to something like 180 other than -1 because -1 means it waits forever. Also you may want to look into the application log to investigate why that job is being stuck. ... View more

It's not the ultimate solution, but you can reduce tez.session.am.dag.submit.timeout.secs to avoid job from being hold up for a long time. ... View more

Not for ranger, but for hive, you can remove password from hive-site.xml by following the below: https://cwiki.apache.org/confluence/display/Hive/AdminManual+Configuration ... View more

Can you use ESCAPED BY '\' when you create an ORC table and load from the external table? ... View more

Ambari may be running some shell script to check if Hive service is running. Can you tell which shell scrip is running from the stack trace? Also can you run 'create table' and 'drop table' via Hive CLI? If you can, the error you are facing might be due to a bug in that shell script that Ambari is running. ... View more