[
https://issues.apache.org/jira/browse/HIVE-27203?focusedWorklogId=854954&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-854954
]
ASF GitHub Bot logged work on HIVE-27203:
-----------------------------------------
Author: ASF GitHub Bot
Created on: 05/Apr/23 07:54
Start Date: 05/Apr/23 07:54
Worklog Time Spent: 10m
Work Description: zratkai commented on code in PR #4181:
URL: https://github.com/apache/hive/pull/4181#discussion_r1158152919
##########
ql/src/test/queries/clientpositive/compaction_query_based_insert_only_clustered.q:
##########
@@ -0,0 +1,33 @@
+--! qt:replace:/createTime:(\d+)/#Masked#/
+--! qt:replace:/location:(\S+)/#Masked#/
+--! qt:replace:/lastAccessTime:(\d+)/#Masked#/
+--! qt:replace:/ownerType:(\S*)/#Masked#/
+--! qt:replace:/owner:(\S*)/#Masked#/
+--! qt:replace:/skewedColValueLocationMaps:(\S*)/#Masked#/
+--! qt:replace:/transient_lastDdlTime=(\d+)/#Masked#/
+--! qt:replace:/totalSize=(\d+)/#Masked#/
+--! qt:replace:/rawDataSize=(\d+)/#Masked#/
+--! qt:replace:/writeId:(\d+)/#Masked#/
+--! qt:replace:/bucketing_version=(\d+)/#Masked#/
+--! qt:replace:/id:(\d+)/#Masked#/
+
+drop table orc_bucketed;
+
+create table orc_bucketed (a int, b string) clustered by (a) into 3 buckets
stored as orc TBLPROPERTIES('transactional'='true',
'transactional_properties'='insert_only');
+
+insert into orc_bucketed values('1', 'text1');
+insert into orc_bucketed values('2', 'text2');
+insert into orc_bucketed values('3', 'text3');
+insert into orc_bucketed values('4', 'text4');
+insert into orc_bucketed values('5', 'text5');
+insert into orc_bucketed values('6', 'text6');
+insert into orc_bucketed values('7', 'text7');
+insert into orc_bucketed values('8', 'text8');
+insert into orc_bucketed values('9', 'text9');
+insert into orc_bucketed values('10', 'text10');
+
+describe extended orc_bucketed;
+alter table orc_bucketed compact 'MAJOR' and wait;
+analyze table orc_bucketed compute statistics;
Review Comment:
I do not remember exactly why it was necessary to do it this way. With this
steps you can force the analyze to happen exactly when it needed. If I remember
correctly the autogather is async, and it caused issues, that sometimes didn't
happen until the test needed at the last describe table, so it failed.
Issue Time Tracking
-------------------
Worklog Id: (was: 854954)
Time Spent: 1h 50m (was: 1h 40m)
> Add compaction pending Qtest for Insert-only, Partitioned, Clustered ACID,
> and combination Tables
> --------------------------------------------------------------------------------------------------
>
> Key: HIVE-27203
> URL: https://issues.apache.org/jira/browse/HIVE-27203
> Project: Hive
> Issue Type: Test
> Affects Versions: 4.0.0
> Reporter: Akshat Mathur
> Assignee: Akshat Mathur
> Priority: Major
> Labels: pull-request-available
> Time Spent: 1h 50m
> Remaining Estimate: 0h
>
> Improve Qtest Coverage for Compaction use cases for ACID Tables:
> # Partitioned Tables( Major & Minor )
> # Insert-Only Clustered( Major & Minor )
> # Insert-Only Partitioned( Major & Minor )
> # Insert-Only Clustered and Partitioned( Major & Minor )
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
