- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Float this Question for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
DiskSpace quota exception on hive
- Labels:
-
Apache Hive
Created ‎10-20-2017 09:47 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Created ‎10-20-2017 10:30 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
