| --! 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) stored as orc TBLPROPERTIES('transactional'='true', 'transactional_properties'='insert_only'); |
| |
| insert into orc_table values('1', 'text1'); |
| insert into orc_table values('2', 'text2'); |
| insert into orc_table values('3', 'text3'); |
| |
| alter table orc_table compact 'MINOR' and wait; |
| analyze table orc_table compute statistics; |
| |
| describe extended orc_table; |