Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

DiskSpace quota exception on hive

DiskSpace quota exception on hive

New Contributor

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

1 REPLY 1

Re: DiskSpace quota exception on hive

Master Collaborator

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.