hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From ser...@apache.org
Subject [01/70] [abbrv] [partial] hive git commit: HIVE-15560: clean up out files that do not correspond to any q files (Gunther Hagleitner, reviewed by Sergey Shelukhin)
Date Tue, 07 Feb 2017 20:58:29 GMT
Repository: hive
Updated Branches:
  refs/heads/hive-14535 748c1bd2f -> b7670c479


http://git-wip-us.apache.org/repos/asf/hive/blob/8230b579/ql/src/test/results/clientpositive/schema_evol_text_vec_mapwork_table.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/schema_evol_text_vec_mapwork_table.q.out b/ql/src/test/results/clientpositive/schema_evol_text_vec_mapwork_table.q.out
deleted file mode 100644
index 093920d..0000000
--- a/ql/src/test/results/clientpositive/schema_evol_text_vec_mapwork_table.q.out
+++ /dev/null
@@ -1,3887 +0,0 @@
-PREHOOK: query: -- SORT_QUERY_RESULTS
---
--- FILE VARIATION: TEXTFILE, Non-Vectorized, MapWork, Table
--- NOTE: the use of hive.vectorized.use.vector.serde.deserialize above which enables doing
---  vectorized reading of TEXTFILE format files using the vector SERDE methods.
---
-------------------------------------------------------------------------------------------
--- SECTION: ALTER TABLE ADD COLUMNS
---
---
--- SUBSECTION: ALTER TABLE ADD COLUMNS: INT PERMUTE SELECT
---
---
-CREATE TABLE table_add_int_permute_select(insert_num int, a INT, b STRING)
-PREHOOK: type: CREATETABLE
-PREHOOK: Output: database:default
-PREHOOK: Output: default@table_add_int_permute_select
-POSTHOOK: query: -- SORT_QUERY_RESULTS
---
--- FILE VARIATION: TEXTFILE, Non-Vectorized, MapWork, Table
--- NOTE: the use of hive.vectorized.use.vector.serde.deserialize above which enables doing
---  vectorized reading of TEXTFILE format files using the vector SERDE methods.
---
-------------------------------------------------------------------------------------------
--- SECTION: ALTER TABLE ADD COLUMNS
---
---
--- SUBSECTION: ALTER TABLE ADD COLUMNS: INT PERMUTE SELECT
---
---
-CREATE TABLE table_add_int_permute_select(insert_num int, a INT, b STRING)
-POSTHOOK: type: CREATETABLE
-POSTHOOK: Output: database:default
-POSTHOOK: Output: default@table_add_int_permute_select
-PREHOOK: query: DESCRIBE FORMATTED table_add_int_permute_select
-PREHOOK: type: DESCTABLE
-PREHOOK: Input: default@table_add_int_permute_select
-POSTHOOK: query: DESCRIBE FORMATTED table_add_int_permute_select
-POSTHOOK: type: DESCTABLE
-POSTHOOK: Input: default@table_add_int_permute_select
-col_name	data_type	comment
-# col_name            	data_type           	comment             
-	 	 
-insert_num          	int                 	                    
-a                   	int                 	                    
-b                   	string              	                    
-	 	 
-# Detailed Table Information	 	 
-Database:           	default             	 
-#### A masked pattern was here ####
-Retention:          	0                   	 
-#### A masked pattern was here ####
-Table Type:         	MANAGED_TABLE       	 
-Table Parameters:	 	 
-	COLUMN_STATS_ACCURATE	{\"BASIC_STATS\":\"true\"}
-	numFiles            	0                   
-	numRows             	0                   
-	rawDataSize         	0                   
-	totalSize           	0                   
-#### A masked pattern was here ####
-	 	 
-# Storage Information	 	 
-SerDe Library:      	org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe	 
-InputFormat:        	org.apache.hadoop.mapred.TextInputFormat	 
-OutputFormat:       	org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat	 
-Compressed:         	No                  	 
-Num Buckets:        	-1                  	 
-Bucket Columns:     	[]                  	 
-Sort Columns:       	[]                  	 
-Storage Desc Params:	 	 
-	serialization.format	1                   
-PREHOOK: query: insert into table table_add_int_permute_select
-    values (1, 1, 'original'),
-           (2, 2, 'original'),
-           (3, 3, 'original'),
-           (4, 4, 'original')
-PREHOOK: type: QUERY
-PREHOOK: Output: default@table_add_int_permute_select
-POSTHOOK: query: insert into table table_add_int_permute_select
-    values (1, 1, 'original'),
-           (2, 2, 'original'),
-           (3, 3, 'original'),
-           (4, 4, 'original')
-POSTHOOK: type: QUERY
-POSTHOOK: Output: default@table_add_int_permute_select
-POSTHOOK: Lineage: table_add_int_permute_select.a EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
-POSTHOOK: Lineage: table_add_int_permute_select.b SIMPLE [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col3, type:string, comment:), ]
-POSTHOOK: Lineage: table_add_int_permute_select.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 table_add_int_permute_select add columns(c int)
-PREHOOK: type: ALTERTABLE_ADDCOLS
-PREHOOK: Input: default@table_add_int_permute_select
-PREHOOK: Output: default@table_add_int_permute_select
-POSTHOOK: query: -- Table-Non-Cascade ADD COLUMNS ...
-alter table table_add_int_permute_select add columns(c int)
-POSTHOOK: type: ALTERTABLE_ADDCOLS
-POSTHOOK: Input: default@table_add_int_permute_select
-POSTHOOK: Output: default@table_add_int_permute_select
-PREHOOK: query: DESCRIBE FORMATTED table_add_int_permute_select
-PREHOOK: type: DESCTABLE
-PREHOOK: Input: default@table_add_int_permute_select
-POSTHOOK: query: DESCRIBE FORMATTED table_add_int_permute_select
-POSTHOOK: type: DESCTABLE
-POSTHOOK: Input: default@table_add_int_permute_select
-col_name	data_type	comment
-# col_name            	data_type           	comment             
-	 	 
-insert_num          	int                 	                    
-a                   	int                 	                    
-b                   	string              	                    
-c                   	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 ####
-	numFiles            	1                   
-	numRows             	4                   
-	rawDataSize         	48                  
-	totalSize           	52                  
-#### A masked pattern was here ####
-	 	 
-# Storage Information	 	 
-SerDe Library:      	org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe	 
-InputFormat:        	org.apache.hadoop.mapred.TextInputFormat	 
-OutputFormat:       	org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat	 
-Compressed:         	No                  	 
-Num Buckets:        	-1                  	 
-Bucket Columns:     	[]                  	 
-Sort Columns:       	[]                  	 
-Storage Desc Params:	 	 
-	serialization.format	1                   
-PREHOOK: query: insert into table table_add_int_permute_select
-    values (5, 1, 'new', 10),
-           (6, 2, 'new', 20),
-           (7, 3, 'new', 30),
-           (8, 4, 'new', 40)
-PREHOOK: type: QUERY
-PREHOOK: Output: default@table_add_int_permute_select
-POSTHOOK: query: insert into table table_add_int_permute_select
-    values (5, 1, 'new', 10),
-           (6, 2, 'new', 20),
-           (7, 3, 'new', 30),
-           (8, 4, 'new', 40)
-POSTHOOK: type: QUERY
-POSTHOOK: Output: default@table_add_int_permute_select
-POSTHOOK: Lineage: table_add_int_permute_select.a EXPRESSION [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
-POSTHOOK: Lineage: table_add_int_permute_select.b SIMPLE [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col3, type:string, comment:), ]
-POSTHOOK: Lineage: table_add_int_permute_select.c EXPRESSION [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col4, type:string, comment:), ]
-POSTHOOK: Lineage: table_add_int_permute_select.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 table_add_int_permute_select
-    values (9, 5, 'new', 100),
-           (10, 6, 'new', 200)
-PREHOOK: type: QUERY
-PREHOOK: Output: default@table_add_int_permute_select
-POSTHOOK: query: insert into table table_add_int_permute_select
-    values (9, 5, 'new', 100),
-           (10, 6, 'new', 200)
-POSTHOOK: type: QUERY
-POSTHOOK: Output: default@table_add_int_permute_select
-POSTHOOK: Lineage: table_add_int_permute_select.a EXPRESSION [(values__tmp__table__3)values__tmp__table__3.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
-POSTHOOK: Lineage: table_add_int_permute_select.b SIMPLE [(values__tmp__table__3)values__tmp__table__3.FieldSchema(name:tmp_values_col3, type:string, comment:), ]
-POSTHOOK: Lineage: table_add_int_permute_select.c EXPRESSION [(values__tmp__table__3)values__tmp__table__3.FieldSchema(name:tmp_values_col4, type:string, comment:), ]
-POSTHOOK: Lineage: table_add_int_permute_select.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,a,b from table_add_int_permute_select
-PREHOOK: type: QUERY
-POSTHOOK: query: explain
-select insert_num,a,b from table_add_int_permute_select
-POSTHOOK: type: QUERY
-Explain
-STAGE DEPENDENCIES:
-  Stage-1 is a root stage
-  Stage-0 depends on stages: Stage-1
-
-STAGE PLANS:
-  Stage: Stage-1
-    Map Reduce
-      Map Operator Tree:
-          TableScan
-            alias: table_add_int_permute_select
-            Statistics: Num rows: 4 Data size: 48 Basic stats: COMPLETE Column stats: NONE
-            Select Operator
-              expressions: insert_num (type: int), a (type: int), b (type: string)
-              outputColumnNames: _col0, _col1, _col2
-              Statistics: Num rows: 4 Data size: 48 Basic stats: COMPLETE Column stats: NONE
-              File Output Operator
-                compressed: false
-                Statistics: Num rows: 4 Data size: 48 Basic stats: COMPLETE Column stats: NONE
-                table:
-                    input format: org.apache.hadoop.mapred.SequenceFileInputFormat
-                    output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                    serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-      Execution mode: vectorized
-
-  Stage: Stage-0
-    Fetch Operator
-      limit: -1
-      Processor Tree:
-        ListSink
-
-PREHOOK: query: -- SELECT permutation columns to make sure NULL defaulting works right
-select insert_num,a,b from table_add_int_permute_select
-PREHOOK: type: QUERY
-PREHOOK: Input: default@table_add_int_permute_select
-#### A masked pattern was here ####
-POSTHOOK: query: -- SELECT permutation columns to make sure NULL defaulting works right
-select insert_num,a,b from table_add_int_permute_select
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@table_add_int_permute_select
-#### A masked pattern was here ####
-insert_num	a	b
-1	1	original
-10	6	new
-2	2	original
-3	3	original
-4	4	original
-5	1	new
-6	2	new
-7	3	new
-8	4	new
-9	5	new
-PREHOOK: query: select insert_num,a,b,c from table_add_int_permute_select
-PREHOOK: type: QUERY
-PREHOOK: Input: default@table_add_int_permute_select
-#### A masked pattern was here ####
-POSTHOOK: query: select insert_num,a,b,c from table_add_int_permute_select
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@table_add_int_permute_select
-#### A masked pattern was here ####
-insert_num	a	b	c
-1	1	original	NULL
-10	6	new	200
-2	2	original	NULL
-3	3	original	NULL
-4	4	original	NULL
-5	1	new	10
-6	2	new	20
-7	3	new	30
-8	4	new	40
-9	5	new	100
-PREHOOK: query: select insert_num,c from table_add_int_permute_select
-PREHOOK: type: QUERY
-PREHOOK: Input: default@table_add_int_permute_select
-#### A masked pattern was here ####
-POSTHOOK: query: select insert_num,c from table_add_int_permute_select
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@table_add_int_permute_select
-#### A masked pattern was here ####
-insert_num	c
-1	NULL
-10	200
-2	NULL
-3	NULL
-4	NULL
-5	10
-6	20
-7	30
-8	40
-9	100
-PREHOOK: query: drop table table_add_int_permute_select
-PREHOOK: type: DROPTABLE
-PREHOOK: Input: default@table_add_int_permute_select
-PREHOOK: Output: default@table_add_int_permute_select
-POSTHOOK: query: drop table table_add_int_permute_select
-POSTHOOK: type: DROPTABLE
-POSTHOOK: Input: default@table_add_int_permute_select
-POSTHOOK: Output: default@table_add_int_permute_select
-PREHOOK: query: -- SUBSECTION: ALTER TABLE ADD COLUMNS: INT, STRING, PERMUTE SELECT
---
---
-CREATE TABLE table_add_int_string_permute_select(insert_num int, a INT, b STRING)
-PREHOOK: type: CREATETABLE
-PREHOOK: Output: database:default
-PREHOOK: Output: default@table_add_int_string_permute_select
-POSTHOOK: query: -- SUBSECTION: ALTER TABLE ADD COLUMNS: INT, STRING, PERMUTE SELECT
---
---
-CREATE TABLE table_add_int_string_permute_select(insert_num int, a INT, b STRING)
-POSTHOOK: type: CREATETABLE
-POSTHOOK: Output: database:default
-POSTHOOK: Output: default@table_add_int_string_permute_select
-PREHOOK: query: DESCRIBE FORMATTED table_add_int_string_permute_select
-PREHOOK: type: DESCTABLE
-PREHOOK: Input: default@table_add_int_string_permute_select
-POSTHOOK: query: DESCRIBE FORMATTED table_add_int_string_permute_select
-POSTHOOK: type: DESCTABLE
-POSTHOOK: Input: default@table_add_int_string_permute_select
-col_name	data_type	comment
-# col_name            	data_type           	comment             
-	 	 
-insert_num          	int                 	                    
-a                   	int                 	                    
-b                   	string              	                    
-	 	 
-# Detailed Table Information	 	 
-Database:           	default             	 
-#### A masked pattern was here ####
-Retention:          	0                   	 
-#### A masked pattern was here ####
-Table Type:         	MANAGED_TABLE       	 
-Table Parameters:	 	 
-	COLUMN_STATS_ACCURATE	{\"BASIC_STATS\":\"true\"}
-	numFiles            	0                   
-	numRows             	0                   
-	rawDataSize         	0                   
-	totalSize           	0                   
-#### A masked pattern was here ####
-	 	 
-# Storage Information	 	 
-SerDe Library:      	org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe	 
-InputFormat:        	org.apache.hadoop.mapred.TextInputFormat	 
-OutputFormat:       	org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat	 
-Compressed:         	No                  	 
-Num Buckets:        	-1                  	 
-Bucket Columns:     	[]                  	 
-Sort Columns:       	[]                  	 
-Storage Desc Params:	 	 
-	serialization.format	1                   
-PREHOOK: query: insert into table table_add_int_string_permute_select
-    values (1, 1, 'original'),
-           (2, 2, 'original'),
-           (3, 3, 'original'),
-           (4, 4, 'original')
-PREHOOK: type: QUERY
-PREHOOK: Output: default@table_add_int_string_permute_select
-POSTHOOK: query: insert into table table_add_int_string_permute_select
-    values (1, 1, 'original'),
-           (2, 2, 'original'),
-           (3, 3, 'original'),
-           (4, 4, 'original')
-POSTHOOK: type: QUERY
-POSTHOOK: Output: default@table_add_int_string_permute_select
-POSTHOOK: Lineage: table_add_int_string_permute_select.a EXPRESSION [(values__tmp__table__4)values__tmp__table__4.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
-POSTHOOK: Lineage: table_add_int_string_permute_select.b SIMPLE [(values__tmp__table__4)values__tmp__table__4.FieldSchema(name:tmp_values_col3, type:string, comment:), ]
-POSTHOOK: Lineage: table_add_int_string_permute_select.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 table_add_int_string_permute_select add columns(c int, d string)
-PREHOOK: type: ALTERTABLE_ADDCOLS
-PREHOOK: Input: default@table_add_int_string_permute_select
-PREHOOK: Output: default@table_add_int_string_permute_select
-POSTHOOK: query: -- Table-Non-Cascade ADD COLUMNS ...
-alter table table_add_int_string_permute_select add columns(c int, d string)
-POSTHOOK: type: ALTERTABLE_ADDCOLS
-POSTHOOK: Input: default@table_add_int_string_permute_select
-POSTHOOK: Output: default@table_add_int_string_permute_select
-PREHOOK: query: DESCRIBE FORMATTED table_add_int_string_permute_select
-PREHOOK: type: DESCTABLE
-PREHOOK: Input: default@table_add_int_string_permute_select
-POSTHOOK: query: DESCRIBE FORMATTED table_add_int_string_permute_select
-POSTHOOK: type: DESCTABLE
-POSTHOOK: Input: default@table_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              	                    
-	 	 
-# 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 ####
-	numFiles            	1                   
-	numRows             	4                   
-	rawDataSize         	48                  
-	totalSize           	52                  
-#### A masked pattern was here ####
-	 	 
-# Storage Information	 	 
-SerDe Library:      	org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe	 
-InputFormat:        	org.apache.hadoop.mapred.TextInputFormat	 
-OutputFormat:       	org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat	 
-Compressed:         	No                  	 
-Num Buckets:        	-1                  	 
-Bucket Columns:     	[]                  	 
-Sort Columns:       	[]                  	 
-Storage Desc Params:	 	 
-	serialization.format	1                   
-PREHOOK: query: insert into table table_add_int_string_permute_select
-    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@table_add_int_string_permute_select
-POSTHOOK: query: insert into table table_add_int_string_permute_select
-    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@table_add_int_string_permute_select
-POSTHOOK: Lineage: table_add_int_string_permute_select.a EXPRESSION [(values__tmp__table__5)values__tmp__table__5.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
-POSTHOOK: Lineage: table_add_int_string_permute_select.b SIMPLE [(values__tmp__table__5)values__tmp__table__5.FieldSchema(name:tmp_values_col3, type:string, comment:), ]
-POSTHOOK: Lineage: table_add_int_string_permute_select.c EXPRESSION [(values__tmp__table__5)values__tmp__table__5.FieldSchema(name:tmp_values_col4, type:string, comment:), ]
-POSTHOOK: Lineage: table_add_int_string_permute_select.d SIMPLE [(values__tmp__table__5)values__tmp__table__5.FieldSchema(name:tmp_values_col5, type:string, comment:), ]
-POSTHOOK: Lineage: table_add_int_string_permute_select.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 table_add_int_string_permute_select
-    values (9, 5, 'new', 100, 'hundred'),
-           (10, 6, 'new', 200, 'two hundred')
-PREHOOK: type: QUERY
-PREHOOK: Output: default@table_add_int_string_permute_select
-POSTHOOK: query: insert into table table_add_int_string_permute_select
-    values (9, 5, 'new', 100, 'hundred'),
-           (10, 6, 'new', 200, 'two hundred')
-POSTHOOK: type: QUERY
-POSTHOOK: Output: default@table_add_int_string_permute_select
-POSTHOOK: Lineage: table_add_int_string_permute_select.a EXPRESSION [(values__tmp__table__6)values__tmp__table__6.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
-POSTHOOK: Lineage: table_add_int_string_permute_select.b SIMPLE [(values__tmp__table__6)values__tmp__table__6.FieldSchema(name:tmp_values_col3, type:string, comment:), ]
-POSTHOOK: Lineage: table_add_int_string_permute_select.c EXPRESSION [(values__tmp__table__6)values__tmp__table__6.FieldSchema(name:tmp_values_col4, type:string, comment:), ]
-POSTHOOK: Lineage: table_add_int_string_permute_select.d SIMPLE [(values__tmp__table__6)values__tmp__table__6.FieldSchema(name:tmp_values_col5, type:string, comment:), ]
-POSTHOOK: Lineage: table_add_int_string_permute_select.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,a,b from table_add_int_string_permute_select
-PREHOOK: type: QUERY
-POSTHOOK: query: explain
-select insert_num,a,b from table_add_int_string_permute_select
-POSTHOOK: type: QUERY
-Explain
-STAGE DEPENDENCIES:
-  Stage-1 is a root stage
-  Stage-0 depends on stages: Stage-1
-
-STAGE PLANS:
-  Stage: Stage-1
-    Map Reduce
-      Map Operator Tree:
-          TableScan
-            alias: table_add_int_string_permute_select
-            Statistics: Num rows: 4 Data size: 48 Basic stats: COMPLETE Column stats: NONE
-            Select Operator
-              expressions: insert_num (type: int), a (type: int), b (type: string)
-              outputColumnNames: _col0, _col1, _col2
-              Statistics: Num rows: 4 Data size: 48 Basic stats: COMPLETE Column stats: NONE
-              File Output Operator
-                compressed: false
-                Statistics: Num rows: 4 Data size: 48 Basic stats: COMPLETE Column stats: NONE
-                table:
-                    input format: org.apache.hadoop.mapred.SequenceFileInputFormat
-                    output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                    serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-      Execution mode: vectorized
-
-  Stage: Stage-0
-    Fetch Operator
-      limit: -1
-      Processor Tree:
-        ListSink
-
-PREHOOK: query: -- SELECT permutation columns to make sure NULL defaulting works right
-select insert_num,a,b from table_add_int_string_permute_select
-PREHOOK: type: QUERY
-PREHOOK: Input: default@table_add_int_string_permute_select
-#### A masked pattern was here ####
-POSTHOOK: query: -- SELECT permutation columns to make sure NULL defaulting works right
-select insert_num,a,b from table_add_int_string_permute_select
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@table_add_int_string_permute_select
-#### A masked pattern was here ####
-insert_num	a	b
-1	1	original
-10	6	new
-2	2	original
-3	3	original
-4	4	original
-5	1	new
-6	2	new
-7	3	new
-8	4	new
-9	5	new
-PREHOOK: query: select insert_num,a,b,c from table_add_int_string_permute_select
-PREHOOK: type: QUERY
-PREHOOK: Input: default@table_add_int_string_permute_select
-#### A masked pattern was here ####
-POSTHOOK: query: select insert_num,a,b,c from table_add_int_string_permute_select
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@table_add_int_string_permute_select
-#### A masked pattern was here ####
-insert_num	a	b	c
-1	1	original	NULL
-10	6	new	200
-2	2	original	NULL
-3	3	original	NULL
-4	4	original	NULL
-5	1	new	10
-6	2	new	20
-7	3	new	30
-8	4	new	40
-9	5	new	100
-PREHOOK: query: select insert_num,a,b,c,d from table_add_int_string_permute_select
-PREHOOK: type: QUERY
-PREHOOK: Input: default@table_add_int_string_permute_select
-#### A masked pattern was here ####
-POSTHOOK: query: select insert_num,a,b,c,d from table_add_int_string_permute_select
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@table_add_int_string_permute_select
-#### A masked pattern was here ####
-insert_num	a	b	c	d
-1	1	original	NULL	NULL
-10	6	new	200	two hundred
-2	2	original	NULL	NULL
-3	3	original	NULL	NULL
-4	4	original	NULL	NULL
-5	1	new	10	ten
-6	2	new	20	twenty
-7	3	new	30	thirty
-8	4	new	40	forty
-9	5	new	100	hundred
-PREHOOK: query: select insert_num,a,c,d from table_add_int_string_permute_select
-PREHOOK: type: QUERY
-PREHOOK: Input: default@table_add_int_string_permute_select
-#### A masked pattern was here ####
-POSTHOOK: query: select insert_num,a,c,d from table_add_int_string_permute_select
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@table_add_int_string_permute_select
-#### A masked pattern was here ####
-insert_num	a	c	d
-1	1	NULL	NULL
-10	6	200	two hundred
-2	2	NULL	NULL
-3	3	NULL	NULL
-4	4	NULL	NULL
-5	1	10	ten
-6	2	20	twenty
-7	3	30	thirty
-8	4	40	forty
-9	5	100	hundred
-PREHOOK: query: select insert_num,a,d from table_add_int_string_permute_select
-PREHOOK: type: QUERY
-PREHOOK: Input: default@table_add_int_string_permute_select
-#### A masked pattern was here ####
-POSTHOOK: query: select insert_num,a,d from table_add_int_string_permute_select
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@table_add_int_string_permute_select
-#### A masked pattern was here ####
-insert_num	a	d
-1	1	NULL
-10	6	two hundred
-2	2	NULL
-3	3	NULL
-4	4	NULL
-5	1	ten
-6	2	twenty
-7	3	thirty
-8	4	forty
-9	5	hundred
-PREHOOK: query: select insert_num,c from table_add_int_string_permute_select
-PREHOOK: type: QUERY
-PREHOOK: Input: default@table_add_int_string_permute_select
-#### A masked pattern was here ####
-POSTHOOK: query: select insert_num,c from table_add_int_string_permute_select
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@table_add_int_string_permute_select
-#### A masked pattern was here ####
-insert_num	c
-1	NULL
-10	200
-2	NULL
-3	NULL
-4	NULL
-5	10
-6	20
-7	30
-8	40
-9	100
-PREHOOK: query: select insert_num,d from table_add_int_string_permute_select
-PREHOOK: type: QUERY
-PREHOOK: Input: default@table_add_int_string_permute_select
-#### A masked pattern was here ####
-POSTHOOK: query: select insert_num,d from table_add_int_string_permute_select
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@table_add_int_string_permute_select
-#### A masked pattern was here ####
-insert_num	d
-1	NULL
-10	two hundred
-2	NULL
-3	NULL
-4	NULL
-5	ten
-6	twenty
-7	thirty
-8	forty
-9	hundred
-PREHOOK: query: drop table table_add_int_string_permute_select
-PREHOOK: type: DROPTABLE
-PREHOOK: Input: default@table_add_int_string_permute_select
-PREHOOK: Output: default@table_add_int_string_permute_select
-POSTHOOK: query: drop table table_add_int_string_permute_select
-POSTHOOK: type: DROPTABLE
-POSTHOOK: Input: default@table_add_int_string_permute_select
-POSTHOOK: Output: default@table_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 table_change_string_group_double(insert_num int, c1 STRING, c2 CHAR(50), c3 VARCHAR(50), b STRING)
-PREHOOK: type: CREATETABLE
-PREHOOK: Output: database:default
-PREHOOK: Output: default@table_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 table_change_string_group_double(insert_num int, c1 STRING, c2 CHAR(50), c3 VARCHAR(50), b STRING)
-POSTHOOK: type: CREATETABLE
-POSTHOOK: Output: database:default
-POSTHOOK: Output: default@table_change_string_group_double
-PREHOOK: query: insert into table table_change_string_group_double
-    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@table_change_string_group_double
-POSTHOOK: query: insert into table table_change_string_group_double
-    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@table_change_string_group_double
-POSTHOOK: Lineage: table_change_string_group_double.b SIMPLE [(values__tmp__table__7)values__tmp__table__7.FieldSchema(name:tmp_values_col5, type:string, comment:), ]
-POSTHOOK: Lineage: table_change_string_group_double.c1 SIMPLE [(values__tmp__table__7)values__tmp__table__7.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
-POSTHOOK: Lineage: table_change_string_group_double.c2 EXPRESSION [(values__tmp__table__7)values__tmp__table__7.FieldSchema(name:tmp_values_col3, type:string, comment:), ]
-POSTHOOK: Lineage: table_change_string_group_double.c3 EXPRESSION [(values__tmp__table__7)values__tmp__table__7.FieldSchema(name:tmp_values_col4, type:string, comment:), ]
-POSTHOOK: Lineage: table_change_string_group_double.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 table_change_string_group_double replace columns (insert_num int, c1 DOUBLE, c2 DOUBLE, c3 DOUBLE, b STRING)
-PREHOOK: type: ALTERTABLE_REPLACECOLS
-PREHOOK: Input: default@table_change_string_group_double
-PREHOOK: Output: default@table_change_string_group_double
-POSTHOOK: query: -- Table-Non-Cascade CHANGE COLUMNS ...
-alter table table_change_string_group_double replace columns (insert_num int, c1 DOUBLE, c2 DOUBLE, c3 DOUBLE, b STRING)
-POSTHOOK: type: ALTERTABLE_REPLACECOLS
-POSTHOOK: Input: default@table_change_string_group_double
-POSTHOOK: Output: default@table_change_string_group_double
-PREHOOK: query: insert into table table_change_string_group_double
-    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@table_change_string_group_double
-POSTHOOK: query: insert into table table_change_string_group_double
-    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@table_change_string_group_double
-POSTHOOK: Lineage: table_change_string_group_double.b SIMPLE [(values__tmp__table__8)values__tmp__table__8.FieldSchema(name:tmp_values_col5, type:string, comment:), ]
-POSTHOOK: Lineage: table_change_string_group_double.c1 EXPRESSION [(values__tmp__table__8)values__tmp__table__8.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
-POSTHOOK: Lineage: table_change_string_group_double.c2 EXPRESSION [(values__tmp__table__8)values__tmp__table__8.FieldSchema(name:tmp_values_col3, type:string, comment:), ]
-POSTHOOK: Lineage: table_change_string_group_double.c3 EXPRESSION [(values__tmp__table__8)values__tmp__table__8.FieldSchema(name:tmp_values_col4, type:string, comment:), ]
-POSTHOOK: Lineage: table_change_string_group_double.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 table_change_string_group_double
-    values (9, 17808.963785, 17808.963785, 17808.963785, 'new'),
-           (10, 9250340.75 , 9250340.75 , 9250340.75 , 'new')
-PREHOOK: type: QUERY
-PREHOOK: Output: default@table_change_string_group_double
-POSTHOOK: query: insert into table table_change_string_group_double
-    values (9, 17808.963785, 17808.963785, 17808.963785, 'new'),
-           (10, 9250340.75 , 9250340.75 , 9250340.75 , 'new')
-POSTHOOK: type: QUERY
-POSTHOOK: Output: default@table_change_string_group_double
-POSTHOOK: Lineage: table_change_string_group_double.b SIMPLE [(values__tmp__table__9)values__tmp__table__9.FieldSchema(name:tmp_values_col5, type:string, comment:), ]
-POSTHOOK: Lineage: table_change_string_group_double.c1 EXPRESSION [(values__tmp__table__9)values__tmp__table__9.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
-POSTHOOK: Lineage: table_change_string_group_double.c2 EXPRESSION [(values__tmp__table__9)values__tmp__table__9.FieldSchema(name:tmp_values_col3, type:string, comment:), ]
-POSTHOOK: Lineage: table_change_string_group_double.c3 EXPRESSION [(values__tmp__table__9)values__tmp__table__9.FieldSchema(name:tmp_values_col4, type:string, comment:), ]
-POSTHOOK: Lineage: table_change_string_group_double.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,c1,c2,c3,b from table_change_string_group_double
-PREHOOK: type: QUERY
-POSTHOOK: query: explain
-select insert_num,c1,c2,c3,b from table_change_string_group_double
-POSTHOOK: type: QUERY
-Explain
-STAGE DEPENDENCIES:
-  Stage-1 is a root stage
-  Stage-0 depends on stages: Stage-1
-
-STAGE PLANS:
-  Stage: Stage-1
-    Map Reduce
-      Map Operator Tree:
-          TableScan
-            alias: table_change_string_group_double
-            Statistics: Num rows: 4 Data size: 151 Basic stats: COMPLETE Column stats: NONE
-            Select Operator
-              expressions: insert_num (type: int), c1 (type: double), c2 (type: double), c3 (type: double), b (type: string)
-              outputColumnNames: _col0, _col1, _col2, _col3, _col4
-              Statistics: Num rows: 4 Data size: 151 Basic stats: COMPLETE Column stats: NONE
-              File Output Operator
-                compressed: false
-                Statistics: Num rows: 4 Data size: 151 Basic stats: COMPLETE Column stats: NONE
-                table:
-                    input format: org.apache.hadoop.mapred.SequenceFileInputFormat
-                    output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                    serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-      Execution mode: vectorized
-
-  Stage: Stage-0
-    Fetch Operator
-      limit: -1
-      Processor Tree:
-        ListSink
-
-PREHOOK: query: select insert_num,c1,c2,c3,b from table_change_string_group_double
-PREHOOK: type: QUERY
-PREHOOK: Input: default@table_change_string_group_double
-#### A masked pattern was here ####
-POSTHOOK: query: select insert_num,c1,c2,c3,b from table_change_string_group_double
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@table_change_string_group_double
-#### A masked pattern was here ####
-insert_num	c1	c2	c3	b
-1	753.7028	753.7028	753.7028	original
-10	9250340.75	9250340.75	9250340.75	new
-2	-3651.672121	-3651.672121	-3651.672121	original
-3	-29.0764	-29.0764	-29.0764	original
-4	-10.3	-10.3	-10.3	original
-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
-9	17808.963785	17808.963785	17808.963785	new
-PREHOOK: query: drop table table_change_string_group_double
-PREHOOK: type: DROPTABLE
-PREHOOK: Input: default@table_change_string_group_double
-PREHOOK: Output: default@table_change_string_group_double
-POSTHOOK: query: drop table table_change_string_group_double
-POSTHOOK: type: DROPTABLE
-POSTHOOK: Input: default@table_change_string_group_double
-POSTHOOK: Output: default@table_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 table_change_date_group_string_group_timestamp(insert_num int, c1 TIMESTAMP, c2 TIMESTAMP, c3 TIMESTAMP, c4 TIMESTAMP, c5 TIMESTAMP, b STRING)
-PREHOOK: type: CREATETABLE
-PREHOOK: Output: database:default
-PREHOOK: Output: default@table_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 table_change_date_group_string_group_timestamp(insert_num int, c1 TIMESTAMP, c2 TIMESTAMP, c3 TIMESTAMP, c4 TIMESTAMP, c5 TIMESTAMP, b STRING)
-POSTHOOK: type: CREATETABLE
-POSTHOOK: Output: database:default
-POSTHOOK: Output: default@table_change_date_group_string_group_timestamp
-PREHOOK: query: insert into table table_change_date_group_string_group_timestamp
-    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@table_change_date_group_string_group_timestamp
-POSTHOOK: query: insert into table table_change_date_group_string_group_timestamp
-    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@table_change_date_group_string_group_timestamp
-POSTHOOK: Lineage: table_change_date_group_string_group_timestamp.b SIMPLE [(values__tmp__table__10)values__tmp__table__10.FieldSchema(name:tmp_values_col7, type:string, comment:), ]
-POSTHOOK: Lineage: table_change_date_group_string_group_timestamp.c1 EXPRESSION [(values__tmp__table__10)values__tmp__table__10.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
-POSTHOOK: Lineage: table_change_date_group_string_group_timestamp.c2 EXPRESSION [(values__tmp__table__10)values__tmp__table__10.FieldSchema(name:tmp_values_col3, type:string, comment:), ]
-POSTHOOK: Lineage: table_change_date_group_string_group_timestamp.c3 EXPRESSION [(values__tmp__table__10)values__tmp__table__10.FieldSchema(name:tmp_values_col4, type:string, comment:), ]
-POSTHOOK: Lineage: table_change_date_group_string_group_timestamp.c4 EXPRESSION [(values__tmp__table__10)values__tmp__table__10.FieldSchema(name:tmp_values_col5, type:string, comment:), ]
-POSTHOOK: Lineage: table_change_date_group_string_group_timestamp.c5 EXPRESSION [(values__tmp__table__10)values__tmp__table__10.FieldSchema(name:tmp_values_col6, type:string, comment:), ]
-POSTHOOK: Lineage: table_change_date_group_string_group_timestamp.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 table_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@table_change_date_group_string_group_timestamp
-PREHOOK: Output: default@table_change_date_group_string_group_timestamp
-POSTHOOK: query: -- Table-Non-Cascade CHANGE COLUMNS ...
-alter table table_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@table_change_date_group_string_group_timestamp
-POSTHOOK: Output: default@table_change_date_group_string_group_timestamp
-PREHOOK: query: insert into table table_change_date_group_string_group_timestamp
-    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@table_change_date_group_string_group_timestamp
-POSTHOOK: query: insert into table table_change_date_group_string_group_timestamp
-    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@table_change_date_group_string_group_timestamp
-POSTHOOK: Lineage: table_change_date_group_string_group_timestamp.b SIMPLE [(values__tmp__table__11)values__tmp__table__11.FieldSchema(name:tmp_values_col7, type:string, comment:), ]
-POSTHOOK: Lineage: table_change_date_group_string_group_timestamp.c1 SIMPLE [(values__tmp__table__11)values__tmp__table__11.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
-POSTHOOK: Lineage: table_change_date_group_string_group_timestamp.c2 EXPRESSION [(values__tmp__table__11)values__tmp__table__11.FieldSchema(name:tmp_values_col3, type:string, comment:), ]
-POSTHOOK: Lineage: table_change_date_group_string_group_timestamp.c3 EXPRESSION [(values__tmp__table__11)values__tmp__table__11.FieldSchema(name:tmp_values_col4, type:string, comment:), ]
-POSTHOOK: Lineage: table_change_date_group_string_group_timestamp.c4 EXPRESSION [(values__tmp__table__11)values__tmp__table__11.FieldSchema(name:tmp_values_col5, type:string, comment:), ]
-POSTHOOK: Lineage: table_change_date_group_string_group_timestamp.c5 EXPRESSION [(values__tmp__table__11)values__tmp__table__11.FieldSchema(name:tmp_values_col6, type:string, comment:), ]
-POSTHOOK: Lineage: table_change_date_group_string_group_timestamp.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 table_change_date_group_string_group_timestamp
-    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@table_change_date_group_string_group_timestamp
-POSTHOOK: query: insert into table table_change_date_group_string_group_timestamp
-    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@table_change_date_group_string_group_timestamp
-POSTHOOK: Lineage: table_change_date_group_string_group_timestamp.b SIMPLE [(values__tmp__table__12)values__tmp__table__12.FieldSchema(name:tmp_values_col7, type:string, comment:), ]
-POSTHOOK: Lineage: table_change_date_group_string_group_timestamp.c1 SIMPLE [(values__tmp__table__12)values__tmp__table__12.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
-POSTHOOK: Lineage: table_change_date_group_string_group_timestamp.c2 EXPRESSION [(values__tmp__table__12)values__tmp__table__12.FieldSchema(name:tmp_values_col3, type:string, comment:), ]
-POSTHOOK: Lineage: table_change_date_group_string_group_timestamp.c3 EXPRESSION [(values__tmp__table__12)values__tmp__table__12.FieldSchema(name:tmp_values_col4, type:string, comment:), ]
-POSTHOOK: Lineage: table_change_date_group_string_group_timestamp.c4 EXPRESSION [(values__tmp__table__12)values__tmp__table__12.FieldSchema(name:tmp_values_col5, type:string, comment:), ]
-POSTHOOK: Lineage: table_change_date_group_string_group_timestamp.c5 EXPRESSION [(values__tmp__table__12)values__tmp__table__12.FieldSchema(name:tmp_values_col6, type:string, comment:), ]
-POSTHOOK: Lineage: table_change_date_group_string_group_timestamp.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,c1,c2,c3,c4,c5,b from table_change_date_group_string_group_timestamp
-PREHOOK: type: QUERY
-POSTHOOK: query: explain
-select insert_num,c1,c2,c3,c4,c5,b from table_change_date_group_string_group_timestamp
-POSTHOOK: type: QUERY
-Explain
-STAGE DEPENDENCIES:
-  Stage-1 is a root stage
-  Stage-0 depends on stages: Stage-1
-
-STAGE PLANS:
-  Stage: Stage-1
-    Map Reduce
-      Map Operator Tree:
-          TableScan
-            alias: table_change_date_group_string_group_timestamp
-            Statistics: Num rows: 3 Data size: 450 Basic stats: COMPLETE Column stats: NONE
-            Select Operator
-              expressions: insert_num (type: int), c1 (type: string), c2 (type: char(50)), c3 (type: char(15)), c4 (type: varchar(50)), c5 (type: varchar(15)), b (type: string)
-              outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6
-              Statistics: Num rows: 3 Data size: 450 Basic stats: COMPLETE Column stats: NONE
-              File Output Operator
-                compressed: false
-                Statistics: Num rows: 3 Data size: 450 Basic stats: COMPLETE Column stats: NONE
-                table:
-                    input format: org.apache.hadoop.mapred.SequenceFileInputFormat
-                    output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                    serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-      Execution mode: vectorized
-
-  Stage: Stage-0
-    Fetch Operator
-      limit: -1
-      Processor Tree:
-        ListSink
-
-PREHOOK: query: select insert_num,c1,c2,c3,c4,c5,b from table_change_date_group_string_group_timestamp
-PREHOOK: type: QUERY
-PREHOOK: Input: default@table_change_date_group_string_group_timestamp
-#### A masked pattern was here ####
-POSTHOOK: query: select insert_num,c1,c2,c3,c4,c5,b from table_change_date_group_string_group_timestamp
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@table_change_date_group_string_group_timestamp
-#### A masked pattern was here ####
-insert_num	c1	c2	c3	c4	c5	b
-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	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	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	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	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	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	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	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	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 table_change_date_group_string_group_timestamp
-PREHOOK: type: DROPTABLE
-PREHOOK: Input: default@table_change_date_group_string_group_timestamp
-PREHOOK: Output: default@table_change_date_group_string_group_timestamp
-POSTHOOK: query: drop table table_change_date_group_string_group_timestamp
-POSTHOOK: type: DROPTABLE
-POSTHOOK: Input: default@table_change_date_group_string_group_timestamp
-POSTHOOK: Output: default@table_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 table_change_date_group_string_group_date(insert_num int, c1 DATE, c2 DATE, c3 DATE, c4 DATE, c5 DATE, b STRING)
-PREHOOK: type: CREATETABLE
-PREHOOK: Output: database:default
-PREHOOK: Output: default@table_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 table_change_date_group_string_group_date(insert_num int, c1 DATE, c2 DATE, c3 DATE, c4 DATE, c5 DATE, b STRING)
-POSTHOOK: type: CREATETABLE
-POSTHOOK: Output: database:default
-POSTHOOK: Output: default@table_change_date_group_string_group_date
-PREHOOK: query: insert into table table_change_date_group_string_group_date
-    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@table_change_date_group_string_group_date
-POSTHOOK: query: insert into table table_change_date_group_string_group_date
-    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@table_change_date_group_string_group_date
-POSTHOOK: Lineage: table_change_date_group_string_group_date.b SIMPLE [(values__tmp__table__13)values__tmp__table__13.FieldSchema(name:tmp_values_col7, type:string, comment:), ]
-POSTHOOK: Lineage: table_change_date_group_string_group_date.c1 EXPRESSION [(values__tmp__table__13)values__tmp__table__13.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
-POSTHOOK: Lineage: table_change_date_group_string_group_date.c2 EXPRESSION [(values__tmp__table__13)values__tmp__table__13.FieldSchema(name:tmp_values_col3, type:string, comment:), ]
-POSTHOOK: Lineage: table_change_date_group_string_group_date.c3 EXPRESSION [(values__tmp__table__13)values__tmp__table__13.FieldSchema(name:tmp_values_col4, type:string, comment:), ]
-POSTHOOK: Lineage: table_change_date_group_string_group_date.c4 EXPRESSION [(values__tmp__table__13)values__tmp__table__13.FieldSchema(name:tmp_values_col5, type:string, comment:), ]
-POSTHOOK: Lineage: table_change_date_group_string_group_date.c5 EXPRESSION [(values__tmp__table__13)values__tmp__table__13.FieldSchema(name:tmp_values_col6, type:string, comment:), ]
-POSTHOOK: Lineage: table_change_date_group_string_group_date.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 table_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@table_change_date_group_string_group_date
-PREHOOK: Output: default@table_change_date_group_string_group_date
-POSTHOOK: query: -- Table-Non-Cascade CHANGE COLUMNS ...
-alter table table_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@table_change_date_group_string_group_date
-POSTHOOK: Output: default@table_change_date_group_string_group_date
-PREHOOK: query: DESCRIBE FORMATTED table_change_date_group_string_group_date
-PREHOOK: type: DESCTABLE
-PREHOOK: Input: default@table_change_date_group_string_group_date
-POSTHOOK: query: DESCRIBE FORMATTED table_change_date_group_string_group_date
-POSTHOOK: type: DESCTABLE
-POSTHOOK: Input: default@table_change_date_group_string_group_date
-col_name	data_type	comment
-# col_name            	data_type           	comment             
-	 	 
-insert_num          	int                 	                    
-c1                  	string              	                    
-c2                  	char(50)            	                    
-c3                  	char(15)            	                    
-c4                  	varchar(50)         	                    
-c5                  	varchar(15)         	                    
-b                   	string              	                    
-	 	 
-# 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 ####
-	numFiles            	1                   
-	numRows             	3                   
-	rawDataSize         	195                 
-	totalSize           	198                 
-#### A masked pattern was here ####
-	 	 
-# Storage Information	 	 
-SerDe Library:      	org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe	 
-InputFormat:        	org.apache.hadoop.mapred.TextInputFormat	 
-OutputFormat:       	org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat	 
-Compressed:         	No                  	 
-Num Buckets:        	-1                  	 
-Bucket Columns:     	[]                  	 
-Sort Columns:       	[]                  	 
-Storage Desc Params:	 	 
-	serialization.format	1                   
-PREHOOK: query: insert into table table_change_date_group_string_group_date
-    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@table_change_date_group_string_group_date
-POSTHOOK: query: insert into table table_change_date_group_string_group_date
-    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@table_change_date_group_string_group_date
-POSTHOOK: Lineage: table_change_date_group_string_group_date.b SIMPLE [(values__tmp__table__14)values__tmp__table__14.FieldSchema(name:tmp_values_col7, type:string, comment:), ]
-POSTHOOK: Lineage: table_change_date_group_string_group_date.c1 SIMPLE [(values__tmp__table__14)values__tmp__table__14.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
-POSTHOOK: Lineage: table_change_date_group_string_group_date.c2 EXPRESSION [(values__tmp__table__14)values__tmp__table__14.FieldSchema(name:tmp_values_col3, type:string, comment:), ]
-POSTHOOK: Lineage: table_change_date_group_string_group_date.c3 EXPRESSION [(values__tmp__table__14)values__tmp__table__14.FieldSchema(name:tmp_values_col4, type:string, comment:), ]
-POSTHOOK: Lineage: table_change_date_group_string_group_date.c4 EXPRESSION [(values__tmp__table__14)values__tmp__table__14.FieldSchema(name:tmp_values_col5, type:string, comment:), ]
-POSTHOOK: Lineage: table_change_date_group_string_group_date.c5 EXPRESSION [(values__tmp__table__14)values__tmp__table__14.FieldSchema(name:tmp_values_col6, type:string, comment:), ]
-POSTHOOK: Lineage: table_change_date_group_string_group_date.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,c1,c2,c3,c4,c5,b from table_change_date_group_string_group_date
-PREHOOK: type: QUERY
-POSTHOOK: query: explain
-select insert_num,c1,c2,c3,c4,c5,b from table_change_date_group_string_group_date
-POSTHOOK: type: QUERY
-Explain
-STAGE DEPENDENCIES:
-  Stage-1 is a root stage
-  Stage-0 depends on stages: Stage-1
-
-STAGE PLANS:
-  Stage: Stage-1
-    Map Reduce
-      Map Operator Tree:
-          TableScan
-            alias: table_change_date_group_string_group_date
-            Statistics: Num rows: 3 Data size: 195 Basic stats: COMPLETE Column stats: NONE
-            Select Operator
-              expressions: insert_num (type: int), c1 (type: string), c2 (type: char(50)), c3 (type: char(15)), c4 (type: varchar(50)), c5 (type: varchar(15)), b (type: string)
-              outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6
-              Statistics: Num rows: 3 Data size: 195 Basic stats: COMPLETE Column stats: NONE
-              File Output Operator
-                compressed: false
-                Statistics: Num rows: 3 Data size: 195 Basic stats: COMPLETE Column stats: NONE
-                table:
-                    input format: org.apache.hadoop.mapred.SequenceFileInputFormat
-                    output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                    serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-      Execution mode: vectorized
-
-  Stage: Stage-0
-    Fetch Operator
-      limit: -1
-      Processor Tree:
-        ListSink
-
-PREHOOK: query: select insert_num,c1,c2,c3,c4,c5,b from table_change_date_group_string_group_date
-PREHOOK: type: QUERY
-PREHOOK: Input: default@table_change_date_group_string_group_date
-#### A masked pattern was here ####
-POSTHOOK: query: select insert_num,c1,c2,c3,c4,c5,b from table_change_date_group_string_group_date
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@table_change_date_group_string_group_date
-#### A masked pattern was here ####
-insert_num	c1	c2	c3	c4	c5	b
-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
-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: query: drop table table_change_date_group_string_group_date
-PREHOOK: type: DROPTABLE
-PREHOOK: Input: default@table_change_date_group_string_group_date
-PREHOOK: Output: default@table_change_date_group_string_group_date
-POSTHOOK: query: drop table table_change_date_group_string_group_date
-POSTHOOK: type: DROPTABLE
-POSTHOOK: Input: default@table_change_date_group_string_group_date
-POSTHOOK: Output: default@table_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 table_change_numeric_group_string_group_multi_ints_string(insert_num int, c1 tinyint, c2 smallint, c3 int, c4 bigint, b STRING)
-PREHOOK: type: CREATETABLE
-PREHOOK: Output: database:default
-PREHOOK: Output: default@table_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 table_change_numeric_group_string_group_multi_ints_string(insert_num int, c1 tinyint, c2 smallint, c3 int, c4 bigint, b STRING)
-POSTHOOK: type: CREATETABLE
-POSTHOOK: Output: database:default
-POSTHOOK: Output: default@table_change_numeric_group_string_group_multi_ints_string
-PREHOOK: query: insert into table table_change_numeric_group_string_group_multi_ints_string
-    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@table_change_numeric_group_string_group_multi_ints_string
-POSTHOOK: query: insert into table table_change_numeric_group_string_group_multi_ints_string
-    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@table_change_numeric_group_string_group_multi_ints_string
-POSTHOOK: Lineage: table_change_numeric_group_string_group_multi_ints_string.b SIMPLE [(values__tmp__table__15)values__tmp__table__15.FieldSchema(name:tmp_values_col6, type:string, comment:), ]
-POSTHOOK: Lineage: table_change_numeric_group_string_group_multi_ints_string.c1 EXPRESSION [(values__tmp__table__15)values__tmp__table__15.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
-POSTHOOK: Lineage: table_change_numeric_group_string_group_multi_ints_string.c2 EXPRESSION [(values__tmp__table__15)values__tmp__table__15.FieldSchema(name:tmp_values_col3, type:string, comment:), ]
-POSTHOOK: Lineage: table_change_numeric_group_string_group_multi_ints_string.c3 EXPRESSION [(values__tmp__table__15)values__tmp__table__15.FieldSchema(name:tmp_values_col4, type:string, comment:), ]
-POSTHOOK: Lineage: table_change_numeric_group_string_group_multi_ints_string.c4 EXPRESSION [(values__tmp__table__15)values__tmp__table__15.FieldSchema(name:tmp_values_col5, type:string, comment:), ]
-POSTHOOK: Lineage: table_change_numeric_group_string_group_multi_ints_string.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,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_string
-PREHOOK: type: QUERY
-PREHOOK: Input: default@table_change_numeric_group_string_group_multi_ints_string
-#### A masked pattern was here ####
-POSTHOOK: query: select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_string
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@table_change_numeric_group_string_group_multi_ints_string
-#### A masked pattern was here ####
-insert_num	c1	c2	c3	c4	b
-1	45	1000	483777	-23866739993	original
-2	-2	-6737	56	28899333	original
-3	NULL	4957	832222222	9000000000	original
-4	0	20435	847492223	-999999999999	original
-PREHOOK: query: -- Table-Non-Cascade CHANGE COLUMNS ...
-alter table table_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@table_change_numeric_group_string_group_multi_ints_string
-PREHOOK: Output: default@table_change_numeric_group_string_group_multi_ints_string
-POSTHOOK: query: -- Table-Non-Cascade CHANGE COLUMNS ...
-alter table table_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@table_change_numeric_group_string_group_multi_ints_string
-POSTHOOK: Output: default@table_change_numeric_group_string_group_multi_ints_string
-PREHOOK: query: insert into table table_change_numeric_group_string_group_multi_ints_string
-    values (5, '2000', '72909', '3244222', '-93222', 'new'),
-           (6, '1', '200', '2323322', '5430907', 'new'),
-           (7, '256', '32768', '31889', '470614135', 'new'),
-           (8, '5555', '40000', '-719017797', '810662019', 'new'),
-           (9, '100', '5000', '5443', '0', 'new'),
-           (10, '17', '90000', '754072151', '3289094', 'new')
-PREHOOK: type: QUERY
-PREHOOK: Output: default@table_change_numeric_group_string_group_multi_ints_string
-POSTHOOK: query: insert into table table_change_numeric_group_string_group_multi_ints_string
-    values (5, '2000', '72909', '3244222', '-93222', 'new'),
-           (6, '1', '200', '2323322', '5430907', 'new'),
-           (7, '256', '32768', '31889', '470614135', 'new'),
-           (8, '5555', '40000', '-719017797', '810662019', 'new'),
-           (9, '100', '5000', '5443', '0', 'new'),
-           (10, '17', '90000', '754072151', '3289094', 'new')
-POSTHOOK: type: QUERY
-POSTHOOK: Output: default@table_change_numeric_group_string_group_multi_ints_string
-POSTHOOK: Lineage: table_change_numeric_group_string_group_multi_ints_string.b SIMPLE [(values__tmp__table__16)values__tmp__table__16.FieldSchema(name:tmp_values_col6, type:string, comment:), ]
-POSTHOOK: Lineage: table_change_numeric_group_string_group_multi_ints_string.c1 SIMPLE [(values__tmp__table__16)values__tmp__table__16.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
-POSTHOOK: Lineage: table_change_numeric_group_string_group_multi_ints_string.c2 SIMPLE [(values__tmp__table__16)values__tmp__table__16.FieldSchema(name:tmp_values_col3, type:string, comment:), ]
-POSTHOOK: Lineage: table_change_numeric_group_string_group_multi_ints_string.c3 SIMPLE [(values__tmp__table__16)values__tmp__table__16.FieldSchema(name:tmp_values_col4, type:string, comment:), ]
-POSTHOOK: Lineage: table_change_numeric_group_string_group_multi_ints_string.c4 SIMPLE [(values__tmp__table__16)values__tmp__table__16.FieldSchema(name:tmp_values_col5, type:string, comment:), ]
-POSTHOOK: Lineage: table_change_numeric_group_string_group_multi_ints_string.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
-PREHOOK: query: explain
-select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_string
-PREHOOK: type: QUERY
-POSTHOOK: query: explain
-select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_string
-POSTHOOK: type: QUERY
-Explain
-STAGE DEPENDENCIES:
-  Stage-1 is a root stage
-  Stage-0 depends on stages: Stage-1
-
-STAGE PLANS:
-  Stage: Stage-1
-    Map Reduce
-      Map Operator Tree:
-          TableScan
-            alias: table_change_numeric_group_string_group_multi_ints_string
-            Statistics: Num rows: 4 Data size: 150 Basic stats: COMPLETE Column stats: NONE
-            Select Operator
-              expressions: insert_num (type: int), c1 (type: string), c2 (type: string), c3 (type: string), c4 (type: string), b (type: string)
-              outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
-              Statistics: Num rows: 4 Data size: 150 Basic stats: COMPLETE Column stats: NONE
-              File Output Operator
-                compressed: false
-                Statistics: Num rows: 4 Data size: 150 Basic stats: COMPLETE Column stats: NONE
-                table:
-                    input format: org.apache.hadoop.mapred.SequenceFileInputFormat
-                    output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                    serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-      Execution mode: vectorized
-
-  Stage: Stage-0
-    Fetch Operator
-      limit: -1
-      Processor Tree:
-        ListSink
-
-PREHOOK: query: select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_string
-PREHOOK: type: QUERY
-PREHOOK: Input: default@table_change_numeric_group_string_group_multi_ints_string
-#### A masked pattern was here ####
-POSTHOOK: query: select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_string
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@table_change_numeric_group_string_group_multi_ints_string
-#### A masked pattern was here ####
-insert_num	c1	c2	c3	c4	b
-1	45	1000	483777	-23866739993	original
-10	17	90000	754072151	3289094	new
-2	-2	-6737	56	28899333	original
-3	NULL	4957	832222222	9000000000	original
-4	0	20435	847492223	-999999999999	original
-5	2000	72909	3244222	-93222	new
-6	1	200	2323322	5430907	new
-7	256	32768	31889	470614135	new
-8	5555	40000	-719017797	810662019	new
-9	100	5000	5443	0	new
-PREHOOK: query: drop table table_change_numeric_group_string_group_multi_ints_string
-PREHOOK: type: DROPTABLE
-PREHOOK: Input: default@table_change_numeric_group_string_group_multi_ints_string
-PREHOOK: Output: default@table_change_numeric_group_string_group_multi_ints_string
-POSTHOOK: query: drop table table_change_numeric_group_string_group_multi_ints_string
-POSTHOOK: type: DROPTABLE
-POSTHOOK: Input: default@table_change_numeric_group_string_group_multi_ints_string
-POSTHOOK: Output: default@table_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 table_change_numeric_group_string_group_multi_ints_char(insert_num int, c1 tinyint, c2 smallint, c3 int, c4 bigint, b STRING)
-PREHOOK: type: CREATETABLE
-PREHOOK: Output: database:default
-PREHOOK: Output: default@table_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 table_change_numeric_group_string_group_multi_ints_char(insert_num int, c1 tinyint, c2 smallint, c3 int, c4 bigint, b STRING)
-POSTHOOK: type: CREATETABLE
-POSTHOOK: Output: database:default
-POSTHOOK: Output: default@table_change_numeric_group_string_group_multi_ints_char
-PREHOOK: query: insert into table table_change_numeric_group_string_group_multi_ints_char
-    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@table_change_numeric_group_string_group_multi_ints_char
-POSTHOOK: query: insert into table table_change_numeric_group_string_group_multi_ints_char
-    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@table_change_numeric_group_string_group_multi_ints_char
-POSTHOOK: Lineage: table_change_numeric_group_string_group_multi_ints_char.b SIMPLE [(values__tmp__table__17)values__tmp__table__17.FieldSchema(name:tmp_values_col6, type:string, comment:), ]
-POSTHOOK: Lineage: table_change_numeric_group_string_group_multi_ints_char.c1 EXPRESSION [(values__tmp__table__17)values__tmp__table__17.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
-POSTHOOK: Lineage: table_change_numeric_group_string_group_multi_ints_char.c2 EXPRESSION [(values__tmp__table__17)values__tmp__table__17.FieldSchema(name:tmp_values_col3, type:string, comment:), ]
-POSTHOOK: Lineage: table_change_numeric_group_string_group_multi_ints_char.c3 EXPRESSION [(values__tmp__table__17)values__tmp__table__17.FieldSchema(name:tmp_values_col4, type:string, comment:), ]
-POSTHOOK: Lineage: table_change_numeric_group_string_group_multi_ints_char.c4 EXPRESSION [(values__tmp__table__17)values__tmp__table__17.FieldSchema(name:tmp_values_col5, type:string, comment:), ]
-POSTHOOK: Lineage: table_change_numeric_group_string_group_multi_ints_char.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,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_char
-PREHOOK: type: QUERY
-PREHOOK: Input: default@table_change_numeric_group_string_group_multi_ints_char
-#### A masked pattern was here ####
-POSTHOOK: query: select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_char
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@table_change_numeric_group_string_group_multi_ints_char
-#### A masked pattern was here ####
-insert_num	c1	c2	c3	c4	b
-1	45	1000	483777	-23866739993	original
-2	-2	-6737	56	28899333	original
-3	NULL	4957	832222222	9000000000	original
-4	0	20435	847492223	-999999999999	original
-PREHOOK: query: -- Table-Non-Cascade CHANGE COLUMNS ...
-alter table table_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@table_change_numeric_group_string_group_multi_ints_char
-PREHOOK: Output: default@table_change_numeric_group_string_group_multi_ints_char
-POSTHOOK: query: -- Table-Non-Cascade CHANGE COLUMNS ...
-alter table table_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@table_change_numeric_group_string_group_multi_ints_char
-POSTHOOK: Output: default@table_change_numeric_group_string_group_multi_ints_char
-PREHOOK: query: insert into table table_change_numeric_group_string_group_multi_ints_char
-    values (5, '2000', '72909', '3244222', '-93222', 'new'),
-           (6, '1', '200', '2323322', '5430907', 'new'),
-           (7, '256', '32768', '31889', '470614135', 'new'),
-           (8, '5555', '40000', '-719017797', '810662019', 'new'),
-           (9, '100', '5000', '5443', '0', 'new'),
-           (10, '17', '90000', '754072151', '3289094', 'new')
-PREHOOK: type: QUERY
-PREHOOK: Output: default@table_change_numeric_group_string_group_multi_ints_char
-POSTHOOK: query: insert into table table_change_numeric_group_string_group_multi_ints_char
-    values (5, '2000', '72909', '3244222', '-93222', 'new'),
-           (6, '1', '200', '2323322', '5430907', 'new'),
-           (7, '256', '32768', '31889', '470614135', 'new'),
-           (8, '5555', '40000', '-719017797', '810662019', 'new'),
-           (9, '100', '5000', '5443', '0', 'new'),
-           (10, '17', '90000', '754072151', '3289094', 'new')
-POSTHOOK: type: QUERY
-POSTHOOK: Output: default@table_change_numeric_group_string_group_multi_ints_char
-POSTHOOK: Lineage: table_change_numeric_group_string_group_multi_ints_char.b SIMPLE [(values__tmp__table__18)values__tmp__table__18.FieldSchema(name:tmp_values_col6, type:string, comment:), ]
-POSTHOOK: Lineage: table_change_numeric_group_string_group_multi_ints_char.c1 EXPRESSION [(values__tmp__table__18)values__tmp__table__18.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
-POSTHOOK: Lineage: table_change_numeric_group_string_group_multi_ints_char.c2 EXPRESSION [(values__tmp__table__18)values__tmp__table__18.FieldSchema(name:tmp_values_col3, type:string, comment:), ]
-POSTHOOK: Lineage: table_change_numeric_group_string_group_multi_ints_char.c3 EXPRESSION [(values__tmp__table__18)values__tmp__table__18.FieldSchema(name:tmp_values_col4, type:string, comment:), ]
-POSTHOOK: Lineage: table_change_numeric_group_string_group_multi_ints_char.c4 EXPRESSION [(values__tmp__table__18)values__tmp__table__18.FieldSchema(name:tmp_values_col5, type:string, comment:), ]
-POSTHOOK: Lineage: table_change_numeric_group_string_group_multi_ints_char.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
-PREHOOK: query: explain
-select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_char
-PREHOOK: type: QUERY
-POSTHOOK: query: explain
-select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_char
-POSTHOOK: type: QUERY
-Explain
-STAGE DEPENDENCIES:
-  Stage-1 is a root stage
-  Stage-0 depends on stages: Stage-1
-
-STAGE PLANS:
-  Stage: Stage-1
-    Map Reduce
-      Map Operator Tree:
-          TableScan
-            alias: table_change_numeric_group_string_group_multi_ints_char
-            Statistics: Num rows: 4 Data size: 150 Basic stats: COMPLETE Column stats: NONE
-            Select Operator
-              expressions: insert_num (type: int), c1 (type: char(50)), c2 (type: char(50)), c3 (type: char(50)), c4 (type: char(50)), b (type: string)
-              outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
-              Statistics: Num rows: 4 Data size: 150 Basic stats: COMPLETE Column stats: NONE
-              File Output Operator
-                compressed: false
-                Statistics: Num rows: 4 Data size: 150 Basic stats: COMPLETE Column stats: NONE
-                table:
-                    input format: org.apache.hadoop.mapred.SequenceFileInputFormat
-                    output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                    serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-      Execution mode: vectorized
-
-  Stage: Stage-0
-    Fetch Operator
-      limit: -1
-      Processor Tree:
-        ListSink
-
-PREHOOK: query: select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_char
-PREHOOK: type: QUERY
-PREHOOK: Input: default@table_change_numeric_group_string_group_multi_ints_char
-#### A masked pattern was here ####
-POSTHOOK: query: select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_char
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@table_change_numeric_group_string_group_multi_ints_char
-#### A masked pattern was here ####
-insert_num	c1	c2	c3	c4	b
-1	45                                                	1000                                              	483777                                            	-23866739993                                      	original
-10	17                                                	90000                                             	754072151                                         	3289094                                           	new
-2	-2                                                	-6737                                             	56                                                	28899333                                          	original
-3	NULL	4957                                              	832222222                                         	9000000000                                        	original
-4	0                                                 	20435                                             	847492223                                         	-999999999999                                     	original
-5	2000                                              	72909                                             	3244222                                           	-93222                                            	new
-6	1                                                 	200                                               	2323322                                           	5430907                                           	new
-7	256                                               	32768                                             	31889                                             	470614135                                         	new
-8	5555                                              	40000                                             	-719017797                                        	810662019                                         	new
-9	100                                               	5000                                              	5443                                              	0                                                 	new
-PREHOOK: query: drop table table_change_numeric_group_string_group_multi_ints_char
-PREHOOK: type: DROPTABLE
-PREHOOK: Input: default@table_change_numeric_group_string_group_multi_ints_char
-PREHOOK: Output: default@table_change_numeric_group_string_group_multi_ints_char
-POSTHOOK: query: drop table table_change_numeric_group_string_group_multi_ints_char
-POSTHOOK: type: DROPTABLE
-POSTHOOK: Input: default@table_change_numeric_group_string_group_multi_ints_char
-POSTHOOK: Output: default@table_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 table_change_numeric_group_string_group_multi_ints_char_trunc(insert_num int, c1 tinyint, c2 smallint, c3 int, c4 bigint, b STRING)
-PREHOOK: type: CREATETABLE
-PREHOOK: Output: database:default
-PREHOOK: Output: default@table_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 table_change_numeric_group_string_group_multi_ints_char_trunc(insert_num int, c1 tinyint, c2 smallint, c3 int, c4 bigint, b STRING)
-POSTHOOK: type: CREATETABLE
-POSTHOOK: Output: database:default
-POSTHOOK: Output: default@table_change_numeric_group_string_group_multi_ints_char_trunc
-PREHOOK: query: insert into table table_change_numeric_group_string_group_multi_ints_char_trunc
-    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@table_change_numeric_group_string_group_multi_ints_char_trunc
-POSTHOOK: query: insert into table table_change_numeric_group_string_group_multi_ints_char_trunc
-    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@table_change_numeric_group_string_group_multi_ints_char_trunc
-POSTHOOK: Lineage: table_change_numeric_group_string_group_multi_ints_char_trunc.b SIMPLE [(values__tmp__table__19)values__tmp__table__19.FieldSchema(name:tmp_values_col6, type:string, comment:), ]
-POSTHOOK: Lineage: table_change_numeric_group_string_group_multi_ints_char_trunc.c1 EXPRESSION [(values__tmp__table__19)values__tmp__table__19.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
-POSTHOOK: Lineage: table_change_numeric_group_string_group_multi_ints_char_trunc.c2 EXPRESSION [(values__tmp__table__19)values__tmp__table__19.FieldSchema(name:tmp_values_col3, type:string, comment:), ]
-POSTHOOK: Lineage: table_change_numeric_group_string_group_multi_ints_char_trunc.c3 EXPRESSION [(values__tmp__table__19)values__tmp__table__19.FieldSchema(name:tmp_values_col4, type:string, comment:), ]
-POSTHOOK: Lineage: table_change_numeric_group_string_group_multi_ints_char_trunc.c4 EXPRESSION [(values__tmp__table__19)values__tmp__table__19.FieldSchema(name:tmp_values_col5, type:string, comment:), ]
-POSTHOOK: Lineage: table_change_numeric_group_string_group_multi_ints_char_trunc.insert_num EXPRESSION [(values__tmp__table__19)values__tmp__table__19.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
-_col0	_col1	_col2	_col3	_col4	_col5
-PREHOOK: query: select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_char_trunc
-PREHOOK: type: QUERY
-PREHOOK: Input: default@table_change_numeric_group_string_group_multi_ints_char_trunc
-#### A masked pattern was here ####
-POSTHOOK: query: select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_char_trunc
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@table_change_numeric_group_string_group_multi_ints_char_trunc
-#### A masked pattern was here ####
-insert_num	c1	c2	c3	c4	b
-1	45	1000	483777	-23866739993	original
-2	-2	-6737	56	28899333	original
-3	NULL	4957	832222222	9000000000	original
-4	0	20435	847492223	-999999999999	original
-PREHOOK: query: -- Table-Non-Cascade CHANGE COLUMNS ...
-alter table table_change_numeric_group_string_group_multi_ints_char_trunc replace columns (insert_num int, c1 CHAR(5), c2 CHAR(5), c3 CHAR(5), c4 CHAR(5), b STRING)
-PREHOOK: type: ALTERTABLE_REPLACECOLS
-PREHOOK: Input: default@table_change_numeric_group_string_group_multi_ints_char_trunc
-PREHOOK: Output: default@table_change_numeric_group_string_group_multi_ints_char_trunc
-POSTHOOK: query: -- Table-Non-Cascade CHANGE COLUMNS ...
-alter table table_change_numeric_group_string_group_multi_ints_char_trunc replace columns (insert_num int, c1 CHAR(5), c2 CHAR(5), c3 CHAR(5), c4 CHAR(5), b STRING)
-POSTHOOK: type: ALTERTABLE_REPLACECOLS
-POSTHOOK: Input: default@table_change_numeric_group_string_group_multi_ints_char_trunc
-POSTHOOK: Output: default@table_change_numeric_group_string_group_multi_ints_char_trunc
-PREHOOK:

<TRUNCATED>

Mime
View raw message