http://git-wip-us.apache.org/repos/asf/hive/blob/fa995bae/ql/src/test/results/clientpositive/schema_evol_text_vecrow_mapwork_table.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/schema_evol_text_vecrow_mapwork_table.q.out b/ql/src/test/results/clientpositive/schema_evol_text_vecrow_mapwork_table.q.out index 6a929fa..5cd8866 100644 --- a/ql/src/test/results/clientpositive/schema_evol_text_vecrow_mapwork_table.q.out +++ b/ql/src/test/results/clientpositive/schema_evol_text_vecrow_mapwork_table.q.out @@ -75,7 +75,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'), @@ -83,7 +82,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:), ] @@ -143,7 +141,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), @@ -151,7 +148,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:), ] @@ -162,13 +158,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:), ] @@ -336,7 +330,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'), @@ -344,7 +337,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:), ] @@ -405,7 +397,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'), @@ -413,7 +404,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:), ] @@ -425,13 +415,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:), ] @@ -647,7 +635,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'), @@ -655,7 +642,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:), ] @@ -679,7 +665,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'), @@ -687,7 +672,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:), ] @@ -699,13 +683,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:), ] @@ -804,14 +786,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:), ] @@ -837,7 +817,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'), @@ -845,7 +824,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:), ] @@ -859,13 +837,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:), ] @@ -957,14 +933,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:), ] @@ -1033,7 +1007,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'), @@ -1043,7 +1016,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:), ] @@ -1144,7 +1116,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'), @@ -1152,7 +1123,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:), ] @@ -1192,7 +1162,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'), @@ -1202,7 +1171,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:), ] @@ -1295,7 +1263,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'), @@ -1303,7 +1270,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:), ] @@ -1343,7 +1309,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'), @@ -1353,7 +1318,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:), ] @@ -1446,7 +1410,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'), @@ -1454,7 +1417,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:), ] @@ -1494,7 +1456,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'), @@ -1504,7 +1465,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:), ] @@ -1597,7 +1557,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'), @@ -1605,7 +1564,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:), ] @@ -1645,7 +1603,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'), @@ -1655,7 +1612,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:), ] @@ -1748,7 +1704,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'), @@ -1756,7 +1711,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:), ] @@ -1796,7 +1750,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'), @@ -1806,7 +1759,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:), ] @@ -1899,7 +1851,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'), @@ -1907,7 +1858,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:), ] @@ -1946,7 +1896,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'), @@ -1956,7 +1905,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:), ] @@ -2048,7 +1996,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'), @@ -2056,7 +2003,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:), ] @@ -2095,7 +2041,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'), @@ -2105,7 +2050,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:), ] @@ -2197,7 +2141,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'), @@ -2205,7 +2148,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:), ] @@ -2244,7 +2186,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'), @@ -2254,7 +2195,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:), ] @@ -2346,7 +2286,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'), @@ -2354,7 +2293,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:), ] @@ -2393,7 +2331,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'), @@ -2403,7 +2340,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:), ] @@ -2495,7 +2431,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'), @@ -2503,7 +2438,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:), ] @@ -2542,7 +2476,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'), @@ -2552,7 +2485,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:), ] @@ -2652,7 +2584,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'), @@ -2660,7 +2591,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:), ] @@ -2700,7 +2630,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'), @@ -2710,7 +2639,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:), ] @@ -2803,7 +2731,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'), @@ -2811,7 +2738,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:), ] @@ -2850,7 +2776,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'), @@ -2860,7 +2785,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:), ] @@ -2952,7 +2876,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'), @@ -2960,7 +2883,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:), ] @@ -2999,7 +2921,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'), @@ -3009,7 +2930,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:), ] @@ -3109,7 +3029,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'), @@ -3117,7 +3036,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:), ] @@ -3159,7 +3077,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'), @@ -3169,7 +3086,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:), ] @@ -3264,7 +3180,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'), @@ -3272,7 +3187,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:), ] @@ -3313,7 +3227,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'), @@ -3323,7 +3236,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:), ] @@ -3417,7 +3329,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'), @@ -3425,7 +3336,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:), ] @@ -3465,7 +3375,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'), @@ -3475,7 +3384,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:), ] @@ -3568,7 +3476,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'), @@ -3576,7 +3483,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:), ] @@ -3615,7 +3521,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'), @@ -3625,7 +3530,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:), ] @@ -3717,7 +3621,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'), @@ -3725,7 +3628,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:), ] @@ -3763,7 +3665,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'), @@ -3773,7 +3674,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:), ] @@ -3864,7 +3764,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'), @@ -3872,7 +3771,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:), ] @@ -3909,7 +3807,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'), @@ -3919,7 +3816,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:), ]
http://git-wip-us.apache.org/repos/asf/hive/blob/fa995bae/ql/src/test/results/clientpositive/selectindate.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/selectindate.q.out b/ql/src/test/results/clientpositive/selectindate.q.out index defebe3..9bcbc18 100644 --- a/ql/src/test/results/clientpositive/selectindate.q.out +++ b/ql/src/test/results/clientpositive/selectindate.q.out @@ -12,41 +12,33 @@ POSTHOOK: Output: database:default POSTHOOK: Output: default@datetest PREHOOK: query: insert into datetest values('2000-03-22', 1) PREHOOK: type: QUERY -PREHOOK: Input: default@values__tmp__table__1 PREHOOK: Output: default@datetest POSTHOOK: query: insert into datetest values('2000-03-22', 1) POSTHOOK: type: QUERY -POSTHOOK: Input: default@values__tmp__table__1 POSTHOOK: Output: default@datetest POSTHOOK: Lineage: datetest.dvalue EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ] POSTHOOK: Lineage: datetest.ivalue EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col2, type:string, comment:), ] PREHOOK: query: insert into datetest values('2001-03-22', 2) PREHOOK: type: QUERY -PREHOOK: Input: default@values__tmp__table__2 PREHOOK: Output: default@datetest POSTHOOK: query: insert into datetest values('2001-03-22', 2) POSTHOOK: type: QUERY -POSTHOOK: Input: default@values__tmp__table__2 POSTHOOK: Output: default@datetest POSTHOOK: Lineage: datetest.dvalue EXPRESSION [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col1, type:string, comment:), ] POSTHOOK: Lineage: datetest.ivalue EXPRESSION [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col2, type:string, comment:), ] PREHOOK: query: insert into datetest values('2002-03-22', 3) PREHOOK: type: QUERY -PREHOOK: Input: default@values__tmp__table__3 PREHOOK: Output: default@datetest POSTHOOK: query: insert into datetest values('2002-03-22', 3) POSTHOOK: type: QUERY -POSTHOOK: Input: default@values__tmp__table__3 POSTHOOK: Output: default@datetest POSTHOOK: Lineage: datetest.dvalue EXPRESSION [(values__tmp__table__3)values__tmp__table__3.FieldSchema(name:tmp_values_col1, type:string, comment:), ] POSTHOOK: Lineage: datetest.ivalue EXPRESSION [(values__tmp__table__3)values__tmp__table__3.FieldSchema(name:tmp_values_col2, type:string, comment:), ] PREHOOK: query: insert into datetest values('2003-03-22', 4) PREHOOK: type: QUERY -PREHOOK: Input: default@values__tmp__table__4 PREHOOK: Output: default@datetest POSTHOOK: query: insert into datetest values('2003-03-22', 4) POSTHOOK: type: QUERY -POSTHOOK: Input: default@values__tmp__table__4 POSTHOOK: Output: default@datetest POSTHOOK: Lineage: datetest.dvalue EXPRESSION [(values__tmp__table__4)values__tmp__table__4.FieldSchema(name:tmp_values_col1, type:string, comment:), ] POSTHOOK: Lineage: datetest.ivalue EXPRESSION [(values__tmp__table__4)values__tmp__table__4.FieldSchema(name:tmp_values_col2, type:string, comment:), ] http://git-wip-us.apache.org/repos/asf/hive/blob/fa995bae/ql/src/test/results/clientpositive/setop_no_distinct.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/setop_no_distinct.q.out b/ql/src/test/results/clientpositive/setop_no_distinct.q.out index 55e9ba7..3e286b3 100644 --- a/ql/src/test/results/clientpositive/setop_no_distinct.q.out +++ b/ql/src/test/results/clientpositive/setop_no_distinct.q.out @@ -8,11 +8,9 @@ POSTHOOK: Output: database:default POSTHOOK: Output: default@a PREHOOK: query: insert into table a values (1,2),(1,2),(1,2),(1,3),(2,3) PREHOOK: type: QUERY -PREHOOK: Input: default@values__tmp__table__1 PREHOOK: Output: default@a POSTHOOK: query: insert into table a values (1,2),(1,2),(1,2),(1,3),(2,3) POSTHOOK: type: QUERY -POSTHOOK: Input: default@values__tmp__table__1 POSTHOOK: Output: default@a POSTHOOK: Lineage: a.key EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ] POSTHOOK: Lineage: a.value EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col2, type:string, comment:), ] @@ -26,11 +24,9 @@ POSTHOOK: Output: database:default POSTHOOK: Output: default@b PREHOOK: query: insert into table b values (1,2),(1,2),(2,3) PREHOOK: type: QUERY -PREHOOK: Input: default@values__tmp__table__2 PREHOOK: Output: default@b POSTHOOK: query: insert into table b values (1,2),(1,2),(2,3) POSTHOOK: type: QUERY -POSTHOOK: Input: default@values__tmp__table__2 POSTHOOK: Output: default@b POSTHOOK: Lineage: b.key EXPRESSION [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col1, type:string, comment:), ] POSTHOOK: Lineage: b.value EXPRESSION [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col2, type:string, comment:), ] @@ -124,11 +120,9 @@ POSTHOOK: Output: database:default POSTHOOK: Output: default@a PREHOOK: query: insert into table a values (0),(1),(2),(2),(2),(2),(3),(NULL),(NULL),(NULL),(NULL),(NULL) PREHOOK: type: QUERY -PREHOOK: Input: default@values__tmp__table__3 PREHOOK: Output: default@a POSTHOOK: query: insert into table a values (0),(1),(2),(2),(2),(2),(3),(NULL),(NULL),(NULL),(NULL),(NULL) POSTHOOK: type: QUERY -POSTHOOK: Input: default@values__tmp__table__3 POSTHOOK: Output: default@a POSTHOOK: Lineage: a.key EXPRESSION [(values__tmp__table__3)values__tmp__table__3.FieldSchema(name:tmp_values_col1, type:string, comment:), ] PREHOOK: query: create table b(key bigint) @@ -141,11 +135,9 @@ POSTHOOK: Output: database:default POSTHOOK: Output: default@b PREHOOK: query: insert into table b values (1),(2),(2),(3),(5),(5),(NULL),(NULL),(NULL) PREHOOK: type: QUERY -PREHOOK: Input: default@values__tmp__table__4 PREHOOK: Output: default@b POSTHOOK: query: insert into table b values (1),(2),(2),(3),(5),(5),(NULL),(NULL),(NULL) POSTHOOK: type: QUERY -POSTHOOK: Input: default@values__tmp__table__4 POSTHOOK: Output: default@b POSTHOOK: Lineage: b.key EXPRESSION [(values__tmp__table__4)values__tmp__table__4.FieldSchema(name:tmp_values_col1, type:string, comment:), ] PREHOOK: query: select * from a except select * from b http://git-wip-us.apache.org/repos/asf/hive/blob/fa995bae/ql/src/test/results/clientpositive/skewjoin_onesideskew.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/skewjoin_onesideskew.q.out b/ql/src/test/results/clientpositive/skewjoin_onesideskew.q.out index 4556ab7..09aaaf6 100644 --- a/ql/src/test/results/clientpositive/skewjoin_onesideskew.q.out +++ b/ql/src/test/results/clientpositive/skewjoin_onesideskew.q.out @@ -12,31 +12,25 @@ POSTHOOK: Output: database:default POSTHOOK: Output: default@skewtable PREHOOK: query: INSERT INTO TABLE skewtable VALUES ("0", "val_0") PREHOOK: type: QUERY -PREHOOK: Input: default@values__tmp__table__1 PREHOOK: Output: default@skewtable POSTHOOK: query: INSERT INTO TABLE skewtable VALUES ("0", "val_0") POSTHOOK: type: QUERY -POSTHOOK: Input: default@values__tmp__table__1 POSTHOOK: Output: default@skewtable POSTHOOK: Lineage: skewtable.key SIMPLE [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ] POSTHOOK: Lineage: skewtable.value SIMPLE [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col2, type:string, comment:), ] PREHOOK: query: INSERT INTO TABLE skewtable VALUES ("0", "val_0") PREHOOK: type: QUERY -PREHOOK: Input: default@values__tmp__table__2 PREHOOK: Output: default@skewtable POSTHOOK: query: INSERT INTO TABLE skewtable VALUES ("0", "val_0") POSTHOOK: type: QUERY -POSTHOOK: Input: default@values__tmp__table__2 POSTHOOK: Output: default@skewtable POSTHOOK: Lineage: skewtable.key SIMPLE [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col1, type:string, comment:), ] POSTHOOK: Lineage: skewtable.value SIMPLE [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col2, type:string, comment:), ] PREHOOK: query: INSERT INTO TABLE skewtable VALUES ("0", "val_0") PREHOOK: type: QUERY -PREHOOK: Input: default@values__tmp__table__3 PREHOOK: Output: default@skewtable POSTHOOK: query: INSERT INTO TABLE skewtable VALUES ("0", "val_0") POSTHOOK: type: QUERY -POSTHOOK: Input: default@values__tmp__table__3 POSTHOOK: Output: default@skewtable POSTHOOK: Lineage: skewtable.key SIMPLE [(values__tmp__table__3)values__tmp__table__3.FieldSchema(name:tmp_values_col1, type:string, comment:), ] POSTHOOK: Lineage: skewtable.value SIMPLE [(values__tmp__table__3)values__tmp__table__3.FieldSchema(name:tmp_values_col2, type:string, comment:), ] @@ -54,21 +48,17 @@ POSTHOOK: Output: database:default POSTHOOK: Output: default@nonskewtable PREHOOK: query: INSERT INTO TABLE nonskewtable VALUES ("1", "val_1") PREHOOK: type: QUERY -PREHOOK: Input: default@values__tmp__table__4 PREHOOK: Output: default@nonskewtable POSTHOOK: query: INSERT INTO TABLE nonskewtable VALUES ("1", "val_1") POSTHOOK: type: QUERY -POSTHOOK: Input: default@values__tmp__table__4 POSTHOOK: Output: default@nonskewtable POSTHOOK: Lineage: nonskewtable.key SIMPLE [(values__tmp__table__4)values__tmp__table__4.FieldSchema(name:tmp_values_col1, type:string, comment:), ] POSTHOOK: Lineage: nonskewtable.value SIMPLE [(values__tmp__table__4)values__tmp__table__4.FieldSchema(name:tmp_values_col2, type:string, comment:), ] PREHOOK: query: INSERT INTO TABLE nonskewtable VALUES ("2", "val_2") PREHOOK: type: QUERY -PREHOOK: Input: default@values__tmp__table__5 PREHOOK: Output: default@nonskewtable POSTHOOK: query: INSERT INTO TABLE nonskewtable VALUES ("2", "val_2") POSTHOOK: type: QUERY -POSTHOOK: Input: default@values__tmp__table__5 POSTHOOK: Output: default@nonskewtable POSTHOOK: Lineage: nonskewtable.key SIMPLE [(values__tmp__table__5)values__tmp__table__5.FieldSchema(name:tmp_values_col1, type:string, comment:), ] POSTHOOK: Lineage: nonskewtable.value SIMPLE [(values__tmp__table__5)values__tmp__table__5.FieldSchema(name:tmp_values_col2, type:string, comment:), ] http://git-wip-us.apache.org/repos/asf/hive/blob/fa995bae/ql/src/test/results/clientpositive/skiphf_aggr.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/skiphf_aggr.q.out b/ql/src/test/results/clientpositive/skiphf_aggr.q.out index aeb4b1b..2af06db 100644 --- a/ql/src/test/results/clientpositive/skiphf_aggr.q.out +++ b/ql/src/test/results/clientpositive/skiphf_aggr.q.out @@ -18,20 +18,16 @@ POSTHOOK: Output: database:default POSTHOOK: Output: default@skipHTbl PREHOOK: query: INSERT OVERWRITE TABLE skipHTbl PARTITION (b = 1) VALUES (1), (2), (3), (4) PREHOOK: type: QUERY -PREHOOK: Input: default@values__tmp__table__1 PREHOOK: Output: default@skiphtbl@b=1 POSTHOOK: query: INSERT OVERWRITE TABLE skipHTbl PARTITION (b = 1) VALUES (1), (2), (3), (4) POSTHOOK: type: QUERY -POSTHOOK: Input: default@values__tmp__table__1 POSTHOOK: Output: default@skiphtbl@b=1 POSTHOOK: Lineage: skiphtbl PARTITION(b=1).a EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ] PREHOOK: query: INSERT OVERWRITE TABLE skipHTbl PARTITION (b = 2) VALUES (1), (2), (3), (4) PREHOOK: type: QUERY -PREHOOK: Input: default@values__tmp__table__2 PREHOOK: Output: default@skiphtbl@b=2 POSTHOOK: query: INSERT OVERWRITE TABLE skipHTbl PARTITION (b = 2) VALUES (1), (2), (3), (4) POSTHOOK: type: QUERY -POSTHOOK: Input: default@values__tmp__table__2 POSTHOOK: Output: default@skiphtbl@b=2 POSTHOOK: Lineage: skiphtbl PARTITION(b=2).a EXPRESSION [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col1, type:string, comment:), ] PREHOOK: query: SELECT * FROM skipHTbl @@ -96,20 +92,16 @@ POSTHOOK: Input: default@skiphtbl@b=2 4 PREHOOK: query: INSERT OVERWRITE TABLE skipHTbl PARTITION (b = 1) VALUES (1) PREHOOK: type: QUERY -PREHOOK: Input: default@values__tmp__table__3 PREHOOK: Output: default@skiphtbl@b=1 POSTHOOK: query: INSERT OVERWRITE TABLE skipHTbl PARTITION (b = 1) VALUES (1) POSTHOOK: type: QUERY -POSTHOOK: Input: default@values__tmp__table__3 POSTHOOK: Output: default@skiphtbl@b=1 POSTHOOK: Lineage: skiphtbl PARTITION(b=1).a EXPRESSION [(values__tmp__table__3)values__tmp__table__3.FieldSchema(name:tmp_values_col1, type:string, comment:), ] PREHOOK: query: INSERT OVERWRITE TABLE skipHTbl PARTITION (b = 2) VALUES (1), (2), (3), (4) PREHOOK: type: QUERY -PREHOOK: Input: default@values__tmp__table__4 PREHOOK: Output: default@skiphtbl@b=2 POSTHOOK: query: INSERT OVERWRITE TABLE skipHTbl PARTITION (b = 2) VALUES (1), (2), (3), (4) POSTHOOK: type: QUERY -POSTHOOK: Input: default@values__tmp__table__4 POSTHOOK: Output: default@skiphtbl@b=2 POSTHOOK: Lineage: skiphtbl PARTITION(b=2).a EXPRESSION [(values__tmp__table__4)values__tmp__table__4.FieldSchema(name:tmp_values_col1, type:string, comment:), ] PREHOOK: query: SELECT DISTINCT b FROM skipHTbl @@ -173,20 +165,16 @@ POSTHOOK: Output: database:default POSTHOOK: Output: default@skipFTbl PREHOOK: query: INSERT OVERWRITE TABLE skipFTbl PARTITION (b = 1) VALUES (1), (2), (3), (4) PREHOOK: type: QUERY -PREHOOK: Input: default@values__tmp__table__5 PREHOOK: Output: default@skipftbl@b=1 POSTHOOK: query: INSERT OVERWRITE TABLE skipFTbl PARTITION (b = 1) VALUES (1), (2), (3), (4) POSTHOOK: type: QUERY -POSTHOOK: Input: default@values__tmp__table__5 POSTHOOK: Output: default@skipftbl@b=1 POSTHOOK: Lineage: skipftbl PARTITION(b=1).a EXPRESSION [(values__tmp__table__5)values__tmp__table__5.FieldSchema(name:tmp_values_col1, type:string, comment:), ] PREHOOK: query: INSERT OVERWRITE TABLE skipFTbl PARTITION (b = 2) VALUES (1), (2), (3), (4) PREHOOK: type: QUERY -PREHOOK: Input: default@values__tmp__table__6 PREHOOK: Output: default@skipftbl@b=2 POSTHOOK: query: INSERT OVERWRITE TABLE skipFTbl PARTITION (b = 2) VALUES (1), (2), (3), (4) POSTHOOK: type: QUERY -POSTHOOK: Input: default@values__tmp__table__6 POSTHOOK: Output: default@skipftbl@b=2 POSTHOOK: Lineage: skipftbl PARTITION(b=2).a EXPRESSION [(values__tmp__table__6)values__tmp__table__6.FieldSchema(name:tmp_values_col1, type:string, comment:), ] PREHOOK: query: SELECT * FROM skipFTbl http://git-wip-us.apache.org/repos/asf/hive/blob/fa995bae/ql/src/test/results/clientpositive/smb_join_partition_key.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/smb_join_partition_key.q.out b/ql/src/test/results/clientpositive/smb_join_partition_key.q.out index a4ab8c3..7fa9d2e 100644 --- a/ql/src/test/results/clientpositive/smb_join_partition_key.q.out +++ b/ql/src/test/results/clientpositive/smb_join_partition_key.q.out @@ -8,21 +8,17 @@ POSTHOOK: Output: database:default POSTHOOK: Output: default@data_table PREHOOK: query: insert into table data_table values(1, 'one') PREHOOK: type: QUERY -PREHOOK: Input: default@values__tmp__table__1 PREHOOK: Output: default@data_table POSTHOOK: query: insert into table data_table values(1, 'one') POSTHOOK: type: QUERY -POSTHOOK: Input: default@values__tmp__table__1 POSTHOOK: Output: default@data_table POSTHOOK: Lineage: data_table.key EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ] POSTHOOK: Lineage: data_table.value SIMPLE [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col2, type:string, comment:), ] PREHOOK: query: insert into table data_table values(2, 'two') PREHOOK: type: QUERY -PREHOOK: Input: default@values__tmp__table__2 PREHOOK: Output: default@data_table POSTHOOK: query: insert into table data_table values(2, 'two') POSTHOOK: type: QUERY -POSTHOOK: Input: default@values__tmp__table__2 POSTHOOK: Output: default@data_table POSTHOOK: Lineage: data_table.key EXPRESSION [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col1, type:string, comment:), ] POSTHOOK: Lineage: data_table.value SIMPLE [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col2, type:string, comment:), ] http://git-wip-us.apache.org/repos/asf/hive/blob/fa995bae/ql/src/test/results/clientpositive/smb_mapjoin_46.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/smb_mapjoin_46.q.out b/ql/src/test/results/clientpositive/smb_mapjoin_46.q.out index df8b14a..53dc1e7 100644 --- a/ql/src/test/results/clientpositive/smb_mapjoin_46.q.out +++ b/ql/src/test/results/clientpositive/smb_mapjoin_46.q.out @@ -9,12 +9,10 @@ POSTHOOK: Output: default@aux1 PREHOOK: query: INSERT INTO aux1 VALUES (NULL, NULL, 'None'), (98, NULL, 'None'), (99, 0, 'Alice'), (99, 2, 'Mat'), (100, 1, 'Bob'), (101, 2, 'Car') PREHOOK: type: QUERY -PREHOOK: Input: default@values__tmp__table__1 PREHOOK: Output: default@aux1 POSTHOOK: query: INSERT INTO aux1 VALUES (NULL, NULL, 'None'), (98, NULL, 'None'), (99, 0, 'Alice'), (99, 2, 'Mat'), (100, 1, 'Bob'), (101, 2, 'Car') POSTHOOK: type: QUERY -POSTHOOK: Input: default@values__tmp__table__1 POSTHOOK: Output: default@aux1 POSTHOOK: Lineage: aux1.col_1 SIMPLE [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col3, type:string, comment:), ] POSTHOOK: Lineage: aux1.key EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ] @@ -51,12 +49,10 @@ POSTHOOK: Output: default@aux2 PREHOOK: query: INSERT INTO aux2 VALUES (102, 2, 'Del'), (103, 2, 'Ema'), (104, 3, 'Fli'), (105, NULL, 'None') PREHOOK: type: QUERY -PREHOOK: Input: default@values__tmp__table__2 PREHOOK: Output: default@aux2 POSTHOOK: query: INSERT INTO aux2 VALUES (102, 2, 'Del'), (103, 2, 'Ema'), (104, 3, 'Fli'), (105, NULL, 'None') POSTHOOK: type: QUERY -POSTHOOK: Input: default@values__tmp__table__2 POSTHOOK: Output: default@aux2 POSTHOOK: Lineage: aux2.col_2 SIMPLE [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col3, type:string, comment:), ] POSTHOOK: Lineage: aux2.key EXPRESSION [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col1, type:string, comment:), ] http://git-wip-us.apache.org/repos/asf/hive/blob/fa995bae/ql/src/test/results/clientpositive/spark/constprog_semijoin.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/spark/constprog_semijoin.q.out b/ql/src/test/results/clientpositive/spark/constprog_semijoin.q.out index 0042255..89c2735 100644 --- a/ql/src/test/results/clientpositive/spark/constprog_semijoin.q.out +++ b/ql/src/test/results/clientpositive/spark/constprog_semijoin.q.out @@ -8,11 +8,9 @@ POSTHOOK: Output: database:default POSTHOOK: Output: default@table1 PREHOOK: query: insert into table1 (id, val, val1, dimid) values (1, 't1val01', 'val101', 100), (2, 't1val02', 'val102', 200), (3, 't1val03', 'val103', 103), (3, 't1val01', 'val104', 100), (2, 't1val05', 'val105', 200), (3, 't1val01', 'val106', 103), (1, 't1val07', 'val107', 200), (2, 't1val01', 'val108', 200), (3, 't1val09', 'val109', 103), (4,'t1val01', 'val110', 200) PREHOOK: type: QUERY -PREHOOK: Input: default@values__tmp__table__1 PREHOOK: Output: default@table1 POSTHOOK: query: insert into table1 (id, val, val1, dimid) values (1, 't1val01', 'val101', 100), (2, 't1val02', 'val102', 200), (3, 't1val03', 'val103', 103), (3, 't1val01', 'val104', 100), (2, 't1val05', 'val105', 200), (3, 't1val01', 'val106', 103), (1, 't1val07', 'val107', 200), (2, 't1val01', 'val108', 200), (3, 't1val09', 'val109', 103), (4,'t1val01', 'val110', 200) POSTHOOK: type: QUERY -POSTHOOK: Input: default@values__tmp__table__1 POSTHOOK: Output: default@table1 POSTHOOK: Lineage: table1.dimid EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col4, type:string, comment:), ] POSTHOOK: Lineage: table1.id EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ] @@ -28,11 +26,9 @@ POSTHOOK: Output: database:default POSTHOOK: Output: default@table2 PREHOOK: query: insert into table2 (id, val2) values (1, 't2val201'), (2, 't2val202'), (3, 't2val203') PREHOOK: type: QUERY -PREHOOK: Input: default@values__tmp__table__2 PREHOOK: Output: default@table2 POSTHOOK: query: insert into table2 (id, val2) values (1, 't2val201'), (2, 't2val202'), (3, 't2val203') POSTHOOK: type: QUERY -POSTHOOK: Input: default@values__tmp__table__2 POSTHOOK: Output: default@table2 POSTHOOK: Lineage: table2.id EXPRESSION [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col1, type:string, comment:), ] POSTHOOK: Lineage: table2.val2 SIMPLE [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col2, type:string, comment:), ] @@ -46,11 +42,9 @@ POSTHOOK: Output: database:default POSTHOOK: Output: default@table3 PREHOOK: query: insert into table3 (id) values (100), (100), (101), (102), (103) PREHOOK: type: QUERY -PREHOOK: Input: default@values__tmp__table__3 PREHOOK: Output: default@table3 POSTHOOK: query: insert into table3 (id) values (100), (100), (101), (102), (103) POSTHOOK: type: QUERY -POSTHOOK: Input: default@values__tmp__table__3 POSTHOOK: Output: default@table3 POSTHOOK: Lineage: table3.id EXPRESSION [(values__tmp__table__3)values__tmp__table__3.FieldSchema(name:tmp_values_col1, type:string, comment:), ] PREHOOK: query: explain select table1.id, table1.val, table1.val1 from table1 left semi join table3 on table1.dimid = table3.id where table1.val = 't1val01' http://git-wip-us.apache.org/repos/asf/hive/blob/fa995bae/ql/src/test/results/clientpositive/spark/insert_into1.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/spark/insert_into1.q.out b/ql/src/test/results/clientpositive/spark/insert_into1.q.out index e817e05..764e29e 100644 --- a/ql/src/test/results/clientpositive/spark/insert_into1.q.out +++ b/ql/src/test/results/clientpositive/spark/insert_into1.q.out @@ -523,11 +523,9 @@ STAGE PLANS: PREHOOK: query: insert into table insert_into1 values(1, 'abc') PREHOOK: type: QUERY -PREHOOK: Input: default@values__tmp__table__2 PREHOOK: Output: default@insert_into1 POSTHOOK: query: insert into table insert_into1 values(1, 'abc') POSTHOOK: type: QUERY -POSTHOOK: Input: default@values__tmp__table__2 POSTHOOK: Output: default@insert_into1 POSTHOOK: Lineage: insert_into1.key EXPRESSION [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col1, type:string, comment:), ] POSTHOOK: Lineage: insert_into1.value SIMPLE [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col2, type:string, comment:), ]