[
https://issues.apache.org/jira/browse/HIVE-27672?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sourabh Badhya updated HIVE-27672:
----------------------------------
Description:
Support the following truncate operations on a partition level -
{code:java}
TRUNCATE TABLE tableName PARTITION (partCol1 = partValue1, partCol2 =
partValue2);{code}
For partition transforms other than identity, the partition column must have a
suffix to the column as follows -
1. Truncate transform on 'b' column - b_trunc
{code:java}
TRUNCATE TABLE tableName PARTITION (b_trunc = 'xy');{code}
2. Bucket transform on 'b' column - b_bucket
{code:java}
TRUNCATE TABLE tableName PARTITION (b_bucket = 10);{code}
3. Year transform on 'b' column - b_year - The value should be in YYYY format.
{code:java}
TRUNCATE TABLE tableName PARTITION (b_year = '2022');{code}
4. Month transform on 'b' column - b_month - The value should be in YYYY-MM
format
{code:java}
TRUNCATE TABLE tableName PARTITION (b_month = '2022-08'); {code}
5. Day transform on 'b' column - b_day - The value should be in YYYY-MM-DD
format
{code:java}
TRUNCATE TABLE tableName PARTITION (b_day = '2022-08-07');{code}
6. Hour transform on 'b' column - b_hour - The value should be in YYYY-MM-DD-HH
format.
{code:java}
TRUNCATE TABLE tableName PARTITION (b_day = '2022-08-07-13'); {code}
Specifying multiple conditions is also supported -
{code:java}
TRUNCATE TABLE tableName PARTITION (b_day = '2022-08-07-13', c_trunc =
'xy');{code}
For table which has undergone partition evolution, truncate is possible for
only identity transform and is only possible for newly added partition which
are outside the upper bound and lower bound of the existing files. If the newly
added partition is within the upper bound and lower bound of the existing files
then a ValidationException is thrown.
was:
Support the following truncate operations on a partition level -
{code:java}
TRUNCATE TABLE tableName PARTITION (partCol1 = partValue1, partCol2 =
partValue2);{code}
For partition transforms other than identity, the partition column must have a
suffix to the column as follows -
1. Truncate transform on 'b' column - b_trunc
{code:java}
TRUNCATE TABLE tableName PARTITION (b_trunc = 'xy');{code}
2. Bucket transform on 'b' column - b_bucket
{code:java}
TRUNCATE TABLE tableName PARTITION (b_bucket = 10);{code}
3. Year transform on 'b' column - b_year - The value should be in YYYY format.
{code:java}
TRUNCATE TABLE tableName PARTITION (b_year = '2022');{code}
4. Month transform on 'b' column - b_month - The value should be in YYYY-MM
format
{code:java}
TRUNCATE TABLE tableName PARTITION (b_month = '2022-08'); {code}
5. Month transform on 'b' column - b_day - The value should be in YYYY-MM-DD
format
{code:java}
TRUNCATE TABLE tableName PARTITION (b_day = '2022-08-07');{code}
6. Hour transform on 'b' column - b_hour - The value should be in YYYY-MM-DD-HH
format.
{code:java}
TRUNCATE TABLE tableName PARTITION (b_day = '2022-08-07-13'); {code}
Specifying multiple conditions is also supported -
{code:java}
TRUNCATE TABLE tableName PARTITION (b_day = '2022-08-07-13', c_trunc =
'xy');{code}
For table which has undergone partition evolution, truncate is possible for
only identity transform and is only possible for newly added partition which
are outside the upper bound and lower bound of the existing files. If the newly
added partition is within the upper bound and lower bound of the existing files
then a ValidationException is thrown.
> Iceberg: Truncate partition support
> -----------------------------------
>
> Key: HIVE-27672
> URL: https://issues.apache.org/jira/browse/HIVE-27672
> Project: Hive
> Issue Type: New Feature
> Reporter: Sourabh Badhya
> Assignee: Sourabh Badhya
> Priority: Major
>
> Support the following truncate operations on a partition level -
> {code:java}
> TRUNCATE TABLE tableName PARTITION (partCol1 = partValue1, partCol2 =
> partValue2);{code}
> For partition transforms other than identity, the partition column must have
> a suffix to the column as follows -
> 1. Truncate transform on 'b' column - b_trunc
> {code:java}
> TRUNCATE TABLE tableName PARTITION (b_trunc = 'xy');{code}
> 2. Bucket transform on 'b' column - b_bucket
> {code:java}
> TRUNCATE TABLE tableName PARTITION (b_bucket = 10);{code}
> 3. Year transform on 'b' column - b_year - The value should be in YYYY format.
> {code:java}
> TRUNCATE TABLE tableName PARTITION (b_year = '2022');{code}
> 4. Month transform on 'b' column - b_month - The value should be in YYYY-MM
> format
> {code:java}
> TRUNCATE TABLE tableName PARTITION (b_month = '2022-08'); {code}
> 5. Day transform on 'b' column - b_day - The value should be in YYYY-MM-DD
> format
> {code:java}
> TRUNCATE TABLE tableName PARTITION (b_day = '2022-08-07');{code}
> 6. Hour transform on 'b' column - b_hour - The value should be in
> YYYY-MM-DD-HH format.
> {code:java}
> TRUNCATE TABLE tableName PARTITION (b_day = '2022-08-07-13'); {code}
> Specifying multiple conditions is also supported -
> {code:java}
> TRUNCATE TABLE tableName PARTITION (b_day = '2022-08-07-13', c_trunc =
> 'xy');{code}
> For table which has undergone partition evolution, truncate is possible for
> only identity transform and is only possible for newly added partition which
> are outside the upper bound and lower bound of the existing files. If the
> newly added partition is within the upper bound and lower bound of the
> existing files then a ValidationException is thrown.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
