| ==== |
| ---- QUERY |
| create table ice_hive_ext (i int) |
| stored by iceberg |
| tblproperties ('external.table.purge'='false'); |
| insert into ice_hive_ext values (4); |
| ---- DML_RESULTS: ice_hive_ext |
| 4 |
| ---- TYPES |
| INT |
| ==== |
| ---- QUERY |
| alter table ice_hive_ext add column j int; |
| select * from ice_hive_ext; |
| ---- RESULTS |
| 4,NULL |
| ---- TYPES |
| INT,INT |
| ==== |
| ---- QUERY |
| insert into ice_hive_ext values (5,5); |
| ---- DML_RESULTS: ice_hive_ext |
| 4,NULL |
| 5,5 |
| ---- TYPES |
| INT,INT |
| ==== |
| ---- QUERY |
| alter table ice_hive_ext set tblproperties ('external.table.purge'='true'); |
| insert into ice_hive_ext values (6,6); |
| describe formatted ice_hive_ext |
| ---- RESULTS: VERIFY_IS_SUBSET |
| '','external.table.purge','true ' |
| ---- TYPES |
| STRING,STRING,STRING |
| ==== |
| ---- QUERY |
| create table ice_hadoop_tables_ext (i int) |
| stored by iceberg |
| tblproperties ('iceberg.catalog'='hadoop.tables', 'external.table.purge'='false'); |
| insert into ice_hadoop_tables_ext values (4); |
| ---- DML_RESULTS: ice_hadoop_tables_ext |
| 4 |
| ---- TYPES |
| INT |
| ==== |
| ---- QUERY |
| alter table ice_hadoop_tables_ext add column j int; |
| select * from ice_hadoop_tables_ext; |
| ---- RESULTS |
| 4,NULL |
| ---- TYPES |
| INT,INT |
| ==== |
| ---- QUERY |
| insert into ice_hadoop_tables_ext values (5,5); |
| ---- DML_RESULTS: ice_hadoop_tables_ext |
| 4,NULL |
| 5,5 |
| ---- TYPES |
| INT,INT |
| ==== |
| ---- QUERY |
| alter table ice_hadoop_tables_ext set tblproperties ('external.table.purge'='true'); |
| insert into ice_hadoop_tables_ext values (6,6); |
| describe formatted ice_hadoop_tables_ext |
| ---- RESULTS: VERIFY_IS_SUBSET |
| '','external.table.purge','true ' |
| ---- TYPES |
| STRING,STRING,STRING |
| ==== |