Check for more details and got error as : "Unexpected end of input stream"   Now, Get the hdfs LOCATION for the table by using below command on HUE or HIVE shell: show create table <table-name>;   Check for the zero byte size files and remove them from hdfs location using below command: hdfs dfs -rm -skipTrash $(hdfs dfs -ls -R <hdfs_location> | grep -v "^d" | awk '{if ($5 == 0) print $8}')   Try running again our query which ran successfully this time. ... View more

@Chris Nauroth Then there must be an issue if after 7 hours there is still no reduction in HDFS storage and it still keeps the /trash/finalized folder... ... View more