I am getting error when trying to execute query like this insert into A select * from B; Caused by: org.apache.hadoop.ipc.RemoteException(org.apache.hadoop.hdfs.protocol.DSQuotaExceededException): The DiskSpace quota of /user/hive/warehouse/adhoc.db is exceeded: quota = 3298534883328 B = 3 TB but diskspace consumed = 3298593288972 B = 3.00 TB I have enough space on my schema(~2.3TB).The table I am trying to insert is around 800 GB. Still I am getting the above error.Any reasons ... View more

How can looping be done in hive query ... View more

I am trying to convert a recursive query to Hive. The structure of my query is as following WITH RECURSIVE REG_AGGR as ( select * from abc where rn=1 union all select * from REG_AGGR where REG_AGGR.id=abc.id ) select * from REG_AGGR; ... View more