http://git-wip-us.apache.org/repos/asf/hive/blob/fa995bae/ql/src/test/results/clientpositive/llap/schema_evol_orc_acid_mapwork_table.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/schema_evol_orc_acid_mapwork_table.q.out b/ql/src/test/results/clientpositive/llap/schema_evol_orc_acid_mapwork_table.q.out index 655bb67..ede8693 100644 --- a/ql/src/test/results/clientpositive/llap/schema_evol_orc_acid_mapwork_table.q.out +++ b/ql/src/test/results/clientpositive/llap/schema_evol_orc_acid_mapwork_table.q.out @@ -38,7 +38,6 @@ PREHOOK: query: insert into table table_add_int_permute_select (3, 3, 'original'), (4, 4, 'original') PREHOOK: type: QUERY -PREHOOK: Input: default@values__tmp__table__1 PREHOOK: Output: default@table_add_int_permute_select POSTHOOK: query: insert into table table_add_int_permute_select values (1, 1, 'original'), @@ -46,7 +45,6 @@ POSTHOOK: query: insert into table table_add_int_permute_select (3, 3, 'original'), (4, 4, 'original') POSTHOOK: type: QUERY -POSTHOOK: Input: default@values__tmp__table__1 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:), ] @@ -68,7 +66,6 @@ PREHOOK: query: insert into table table_add_int_permute_select (7, 3, 'new', 30), (8, 4, 'new', 40) PREHOOK: type: QUERY -PREHOOK: Input: default@values__tmp__table__2 PREHOOK: Output: default@table_add_int_permute_select POSTHOOK: query: insert into table table_add_int_permute_select values (5, 1, 'new', 10), @@ -76,7 +73,6 @@ POSTHOOK: query: insert into table table_add_int_permute_select (7, 3, 'new', 30), (8, 4, 'new', 40) POSTHOOK: type: QUERY -POSTHOOK: Input: default@values__tmp__table__2 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:), ] @@ -87,13 +83,11 @@ PREHOOK: query: insert into table table_add_int_permute_select values (9, 5, 'new', 100), (10, 6, 'new', 200) PREHOOK: type: QUERY -PREHOOK: Input: default@values__tmp__table__3 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: Input: default@values__tmp__table__3 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:), ] @@ -187,7 +181,6 @@ PREHOOK: query: insert into table table_add_int_string_permute_select (3, 3, 'original'), (4, 4, 'original') PREHOOK: type: QUERY -PREHOOK: Input: default@values__tmp__table__4 PREHOOK: Output: default@table_add_int_string_permute_select POSTHOOK: query: insert into table table_add_int_string_permute_select values (1, 1, 'original'), @@ -195,7 +188,6 @@ POSTHOOK: query: insert into table table_add_int_string_permute_select (3, 3, 'original'), (4, 4, 'original') POSTHOOK: type: QUERY -POSTHOOK: Input: default@values__tmp__table__4 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:), ] @@ -217,7 +209,6 @@ PREHOOK: query: insert into table table_add_int_string_permute_select (7, 3, 'new', 30, 'thirty'), (8, 4, 'new', 40, 'forty') PREHOOK: type: QUERY -PREHOOK: Input: default@values__tmp__table__5 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'), @@ -225,7 +216,6 @@ POSTHOOK: query: insert into table table_add_int_string_permute_select (7, 3, 'new', 30, 'thirty'), (8, 4, 'new', 40, 'forty') POSTHOOK: type: QUERY -POSTHOOK: Input: default@values__tmp__table__5 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:), ] @@ -237,13 +227,11 @@ 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: Input: default@values__tmp__table__6 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: Input: default@values__tmp__table__6 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:), ] @@ -422,7 +410,6 @@ PREHOOK: query: insert into table table_change_string_group_double (3, '-29.0764', '-29.0764', '-29.0764', 'original'), (4, '-10.3', '-10.3', '-10.3', 'original') PREHOOK: type: QUERY -PREHOOK: Input: default@values__tmp__table__7 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'), @@ -430,7 +417,6 @@ POSTHOOK: query: insert into table table_change_string_group_double (3, '-29.0764', '-29.0764', '-29.0764', 'original'), (4, '-10.3', '-10.3', '-10.3', 'original') POSTHOOK: type: QUERY -POSTHOOK: Input: default@values__tmp__table__7 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:), ] @@ -454,7 +440,6 @@ PREHOOK: query: insert into table table_change_string_group_double (7, 46114.284799488, 46114.284799488, 46114.284799488, 'new'), (8, -66475.561431, -66475.561431, -66475.561431, 'new') PREHOOK: type: QUERY -PREHOOK: Input: default@values__tmp__table__8 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'), @@ -462,7 +447,6 @@ POSTHOOK: query: insert into table table_change_string_group_double (7, 46114.284799488, 46114.284799488, 46114.284799488, 'new'), (8, -66475.561431, -66475.561431, -66475.561431, 'new') POSTHOOK: type: QUERY -POSTHOOK: Input: default@values__tmp__table__8 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:), ] @@ -474,13 +458,11 @@ 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: Input: default@values__tmp__table__9 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: Input: default@values__tmp__table__9 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:), ] @@ -542,14 +524,12 @@ PREHOOK: query: insert into table table_change_date_group_string_group_timestamp (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: Input: default@values__tmp__table__10 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: Input: default@values__tmp__table__10 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:), ] @@ -575,7 +555,6 @@ PREHOOK: query: insert into table table_change_date_group_string_group_timestamp (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: Input: default@values__tmp__table__11 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'), @@ -583,7 +562,6 @@ POSTHOOK: query: insert into table table_change_date_group_string_group_timestam (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: Input: default@values__tmp__table__11 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:), ] @@ -597,13 +575,11 @@ 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: Input: default@values__tmp__table__12 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: Input: default@values__tmp__table__12 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:), ] @@ -658,14 +634,12 @@ PREHOOK: query: insert into table table_change_date_group_string_group_date (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: Input: default@values__tmp__table__13 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: Input: default@values__tmp__table__13 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:), ] @@ -693,7 +667,6 @@ PREHOOK: query: insert into table table_change_date_group_string_group_date (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: Input: default@values__tmp__table__14 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'), @@ -703,7 +676,6 @@ POSTHOOK: query: insert into table table_change_date_group_string_group_date (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: Input: default@values__tmp__table__14 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:), ] @@ -767,7 +739,6 @@ PREHOOK: query: insert into table table_change_numeric_group_string_group_multi_ (3, -255, 4957, 832222222, 9000000000, 'original'), (4, 0, 20435, 847492223, -999999999999, 'original') PREHOOK: type: QUERY -PREHOOK: Input: default@values__tmp__table__15 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'), @@ -775,7 +746,6 @@ POSTHOOK: query: insert into table table_change_numeric_group_string_group_multi (3, -255, 4957, 832222222, 9000000000, 'original'), (4, 0, 20435, 847492223, -999999999999, 'original') POSTHOOK: type: QUERY -POSTHOOK: Input: default@values__tmp__table__15 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:), ] @@ -815,7 +785,6 @@ PREHOOK: query: insert into table table_change_numeric_group_string_group_multi_ (9, '100', '5000', '5443', '0', 'new'), (10, '17', '90000', '754072151', '3289094', 'new') PREHOOK: type: QUERY -PREHOOK: Input: default@values__tmp__table__16 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'), @@ -825,7 +794,6 @@ POSTHOOK: query: insert into table table_change_numeric_group_string_group_multi (9, '100', '5000', '5443', '0', 'new'), (10, '17', '90000', '754072151', '3289094', 'new') POSTHOOK: type: QUERY -POSTHOOK: Input: default@values__tmp__table__16 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:), ] @@ -881,7 +849,6 @@ PREHOOK: query: insert into table table_change_numeric_group_string_group_multi_ (3, -255, 4957, 832222222, 9000000000, 'original'), (4, 0, 20435, 847492223, -999999999999, 'original') PREHOOK: type: QUERY -PREHOOK: Input: default@values__tmp__table__17 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'), @@ -889,7 +856,6 @@ POSTHOOK: query: insert into table table_change_numeric_group_string_group_multi (3, -255, 4957, 832222222, 9000000000, 'original'), (4, 0, 20435, 847492223, -999999999999, 'original') POSTHOOK: type: QUERY -POSTHOOK: Input: default@values__tmp__table__17 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:), ] @@ -929,7 +895,6 @@ PREHOOK: query: insert into table table_change_numeric_group_string_group_multi_ (9, '100', '5000', '5443', '0', 'new'), (10, '17', '90000', '754072151', '3289094', 'new') PREHOOK: type: QUERY -PREHOOK: Input: default@values__tmp__table__18 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'), @@ -939,7 +904,6 @@ POSTHOOK: query: insert into table table_change_numeric_group_string_group_multi (9, '100', '5000', '5443', '0', 'new'), (10, '17', '90000', '754072151', '3289094', 'new') POSTHOOK: type: QUERY -POSTHOOK: Input: default@values__tmp__table__18 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:), ] @@ -995,7 +959,6 @@ PREHOOK: query: insert into table table_change_numeric_group_string_group_multi_ (3, -255, 4957, 832222222, 9000000000, 'original'), (4, 0, 20435, 847492223, -999999999999, 'original') PREHOOK: type: QUERY -PREHOOK: Input: default@values__tmp__table__19 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'), @@ -1003,7 +966,6 @@ POSTHOOK: query: insert into table table_change_numeric_group_string_group_multi (3, -255, 4957, 832222222, 9000000000, 'original'), (4, 0, 20435, 847492223, -999999999999, 'original') POSTHOOK: type: QUERY -POSTHOOK: Input: default@values__tmp__table__19 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:), ] @@ -1043,7 +1005,6 @@ PREHOOK: query: insert into table table_change_numeric_group_string_group_multi_ (9, '100', '5000', '5443', '0', 'new'), (10, '17', '90000', '754072151', '3289094', 'new') PREHOOK: type: QUERY -PREHOOK: Input: default@values__tmp__table__20 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 (5, '2000', '72909', '3244222', '-93222', 'new'), @@ -1053,7 +1014,6 @@ POSTHOOK: query: insert into table table_change_numeric_group_string_group_multi (9, '100', '5000', '5443', '0', 'new'), (10, '17', '90000', '754072151', '3289094', 'new') POSTHOOK: type: QUERY -POSTHOOK: Input: default@values__tmp__table__20 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__20)values__tmp__table__20.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__20)values__tmp__table__20.FieldSchema(name:tmp_values_col2, type:string, comment:), ] @@ -1109,7 +1069,6 @@ PREHOOK: query: insert into table table_change_numeric_group_string_group_multi_ (3, -255, 4957, 832222222, 9000000000, 'original'), (4, 0, 20435, 847492223, -999999999999, 'original') PREHOOK: type: QUERY -PREHOOK: Input: default@values__tmp__table__21 PREHOOK: Output: default@table_change_numeric_group_string_group_multi_ints_varchar POSTHOOK: query: insert into table table_change_numeric_group_string_group_multi_ints_varchar values (1, 45, 1000, 483777, -23866739993, 'original'), @@ -1117,7 +1076,6 @@ POSTHOOK: query: insert into table table_change_numeric_group_string_group_multi (3, -255, 4957, 832222222, 9000000000, 'original'), (4, 0, 20435, 847492223, -999999999999, 'original') POSTHOOK: type: QUERY -POSTHOOK: Input: default@values__tmp__table__21 POSTHOOK: Output: default@table_change_numeric_group_string_group_multi_ints_varchar POSTHOOK: Lineage: table_change_numeric_group_string_group_multi_ints_varchar.b SIMPLE [(values__tmp__table__21)values__tmp__table__21.FieldSchema(name:tmp_values_col6, type:string, comment:), ] POSTHOOK: Lineage: table_change_numeric_group_string_group_multi_ints_varchar.c1 EXPRESSION [(values__tmp__table__21)values__tmp__table__21.FieldSchema(name:tmp_values_col2, type:string, comment:), ] @@ -1157,7 +1115,6 @@ PREHOOK: query: insert into table table_change_numeric_group_string_group_multi_ (9, '100', '5000', '5443', '0', 'new'), (10, '17', '90000', '754072151', '3289094', 'new') PREHOOK: type: QUERY -PREHOOK: Input: default@values__tmp__table__22 PREHOOK: Output: default@table_change_numeric_group_string_group_multi_ints_varchar POSTHOOK: query: insert into table table_change_numeric_group_string_group_multi_ints_varchar values (5, '2000', '72909', '3244222', '-93222', 'new'), @@ -1167,7 +1124,6 @@ POSTHOOK: query: insert into table table_change_numeric_group_string_group_multi (9, '100', '5000', '5443', '0', 'new'), (10, '17', '90000', '754072151', '3289094', 'new') POSTHOOK: type: QUERY -POSTHOOK: Input: default@values__tmp__table__22 POSTHOOK: Output: default@table_change_numeric_group_string_group_multi_ints_varchar POSTHOOK: Lineage: table_change_numeric_group_string_group_multi_ints_varchar.b SIMPLE [(values__tmp__table__22)values__tmp__table__22.FieldSchema(name:tmp_values_col6, type:string, comment:), ] POSTHOOK: Lineage: table_change_numeric_group_string_group_multi_ints_varchar.c1 EXPRESSION [(values__tmp__table__22)values__tmp__table__22.FieldSchema(name:tmp_values_col2, type:string, comment:), ] @@ -1223,7 +1179,6 @@ PREHOOK: query: insert into table table_change_numeric_group_string_group_multi_ (3, -255, 4957, 832222222, 9000000000, 'original'), (4, 0, 20435, 847492223, -999999999999, 'original') PREHOOK: type: QUERY -PREHOOK: Input: default@values__tmp__table__23 PREHOOK: Output: default@table_change_numeric_group_string_group_multi_ints_varchar_trunc POSTHOOK: query: insert into table table_change_numeric_group_string_group_multi_ints_varchar_trunc values (1, 45, 1000, 483777, -23866739993, 'original'), @@ -1231,7 +1186,6 @@ POSTHOOK: query: insert into table table_change_numeric_group_string_group_multi (3, -255, 4957, 832222222, 9000000000, 'original'), (4, 0, 20435, 847492223, -999999999999, 'original') POSTHOOK: type: QUERY -POSTHOOK: Input: default@values__tmp__table__23 POSTHOOK: Output: default@table_change_numeric_group_string_group_multi_ints_varchar_trunc POSTHOOK: Lineage: table_change_numeric_group_string_group_multi_ints_varchar_trunc.b SIMPLE [(values__tmp__table__23)values__tmp__table__23.FieldSchema(name:tmp_values_col6, type:string, comment:), ] POSTHOOK: Lineage: table_change_numeric_group_string_group_multi_ints_varchar_trunc.c1 EXPRESSION [(values__tmp__table__23)values__tmp__table__23.FieldSchema(name:tmp_values_col2, type:string, comment:), ] @@ -1271,7 +1225,6 @@ PREHOOK: query: insert into table table_change_numeric_group_string_group_multi_ (9, '100', '5000', '5443', '0', 'new'), (10, '17', '90000', '754072151', '3289094', 'new') PREHOOK: type: QUERY -PREHOOK: Input: default@values__tmp__table__24 PREHOOK: Output: default@table_change_numeric_group_string_group_multi_ints_varchar_trunc POSTHOOK: query: insert into table table_change_numeric_group_string_group_multi_ints_varchar_trunc values (5, '2000', '72909', '3244222', '-93222', 'new'), @@ -1281,7 +1234,6 @@ POSTHOOK: query: insert into table table_change_numeric_group_string_group_multi (9, '100', '5000', '5443', '0', 'new'), (10, '17', '90000', '754072151', '3289094', 'new') POSTHOOK: type: QUERY -POSTHOOK: Input: default@values__tmp__table__24 POSTHOOK: Output: default@table_change_numeric_group_string_group_multi_ints_varchar_trunc POSTHOOK: Lineage: table_change_numeric_group_string_group_multi_ints_varchar_trunc.b SIMPLE [(values__tmp__table__24)values__tmp__table__24.FieldSchema(name:tmp_values_col6, type:string, comment:), ] POSTHOOK: Lineage: table_change_numeric_group_string_group_multi_ints_varchar_trunc.c1 EXPRESSION [(values__tmp__table__24)values__tmp__table__24.FieldSchema(name:tmp_values_col2, type:string, comment:), ] @@ -1337,7 +1289,6 @@ PREHOOK: query: insert into table table_change_numeric_group_string_group_floati (3, - 832222222, 255, 4957,'original'), (4, 847492223, 0, 20435, 'original') PREHOOK: type: QUERY -PREHOOK: Input: default@values__tmp__table__25 PREHOOK: Output: default@table_change_numeric_group_string_group_floating_string POSTHOOK: query: insert into table table_change_numeric_group_string_group_floating_string values (1, -23866739993, 753.7028, -3651.672121, 'original'), @@ -1345,7 +1296,6 @@ POSTHOOK: query: insert into table table_change_numeric_group_string_group_float (3, - 832222222, 255, 4957,'original'), (4, 847492223, 0, 20435, 'original') POSTHOOK: type: QUERY -POSTHOOK: Input: default@values__tmp__table__25 POSTHOOK: Output: default@table_change_numeric_group_string_group_floating_string POSTHOOK: Lineage: table_change_numeric_group_string_group_floating_string.b SIMPLE [(values__tmp__table__25)values__tmp__table__25.FieldSchema(name:tmp_values_col5, type:string, comment:), ] POSTHOOK: Lineage: table_change_numeric_group_string_group_floating_string.c1 EXPRESSION [(values__tmp__table__25)values__tmp__table__25.FieldSchema(name:tmp_values_col2, type:string, comment:), ] @@ -1384,7 +1334,6 @@ PREHOOK: query: insert into table table_change_numeric_group_string_group_floati (9, '100', '5000', '5443', 'new'), (10, '17', '90000', '754072151', 'new') PREHOOK: type: QUERY -PREHOOK: Input: default@values__tmp__table__26 PREHOOK: Output: default@table_change_numeric_group_string_group_floating_string POSTHOOK: query: insert into table table_change_numeric_group_string_group_floating_string values (5, '30.774', '20.31', '46114.284799488', 'new'), @@ -1394,7 +1343,6 @@ POSTHOOK: query: insert into table table_change_numeric_group_string_group_float (9, '100', '5000', '5443', 'new'), (10, '17', '90000', '754072151', 'new') POSTHOOK: type: QUERY -POSTHOOK: Input: default@values__tmp__table__26 POSTHOOK: Output: default@table_change_numeric_group_string_group_floating_string POSTHOOK: Lineage: table_change_numeric_group_string_group_floating_string.b SIMPLE [(values__tmp__table__26)values__tmp__table__26.FieldSchema(name:tmp_values_col5, type:string, comment:), ] POSTHOOK: Lineage: table_change_numeric_group_string_group_floating_string.c1 SIMPLE [(values__tmp__table__26)values__tmp__table__26.FieldSchema(name:tmp_values_col2, type:string, comment:), ] @@ -1449,7 +1397,6 @@ PREHOOK: query: insert into table table_change_numeric_group_string_group_floati (3, 9000000000, -255, 4957,'original'), (4, -999999999999, 0, 20435, 'original') PREHOOK: type: QUERY -PREHOOK: Input: default@values__tmp__table__27 PREHOOK: Output: default@table_change_numeric_group_string_group_floating_char POSTHOOK: query: insert into table table_change_numeric_group_string_group_floating_char values (1, -23866739993, 753.7028, -3651.672121, 'original'), @@ -1457,7 +1404,6 @@ POSTHOOK: query: insert into table table_change_numeric_group_string_group_float (3, 9000000000, -255, 4957,'original'), (4, -999999999999, 0, 20435, 'original') POSTHOOK: type: QUERY -POSTHOOK: Input: default@values__tmp__table__27 POSTHOOK: Output: default@table_change_numeric_group_string_group_floating_char POSTHOOK: Lineage: table_change_numeric_group_string_group_floating_char.b SIMPLE [(values__tmp__table__27)values__tmp__table__27.FieldSchema(name:tmp_values_col5, type:string, comment:), ] POSTHOOK: Lineage: table_change_numeric_group_string_group_floating_char.c1 EXPRESSION [(values__tmp__table__27)values__tmp__table__27.FieldSchema(name:tmp_values_col2, type:string, comment:), ] @@ -1496,7 +1442,6 @@ PREHOOK: query: insert into table table_change_numeric_group_string_group_floati (9, '100', '5000', '5443', 'new'), (10, '17', '90000', '754072151', 'new') PREHOOK: type: QUERY -PREHOOK: Input: default@values__tmp__table__28 PREHOOK: Output: default@table_change_numeric_group_string_group_floating_char POSTHOOK: query: insert into table table_change_numeric_group_string_group_floating_char values (5, '30.774', '20.31', '46114.284799488', 'new'), @@ -1506,7 +1451,6 @@ POSTHOOK: query: insert into table table_change_numeric_group_string_group_float (9, '100', '5000', '5443', 'new'), (10, '17', '90000', '754072151', 'new') POSTHOOK: type: QUERY -POSTHOOK: Input: default@values__tmp__table__28 POSTHOOK: Output: default@table_change_numeric_group_string_group_floating_char POSTHOOK: Lineage: table_change_numeric_group_string_group_floating_char.b SIMPLE [(values__tmp__table__28)values__tmp__table__28.FieldSchema(name:tmp_values_col5, type:string, comment:), ] POSTHOOK: Lineage: table_change_numeric_group_string_group_floating_char.c1 EXPRESSION [(values__tmp__table__28)values__tmp__table__28.FieldSchema(name:tmp_values_col2, type:string, comment:), ] @@ -1561,7 +1505,6 @@ PREHOOK: query: insert into table table_change_numeric_group_string_group_floati (3, 832222222, -255, 4957, 'original'), (4, 847492223, 0, 20435, 'original') PREHOOK: type: QUERY -PREHOOK: Input: default@values__tmp__table__29 PREHOOK: Output: default@table_change_numeric_group_string_group_floating_char_trunc POSTHOOK: query: insert into table table_change_numeric_group_string_group_floating_char_trunc values (1, -23866739993, 753.7028, -3651.672121, 'original'), @@ -1569,7 +1512,6 @@ POSTHOOK: query: insert into table table_change_numeric_group_string_group_float (3, 832222222, -255, 4957, 'original'), (4, 847492223, 0, 20435, 'original') POSTHOOK: type: QUERY -POSTHOOK: Input: default@values__tmp__table__29 POSTHOOK: Output: default@table_change_numeric_group_string_group_floating_char_trunc POSTHOOK: Lineage: table_change_numeric_group_string_group_floating_char_trunc.b SIMPLE [(values__tmp__table__29)values__tmp__table__29.FieldSchema(name:tmp_values_col5, type:string, comment:), ] POSTHOOK: Lineage: table_change_numeric_group_string_group_floating_char_trunc.c1 EXPRESSION [(values__tmp__table__29)values__tmp__table__29.FieldSchema(name:tmp_values_col2, type:string, comment:), ] @@ -1608,7 +1550,6 @@ PREHOOK: query: insert into table table_change_numeric_group_string_group_floati (9, '100', '5000', '5443', 'new'), (10, '17', '90000', '754072151', 'new') PREHOOK: type: QUERY -PREHOOK: Input: default@values__tmp__table__30 PREHOOK: Output: default@table_change_numeric_group_string_group_floating_char_trunc POSTHOOK: query: insert into table table_change_numeric_group_string_group_floating_char_trunc values (5, '30.774', '20.31', '46114.284799488', 'new'), @@ -1618,7 +1559,6 @@ POSTHOOK: query: insert into table table_change_numeric_group_string_group_float (9, '100', '5000', '5443', 'new'), (10, '17', '90000', '754072151', 'new') POSTHOOK: type: QUERY -POSTHOOK: Input: default@values__tmp__table__30 POSTHOOK: Output: default@table_change_numeric_group_string_group_floating_char_trunc POSTHOOK: Lineage: table_change_numeric_group_string_group_floating_char_trunc.b SIMPLE [(values__tmp__table__30)values__tmp__table__30.FieldSchema(name:tmp_values_col5, type:string, comment:), ] POSTHOOK: Lineage: table_change_numeric_group_string_group_floating_char_trunc.c1 EXPRESSION [(values__tmp__table__30)values__tmp__table__30.FieldSchema(name:tmp_values_col2, type:string, comment:), ] @@ -1673,7 +1613,6 @@ PREHOOK: query: insert into table table_change_numeric_group_string_group_floati (3, 9000000000, -255, 4957, 'original'), (4, -999999999999, 0, 20435, 'original') PREHOOK: type: QUERY -PREHOOK: Input: default@values__tmp__table__31 PREHOOK: Output: default@table_change_numeric_group_string_group_floating_varchar POSTHOOK: query: insert into table table_change_numeric_group_string_group_floating_varchar values (1, -23866739993, 753.7028, -3651.672121, 'original'), @@ -1681,7 +1620,6 @@ POSTHOOK: query: insert into table table_change_numeric_group_string_group_float (3, 9000000000, -255, 4957, 'original'), (4, -999999999999, 0, 20435, 'original') POSTHOOK: type: QUERY -POSTHOOK: Input: default@values__tmp__table__31 POSTHOOK: Output: default@table_change_numeric_group_string_group_floating_varchar POSTHOOK: Lineage: table_change_numeric_group_string_group_floating_varchar.b SIMPLE [(values__tmp__table__31)values__tmp__table__31.FieldSchema(name:tmp_values_col5, type:string, comment:), ] POSTHOOK: Lineage: table_change_numeric_group_string_group_floating_varchar.c1 EXPRESSION [(values__tmp__table__31)values__tmp__table__31.FieldSchema(name:tmp_values_col2, type:string, comment:), ] @@ -1720,7 +1658,6 @@ PREHOOK: query: insert into table table_change_numeric_group_string_group_floati (9, '100', '5000', '5443', 'new'), (10, '17', '90000', '754072151', 'new') PREHOOK: type: QUERY -PREHOOK: Input: default@values__tmp__table__32 PREHOOK: Output: default@table_change_numeric_group_string_group_floating_varchar POSTHOOK: query: insert into table table_change_numeric_group_string_group_floating_varchar values (5, '30.774', '20.31', '46114.284799488', 'new'), @@ -1730,7 +1667,6 @@ POSTHOOK: query: insert into table table_change_numeric_group_string_group_float (9, '100', '5000', '5443', 'new'), (10, '17', '90000', '754072151', 'new') POSTHOOK: type: QUERY -POSTHOOK: Input: default@values__tmp__table__32 POSTHOOK: Output: default@table_change_numeric_group_string_group_floating_varchar POSTHOOK: Lineage: table_change_numeric_group_string_group_floating_varchar.b SIMPLE [(values__tmp__table__32)values__tmp__table__32.FieldSchema(name:tmp_values_col5, type:string, comment:), ] POSTHOOK: Lineage: table_change_numeric_group_string_group_floating_varchar.c1 EXPRESSION [(values__tmp__table__32)values__tmp__table__32.FieldSchema(name:tmp_values_col2, type:string, comment:), ] @@ -1785,7 +1721,6 @@ PREHOOK: query: insert into table table_change_numeric_group_string_group_floati (3, 9000000000, -255, 4957, 'original'), (4, -999999999999, 0, 20435, 'original') PREHOOK: type: QUERY -PREHOOK: Input: default@values__tmp__table__33 PREHOOK: Output: default@table_change_numeric_group_string_group_floating_varchar_trunc POSTHOOK: query: insert into table table_change_numeric_group_string_group_floating_varchar_trunc values (1, -23866739993, 753.7028, -3651.672121, 'original'), @@ -1793,7 +1728,6 @@ POSTHOOK: query: insert into table table_change_numeric_group_string_group_float (3, 9000000000, -255, 4957, 'original'), (4, -999999999999, 0, 20435, 'original') POSTHOOK: type: QUERY -POSTHOOK: Input: default@values__tmp__table__33 POSTHOOK: Output: default@table_change_numeric_group_string_group_floating_varchar_trunc POSTHOOK: Lineage: table_change_numeric_group_string_group_floating_varchar_trunc.b SIMPLE [(values__tmp__table__33)values__tmp__table__33.FieldSchema(name:tmp_values_col5, type:string, comment:), ] POSTHOOK: Lineage: table_change_numeric_group_string_group_floating_varchar_trunc.c1 EXPRESSION [(values__tmp__table__33)values__tmp__table__33.FieldSchema(name:tmp_values_col2, type:string, comment:), ] @@ -1832,7 +1766,6 @@ PREHOOK: query: insert into table table_change_numeric_group_string_group_floati (9, '100', '5000', '5443', 'new'), (10, '17', '90000', '754072151', 'new') PREHOOK: type: QUERY -PREHOOK: Input: default@values__tmp__table__34 PREHOOK: Output: default@table_change_numeric_group_string_group_floating_varchar_trunc POSTHOOK: query: insert into table table_change_numeric_group_string_group_floating_varchar_trunc values (5, '30.774', '20.31', '46114.284799488', 'new'), @@ -1842,7 +1775,6 @@ POSTHOOK: query: insert into table table_change_numeric_group_string_group_float (9, '100', '5000', '5443', 'new'), (10, '17', '90000', '754072151', 'new') POSTHOOK: type: QUERY -POSTHOOK: Input: default@values__tmp__table__34 POSTHOOK: Output: default@table_change_numeric_group_string_group_floating_varchar_trunc POSTHOOK: Lineage: table_change_numeric_group_string_group_floating_varchar_trunc.b SIMPLE [(values__tmp__table__34)values__tmp__table__34.FieldSchema(name:tmp_values_col5, type:string, comment:), ] POSTHOOK: Lineage: table_change_numeric_group_string_group_floating_varchar_trunc.c1 EXPRESSION [(values__tmp__table__34)values__tmp__table__34.FieldSchema(name:tmp_values_col2, type:string, comment:), ] @@ -1905,7 +1837,6 @@ PREHOOK: query: insert into table table_change_string_group_string_group_string (3, 'dynamic reptile', 'dynamic reptile', 'dynamic reptile', 'dynamic reptile', 'original'), (4, 'blank pads ', 'blank pads ', 'blank pads ', 'blank pads ', 'original') PREHOOK: type: QUERY -PREHOOK: Input: default@values__tmp__table__35 PREHOOK: Output: default@table_change_string_group_string_group_string POSTHOOK: query: insert into table table_change_string_group_string_group_string values (1, 'escapist', 'escapist', 'escapist', 'escapist', 'original'), @@ -1913,7 +1844,6 @@ POSTHOOK: query: insert into table table_change_string_group_string_group_string (3, 'dynamic reptile', 'dynamic reptile', 'dynamic reptile', 'dynamic reptile', 'original'), (4, 'blank pads ', 'blank pads ', 'blank pads ', 'blank pads ', 'original') POSTHOOK: type: QUERY -POSTHOOK: Input: default@values__tmp__table__35 POSTHOOK: Output: default@table_change_string_group_string_group_string POSTHOOK: Lineage: table_change_string_group_string_group_string.b SIMPLE [(values__tmp__table__35)values__tmp__table__35.FieldSchema(name:tmp_values_col6, type:string, comment:), ] POSTHOOK: Lineage: table_change_string_group_string_group_string.c1 SIMPLE [(values__tmp__table__35)values__tmp__table__35.FieldSchema(name:tmp_values_col2, type:string, comment:), ] @@ -1953,7 +1883,6 @@ PREHOOK: query: insert into table table_change_string_group_string_group_string (9, 'hangar paralysed companion ', 'hangar paralysed companion ', 'hangar paralysed companion ', 'hangar paralysed companion ', 'new'), (10, 'bottom ', 'bottom ', 'bottom ', 'bottom ', 'new') PREHOOK: type: QUERY -PREHOOK: Input: default@values__tmp__table__36 PREHOOK: Output: default@table_change_string_group_string_group_string POSTHOOK: query: insert into table table_change_string_group_string_group_string values (5, 'junkyard', 'junkyard', 'junkyard', 'junkyard', 'new'), @@ -1963,7 +1892,6 @@ POSTHOOK: query: insert into table table_change_string_group_string_group_string (9, 'hangar paralysed companion ', 'hangar paralysed companion ', 'hangar paralysed companion ', 'hangar paralysed companion ', 'new'), (10, 'bottom ', 'bottom ', 'bottom ', 'bottom ', 'new') POSTHOOK: type: QUERY -POSTHOOK: Input: default@values__tmp__table__36 POSTHOOK: Output: default@table_change_string_group_string_group_string POSTHOOK: Lineage: table_change_string_group_string_group_string.b SIMPLE [(values__tmp__table__36)values__tmp__table__36.FieldSchema(name:tmp_values_col6, type:string, comment:), ] POSTHOOK: Lineage: table_change_string_group_string_group_string.c1 EXPRESSION [(values__tmp__table__36)values__tmp__table__36.FieldSchema(name:tmp_values_col2, type:string, comment:), ] @@ -2019,7 +1947,6 @@ PREHOOK: query: insert into table table_change_string_group_string_group_char (3, 'dynamic reptile', 'dynamic reptile', 'dynamic reptile', 'original'), (4, 'blank pads ', 'blank pads ', 'blank pads ', 'original') PREHOOK: type: QUERY -PREHOOK: Input: default@values__tmp__table__37 PREHOOK: Output: default@table_change_string_group_string_group_char POSTHOOK: query: insert into table table_change_string_group_string_group_char values (1, 'escapist', 'escapist', 'escapist', 'original'), @@ -2027,7 +1954,6 @@ POSTHOOK: query: insert into table table_change_string_group_string_group_char (3, 'dynamic reptile', 'dynamic reptile', 'dynamic reptile', 'original'), (4, 'blank pads ', 'blank pads ', 'blank pads ', 'original') POSTHOOK: type: QUERY -POSTHOOK: Input: default@values__tmp__table__37 POSTHOOK: Output: default@table_change_string_group_string_group_char POSTHOOK: Lineage: table_change_string_group_string_group_char.b SIMPLE [(values__tmp__table__37)values__tmp__table__37.FieldSchema(name:tmp_values_col5, type:string, comment:), ] POSTHOOK: Lineage: table_change_string_group_string_group_char.c1 EXPRESSION [(values__tmp__table__37)values__tmp__table__37.FieldSchema(name:tmp_values_col2, type:string, comment:), ] @@ -2066,7 +1992,6 @@ PREHOOK: query: insert into table table_change_string_group_string_group_char (9, 'hangar paralysed companion ', 'hangar paralysed companion ', 'hangar paralysed companion ', 'new'), (10, 'bottom ', 'bottom ', 'bottom ', 'new') PREHOOK: type: QUERY -PREHOOK: Input: default@values__tmp__table__38 PREHOOK: Output: default@table_change_string_group_string_group_char POSTHOOK: query: insert into table table_change_string_group_string_group_char values (5, 'junkyard', 'junkyard', 'junkyard', 'new'), @@ -2076,7 +2001,6 @@ POSTHOOK: query: insert into table table_change_string_group_string_group_char (9, 'hangar paralysed companion ', 'hangar paralysed companion ', 'hangar paralysed companion ', 'new'), (10, 'bottom ', 'bottom ', 'bottom ', 'new') POSTHOOK: type: QUERY -POSTHOOK: Input: default@values__tmp__table__38 POSTHOOK: Output: default@table_change_string_group_string_group_char POSTHOOK: Lineage: table_change_string_group_string_group_char.b SIMPLE [(values__tmp__table__38)values__tmp__table__38.FieldSchema(name:tmp_values_col5, type:string, comment:), ] POSTHOOK: Lineage: table_change_string_group_string_group_char.c1 EXPRESSION [(values__tmp__table__38)values__tmp__table__38.FieldSchema(name:tmp_values_col2, type:string, comment:), ] @@ -2131,7 +2055,6 @@ PREHOOK: query: insert into table table_change_string_group_string_group_varchar (3, 'dynamic reptile', 'dynamic reptile', 'dynamic reptile', 'original'), (4, 'blank pads ', 'blank pads ', 'blank pads ', 'original') PREHOOK: type: QUERY -PREHOOK: Input: default@values__tmp__table__39 PREHOOK: Output: default@table_change_string_group_string_group_varchar POSTHOOK: query: insert into table table_change_string_group_string_group_varchar values (1, 'escapist', 'escapist', 'escapist', 'original'), @@ -2139,7 +2062,6 @@ POSTHOOK: query: insert into table table_change_string_group_string_group_varcha (3, 'dynamic reptile', 'dynamic reptile', 'dynamic reptile', 'original'), (4, 'blank pads ', 'blank pads ', 'blank pads ', 'original') POSTHOOK: type: QUERY -POSTHOOK: Input: default@values__tmp__table__39 POSTHOOK: Output: default@table_change_string_group_string_group_varchar POSTHOOK: Lineage: table_change_string_group_string_group_varchar.b SIMPLE [(values__tmp__table__39)values__tmp__table__39.FieldSchema(name:tmp_values_col5, type:string, comment:), ] POSTHOOK: Lineage: table_change_string_group_string_group_varchar.c1 EXPRESSION [(values__tmp__table__39)values__tmp__table__39.FieldSchema(name:tmp_values_col2, type:string, comment:), ] @@ -2178,7 +2100,6 @@ PREHOOK: query: insert into table table_change_string_group_string_group_varchar (9, 'hangar paralysed companion ', 'hangar paralysed companion ', 'hangar paralysed companion ', 'new'), (10, 'bottom ', 'bottom ', 'bottom ', 'new') PREHOOK: type: QUERY -PREHOOK: Input: default@values__tmp__table__40 PREHOOK: Output: default@table_change_string_group_string_group_varchar POSTHOOK: query: insert into table table_change_string_group_string_group_varchar values (5, 'junkyard', 'junkyard', 'junkyard', 'new'), @@ -2188,7 +2109,6 @@ POSTHOOK: query: insert into table table_change_string_group_string_group_varcha (9, 'hangar paralysed companion ', 'hangar paralysed companion ', 'hangar paralysed companion ', 'new'), (10, 'bottom ', 'bottom ', 'bottom ', 'new') POSTHOOK: type: QUERY -POSTHOOK: Input: default@values__tmp__table__40 POSTHOOK: Output: default@table_change_string_group_string_group_varchar POSTHOOK: Lineage: table_change_string_group_string_group_varchar.b SIMPLE [(values__tmp__table__40)values__tmp__table__40.FieldSchema(name:tmp_values_col5, type:string, comment:), ] POSTHOOK: Lineage: table_change_string_group_string_group_varchar.c1 EXPRESSION [(values__tmp__table__40)values__tmp__table__40.FieldSchema(name:tmp_values_col2, type:string, comment:), ] @@ -2251,7 +2171,6 @@ PREHOOK: query: insert into table table_change_lower_to_higher_numeric_group_tin (3, -255, -255, -255, -255, -255, -255, 'original'), (4, 100, 100, 100, 100, 100, 100, 'original') PREHOOK: type: QUERY -PREHOOK: Input: default@values__tmp__table__41 PREHOOK: Output: default@table_change_lower_to_higher_numeric_group_tinyint POSTHOOK: query: insert into table table_change_lower_to_higher_numeric_group_tinyint values (1, 45, 45, 45, 45, 45, 45, 'original'), @@ -2259,7 +2178,6 @@ POSTHOOK: query: insert into table table_change_lower_to_higher_numeric_group_ti (3, -255, -255, -255, -255, -255, -255, 'original'), (4, 100, 100, 100, 100, 100, 100, 'original') POSTHOOK: type: QUERY -POSTHOOK: Input: default@values__tmp__table__41 POSTHOOK: Output: default@table_change_lower_to_higher_numeric_group_tinyint POSTHOOK: Lineage: table_change_lower_to_higher_numeric_group_tinyint.b SIMPLE [(values__tmp__table__41)values__tmp__table__41.FieldSchema(name:tmp_values_col8, type:string, comment:), ] POSTHOOK: Lineage: table_change_lower_to_higher_numeric_group_tinyint.c1 EXPRESSION [(values__tmp__table__41)values__tmp__table__41.FieldSchema(name:tmp_values_col2, type:string, comment:), ] @@ -2301,7 +2219,6 @@ PREHOOK: query: insert into table table_change_lower_to_higher_numeric_group_tin (9, '100', '5000', '5443', '22', '2', '-2', 'new'), (10, '17', '90000', '754072151', '95', '20', '18', 'new') PREHOOK: type: QUERY -PREHOOK: Input: default@values__tmp__table__42 PREHOOK: Output: default@table_change_lower_to_higher_numeric_group_tinyint POSTHOOK: query: insert into table table_change_lower_to_higher_numeric_group_tinyint values (5, '774', '2031', '200', '12', '99', '0', 'new'), @@ -2311,7 +2228,6 @@ POSTHOOK: query: insert into table table_change_lower_to_higher_numeric_group_ti (9, '100', '5000', '5443', '22', '2', '-2', 'new'), (10, '17', '90000', '754072151', '95', '20', '18', 'new') POSTHOOK: type: QUERY -POSTHOOK: Input: default@values__tmp__table__42 POSTHOOK: Output: default@table_change_lower_to_higher_numeric_group_tinyint POSTHOOK: Lineage: table_change_lower_to_higher_numeric_group_tinyint.b SIMPLE [(values__tmp__table__42)values__tmp__table__42.FieldSchema(name:tmp_values_col8, type:string, comment:), ] POSTHOOK: Lineage: table_change_lower_to_higher_numeric_group_tinyint.c1 EXPRESSION [(values__tmp__table__42)values__tmp__table__42.FieldSchema(name:tmp_values_col2, type:string, comment:), ] @@ -2369,7 +2285,6 @@ PREHOOK: query: insert into table table_change_lower_to_higher_numeric_group_sma (3, -5000, -5000, -5000, -5000, -5000, 'original'), (4, 100, 100, 100, 100, 100, 'original') PREHOOK: type: QUERY -PREHOOK: Input: default@values__tmp__table__43 PREHOOK: Output: default@table_change_lower_to_higher_numeric_group_smallint POSTHOOK: query: insert into table table_change_lower_to_higher_numeric_group_smallint values (1, 2031, 2031, 2031, 2031, 2031, 'original'), @@ -2377,7 +2292,6 @@ POSTHOOK: query: insert into table table_change_lower_to_higher_numeric_group_sm (3, -5000, -5000, -5000, -5000, -5000, 'original'), (4, 100, 100, 100, 100, 100, 'original') POSTHOOK: type: QUERY -POSTHOOK: Input: default@values__tmp__table__43 POSTHOOK: Output: default@table_change_lower_to_higher_numeric_group_smallint POSTHOOK: Lineage: table_change_lower_to_higher_numeric_group_smallint.b SIMPLE [(values__tmp__table__43)values__tmp__table__43.FieldSchema(name:tmp_values_col7, type:string, comment:), ] POSTHOOK: Lineage: table_change_lower_to_higher_numeric_group_smallint.c1 EXPRESSION [(values__tmp__table__43)values__tmp__table__43.FieldSchema(name:tmp_values_col2, type:string, comment:), ] @@ -2418,7 +2332,6 @@ PREHOOK: query: insert into table table_change_lower_to_higher_numeric_group_sma (9, '100', '5000', '5443', '22', '2', 'new'), (10, '17', '90000', '754072151', '95', '20', 'new') PREHOOK: type: QUERY -PREHOOK: Input: default@values__tmp__table__44 PREHOOK: Output: default@table_change_lower_to_higher_numeric_group_smallint POSTHOOK: query: insert into table table_change_lower_to_higher_numeric_group_smallint values (5, '774', '2031', '200', '12', '99', 'new'), @@ -2428,7 +2341,6 @@ POSTHOOK: query: insert into table table_change_lower_to_higher_numeric_group_sm (9, '100', '5000', '5443', '22', '2', 'new'), (10, '17', '90000', '754072151', '95', '20', 'new') POSTHOOK: type: QUERY -POSTHOOK: Input: default@values__tmp__table__44 POSTHOOK: Output: default@table_change_lower_to_higher_numeric_group_smallint POSTHOOK: Lineage: table_change_lower_to_higher_numeric_group_smallint.b SIMPLE [(values__tmp__table__44)values__tmp__table__44.FieldSchema(name:tmp_values_col7, type:string, comment:), ] POSTHOOK: Lineage: table_change_lower_to_higher_numeric_group_smallint.c1 EXPRESSION [(values__tmp__table__44)values__tmp__table__44.FieldSchema(name:tmp_values_col2, type:string, comment:), ] @@ -2485,7 +2397,6 @@ PREHOOK: query: insert into table table_change_lower_to_higher_numeric_group_int (3, -5000, -5000, -5000, -5000, 'original'), (4, 52927714, 52927714, 52927714, 52927714, 'original') PREHOOK: type: QUERY -PREHOOK: Input: default@values__tmp__table__45 PREHOOK: Output: default@table_change_lower_to_higher_numeric_group_int POSTHOOK: query: insert into table table_change_lower_to_higher_numeric_group_int values (1, 2031, 2031, 2031, 2031, 'original'), @@ -2493,7 +2404,6 @@ POSTHOOK: query: insert into table table_change_lower_to_higher_numeric_group_in (3, -5000, -5000, -5000, -5000, 'original'), (4, 52927714, 52927714, 52927714, 52927714, 'original') POSTHOOK: type: QUERY -POSTHOOK: Input: default@values__tmp__table__45 POSTHOOK: Output: default@table_change_lower_to_higher_numeric_group_int POSTHOOK: Lineage: table_change_lower_to_higher_numeric_group_int.b SIMPLE [(values__tmp__table__45)values__tmp__table__45.FieldSchema(name:tmp_values_col6, type:string, comment:), ] POSTHOOK: Lineage: table_change_lower_to_higher_numeric_group_int.c1 EXPRESSION [(values__tmp__table__45)values__tmp__table__45.FieldSchema(name:tmp_values_col2, type:string, comment:), ] @@ -2533,7 +2443,6 @@ PREHOOK: query: insert into table table_change_lower_to_higher_numeric_group_int (9, '100', '5000', '5443', '22', 'new'), (10, '17', '90000', '754072151', '95', 'new') PREHOOK: type: QUERY -PREHOOK: Input: default@values__tmp__table__46 PREHOOK: Output: default@table_change_lower_to_higher_numeric_group_int POSTHOOK: query: insert into table table_change_lower_to_higher_numeric_group_int values (5, '774', '2031', '200', '12', 'new'), @@ -2543,7 +2452,6 @@ POSTHOOK: query: insert into table table_change_lower_to_higher_numeric_group_in (9, '100', '5000', '5443', '22', 'new'), (10, '17', '90000', '754072151', '95', 'new') POSTHOOK: type: QUERY -POSTHOOK: Input: default@values__tmp__table__46 POSTHOOK: Output: default@table_change_lower_to_higher_numeric_group_int POSTHOOK: Lineage: table_change_lower_to_higher_numeric_group_int.b SIMPLE [(values__tmp__table__46)values__tmp__table__46.FieldSchema(name:tmp_values_col6, type:string, comment:), ] POSTHOOK: Lineage: table_change_lower_to_higher_numeric_group_int.c1 EXPRESSION [(values__tmp__table__46)values__tmp__table__46.FieldSchema(name:tmp_values_col2, type:string, comment:), ] @@ -2599,7 +2507,6 @@ PREHOOK: query: insert into table table_change_lower_to_higher_numeric_group_big (3, -5000, -5000, -5000, 'original'), (4, 52927714, 52927714, 52927714, 'original') PREHOOK: type: QUERY -PREHOOK: Input: default@values__tmp__table__47 PREHOOK: Output: default@table_change_lower_to_higher_numeric_group_bigint POSTHOOK: query: insert into table table_change_lower_to_higher_numeric_group_bigint values (1, 7203778961, 7203778961, 7203778961, 'original'), @@ -2607,7 +2514,6 @@ POSTHOOK: query: insert into table table_change_lower_to_higher_numeric_group_bi (3, -5000, -5000, -5000, 'original'), (4, 52927714, 52927714, 52927714, 'original') POSTHOOK: type: QUERY -POSTHOOK: Input: default@values__tmp__table__47 POSTHOOK: Output: default@table_change_lower_to_higher_numeric_group_bigint POSTHOOK: Lineage: table_change_lower_to_higher_numeric_group_bigint.b SIMPLE [(values__tmp__table__47)values__tmp__table__47.FieldSchema(name:tmp_values_col5, type:string, comment:), ] POSTHOOK: Lineage: table_change_lower_to_higher_numeric_group_bigint.c1 EXPRESSION [(values__tmp__table__47)values__tmp__table__47.FieldSchema(name:tmp_values_col2, type:string, comment:), ] @@ -2646,7 +2552,6 @@ PREHOOK: query: insert into table table_change_lower_to_higher_numeric_group_big (9, '100', '5000', '5443', 'new'), (10, '17', '90000', '754072151', 'new') PREHOOK: type: QUERY -PREHOOK: Input: default@values__tmp__table__48 PREHOOK: Output: default@table_change_lower_to_higher_numeric_group_bigint POSTHOOK: query: insert into table table_change_lower_to_higher_numeric_group_bigint values (5, '774', '2031', '200', 'new'), @@ -2656,7 +2561,6 @@ POSTHOOK: query: insert into table table_change_lower_to_higher_numeric_group_bi (9, '100', '5000', '5443', 'new'), (10, '17', '90000', '754072151', 'new') POSTHOOK: type: QUERY -POSTHOOK: Input: default@values__tmp__table__48 POSTHOOK: Output: default@table_change_lower_to_higher_numeric_group_bigint POSTHOOK: Lineage: table_change_lower_to_higher_numeric_group_bigint.b SIMPLE [(values__tmp__table__48)values__tmp__table__48.FieldSchema(name:tmp_values_col5, type:string, comment:), ] POSTHOOK: Lineage: table_change_lower_to_higher_numeric_group_bigint.c1 EXPRESSION [(values__tmp__table__48)values__tmp__table__48.FieldSchema(name:tmp_values_col2, type:string, comment:), ] @@ -2711,7 +2615,6 @@ PREHOOK: query: insert into table table_change_lower_to_higher_numeric_group_dec (3, -5000, -5000, 'original'), (4, 52927714, 52927714, 'original') PREHOOK: type: QUERY -PREHOOK: Input: default@values__tmp__table__49 PREHOOK: Output: default@table_change_lower_to_higher_numeric_group_decimal POSTHOOK: query: insert into table table_change_lower_to_higher_numeric_group_decimal values (1, -29.0764, -29.0764, 'original'), @@ -2719,7 +2622,6 @@ POSTHOOK: query: insert into table table_change_lower_to_higher_numeric_group_de (3, -5000, -5000, 'original'), (4, 52927714, 52927714, 'original') POSTHOOK: type: QUERY -POSTHOOK: Input: default@values__tmp__table__49 POSTHOOK: Output: default@table_change_lower_to_higher_numeric_group_decimal POSTHOOK: Lineage: table_change_lower_to_higher_numeric_group_decimal.b SIMPLE [(values__tmp__table__49)values__tmp__table__49.FieldSchema(name:tmp_values_col4, type:string, comment:), ] POSTHOOK: Lineage: table_change_lower_to_higher_numeric_group_decimal.c1 EXPRESSION [(values__tmp__table__49)values__tmp__table__49.FieldSchema(name:tmp_values_col2, type:string, comment:), ] @@ -2757,7 +2659,6 @@ PREHOOK: query: insert into table table_change_lower_to_higher_numeric_group_dec (9, '10.0', '0.100', 'new'), (10, '1.7', '17.8888', 'new') PREHOOK: type: QUERY -PREHOOK: Input: default@values__tmp__table__50 PREHOOK: Output: default@table_change_lower_to_higher_numeric_group_decimal POSTHOOK: query: insert into table table_change_lower_to_higher_numeric_group_decimal values (5, '7.74', '22.3', 'new'), @@ -2767,7 +2668,6 @@ POSTHOOK: query: insert into table table_change_lower_to_higher_numeric_group_de (9, '10.0', '0.100', 'new'), (10, '1.7', '17.8888', 'new') POSTHOOK: type: QUERY -POSTHOOK: Input: default@values__tmp__table__50 POSTHOOK: Output: default@table_change_lower_to_higher_numeric_group_decimal POSTHOOK: Lineage: table_change_lower_to_higher_numeric_group_decimal.b SIMPLE [(values__tmp__table__50)values__tmp__table__50.FieldSchema(name:tmp_values_col4, type:string, comment:), ] POSTHOOK: Lineage: table_change_lower_to_higher_numeric_group_decimal.c1 EXPRESSION [(values__tmp__table__50)values__tmp__table__50.FieldSchema(name:tmp_values_col2, type:string, comment:), ] @@ -2821,7 +2721,6 @@ PREHOOK: query: insert into table table_change_lower_to_higher_numeric_group_flo (3, -5000, 'original'), (4, 52927714, 'original') PREHOOK: type: QUERY -PREHOOK: Input: default@values__tmp__table__51 PREHOOK: Output: default@table_change_lower_to_higher_numeric_group_float POSTHOOK: query: insert into table table_change_lower_to_higher_numeric_group_float values (1, -29.0764, 'original'), @@ -2829,7 +2728,6 @@ POSTHOOK: query: insert into table table_change_lower_to_higher_numeric_group_fl (3, -5000, 'original'), (4, 52927714, 'original') POSTHOOK: type: QUERY -POSTHOOK: Input: default@values__tmp__table__51 POSTHOOK: Output: default@table_change_lower_to_higher_numeric_group_float POSTHOOK: Lineage: table_change_lower_to_higher_numeric_group_float.b SIMPLE [(values__tmp__table__51)values__tmp__table__51.FieldSchema(name:tmp_values_col3, type:string, comment:), ] POSTHOOK: Lineage: table_change_lower_to_higher_numeric_group_float.c1 EXPRESSION [(values__tmp__table__51)values__tmp__table__51.FieldSchema(name:tmp_values_col2, type:string, comment:), ] @@ -2866,7 +2764,6 @@ PREHOOK: query: insert into table table_change_lower_to_higher_numeric_group_flo (9, '100', 'new'), (10, '17', 'new') PREHOOK: type: QUERY -PREHOOK: Input: default@values__tmp__table__52 PREHOOK: Output: default@table_change_lower_to_higher_numeric_group_float POSTHOOK: query: insert into table table_change_lower_to_higher_numeric_group_float values (5, '774', 'new'), @@ -2876,7 +2773,6 @@ POSTHOOK: query: insert into table table_change_lower_to_higher_numeric_group_fl (9, '100', 'new'), (10, '17', 'new') POSTHOOK: type: QUERY -POSTHOOK: Input: default@values__tmp__table__52 POSTHOOK: Output: default@table_change_lower_to_higher_numeric_group_float POSTHOOK: Lineage: table_change_lower_to_higher_numeric_group_float.b SIMPLE [(values__tmp__table__52)values__tmp__table__52.FieldSchema(name:tmp_values_col3, type:string, comment:), ] POSTHOOK: Lineage: table_change_lower_to_higher_numeric_group_float.c1 EXPRESSION [(values__tmp__table__52)values__tmp__table__52.FieldSchema(name:tmp_values_col2, type:string, comment:), ] @@ -2931,7 +2827,6 @@ PREHOOK: query: insert into table table5 (3, 3, 'original'), (4, 4, 'original') PREHOOK: type: QUERY -PREHOOK: Input: default@values__tmp__table__53 PREHOOK: Output: default@table5 POSTHOOK: query: insert into table table5 values (1, 1, 'original'), @@ -2939,7 +2834,6 @@ POSTHOOK: query: insert into table table5 (3, 3, 'original'), (4, 4, 'original') POSTHOOK: type: QUERY -POSTHOOK: Input: default@values__tmp__table__53 POSTHOOK: Output: default@table5 POSTHOOK: Lineage: table5.a EXPRESSION [(values__tmp__table__53)values__tmp__table__53.FieldSchema(name:tmp_values_col2, type:string, comment:), ] POSTHOOK: Lineage: table5.b SIMPLE [(values__tmp__table__53)values__tmp__table__53.FieldSchema(name:tmp_values_col3, type:string, comment:), ] @@ -2961,7 +2855,6 @@ PREHOOK: query: insert into table table5 (7, 3, 'new', 30, 'thirty'), (8, 4, 'new', 40, 'forty') PREHOOK: type: QUERY -PREHOOK: Input: default@values__tmp__table__54 PREHOOK: Output: default@table5 POSTHOOK: query: insert into table table5 values (5, 1, 'new', 10, 'ten'), @@ -2969,7 +2862,6 @@ POSTHOOK: query: insert into table table5 (7, 3, 'new', 30, 'thirty'), (8, 4, 'new', 40, 'forty') POSTHOOK: type: QUERY -POSTHOOK: Input: default@values__tmp__table__54 POSTHOOK: Output: default@table5 POSTHOOK: Lineage: table5.a EXPRESSION [(values__tmp__table__54)values__tmp__table__54.FieldSchema(name:tmp_values_col2, type:string, comment:), ] POSTHOOK: Lineage: table5.b SIMPLE [(values__tmp__table__54)values__tmp__table__54.FieldSchema(name:tmp_values_col3, type:string, comment:), ] @@ -2981,13 +2873,11 @@ PREHOOK: query: insert into table table5 values (9, 5, 'new', 100, 'hundred'), (10, 6, 'new', 200, 'two hundred') PREHOOK: type: QUERY -PREHOOK: Input: default@values__tmp__table__55 PREHOOK: Output: default@table5 POSTHOOK: query: insert into table table5 values (9, 5, 'new', 100, 'hundred'), (10, 6, 'new', 200, 'two hundred') POSTHOOK: type: QUERY -POSTHOOK: Input: default@values__tmp__table__55 POSTHOOK: Output: default@table5 POSTHOOK: Lineage: table5.a EXPRESSION [(values__tmp__table__55)values__tmp__table__55.FieldSchema(name:tmp_values_col2, type:string, comment:), ] POSTHOOK: Lineage: table5.b SIMPLE [(values__tmp__table__55)values__tmp__table__55.FieldSchema(name:tmp_values_col3, type:string, comment:), ] @@ -3066,7 +2956,6 @@ PREHOOK: query: insert into table table6 (3, 3, 'original'), (4, 4, 'original') PREHOOK: type: QUERY -PREHOOK: Input: default@values__tmp__table__56 PREHOOK: Output: default@table6 POSTHOOK: query: insert into table table6 values (1, 1, 'original'), @@ -3074,7 +2963,6 @@ POSTHOOK: query: insert into table table6 (3, 3, 'original'), (4, 4, 'original') POSTHOOK: type: QUERY -POSTHOOK: Input: default@values__tmp__table__56 POSTHOOK: Output: default@table6 POSTHOOK: Lineage: table6.a EXPRESSION [(values__tmp__table__56)values__tmp__table__56.FieldSchema(name:tmp_values_col2, type:string, comment:), ] POSTHOOK: Lineage: table6.b SIMPLE [(values__tmp__table__56)values__tmp__table__56.FieldSchema(name:tmp_values_col3, type:string, comment:), ] @@ -3096,7 +2984,6 @@ PREHOOK: query: insert into table table6 (7, 3, 'new', 30, 'thirty'), (8, 4, 'new', 40, 'forty') PREHOOK: type: QUERY -PREHOOK: Input: default@values__tmp__table__57 PREHOOK: Output: default@table6 POSTHOOK: query: insert into table table6 values (5, 1, 'new', 10, 'ten'), @@ -3104,7 +2991,6 @@ POSTHOOK: query: insert into table table6 (7, 3, 'new', 30, 'thirty'), (8, 4, 'new', 40, 'forty') POSTHOOK: type: QUERY -POSTHOOK: Input: default@values__tmp__table__57 POSTHOOK: Output: default@table6 POSTHOOK: Lineage: table6.a EXPRESSION [(values__tmp__table__57)values__tmp__table__57.FieldSchema(name:tmp_values_col2, type:string, comment:), ] POSTHOOK: Lineage: table6.b SIMPLE [(values__tmp__table__57)values__tmp__table__57.FieldSchema(name:tmp_values_col3, type:string, comment:), ] @@ -3116,13 +3002,11 @@ PREHOOK: query: insert into table table6 values (9, 5, 'new', 100, 'hundred'), (10, 6, 'new', 200, 'two hundred') PREHOOK: type: QUERY -PREHOOK: Input: default@values__tmp__table__58 PREHOOK: Output: default@table6 POSTHOOK: query: insert into table table6 values (9, 5, 'new', 100, 'hundred'), (10, 6, 'new', 200, 'two hundred') POSTHOOK: type: QUERY -POSTHOOK: Input: default@values__tmp__table__58 POSTHOOK: Output: default@table6 POSTHOOK: Lineage: table6.a EXPRESSION [(values__tmp__table__58)values__tmp__table__58.FieldSchema(name:tmp_values_col2, type:string, comment:), ] POSTHOOK: Lineage: table6.b SIMPLE [(values__tmp__table__58)values__tmp__table__58.FieldSchema(name:tmp_values_col3, type:string, comment:), ] @@ -3196,7 +3080,6 @@ PREHOOK: query: insert into table table7 (3, 3, 'original'), (4, 4, 'original') PREHOOK: type: QUERY -PREHOOK: Input: default@values__tmp__table__59 PREHOOK: Output: default@table7 POSTHOOK: query: insert into table table7 values (1, 1, 'original'), @@ -3204,7 +3087,6 @@ POSTHOOK: query: insert into table table7 (3, 3, 'original'), (4, 4, 'original') POSTHOOK: type: QUERY -POSTHOOK: Input: default@values__tmp__table__59 POSTHOOK: Output: default@table7 POSTHOOK: Lineage: table7.a EXPRESSION [(values__tmp__table__59)values__tmp__table__59.FieldSchema(name:tmp_values_col2, type:string, comment:), ] POSTHOOK: Lineage: table7.b SIMPLE [(values__tmp__table__59)values__tmp__table__59.FieldSchema(name:tmp_values_col3, type:string, comment:), ] @@ -3226,7 +3108,6 @@ PREHOOK: query: insert into table table7 (7, 3, 'new', 30, 'thirty'), (8, 4, 'new', 40, 'forty') PREHOOK: type: QUERY -PREHOOK: Input: default@values__tmp__table__60 PREHOOK: Output: default@table7 POSTHOOK: query: insert into table table7 values (5, 1, 'new', 10, 'ten'), @@ -3234,7 +3115,6 @@ POSTHOOK: query: insert into table table7 (7, 3, 'new', 30, 'thirty'), (8, 4, 'new', 40, 'forty') POSTHOOK: type: QUERY -POSTHOOK: Input: default@values__tmp__table__60 POSTHOOK: Output: default@table7 POSTHOOK: Lineage: table7.a EXPRESSION [(values__tmp__table__60)values__tmp__table__60.FieldSchema(name:tmp_values_col2, type:string, comment:), ] POSTHOOK: Lineage: table7.b SIMPLE [(values__tmp__table__60)values__tmp__table__60.FieldSchema(name:tmp_values_col3, type:string, comment:), ] @@ -3246,13 +3126,11 @@ PREHOOK: query: insert into table table7 values (9, 5, 'new', 100, 'hundred'), (10, 6, 'new', 200, 'two hundred') PREHOOK: type: QUERY -PREHOOK: Input: default@values__tmp__table__61 PREHOOK: Output: default@table7 POSTHOOK: query: insert into table table7 values (9, 5, 'new', 100, 'hundred'), (10, 6, 'new', 200, 'two hundred') POSTHOOK: type: QUERY -POSTHOOK: Input: default@values__tmp__table__61 POSTHOOK: Output: default@table7 POSTHOOK: Lineage: table7.a EXPRESSION [(values__tmp__table__61)values__tmp__table__61.FieldSchema(name:tmp_values_col2, type:string, comment:), ] POSTHOOK: Lineage: table7.b SIMPLE [(values__tmp__table__61)values__tmp__table__61.FieldSchema(name:tmp_values_col3, type:string, comment:), ]
http://git-wip-us.apache.org/repos/asf/hive/blob/fa995bae/ql/src/test/results/clientpositive/llap/schema_evol_orc_acid_part.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/schema_evol_orc_acid_part.q.out b/ql/src/test/results/clientpositive/llap/schema_evol_orc_acid_part.q.out index 89b87ea..96134a3 100644 --- a/ql/src/test/results/clientpositive/llap/schema_evol_orc_acid_part.q.out +++ b/ql/src/test/results/clientpositive/llap/schema_evol_orc_acid_part.q.out @@ -54,11 +54,9 @@ POSTHOOK: Output: database:default POSTHOOK: Output: default@part_add_int_permute_select PREHOOK: query: insert into table part_add_int_permute_select partition(part=1) VALUES (1, 1111, 'new') PREHOOK: type: QUERY -PREHOOK: Input: default@values__tmp__table__1 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, 1111, 'new') POSTHOOK: type: QUERY -POSTHOOK: Input: default@values__tmp__table__1 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:), ] @@ -76,11 +74,9 @@ POSTHOOK: Input: default@part_add_int_permute_select POSTHOOK: Output: default@part_add_int_permute_select PREHOOK: query: insert into table part_add_int_permute_select partition(part=1) VALUES (2, 2222, 'new', 3333) PREHOOK: type: QUERY -PREHOOK: Input: default@values__tmp__table__2 PREHOOK: Output: default@part_add_int_permute_select@part=1 POSTHOOK: query: insert into table part_add_int_permute_select partition(part=1) VALUES (2, 2222, 'new', 3333) POSTHOOK: type: QUERY -POSTHOOK: Input: default@values__tmp__table__2 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__2)values__tmp__table__2.FieldSchema(name:tmp_values_col2, type:string, comment:), ] POSTHOOK: Lineage: part_add_int_permute_select PARTITION(part=1).b SIMPLE [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col3, type:string, comment:), ] @@ -152,11 +148,9 @@ POSTHOOK: Output: database:default POSTHOOK: Output: default@part_add_int_string_permute_select PREHOOK: query: insert into table part_add_int_string_permute_select partition(part=1) VALUES (1, 1111, 'new') PREHOOK: type: QUERY -PREHOOK: Input: default@values__tmp__table__3 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, 1111, 'new') POSTHOOK: type: QUERY -POSTHOOK: Input: default@values__tmp__table__3 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__3)values__tmp__table__3.FieldSchema(name:tmp_values_col2, type:string, comment:), ] POSTHOOK: Lineage: part_add_int_string_permute_select PARTITION(part=1).b SIMPLE [(values__tmp__table__3)values__tmp__table__3.FieldSchema(name:tmp_values_col3, type:string, comment:), ] @@ -174,11 +168,9 @@ POSTHOOK: Input: default@part_add_int_string_permute_select POSTHOOK: Output: default@part_add_int_string_permute_select PREHOOK: query: insert into table part_add_int_string_permute_select partition(part=1) VALUES (2, 2222, 'new', 3333, '4444') PREHOOK: type: QUERY -PREHOOK: Input: default@values__tmp__table__4 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 (2, 2222, 'new', 3333, '4444') POSTHOOK: type: QUERY -POSTHOOK: Input: default@values__tmp__table__4 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:), ] @@ -426,11 +418,9 @@ POSTHOOK: Input: default@part_change_date_group_string_group_date_timestamp POSTHOOK: Output: default@part_change_date_group_string_group_date_timestamp PREHOOK: query: insert into table part_change_date_group_string_group_date_timestamp partition(part=1) VALUES (111, 'filler', 'filler', 'filler', 'filler', 'filler', 'filler', 'filler', 'filler', 'filler', 'filler', 'new') PREHOOK: type: QUERY -PREHOOK: Input: default@values__tmp__table__5 PREHOOK: Output: default@part_change_date_group_string_group_date_timestamp@part=1 POSTHOOK: query: insert into table part_change_date_group_string_group_date_timestamp partition(part=1) VALUES (111, 'filler', 'filler', 'filler', 'filler', 'filler', 'filler', 'filler', 'filler', 'filler', 'filler', 'new') POSTHOOK: type: QUERY -POSTHOOK: Input: default@values__tmp__table__5 POSTHOOK: Output: default@part_change_date_group_string_group_date_timestamp@part=1 POSTHOOK: Lineage: part_change_date_group_string_group_date_timestamp PARTITION(part=1).b SIMPLE [(values__tmp__table__5)values__tmp__table__5.FieldSchema(name:tmp_values_col12, type:string, comment:), ] POSTHOOK: Lineage: part_change_date_group_string_group_date_timestamp PARTITION(part=1).c1 SIMPLE [(values__tmp__table__5)values__tmp__table__5.FieldSchema(name:tmp_values_col2, type:string, comment:), ] @@ -587,7 +577,6 @@ PREHOOK: query: insert into table part_change_numeric_group_string_group_multi_i 'filler', 'filler', 'filler', 'filler', 'filler', 'filler', 'filler', 'filler', 'new') PREHOOK: type: QUERY -PREHOOK: Input: default@values__tmp__table__6 PREHOOK: Output: default@part_change_numeric_group_string_group_multi_ints_string_group@part=1 POSTHOOK: query: insert into table part_change_numeric_group_string_group_multi_ints_string_group partition(part=1) VALUES (111, 'filler', 'filler', 'filler', 'filler', @@ -595,7 +584,6 @@ POSTHOOK: query: insert into table part_change_numeric_group_string_group_multi_ 'filler', 'filler', 'filler', 'filler', 'filler', 'filler', 'filler', 'filler', 'new') POSTHOOK: type: QUERY -POSTHOOK: Input: default@values__tmp__table__6 POSTHOOK: Output: default@part_change_numeric_group_string_group_multi_ints_string_group@part=1 POSTHOOK: Lineage: part_change_numeric_group_string_group_multi_ints_string_group PARTITION(part=1).b SIMPLE [(values__tmp__table__6)values__tmp__table__6.FieldSchema(name:tmp_values_col22, type:string, comment:), ] POSTHOOK: Lineage: part_change_numeric_group_string_group_multi_ints_string_group PARTITION(part=1).c1 SIMPLE [(values__tmp__table__6)values__tmp__table__6.FieldSchema(name:tmp_values_col2, type:string, comment:), ] @@ -789,7 +777,6 @@ PREHOOK: query: insert into table part_change_numeric_group_string_group_floatin 'filler', 'filler', 'filler', 'filler', 'filler', 'filler', 'new') PREHOOK: type: QUERY -PREHOOK: Input: default@values__tmp__table__7 PREHOOK: Output: default@part_change_numeric_group_string_group_floating_string_group@part=1 POSTHOOK: query: insert into table part_change_numeric_group_string_group_floating_string_group partition(part=1) VALUES (111, 'filler', 'filler', 'filler', @@ -797,7 +784,6 @@ POSTHOOK: query: insert into table part_change_numeric_group_string_group_floati 'filler', 'filler', 'filler', 'filler', 'filler', 'filler', 'new') POSTHOOK: type: QUERY -POSTHOOK: Input: default@values__tmp__table__7 POSTHOOK: Output: default@part_change_numeric_group_string_group_floating_string_group@part=1 POSTHOOK: Lineage: part_change_numeric_group_string_group_floating_string_group PARTITION(part=1).b SIMPLE [(values__tmp__table__7)values__tmp__table__7.FieldSchema(name:tmp_values_col17, type:string, comment:), ] POSTHOOK: Lineage: part_change_numeric_group_string_group_floating_string_group PARTITION(part=1).c1 SIMPLE [(values__tmp__table__7)values__tmp__table__7.FieldSchema(name:tmp_values_col2, type:string, comment:), ] @@ -979,7 +965,6 @@ PREHOOK: query: insert into table part_change_string_group_string_group_string p 'filler', 'filler', 'filler', 'new') PREHOOK: type: QUERY -PREHOOK: Input: default@values__tmp__table__8 PREHOOK: Output: default@part_change_string_group_string_group_string@part=1 POSTHOOK: query: insert into table part_change_string_group_string_group_string partition(part=1) VALUES (111, 'filler', 'filler', 'filler', 'filler', @@ -987,7 +972,6 @@ POSTHOOK: query: insert into table part_change_string_group_string_group_string 'filler', 'filler', 'filler', 'new') POSTHOOK: type: QUERY -POSTHOOK: Input: default@values__tmp__table__8 POSTHOOK: Output: default@part_change_string_group_string_group_string@part=1 POSTHOOK: Lineage: part_change_string_group_string_group_string PARTITION(part=1).b SIMPLE [(values__tmp__table__8)values__tmp__table__8.FieldSchema(name:tmp_values_col12, type:string, comment:), ] POSTHOOK: Lineage: part_change_string_group_string_group_string PARTITION(part=1).c1 EXPRESSION [(values__tmp__table__8)values__tmp__table__8.FieldSchema(name:tmp_values_col2, type:string, comment:), ] @@ -1149,7 +1133,6 @@ PREHOOK: query: insert into table part_change_lower_to_higher_numeric_group_tiny 1234.5678, 9876.543, 789.321, 'new') PREHOOK: type: QUERY -PREHOOK: Input: default@values__tmp__table__9 PREHOOK: Output: default@part_change_lower_to_higher_numeric_group_tinyint_to_bigint@part=1 POSTHOOK: query: insert into table part_change_lower_to_higher_numeric_group_tinyint_to_bigint partition(part=1) VALUES (111, 7000, 80000, 90000000, 1234.5678, 9876.543, 789.321, @@ -1158,7 +1141,6 @@ POSTHOOK: query: insert into table part_change_lower_to_higher_numeric_group_tin 1234.5678, 9876.543, 789.321, 'new') POSTHOOK: type: QUERY -POSTHOOK: Input: default@values__tmp__table__9 POSTHOOK: Output: default@part_change_lower_to_higher_numeric_group_tinyint_to_bigint@part=1 POSTHOOK: Lineage: part_change_lower_to_higher_numeric_group_tinyint_to_bigint PARTITION(part=1).b SIMPLE [(values__tmp__table__9)values__tmp__table__9.FieldSchema(name:tmp_values_col20, type:string, comment:), ] POSTHOOK: Lineage: part_change_lower_to_higher_numeric_group_tinyint_to_bigint PARTITION(part=1).c1 EXPRESSION [(values__tmp__table__9)values__tmp__table__9.FieldSchema(name:tmp_values_col2, type:string, comment:), ] @@ -1278,11 +1260,9 @@ POSTHOOK: Input: default@part_change_lower_to_higher_numeric_group_decimal_to_fl POSTHOOK: Output: default@part_change_lower_to_higher_numeric_group_decimal_to_float PREHOOK: query: insert into table part_change_lower_to_higher_numeric_group_decimal_to_float partition(part=1) VALUES (111, 1234.5678, 9876.543, 1234.5678, 'new') PREHOOK: type: QUERY -PREHOOK: Input: default@values__tmp__table__10 PREHOOK: Output: default@part_change_lower_to_higher_numeric_group_decimal_to_float@part=1 POSTHOOK: query: insert into table part_change_lower_to_higher_numeric_group_decimal_to_float partition(part=1) VALUES (111, 1234.5678, 9876.543, 1234.5678, 'new') POSTHOOK: type: QUERY -POSTHOOK: Input: default@values__tmp__table__10 POSTHOOK: Output: default@part_change_lower_to_higher_numeric_group_decimal_to_float@part=1 POSTHOOK: Lineage: part_change_lower_to_higher_numeric_group_decimal_to_float PARTITION(part=1).b SIMPLE [(values__tmp__table__10)values__tmp__table__10.FieldSchema(name:tmp_values_col5, type:string, comment:), ] POSTHOOK: Lineage: part_change_lower_to_higher_numeric_group_decimal_to_float PARTITION(part=1).c1 EXPRESSION [(values__tmp__table__10)values__tmp__table__10.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
