| --! 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_table; |
| |
| create table orc_table (a int, b string) clustered by (a) into 3 buckets stored as orc TBLPROPERTIES('transactional'='true'); |
| |
| insert into orc_table values('1', 'text1'); |
| insert into orc_table values('2', 'text2'); |
| insert into orc_table values('3', 'text3'); |
| insert into orc_table values('4', 'text4'); |
| insert into orc_table values('5', 'text5'); |
| insert into orc_table values('6', 'text6'); |
| insert into orc_table values('7', 'text7'); |
| insert into orc_table values('8', 'text8'); |
| insert into orc_table values('9', 'text9'); |
| insert into orc_table values('10', 'text10'); |
| |
| describe extended orc_table; |
| alter table orc_table compact 'MAJOR' and wait; |
| analyze table orc_table compute statistics; |
| |
| describe extended orc_table; |
| |