@Karan Alang From what I have understood, data cannot be 'moved' from the unencrypted zone to an encrypted zone in hdfs. In your case, the temporary data from the table(sample_07) is loaded into the staging directory, which by default is created under /apps/hive/warehouse/.hive-staging*. And this directory does not belong to the encrypted zone(/encrypt/hive) that you created. Hive user tries to "move" this data from the staging directory to the encrypted zone and thus fails. So, you can point this staging directory, to the encrypted zone, by setting the following hive property. set hive.exec.stagingdir=/encrypt/hive/tmp/; I hope it works for you. ... View more