hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From jcama...@apache.org
Subject [1/2] hive git commit: HIVE-15583: CTAS query removes leading underscore from column names with CBO (Jesus Camacho Rodriguez, reviewed by Ashutosh Chauhan)
Date Sat, 14 Jan 2017 10:14:40 GMT
Repository: hive
Updated Branches:
  refs/heads/master c8a0cb006 -> 566788696


http://git-wip-us.apache.org/repos/asf/hive/blob/56678869/ql/src/test/results/clientpositive/llap/vector_number_compare_projection.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/vector_number_compare_projection.q.out
b/ql/src/test/results/clientpositive/llap/vector_number_compare_projection.q.out
index 92a4cf7..3b8c0dc 100644
--- a/ql/src/test/results/clientpositive/llap/vector_number_compare_projection.q.out
+++ b/ql/src/test/results/clientpositive/llap/vector_number_compare_projection.q.out
@@ -181,7 +181,7 @@ POSTHOOK: query: SELECT sum(hash(*)) FROM
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@vectortab2k_orc
 #### A masked pattern was here ####
-c0
+_c0
 -3601806268
 PREHOOK: query: EXPLAIN
 SELECT sum(hash(*)) FROM
@@ -260,7 +260,7 @@ POSTHOOK: query: SELECT sum(hash(*)) FROM
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@vectortab2k_orc
 #### A masked pattern was here ####
-c0
+_c0
 24462176095
 PREHOOK: query: -- With some filtering
 SELECT sum(hash(*)) FROM
@@ -278,7 +278,7 @@ SELECT sum(hash(*)) FROM
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@vectortab2k_orc
 #### A masked pattern was here ####
-c0
+_c0
 62396741790
 PREHOOK: query: SELECT sum(hash(*)) FROM
     (SELECT t, si, i, b, (t > 0) as compare1, (si >= 0) as compare2, (i != 0) as compare3,
(b > 0) as compare4 from vectortab2k_orc
@@ -294,7 +294,7 @@ POSTHOOK: query: SELECT sum(hash(*)) FROM
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@vectortab2k_orc
 #### A masked pattern was here ####
-c0
+_c0
 14122059922
 PREHOOK: query: --
 -- Projection LongScalar<Compare>LongColumn
@@ -314,7 +314,7 @@ SELECT sum(hash(*)) FROM
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@vectortab2k_orc
 #### A masked pattern was here ####
-c0
+_c0
 -3601796069
 PREHOOK: query: SELECT sum(hash(*)) FROM
     (SELECT t, si, i, b, (0 > t) as compare1, (0 >= si) as compare2, (0 != i) as compare3,
(0 > b) as compare4 from vectortab2k_orc
@@ -328,7 +328,7 @@ POSTHOOK: query: SELECT sum(hash(*)) FROM
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@vectortab2k_orc
 #### A masked pattern was here ####
-c0
+_c0
 20166891877
 PREHOOK: query: -- With some filtering
 SELECT sum(hash(*)) FROM
@@ -346,7 +346,7 @@ SELECT sum(hash(*)) FROM
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@vectortab2k_orc
 #### A masked pattern was here ####
-c0
+_c0
 62396748920
 PREHOOK: query: SELECT sum(hash(*)) FROM
     (SELECT t, si, i, b, (0 > t) as compare1, (0 >= si) as compare2, (0 != i) as compare3,
(0 > b) as compare4 from vectortab2k_orc
@@ -362,7 +362,7 @@ POSTHOOK: query: SELECT sum(hash(*)) FROM
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@vectortab2k_orc
 #### A masked pattern was here ####
-c0
+_c0
 14121946175
 PREHOOK: query: CREATE TABLE scratch_repeat AS SELECT t, si, i, b, bo, 20 as t_repeat,
      9000 as si_repeat, 9233320 as i_repeat, -823823999339992 as b_repeat, false as bo_repeat_false,
true as bo_repeat_true FROM vectortab2k
@@ -432,7 +432,7 @@ SELECT sum(hash(*)) FROM
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@vectortab2k_orc_repeat
 #### A masked pattern was here ####
-c0
+_c0
 972535192000
 PREHOOK: query: SELECT sum(hash(*)) FROM
     (SELECT t_repeat, si_repeat, i_repeat, (t_repeat < 0) as compare1, (si_repeat <=0)
as compare2, (i_repeat != 0) as compare3 from vectortab2k_orc_repeat
@@ -446,7 +446,7 @@ POSTHOOK: query: SELECT sum(hash(*)) FROM
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@vectortab2k_orc_repeat
 #### A masked pattern was here ####
-c0
+_c0
 972533210000
 PREHOOK: query: -- With some filtering
 SELECT sum(hash(*)) FROM
@@ -464,7 +464,7 @@ SELECT sum(hash(*)) FROM
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@vectortab2k_orc_repeat
 #### A masked pattern was here ####
-c0
+_c0
 231949643292
 PREHOOK: query: SELECT sum(hash(*)) FROM
     (SELECT t_repeat, si_repeat, i_repeat, (t_repeat < 0) as compare1, (si_repeat <=0)
as compare2, (i_repeat != 0) as compare3 from vectortab2k_orc_repeat
@@ -480,7 +480,7 @@ POSTHOOK: query: SELECT sum(hash(*)) FROM
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@vectortab2k_orc_repeat
 #### A masked pattern was here ####
-c0
+_c0
 235353036820
 PREHOOK: query: --
 -- Projection LongScalar<Compare>LongColumn
@@ -500,7 +500,7 @@ SELECT sum(hash(*)) FROM
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@vectortab2k_orc_repeat
 #### A masked pattern was here ####
-c0
+_c0
 972533208000
 PREHOOK: query: SELECT sum(hash(*)) FROM
     (SELECT t_repeat, si_repeat, i_repeat, (0 < t_repeat) as compare1, (0 <= si_repeat)
as compare2, (0 != i_repeat) as compare3 from vectortab2k_orc_repeat
@@ -514,7 +514,7 @@ POSTHOOK: query: SELECT sum(hash(*)) FROM
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@vectortab2k_orc_repeat
 #### A masked pattern was here ####
-c0
+_c0
 972535194000
 PREHOOK: query: -- With some filtering
 SELECT sum(hash(*)) FROM
@@ -532,7 +532,7 @@ SELECT sum(hash(*)) FROM
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@vectortab2k_orc_repeat
 #### A masked pattern was here ####
-c0
+_c0
 231949170108
 PREHOOK: query: SELECT sum(hash(*)) FROM
     (SELECT t_repeat, si_repeat, i_repeat, (0 < t_repeat) as compare1, (0 <= si_repeat)
as compare2, (0 != i_repeat) as compare3 from vectortab2k_orc_repeat
@@ -548,7 +548,7 @@ POSTHOOK: query: SELECT sum(hash(*)) FROM
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@vectortab2k_orc_repeat
 #### A masked pattern was here ####
-c0
+_c0
 235353516948
 PREHOOK: query: CREATE TABLE scratch_null AS SELECT t, si, i, b, bo,
      cast(null as tinyint) as t_null, cast(null as smallint) as si_null, cast(null as int)
as i_null, cast(null as bigint) as b_null, cast(null as boolean) as bo_null FROM vectortab2k
@@ -614,7 +614,7 @@ SELECT sum(hash(*)) FROM
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@vectortab2k_orc_null
 #### A masked pattern was here ####
-c0
+_c0
 0
 PREHOOK: query: SELECT sum(hash(*)) FROM
     (SELECT t_null, si_null, i_null, (t_null < 0) as compare1, (si_null <=0) as compare2,
(i_null != 0) as compare3 from vectortab2k_orc_null
@@ -628,7 +628,7 @@ POSTHOOK: query: SELECT sum(hash(*)) FROM
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@vectortab2k_orc_null
 #### A masked pattern was here ####
-c0
+_c0
 0
 PREHOOK: query: -- With some filtering
 SELECT sum(hash(*)) FROM
@@ -646,7 +646,7 @@ SELECT sum(hash(*)) FROM
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@vectortab2k_orc_null
 #### A masked pattern was here ####
-c0
+_c0
 0
 PREHOOK: query: SELECT sum(hash(*)) FROM
     (SELECT t_null, si_null, i_null, (t_null < 0) as compare1, (si_null <=0) as compare2,
(i_null != 0) as compare3 from vectortab2k_orc_null
@@ -662,7 +662,7 @@ POSTHOOK: query: SELECT sum(hash(*)) FROM
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@vectortab2k_orc_null
 #### A masked pattern was here ####
-c0
+_c0
 0
 PREHOOK: query: --
 -- Projection LongScalar<Compare>LongColumn
@@ -682,7 +682,7 @@ SELECT sum(hash(*)) FROM
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@vectortab2k_orc_null
 #### A masked pattern was here ####
-c0
+_c0
 0
 PREHOOK: query: SELECT sum(hash(*)) FROM
     (SELECT t_null, si_null, i_null, (0 < t_null) as compare1, (0 <= si_null) as compare2,
(0 != i_null) as compare3 from vectortab2k_orc_null
@@ -696,7 +696,7 @@ POSTHOOK: query: SELECT sum(hash(*)) FROM
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@vectortab2k_orc_null
 #### A masked pattern was here ####
-c0
+_c0
 0
 PREHOOK: query: -- With some filtering
 SELECT sum(hash(*)) FROM
@@ -714,7 +714,7 @@ SELECT sum(hash(*)) FROM
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@vectortab2k_orc_null
 #### A masked pattern was here ####
-c0
+_c0
 0
 PREHOOK: query: SELECT sum(hash(*)) FROM
     (SELECT t_null, si_null, i_null, (0 < t_null) as compare1, (0 <= si_null) as compare2,
(0 != i_null) as compare3 from vectortab2k_orc_null
@@ -730,5 +730,5 @@ POSTHOOK: query: SELECT sum(hash(*)) FROM
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@vectortab2k_orc_null
 #### A masked pattern was here ####
-c0
+_c0
 0

http://git-wip-us.apache.org/repos/asf/hive/blob/56678869/ql/src/test/results/clientpositive/llap/vectorization_0.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/vectorization_0.q.out b/ql/src/test/results/clientpositive/llap/vectorization_0.q.out
index 7e1bae1..3097d99 100644
--- a/ql/src/test/results/clientpositive/llap/vectorization_0.q.out
+++ b/ql/src/test/results/clientpositive/llap/vectorization_0.q.out
@@ -30190,7 +30190,7 @@ POSTHOOK: type: CREATETABLE_AS_SELECT
 POSTHOOK: Input: default@srcbucket
 POSTHOOK: Output: database:default
 POSTHOOK: Output: default@cast_string_to_int_1
-POSTHOOK: Lineage: cast_string_to_int_1.c0 EXPRESSION [(srcbucket)srcbucket.FieldSchema(name:key,
type:int, comment:null), ]
+POSTHOOK: Lineage: cast_string_to_int_1._c0 EXPRESSION [(srcbucket)srcbucket.FieldSchema(name:key,
type:int, comment:null), ]
 POSTHOOK: Lineage: cast_string_to_int_1.value SIMPLE [(srcbucket)srcbucket.FieldSchema(name:value,
type:string, comment:null), ]
 PREHOOK: query: create table cast_string_to_int_2(i int,s string)
 PREHOOK: type: CREATETABLE
@@ -30208,7 +30208,7 @@ POSTHOOK: query: insert overwrite table cast_string_to_int_2 select
* from cast_
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@cast_string_to_int_1
 POSTHOOK: Output: default@cast_string_to_int_2
-POSTHOOK: Lineage: cast_string_to_int_2.i EXPRESSION [(cast_string_to_int_1)cast_string_to_int_1.FieldSchema(name:c0,
type:string, comment:null), ]
+POSTHOOK: Lineage: cast_string_to_int_2.i EXPRESSION [(cast_string_to_int_1)cast_string_to_int_1.FieldSchema(name:_c0,
type:string, comment:null), ]
 POSTHOOK: Lineage: cast_string_to_int_2.s SIMPLE [(cast_string_to_int_1)cast_string_to_int_1.FieldSchema(name:value,
type:string, comment:null), ]
 PREHOOK: query: --moving ALL_1 system test here
 select all key from src

http://git-wip-us.apache.org/repos/asf/hive/blob/56678869/ql/src/test/results/clientpositive/llap/vectorized_date_funcs.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/vectorized_date_funcs.q.out b/ql/src/test/results/clientpositive/llap/vectorized_date_funcs.q.out
index 42d1a35..9a74a9f 100644
--- a/ql/src/test/results/clientpositive/llap/vectorized_date_funcs.q.out
+++ b/ql/src/test/results/clientpositive/llap/vectorized_date_funcs.q.out
@@ -58,7 +58,7 @@ POSTHOOK: Input: default@date_udf_flight
 POSTHOOK: Output: default@date_udf_flight_orc
 POSTHOOK: Lineage: date_udf_flight_orc.fl_date SIMPLE [(date_udf_flight)date_udf_flight.FieldSchema(name:fl_date,
type:date, comment:null), ]
 POSTHOOK: Lineage: date_udf_flight_orc.fl_time EXPRESSION [(date_udf_flight)date_udf_flight.FieldSchema(name:fl_date,
type:date, comment:null), ]
-fl_date	c1
+fl_date	_c1
 PREHOOK: query: SELECT * FROM date_udf_flight_orc
 PREHOOK: type: QUERY
 PREHOOK: Input: default@date_udf_flight_orc
@@ -317,7 +317,7 @@ FROM date_udf_flight_orc
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@date_udf_flight_orc
 #### A masked pattern was here ####
-fl_time	c1	c2	c3	c4	c5	c6	c7	c8	c9	c10	c11	c12	c13	c14	c15	c16	c17	c18	c19
+fl_time	_c1	_c2	_c3	_c4	_c5	_c6	_c7	_c8	_c9	_c10	_c11	_c12	_c13	_c14	_c15	_c16	_c17	_c18
_c19
 2010-10-20 07:00:00	1287583200	2010	10	20	20	4	42	2010-10-20	2010-10-20	2010-10-22	2010-10-18
3945	3945	3945	3945	1316	1316	1316	1316
 2010-10-20 07:00:00	1287583200	2010	10	20	20	4	42	2010-10-20	2010-10-20	2010-10-22	2010-10-18
3945	3945	3945	3945	1316	1316	1316	1316
 2010-10-20 07:00:00	1287583200	2010	10	20	20	4	42	2010-10-20	2010-10-20	2010-10-22	2010-10-18
3945	3945	3945	3945	1316	1316	1316	1316
@@ -567,7 +567,7 @@ FROM date_udf_flight_orc
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@date_udf_flight_orc
 #### A masked pattern was here ####
-fl_date	c1	c2	c3	c4	c5	c6	c7	c8	c9	c10	c11	c12	c13	c14	c15	c16	c17	c18	c19
+fl_date	_c1	_c2	_c3	_c4	_c5	_c6	_c7	_c8	_c9	_c10	_c11	_c12	_c13	_c14	_c15	_c16	_c17	_c18
_c19
 2010-10-20	1287558000	2010	10	20	20	4	42	2010-10-20	2010-10-20	2010-10-22	2010-10-18	3945
3945	3945	3945	1316	1316	1316	1316
 2010-10-20	1287558000	2010	10	20	20	4	42	2010-10-20	2010-10-20	2010-10-22	2010-10-18	3945
3945	3945	3945	1316	1316	1316	1316
 2010-10-20	1287558000	2010	10	20	20	4	42	2010-10-20	2010-10-20	2010-10-22	2010-10-18	3945
3945	3945	3945	1316	1316	1316	1316
@@ -827,7 +827,7 @@ FROM date_udf_flight_orc
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@date_udf_flight_orc
 #### A masked pattern was here ####
-fl_time	fl_date	c2	c3	c4	c5	c6	c7	c8	c9	c10	c11	c12	c13	c14	c15	c16	c17	c18	c19	c20	c21
+fl_time	fl_date	_c2	_c3	_c4	_c5	_c6	_c7	_c8	_c9	_c10	_c11	_c12	_c13	_c14	_c15	_c16	_c17	_c18
_c19	_c20	_c21
 2010-10-20 07:00:00	2010-10-20	true	true	true	true	true	true	true	true	true	true	true	true
true	true	true	true	true	true	true	true
 2010-10-20 07:00:00	2010-10-20	true	true	true	true	true	true	true	true	true	true	true	true
true	true	true	true	true	true	true	true
 2010-10-20 07:00:00	2010-10-20	true	true	true	true	true	true	true	true	true	true	true	true
true	true	true	true	true	true	true	true
@@ -1023,7 +1023,7 @@ FROM date_udf_flight_orc LIMIT 10
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@date_udf_flight_orc
 #### A masked pattern was here ####
-fl_date	c1	c2	c3	c4	c5
+fl_date	_c1	_c2	_c3	_c4	_c5
 2010-10-20	2010-10-22	2010-10-18	-2	2	4
 2010-10-20	2010-10-22	2010-10-18	-2	2	4
 2010-10-20	2010-10-22	2010-10-18	-2	2	4
@@ -1044,7 +1044,7 @@ SELECT to_date('2009-07-30 04:17:52') FROM date_udf_flight_orc LIMIT
1
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@date_udf_flight_orc
 #### A masked pattern was here ####
-c0
+_c0
 2009-07-30
 PREHOOK: query: EXPLAIN SELECT
   min(fl_date) AS c1,
@@ -1150,5 +1150,5 @@ ORDER BY c1
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@date_udf_flight_orc
 #### A masked pattern was here ####
-c1	c1_1	c2	c3
+c1	_c1	_c2	_c3
 2010-10-20	2010-10-31	137	137

http://git-wip-us.apache.org/repos/asf/hive/blob/56678869/ql/src/test/results/clientpositive/masking_8.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/masking_8.q.out b/ql/src/test/results/clientpositive/masking_8.q.out
index b365962..b33df21 100644
--- a/ql/src/test/results/clientpositive/masking_8.q.out
+++ b/ql/src/test/results/clientpositive/masking_8.q.out
@@ -12,7 +12,7 @@ POSTHOOK: type: CREATETABLE_AS_SELECT
 POSTHOOK: Input: default@src
 POSTHOOK: Output: database:default
 POSTHOOK: Output: default@masking_test
-POSTHOOK: Lineage: masking_test.c2 SIMPLE []
+POSTHOOK: Lineage: masking_test._c2 SIMPLE []
 POSTHOOK: Lineage: masking_test.key EXPRESSION [(src)src.FieldSchema(name:key, type:string,
comment:default), ]
 POSTHOOK: Lineage: masking_test.value SIMPLE [(src)src.FieldSchema(name:value, type:string,
comment:default), ]
 PREHOOK: query: explain select *, ROW__ID from masking_test
@@ -34,7 +34,7 @@ STAGE PLANS:
               predicate: (((key % 2) = 0) and (key < 10)) (type: boolean)
               Statistics: Num rows: 83 Data size: 1130 Basic stats: COMPLETE Column stats:
NONE
               Select Operator
-                expressions: key (type: int), reverse(value) (type: string), c2 (type: string),
ROW__ID (type: struct<transactionid:bigint,bucketid:int,rowid:bigint>)
+                expressions: key (type: int), reverse(value) (type: string), _c2 (type: string),
ROW__ID (type: struct<transactionid:bigint,bucketid:int,rowid:bigint>)
                 outputColumnNames: _col0, _col1, _col2, _col3
                 Statistics: Num rows: 83 Data size: 1130 Basic stats: COMPLETE Column stats:
NONE
                 File Output Operator
@@ -84,7 +84,7 @@ STAGE PLANS:
               predicate: (((key % 2) = 0) and (key < 10)) (type: boolean)
               Statistics: Num rows: 83 Data size: 1130 Basic stats: COMPLETE Column stats:
NONE
               Select Operator
-                expressions: key (type: int), reverse(value) (type: string), c2 (type: string)
+                expressions: key (type: int), reverse(value) (type: string), _c2 (type: string)
                 outputColumnNames: _col0, _col1, _col2
                 Statistics: Num rows: 83 Data size: 1130 Basic stats: COMPLETE Column stats:
NONE
                 File Output Operator
@@ -134,7 +134,7 @@ STAGE PLANS:
               predicate: (((key % 2) = 0) and (key < 10)) (type: boolean)
               Statistics: Num rows: 83 Data size: 1130 Basic stats: COMPLETE Column stats:
NONE
               Select Operator
-                expressions: INPUT__FILE__NAME (type: string), key (type: int), reverse(value)
(type: string), c2 (type: string), ROW__ID (type: struct<transactionid:bigint,bucketid:int,rowid:bigint>)
+                expressions: INPUT__FILE__NAME (type: string), key (type: int), reverse(value)
(type: string), _c2 (type: string), ROW__ID (type: struct<transactionid:bigint,bucketid:int,rowid:bigint>)
                 outputColumnNames: _col0, _col1, _col2, _col3, _col4
                 Statistics: Num rows: 83 Data size: 1130 Basic stats: COMPLETE Column stats:
NONE
                 File Output Operator
@@ -181,16 +181,16 @@ POSTHOOK: type: CREATETABLE_AS_SELECT
 POSTHOOK: Input: default@src
 POSTHOOK: Output: database:default
 POSTHOOK: Output: default@masking_test
-POSTHOOK: Lineage: masking_test.c1 SIMPLE []
-POSTHOOK: Lineage: masking_test.c10 SIMPLE []
-POSTHOOK: Lineage: masking_test.c2 SIMPLE []
-POSTHOOK: Lineage: masking_test.c3 SIMPLE []
-POSTHOOK: Lineage: masking_test.c4 SIMPLE []
-POSTHOOK: Lineage: masking_test.c5 SIMPLE []
-POSTHOOK: Lineage: masking_test.c6 SIMPLE []
-POSTHOOK: Lineage: masking_test.c7 SIMPLE []
-POSTHOOK: Lineage: masking_test.c8 SIMPLE []
-POSTHOOK: Lineage: masking_test.c9 SIMPLE []
+POSTHOOK: Lineage: masking_test._c1 SIMPLE []
+POSTHOOK: Lineage: masking_test._c10 SIMPLE []
+POSTHOOK: Lineage: masking_test._c2 SIMPLE []
+POSTHOOK: Lineage: masking_test._c3 SIMPLE []
+POSTHOOK: Lineage: masking_test._c4 SIMPLE []
+POSTHOOK: Lineage: masking_test._c5 SIMPLE []
+POSTHOOK: Lineage: masking_test._c6 SIMPLE []
+POSTHOOK: Lineage: masking_test._c7 SIMPLE []
+POSTHOOK: Lineage: masking_test._c8 SIMPLE []
+POSTHOOK: Lineage: masking_test._c9 SIMPLE []
 POSTHOOK: Lineage: masking_test.key EXPRESSION [(src)src.FieldSchema(name:key, type:string,
comment:default), ]
 PREHOOK: query: explain select ROW__ID, * from masking_test
 PREHOOK: type: QUERY
@@ -211,7 +211,7 @@ STAGE PLANS:
               predicate: (((key % 2) = 0) and (key < 10)) (type: boolean)
               Statistics: Num rows: 83 Data size: 2889 Basic stats: COMPLETE Column stats:
NONE
               Select Operator
-                expressions: ROW__ID (type: struct<transactionid:bigint,bucketid:int,rowid:bigint>),
key (type: int), c1 (type: string), c2 (type: string), c3 (type: string), c4 (type: string),
c5 (type: string), c6 (type: string), c7 (type: string), c8 (type: string), c9 (type: string),
c10 (type: string)
+                expressions: ROW__ID (type: struct<transactionid:bigint,bucketid:int,rowid:bigint>),
key (type: int), _c1 (type: string), _c2 (type: string), _c3 (type: string), _c4 (type: string),
_c5 (type: string), _c6 (type: string), _c7 (type: string), _c8 (type: string), _c9 (type:
string), _c10 (type: string)
                 outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7,
_col8, _col9, _col10, _col11
                 Statistics: Num rows: 83 Data size: 2889 Basic stats: COMPLETE Column stats:
NONE
                 File Output Operator
@@ -264,16 +264,16 @@ POSTHOOK: type: CREATETABLE_AS_SELECT
 POSTHOOK: Input: default@src
 POSTHOOK: Output: database:default
 POSTHOOK: Output: default@masking_test
-POSTHOOK: Lineage: masking_test.c1 SIMPLE []
-POSTHOOK: Lineage: masking_test.c10 SIMPLE []
-POSTHOOK: Lineage: masking_test.c11 SIMPLE []
-POSTHOOK: Lineage: masking_test.c2 SIMPLE []
-POSTHOOK: Lineage: masking_test.c3 SIMPLE []
-POSTHOOK: Lineage: masking_test.c4 SIMPLE []
-POSTHOOK: Lineage: masking_test.c5 SIMPLE []
-POSTHOOK: Lineage: masking_test.c7 SIMPLE []
-POSTHOOK: Lineage: masking_test.c8 SIMPLE []
-POSTHOOK: Lineage: masking_test.c9 SIMPLE []
+POSTHOOK: Lineage: masking_test._c1 SIMPLE []
+POSTHOOK: Lineage: masking_test._c10 SIMPLE []
+POSTHOOK: Lineage: masking_test._c11 SIMPLE []
+POSTHOOK: Lineage: masking_test._c2 SIMPLE []
+POSTHOOK: Lineage: masking_test._c3 SIMPLE []
+POSTHOOK: Lineage: masking_test._c4 SIMPLE []
+POSTHOOK: Lineage: masking_test._c5 SIMPLE []
+POSTHOOK: Lineage: masking_test._c7 SIMPLE []
+POSTHOOK: Lineage: masking_test._c8 SIMPLE []
+POSTHOOK: Lineage: masking_test._c9 SIMPLE []
 POSTHOOK: Lineage: masking_test.input__file__name SIMPLE [(src)src.FieldSchema(name:INPUT__FILE__NAME,
type:string, comment:), ]
 POSTHOOK: Lineage: masking_test.key EXPRESSION [(src)src.FieldSchema(name:key, type:string,
comment:default), ]
 PREHOOK: query: select INPUT__FILE__NAME, *, ROW__ID from masking_test

http://git-wip-us.apache.org/repos/asf/hive/blob/56678869/ql/src/test/results/clientpositive/materialized_view_create.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/materialized_view_create.q.out b/ql/src/test/results/clientpositive/materialized_view_create.q.out
index 818a820..fc88dbc 100644
--- a/ql/src/test/results/clientpositive/materialized_view_create.q.out
+++ b/ql/src/test/results/clientpositive/materialized_view_create.q.out
@@ -111,7 +111,7 @@ POSTHOOK: query: describe extended cmv_mat_view4
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@cmv_mat_view4
 a                   	int                 	                    
-c1                  	decimal(20,2)       	                    
+_c1                 	decimal(20,2)       	                    
 	 	 
 #### A masked pattern was here ####
 PREHOOK: query: create table cmv_basetable2 (d int, e varchar(256), f decimal(10,2))

http://git-wip-us.apache.org/repos/asf/hive/blob/56678869/ql/src/test/results/clientpositive/parquet_ctas.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/parquet_ctas.q.out b/ql/src/test/results/clientpositive/parquet_ctas.q.out
index c9a9c13..6eb5292 100644
--- a/ql/src/test/results/clientpositive/parquet_ctas.q.out
+++ b/ql/src/test/results/clientpositive/parquet_ctas.q.out
@@ -84,16 +84,16 @@ POSTHOOK: type: CREATETABLE_AS_SELECT
 POSTHOOK: Input: default@staging
 POSTHOOK: Output: database:default
 POSTHOOK: Output: default@parquet_ctas_advanced
-POSTHOOK: Lineage: parquet_ctas_advanced.c0 EXPRESSION [(staging)staging.FieldSchema(name:key,
type:int, comment:null), ]
-POSTHOOK: Lineage: parquet_ctas_advanced.c1 EXPRESSION [(staging)staging.FieldSchema(name:value,
type:string, comment:null), ]
+POSTHOOK: Lineage: parquet_ctas_advanced._c0 EXPRESSION [(staging)staging.FieldSchema(name:key,
type:int, comment:null), ]
+POSTHOOK: Lineage: parquet_ctas_advanced._c1 EXPRESSION [(staging)staging.FieldSchema(name:value,
type:string, comment:null), ]
 PREHOOK: query: describe parquet_ctas_advanced
 PREHOOK: type: DESCTABLE
 PREHOOK: Input: default@parquet_ctas_advanced
 POSTHOOK: query: describe parquet_ctas_advanced
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@parquet_ctas_advanced
-c0                  	int                 	                    
-c1                  	string              	                    
+_c0                 	int                 	                    
+_c1                 	string              	                    
 PREHOOK: query: select * from parquet_ctas_advanced
 PREHOOK: type: QUERY
 PREHOOK: Input: default@parquet_ctas_advanced
@@ -160,7 +160,7 @@ POSTHOOK: type: CREATETABLE_AS_SELECT
 POSTHOOK: Input: default@staging
 POSTHOOK: Output: database:default
 POSTHOOK: Output: default@parquet_ctas_mixed
-POSTHOOK: Lineage: parquet_ctas_mixed.c1 EXPRESSION [(staging)staging.FieldSchema(name:key,
type:int, comment:null), ]
+POSTHOOK: Lineage: parquet_ctas_mixed._c1 EXPRESSION [(staging)staging.FieldSchema(name:key,
type:int, comment:null), ]
 POSTHOOK: Lineage: parquet_ctas_mixed.key SIMPLE [(staging)staging.FieldSchema(name:key,
type:int, comment:null), ]
 POSTHOOK: Lineage: parquet_ctas_mixed.myvalue EXPRESSION [(staging)staging.FieldSchema(name:value,
type:string, comment:null), ]
 PREHOOK: query: describe parquet_ctas_mixed
@@ -170,7 +170,7 @@ POSTHOOK: query: describe parquet_ctas_mixed
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@parquet_ctas_mixed
 key                 	int                 	                    
-c1                  	int                 	                    
+_c1                 	int                 	                    
 myvalue             	string              	                    
 PREHOOK: query: select * from parquet_ctas_mixed
 PREHOOK: type: QUERY

http://git-wip-us.apache.org/repos/asf/hive/blob/56678869/ql/src/test/results/clientpositive/parquet_join.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/parquet_join.q.out b/ql/src/test/results/clientpositive/parquet_join.q.out
index 86fb64a..e6cc18a 100644
--- a/ql/src/test/results/clientpositive/parquet_join.q.out
+++ b/ql/src/test/results/clientpositive/parquet_join.q.out
@@ -58,7 +58,7 @@ POSTHOOK: type: CREATETABLE_AS_SELECT
 POSTHOOK: Input: default@staging
 POSTHOOK: Output: database:default
 POSTHOOK: Output: default@parquet_jointable2
-POSTHOOK: Lineage: parquet_jointable2.c1 EXPRESSION [(staging)staging.FieldSchema(name:key,
type:int, comment:null), ]
+POSTHOOK: Lineage: parquet_jointable2._c1 EXPRESSION [(staging)staging.FieldSchema(name:key,
type:int, comment:null), ]
 POSTHOOK: Lineage: parquet_jointable2.key SIMPLE [(staging)staging.FieldSchema(name:key,
type:int, comment:null), ]
 POSTHOOK: Lineage: parquet_jointable2.myvalue EXPRESSION [(staging)staging.FieldSchema(name:value,
type:string, comment:null), ]
 PREHOOK: query: -- SORT_QUERY_RESULTS

http://git-wip-us.apache.org/repos/asf/hive/blob/56678869/ql/src/test/results/clientpositive/print_header.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/print_header.q.out b/ql/src/test/results/clientpositive/print_header.q.out
index f01d1d3..48d7455 100644
--- a/ql/src/test/results/clientpositive/print_header.q.out
+++ b/ql/src/test/results/clientpositive/print_header.q.out
@@ -38,7 +38,7 @@ POSTHOOK: query: SELECT src.key, sum(substr(src.value,5)) FROM src GROUP
BY src.
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@src
 #### A masked pattern was here ####
-src.key	c1
+src.key	_c1
 0	0.0
 10	10.0
 100	200.0

http://git-wip-us.apache.org/repos/asf/hive/blob/56678869/ql/src/test/results/clientpositive/spark/parquet_join.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/parquet_join.q.out b/ql/src/test/results/clientpositive/spark/parquet_join.q.out
index a8d98e8..1861219 100644
--- a/ql/src/test/results/clientpositive/spark/parquet_join.q.out
+++ b/ql/src/test/results/clientpositive/spark/parquet_join.q.out
@@ -58,7 +58,7 @@ POSTHOOK: type: CREATETABLE_AS_SELECT
 POSTHOOK: Input: default@staging
 POSTHOOK: Output: database:default
 POSTHOOK: Output: default@parquet_jointable2
-POSTHOOK: Lineage: parquet_jointable2.c1 EXPRESSION [(staging)staging.FieldSchema(name:key,
type:int, comment:null), ]
+POSTHOOK: Lineage: parquet_jointable2._c1 EXPRESSION [(staging)staging.FieldSchema(name:key,
type:int, comment:null), ]
 POSTHOOK: Lineage: parquet_jointable2.key SIMPLE [(staging)staging.FieldSchema(name:key,
type:int, comment:null), ]
 POSTHOOK: Lineage: parquet_jointable2.myvalue EXPRESSION [(staging)staging.FieldSchema(name:value,
type:string, comment:null), ]
 PREHOOK: query: -- SORT_QUERY_RESULTS

http://git-wip-us.apache.org/repos/asf/hive/blob/56678869/ql/src/test/results/clientpositive/spark/vectorization_0.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/vectorization_0.q.out b/ql/src/test/results/clientpositive/spark/vectorization_0.q.out
index e5f5359..b589ac8 100644
--- a/ql/src/test/results/clientpositive/spark/vectorization_0.q.out
+++ b/ql/src/test/results/clientpositive/spark/vectorization_0.q.out
@@ -30162,7 +30162,7 @@ POSTHOOK: type: CREATETABLE_AS_SELECT
 POSTHOOK: Input: default@srcbucket
 POSTHOOK: Output: database:default
 POSTHOOK: Output: default@cast_string_to_int_1
-POSTHOOK: Lineage: cast_string_to_int_1.c0 EXPRESSION [(srcbucket)srcbucket.FieldSchema(name:key,
type:int, comment:null), ]
+POSTHOOK: Lineage: cast_string_to_int_1._c0 EXPRESSION [(srcbucket)srcbucket.FieldSchema(name:key,
type:int, comment:null), ]
 POSTHOOK: Lineage: cast_string_to_int_1.value SIMPLE [(srcbucket)srcbucket.FieldSchema(name:value,
type:string, comment:null), ]
 PREHOOK: query: create table cast_string_to_int_2(i int,s string)
 PREHOOK: type: CREATETABLE
@@ -30180,7 +30180,7 @@ POSTHOOK: query: insert overwrite table cast_string_to_int_2 select
* from cast_
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@cast_string_to_int_1
 POSTHOOK: Output: default@cast_string_to_int_2
-POSTHOOK: Lineage: cast_string_to_int_2.i EXPRESSION [(cast_string_to_int_1)cast_string_to_int_1.FieldSchema(name:c0,
type:string, comment:null), ]
+POSTHOOK: Lineage: cast_string_to_int_2.i EXPRESSION [(cast_string_to_int_1)cast_string_to_int_1.FieldSchema(name:_c0,
type:string, comment:null), ]
 POSTHOOK: Lineage: cast_string_to_int_2.s SIMPLE [(cast_string_to_int_1)cast_string_to_int_1.FieldSchema(name:value,
type:string, comment:null), ]
 PREHOOK: query: --moving ALL_1 system test here
 select all key from src

http://git-wip-us.apache.org/repos/asf/hive/blob/56678869/ql/src/test/results/clientpositive/vector_complex_all.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/vector_complex_all.q.out b/ql/src/test/results/clientpositive/vector_complex_all.q.out
index 69d5576..e6f0307 100644
--- a/ql/src/test/results/clientpositive/vector_complex_all.q.out
+++ b/ql/src/test/results/clientpositive/vector_complex_all.q.out
@@ -65,7 +65,7 @@ POSTHOOK: Lineage: orc_create_complex.mp SIMPLE [(orc_create_staging)orc_create_
 POSTHOOK: Lineage: orc_create_complex.str SIMPLE [(orc_create_staging)orc_create_staging.FieldSchema(name:str,
type:string, comment:null), ]
 POSTHOOK: Lineage: orc_create_complex.strct SIMPLE [(orc_create_staging)orc_create_staging.FieldSchema(name:strct,
type:struct<A:string,B:string>, comment:null), ]
 POSTHOOK: Lineage: orc_create_complex.val SIMPLE []
-orc_create_staging.str	orc_create_staging.mp	orc_create_staging.lst	orc_create_staging.strct
c1
+orc_create_staging.str	orc_create_staging.mp	orc_create_staging.lst	orc_create_staging.strct
_c1
 PREHOOK: query: SELECT * FROM orc_create_complex
 PREHOOK: type: QUERY
 PREHOOK: Input: default@orc_create_complex
@@ -177,7 +177,7 @@ POSTHOOK: query: select count(*) from orc_create_complex
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@orc_create_complex
 #### A masked pattern was here ####
-c0
+_c0
 13503
 PREHOOK: query: SELECT distinct lst, strct FROM orc_create_complex
 PREHOOK: type: QUERY
@@ -199,7 +199,7 @@ POSTHOOK: query: SELECT str, count(val)  FROM orc_create_complex GROUP
BY str
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@orc_create_complex
 #### A masked pattern was here ####
-str	c1
+str	_c1
 line1	4501
 line2	4501
 line3	4501
@@ -211,7 +211,7 @@ POSTHOOK: query: SELECT strct.B, count(val) FROM orc_create_complex GROUP
BY str
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@orc_create_complex
 #### A masked pattern was here ####
-strct.b	c1
+strct.b	_c1
 four	4501
 six	4501
 two	4501
@@ -223,7 +223,7 @@ POSTHOOK: query: SELECT strct, mp, lst, str, count(val) FROM orc_create_complex
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@orc_create_complex
 #### A masked pattern was here ####
-strct	mp	lst	str	c4
+strct	mp	lst	str	_c4
 {"a":"one","b":"two"}	{"key11":"value11","key12":"value12","key13":"value13"}	["a","b","c"]
line1	4501
 {"a":"three","b":"four"}	{"key21":"value21","key22":"value22","key23":"value23"}	["d","e","f"]
line2	4501
 {"a":"five","b":"six"}	{"key31":"value31","key32":"value32","key33":"value33"}	["g","h","i"]
line3	4501

http://git-wip-us.apache.org/repos/asf/hive/blob/56678869/ql/src/test/results/clientpositive/vector_complex_join.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/vector_complex_join.q.out b/ql/src/test/results/clientpositive/vector_complex_join.q.out
index 8fc609f..2d32039 100644
--- a/ql/src/test/results/clientpositive/vector_complex_join.q.out
+++ b/ql/src/test/results/clientpositive/vector_complex_join.q.out
@@ -20,7 +20,7 @@ POSTHOOK: Input: default@src
 POSTHOOK: Output: default@test
 POSTHOOK: Lineage: test.a SIMPLE []
 POSTHOOK: Lineage: test.b EXPRESSION []
-c0	c1
+_c0	_c1
 PREHOOK: query: explain
 select * from alltypesorc join test where alltypesorc.cint=test.a
 PREHOOK: type: QUERY
@@ -123,7 +123,7 @@ POSTHOOK: type: QUERY
 POSTHOOK: Input: default@src
 POSTHOOK: Output: default@test2a
 POSTHOOK: Lineage: test2a.a EXPRESSION []
-c0
+_c0
 PREHOOK: query: CREATE TABLE test2b (a INT) STORED AS ORC
 PREHOOK: type: CREATETABLE
 PREHOOK: Output: database:default

http://git-wip-us.apache.org/repos/asf/hive/blob/56678869/ql/src/test/results/clientpositive/vector_interval_arithmetic.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/vector_interval_arithmetic.q.out b/ql/src/test/results/clientpositive/vector_interval_arithmetic.q.out
index da1ebc9..84d84d0 100644
--- a/ql/src/test/results/clientpositive/vector_interval_arithmetic.q.out
+++ b/ql/src/test/results/clientpositive/vector_interval_arithmetic.q.out
@@ -128,7 +128,7 @@ order by dateval
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@interval_arithmetic_1
 #### A masked pattern was here ####
-dateval	c1	c2	c3	c4	c5	c6
+dateval	_c1	_c2	_c3	_c4	_c5	_c6
 0004-09-22	0002-07-22	0006-11-22	0006-11-22	0002-07-22	0002-07-22	0006-11-22
 0528-10-27	0526-08-27	0530-12-27	0530-12-27	0526-08-27	0526-08-27	0530-12-27
 1319-02-02	1316-12-02	1321-04-02	1321-04-02	1316-12-02	1316-12-02	1321-04-02
@@ -258,7 +258,7 @@ order by dateval
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@interval_arithmetic_1
 #### A masked pattern was here ####
-dateval	c1	c2	c3
+dateval	_c1	_c2	_c3
 0004-09-22	-728552 23:00:00.000000000	728552 23:00:00.000000000	0 00:00:00.000000000
 0528-10-27	-537126 23:00:00.000000000	537126 23:00:00.000000000	0 00:00:00.000000000
 1319-02-02	-248481 23:00:00.000000000	248481 23:00:00.000000000	0 00:00:00.000000000
@@ -400,7 +400,7 @@ order by tsval
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@interval_arithmetic_1
 #### A masked pattern was here ####
-tsval	c1	c2	c3	c4	c5	c6
+tsval	_c1	_c2	_c3	_c4	_c5	_c6
 0004-09-22 18:26:29.519542222	0002-07-22 18:26:29.519542222	0006-11-22 18:26:29.519542222
0006-11-22 18:26:29.519542222	0002-07-22 18:26:29.519542222	0002-07-22 18:26:29.519542222
0006-11-22 18:26:29.519542222
 0528-10-27 08:15:18.941718273	0526-08-27 08:15:18.941718273	0530-12-27 08:15:18.941718273
0530-12-27 08:15:18.941718273	0526-08-27 08:15:18.941718273	0526-08-27 08:15:18.941718273
0530-12-27 08:15:18.941718273
 1319-02-02 16:31:57.778	1316-12-02 16:31:57.778	1321-04-02 16:31:57.778	1321-04-02 16:31:57.778
1316-12-02 16:31:57.778	1316-12-02 16:31:57.778	1321-04-02 16:31:57.778
@@ -527,7 +527,7 @@ limit 2
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@interval_arithmetic_1
 #### A masked pattern was here ####
-c0	c1
+_c0	_c1
 5-5	-1-1
 5-5	-1-1
 PREHOOK: query: -- interval day-time arithmetic
@@ -623,7 +623,7 @@ order by dateval
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@interval_arithmetic_1
 #### A masked pattern was here ####
-dateval	c1	c2	c3	c4	c5	c6
+dateval	_c1	_c2	_c3	_c4	_c5	_c6
 0004-09-22	0004-06-14 12:37:26.876543211	0004-12-30 11:22:33.123456789	0004-12-30 11:22:33.123456789
0004-06-14 12:37:26.876543211	0004-06-14 12:37:26.876543211	0004-12-30 11:22:33.123456789
 0528-10-27	0528-07-19 12:37:26.876543211	0529-02-03 11:22:33.123456789	0529-02-03 11:22:33.123456789
0528-07-19 12:37:26.876543211	0528-07-19 12:37:26.876543211	0529-02-03 11:22:33.123456789
 1319-02-02	1318-10-25 12:37:26.876543211	1319-05-12 11:22:33.123456789	1319-05-12 11:22:33.123456789
1318-10-25 12:37:26.876543211	1318-10-25 12:37:26.876543211	1319-05-12 11:22:33.123456789
@@ -757,7 +757,7 @@ order by dateval
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@interval_arithmetic_1
 #### A masked pattern was here ####
-dateval	tsval	c2	c3	c4
+dateval	tsval	_c2	_c3	_c4
 0004-09-22	0004-09-22 18:26:29.519542222	-0 18:26:30.519542222	0 18:26:30.519542222	0 00:00:00.000000000
 0528-10-27	0528-10-27 08:15:18.941718273	-0 08:15:19.941718273	0 08:15:19.941718273	0 00:00:00.000000000
 1319-02-02	1319-02-02 16:31:57.778	-0 16:31:58.778000000	0 16:31:58.778000000	0 00:00:00.000000000
@@ -899,7 +899,7 @@ order by tsval
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@interval_arithmetic_1
 #### A masked pattern was here ####
-tsval	c1	c2	c3	c4	c5	c6
+tsval	_c1	_c2	_c3	_c4	_c5	_c6
 0004-09-22 18:26:29.519542222	0004-06-15 07:03:56.396085433	0004-12-31 05:49:02.642999011
0004-12-31 05:49:02.642999011	0004-06-15 07:03:56.396085433	0004-06-15 07:03:56.396085433
0004-12-31 05:49:02.642999011
 0528-10-27 08:15:18.941718273	0528-07-19 20:52:45.818261484	0529-02-03 19:37:52.065175062
0529-02-03 19:37:52.065175062	0528-07-19 20:52:45.818261484	0528-07-19 20:52:45.818261484
0529-02-03 19:37:52.065175062
 1319-02-02 16:31:57.778	1318-10-26 05:09:24.654543211	1319-05-13 03:54:30.901456789	1319-05-13
03:54:30.901456789	1318-10-26 05:09:24.654543211	1318-10-26 05:09:24.654543211	1319-05-13
03:54:30.901456789
@@ -1014,7 +1014,7 @@ limit 2
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@interval_arithmetic_1
 #### A masked pattern was here ####
-c0	c1
+_c0	_c1
 109 20:30:40.246913578	89 02:14:26.000000000
 109 20:30:40.246913578	89 02:14:26.000000000
 PREHOOK: query: drop table interval_arithmetic_1

http://git-wip-us.apache.org/repos/asf/hive/blob/56678869/ql/src/test/results/clientpositive/vector_tablesample_rows.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/vector_tablesample_rows.q.out b/ql/src/test/results/clientpositive/vector_tablesample_rows.q.out
index 7e5f24d..649f0e3 100644
--- a/ql/src/test/results/clientpositive/vector_tablesample_rows.q.out
+++ b/ql/src/test/results/clientpositive/vector_tablesample_rows.q.out
@@ -157,7 +157,7 @@ POSTHOOK: query: select count(*) from decimal_2
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@decimal_2
 #### A masked pattern was here ####
-c0
+_c0
 1
 PREHOOK: query: drop table decimal_2
 PREHOOK: type: DROPTABLE

http://git-wip-us.apache.org/repos/asf/hive/blob/56678869/ql/src/test/results/clientpositive/vectorized_date_funcs.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/vectorized_date_funcs.q.out b/ql/src/test/results/clientpositive/vectorized_date_funcs.q.out
index 18a4f2f..f062093 100644
--- a/ql/src/test/results/clientpositive/vectorized_date_funcs.q.out
+++ b/ql/src/test/results/clientpositive/vectorized_date_funcs.q.out
@@ -58,7 +58,7 @@ POSTHOOK: Input: default@date_udf_flight
 POSTHOOK: Output: default@date_udf_flight_orc
 POSTHOOK: Lineage: date_udf_flight_orc.fl_date SIMPLE [(date_udf_flight)date_udf_flight.FieldSchema(name:fl_date,
type:date, comment:null), ]
 POSTHOOK: Lineage: date_udf_flight_orc.fl_time EXPRESSION [(date_udf_flight)date_udf_flight.FieldSchema(name:fl_date,
type:date, comment:null), ]
-fl_date	c1
+fl_date	_c1
 PREHOOK: query: SELECT * FROM date_udf_flight_orc
 PREHOOK: type: QUERY
 PREHOOK: Input: default@date_udf_flight_orc
@@ -332,7 +332,7 @@ FROM date_udf_flight_orc
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@date_udf_flight_orc
 #### A masked pattern was here ####
-fl_time	c1	c2	c3	c4	c5	c6	c7	c8	c9	c10	c11	c12	c13	c14	c15	c16	c17	c18	c19
+fl_time	_c1	_c2	_c3	_c4	_c5	_c6	_c7	_c8	_c9	_c10	_c11	_c12	_c13	_c14	_c15	_c16	_c17	_c18
_c19
 2010-10-20 07:00:00	1287583200	2010	10	20	20	4	42	2010-10-20	2010-10-20	2010-10-22	2010-10-18
3945	3945	3945	3945	1316	1316	1316	1316
 2010-10-20 07:00:00	1287583200	2010	10	20	20	4	42	2010-10-20	2010-10-20	2010-10-22	2010-10-18
3945	3945	3945	3945	1316	1316	1316	1316
 2010-10-20 07:00:00	1287583200	2010	10	20	20	4	42	2010-10-20	2010-10-20	2010-10-22	2010-10-18
3945	3945	3945	3945	1316	1316	1316	1316
@@ -597,7 +597,7 @@ FROM date_udf_flight_orc
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@date_udf_flight_orc
 #### A masked pattern was here ####
-fl_date	c1	c2	c3	c4	c5	c6	c7	c8	c9	c10	c11	c12	c13	c14	c15	c16	c17	c18	c19
+fl_date	_c1	_c2	_c3	_c4	_c5	_c6	_c7	_c8	_c9	_c10	_c11	_c12	_c13	_c14	_c15	_c16	_c17	_c18
_c19
 2010-10-20	1287558000	2010	10	20	20	4	42	2010-10-20	2010-10-20	2010-10-22	2010-10-18	3945
3945	3945	3945	1316	1316	1316	1316
 2010-10-20	1287558000	2010	10	20	20	4	42	2010-10-20	2010-10-20	2010-10-22	2010-10-18	3945
3945	3945	3945	1316	1316	1316	1316
 2010-10-20	1287558000	2010	10	20	20	4	42	2010-10-20	2010-10-20	2010-10-22	2010-10-18	3945
3945	3945	3945	1316	1316	1316	1316
@@ -872,7 +872,7 @@ FROM date_udf_flight_orc
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@date_udf_flight_orc
 #### A masked pattern was here ####
-fl_time	fl_date	c2	c3	c4	c5	c6	c7	c8	c9	c10	c11	c12	c13	c14	c15	c16	c17	c18	c19	c20	c21
+fl_time	fl_date	_c2	_c3	_c4	_c5	_c6	_c7	_c8	_c9	_c10	_c11	_c12	_c13	_c14	_c15	_c16	_c17	_c18
_c19	_c20	_c21
 2010-10-20 07:00:00	2010-10-20	true	true	true	true	true	true	true	true	true	true	true	true
true	true	true	true	true	true	true	true
 2010-10-20 07:00:00	2010-10-20	true	true	true	true	true	true	true	true	true	true	true	true
true	true	true	true	true	true	true	true
 2010-10-20 07:00:00	2010-10-20	true	true	true	true	true	true	true	true	true	true	true	true
true	true	true	true	true	true	true	true
@@ -1084,7 +1084,7 @@ FROM date_udf_flight_orc LIMIT 10
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@date_udf_flight_orc
 #### A masked pattern was here ####
-fl_date	c1	c2	c3	c4	c5
+fl_date	_c1	_c2	_c3	_c4	_c5
 2010-10-20	2010-10-22	2010-10-18	-2	2	4
 2010-10-20	2010-10-22	2010-10-18	-2	2	4
 2010-10-20	2010-10-22	2010-10-18	-2	2	4
@@ -1105,7 +1105,7 @@ SELECT to_date('2009-07-30 04:17:52') FROM date_udf_flight_orc LIMIT
1
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@date_udf_flight_orc
 #### A masked pattern was here ####
-c0
+_c0
 2009-07-30
 PREHOOK: query: EXPLAIN SELECT
   min(fl_date) AS c1,
@@ -1211,5 +1211,5 @@ ORDER BY c1
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@date_udf_flight_orc
 #### A masked pattern was here ####
-c1	c1_1	c2	c3
+c1	_c1	_c2	_c3
 2010-10-20	2010-10-31	137	137


Mime
View raw message