You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by ai...@apache.org on 2016/12/06 20:47:38 UTC
[02/47] hive git commit: HIVE-15346: "values temp table" should not
be an input (Aihua Xu, reviewed by Yongzhi Chen)
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:), ]