| --! qt:dataset:part |
| set hive.stats.column.autogather=true; |
| set hive.mapred.mode=nonstrict; |
| set hive.cli.print.header=true; |
| SET hive.exec.schema.evolution=true; |
| SET hive.vectorized.execution.enabled=false; |
| set hive.fetch.task.conversion=none; |
| |
| -- SORT_QUERY_RESULTS |
| -- |
| -- FILE VARIATION: TEXT, Non-Vectorized, MapWork, Partitioned |
| -- |
| -- |
| -- SECTION VARIATION: ALTER TABLE ADD COLUMNS ... STATIC INSERT |
| --- |
| CREATE TABLE partitioned1_n1(a INT, b STRING) PARTITIONED BY(part INT) STORED AS TEXTFILE; |
| |
| explain insert into table partitioned1_n1 partition(part=1) values(1, 'original'),(2, 'original'), (3, 'original'),(4, 'original'); |
| |
| insert into table partitioned1_n1 partition(part=1) values(1, 'original'),(2, 'original'), (3, 'original'),(4, 'original'); |
| |
| desc formatted partitioned1_n1 partition(part=1); |
| |
| desc formatted partitioned1_n1 partition(part=1) a; |
| |
| -- Table-Non-Cascade ADD COLUMNS ... |
| alter table partitioned1_n1 add columns(c int, d string); |
| |
| desc formatted partitioned1_n1 partition(part=1); |
| |
| explain insert into table partitioned1_n1 partition(part=2) values(1, 'new', 10, 'ten'),(2, 'new', 20, 'twenty'), (3, 'new', 30, 'thirty'),(4, 'new', 40, 'forty'); |
| |
| insert into table partitioned1_n1 partition(part=2) values(1, 'new', 10, 'ten'),(2, 'new', 20, 'twenty'), (3, 'new', 30, 'thirty'),(4, 'new', 40, 'forty'); |
| |
| desc formatted partitioned1_n1 partition(part=2); |
| |
| desc formatted partitioned1_n1 partition(part=2) c; |
| |
| explain insert into table partitioned1_n1 partition(part=1) values(5, 'new', 100, 'hundred'),(6, 'new', 200, 'two hundred'); |
| |
| insert into table partitioned1_n1 partition(part=1) values(5, 'new', 100, 'hundred'),(6, 'new', 200, 'two hundred'); |
| |
| desc formatted partitioned1_n1 partition(part=1); |
| |
| desc formatted partitioned1_n1 partition(part=1) a; |
| |
| desc formatted partitioned1_n1 partition(part=1) c; |