This may be due to HDFS default replication set to 3. So the total space requirement would be 800GB * 3 = 2.4TB which exceeds 2.3TB that's available. ... View more

Not sure about the usecase, Can refer this link to loop Hive query using shell script. ... View more

See the following links for more information: https://community.hortonworks.com/questions/120941/recursive-query-or-better-way-to-build-hierarchica.html https://blog.pythian.com/recursion-in-hive/ https://stackoverflow.com/questions/38765543/recursive-query-in-hive ... View more