hive.exec.stagingdir was already set to - /encrypt/hive/tmp/ also, scrachdir to location in encryption zone -> /encrypt/hive/tmp & provided permission 777 There is an additional variable that was to be changed -> hive.metastore.warehouse.dir - I changed this from existing value (/apps/hive/warehouse) to location in the encrypted zone -> /encrypt/hive, and this problem is fixed. ---------------------------------------------------------------------------------------------------------- INFO : Moving data to: /encrypt/hive/testtable2 from hdfs://sandbox.hortonworks.com:8020/encrypt/hive/.hive-staging_hive_2017-01-25_22-54-41_396_5265658181234256688-1/-ext-10001 INFO : Table default.testtable2 stats: [numFiles=1, numRows=5, totalSize=211, rawDataSize=206] No rows affected (47.001 seconds) ... View more

manually create user - nn, provided access to users 'nn' & 'hdfs' to to fix the issue, reference - https://community.hortonworks.com/questions/41938/creating-encryption-zone-fails-on-a-kerberized-sin.html ... View more

HADOOP_CLASSPATH=$(ls -1 /usr/hdp/current/hbase-client/lib/*.jar | tr '\n', ':') hadoop jar mr.jar hbase.labfiles.Exercise5.ProductAnalyzer -libjars $(ls -1 /usr/hdp/current/hbase-client/lib/*.jar | tr '\n', ',') This worked finally (changes highlighted) ! ... View more