http://git-wip-us.apache.org/repos/asf/hive/blob/8230b579/ql/src/test/results/clientpositive/llap/schema_evol_orc_vec_mapwork_part.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/schema_evol_orc_vec_mapwork_part.q.out b/ql/src/test/results/clientpositive/llap/schema_evol_orc_vec_mapwork_part.q.out deleted file mode 100644 index 210589d..0000000 --- a/ql/src/test/results/clientpositive/llap/schema_evol_orc_vec_mapwork_part.q.out +++ /dev/null @@ -1,3723 +0,0 @@ -PREHOOK: query: -- SORT_QUERY_RESULTS --- --- FILE VARIATION: ORC, Vectorized, MapWork, Partitioned --- ------------------------------------------------------------------------------------------- --- SECTION: ALTER TABLE ADD COLUMNS --- --- --- SUBSECTION: ALTER TABLE ADD COLUMNS: INT PERMUTE SELECT --- --- -CREATE TABLE part_add_int_permute_select(insert_num int, a INT, b STRING) PARTITIONED BY(part INT) -PREHOOK: type: CREATETABLE -PREHOOK: Output: database:default -PREHOOK: Output: default@part_add_int_permute_select -POSTHOOK: query: -- SORT_QUERY_RESULTS --- --- FILE VARIATION: ORC, Vectorized, MapWork, Partitioned --- ------------------------------------------------------------------------------------------- --- SECTION: ALTER TABLE ADD COLUMNS --- --- --- SUBSECTION: ALTER TABLE ADD COLUMNS: INT PERMUTE SELECT --- --- -CREATE TABLE part_add_int_permute_select(insert_num int, a INT, b STRING) PARTITIONED BY(part INT) -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:default -POSTHOOK: Output: default@part_add_int_permute_select -PREHOOK: query: DESCRIBE FORMATTED part_add_int_permute_select -PREHOOK: type: DESCTABLE -PREHOOK: Input: default@part_add_int_permute_select -POSTHOOK: query: DESCRIBE FORMATTED part_add_int_permute_select -POSTHOOK: type: DESCTABLE -POSTHOOK: Input: default@part_add_int_permute_select -col_name data_type comment -# col_name data_type comment - -insert_num int -a int -b string - -# Partition Information -# col_name data_type comment - -part int - -# Detailed Table Information -Database: default -#### A masked pattern was here #### -Retention: 0 -#### A masked pattern was here #### -Table Type: MANAGED_TABLE -Table Parameters: -#### A masked pattern was here #### - -# Storage Information -SerDe Library: org.apache.hadoop.hive.ql.io.orc.OrcSerde -InputFormat: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat -OutputFormat: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat -Compressed: No -Num Buckets: -1 -Bucket Columns: [] -Sort Columns: [] -Storage Desc Params: - serialization.format 1 -PREHOOK: query: insert into table part_add_int_permute_select partition(part=1) - values (1, 1, 'original'), - (2, 2, 'original'), - (3, 3, 'original'), - (4, 4, 'original') -PREHOOK: type: QUERY -PREHOOK: Output: default@part_add_int_permute_select@part=1 -POSTHOOK: query: insert into table part_add_int_permute_select partition(part=1) - values (1, 1, 'original'), - (2, 2, 'original'), - (3, 3, 'original'), - (4, 4, 'original') -POSTHOOK: type: QUERY -POSTHOOK: Output: default@part_add_int_permute_select@part=1 -POSTHOOK: Lineage: part_add_int_permute_select PARTITION(part=1).a EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col2, type:string, comment:), ] -POSTHOOK: Lineage: part_add_int_permute_select PARTITION(part=1).b SIMPLE [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col3, type:string, comment:), ] -POSTHOOK: Lineage: part_add_int_permute_select PARTITION(part=1).insert_num EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ] -_col0 _col1 _col2 -PREHOOK: query: -- Table-Non-Cascade ADD COLUMNS ... -alter table part_add_int_permute_select add columns(c int) -PREHOOK: type: ALTERTABLE_ADDCOLS -PREHOOK: Input: default@part_add_int_permute_select -PREHOOK: Output: default@part_add_int_permute_select -POSTHOOK: query: -- Table-Non-Cascade ADD COLUMNS ... -alter table part_add_int_permute_select add columns(c int) -POSTHOOK: type: ALTERTABLE_ADDCOLS -POSTHOOK: Input: default@part_add_int_permute_select -POSTHOOK: Output: default@part_add_int_permute_select -PREHOOK: query: DESCRIBE FORMATTED part_add_int_permute_select -PREHOOK: type: DESCTABLE -PREHOOK: Input: default@part_add_int_permute_select -POSTHOOK: query: DESCRIBE FORMATTED part_add_int_permute_select -POSTHOOK: type: DESCTABLE -POSTHOOK: Input: default@part_add_int_permute_select -col_name data_type comment -# col_name data_type comment - -insert_num int -a int -b string -c int - -# Partition Information -# col_name data_type comment - -part int - -# Detailed Table Information -Database: default -#### A masked pattern was here #### -Retention: 0 -#### A masked pattern was here #### -Table Type: MANAGED_TABLE -Table Parameters: -#### A masked pattern was here #### - -# Storage Information -SerDe Library: org.apache.hadoop.hive.ql.io.orc.OrcSerde -InputFormat: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat -OutputFormat: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat -Compressed: No -Num Buckets: -1 -Bucket Columns: [] -Sort Columns: [] -Storage Desc Params: - serialization.format 1 -PREHOOK: query: insert into table part_add_int_permute_select partition(part=2) - values (5, 1, 'new', 10), - (6, 2, 'new', 20), - (7, 3, 'new', 30), - (8, 4, 'new', 40) -PREHOOK: type: QUERY -PREHOOK: Output: default@part_add_int_permute_select@part=2 -POSTHOOK: query: insert into table part_add_int_permute_select partition(part=2) - values (5, 1, 'new', 10), - (6, 2, 'new', 20), - (7, 3, 'new', 30), - (8, 4, 'new', 40) -POSTHOOK: type: QUERY -POSTHOOK: Output: default@part_add_int_permute_select@part=2 -POSTHOOK: Lineage: part_add_int_permute_select PARTITION(part=2).a EXPRESSION [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col2, type:string, comment:), ] -POSTHOOK: Lineage: part_add_int_permute_select PARTITION(part=2).b SIMPLE [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col3, type:string, comment:), ] -POSTHOOK: Lineage: part_add_int_permute_select PARTITION(part=2).c EXPRESSION [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col4, type:string, comment:), ] -POSTHOOK: Lineage: part_add_int_permute_select PARTITION(part=2).insert_num EXPRESSION [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col1, type:string, comment:), ] -_col0 _col1 _col2 _col3 -PREHOOK: query: insert into table part_add_int_permute_select partition(part=1) - values (9, 5, 'new', 100), - (10, 6, 'new', 200) -PREHOOK: type: QUERY -PREHOOK: Output: default@part_add_int_permute_select@part=1 -POSTHOOK: query: insert into table part_add_int_permute_select partition(part=1) - values (9, 5, 'new', 100), - (10, 6, 'new', 200) -POSTHOOK: type: QUERY -POSTHOOK: Output: default@part_add_int_permute_select@part=1 -POSTHOOK: Lineage: part_add_int_permute_select PARTITION(part=1).a EXPRESSION [(values__tmp__table__3)values__tmp__table__3.FieldSchema(name:tmp_values_col2, type:string, comment:), ] -POSTHOOK: Lineage: part_add_int_permute_select PARTITION(part=1).b SIMPLE [(values__tmp__table__3)values__tmp__table__3.FieldSchema(name:tmp_values_col3, type:string, comment:), ] -POSTHOOK: Lineage: part_add_int_permute_select PARTITION(part=1).c EXPRESSION [(values__tmp__table__3)values__tmp__table__3.FieldSchema(name:tmp_values_col4, type:string, comment:), ] -POSTHOOK: Lineage: part_add_int_permute_select PARTITION(part=1).insert_num EXPRESSION [(values__tmp__table__3)values__tmp__table__3.FieldSchema(name:tmp_values_col1, type:string, comment:), ] -_col0 _col1 _col2 _col3 -PREHOOK: query: explain -select insert_num,part,a,b from part_add_int_permute_select -PREHOOK: type: QUERY -POSTHOOK: query: explain -select insert_num,part,a,b from part_add_int_permute_select -POSTHOOK: type: QUERY -Explain -Plan optimized by CBO. - -Stage-0 - Fetch Operator - limit:-1 - Stage-1 - Map 1 vectorized, llap - File Output Operator [FS_4] - Select Operator [SEL_3] (rows=10 width=4) - Output:["_col0","_col1","_col2","_col3"] - TableScan [TS_0] (rows=10 width=103) - default@part_add_int_permute_select,part_add_int_permute_select,Tbl:COMPLETE,Col:PARTIAL,Output:["insert_num","a","b"] - -PREHOOK: query: -- SELECT permutation columns to make sure NULL defaulting works right -select insert_num,part,a,b from part_add_int_permute_select -PREHOOK: type: QUERY -PREHOOK: Input: default@part_add_int_permute_select -PREHOOK: Input: default@part_add_int_permute_select@part=1 -PREHOOK: Input: default@part_add_int_permute_select@part=2 -#### A masked pattern was here #### -POSTHOOK: query: -- SELECT permutation columns to make sure NULL defaulting works right -select insert_num,part,a,b from part_add_int_permute_select -POSTHOOK: type: QUERY -POSTHOOK: Input: default@part_add_int_permute_select -POSTHOOK: Input: default@part_add_int_permute_select@part=1 -POSTHOOK: Input: default@part_add_int_permute_select@part=2 -#### A masked pattern was here #### -insert_num part a b -1 1 1 original -10 1 6 new -2 1 2 original -3 1 3 original -4 1 4 original -5 2 1 new -6 2 2 new -7 2 3 new -8 2 4 new -9 1 5 new -PREHOOK: query: select insert_num,part,a,b,c from part_add_int_permute_select -PREHOOK: type: QUERY -PREHOOK: Input: default@part_add_int_permute_select -PREHOOK: Input: default@part_add_int_permute_select@part=1 -PREHOOK: Input: default@part_add_int_permute_select@part=2 -#### A masked pattern was here #### -POSTHOOK: query: select insert_num,part,a,b,c from part_add_int_permute_select -POSTHOOK: type: QUERY -POSTHOOK: Input: default@part_add_int_permute_select -POSTHOOK: Input: default@part_add_int_permute_select@part=1 -POSTHOOK: Input: default@part_add_int_permute_select@part=2 -#### A masked pattern was here #### -insert_num part a b c -1 1 1 original NULL -10 1 6 new 200 -2 1 2 original NULL -3 1 3 original NULL -4 1 4 original NULL -5 2 1 new 10 -6 2 2 new 20 -7 2 3 new 30 -8 2 4 new 40 -9 1 5 new 100 -PREHOOK: query: select insert_num,part,c from part_add_int_permute_select -PREHOOK: type: QUERY -PREHOOK: Input: default@part_add_int_permute_select -PREHOOK: Input: default@part_add_int_permute_select@part=1 -PREHOOK: Input: default@part_add_int_permute_select@part=2 -#### A masked pattern was here #### -POSTHOOK: query: select insert_num,part,c from part_add_int_permute_select -POSTHOOK: type: QUERY -POSTHOOK: Input: default@part_add_int_permute_select -POSTHOOK: Input: default@part_add_int_permute_select@part=1 -POSTHOOK: Input: default@part_add_int_permute_select@part=2 -#### A masked pattern was here #### -insert_num part c -1 1 NULL -10 1 200 -2 1 NULL -3 1 NULL -4 1 NULL -5 2 10 -6 2 20 -7 2 30 -8 2 40 -9 1 100 -PREHOOK: query: drop table part_add_int_permute_select -PREHOOK: type: DROPTABLE -PREHOOK: Input: default@part_add_int_permute_select -PREHOOK: Output: default@part_add_int_permute_select -POSTHOOK: query: drop table part_add_int_permute_select -POSTHOOK: type: DROPTABLE -POSTHOOK: Input: default@part_add_int_permute_select -POSTHOOK: Output: default@part_add_int_permute_select -PREHOOK: query: -- SUBSECTION: ALTER TABLE ADD COLUMNS: INT, STRING, PERMUTE SELECT --- --- -CREATE TABLE part_add_int_string_permute_select(insert_num int, a INT, b STRING) PARTITIONED BY(part INT) -PREHOOK: type: CREATETABLE -PREHOOK: Output: database:default -PREHOOK: Output: default@part_add_int_string_permute_select -POSTHOOK: query: -- SUBSECTION: ALTER TABLE ADD COLUMNS: INT, STRING, PERMUTE SELECT --- --- -CREATE TABLE part_add_int_string_permute_select(insert_num int, a INT, b STRING) PARTITIONED BY(part INT) -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:default -POSTHOOK: Output: default@part_add_int_string_permute_select -PREHOOK: query: DESCRIBE FORMATTED part_add_int_string_permute_select -PREHOOK: type: DESCTABLE -PREHOOK: Input: default@part_add_int_string_permute_select -POSTHOOK: query: DESCRIBE FORMATTED part_add_int_string_permute_select -POSTHOOK: type: DESCTABLE -POSTHOOK: Input: default@part_add_int_string_permute_select -col_name data_type comment -# col_name data_type comment - -insert_num int -a int -b string - -# Partition Information -# col_name data_type comment - -part int - -# Detailed Table Information -Database: default -#### A masked pattern was here #### -Retention: 0 -#### A masked pattern was here #### -Table Type: MANAGED_TABLE -Table Parameters: -#### A masked pattern was here #### - -# Storage Information -SerDe Library: org.apache.hadoop.hive.ql.io.orc.OrcSerde -InputFormat: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat -OutputFormat: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat -Compressed: No -Num Buckets: -1 -Bucket Columns: [] -Sort Columns: [] -Storage Desc Params: - serialization.format 1 -PREHOOK: query: insert into table part_add_int_string_permute_select partition(part=1) - values (1, 1, 'original'), - (2, 2, 'original'), - (3, 3, 'original'), - (4, 4, 'original') -PREHOOK: type: QUERY -PREHOOK: Output: default@part_add_int_string_permute_select@part=1 -POSTHOOK: query: insert into table part_add_int_string_permute_select partition(part=1) - values (1, 1, 'original'), - (2, 2, 'original'), - (3, 3, 'original'), - (4, 4, 'original') -POSTHOOK: type: QUERY -POSTHOOK: Output: default@part_add_int_string_permute_select@part=1 -POSTHOOK: Lineage: part_add_int_string_permute_select PARTITION(part=1).a EXPRESSION [(values__tmp__table__4)values__tmp__table__4.FieldSchema(name:tmp_values_col2, type:string, comment:), ] -POSTHOOK: Lineage: part_add_int_string_permute_select PARTITION(part=1).b SIMPLE [(values__tmp__table__4)values__tmp__table__4.FieldSchema(name:tmp_values_col3, type:string, comment:), ] -POSTHOOK: Lineage: part_add_int_string_permute_select PARTITION(part=1).insert_num EXPRESSION [(values__tmp__table__4)values__tmp__table__4.FieldSchema(name:tmp_values_col1, type:string, comment:), ] -_col0 _col1 _col2 -PREHOOK: query: -- Table-Non-Cascade ADD COLUMNS ... -alter table part_add_int_string_permute_select add columns(c int, d string) -PREHOOK: type: ALTERTABLE_ADDCOLS -PREHOOK: Input: default@part_add_int_string_permute_select -PREHOOK: Output: default@part_add_int_string_permute_select -POSTHOOK: query: -- Table-Non-Cascade ADD COLUMNS ... -alter table part_add_int_string_permute_select add columns(c int, d string) -POSTHOOK: type: ALTERTABLE_ADDCOLS -POSTHOOK: Input: default@part_add_int_string_permute_select -POSTHOOK: Output: default@part_add_int_string_permute_select -PREHOOK: query: DESCRIBE FORMATTED part_add_int_string_permute_select -PREHOOK: type: DESCTABLE -PREHOOK: Input: default@part_add_int_string_permute_select -POSTHOOK: query: DESCRIBE FORMATTED part_add_int_string_permute_select -POSTHOOK: type: DESCTABLE -POSTHOOK: Input: default@part_add_int_string_permute_select -col_name data_type comment -# col_name data_type comment - -insert_num int -a int -b string -c int -d string - -# Partition Information -# col_name data_type comment - -part int - -# Detailed Table Information -Database: default -#### A masked pattern was here #### -Retention: 0 -#### A masked pattern was here #### -Table Type: MANAGED_TABLE -Table Parameters: -#### A masked pattern was here #### - -# Storage Information -SerDe Library: org.apache.hadoop.hive.ql.io.orc.OrcSerde -InputFormat: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat -OutputFormat: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat -Compressed: No -Num Buckets: -1 -Bucket Columns: [] -Sort Columns: [] -Storage Desc Params: - serialization.format 1 -PREHOOK: query: insert into table part_add_int_string_permute_select partition(part=2) - values (5, 1, 'new', 10, 'ten'), - (6, 2, 'new', 20, 'twenty'), - (7, 3, 'new', 30, 'thirty'), - (8, 4, 'new', 40, 'forty') -PREHOOK: type: QUERY -PREHOOK: Output: default@part_add_int_string_permute_select@part=2 -POSTHOOK: query: insert into table part_add_int_string_permute_select partition(part=2) - values (5, 1, 'new', 10, 'ten'), - (6, 2, 'new', 20, 'twenty'), - (7, 3, 'new', 30, 'thirty'), - (8, 4, 'new', 40, 'forty') -POSTHOOK: type: QUERY -POSTHOOK: Output: default@part_add_int_string_permute_select@part=2 -POSTHOOK: Lineage: part_add_int_string_permute_select PARTITION(part=2).a EXPRESSION [(values__tmp__table__5)values__tmp__table__5.FieldSchema(name:tmp_values_col2, type:string, comment:), ] -POSTHOOK: Lineage: part_add_int_string_permute_select PARTITION(part=2).b SIMPLE [(values__tmp__table__5)values__tmp__table__5.FieldSchema(name:tmp_values_col3, type:string, comment:), ] -POSTHOOK: Lineage: part_add_int_string_permute_select PARTITION(part=2).c EXPRESSION [(values__tmp__table__5)values__tmp__table__5.FieldSchema(name:tmp_values_col4, type:string, comment:), ] -POSTHOOK: Lineage: part_add_int_string_permute_select PARTITION(part=2).d SIMPLE [(values__tmp__table__5)values__tmp__table__5.FieldSchema(name:tmp_values_col5, type:string, comment:), ] -POSTHOOK: Lineage: part_add_int_string_permute_select PARTITION(part=2).insert_num EXPRESSION [(values__tmp__table__5)values__tmp__table__5.FieldSchema(name:tmp_values_col1, type:string, comment:), ] -_col0 _col1 _col2 _col3 _col4 -PREHOOK: query: insert into table part_add_int_string_permute_select partition(part=1) - values (9, 5, 'new', 100, 'hundred'), - (10, 6, 'new', 200, 'two hundred') -PREHOOK: type: QUERY -PREHOOK: Output: default@part_add_int_string_permute_select@part=1 -POSTHOOK: query: insert into table part_add_int_string_permute_select partition(part=1) - values (9, 5, 'new', 100, 'hundred'), - (10, 6, 'new', 200, 'two hundred') -POSTHOOK: type: QUERY -POSTHOOK: Output: default@part_add_int_string_permute_select@part=1 -POSTHOOK: Lineage: part_add_int_string_permute_select PARTITION(part=1).a EXPRESSION [(values__tmp__table__6)values__tmp__table__6.FieldSchema(name:tmp_values_col2, type:string, comment:), ] -POSTHOOK: Lineage: part_add_int_string_permute_select PARTITION(part=1).b SIMPLE [(values__tmp__table__6)values__tmp__table__6.FieldSchema(name:tmp_values_col3, type:string, comment:), ] -POSTHOOK: Lineage: part_add_int_string_permute_select PARTITION(part=1).c EXPRESSION [(values__tmp__table__6)values__tmp__table__6.FieldSchema(name:tmp_values_col4, type:string, comment:), ] -POSTHOOK: Lineage: part_add_int_string_permute_select PARTITION(part=1).d SIMPLE [(values__tmp__table__6)values__tmp__table__6.FieldSchema(name:tmp_values_col5, type:string, comment:), ] -POSTHOOK: Lineage: part_add_int_string_permute_select PARTITION(part=1).insert_num EXPRESSION [(values__tmp__table__6)values__tmp__table__6.FieldSchema(name:tmp_values_col1, type:string, comment:), ] -_col0 _col1 _col2 _col3 _col4 -PREHOOK: query: explain -select insert_num,part,a,b from part_add_int_string_permute_select -PREHOOK: type: QUERY -POSTHOOK: query: explain -select insert_num,part,a,b from part_add_int_string_permute_select -POSTHOOK: type: QUERY -Explain -Plan optimized by CBO. - -Stage-0 - Fetch Operator - limit:-1 - Stage-1 - Map 1 vectorized, llap - File Output Operator [FS_4] - Select Operator [SEL_3] (rows=10 width=4) - Output:["_col0","_col1","_col2","_col3"] - TableScan [TS_0] (rows=10 width=157) - default@part_add_int_string_permute_select,part_add_int_string_permute_select,Tbl:COMPLETE,Col:PARTIAL,Output:["insert_num","a","b"] - -PREHOOK: query: -- SELECT permutation columns to make sure NULL defaulting works right -select insert_num,part,a,b from part_add_int_string_permute_select -PREHOOK: type: QUERY -PREHOOK: Input: default@part_add_int_string_permute_select -PREHOOK: Input: default@part_add_int_string_permute_select@part=1 -PREHOOK: Input: default@part_add_int_string_permute_select@part=2 -#### A masked pattern was here #### -POSTHOOK: query: -- SELECT permutation columns to make sure NULL defaulting works right -select insert_num,part,a,b from part_add_int_string_permute_select -POSTHOOK: type: QUERY -POSTHOOK: Input: default@part_add_int_string_permute_select -POSTHOOK: Input: default@part_add_int_string_permute_select@part=1 -POSTHOOK: Input: default@part_add_int_string_permute_select@part=2 -#### A masked pattern was here #### -insert_num part a b -1 1 1 original -10 1 6 new -2 1 2 original -3 1 3 original -4 1 4 original -5 2 1 new -6 2 2 new -7 2 3 new -8 2 4 new -9 1 5 new -PREHOOK: query: select insert_num,part,a,b,c from part_add_int_string_permute_select -PREHOOK: type: QUERY -PREHOOK: Input: default@part_add_int_string_permute_select -PREHOOK: Input: default@part_add_int_string_permute_select@part=1 -PREHOOK: Input: default@part_add_int_string_permute_select@part=2 -#### A masked pattern was here #### -POSTHOOK: query: select insert_num,part,a,b,c from part_add_int_string_permute_select -POSTHOOK: type: QUERY -POSTHOOK: Input: default@part_add_int_string_permute_select -POSTHOOK: Input: default@part_add_int_string_permute_select@part=1 -POSTHOOK: Input: default@part_add_int_string_permute_select@part=2 -#### A masked pattern was here #### -insert_num part a b c -1 1 1 original NULL -10 1 6 new 200 -2 1 2 original NULL -3 1 3 original NULL -4 1 4 original NULL -5 2 1 new 10 -6 2 2 new 20 -7 2 3 new 30 -8 2 4 new 40 -9 1 5 new 100 -PREHOOK: query: select insert_num,part,a,b,c,d from part_add_int_string_permute_select -PREHOOK: type: QUERY -PREHOOK: Input: default@part_add_int_string_permute_select -PREHOOK: Input: default@part_add_int_string_permute_select@part=1 -PREHOOK: Input: default@part_add_int_string_permute_select@part=2 -#### A masked pattern was here #### -POSTHOOK: query: select insert_num,part,a,b,c,d from part_add_int_string_permute_select -POSTHOOK: type: QUERY -POSTHOOK: Input: default@part_add_int_string_permute_select -POSTHOOK: Input: default@part_add_int_string_permute_select@part=1 -POSTHOOK: Input: default@part_add_int_string_permute_select@part=2 -#### A masked pattern was here #### -insert_num part a b c d -1 1 1 original NULL NULL -10 1 6 new 200 two hundred -2 1 2 original NULL NULL -3 1 3 original NULL NULL -4 1 4 original NULL NULL -5 2 1 new 10 ten -6 2 2 new 20 twenty -7 2 3 new 30 thirty -8 2 4 new 40 forty -9 1 5 new 100 hundred -PREHOOK: query: select insert_num,part,a,c,d from part_add_int_string_permute_select -PREHOOK: type: QUERY -PREHOOK: Input: default@part_add_int_string_permute_select -PREHOOK: Input: default@part_add_int_string_permute_select@part=1 -PREHOOK: Input: default@part_add_int_string_permute_select@part=2 -#### A masked pattern was here #### -POSTHOOK: query: select insert_num,part,a,c,d from part_add_int_string_permute_select -POSTHOOK: type: QUERY -POSTHOOK: Input: default@part_add_int_string_permute_select -POSTHOOK: Input: default@part_add_int_string_permute_select@part=1 -POSTHOOK: Input: default@part_add_int_string_permute_select@part=2 -#### A masked pattern was here #### -insert_num part a c d -1 1 1 NULL NULL -10 1 6 200 two hundred -2 1 2 NULL NULL -3 1 3 NULL NULL -4 1 4 NULL NULL -5 2 1 10 ten -6 2 2 20 twenty -7 2 3 30 thirty -8 2 4 40 forty -9 1 5 100 hundred -PREHOOK: query: select insert_num,part,a,d from part_add_int_string_permute_select -PREHOOK: type: QUERY -PREHOOK: Input: default@part_add_int_string_permute_select -PREHOOK: Input: default@part_add_int_string_permute_select@part=1 -PREHOOK: Input: default@part_add_int_string_permute_select@part=2 -#### A masked pattern was here #### -POSTHOOK: query: select insert_num,part,a,d from part_add_int_string_permute_select -POSTHOOK: type: QUERY -POSTHOOK: Input: default@part_add_int_string_permute_select -POSTHOOK: Input: default@part_add_int_string_permute_select@part=1 -POSTHOOK: Input: default@part_add_int_string_permute_select@part=2 -#### A masked pattern was here #### -insert_num part a d -1 1 1 NULL -10 1 6 two hundred -2 1 2 NULL -3 1 3 NULL -4 1 4 NULL -5 2 1 ten -6 2 2 twenty -7 2 3 thirty -8 2 4 forty -9 1 5 hundred -PREHOOK: query: select insert_num,part,c from part_add_int_string_permute_select -PREHOOK: type: QUERY -PREHOOK: Input: default@part_add_int_string_permute_select -PREHOOK: Input: default@part_add_int_string_permute_select@part=1 -PREHOOK: Input: default@part_add_int_string_permute_select@part=2 -#### A masked pattern was here #### -POSTHOOK: query: select insert_num,part,c from part_add_int_string_permute_select -POSTHOOK: type: QUERY -POSTHOOK: Input: default@part_add_int_string_permute_select -POSTHOOK: Input: default@part_add_int_string_permute_select@part=1 -POSTHOOK: Input: default@part_add_int_string_permute_select@part=2 -#### A masked pattern was here #### -insert_num part c -1 1 NULL -10 1 200 -2 1 NULL -3 1 NULL -4 1 NULL -5 2 10 -6 2 20 -7 2 30 -8 2 40 -9 1 100 -PREHOOK: query: select insert_num,part,d from part_add_int_string_permute_select -PREHOOK: type: QUERY -PREHOOK: Input: default@part_add_int_string_permute_select -PREHOOK: Input: default@part_add_int_string_permute_select@part=1 -PREHOOK: Input: default@part_add_int_string_permute_select@part=2 -#### A masked pattern was here #### -POSTHOOK: query: select insert_num,part,d from part_add_int_string_permute_select -POSTHOOK: type: QUERY -POSTHOOK: Input: default@part_add_int_string_permute_select -POSTHOOK: Input: default@part_add_int_string_permute_select@part=1 -POSTHOOK: Input: default@part_add_int_string_permute_select@part=2 -#### A masked pattern was here #### -insert_num part d -1 1 NULL -10 1 two hundred -2 1 NULL -3 1 NULL -4 1 NULL -5 2 ten -6 2 twenty -7 2 thirty -8 2 forty -9 1 hundred -PREHOOK: query: drop table part_add_int_string_permute_select -PREHOOK: type: DROPTABLE -PREHOOK: Input: default@part_add_int_string_permute_select -PREHOOK: Output: default@part_add_int_string_permute_select -POSTHOOK: query: drop table part_add_int_string_permute_select -POSTHOOK: type: DROPTABLE -POSTHOOK: Input: default@part_add_int_string_permute_select -POSTHOOK: Output: default@part_add_int_string_permute_select -PREHOOK: query: ------------------------------------------------------------------------------------------ --- SECTION: ALTER TABLE CHANGE COLUMNS for STRING_GROUP -> DOUBLE --- --- --- --- SUBSECTION: ALTER TABLE CHANGE COLUMNS for STRING_GROUP -> DOUBLE: (STRING, CHAR, VARCHAR) --- -CREATE TABLE part_change_string_group_double(insert_num int, c1 STRING, c2 CHAR(50), c3 VARCHAR(50), b STRING) PARTITIONED BY(part INT) -PREHOOK: type: CREATETABLE -PREHOOK: Output: database:default -PREHOOK: Output: default@part_change_string_group_double -POSTHOOK: query: ------------------------------------------------------------------------------------------ --- SECTION: ALTER TABLE CHANGE COLUMNS for STRING_GROUP -> DOUBLE --- --- --- --- SUBSECTION: ALTER TABLE CHANGE COLUMNS for STRING_GROUP -> DOUBLE: (STRING, CHAR, VARCHAR) --- -CREATE TABLE part_change_string_group_double(insert_num int, c1 STRING, c2 CHAR(50), c3 VARCHAR(50), b STRING) PARTITIONED BY(part INT) -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:default -POSTHOOK: Output: default@part_change_string_group_double -PREHOOK: query: insert into table part_change_string_group_double partition(part=1) - values (1, '753.7028', '753.7028', '753.7028', 'original'), - (2, '-3651.672121', '-3651.672121', '-3651.672121', 'original'), - (3, '-29.0764', '-29.0764', '-29.0764', 'original'), - (4, '-10.3', '-10.3', '-10.3', 'original') -PREHOOK: type: QUERY -PREHOOK: Output: default@part_change_string_group_double@part=1 -POSTHOOK: query: insert into table part_change_string_group_double partition(part=1) - values (1, '753.7028', '753.7028', '753.7028', 'original'), - (2, '-3651.672121', '-3651.672121', '-3651.672121', 'original'), - (3, '-29.0764', '-29.0764', '-29.0764', 'original'), - (4, '-10.3', '-10.3', '-10.3', 'original') -POSTHOOK: type: QUERY -POSTHOOK: Output: default@part_change_string_group_double@part=1 -POSTHOOK: Lineage: part_change_string_group_double PARTITION(part=1).b SIMPLE [(values__tmp__table__7)values__tmp__table__7.FieldSchema(name:tmp_values_col5, type:string, comment:), ] -POSTHOOK: Lineage: part_change_string_group_double PARTITION(part=1).c1 SIMPLE [(values__tmp__table__7)values__tmp__table__7.FieldSchema(name:tmp_values_col2, type:string, comment:), ] -POSTHOOK: Lineage: part_change_string_group_double PARTITION(part=1).c2 EXPRESSION [(values__tmp__table__7)values__tmp__table__7.FieldSchema(name:tmp_values_col3, type:string, comment:), ] -POSTHOOK: Lineage: part_change_string_group_double PARTITION(part=1).c3 EXPRESSION [(values__tmp__table__7)values__tmp__table__7.FieldSchema(name:tmp_values_col4, type:string, comment:), ] -POSTHOOK: Lineage: part_change_string_group_double PARTITION(part=1).insert_num EXPRESSION [(values__tmp__table__7)values__tmp__table__7.FieldSchema(name:tmp_values_col1, type:string, comment:), ] -_col0 _col1 _col2 _col3 _col4 -PREHOOK: query: -- Table-Non-Cascade CHANGE COLUMNS ... -alter table part_change_string_group_double replace columns (insert_num int, c1 DOUBLE, c2 DOUBLE, c3 DOUBLE, b STRING) -PREHOOK: type: ALTERTABLE_REPLACECOLS -PREHOOK: Input: default@part_change_string_group_double -PREHOOK: Output: default@part_change_string_group_double -POSTHOOK: query: -- Table-Non-Cascade CHANGE COLUMNS ... -alter table part_change_string_group_double replace columns (insert_num int, c1 DOUBLE, c2 DOUBLE, c3 DOUBLE, b STRING) -POSTHOOK: type: ALTERTABLE_REPLACECOLS -POSTHOOK: Input: default@part_change_string_group_double -POSTHOOK: Output: default@part_change_string_group_double -PREHOOK: query: insert into table part_change_string_group_double partition(part=2) - values (5, 30.774, 30.774, 30.774, 'new'), - (6, 20.31, 20.31, 20.31, 'new'), - (7, 46114.284799488, 46114.284799488, 46114.284799488, 'new'), - (8, -66475.561431, -66475.561431, -66475.561431, 'new') -PREHOOK: type: QUERY -PREHOOK: Output: default@part_change_string_group_double@part=2 -POSTHOOK: query: insert into table part_change_string_group_double partition(part=2) - values (5, 30.774, 30.774, 30.774, 'new'), - (6, 20.31, 20.31, 20.31, 'new'), - (7, 46114.284799488, 46114.284799488, 46114.284799488, 'new'), - (8, -66475.561431, -66475.561431, -66475.561431, 'new') -POSTHOOK: type: QUERY -POSTHOOK: Output: default@part_change_string_group_double@part=2 -POSTHOOK: Lineage: part_change_string_group_double PARTITION(part=2).b SIMPLE [(values__tmp__table__8)values__tmp__table__8.FieldSchema(name:tmp_values_col5, type:string, comment:), ] -POSTHOOK: Lineage: part_change_string_group_double PARTITION(part=2).c1 EXPRESSION [(values__tmp__table__8)values__tmp__table__8.FieldSchema(name:tmp_values_col2, type:string, comment:), ] -POSTHOOK: Lineage: part_change_string_group_double PARTITION(part=2).c2 EXPRESSION [(values__tmp__table__8)values__tmp__table__8.FieldSchema(name:tmp_values_col3, type:string, comment:), ] -POSTHOOK: Lineage: part_change_string_group_double PARTITION(part=2).c3 EXPRESSION [(values__tmp__table__8)values__tmp__table__8.FieldSchema(name:tmp_values_col4, type:string, comment:), ] -POSTHOOK: Lineage: part_change_string_group_double PARTITION(part=2).insert_num EXPRESSION [(values__tmp__table__8)values__tmp__table__8.FieldSchema(name:tmp_values_col1, type:string, comment:), ] -_col0 _col1 _col2 _col3 _col4 -PREHOOK: query: insert into table part_change_string_group_double partition(part=1) - values (9, 17808.963785, 17808.963785, 17808.963785, 'new'), - (10, 9250340.75 , 9250340.75 , 9250340.75 , 'new') -PREHOOK: type: QUERY -PREHOOK: Output: default@part_change_string_group_double@part=1 -POSTHOOK: query: insert into table part_change_string_group_double partition(part=1) - values (9, 17808.963785, 17808.963785, 17808.963785, 'new'), - (10, 9250340.75 , 9250340.75 , 9250340.75 , 'new') -POSTHOOK: type: QUERY -POSTHOOK: Output: default@part_change_string_group_double@part=1 -POSTHOOK: Lineage: part_change_string_group_double PARTITION(part=1).b SIMPLE [(values__tmp__table__9)values__tmp__table__9.FieldSchema(name:tmp_values_col5, type:string, comment:), ] -POSTHOOK: Lineage: part_change_string_group_double PARTITION(part=1).c1 EXPRESSION [(values__tmp__table__9)values__tmp__table__9.FieldSchema(name:tmp_values_col2, type:string, comment:), ] -POSTHOOK: Lineage: part_change_string_group_double PARTITION(part=1).c2 EXPRESSION [(values__tmp__table__9)values__tmp__table__9.FieldSchema(name:tmp_values_col3, type:string, comment:), ] -POSTHOOK: Lineage: part_change_string_group_double PARTITION(part=1).c3 EXPRESSION [(values__tmp__table__9)values__tmp__table__9.FieldSchema(name:tmp_values_col4, type:string, comment:), ] -POSTHOOK: Lineage: part_change_string_group_double PARTITION(part=1).insert_num EXPRESSION [(values__tmp__table__9)values__tmp__table__9.FieldSchema(name:tmp_values_col1, type:string, comment:), ] -_col0 _col1 _col2 _col3 _col4 -PREHOOK: query: explain -select insert_num,part,c1,c2,c3,b from part_change_string_group_double -PREHOOK: type: QUERY -POSTHOOK: query: explain -select insert_num,part,c1,c2,c3,b from part_change_string_group_double -POSTHOOK: type: QUERY -Explain -Plan optimized by CBO. - -Stage-0 - Fetch Operator - limit:-1 - Stage-1 - Map 1 vectorized, llap - File Output Operator [FS_4] - Select Operator [SEL_3] (rows=10 width=4) - Output:["_col0","_col1","_col2","_col3","_col4","_col5"] - TableScan [TS_0] (rows=10 width=238) - default@part_change_string_group_double,part_change_string_group_double,Tbl:COMPLETE,Col:PARTIAL,Output:["insert_num","c1","c2","c3","b"] - -PREHOOK: query: select insert_num,part,c1,c2,c3,b from part_change_string_group_double -PREHOOK: type: QUERY -PREHOOK: Input: default@part_change_string_group_double -PREHOOK: Input: default@part_change_string_group_double@part=1 -PREHOOK: Input: default@part_change_string_group_double@part=2 -#### A masked pattern was here #### -POSTHOOK: query: select insert_num,part,c1,c2,c3,b from part_change_string_group_double -POSTHOOK: type: QUERY -POSTHOOK: Input: default@part_change_string_group_double -POSTHOOK: Input: default@part_change_string_group_double@part=1 -POSTHOOK: Input: default@part_change_string_group_double@part=2 -#### A masked pattern was here #### -insert_num part c1 c2 c3 b -1 1 753.7028 753.7028 753.7028 original -10 1 9250340.75 9250340.75 9250340.75 new -2 1 -3651.672121 -3651.672121 -3651.672121 original -3 1 -29.0764 -29.0764 -29.0764 original -4 1 -10.3 -10.3 -10.3 original -5 2 30.774 30.774 30.774 new -6 2 20.31 20.31 20.31 new -7 2 46114.284799488 46114.284799488 46114.284799488 new -8 2 -66475.561431 -66475.561431 -66475.561431 new -9 1 17808.963785 17808.963785 17808.963785 new -PREHOOK: query: drop table part_change_string_group_double -PREHOOK: type: DROPTABLE -PREHOOK: Input: default@part_change_string_group_double -PREHOOK: Output: default@part_change_string_group_double -POSTHOOK: query: drop table part_change_string_group_double -POSTHOOK: type: DROPTABLE -POSTHOOK: Input: default@part_change_string_group_double -POSTHOOK: Output: default@part_change_string_group_double -PREHOOK: query: ------------------------------------------------------------------------------------------ --- SECTION: ALTER TABLE CHANGE COLUMNS for DATE_GROUP -> STRING_GROUP --- --- --- --- SUBSECTION: ALTER TABLE CHANGE COLUMNS for DATE_GROUP -> STRING_GROUP: TIMESTAMP, (STRING, CHAR, CHAR trunc, VARCHAR, VARCHAR trunc) --- -CREATE TABLE part_change_date_group_string_group_timestamp(insert_num int, c1 TIMESTAMP, c2 TIMESTAMP, c3 TIMESTAMP, c4 TIMESTAMP, c5 TIMESTAMP, b STRING) PARTITIONED BY(part INT) -PREHOOK: type: CREATETABLE -PREHOOK: Output: database:default -PREHOOK: Output: default@part_change_date_group_string_group_timestamp -POSTHOOK: query: ------------------------------------------------------------------------------------------ --- SECTION: ALTER TABLE CHANGE COLUMNS for DATE_GROUP -> STRING_GROUP --- --- --- --- SUBSECTION: ALTER TABLE CHANGE COLUMNS for DATE_GROUP -> STRING_GROUP: TIMESTAMP, (STRING, CHAR, CHAR trunc, VARCHAR, VARCHAR trunc) --- -CREATE TABLE part_change_date_group_string_group_timestamp(insert_num int, c1 TIMESTAMP, c2 TIMESTAMP, c3 TIMESTAMP, c4 TIMESTAMP, c5 TIMESTAMP, b STRING) PARTITIONED BY(part INT) -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:default -POSTHOOK: Output: default@part_change_date_group_string_group_timestamp -PREHOOK: query: insert into table part_change_date_group_string_group_timestamp partition(part=1) - values (1, '2000-12-18 08:42:30.000595596', '2000-12-18 08:42:30.000595596', '2000-12-18 08:42:30.000595596', '2000-12-18 08:42:30.000595596', '2000-12-18 08:42:30.000595596', 'original'), - (2, '2024-11-11 16:42:41.101', '2024-11-11 16:42:41.101', '2024-11-11 16:42:41.101', '2024-11-11 16:42:41.101', '2024-11-11 16:42:41.101', 'original'), - (3, '2021-09-24 03:18:32.413655165', '2021-09-24 03:18:32.413655165', '2021-09-24 03:18:32.413655165', '2021-09-24 03:18:32.413655165', '2021-09-24 03:18:32.413655165', 'original') -PREHOOK: type: QUERY -PREHOOK: Output: default@part_change_date_group_string_group_timestamp@part=1 -POSTHOOK: query: insert into table part_change_date_group_string_group_timestamp partition(part=1) - values (1, '2000-12-18 08:42:30.000595596', '2000-12-18 08:42:30.000595596', '2000-12-18 08:42:30.000595596', '2000-12-18 08:42:30.000595596', '2000-12-18 08:42:30.000595596', 'original'), - (2, '2024-11-11 16:42:41.101', '2024-11-11 16:42:41.101', '2024-11-11 16:42:41.101', '2024-11-11 16:42:41.101', '2024-11-11 16:42:41.101', 'original'), - (3, '2021-09-24 03:18:32.413655165', '2021-09-24 03:18:32.413655165', '2021-09-24 03:18:32.413655165', '2021-09-24 03:18:32.413655165', '2021-09-24 03:18:32.413655165', 'original') -POSTHOOK: type: QUERY -POSTHOOK: Output: default@part_change_date_group_string_group_timestamp@part=1 -POSTHOOK: Lineage: part_change_date_group_string_group_timestamp PARTITION(part=1).b SIMPLE [(values__tmp__table__10)values__tmp__table__10.FieldSchema(name:tmp_values_col7, type:string, comment:), ] -POSTHOOK: Lineage: part_change_date_group_string_group_timestamp PARTITION(part=1).c1 EXPRESSION [(values__tmp__table__10)values__tmp__table__10.FieldSchema(name:tmp_values_col2, type:string, comment:), ] -POSTHOOK: Lineage: part_change_date_group_string_group_timestamp PARTITION(part=1).c2 EXPRESSION [(values__tmp__table__10)values__tmp__table__10.FieldSchema(name:tmp_values_col3, type:string, comment:), ] -POSTHOOK: Lineage: part_change_date_group_string_group_timestamp PARTITION(part=1).c3 EXPRESSION [(values__tmp__table__10)values__tmp__table__10.FieldSchema(name:tmp_values_col4, type:string, comment:), ] -POSTHOOK: Lineage: part_change_date_group_string_group_timestamp PARTITION(part=1).c4 EXPRESSION [(values__tmp__table__10)values__tmp__table__10.FieldSchema(name:tmp_values_col5, type:string, comment:), ] -POSTHOOK: Lineage: part_change_date_group_string_group_timestamp PARTITION(part=1).c5 EXPRESSION [(values__tmp__table__10)values__tmp__table__10.FieldSchema(name:tmp_values_col6, type:string, comment:), ] -POSTHOOK: Lineage: part_change_date_group_string_group_timestamp PARTITION(part=1).insert_num EXPRESSION [(values__tmp__table__10)values__tmp__table__10.FieldSchema(name:tmp_values_col1, type:string, comment:), ] -_col0 _col1 _col2 _col3 _col4 _col5 _col6 -PREHOOK: query: -- Table-Non-Cascade CHANGE COLUMNS ... -alter table part_change_date_group_string_group_timestamp replace columns(insert_num int, c1 STRING, c2 CHAR(50), c3 CHAR(15), c4 VARCHAR(50), c5 VARCHAR(15), b STRING) -PREHOOK: type: ALTERTABLE_REPLACECOLS -PREHOOK: Input: default@part_change_date_group_string_group_timestamp -PREHOOK: Output: default@part_change_date_group_string_group_timestamp -POSTHOOK: query: -- Table-Non-Cascade CHANGE COLUMNS ... -alter table part_change_date_group_string_group_timestamp replace columns(insert_num int, c1 STRING, c2 CHAR(50), c3 CHAR(15), c4 VARCHAR(50), c5 VARCHAR(15), b STRING) -POSTHOOK: type: ALTERTABLE_REPLACECOLS -POSTHOOK: Input: default@part_change_date_group_string_group_timestamp -POSTHOOK: Output: default@part_change_date_group_string_group_timestamp -PREHOOK: query: insert into table part_change_date_group_string_group_timestamp partition(part=2) - values (4, '0004-09-22 18:26:29.519542222', '0004-09-22 18:26:29.519542222', '0004-09-22 18:26:29.519542222', '0004-09-22 18:26:29.519542222', '0004-09-22 18:26:29.519542222', 'new'), - (5, '1815-05-06 00:12:37.543584705', '1815-05-06 00:12:37.543584705', '1815-05-06 00:12:37.543584705', '1815-05-06 00:12:37.543584705', '1815-05-06 00:12:37.543584705', 'new'), - (6, '2007-02-09 05:17:29.368756876', '2007-02-09 05:17:29.368756876', '2007-02-09 05:17:29.368756876', '2007-02-09 05:17:29.368756876', '2007-02-09 05:17:29.368756876', 'new'), - (7, '2002-05-10 05:29:48.990818073', '2002-05-10 05:29:48.990818073', '2002-05-10 05:29:48.990818073', '2002-05-10 05:29:48.990818073', '2002-05-10 05:29:48.990818073', 'new') -PREHOOK: type: QUERY -PREHOOK: Output: default@part_change_date_group_string_group_timestamp@part=2 -POSTHOOK: query: insert into table part_change_date_group_string_group_timestamp partition(part=2) - values (4, '0004-09-22 18:26:29.519542222', '0004-09-22 18:26:29.519542222', '0004-09-22 18:26:29.519542222', '0004-09-22 18:26:29.519542222', '0004-09-22 18:26:29.519542222', 'new'), - (5, '1815-05-06 00:12:37.543584705', '1815-05-06 00:12:37.543584705', '1815-05-06 00:12:37.543584705', '1815-05-06 00:12:37.543584705', '1815-05-06 00:12:37.543584705', 'new'), - (6, '2007-02-09 05:17:29.368756876', '2007-02-09 05:17:29.368756876', '2007-02-09 05:17:29.368756876', '2007-02-09 05:17:29.368756876', '2007-02-09 05:17:29.368756876', 'new'), - (7, '2002-05-10 05:29:48.990818073', '2002-05-10 05:29:48.990818073', '2002-05-10 05:29:48.990818073', '2002-05-10 05:29:48.990818073', '2002-05-10 05:29:48.990818073', 'new') -POSTHOOK: type: QUERY -POSTHOOK: Output: default@part_change_date_group_string_group_timestamp@part=2 -POSTHOOK: Lineage: part_change_date_group_string_group_timestamp PARTITION(part=2).b SIMPLE [(values__tmp__table__11)values__tmp__table__11.FieldSchema(name:tmp_values_col7, type:string, comment:), ] -POSTHOOK: Lineage: part_change_date_group_string_group_timestamp PARTITION(part=2).c1 SIMPLE [(values__tmp__table__11)values__tmp__table__11.FieldSchema(name:tmp_values_col2, type:string, comment:), ] -POSTHOOK: Lineage: part_change_date_group_string_group_timestamp PARTITION(part=2).c2 EXPRESSION [(values__tmp__table__11)values__tmp__table__11.FieldSchema(name:tmp_values_col3, type:string, comment:), ] -POSTHOOK: Lineage: part_change_date_group_string_group_timestamp PARTITION(part=2).c3 EXPRESSION [(values__tmp__table__11)values__tmp__table__11.FieldSchema(name:tmp_values_col4, type:string, comment:), ] -POSTHOOK: Lineage: part_change_date_group_string_group_timestamp PARTITION(part=2).c4 EXPRESSION [(values__tmp__table__11)values__tmp__table__11.FieldSchema(name:tmp_values_col5, type:string, comment:), ] -POSTHOOK: Lineage: part_change_date_group_string_group_timestamp PARTITION(part=2).c5 EXPRESSION [(values__tmp__table__11)values__tmp__table__11.FieldSchema(name:tmp_values_col6, type:string, comment:), ] -POSTHOOK: Lineage: part_change_date_group_string_group_timestamp PARTITION(part=2).insert_num EXPRESSION [(values__tmp__table__11)values__tmp__table__11.FieldSchema(name:tmp_values_col1, type:string, comment:), ] -_col0 _col1 _col2 _col3 _col4 _col5 _col6 -PREHOOK: query: insert into table part_change_date_group_string_group_timestamp partition(part=1) - values (8, '6229-06-28 02:54:28.970117179', '6229-06-28 02:54:28.970117179', '6229-06-28 02:54:28.970117179', '6229-06-28 02:54:28.970117179', '6229-06-28 02:54:28.970117179', 'new'), - (9, '5966-07-09 03:30:50.597', '5966-07-09 03:30:50.597', '5966-07-09 03:30:50.597', '5966-07-09 03:30:50.597', '5966-07-09 03:30:50.597', 'new') -PREHOOK: type: QUERY -PREHOOK: Output: default@part_change_date_group_string_group_timestamp@part=1 -POSTHOOK: query: insert into table part_change_date_group_string_group_timestamp partition(part=1) - values (8, '6229-06-28 02:54:28.970117179', '6229-06-28 02:54:28.970117179', '6229-06-28 02:54:28.970117179', '6229-06-28 02:54:28.970117179', '6229-06-28 02:54:28.970117179', 'new'), - (9, '5966-07-09 03:30:50.597', '5966-07-09 03:30:50.597', '5966-07-09 03:30:50.597', '5966-07-09 03:30:50.597', '5966-07-09 03:30:50.597', 'new') -POSTHOOK: type: QUERY -POSTHOOK: Output: default@part_change_date_group_string_group_timestamp@part=1 -POSTHOOK: Lineage: part_change_date_group_string_group_timestamp PARTITION(part=1).b SIMPLE [(values__tmp__table__12)values__tmp__table__12.FieldSchema(name:tmp_values_col7, type:string, comment:), ] -POSTHOOK: Lineage: part_change_date_group_string_group_timestamp PARTITION(part=1).c1 SIMPLE [(values__tmp__table__12)values__tmp__table__12.FieldSchema(name:tmp_values_col2, type:string, comment:), ] -POSTHOOK: Lineage: part_change_date_group_string_group_timestamp PARTITION(part=1).c2 EXPRESSION [(values__tmp__table__12)values__tmp__table__12.FieldSchema(name:tmp_values_col3, type:string, comment:), ] -POSTHOOK: Lineage: part_change_date_group_string_group_timestamp PARTITION(part=1).c3 EXPRESSION [(values__tmp__table__12)values__tmp__table__12.FieldSchema(name:tmp_values_col4, type:string, comment:), ] -POSTHOOK: Lineage: part_change_date_group_string_group_timestamp PARTITION(part=1).c4 EXPRESSION [(values__tmp__table__12)values__tmp__table__12.FieldSchema(name:tmp_values_col5, type:string, comment:), ] -POSTHOOK: Lineage: part_change_date_group_string_group_timestamp PARTITION(part=1).c5 EXPRESSION [(values__tmp__table__12)values__tmp__table__12.FieldSchema(name:tmp_values_col6, type:string, comment:), ] -POSTHOOK: Lineage: part_change_date_group_string_group_timestamp PARTITION(part=1).insert_num EXPRESSION [(values__tmp__table__12)values__tmp__table__12.FieldSchema(name:tmp_values_col1, type:string, comment:), ] -_col0 _col1 _col2 _col3 _col4 _col5 _col6 -PREHOOK: query: explain -select insert_num,part,c1,c2,c3,c4,c5,b from part_change_date_group_string_group_timestamp -PREHOOK: type: QUERY -POSTHOOK: query: explain -select insert_num,part,c1,c2,c3,c4,c5,b from part_change_date_group_string_group_timestamp -POSTHOOK: type: QUERY -Explain -Plan optimized by CBO. - -Stage-0 - Fetch Operator - limit:-1 - Stage-1 - Map 1 vectorized, llap - File Output Operator [FS_4] - Select Operator [SEL_3] (rows=9 width=4) - Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7"] - TableScan [TS_0] (rows=9 width=534) - default@part_change_date_group_string_group_timestamp,part_change_date_group_string_group_timestamp,Tbl:COMPLETE,Col:PARTIAL,Output:["insert_num","c1","c2","c3","c4","c5","b"] - -PREHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,b from part_change_date_group_string_group_timestamp -PREHOOK: type: QUERY -PREHOOK: Input: default@part_change_date_group_string_group_timestamp -PREHOOK: Input: default@part_change_date_group_string_group_timestamp@part=1 -PREHOOK: Input: default@part_change_date_group_string_group_timestamp@part=2 -#### A masked pattern was here #### -POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,b from part_change_date_group_string_group_timestamp -POSTHOOK: type: QUERY -POSTHOOK: Input: default@part_change_date_group_string_group_timestamp -POSTHOOK: Input: default@part_change_date_group_string_group_timestamp@part=1 -POSTHOOK: Input: default@part_change_date_group_string_group_timestamp@part=2 -#### A masked pattern was here #### -insert_num part c1 c2 c3 c4 c5 b -1 1 2000-12-18 08:42:30.000595596 2000-12-18 08:42:30.000595596 2000-12-18 08:4 2000-12-18 08:42:30.000595596 2000-12-18 08:4 original -2 1 2024-11-11 16:42:41.101 2024-11-11 16:42:41.101 2024-11-11 16:4 2024-11-11 16:42:41.101 2024-11-11 16:4 original -3 1 2021-09-24 03:18:32.413655165 2021-09-24 03:18:32.413655165 2021-09-24 03:1 2021-09-24 03:18:32.413655165 2021-09-24 03:1 original -4 2 0004-09-22 18:26:29.519542222 0004-09-22 18:26:29.519542222 0004-09-22 18:2 0004-09-22 18:26:29.519542222 0004-09-22 18:2 new -5 2 1815-05-06 00:12:37.543584705 1815-05-06 00:12:37.543584705 1815-05-06 00:1 1815-05-06 00:12:37.543584705 1815-05-06 00:1 new -6 2 2007-02-09 05:17:29.368756876 2007-02-09 05:17:29.368756876 2007-02-09 05:1 2007-02-09 05:17:29.368756876 2007-02-09 05:1 new -7 2 2002-05-10 05:29:48.990818073 2002-05-10 05:29:48.990818073 2002-05-10 05:2 2002-05-10 05:29:48.990818073 2002-05-10 05:2 new -8 1 6229-06-28 02:54:28.970117179 6229-06-28 02:54:28.970117179 6229-06-28 02:5 6229-06-28 02:54:28.970117179 6229-06-28 02:5 new -9 1 5966-07-09 03:30:50.597 5966-07-09 03:30:50.597 5966-07-09 03:3 5966-07-09 03:30:50.597 5966-07-09 03:3 new -PREHOOK: query: drop table part_change_date_group_string_group_timestamp -PREHOOK: type: DROPTABLE -PREHOOK: Input: default@part_change_date_group_string_group_timestamp -PREHOOK: Output: default@part_change_date_group_string_group_timestamp -POSTHOOK: query: drop table part_change_date_group_string_group_timestamp -POSTHOOK: type: DROPTABLE -POSTHOOK: Input: default@part_change_date_group_string_group_timestamp -POSTHOOK: Output: default@part_change_date_group_string_group_timestamp -PREHOOK: query: -- --- SUBSECTION: ALTER TABLE CHANGE COLUMNS for DATE_GROUP -> STRING_GROUP: DATE, (STRING, CHAR, CHAR trunc, VARCHAR, VARCHAR trunc) --- -CREATE TABLE part_change_date_group_string_group_date(insert_num int, c1 DATE, c2 DATE, c3 DATE, c4 DATE, c5 DATE, b STRING) PARTITIONED BY(part INT) -PREHOOK: type: CREATETABLE -PREHOOK: Output: database:default -PREHOOK: Output: default@part_change_date_group_string_group_date -POSTHOOK: query: -- --- SUBSECTION: ALTER TABLE CHANGE COLUMNS for DATE_GROUP -> STRING_GROUP: DATE, (STRING, CHAR, CHAR trunc, VARCHAR, VARCHAR trunc) --- -CREATE TABLE part_change_date_group_string_group_date(insert_num int, c1 DATE, c2 DATE, c3 DATE, c4 DATE, c5 DATE, b STRING) PARTITIONED BY(part INT) -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:default -POSTHOOK: Output: default@part_change_date_group_string_group_date -PREHOOK: query: insert into table part_change_date_group_string_group_date partition(part=1) - values (1, '2000-12-18', '2000-12-18', '2000-12-18', '2000-12-18', '2000-12-18', 'original'), - (2, '2024-11-11', '2024-11-11', '2024-11-11', '2024-11-11', '2024-11-11', 'original'), - (3, '2021-09-24', '2021-09-24', '2021-09-24', '2021-09-24', '2021-09-24', 'original') -PREHOOK: type: QUERY -PREHOOK: Output: default@part_change_date_group_string_group_date@part=1 -POSTHOOK: query: insert into table part_change_date_group_string_group_date partition(part=1) - values (1, '2000-12-18', '2000-12-18', '2000-12-18', '2000-12-18', '2000-12-18', 'original'), - (2, '2024-11-11', '2024-11-11', '2024-11-11', '2024-11-11', '2024-11-11', 'original'), - (3, '2021-09-24', '2021-09-24', '2021-09-24', '2021-09-24', '2021-09-24', 'original') -POSTHOOK: type: QUERY -POSTHOOK: Output: default@part_change_date_group_string_group_date@part=1 -POSTHOOK: Lineage: part_change_date_group_string_group_date PARTITION(part=1).b SIMPLE [(values__tmp__table__13)values__tmp__table__13.FieldSchema(name:tmp_values_col7, type:string, comment:), ] -POSTHOOK: Lineage: part_change_date_group_string_group_date PARTITION(part=1).c1 EXPRESSION [(values__tmp__table__13)values__tmp__table__13.FieldSchema(name:tmp_values_col2, type:string, comment:), ] -POSTHOOK: Lineage: part_change_date_group_string_group_date PARTITION(part=1).c2 EXPRESSION [(values__tmp__table__13)values__tmp__table__13.FieldSchema(name:tmp_values_col3, type:string, comment:), ] -POSTHOOK: Lineage: part_change_date_group_string_group_date PARTITION(part=1).c3 EXPRESSION [(values__tmp__table__13)values__tmp__table__13.FieldSchema(name:tmp_values_col4, type:string, comment:), ] -POSTHOOK: Lineage: part_change_date_group_string_group_date PARTITION(part=1).c4 EXPRESSION [(values__tmp__table__13)values__tmp__table__13.FieldSchema(name:tmp_values_col5, type:string, comment:), ] -POSTHOOK: Lineage: part_change_date_group_string_group_date PARTITION(part=1).c5 EXPRESSION [(values__tmp__table__13)values__tmp__table__13.FieldSchema(name:tmp_values_col6, type:string, comment:), ] -POSTHOOK: Lineage: part_change_date_group_string_group_date PARTITION(part=1).insert_num EXPRESSION [(values__tmp__table__13)values__tmp__table__13.FieldSchema(name:tmp_values_col1, type:string, comment:), ] -_col0 _col1 _col2 _col3 _col4 _col5 _col6 -PREHOOK: query: -- Table-Non-Cascade CHANGE COLUMNS ... -alter table part_change_date_group_string_group_date replace columns(insert_num int, c1 STRING, c2 CHAR(50), c3 CHAR(15), c4 VARCHAR(50), c5 VARCHAR(15), b STRING) -PREHOOK: type: ALTERTABLE_REPLACECOLS -PREHOOK: Input: default@part_change_date_group_string_group_date -PREHOOK: Output: default@part_change_date_group_string_group_date -POSTHOOK: query: -- Table-Non-Cascade CHANGE COLUMNS ... -alter table part_change_date_group_string_group_date replace columns(insert_num int, c1 STRING, c2 CHAR(50), c3 CHAR(15), c4 VARCHAR(50), c5 VARCHAR(15), b STRING) -POSTHOOK: type: ALTERTABLE_REPLACECOLS -POSTHOOK: Input: default@part_change_date_group_string_group_date -POSTHOOK: Output: default@part_change_date_group_string_group_date -PREHOOK: query: insert into table part_change_date_group_string_group_date partition(part=2) - values (4, '0004-09-22', '0004-09-22', '0004-09-22', '0004-09-22', '0004-09-22', 'new'), - (5, '1815-05-06', '1815-05-06', '1815-05-06', '1815-05-06', '1815-05-06', 'new'), - (6, '2007-02-09', '2007-02-09', '2007-02-09', '2007-02-09', '2007-02-09', 'new'), - (7, '2002-05-10', '2002-05-10', '2002-05-10', '2002-05-10', '2002-05-10', 'new'), - (8, '6229-06-28', '6229-06-28', '6229-06-28', '6229-06-28', '6229-06-28', 'new'), - (9, '5966-07-09', '5966-07-09', '5966-07-09', '5966-07-09', '5966-07-09', 'new') -PREHOOK: type: QUERY -PREHOOK: Output: default@part_change_date_group_string_group_date@part=2 -POSTHOOK: query: insert into table part_change_date_group_string_group_date partition(part=2) - values (4, '0004-09-22', '0004-09-22', '0004-09-22', '0004-09-22', '0004-09-22', 'new'), - (5, '1815-05-06', '1815-05-06', '1815-05-06', '1815-05-06', '1815-05-06', 'new'), - (6, '2007-02-09', '2007-02-09', '2007-02-09', '2007-02-09', '2007-02-09', 'new'), - (7, '2002-05-10', '2002-05-10', '2002-05-10', '2002-05-10', '2002-05-10', 'new'), - (8, '6229-06-28', '6229-06-28', '6229-06-28', '6229-06-28', '6229-06-28', 'new'), - (9, '5966-07-09', '5966-07-09', '5966-07-09', '5966-07-09', '5966-07-09', 'new') -POSTHOOK: type: QUERY -POSTHOOK: Output: default@part_change_date_group_string_group_date@part=2 -POSTHOOK: Lineage: part_change_date_group_string_group_date PARTITION(part=2).b SIMPLE [(values__tmp__table__14)values__tmp__table__14.FieldSchema(name:tmp_values_col7, type:string, comment:), ] -POSTHOOK: Lineage: part_change_date_group_string_group_date PARTITION(part=2).c1 SIMPLE [(values__tmp__table__14)values__tmp__table__14.FieldSchema(name:tmp_values_col2, type:string, comment:), ] -POSTHOOK: Lineage: part_change_date_group_string_group_date PARTITION(part=2).c2 EXPRESSION [(values__tmp__table__14)values__tmp__table__14.FieldSchema(name:tmp_values_col3, type:string, comment:), ] -POSTHOOK: Lineage: part_change_date_group_string_group_date PARTITION(part=2).c3 EXPRESSION [(values__tmp__table__14)values__tmp__table__14.FieldSchema(name:tmp_values_col4, type:string, comment:), ] -POSTHOOK: Lineage: part_change_date_group_string_group_date PARTITION(part=2).c4 EXPRESSION [(values__tmp__table__14)values__tmp__table__14.FieldSchema(name:tmp_values_col5, type:string, comment:), ] -POSTHOOK: Lineage: part_change_date_group_string_group_date PARTITION(part=2).c5 EXPRESSION [(values__tmp__table__14)values__tmp__table__14.FieldSchema(name:tmp_values_col6, type:string, comment:), ] -POSTHOOK: Lineage: part_change_date_group_string_group_date PARTITION(part=2).insert_num EXPRESSION [(values__tmp__table__14)values__tmp__table__14.FieldSchema(name:tmp_values_col1, type:string, comment:), ] -_col0 _col1 _col2 _col3 _col4 _col5 _col6 -PREHOOK: query: explain -select insert_num,part,c1,c2,c3,c4,c5,b from part_change_date_group_string_group_date -PREHOOK: type: QUERY -POSTHOOK: query: explain -select insert_num,part,c1,c2,c3,c4,c5,b from part_change_date_group_string_group_date -POSTHOOK: type: QUERY -Explain -Plan optimized by CBO. - -Stage-0 - Fetch Operator - limit:-1 - Stage-1 - Map 1 vectorized, llap - File Output Operator [FS_4] - Select Operator [SEL_3] (rows=9 width=4) - Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7"] - TableScan [TS_0] (rows=9 width=533) - default@part_change_date_group_string_group_date,part_change_date_group_string_group_date,Tbl:COMPLETE,Col:PARTIAL,Output:["insert_num","c1","c2","c3","c4","c5","b"] - -PREHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,b from part_change_date_group_string_group_date -PREHOOK: type: QUERY -PREHOOK: Input: default@part_change_date_group_string_group_date -PREHOOK: Input: default@part_change_date_group_string_group_date@part=1 -PREHOOK: Input: default@part_change_date_group_string_group_date@part=2 -#### A masked pattern was here #### -POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,b from part_change_date_group_string_group_date -POSTHOOK: type: QUERY -POSTHOOK: Input: default@part_change_date_group_string_group_date -POSTHOOK: Input: default@part_change_date_group_string_group_date@part=1 -POSTHOOK: Input: default@part_change_date_group_string_group_date@part=2 -#### A masked pattern was here #### -insert_num part c1 c2 c3 c4 c5 b -1 1 2000-12-18 2000-12-18 2000-12-18 2000-12-18 2000-12-18 original -2 1 2024-11-11 2024-11-11 2024-11-11 2024-11-11 2024-11-11 original -3 1 2021-09-24 2021-09-24 2021-09-24 2021-09-24 2021-09-24 original -4 2 0004-09-22 0004-09-22 0004-09-22 0004-09-22 0004-09-22 new -5 2 1815-05-06 1815-05-06 1815-05-06 1815-05-06 1815-05-06 new -6 2 2007-02-09 2007-02-09 2007-02-09 2007-02-09 2007-02-09 new -7 2 2002-05-10 2002-05-10 2002-05-10 2002-05-10 2002-05-10 new -8 2 6229-06-28 6229-06-28 6229-06-28 6229-06-28 6229-06-28 new -9 2 5966-07-09 5966-07-09 5966-07-09 5966-07-09 5966-07-09 new -PREHOOK: query: drop table part_change_date_group_string_group_date -PREHOOK: type: DROPTABLE -PREHOOK: Input: default@part_change_date_group_string_group_date -PREHOOK: Output: default@part_change_date_group_string_group_date -POSTHOOK: query: drop table part_change_date_group_string_group_date -POSTHOOK: type: DROPTABLE -POSTHOOK: Input: default@part_change_date_group_string_group_date -POSTHOOK: Output: default@part_change_date_group_string_group_date -PREHOOK: query: ------------------------------------------------------------------------------------------ --- SECTION: ALTER TABLE CHANGE COLUMNS for NUMERIC_GROUP -> STRING_GROUP --- --- --- --- SUBSECTION: ALTER TABLE CHANGE COLUMNS for NUMERIC_GROUP -> STRING_GROUP: (TINYINT, SMALLINT, INT, BIGINT), STRING --- -CREATE TABLE part_change_numeric_group_string_group_multi_ints_string(insert_num int, c1 tinyint, c2 smallint, c3 int, c4 bigint, b STRING) PARTITIONED BY(part INT) -PREHOOK: type: CREATETABLE -PREHOOK: Output: database:default -PREHOOK: Output: default@part_change_numeric_group_string_group_multi_ints_string -POSTHOOK: query: ------------------------------------------------------------------------------------------ --- SECTION: ALTER TABLE CHANGE COLUMNS for NUMERIC_GROUP -> STRING_GROUP --- --- --- --- SUBSECTION: ALTER TABLE CHANGE COLUMNS for NUMERIC_GROUP -> STRING_GROUP: (TINYINT, SMALLINT, INT, BIGINT), STRING --- -CREATE TABLE part_change_numeric_group_string_group_multi_ints_string(insert_num int, c1 tinyint, c2 smallint, c3 int, c4 bigint, b STRING) PARTITIONED BY(part INT) -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:default -POSTHOOK: Output: default@part_change_numeric_group_string_group_multi_ints_string -PREHOOK: query: insert into table part_change_numeric_group_string_group_multi_ints_string partition(part=1) - values (1, 45, 1000, 483777, -23866739993, 'original'), - (2, -2, -6737, 56, 28899333, 'original'), - (3, -255, 4957, 832222222, 9000000000, 'original'), - (4, 0, 20435, 847492223, -999999999999, 'original') -PREHOOK: type: QUERY -PREHOOK: Output: default@part_change_numeric_group_string_group_multi_ints_string@part=1 -POSTHOOK: query: insert into table part_change_numeric_group_string_group_multi_ints_string partition(part=1) - values (1, 45, 1000, 483777, -23866739993, 'original'), - (2, -2, -6737, 56, 28899333, 'original'), - (3, -255, 4957, 832222222, 9000000000, 'original'), - (4, 0, 20435, 847492223, -999999999999, 'original') -POSTHOOK: type: QUERY -POSTHOOK: Output: default@part_change_numeric_group_string_group_multi_ints_string@part=1 -POSTHOOK: Lineage: part_change_numeric_group_string_group_multi_ints_string PARTITION(part=1).b SIMPLE [(values__tmp__table__15)values__tmp__table__15.FieldSchema(name:tmp_values_col6, type:string, comment:), ] -POSTHOOK: Lineage: part_change_numeric_group_string_group_multi_ints_string PARTITION(part=1).c1 EXPRESSION [(values__tmp__table__15)values__tmp__table__15.FieldSchema(name:tmp_values_col2, type:string, comment:), ] -POSTHOOK: Lineage: part_change_numeric_group_string_group_multi_ints_string PARTITION(part=1).c2 EXPRESSION [(values__tmp__table__15)values__tmp__table__15.FieldSchema(name:tmp_values_col3, type:string, comment:), ] -POSTHOOK: Lineage: part_change_numeric_group_string_group_multi_ints_string PARTITION(part=1).c3 EXPRESSION [(values__tmp__table__15)values__tmp__table__15.FieldSchema(name:tmp_values_col4, type:string, comment:), ] -POSTHOOK: Lineage: part_change_numeric_group_string_group_multi_ints_string PARTITION(part=1).c4 EXPRESSION [(values__tmp__table__15)values__tmp__table__15.FieldSchema(name:tmp_values_col5, type:string, comment:), ] -POSTHOOK: Lineage: part_change_numeric_group_string_group_multi_ints_string PARTITION(part=1).insert_num EXPRESSION [(values__tmp__table__15)values__tmp__table__15.FieldSchema(name:tmp_values_col1, type:string, comment:), ] -_col0 _col1 _col2 _col3 _col4 _col5 -PREHOOK: query: select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_string -PREHOOK: type: QUERY -PREHOOK: Input: default@part_change_numeric_group_string_group_multi_ints_string -PREHOOK: Input: default@part_change_numeric_group_string_group_multi_ints_string@part=1 -#### A masked pattern was here #### -POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_string -POSTHOOK: type: QUERY -POSTHOOK: Input: default@part_change_numeric_group_string_group_multi_ints_string -POSTHOOK: Input: default@part_change_numeric_group_string_group_multi_ints_string@part=1 -#### A masked pattern was here #### -insert_num part c1 c2 c3 c4 b -1 1 45 1000 483777 -23866739993 original -2 1 -2 -6737 56 28899333 original -3 1 NULL 4957 832222222 9000000000 original -4 1 0 20435 847492223 -999999999999 original -PREHOOK: query: -- Table-Non-Cascade CHANGE COLUMNS ... -alter table part_change_numeric_group_string_group_multi_ints_string replace columns (insert_num int, c1 STRING, c2 STRING, c3 STRING, c4 STRING, b STRING) -PREHOOK: type: ALTERTABLE_REPLACECOLS -PREHOOK: Input: default@part_change_numeric_group_string_group_multi_ints_string -PREHOOK: Output: default@part_change_numeric_group_string_group_multi_ints_string -POSTHOOK: query: -- Table-Non-Cascade CHANGE COLUMNS ... -alter table part_change_numeric_group_string_group_multi_ints_string replace columns (insert_num int, c1 STRING, c2 STRING, c3 STRING, c4 STRING, b STRING) -POSTHOOK: type: ALTERTABLE_REPLACECOLS -POSTHOOK: Input: default@part_change_numeric_group_string_group_multi_ints_string -POSTHOOK: Output: default@part_change_numeric_group_string_group_multi_ints_string -PREHOOK: query: insert into table part_change_numeric_group_string_group_multi_ints_string partition(part) - values (5, '2000', '72909', '3244222', '-93222', 'new', 2), - (6, '1', '200', '2323322', '5430907', 'new', 2), - (7, '256', '32768', '31889', '470614135', 'new', 2), - (8, '5555', '40000', '-719017797', '810662019', 'new', 2), - (9, '100', '5000', '5443', '0', 'new', 1), - (10, '17', '90000', '754072151', '3289094', 'new', 1) -PREHOOK: type: QUERY -PREHOOK: Output: default@part_change_numeric_group_string_group_multi_ints_string -POSTHOOK: query: insert into table part_change_numeric_group_string_group_multi_ints_string partition(part) - values (5, '2000', '72909', '3244222', '-93222', 'new', 2), - (6, '1', '200', '2323322', '5430907', 'new', 2), - (7, '256', '32768', '31889', '470614135', 'new', 2), - (8, '5555', '40000', '-719017797', '810662019', 'new', 2), - (9, '100', '5000', '5443', '0', 'new', 1), - (10, '17', '90000', '754072151', '3289094', 'new', 1) -POSTHOOK: type: QUERY -POSTHOOK: Output: default@part_change_numeric_group_string_group_multi_ints_string@part=1 -POSTHOOK: Output: default@part_change_numeric_group_string_group_multi_ints_string@part=2 -POSTHOOK: Lineage: part_change_numeric_group_string_group_multi_ints_string PARTITION(part=1).b SIMPLE [(values__tmp__table__16)values__tmp__table__16.FieldSchema(name:tmp_values_col6, type:string, comment:), ] -POSTHOOK: Lineage: part_change_numeric_group_string_group_multi_ints_string PARTITION(part=1).c1 SIMPLE [(values__tmp__table__16)values__tmp__table__16.FieldSchema(name:tmp_values_col2, type:string, comment:), ] -POSTHOOK: Lineage: part_change_numeric_group_string_group_multi_ints_string PARTITION(part=1).c2 SIMPLE [(values__tmp__table__16)values__tmp__table__16.FieldSchema(name:tmp_values_col3, type:string, comment:), ] -POSTHOOK: Lineage: part_change_numeric_group_string_group_multi_ints_string PARTITION(part=1).c3 SIMPLE [(values__tmp__table__16)values__tmp__table__16.FieldSchema(name:tmp_values_col4, type:string, comment:), ] -POSTHOOK: Lineage: part_change_numeric_group_string_group_multi_ints_string PARTITION(part=1).c4 SIMPLE [(values__tmp__table__16)values__tmp__table__16.FieldSchema(name:tmp_values_col5, type:string, comment:), ] -POSTHOOK: Lineage: part_change_numeric_group_string_group_multi_ints_string PARTITION(part=1).insert_num EXPRESSION [(values__tmp__table__16)values__tmp__table__16.FieldSchema(name:tmp_values_col1, type:string, comment:), ] -POSTHOOK: Lineage: part_change_numeric_group_string_group_multi_ints_string PARTITION(part=2).b SIMPLE [(values__tmp__table__16)values__tmp__table__16.FieldSchema(name:tmp_values_col6, type:string, comment:), ] -POSTHOOK: Lineage: part_change_numeric_group_string_group_multi_ints_string PARTITION(part=2).c1 SIMPLE [(values__tmp__table__16)values__tmp__table__16.FieldSchema(name:tmp_values_col2, type:string, comment:), ] -POSTHOOK: Lineage: part_change_numeric_group_string_group_multi_ints_string PARTITION(part=2).c2 SIMPLE [(values__tmp__table__16)values__tmp__table__16.FieldSchema(name:tmp_values_col3, type:string, comment:), ] -POSTHOOK: Lineage: part_change_numeric_group_string_group_multi_ints_string PARTITION(part=2).c3 SIMPLE [(values__tmp__table__16)values__tmp__table__16.FieldSchema(name:tmp_values_col4, type:string, comment:), ] -POSTHOOK: Lineage: part_change_numeric_group_string_group_multi_ints_string PARTITION(part=2).c4 SIMPLE [(values__tmp__table__16)values__tmp__table__16.FieldSchema(name:tmp_values_col5, type:string, comment:), ] -POSTHOOK: Lineage: part_change_numeric_group_string_group_multi_ints_string PARTITION(part=2).insert_num EXPRESSION [(values__tmp__table__16)values__tmp__table__16.FieldSchema(name:tmp_values_col1, type:string, comment:), ] -_col0 _col1 _col2 _col3 _col4 _col5 _col6 -PREHOOK: query: explain -select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_string -PREHOOK: type: QUERY -POSTHOOK: query: explain -select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_string -POSTHOOK: type: QUERY -Explain -Plan optimized by CBO. - -Stage-0 - Fetch Operator - limit:-1 - Stage-1 - Map 1 vectorized, llap - File Output Operator [FS_4] - Select Operator [SEL_3] (rows=10 width=4) - Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6"] - TableScan [TS_0] (rows=10 width=317) - default@part_change_numeric_group_string_group_multi_ints_string,part_change_numeric_group_string_group_multi_ints_string,Tbl:COMPLETE,Col:PARTIAL,Output:["insert_num","c1","c2","c3","c4","b"] - -PREHOOK: query: select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_string -PREHOOK: type: QUERY -PREHOOK: Input: default@part_change_numeric_group_string_group_multi_ints_string -PREHOOK: Input: default@part_change_numeric_group_string_group_multi_ints_string@part=1 -PREHOOK: Input: default@part_change_numeric_group_string_group_multi_ints_string@part=2 -#### A masked pattern was here #### -POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_string -POSTHOOK: type: QUERY -POSTHOOK: Input: default@part_change_numeric_group_string_group_multi_ints_string -POSTHOOK: Input: default@part_change_numeric_group_string_group_multi_ints_string@part=1 -POSTHOOK: Input: default@part_change_numeric_group_string_group_multi_ints_string@part=2 -#### A masked pattern was here #### -insert_num part c1 c2 c3 c4 b -1 1 45 1000 483777 -23866739993 original -10 1 17 90000 754072151 3289094 new -2 1 -2 -6737 56 28899333 original -3 1 NULL 4957 832222222 9000000000 original -4 1 0 20435 847492223 -999999999999 original -5 2 2000 72909 3244222 -93222 new -6 2 1 200 2323322 5430907 new -7 2 256 32768 31889 470614135 new -8 2 5555 40000 -719017797 810662019 new -9 1 100 5000 5443 0 new -PREHOOK: query: drop table part_change_numeric_group_string_group_multi_ints_string -PREHOOK: type: DROPTABLE -PREHOOK: Input: default@part_change_numeric_group_string_group_multi_ints_string -PREHOOK: Output: default@part_change_numeric_group_string_group_multi_ints_string -POSTHOOK: query: drop table part_change_numeric_group_string_group_multi_ints_string -POSTHOOK: type: DROPTABLE -POSTHOOK: Input: default@part_change_numeric_group_string_group_multi_ints_string -POSTHOOK: Output: default@part_change_numeric_group_string_group_multi_ints_string -PREHOOK: query: -- --- SUBSECTION: ALTER TABLE CHANGE COLUMNS for NUMERIC_GROUP -> STRING_GROUP: (TINYINT, SMALLINT, INT, BIGINT), CHAR --- -CREATE TABLE part_change_numeric_group_string_group_multi_ints_char(insert_num int, c1 tinyint, c2 smallint, c3 int, c4 bigint, b STRING) PARTITIONED BY(part INT) -PREHOOK: type: CREATETABLE -PREHOOK: Output: database:default -PREHOOK: Output: default@part_change_numeric_group_string_group_multi_ints_char -POSTHOOK: query: -- --- SUBSECTION: ALTER TABLE CHANGE COLUMNS for NUMERIC_GROUP -> STRING_GROUP: (TINYINT, SMALLINT, INT, BIGINT), CHAR --- -CREATE TABLE part_change_numeric_group_string_group_multi_ints_char(insert_num int, c1 tinyint, c2 smallint, c3 int, c4 bigint, b STRING) PARTITIONED BY(part INT) -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:default -POSTHOOK: Output: default@part_change_numeric_group_string_group_multi_ints_char -PREHOOK: query: insert into table part_change_numeric_group_string_group_multi_ints_char partition(part=1) - values (1, 45, 1000, 483777, -23866739993, 'original'), - (2, -2, -6737, 56, 28899333, 'original'), - (3, -255, 4957, 832222222, 9000000000, 'original'), - (4, 0, 20435, 847492223, -999999999999, 'original') -PREHOOK: type: QUERY -PREHOOK: Output: default@part_change_numeric_group_string_group_multi_ints_char@part=1 -POSTHOOK: query: insert into table part_change_numeric_group_string_group_multi_ints_char partition(part=1) - values (1, 45, 1000, 483777, -23866739993, 'original'), - (2, -2, -6737, 56, 28899333, 'original'), - (3, -255, 4957, 832222222, 9000000000, 'original'), - (4, 0, 20435, 847492223, -999999999999, 'original') -POSTHOOK: type: QUERY -POSTHOOK: Output: default@part_change_numeric_group_string_group_multi_ints_char@part=1 -POSTHOOK: Lineage: part_change_numeric_group_string_group_multi_ints_char PARTITION(part=1).b SIMPLE [(values__tmp__table__17)values__tmp__table__17.FieldSchema(name:tmp_values_col6, type:string, comment:), ] -POSTHOOK: Lineage: part_change_numeric_group_string_group_multi_ints_char PARTITION(part=1).c1 EXPRESSION [(values__tmp__table__17)values__tmp__table__17.FieldSchema(name:tmp_values_col2, type:string, comment:), ] -POSTHOOK: Lineage: part_change_numeric_group_string_group_multi_ints_char PARTITION(part=1).c2 EXPRESSION [(values__tmp__table__17)values__tmp__table__17.FieldSchema(name:tmp_values_col3, type:string, comment:), ] -POSTHOOK: Lineage: part_change_numeric_group_string_group_multi_ints_char PARTITION(part=1).c3 EXPRESSION [(values__tmp__table__17)values__tmp__table__17.FieldSchema(name:tmp_values_col4, type:string, comment:), ] -POSTHOOK: Lineage: part_change_numeric_group_string_group_multi_ints_char PARTITION(part=1).c4 EXPRESSION [(values__tmp__table__17)values__tmp__table__17.FieldSchema(name:tmp_values_col5, type:string, comment:), ] -POSTHOOK: Lineage: part_change_numeric_group_string_group_multi_ints_char PARTITION(part=1).insert_num EXPRESSION [(values__tmp__table__17)values__tmp__table__17.FieldSchema(name:tmp_values_col1, type:string, comment:), ] -_col0 _col1 _col2 _col3 _col4 _col5 -PREHOOK: query: select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_char -PREHOOK: type: QUERY -PREHOOK: Input: default@part_change_numeric_group_string_group_multi_ints_char -PREHOOK: Input: default@part_change_numeric_group_string_group_multi_ints_char@part=1 -#### A masked pattern was here #### -POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_char -POSTHOOK: type: QUERY -POSTHOOK: Input: default@part_change_numeric_group_string_group_multi_ints_char -POSTHOOK: Input: default@part_change_numeric_group_string_group_multi_ints_char@part=1 -#### A masked pattern was here #### -insert_num part c1 c2 c3 c4 b -1 1 45 1000 483777 -23866739993 original -2 1 -2 -6737 56 28899333 original -3 1 NULL 4957 832222222 9000000000 original -4 1 0 20435 847492223 -999999999999 original -PREHOOK: query: -- Table-Non-Cascade CHANGE COLUMNS ... -alter table part_change_numeric_group_string_group_multi_ints_char replace columns (insert_num int, c1 CHAR(50), c2 CHAR(50), c3 CHAR(50), c4 CHAR(50), b STRING) -PREHOOK: type: ALTERTABLE_REPLACECOLS -PREHOOK: Input: default@part_change_numeric_group_string_group_multi_ints_char -PREHOOK: Output: default@part_change_numeric_group_string_group_multi_ints_char -POSTHOOK: query: -- Table-Non-Cascade CHANGE COLUMNS ... -alter table part_change_numeric_group_string_group_multi_ints_char replace columns (insert_num int, c1 CHAR(50), c2 CHAR(50), c3 CHAR(50), c4 CHAR(50), b STRING) -POSTHOOK: type: ALTERTABLE_REPLACECOLS -POSTHOOK: Input: default@part_change_numeric_group_string_group_multi_ints_char -POSTHOOK: Output: default@part_change_numeric_group_string_group_multi_ints_char -PREHOOK: query: insert into table part_change_numeric_group_string_group_multi_ints_char partition(part) - values (5, '2000', '72909', '3244222', '-93222', 'new', 2), - (6, '1', '200', '2323322', '5430907', 'new', 2), - (7, '256', '32768', '31889', '470614135', 'new', 2), - (8, '5555', '40000', '-719017797', '810662019', 'new', 2), - (9, '100', '5000', '5443', '0', 'new', 1), - (10, '17', '90000', '754072151', '3289094', 'new', 1) -PREHOOK: type: QUERY -PREHOOK: Output: default@part_change_numeric_group_string_group_multi_ints_char -POSTHOOK: query: insert into table part_change_numeric_group_string_group_multi_ints_char partition(part) - values (5, '2000', '72909', '3244222', '-93222', 'new', 2), - (6, '1', '200', '2323322', '5430907', 'new', 2), - (7, '256', '32768', '31889', '470614135', 'new', 2), - (8, '5555', '40000', '-719017797', '810662019', 'new', 2), - (9, '100', '5000', '5443', '0', 'new', 1), - (10, '17', '90000', '754072151', '3289094', 'new', 1) -POSTHOOK: type: QUERY -POSTHOOK: Output: default@part_change_numeric_group_string_group_multi_ints_char@part=1 -POSTHOOK: Output: default@part_change_numeric_group_string_group_multi_ints_char@part=2 -POSTHOOK: Lineage: part_change_numeric_group_string_group_multi_ints_char PARTITION(part=1).b SIMPLE [(values__tmp__table__18)values__tmp__table__18.FieldSchema(name:tmp_values_col6, type:string, comment:), ] -POSTHOOK: Lineage: part_change_numeric_group_string_group_multi_ints_char PARTITION(part=1).c1 EXPRESSION [(values__tmp__table__18)values__tmp__table__18.FieldSchema(name:tmp_values_col2, type:string, comment:), ] -POSTHOOK: Lineage: part_change_numeric_group_string_group_multi_ints_char PARTITION(part=1).c2 EXPRESSION [(values__tmp__table__18)values__tmp__table__18.FieldSchema(name:tmp_values_col3, type:string, comment:), ] -POSTHOOK: Lineage: part_change_numeric_group_string_group_multi_ints_char PARTITION(part=1).c3 EXPRESSION [(values__tmp__table__18)values__tmp__table__18.FieldSchema(name:tmp_values_col4, type:string, comment:), ] -POSTHOOK: Lineage: part_change_numeric_group_string_group_multi_ints_char PARTITION(part=1).c4 EXPRESSION [(values__tmp__table__18)values__tmp__table__18.FieldSchema(name:tmp_values_col5, type:string, comment:), ] -POSTHOOK: Lineage: part_change_numeric_group_string_group_multi_ints_char PARTITION(part=1).insert_num EXPRESSION [(values__tmp__table__18)values__tmp__table__18.FieldSchema(name:tmp_values_col1, type:string, comment:), ] -POSTHOOK: Lineage: part_change_numeric_group_string_group_multi_ints_char PARTITION(part=2).b SIMPLE [(values__tmp__table__18)values__tmp__table__18.FieldSchema(name:tmp_values_col6, type:string, comment:), ] -POSTHOOK: Lineage: part_change_numeric_group_string_group_multi_ints_char PARTITION(part=2).c1 EXPRESSION [(values__tmp__table__18)values__tmp__table__18.FieldSchema(name:tmp_values_col2, type:string, comment:), ] -POSTHOOK: Lineage: part_change_numeric_group_string_group_multi_ints_char PARTITION(part=2).c2 EXPRESSION [(values__tmp__table__18)values__tmp__table__18.FieldSchema(name:tmp_values_col3, type:string, comment:), ] -POSTHOOK: Lineage: part_change_numeric_group_string_group_multi_ints_char PARTITION(part=2).c3 EXPRESSION [(values__tmp__table__18)values__tmp__table__18.FieldSchema(name:tmp_values_col4, type:string, comment:), ] -POSTHOOK: Lineage: part_change_numeric_group_string_group_multi_ints_char PARTITION(part=2).c4 EXPRESSION [(values__tmp__table__18)values__tmp__table__18.FieldSchema(name:tmp_values_col5, type:string, comment:), ] -POSTHOOK: Lineage: part_change_numeric_group_string_group_multi_ints_char PARTITION(part=2).insert_num EXPRESSION [(values__tmp__table__18)values__tmp__table__18.FieldSchema(name:tmp_values_col1, type:string, comment:), ] -_col0 _col1 _col2 _col3 _col4 _col5 _col6 -PREHOOK: query: explain -select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_char -PREHOOK: type: QUERY -POSTHOOK: query: explain -select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_char -POSTHOOK: type: QUERY -Explain -Plan optimized by CBO. - -Stage-0 - Fetch Operator - limit:-1 - Stage-1 - Map 1 vectorized, llap - File Output Operator [FS_4] - Select Operator [SEL_3] (rows=10 width=4) - Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6"] - TableScan [TS_0] (rows=10 width=426) - default@part_change_numeric_group_string_group_multi_ints_char,part_change_numeric_group_string_group_multi_ints_char,Tbl:COMPLETE,Col:PARTIAL,Output:["insert_num","c1","c2","c3","c4","b"] - -PREHOOK: query: select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_char -PREHOOK: type: QUERY -PREHOOK: Input: default@part_change_numeric_group_string_group_multi_ints_char -PREHOOK: Input: default@part_change_numeric_group_string_group_multi_ints_char@part=1 -PREHOOK: Input: default@part_change_numeric_group_string_group_multi_ints_char@part=2 -#### A masked pattern was here #### -POSTHOOK: query: select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_char -POSTHOOK: type: QUERY -POSTHOOK: Input: default@part_change_numeric_group_string_group_multi_ints_char -POSTHOOK: Input: default@part_change_numeric_group_string_group_multi_ints_char@part=1 -POSTHOOK: Input: default@part_change_numeric_group_string_group_multi_ints_char@part=2 -#### A masked pattern was here #### -insert_num part c1 c2 c3 c4 b -1 1 45 1000 483777 -23866739993 original -10 1 17 90000 754072151 3289094 new -2 1 -2 -6737 56 28899333 original -3 1 NULL 4957 832222222 9000000000 original -4 1 0 20435 847492223 -999999999999 original -5 2 2000 72909 3244222 -93222 new -6 2 1 200 2323322 5430907 new -7 2 256 32768 31889 470614135 new -8 2 5555 40000 -719017797 810662019 new -9 1 100 5000 5443 0 new -PREHOOK: query: drop table part_change_numeric_group_string_group_multi_ints_char -PREHOOK: type: DROPTABLE -PREHOOK: Input: default@part_change_numeric_group_string_group_multi_ints_char -PREHOOK: Output: default@part_change_numeric_group_string_group_multi_ints_char -POSTHOOK: query: drop table part_change_numeric_group_string_group_multi_ints_char -POSTHOOK: type: DROPTABLE -POSTHOOK: Input: default@part_change_numeric_group_string_group_multi_ints_char -POSTHOOK: Output: default@part_change_numeric_group_string_group_multi_ints_char -PREHOOK: query: -- --- SUBSECTION: ALTER TABLE CHANGE COLUMNS for NUMERIC_GROUP -> STRING_GROUP: (TINYINT, SMALLINT, INT, BIGINT), CHAR truncation --- -CREATE TABLE part_change_numeric_group_string_group_multi_ints_char_trunc(insert_num int, c1 tinyint, c2 smallint, c3 int, c4 bigint, b STRING) PARTITIONED BY(part INT) -PREHOOK: type: CREATETABLE -PREHOOK: Output: database:default -PREHOOK: Output: default@part_change_numeric_group_string_group_multi_ints_char_trunc -POSTHOOK: query: -- --- SUBSECTION: ALTER TABLE CHANGE COLUMNS for NUMERIC_GROUP -> STRING_GROUP: (TINYINT, SMALLINT, INT, BIGINT), CHAR truncation --- -CREATE TABLE part_change_numeric_group_string_group_multi_ints_char_trunc(insert_num int, c1 tinyint, c2 smallint, c3 int, c4 bigint, b STRING) PARTITIONED BY(part INT) -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:default -POSTHOOK: Output: default@part_change_numeric_group_string_group_multi_ints_char_trunc -PREHOOK: query: insert into table part_change_numeric_group_string_group_multi_ints_char_trunc partition(part=1) - values (1, 45, 1000, 483777, -23866739993, 'original'), - (2, -2, -6737, 56, 28899333, 'original'), - (3, -255, 4957, 832222222, 9000000000, 'original'), - (4, 0, 20435, 847492223, -999999999999, 'original') -PREHOOK: type: QUERY -PREHOOK: Output: default@part_change_numeric_group_string_group_multi_ints_char_trunc@part=1 -POSTHOOK: query: insert into table part_change_numeric_group_string_group_multi_ints_char_trunc partition(part=1) - values (1, 45, 1000, 483777, -23866739993, 'original'), - (2, -2, -6737, 56, 28899333, 'original'), - (3, -255, 4957, 832222222, 9000000000, 'original'), - (4, 0, 20435, 847492223, -999999999999, 'original') -POSTHOOK: type: QUERY -POSTHOOK: Output: default@part_change_numeric_group_string_group_multi_
<TRUNCATED>
