You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by px...@apache.org on 2016/05/09 17:41:44 UTC
[02/21] hive git commit: HIVE-13341: Stats state is not captured
correctly: differentiate load table and create table (Pengcheng Xiong,
reviewed by Ashutosh Chauhan)
http://git-wip-us.apache.org/repos/asf/hive/blob/244ce09c/ql/src/test/results/clientpositive/tez/schema_evol_text_nonvec_mapwork_table.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/tez/schema_evol_text_nonvec_mapwork_table.q.out b/ql/src/test/results/clientpositive/tez/schema_evol_text_nonvec_mapwork_table.q.out
index 14abca9..f8f413c 100644
--- a/ql/src/test/results/clientpositive/tez/schema_evol_text_nonvec_mapwork_table.q.out
+++ b/ql/src/test/results/clientpositive/tez/schema_evol_text_nonvec_mapwork_table.q.out
@@ -48,6 +48,11 @@ Retention: 0
#### A masked pattern was here ####
Table Type: MANAGED_TABLE
Table Parameters:
+ COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"}
+ numFiles 0
+ numRows 0
+ rawDataSize 0
+ totalSize 0
#### A masked pattern was here ####
# Storage Information
@@ -184,13 +189,13 @@ Stage-0
Stage-1
Reducer 2
File Output Operator [FS_4]
- Select Operator [SEL_3] (rows=10 width=11)
+ Select Operator [SEL_3] (rows=4 width=12)
Output:["_col0","_col1","_col2"]
<-Map 1 [SIMPLE_EDGE]
SHUFFLE [RS_2]
- Select Operator [SEL_1] (rows=10 width=11)
+ Select Operator [SEL_1] (rows=4 width=12)
Output:["_col0","_col1","_col2"]
- TableScan [TS_0] (rows=10 width=11)
+ TableScan [TS_0] (rows=4 width=12)
default@table_add_int_permute_select,table_add_int_permute_select,Tbl:COMPLETE,Col:NONE,Output:["insert_num","a","b"]
PREHOOK: query: -- SELECT permutation columns to make sure NULL defaulting works right
@@ -294,6 +299,11 @@ Retention: 0
#### A masked pattern was here ####
Table Type: MANAGED_TABLE
Table Parameters:
+ COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"}
+ numFiles 0
+ numRows 0
+ rawDataSize 0
+ totalSize 0
#### A masked pattern was here ####
# Storage Information
@@ -433,13 +443,13 @@ Stage-0
Stage-1
Reducer 2
File Output Operator [FS_4]
- Select Operator [SEL_3] (rows=10 width=15)
+ Select Operator [SEL_3] (rows=4 width=12)
Output:["_col0","_col1","_col2"]
<-Map 1 [SIMPLE_EDGE]
SHUFFLE [RS_2]
- Select Operator [SEL_1] (rows=10 width=15)
+ Select Operator [SEL_1] (rows=4 width=12)
Output:["_col0","_col1","_col2"]
- TableScan [TS_0] (rows=10 width=15)
+ TableScan [TS_0] (rows=4 width=12)
default@table_add_int_string_permute_select,table_add_int_string_permute_select,Tbl:COMPLETE,Col:NONE,Output:["insert_num","a","b"]
PREHOOK: query: -- SELECT permutation columns to make sure NULL defaulting works right
@@ -697,13 +707,13 @@ Stage-0
Stage-1
Reducer 2
File Output Operator [FS_4]
- Select Operator [SEL_3] (rows=10 width=55)
+ Select Operator [SEL_3] (rows=4 width=79)
Output:["_col0","_col1","_col2","_col3","_col4"]
<-Map 1 [SIMPLE_EDGE]
SHUFFLE [RS_2]
- Select Operator [SEL_1] (rows=10 width=55)
+ Select Operator [SEL_1] (rows=4 width=79)
Output:["_col0","_col1","_col2","_col3","_col4"]
- TableScan [TS_0] (rows=10 width=55)
+ TableScan [TS_0] (rows=4 width=79)
default@table_change_string_group_double,table_change_string_group_double,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","b"]
PREHOOK: query: select insert_num,c1,c2,c3,b from table_change_string_group_double order by insert_num
@@ -849,13 +859,13 @@ Stage-0
Stage-1
Reducer 2
File Output Operator [FS_4]
- Select Operator [SEL_3] (rows=9 width=147)
+ Select Operator [SEL_3] (rows=3 width=150)
Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6"]
<-Map 1 [SIMPLE_EDGE]
SHUFFLE [RS_2]
- Select Operator [SEL_1] (rows=9 width=147)
+ Select Operator [SEL_1] (rows=3 width=150)
Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6"]
- TableScan [TS_0] (rows=9 width=147)
+ TableScan [TS_0] (rows=3 width=150)
default@table_change_date_group_string_group_timestamp,table_change_date_group_string_group_timestamp,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","c4","c5","b"]
PREHOOK: query: select insert_num,c1,c2,c3,c4,c5,b from table_change_date_group_string_group_timestamp order by insert_num
@@ -1017,13 +1027,13 @@ Stage-0
Stage-1
Reducer 2
File Output Operator [FS_4]
- Select Operator [SEL_3] (rows=9 width=91)
+ Select Operator [SEL_3] (rows=3 width=65)
Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6"]
<-Map 1 [SIMPLE_EDGE]
SHUFFLE [RS_2]
- Select Operator [SEL_1] (rows=9 width=91)
+ Select Operator [SEL_1] (rows=3 width=65)
Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6"]
- TableScan [TS_0] (rows=9 width=91)
+ TableScan [TS_0] (rows=3 width=65)
default@table_change_date_group_string_group_date,table_change_date_group_string_group_date,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","c4","c5","b"]
PREHOOK: query: select insert_num,c1,c2,c3,c4,c5,b from table_change_date_group_string_group_date order by insert_num
@@ -1165,13 +1175,13 @@ Stage-0
Stage-1
Reducer 2
File Output Operator [FS_4]
- Select Operator [SEL_3] (rows=10 width=33)
+ Select Operator [SEL_3] (rows=4 width=37)
Output:["_col0","_col1","_col2","_col3","_col4","_col5"]
<-Map 1 [SIMPLE_EDGE]
SHUFFLE [RS_2]
- Select Operator [SEL_1] (rows=10 width=33)
+ Select Operator [SEL_1] (rows=4 width=37)
Output:["_col0","_col1","_col2","_col3","_col4","_col5"]
- TableScan [TS_0] (rows=10 width=33)
+ TableScan [TS_0] (rows=4 width=37)
default@table_change_numeric_group_string_group_multi_ints_string,table_change_numeric_group_string_group_multi_ints_string,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","c4","b"]
PREHOOK: query: select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_string order by insert_num
@@ -1306,13 +1316,13 @@ Stage-0
Stage-1
Reducer 2
File Output Operator [FS_4]
- Select Operator [SEL_3] (rows=10 width=140)
+ Select Operator [SEL_3] (rows=4 width=37)
Output:["_col0","_col1","_col2","_col3","_col4","_col5"]
<-Map 1 [SIMPLE_EDGE]
SHUFFLE [RS_2]
- Select Operator [SEL_1] (rows=10 width=140)
+ Select Operator [SEL_1] (rows=4 width=37)
Output:["_col0","_col1","_col2","_col3","_col4","_col5"]
- TableScan [TS_0] (rows=10 width=140)
+ TableScan [TS_0] (rows=4 width=37)
default@table_change_numeric_group_string_group_multi_ints_char,table_change_numeric_group_string_group_multi_ints_char,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","c4","b"]
PREHOOK: query: select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_char order by insert_num
@@ -1447,13 +1457,13 @@ Stage-0
Stage-1
Reducer 2
File Output Operator [FS_4]
- Select Operator [SEL_3] (rows=10 width=32)
+ Select Operator [SEL_3] (rows=4 width=37)
Output:["_col0","_col1","_col2","_col3","_col4","_col5"]
<-Map 1 [SIMPLE_EDGE]
SHUFFLE [RS_2]
- Select Operator [SEL_1] (rows=10 width=32)
+ Select Operator [SEL_1] (rows=4 width=37)
Output:["_col0","_col1","_col2","_col3","_col4","_col5"]
- TableScan [TS_0] (rows=10 width=32)
+ TableScan [TS_0] (rows=4 width=37)
default@table_change_numeric_group_string_group_multi_ints_char_trunc,table_change_numeric_group_string_group_multi_ints_char_trunc,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","c4","b"]
PREHOOK: query: select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_char_trunc order by insert_num
@@ -1588,13 +1598,13 @@ Stage-0
Stage-1
Reducer 2
File Output Operator [FS_4]
- Select Operator [SEL_3] (rows=10 width=33)
+ Select Operator [SEL_3] (rows=4 width=37)
Output:["_col0","_col1","_col2","_col3","_col4","_col5"]
<-Map 1 [SIMPLE_EDGE]
SHUFFLE [RS_2]
- Select Operator [SEL_1] (rows=10 width=33)
+ Select Operator [SEL_1] (rows=4 width=37)
Output:["_col0","_col1","_col2","_col3","_col4","_col5"]
- TableScan [TS_0] (rows=10 width=33)
+ TableScan [TS_0] (rows=4 width=37)
default@table_change_numeric_group_string_group_multi_ints_varchar,table_change_numeric_group_string_group_multi_ints_varchar,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","c4","b"]
PREHOOK: query: select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_varchar order by insert_num
@@ -1729,13 +1739,13 @@ Stage-0
Stage-1
Reducer 2
File Output Operator [FS_4]
- Select Operator [SEL_3] (rows=10 width=30)
+ Select Operator [SEL_3] (rows=4 width=37)
Output:["_col0","_col1","_col2","_col3","_col4","_col5"]
<-Map 1 [SIMPLE_EDGE]
SHUFFLE [RS_2]
- Select Operator [SEL_1] (rows=10 width=30)
+ Select Operator [SEL_1] (rows=4 width=37)
Output:["_col0","_col1","_col2","_col3","_col4","_col5"]
- TableScan [TS_0] (rows=10 width=30)
+ TableScan [TS_0] (rows=4 width=37)
default@table_change_numeric_group_string_group_multi_ints_varchar_trunc,table_change_numeric_group_string_group_multi_ints_varchar_trunc,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","c4","b"]
PREHOOK: query: select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_varchar_trunc order by insert_num
@@ -1868,13 +1878,13 @@ Stage-0
Stage-1
Reducer 2
File Output Operator [FS_4]
- Select Operator [SEL_3] (rows=10 width=38)
+ Select Operator [SEL_3] (rows=4 width=53)
Output:["_col0","_col1","_col2","_col3","_col4"]
<-Map 1 [SIMPLE_EDGE]
SHUFFLE [RS_2]
- Select Operator [SEL_1] (rows=10 width=38)
+ Select Operator [SEL_1] (rows=4 width=53)
Output:["_col0","_col1","_col2","_col3","_col4"]
- TableScan [TS_0] (rows=10 width=38)
+ TableScan [TS_0] (rows=4 width=53)
default@table_change_numeric_group_string_group_floating_string,table_change_numeric_group_string_group_floating_string,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","b"]
PREHOOK: query: select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_string order by insert_num
@@ -2007,13 +2017,13 @@ Stage-0
Stage-1
Reducer 2
File Output Operator [FS_4]
- Select Operator [SEL_3] (rows=10 width=116)
+ Select Operator [SEL_3] (rows=4 width=55)
Output:["_col0","_col1","_col2","_col3","_col4"]
<-Map 1 [SIMPLE_EDGE]
SHUFFLE [RS_2]
- Select Operator [SEL_1] (rows=10 width=116)
+ Select Operator [SEL_1] (rows=4 width=55)
Output:["_col0","_col1","_col2","_col3","_col4"]
- TableScan [TS_0] (rows=10 width=116)
+ TableScan [TS_0] (rows=4 width=55)
default@table_change_numeric_group_string_group_floating_char,table_change_numeric_group_string_group_floating_char,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","b"]
PREHOOK: query: select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_char order by insert_num
@@ -2146,13 +2156,13 @@ Stage-0
Stage-1
Reducer 2
File Output Operator [FS_4]
- Select Operator [SEL_3] (rows=10 width=39)
+ Select Operator [SEL_3] (rows=4 width=53)
Output:["_col0","_col1","_col2","_col3","_col4"]
<-Map 1 [SIMPLE_EDGE]
SHUFFLE [RS_2]
- Select Operator [SEL_1] (rows=10 width=39)
+ Select Operator [SEL_1] (rows=4 width=53)
Output:["_col0","_col1","_col2","_col3","_col4"]
- TableScan [TS_0] (rows=10 width=39)
+ TableScan [TS_0] (rows=4 width=53)
default@table_change_numeric_group_string_group_floating_char_trunc,table_change_numeric_group_string_group_floating_char_trunc,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","b"]
PREHOOK: query: select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_char_trunc order by insert_num
@@ -2285,13 +2295,13 @@ Stage-0
Stage-1
Reducer 2
File Output Operator [FS_4]
- Select Operator [SEL_3] (rows=10 width=36)
+ Select Operator [SEL_3] (rows=4 width=50)
Output:["_col0","_col1","_col2","_col3","_col4"]
<-Map 1 [SIMPLE_EDGE]
SHUFFLE [RS_2]
- Select Operator [SEL_1] (rows=10 width=36)
+ Select Operator [SEL_1] (rows=4 width=50)
Output:["_col0","_col1","_col2","_col3","_col4"]
- TableScan [TS_0] (rows=10 width=36)
+ TableScan [TS_0] (rows=4 width=50)
default@table_change_numeric_group_string_group_floating_varchar,table_change_numeric_group_string_group_floating_varchar,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","b"]
PREHOOK: query: select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_varchar order by insert_num
@@ -2424,13 +2434,13 @@ Stage-0
Stage-1
Reducer 2
File Output Operator [FS_4]
- Select Operator [SEL_3] (rows=10 width=36)
+ Select Operator [SEL_3] (rows=4 width=55)
Output:["_col0","_col1","_col2","_col3","_col4"]
<-Map 1 [SIMPLE_EDGE]
SHUFFLE [RS_2]
- Select Operator [SEL_1] (rows=10 width=36)
+ Select Operator [SEL_1] (rows=4 width=55)
Output:["_col0","_col1","_col2","_col3","_col4"]
- TableScan [TS_0] (rows=10 width=36)
+ TableScan [TS_0] (rows=4 width=55)
default@table_change_numeric_group_string_group_floating_varchar_trunc,table_change_numeric_group_string_group_floating_varchar_trunc,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","b"]
PREHOOK: query: select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_varchar_trunc order by insert_num
@@ -2573,13 +2583,13 @@ Stage-0
Stage-1
Reducer 2
File Output Operator [FS_4]
- Select Operator [SEL_3] (rows=10 width=79)
+ Select Operator [SEL_3] (rows=4 width=59)
Output:["_col0","_col1","_col2","_col3","_col4","_col5"]
<-Map 1 [SIMPLE_EDGE]
SHUFFLE [RS_2]
- Select Operator [SEL_1] (rows=10 width=79)
+ Select Operator [SEL_1] (rows=4 width=59)
Output:["_col0","_col1","_col2","_col3","_col4","_col5"]
- TableScan [TS_0] (rows=10 width=79)
+ TableScan [TS_0] (rows=4 width=59)
default@table_change_string_group_string_group_string,table_change_string_group_string_group_string,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","c4","b"]
PREHOOK: query: select insert_num,c1,c2,c3,c4,b from table_change_string_group_string_group_string order by insert_num
@@ -2712,13 +2722,13 @@ Stage-0
Stage-1
Reducer 2
File Output Operator [FS_4]
- Select Operator [SEL_3] (rows=10 width=93)
+ Select Operator [SEL_3] (rows=4 width=163)
Output:["_col0","_col1","_col2","_col3","_col4"]
<-Map 1 [SIMPLE_EDGE]
SHUFFLE [RS_2]
- Select Operator [SEL_1] (rows=10 width=93)
+ Select Operator [SEL_1] (rows=4 width=163)
Output:["_col0","_col1","_col2","_col3","_col4"]
- TableScan [TS_0] (rows=10 width=93)
+ TableScan [TS_0] (rows=4 width=163)
default@table_change_string_group_string_group_char,table_change_string_group_string_group_char,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","b"]
PREHOOK: query: select insert_num,c1,c2,c3,b from table_change_string_group_string_group_char order by insert_num
@@ -2851,13 +2861,13 @@ Stage-0
Stage-1
Reducer 2
File Output Operator [FS_4]
- Select Operator [SEL_3] (rows=10 width=68)
+ Select Operator [SEL_3] (rows=4 width=46)
Output:["_col0","_col1","_col2","_col3","_col4"]
<-Map 1 [SIMPLE_EDGE]
SHUFFLE [RS_2]
- Select Operator [SEL_1] (rows=10 width=68)
+ Select Operator [SEL_1] (rows=4 width=46)
Output:["_col0","_col1","_col2","_col3","_col4"]
- TableScan [TS_0] (rows=10 width=68)
+ TableScan [TS_0] (rows=4 width=46)
default@table_change_string_group_string_group_varchar,table_change_string_group_string_group_varchar,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","b"]
PREHOOK: query: select insert_num,c1,c2,c3,b from table_change_string_group_string_group_varchar order by insert_num
@@ -3004,13 +3014,13 @@ Stage-0
Stage-1
Reducer 2
File Output Operator [FS_4]
- Select Operator [SEL_3] (rows=10 width=44)
+ Select Operator [SEL_3] (rows=4 width=29)
Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7"]
<-Map 1 [SIMPLE_EDGE]
SHUFFLE [RS_2]
- Select Operator [SEL_1] (rows=10 width=44)
+ Select Operator [SEL_1] (rows=4 width=29)
Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7"]
- TableScan [TS_0] (rows=10 width=44)
+ TableScan [TS_0] (rows=4 width=29)
default@table_change_lower_to_higher_numeric_group_tinyint,table_change_lower_to_higher_numeric_group_tinyint,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","c4","c5","c6","b"]
PREHOOK: query: select insert_num,c1,c2,c3,c4,c5,c6,b from table_change_lower_to_higher_numeric_group_tinyint order by insert_num
@@ -3147,13 +3157,13 @@ Stage-0
Stage-1
Reducer 2
File Output Operator [FS_4]
- Select Operator [SEL_3] (rows=10 width=44)
+ Select Operator [SEL_3] (rows=4 width=32)
Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6"]
<-Map 1 [SIMPLE_EDGE]
SHUFFLE [RS_2]
- Select Operator [SEL_1] (rows=10 width=44)
+ Select Operator [SEL_1] (rows=4 width=32)
Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6"]
- TableScan [TS_0] (rows=10 width=44)
+ TableScan [TS_0] (rows=4 width=32)
default@table_change_lower_to_higher_numeric_group_smallint,table_change_lower_to_higher_numeric_group_smallint,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","c4","c5","b"]
PREHOOK: query: select insert_num,c1,c2,c3,c4,c5,b from table_change_lower_to_higher_numeric_group_smallint order by insert_num
@@ -3288,13 +3298,13 @@ Stage-0
Stage-1
Reducer 2
File Output Operator [FS_4]
- Select Operator [SEL_3] (rows=10 width=42)
+ Select Operator [SEL_3] (rows=4 width=33)
Output:["_col0","_col1","_col2","_col3","_col4","_col5"]
<-Map 1 [SIMPLE_EDGE]
SHUFFLE [RS_2]
- Select Operator [SEL_1] (rows=10 width=42)
+ Select Operator [SEL_1] (rows=4 width=33)
Output:["_col0","_col1","_col2","_col3","_col4","_col5"]
- TableScan [TS_0] (rows=10 width=42)
+ TableScan [TS_0] (rows=4 width=33)
default@table_change_lower_to_higher_numeric_group_int,table_change_lower_to_higher_numeric_group_int,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","c4","b"]
PREHOOK: query: select insert_num,c1,c2,c3,c4,b from table_change_lower_to_higher_numeric_group_int order by insert_num
@@ -3427,13 +3437,13 @@ Stage-0
Stage-1
Reducer 2
File Output Operator [FS_4]
- Select Operator [SEL_3] (rows=10 width=41)
+ Select Operator [SEL_3] (rows=4 width=31)
Output:["_col0","_col1","_col2","_col3","_col4"]
<-Map 1 [SIMPLE_EDGE]
SHUFFLE [RS_2]
- Select Operator [SEL_1] (rows=10 width=41)
+ Select Operator [SEL_1] (rows=4 width=31)
Output:["_col0","_col1","_col2","_col3","_col4"]
- TableScan [TS_0] (rows=10 width=41)
+ TableScan [TS_0] (rows=4 width=31)
default@table_change_lower_to_higher_numeric_group_bigint,table_change_lower_to_higher_numeric_group_bigint,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","b"]
PREHOOK: query: select insert_num,c1,c2,c3,b from table_change_lower_to_higher_numeric_group_bigint order by insert_num
@@ -3564,13 +3574,13 @@ Stage-0
Stage-1
Reducer 2
File Output Operator [FS_4]
- Select Operator [SEL_3] (rows=10 width=33)
+ Select Operator [SEL_3] (rows=4 width=59)
Output:["_col0","_col1","_col2","_col3"]
<-Map 1 [SIMPLE_EDGE]
SHUFFLE [RS_2]
- Select Operator [SEL_1] (rows=10 width=33)
+ Select Operator [SEL_1] (rows=4 width=59)
Output:["_col0","_col1","_col2","_col3"]
- TableScan [TS_0] (rows=10 width=33)
+ TableScan [TS_0] (rows=4 width=59)
default@table_change_lower_to_higher_numeric_group_decimal,table_change_lower_to_higher_numeric_group_decimal,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","b"]
PREHOOK: query: select insert_num,c1,c2,b from table_change_lower_to_higher_numeric_group_decimal order by insert_num
@@ -3699,13 +3709,13 @@ Stage-0
Stage-1
Reducer 2
File Output Operator [FS_4]
- Select Operator [SEL_3] (rows=10 width=14)
+ Select Operator [SEL_3] (rows=4 width=19)
Output:["_col0","_col1","_col2"]
<-Map 1 [SIMPLE_EDGE]
SHUFFLE [RS_2]
- Select Operator [SEL_1] (rows=10 width=14)
+ Select Operator [SEL_1] (rows=4 width=19)
Output:["_col0","_col1","_col2"]
- TableScan [TS_0] (rows=10 width=14)
+ TableScan [TS_0] (rows=4 width=19)
default@table_change_lower_to_higher_numeric_group_float,table_change_lower_to_higher_numeric_group_float,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","b"]
PREHOOK: query: select insert_num,c1,b from table_change_lower_to_higher_numeric_group_float order by insert_num
http://git-wip-us.apache.org/repos/asf/hive/blob/244ce09c/ql/src/test/results/clientpositive/tez/schema_evol_text_vec_mapwork_table.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/tez/schema_evol_text_vec_mapwork_table.q.out b/ql/src/test/results/clientpositive/tez/schema_evol_text_vec_mapwork_table.q.out
index 2b799f9..f74a754 100644
--- a/ql/src/test/results/clientpositive/tez/schema_evol_text_vec_mapwork_table.q.out
+++ b/ql/src/test/results/clientpositive/tez/schema_evol_text_vec_mapwork_table.q.out
@@ -52,6 +52,11 @@ Retention: 0
#### A masked pattern was here ####
Table Type: MANAGED_TABLE
Table Parameters:
+ COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"}
+ numFiles 0
+ numRows 0
+ rawDataSize 0
+ totalSize 0
#### A masked pattern was here ####
# Storage Information
@@ -188,13 +193,13 @@ Stage-0
Stage-1
Reducer 2 vectorized
File Output Operator [FS_8]
- Select Operator [SEL_7] (rows=10 width=11)
+ Select Operator [SEL_7] (rows=4 width=12)
Output:["_col0","_col1","_col2"]
<-Map 1 [SIMPLE_EDGE] vectorized
SHUFFLE [RS_6]
- Select Operator [SEL_5] (rows=10 width=11)
+ Select Operator [SEL_5] (rows=4 width=12)
Output:["_col0","_col1","_col2"]
- TableScan [TS_0] (rows=10 width=11)
+ TableScan [TS_0] (rows=4 width=12)
default@table_add_int_permute_select,table_add_int_permute_select,Tbl:COMPLETE,Col:NONE,Output:["insert_num","a","b"]
PREHOOK: query: -- SELECT permutation columns to make sure NULL defaulting works right
@@ -298,6 +303,11 @@ Retention: 0
#### A masked pattern was here ####
Table Type: MANAGED_TABLE
Table Parameters:
+ COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"}
+ numFiles 0
+ numRows 0
+ rawDataSize 0
+ totalSize 0
#### A masked pattern was here ####
# Storage Information
@@ -437,13 +447,13 @@ Stage-0
Stage-1
Reducer 2 vectorized
File Output Operator [FS_8]
- Select Operator [SEL_7] (rows=10 width=15)
+ Select Operator [SEL_7] (rows=4 width=12)
Output:["_col0","_col1","_col2"]
<-Map 1 [SIMPLE_EDGE] vectorized
SHUFFLE [RS_6]
- Select Operator [SEL_5] (rows=10 width=15)
+ Select Operator [SEL_5] (rows=4 width=12)
Output:["_col0","_col1","_col2"]
- TableScan [TS_0] (rows=10 width=15)
+ TableScan [TS_0] (rows=4 width=12)
default@table_add_int_string_permute_select,table_add_int_string_permute_select,Tbl:COMPLETE,Col:NONE,Output:["insert_num","a","b"]
PREHOOK: query: -- SELECT permutation columns to make sure NULL defaulting works right
@@ -701,13 +711,13 @@ Stage-0
Stage-1
Reducer 2 vectorized
File Output Operator [FS_8]
- Select Operator [SEL_7] (rows=10 width=38)
+ Select Operator [SEL_7] (rows=4 width=37)
Output:["_col0","_col1","_col2","_col3","_col4"]
<-Map 1 [SIMPLE_EDGE] vectorized
SHUFFLE [RS_6]
- Select Operator [SEL_5] (rows=10 width=38)
+ Select Operator [SEL_5] (rows=4 width=37)
Output:["_col0","_col1","_col2","_col3","_col4"]
- TableScan [TS_0] (rows=10 width=38)
+ TableScan [TS_0] (rows=4 width=37)
default@table_change_string_group_double,table_change_string_group_double,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","b"]
PREHOOK: query: select insert_num,c1,c2,c3,b from table_change_string_group_double order by insert_num
@@ -853,13 +863,13 @@ Stage-0
Stage-1
Reducer 2 vectorized
File Output Operator [FS_8]
- Select Operator [SEL_7] (rows=9 width=132)
+ Select Operator [SEL_7] (rows=3 width=150)
Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6"]
<-Map 1 [SIMPLE_EDGE] vectorized
SHUFFLE [RS_6]
- Select Operator [SEL_5] (rows=9 width=132)
+ Select Operator [SEL_5] (rows=3 width=150)
Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6"]
- TableScan [TS_0] (rows=9 width=132)
+ TableScan [TS_0] (rows=3 width=150)
default@table_change_date_group_string_group_timestamp,table_change_date_group_string_group_timestamp,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","c4","c5","b"]
PREHOOK: query: select insert_num,c1,c2,c3,c4,c5,b from table_change_date_group_string_group_timestamp order by insert_num
@@ -1021,13 +1031,13 @@ Stage-0
Stage-1
Reducer 2 vectorized
File Output Operator [FS_8]
- Select Operator [SEL_7] (rows=9 width=61)
+ Select Operator [SEL_7] (rows=3 width=65)
Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6"]
<-Map 1 [SIMPLE_EDGE] vectorized
SHUFFLE [RS_6]
- Select Operator [SEL_5] (rows=9 width=61)
+ Select Operator [SEL_5] (rows=3 width=65)
Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6"]
- TableScan [TS_0] (rows=9 width=61)
+ TableScan [TS_0] (rows=3 width=65)
default@table_change_date_group_string_group_date,table_change_date_group_string_group_date,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","c4","c5","b"]
PREHOOK: query: select insert_num,c1,c2,c3,c4,c5,b from table_change_date_group_string_group_date order by insert_num
@@ -1169,13 +1179,13 @@ Stage-0
Stage-1
Reducer 2 vectorized
File Output Operator [FS_8]
- Select Operator [SEL_7] (rows=10 width=33)
+ Select Operator [SEL_7] (rows=4 width=37)
Output:["_col0","_col1","_col2","_col3","_col4","_col5"]
<-Map 1 [SIMPLE_EDGE] vectorized
SHUFFLE [RS_6]
- Select Operator [SEL_5] (rows=10 width=33)
+ Select Operator [SEL_5] (rows=4 width=37)
Output:["_col0","_col1","_col2","_col3","_col4","_col5"]
- TableScan [TS_0] (rows=10 width=33)
+ TableScan [TS_0] (rows=4 width=37)
default@table_change_numeric_group_string_group_multi_ints_string,table_change_numeric_group_string_group_multi_ints_string,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","c4","b"]
PREHOOK: query: select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_string order by insert_num
@@ -1310,13 +1320,13 @@ Stage-0
Stage-1
Reducer 2 vectorized
File Output Operator [FS_8]
- Select Operator [SEL_7] (rows=10 width=33)
+ Select Operator [SEL_7] (rows=4 width=37)
Output:["_col0","_col1","_col2","_col3","_col4","_col5"]
<-Map 1 [SIMPLE_EDGE] vectorized
SHUFFLE [RS_6]
- Select Operator [SEL_5] (rows=10 width=33)
+ Select Operator [SEL_5] (rows=4 width=37)
Output:["_col0","_col1","_col2","_col3","_col4","_col5"]
- TableScan [TS_0] (rows=10 width=33)
+ TableScan [TS_0] (rows=4 width=37)
default@table_change_numeric_group_string_group_multi_ints_char,table_change_numeric_group_string_group_multi_ints_char,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","c4","b"]
PREHOOK: query: select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_char order by insert_num
@@ -1451,13 +1461,13 @@ Stage-0
Stage-1
Reducer 2 vectorized
File Output Operator [FS_8]
- Select Operator [SEL_7] (rows=10 width=30)
+ Select Operator [SEL_7] (rows=4 width=37)
Output:["_col0","_col1","_col2","_col3","_col4","_col5"]
<-Map 1 [SIMPLE_EDGE] vectorized
SHUFFLE [RS_6]
- Select Operator [SEL_5] (rows=10 width=30)
+ Select Operator [SEL_5] (rows=4 width=37)
Output:["_col0","_col1","_col2","_col3","_col4","_col5"]
- TableScan [TS_0] (rows=10 width=30)
+ TableScan [TS_0] (rows=4 width=37)
default@table_change_numeric_group_string_group_multi_ints_char_trunc,table_change_numeric_group_string_group_multi_ints_char_trunc,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","c4","b"]
PREHOOK: query: select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_char_trunc order by insert_num
@@ -1592,13 +1602,13 @@ Stage-0
Stage-1
Reducer 2 vectorized
File Output Operator [FS_8]
- Select Operator [SEL_7] (rows=10 width=33)
+ Select Operator [SEL_7] (rows=4 width=37)
Output:["_col0","_col1","_col2","_col3","_col4","_col5"]
<-Map 1 [SIMPLE_EDGE] vectorized
SHUFFLE [RS_6]
- Select Operator [SEL_5] (rows=10 width=33)
+ Select Operator [SEL_5] (rows=4 width=37)
Output:["_col0","_col1","_col2","_col3","_col4","_col5"]
- TableScan [TS_0] (rows=10 width=33)
+ TableScan [TS_0] (rows=4 width=37)
default@table_change_numeric_group_string_group_multi_ints_varchar,table_change_numeric_group_string_group_multi_ints_varchar,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","c4","b"]
PREHOOK: query: select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_varchar order by insert_num
@@ -1733,13 +1743,13 @@ Stage-0
Stage-1
Reducer 2 vectorized
File Output Operator [FS_8]
- Select Operator [SEL_7] (rows=10 width=30)
+ Select Operator [SEL_7] (rows=4 width=37)
Output:["_col0","_col1","_col2","_col3","_col4","_col5"]
<-Map 1 [SIMPLE_EDGE] vectorized
SHUFFLE [RS_6]
- Select Operator [SEL_5] (rows=10 width=30)
+ Select Operator [SEL_5] (rows=4 width=37)
Output:["_col0","_col1","_col2","_col3","_col4","_col5"]
- TableScan [TS_0] (rows=10 width=30)
+ TableScan [TS_0] (rows=4 width=37)
default@table_change_numeric_group_string_group_multi_ints_varchar_trunc,table_change_numeric_group_string_group_multi_ints_varchar_trunc,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","c4","b"]
PREHOOK: query: select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_varchar_trunc order by insert_num
@@ -1872,13 +1882,13 @@ Stage-0
Stage-1
Reducer 2 vectorized
File Output Operator [FS_8]
- Select Operator [SEL_7] (rows=10 width=38)
+ Select Operator [SEL_7] (rows=4 width=53)
Output:["_col0","_col1","_col2","_col3","_col4"]
<-Map 1 [SIMPLE_EDGE] vectorized
SHUFFLE [RS_6]
- Select Operator [SEL_5] (rows=10 width=38)
+ Select Operator [SEL_5] (rows=4 width=53)
Output:["_col0","_col1","_col2","_col3","_col4"]
- TableScan [TS_0] (rows=10 width=38)
+ TableScan [TS_0] (rows=4 width=53)
default@table_change_numeric_group_string_group_floating_string,table_change_numeric_group_string_group_floating_string,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","b"]
PREHOOK: query: select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_string order by insert_num
@@ -2011,13 +2021,13 @@ Stage-0
Stage-1
Reducer 2 vectorized
File Output Operator [FS_8]
- Select Operator [SEL_7] (rows=10 width=38)
+ Select Operator [SEL_7] (rows=4 width=55)
Output:["_col0","_col1","_col2","_col3","_col4"]
<-Map 1 [SIMPLE_EDGE] vectorized
SHUFFLE [RS_6]
- Select Operator [SEL_5] (rows=10 width=38)
+ Select Operator [SEL_5] (rows=4 width=55)
Output:["_col0","_col1","_col2","_col3","_col4"]
- TableScan [TS_0] (rows=10 width=38)
+ TableScan [TS_0] (rows=4 width=55)
default@table_change_numeric_group_string_group_floating_char,table_change_numeric_group_string_group_floating_char,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","b"]
PREHOOK: query: select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_char order by insert_num
@@ -2150,13 +2160,13 @@ Stage-0
Stage-1
Reducer 2 vectorized
File Output Operator [FS_8]
- Select Operator [SEL_7] (rows=10 width=35)
+ Select Operator [SEL_7] (rows=4 width=53)
Output:["_col0","_col1","_col2","_col3","_col4"]
<-Map 1 [SIMPLE_EDGE] vectorized
SHUFFLE [RS_6]
- Select Operator [SEL_5] (rows=10 width=35)
+ Select Operator [SEL_5] (rows=4 width=53)
Output:["_col0","_col1","_col2","_col3","_col4"]
- TableScan [TS_0] (rows=10 width=35)
+ TableScan [TS_0] (rows=4 width=53)
default@table_change_numeric_group_string_group_floating_char_trunc,table_change_numeric_group_string_group_floating_char_trunc,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","b"]
PREHOOK: query: select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_char_trunc order by insert_num
@@ -2289,13 +2299,13 @@ Stage-0
Stage-1
Reducer 2 vectorized
File Output Operator [FS_8]
- Select Operator [SEL_7] (rows=10 width=36)
+ Select Operator [SEL_7] (rows=4 width=50)
Output:["_col0","_col1","_col2","_col3","_col4"]
<-Map 1 [SIMPLE_EDGE] vectorized
SHUFFLE [RS_6]
- Select Operator [SEL_5] (rows=10 width=36)
+ Select Operator [SEL_5] (rows=4 width=50)
Output:["_col0","_col1","_col2","_col3","_col4"]
- TableScan [TS_0] (rows=10 width=36)
+ TableScan [TS_0] (rows=4 width=50)
default@table_change_numeric_group_string_group_floating_varchar,table_change_numeric_group_string_group_floating_varchar,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","b"]
PREHOOK: query: select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_varchar order by insert_num
@@ -2428,13 +2438,13 @@ Stage-0
Stage-1
Reducer 2 vectorized
File Output Operator [FS_8]
- Select Operator [SEL_7] (rows=10 width=36)
+ Select Operator [SEL_7] (rows=4 width=55)
Output:["_col0","_col1","_col2","_col3","_col4"]
<-Map 1 [SIMPLE_EDGE] vectorized
SHUFFLE [RS_6]
- Select Operator [SEL_5] (rows=10 width=36)
+ Select Operator [SEL_5] (rows=4 width=55)
Output:["_col0","_col1","_col2","_col3","_col4"]
- TableScan [TS_0] (rows=10 width=36)
+ TableScan [TS_0] (rows=4 width=55)
default@table_change_numeric_group_string_group_floating_varchar_trunc,table_change_numeric_group_string_group_floating_varchar_trunc,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","b"]
PREHOOK: query: select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_varchar_trunc order by insert_num
@@ -2577,13 +2587,13 @@ Stage-0
Stage-1
Reducer 2 vectorized
File Output Operator [FS_8]
- Select Operator [SEL_7] (rows=10 width=54)
+ Select Operator [SEL_7] (rows=4 width=59)
Output:["_col0","_col1","_col2","_col3","_col4","_col5"]
<-Map 1 [SIMPLE_EDGE] vectorized
SHUFFLE [RS_6]
- Select Operator [SEL_5] (rows=10 width=54)
+ Select Operator [SEL_5] (rows=4 width=59)
Output:["_col0","_col1","_col2","_col3","_col4","_col5"]
- TableScan [TS_0] (rows=10 width=54)
+ TableScan [TS_0] (rows=4 width=59)
default@table_change_string_group_string_group_string,table_change_string_group_string_group_string,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","c4","b"]
PREHOOK: query: select insert_num,c1,c2,c3,c4,b from table_change_string_group_string_group_string order by insert_num
@@ -2716,13 +2726,13 @@ Stage-0
Stage-1
Reducer 2 vectorized
File Output Operator [FS_8]
- Select Operator [SEL_7] (rows=10 width=46)
+ Select Operator [SEL_7] (rows=4 width=44)
Output:["_col0","_col1","_col2","_col3","_col4"]
<-Map 1 [SIMPLE_EDGE] vectorized
SHUFFLE [RS_6]
- Select Operator [SEL_5] (rows=10 width=46)
+ Select Operator [SEL_5] (rows=4 width=44)
Output:["_col0","_col1","_col2","_col3","_col4"]
- TableScan [TS_0] (rows=10 width=46)
+ TableScan [TS_0] (rows=4 width=44)
default@table_change_string_group_string_group_char,table_change_string_group_string_group_char,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","b"]
PREHOOK: query: select insert_num,c1,c2,c3,b from table_change_string_group_string_group_char order by insert_num
@@ -2855,13 +2865,13 @@ Stage-0
Stage-1
Reducer 2 vectorized
File Output Operator [FS_8]
- Select Operator [SEL_7] (rows=10 width=45)
+ Select Operator [SEL_7] (rows=4 width=46)
Output:["_col0","_col1","_col2","_col3","_col4"]
<-Map 1 [SIMPLE_EDGE] vectorized
SHUFFLE [RS_6]
- Select Operator [SEL_5] (rows=10 width=45)
+ Select Operator [SEL_5] (rows=4 width=46)
Output:["_col0","_col1","_col2","_col3","_col4"]
- TableScan [TS_0] (rows=10 width=45)
+ TableScan [TS_0] (rows=4 width=46)
default@table_change_string_group_string_group_varchar,table_change_string_group_string_group_varchar,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","b"]
PREHOOK: query: select insert_num,c1,c2,c3,b from table_change_string_group_string_group_varchar order by insert_num
@@ -3008,13 +3018,13 @@ Stage-0
Stage-1
Reducer 2 vectorized
File Output Operator [FS_8]
- Select Operator [SEL_7] (rows=10 width=44)
+ Select Operator [SEL_7] (rows=4 width=29)
Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7"]
<-Map 1 [SIMPLE_EDGE] vectorized
SHUFFLE [RS_6]
- Select Operator [SEL_5] (rows=10 width=44)
+ Select Operator [SEL_5] (rows=4 width=29)
Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7"]
- TableScan [TS_0] (rows=10 width=44)
+ TableScan [TS_0] (rows=4 width=29)
default@table_change_lower_to_higher_numeric_group_tinyint,table_change_lower_to_higher_numeric_group_tinyint,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","c4","c5","c6","b"]
PREHOOK: query: select insert_num,c1,c2,c3,c4,c5,c6,b from table_change_lower_to_higher_numeric_group_tinyint order by insert_num
@@ -3151,13 +3161,13 @@ Stage-0
Stage-1
Reducer 2 vectorized
File Output Operator [FS_8]
- Select Operator [SEL_7] (rows=10 width=44)
+ Select Operator [SEL_7] (rows=4 width=32)
Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6"]
<-Map 1 [SIMPLE_EDGE] vectorized
SHUFFLE [RS_6]
- Select Operator [SEL_5] (rows=10 width=44)
+ Select Operator [SEL_5] (rows=4 width=32)
Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6"]
- TableScan [TS_0] (rows=10 width=44)
+ TableScan [TS_0] (rows=4 width=32)
default@table_change_lower_to_higher_numeric_group_smallint,table_change_lower_to_higher_numeric_group_smallint,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","c4","c5","b"]
PREHOOK: query: select insert_num,c1,c2,c3,c4,c5,b from table_change_lower_to_higher_numeric_group_smallint order by insert_num
@@ -3292,13 +3302,13 @@ Stage-0
Stage-1
Reducer 2 vectorized
File Output Operator [FS_8]
- Select Operator [SEL_7] (rows=10 width=42)
+ Select Operator [SEL_7] (rows=4 width=33)
Output:["_col0","_col1","_col2","_col3","_col4","_col5"]
<-Map 1 [SIMPLE_EDGE] vectorized
SHUFFLE [RS_6]
- Select Operator [SEL_5] (rows=10 width=42)
+ Select Operator [SEL_5] (rows=4 width=33)
Output:["_col0","_col1","_col2","_col3","_col4","_col5"]
- TableScan [TS_0] (rows=10 width=42)
+ TableScan [TS_0] (rows=4 width=33)
default@table_change_lower_to_higher_numeric_group_int,table_change_lower_to_higher_numeric_group_int,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","c4","b"]
PREHOOK: query: select insert_num,c1,c2,c3,c4,b from table_change_lower_to_higher_numeric_group_int order by insert_num
@@ -3431,13 +3441,13 @@ Stage-0
Stage-1
Reducer 2 vectorized
File Output Operator [FS_8]
- Select Operator [SEL_7] (rows=10 width=41)
+ Select Operator [SEL_7] (rows=4 width=31)
Output:["_col0","_col1","_col2","_col3","_col4"]
<-Map 1 [SIMPLE_EDGE] vectorized
SHUFFLE [RS_6]
- Select Operator [SEL_5] (rows=10 width=41)
+ Select Operator [SEL_5] (rows=4 width=31)
Output:["_col0","_col1","_col2","_col3","_col4"]
- TableScan [TS_0] (rows=10 width=41)
+ TableScan [TS_0] (rows=4 width=31)
default@table_change_lower_to_higher_numeric_group_bigint,table_change_lower_to_higher_numeric_group_bigint,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","b"]
PREHOOK: query: select insert_num,c1,c2,c3,b from table_change_lower_to_higher_numeric_group_bigint order by insert_num
@@ -3568,13 +3578,13 @@ Stage-0
Stage-1
Reducer 2 vectorized
File Output Operator [FS_8]
- Select Operator [SEL_7] (rows=10 width=33)
+ Select Operator [SEL_7] (rows=4 width=59)
Output:["_col0","_col1","_col2","_col3"]
<-Map 1 [SIMPLE_EDGE] vectorized
SHUFFLE [RS_6]
- Select Operator [SEL_5] (rows=10 width=33)
+ Select Operator [SEL_5] (rows=4 width=59)
Output:["_col0","_col1","_col2","_col3"]
- TableScan [TS_0] (rows=10 width=33)
+ TableScan [TS_0] (rows=4 width=59)
default@table_change_lower_to_higher_numeric_group_decimal,table_change_lower_to_higher_numeric_group_decimal,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","b"]
PREHOOK: query: select insert_num,c1,c2,b from table_change_lower_to_higher_numeric_group_decimal order by insert_num
@@ -3703,13 +3713,13 @@ Stage-0
Stage-1
Reducer 2 vectorized
File Output Operator [FS_8]
- Select Operator [SEL_7] (rows=10 width=14)
+ Select Operator [SEL_7] (rows=4 width=19)
Output:["_col0","_col1","_col2"]
<-Map 1 [SIMPLE_EDGE] vectorized
SHUFFLE [RS_6]
- Select Operator [SEL_5] (rows=10 width=14)
+ Select Operator [SEL_5] (rows=4 width=19)
Output:["_col0","_col1","_col2"]
- TableScan [TS_0] (rows=10 width=14)
+ TableScan [TS_0] (rows=4 width=19)
default@table_change_lower_to_higher_numeric_group_float,table_change_lower_to_higher_numeric_group_float,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","b"]
PREHOOK: query: select insert_num,c1,b from table_change_lower_to_higher_numeric_group_float order by insert_num
http://git-wip-us.apache.org/repos/asf/hive/blob/244ce09c/ql/src/test/results/clientpositive/tez/schema_evol_text_vecrow_mapwork_table.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/tez/schema_evol_text_vecrow_mapwork_table.q.out b/ql/src/test/results/clientpositive/tez/schema_evol_text_vecrow_mapwork_table.q.out
index 1b46fa7..81cb662 100644
--- a/ql/src/test/results/clientpositive/tez/schema_evol_text_vecrow_mapwork_table.q.out
+++ b/ql/src/test/results/clientpositive/tez/schema_evol_text_vecrow_mapwork_table.q.out
@@ -52,6 +52,11 @@ Retention: 0
#### A masked pattern was here ####
Table Type: MANAGED_TABLE
Table Parameters:
+ COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"}
+ numFiles 0
+ numRows 0
+ rawDataSize 0
+ totalSize 0
#### A masked pattern was here ####
# Storage Information
@@ -188,13 +193,13 @@ Stage-0
Stage-1
Reducer 2 vectorized
File Output Operator [FS_8]
- Select Operator [SEL_7] (rows=10 width=11)
+ Select Operator [SEL_7] (rows=4 width=12)
Output:["_col0","_col1","_col2"]
<-Map 1 [SIMPLE_EDGE] vectorized
SHUFFLE [RS_6]
- Select Operator [SEL_5] (rows=10 width=11)
+ Select Operator [SEL_5] (rows=4 width=12)
Output:["_col0","_col1","_col2"]
- TableScan [TS_0] (rows=10 width=11)
+ TableScan [TS_0] (rows=4 width=12)
default@table_add_int_permute_select,table_add_int_permute_select,Tbl:COMPLETE,Col:NONE,Output:["insert_num","a","b"]
PREHOOK: query: -- SELECT permutation columns to make sure NULL defaulting works right
@@ -298,6 +303,11 @@ Retention: 0
#### A masked pattern was here ####
Table Type: MANAGED_TABLE
Table Parameters:
+ COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"}
+ numFiles 0
+ numRows 0
+ rawDataSize 0
+ totalSize 0
#### A masked pattern was here ####
# Storage Information
@@ -437,13 +447,13 @@ Stage-0
Stage-1
Reducer 2 vectorized
File Output Operator [FS_8]
- Select Operator [SEL_7] (rows=10 width=15)
+ Select Operator [SEL_7] (rows=4 width=12)
Output:["_col0","_col1","_col2"]
<-Map 1 [SIMPLE_EDGE] vectorized
SHUFFLE [RS_6]
- Select Operator [SEL_5] (rows=10 width=15)
+ Select Operator [SEL_5] (rows=4 width=12)
Output:["_col0","_col1","_col2"]
- TableScan [TS_0] (rows=10 width=15)
+ TableScan [TS_0] (rows=4 width=12)
default@table_add_int_string_permute_select,table_add_int_string_permute_select,Tbl:COMPLETE,Col:NONE,Output:["insert_num","a","b"]
PREHOOK: query: -- SELECT permutation columns to make sure NULL defaulting works right
@@ -701,13 +711,13 @@ Stage-0
Stage-1
Reducer 2 vectorized
File Output Operator [FS_8]
- Select Operator [SEL_7] (rows=10 width=38)
+ Select Operator [SEL_7] (rows=4 width=37)
Output:["_col0","_col1","_col2","_col3","_col4"]
<-Map 1 [SIMPLE_EDGE] vectorized
SHUFFLE [RS_6]
- Select Operator [SEL_5] (rows=10 width=38)
+ Select Operator [SEL_5] (rows=4 width=37)
Output:["_col0","_col1","_col2","_col3","_col4"]
- TableScan [TS_0] (rows=10 width=38)
+ TableScan [TS_0] (rows=4 width=37)
default@table_change_string_group_double,table_change_string_group_double,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","b"]
PREHOOK: query: select insert_num,c1,c2,c3,b from table_change_string_group_double order by insert_num
@@ -853,13 +863,13 @@ Stage-0
Stage-1
Reducer 2 vectorized
File Output Operator [FS_8]
- Select Operator [SEL_7] (rows=9 width=132)
+ Select Operator [SEL_7] (rows=3 width=150)
Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6"]
<-Map 1 [SIMPLE_EDGE] vectorized
SHUFFLE [RS_6]
- Select Operator [SEL_5] (rows=9 width=132)
+ Select Operator [SEL_5] (rows=3 width=150)
Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6"]
- TableScan [TS_0] (rows=9 width=132)
+ TableScan [TS_0] (rows=3 width=150)
default@table_change_date_group_string_group_timestamp,table_change_date_group_string_group_timestamp,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","c4","c5","b"]
PREHOOK: query: select insert_num,c1,c2,c3,c4,c5,b from table_change_date_group_string_group_timestamp order by insert_num
@@ -1021,13 +1031,13 @@ Stage-0
Stage-1
Reducer 2 vectorized
File Output Operator [FS_8]
- Select Operator [SEL_7] (rows=9 width=61)
+ Select Operator [SEL_7] (rows=3 width=65)
Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6"]
<-Map 1 [SIMPLE_EDGE] vectorized
SHUFFLE [RS_6]
- Select Operator [SEL_5] (rows=9 width=61)
+ Select Operator [SEL_5] (rows=3 width=65)
Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6"]
- TableScan [TS_0] (rows=9 width=61)
+ TableScan [TS_0] (rows=3 width=65)
default@table_change_date_group_string_group_date,table_change_date_group_string_group_date,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","c4","c5","b"]
PREHOOK: query: select insert_num,c1,c2,c3,c4,c5,b from table_change_date_group_string_group_date order by insert_num
@@ -1169,13 +1179,13 @@ Stage-0
Stage-1
Reducer 2 vectorized
File Output Operator [FS_8]
- Select Operator [SEL_7] (rows=10 width=33)
+ Select Operator [SEL_7] (rows=4 width=37)
Output:["_col0","_col1","_col2","_col3","_col4","_col5"]
<-Map 1 [SIMPLE_EDGE] vectorized
SHUFFLE [RS_6]
- Select Operator [SEL_5] (rows=10 width=33)
+ Select Operator [SEL_5] (rows=4 width=37)
Output:["_col0","_col1","_col2","_col3","_col4","_col5"]
- TableScan [TS_0] (rows=10 width=33)
+ TableScan [TS_0] (rows=4 width=37)
default@table_change_numeric_group_string_group_multi_ints_string,table_change_numeric_group_string_group_multi_ints_string,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","c4","b"]
PREHOOK: query: select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_string order by insert_num
@@ -1310,13 +1320,13 @@ Stage-0
Stage-1
Reducer 2 vectorized
File Output Operator [FS_8]
- Select Operator [SEL_7] (rows=10 width=33)
+ Select Operator [SEL_7] (rows=4 width=37)
Output:["_col0","_col1","_col2","_col3","_col4","_col5"]
<-Map 1 [SIMPLE_EDGE] vectorized
SHUFFLE [RS_6]
- Select Operator [SEL_5] (rows=10 width=33)
+ Select Operator [SEL_5] (rows=4 width=37)
Output:["_col0","_col1","_col2","_col3","_col4","_col5"]
- TableScan [TS_0] (rows=10 width=33)
+ TableScan [TS_0] (rows=4 width=37)
default@table_change_numeric_group_string_group_multi_ints_char,table_change_numeric_group_string_group_multi_ints_char,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","c4","b"]
PREHOOK: query: select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_char order by insert_num
@@ -1451,13 +1461,13 @@ Stage-0
Stage-1
Reducer 2 vectorized
File Output Operator [FS_8]
- Select Operator [SEL_7] (rows=10 width=30)
+ Select Operator [SEL_7] (rows=4 width=37)
Output:["_col0","_col1","_col2","_col3","_col4","_col5"]
<-Map 1 [SIMPLE_EDGE] vectorized
SHUFFLE [RS_6]
- Select Operator [SEL_5] (rows=10 width=30)
+ Select Operator [SEL_5] (rows=4 width=37)
Output:["_col0","_col1","_col2","_col3","_col4","_col5"]
- TableScan [TS_0] (rows=10 width=30)
+ TableScan [TS_0] (rows=4 width=37)
default@table_change_numeric_group_string_group_multi_ints_char_trunc,table_change_numeric_group_string_group_multi_ints_char_trunc,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","c4","b"]
PREHOOK: query: select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_char_trunc order by insert_num
@@ -1592,13 +1602,13 @@ Stage-0
Stage-1
Reducer 2 vectorized
File Output Operator [FS_8]
- Select Operator [SEL_7] (rows=10 width=33)
+ Select Operator [SEL_7] (rows=4 width=37)
Output:["_col0","_col1","_col2","_col3","_col4","_col5"]
<-Map 1 [SIMPLE_EDGE] vectorized
SHUFFLE [RS_6]
- Select Operator [SEL_5] (rows=10 width=33)
+ Select Operator [SEL_5] (rows=4 width=37)
Output:["_col0","_col1","_col2","_col3","_col4","_col5"]
- TableScan [TS_0] (rows=10 width=33)
+ TableScan [TS_0] (rows=4 width=37)
default@table_change_numeric_group_string_group_multi_ints_varchar,table_change_numeric_group_string_group_multi_ints_varchar,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","c4","b"]
PREHOOK: query: select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_varchar order by insert_num
@@ -1733,13 +1743,13 @@ Stage-0
Stage-1
Reducer 2 vectorized
File Output Operator [FS_8]
- Select Operator [SEL_7] (rows=10 width=30)
+ Select Operator [SEL_7] (rows=4 width=37)
Output:["_col0","_col1","_col2","_col3","_col4","_col5"]
<-Map 1 [SIMPLE_EDGE] vectorized
SHUFFLE [RS_6]
- Select Operator [SEL_5] (rows=10 width=30)
+ Select Operator [SEL_5] (rows=4 width=37)
Output:["_col0","_col1","_col2","_col3","_col4","_col5"]
- TableScan [TS_0] (rows=10 width=30)
+ TableScan [TS_0] (rows=4 width=37)
default@table_change_numeric_group_string_group_multi_ints_varchar_trunc,table_change_numeric_group_string_group_multi_ints_varchar_trunc,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","c4","b"]
PREHOOK: query: select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_varchar_trunc order by insert_num
@@ -1872,13 +1882,13 @@ Stage-0
Stage-1
Reducer 2 vectorized
File Output Operator [FS_8]
- Select Operator [SEL_7] (rows=10 width=38)
+ Select Operator [SEL_7] (rows=4 width=53)
Output:["_col0","_col1","_col2","_col3","_col4"]
<-Map 1 [SIMPLE_EDGE] vectorized
SHUFFLE [RS_6]
- Select Operator [SEL_5] (rows=10 width=38)
+ Select Operator [SEL_5] (rows=4 width=53)
Output:["_col0","_col1","_col2","_col3","_col4"]
- TableScan [TS_0] (rows=10 width=38)
+ TableScan [TS_0] (rows=4 width=53)
default@table_change_numeric_group_string_group_floating_string,table_change_numeric_group_string_group_floating_string,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","b"]
PREHOOK: query: select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_string order by insert_num
@@ -2011,13 +2021,13 @@ Stage-0
Stage-1
Reducer 2 vectorized
File Output Operator [FS_8]
- Select Operator [SEL_7] (rows=10 width=38)
+ Select Operator [SEL_7] (rows=4 width=55)
Output:["_col0","_col1","_col2","_col3","_col4"]
<-Map 1 [SIMPLE_EDGE] vectorized
SHUFFLE [RS_6]
- Select Operator [SEL_5] (rows=10 width=38)
+ Select Operator [SEL_5] (rows=4 width=55)
Output:["_col0","_col1","_col2","_col3","_col4"]
- TableScan [TS_0] (rows=10 width=38)
+ TableScan [TS_0] (rows=4 width=55)
default@table_change_numeric_group_string_group_floating_char,table_change_numeric_group_string_group_floating_char,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","b"]
PREHOOK: query: select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_char order by insert_num
@@ -2150,13 +2160,13 @@ Stage-0
Stage-1
Reducer 2 vectorized
File Output Operator [FS_8]
- Select Operator [SEL_7] (rows=10 width=35)
+ Select Operator [SEL_7] (rows=4 width=53)
Output:["_col0","_col1","_col2","_col3","_col4"]
<-Map 1 [SIMPLE_EDGE] vectorized
SHUFFLE [RS_6]
- Select Operator [SEL_5] (rows=10 width=35)
+ Select Operator [SEL_5] (rows=4 width=53)
Output:["_col0","_col1","_col2","_col3","_col4"]
- TableScan [TS_0] (rows=10 width=35)
+ TableScan [TS_0] (rows=4 width=53)
default@table_change_numeric_group_string_group_floating_char_trunc,table_change_numeric_group_string_group_floating_char_trunc,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","b"]
PREHOOK: query: select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_char_trunc order by insert_num
@@ -2289,13 +2299,13 @@ Stage-0
Stage-1
Reducer 2 vectorized
File Output Operator [FS_8]
- Select Operator [SEL_7] (rows=10 width=36)
+ Select Operator [SEL_7] (rows=4 width=50)
Output:["_col0","_col1","_col2","_col3","_col4"]
<-Map 1 [SIMPLE_EDGE] vectorized
SHUFFLE [RS_6]
- Select Operator [SEL_5] (rows=10 width=36)
+ Select Operator [SEL_5] (rows=4 width=50)
Output:["_col0","_col1","_col2","_col3","_col4"]
- TableScan [TS_0] (rows=10 width=36)
+ TableScan [TS_0] (rows=4 width=50)
default@table_change_numeric_group_string_group_floating_varchar,table_change_numeric_group_string_group_floating_varchar,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","b"]
PREHOOK: query: select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_varchar order by insert_num
@@ -2428,13 +2438,13 @@ Stage-0
Stage-1
Reducer 2 vectorized
File Output Operator [FS_8]
- Select Operator [SEL_7] (rows=10 width=36)
+ Select Operator [SEL_7] (rows=4 width=55)
Output:["_col0","_col1","_col2","_col3","_col4"]
<-Map 1 [SIMPLE_EDGE] vectorized
SHUFFLE [RS_6]
- Select Operator [SEL_5] (rows=10 width=36)
+ Select Operator [SEL_5] (rows=4 width=55)
Output:["_col0","_col1","_col2","_col3","_col4"]
- TableScan [TS_0] (rows=10 width=36)
+ TableScan [TS_0] (rows=4 width=55)
default@table_change_numeric_group_string_group_floating_varchar_trunc,table_change_numeric_group_string_group_floating_varchar_trunc,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","b"]
PREHOOK: query: select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_varchar_trunc order by insert_num
@@ -2577,13 +2587,13 @@ Stage-0
Stage-1
Reducer 2 vectorized
File Output Operator [FS_8]
- Select Operator [SEL_7] (rows=10 width=54)
+ Select Operator [SEL_7] (rows=4 width=59)
Output:["_col0","_col1","_col2","_col3","_col4","_col5"]
<-Map 1 [SIMPLE_EDGE] vectorized
SHUFFLE [RS_6]
- Select Operator [SEL_5] (rows=10 width=54)
+ Select Operator [SEL_5] (rows=4 width=59)
Output:["_col0","_col1","_col2","_col3","_col4","_col5"]
- TableScan [TS_0] (rows=10 width=54)
+ TableScan [TS_0] (rows=4 width=59)
default@table_change_string_group_string_group_string,table_change_string_group_string_group_string,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","c4","b"]
PREHOOK: query: select insert_num,c1,c2,c3,c4,b from table_change_string_group_string_group_string order by insert_num
@@ -2716,13 +2726,13 @@ Stage-0
Stage-1
Reducer 2 vectorized
File Output Operator [FS_8]
- Select Operator [SEL_7] (rows=10 width=46)
+ Select Operator [SEL_7] (rows=4 width=44)
Output:["_col0","_col1","_col2","_col3","_col4"]
<-Map 1 [SIMPLE_EDGE] vectorized
SHUFFLE [RS_6]
- Select Operator [SEL_5] (rows=10 width=46)
+ Select Operator [SEL_5] (rows=4 width=44)
Output:["_col0","_col1","_col2","_col3","_col4"]
- TableScan [TS_0] (rows=10 width=46)
+ TableScan [TS_0] (rows=4 width=44)
default@table_change_string_group_string_group_char,table_change_string_group_string_group_char,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","b"]
PREHOOK: query: select insert_num,c1,c2,c3,b from table_change_string_group_string_group_char order by insert_num
@@ -2855,13 +2865,13 @@ Stage-0
Stage-1
Reducer 2 vectorized
File Output Operator [FS_8]
- Select Operator [SEL_7] (rows=10 width=45)
+ Select Operator [SEL_7] (rows=4 width=46)
Output:["_col0","_col1","_col2","_col3","_col4"]
<-Map 1 [SIMPLE_EDGE] vectorized
SHUFFLE [RS_6]
- Select Operator [SEL_5] (rows=10 width=45)
+ Select Operator [SEL_5] (rows=4 width=46)
Output:["_col0","_col1","_col2","_col3","_col4"]
- TableScan [TS_0] (rows=10 width=45)
+ TableScan [TS_0] (rows=4 width=46)
default@table_change_string_group_string_group_varchar,table_change_string_group_string_group_varchar,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","b"]
PREHOOK: query: select insert_num,c1,c2,c3,b from table_change_string_group_string_group_varchar order by insert_num
@@ -3008,13 +3018,13 @@ Stage-0
Stage-1
Reducer 2 vectorized
File Output Operator [FS_8]
- Select Operator [SEL_7] (rows=10 width=44)
+ Select Operator [SEL_7] (rows=4 width=29)
Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7"]
<-Map 1 [SIMPLE_EDGE] vectorized
SHUFFLE [RS_6]
- Select Operator [SEL_5] (rows=10 width=44)
+ Select Operator [SEL_5] (rows=4 width=29)
Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7"]
- TableScan [TS_0] (rows=10 width=44)
+ TableScan [TS_0] (rows=4 width=29)
default@table_change_lower_to_higher_numeric_group_tinyint,table_change_lower_to_higher_numeric_group_tinyint,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","c4","c5","c6","b"]
PREHOOK: query: select insert_num,c1,c2,c3,c4,c5,c6,b from table_change_lower_to_higher_numeric_group_tinyint order by insert_num
@@ -3151,13 +3161,13 @@ Stage-0
Stage-1
Reducer 2 vectorized
File Output Operator [FS_8]
- Select Operator [SEL_7] (rows=10 width=44)
+ Select Operator [SEL_7] (rows=4 width=32)
Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6"]
<-Map 1 [SIMPLE_EDGE] vectorized
SHUFFLE [RS_6]
- Select Operator [SEL_5] (rows=10 width=44)
+ Select Operator [SEL_5] (rows=4 width=32)
Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6"]
- TableScan [TS_0] (rows=10 width=44)
+ TableScan [TS_0] (rows=4 width=32)
default@table_change_lower_to_higher_numeric_group_smallint,table_change_lower_to_higher_numeric_group_smallint,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","c4","c5","b"]
PREHOOK: query: select insert_num,c1,c2,c3,c4,c5,b from table_change_lower_to_higher_numeric_group_smallint order by insert_num
@@ -3292,13 +3302,13 @@ Stage-0
Stage-1
Reducer 2 vectorized
File Output Operator [FS_8]
- Select Operator [SEL_7] (rows=10 width=42)
+ Select Operator [SEL_7] (rows=4 width=33)
Output:["_col0","_col1","_col2","_col3","_col4","_col5"]
<-Map 1 [SIMPLE_EDGE] vectorized
SHUFFLE [RS_6]
- Select Operator [SEL_5] (rows=10 width=42)
+ Select Operator [SEL_5] (rows=4 width=33)
Output:["_col0","_col1","_col2","_col3","_col4","_col5"]
- TableScan [TS_0] (rows=10 width=42)
+ TableScan [TS_0] (rows=4 width=33)
default@table_change_lower_to_higher_numeric_group_int,table_change_lower_to_higher_numeric_group_int,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","c4","b"]
PREHOOK: query: select insert_num,c1,c2,c3,c4,b from table_change_lower_to_higher_numeric_group_int order by insert_num
@@ -3431,13 +3441,13 @@ Stage-0
Stage-1
Reducer 2 vectorized
File Output Operator [FS_8]
- Select Operator [SEL_7] (rows=10 width=41)
+ Select Operator [SEL_7] (rows=4 width=31)
Output:["_col0","_col1","_col2","_col3","_col4"]
<-Map 1 [SIMPLE_EDGE] vectorized
SHUFFLE [RS_6]
- Select Operator [SEL_5] (rows=10 width=41)
+ Select Operator [SEL_5] (rows=4 width=31)
Output:["_col0","_col1","_col2","_col3","_col4"]
- TableScan [TS_0] (rows=10 width=41)
+ TableScan [TS_0] (rows=4 width=31)
default@table_change_lower_to_higher_numeric_group_bigint,table_change_lower_to_higher_numeric_group_bigint,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","b"]
PREHOOK: query: select insert_num,c1,c2,c3,b from table_change_lower_to_higher_numeric_group_bigint order by insert_num
@@ -3568,13 +3578,13 @@ Stage-0
Stage-1
Reducer 2 vectorized
File Output Operator [FS_8]
- Select Operator [SEL_7] (rows=10 width=33)
+ Select Operator [SEL_7] (rows=4 width=59)
Output:["_col0","_col1","_col2","_col3"]
<-Map 1 [SIMPLE_EDGE] vectorized
SHUFFLE [RS_6]
- Select Operator [SEL_5] (rows=10 width=33)
+ Select Operator [SEL_5] (rows=4 width=59)
Output:["_col0","_col1","_col2","_col3"]
- TableScan [TS_0] (rows=10 width=33)
+ TableScan [TS_0] (rows=4 width=59)
default@table_change_lower_to_higher_numeric_group_decimal,table_change_lower_to_higher_numeric_group_decimal,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","b"]
PREHOOK: query: select insert_num,c1,c2,b from table_change_lower_to_higher_numeric_group_decimal order by insert_num
@@ -3703,13 +3713,13 @@ Stage-0
Stage-1
Reducer 2 vectorized
File Output Operator [FS_8]
- Select Operator [SEL_7] (rows=10 width=14)
+ Select Operator [SEL_7] (rows=4 width=19)
Output:["_col0","_col1","_col2"]
<-Map 1 [SIMPLE_EDGE] vectorized
SHUFFLE [RS_6]
- Select Operator [SEL_5] (rows=10 width=14)
+ Select Operator [SEL_5] (rows=4 width=19)
Output:["_col0","_col1","_col2"]
- TableScan [TS_0] (rows=10 width=14)
+ TableScan [TS_0] (rows=4 width=19)
default@table_change_lower_to_higher_numeric_group_float,table_change_lower_to_higher_numeric_group_float,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","b"]
PREHOOK: query: select insert_num,c1,b from table_change_lower_to_higher_numeric_group_float order by insert_num
http://git-wip-us.apache.org/repos/asf/hive/blob/244ce09c/ql/src/test/results/clientpositive/tez/tez_join_result_complex.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/tez/tez_join_result_complex.q.out b/ql/src/test/results/clientpositive/tez/tez_join_result_complex.q.out
index 3e3b08c..8640187 100644
--- a/ql/src/test/results/clientpositive/tez/tez_join_result_complex.q.out
+++ b/ql/src/test/results/clientpositive/tez/tez_join_result_complex.q.out
@@ -206,6 +206,8 @@ STAGE PLANS:
#### A masked pattern was here ####
name default.ct_events_clean
numFiles 1
+ numRows 0
+ rawDataSize 0
serialization.ddl struct ct_events_clean { string contact_event_id, string ce_create_dt, string ce_end_dt, string contact_type, string cnctevs_cd, string contact_mode, string cntvnst_stts_cd, i32 total_transfers, list<string> ce_notes}
serialization.format
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
@@ -227,6 +229,8 @@ STAGE PLANS:
#### A masked pattern was here ####
name default.ct_events_clean
numFiles 1
+ numRows 0
+ rawDataSize 0
serialization.ddl struct ct_events_clean { string contact_event_id, string ce_create_dt, string ce_end_dt, string contact_type, string cnctevs_cd, string contact_mode, string cntvnst_stts_cd, i32 total_transfers, list<string> ce_notes}
serialization.format
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
@@ -308,6 +312,8 @@ STAGE PLANS:
#### A masked pattern was here ####
name default.service_request_clean
numFiles 1
+ numRows 0
+ rawDataSize 0
serialization.ddl struct service_request_clean { string cnctevn_id, string svcrqst_id, string svcrqst_crt_dts, i32 subject_seq_no, string plan_component, string cust_segment, string cnctyp_cd, string cnctmd_cd, string cnctevs_cd, string svcrtyp_cd, string svrstyp_cd, string cmpltyp_cd, string catsrsn_cd, string apealvl_cd, string cnstnty_cd, string svcrqst_asrqst_ind, string svcrqst_rtnorig_in, string svcrqst_vwasof_dt, string sum_reason_cd, string sum_reason, string crsr_master_claim_index, list<string> svcrqct_cds, string svcrqst_lupdt, timestamp crsr_lupdt, string cntevsds_lupdt, i32 ignore_me, list<string> notes}
serialization.format
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
@@ -329,6 +335,8 @@ STAGE PLANS:
#### A masked pattern was here ####
name default.service_request_clean
numFiles 1
+ numRows 0
+ rawDataSize 0
serialization.ddl struct service_request_clean { string cnctevn_id, string svcrqst_id, string svcrqst_crt_dts, i32 subject_seq_no, string plan_component, string cust_segment, string cnctyp_cd, string cnctmd_cd, string cnctevs_cd, string svcrtyp_cd, string svrstyp_cd, string cmpltyp_cd, string catsrsn_cd, string apealvl_cd, string cnstnty_cd, string svcrqst_asrqst_ind, string svcrqst_rtnorig_in, string svcrqst_vwasof_dt, string sum_reason_cd, string sum_reason, string crsr_master_claim_index, list<string> svcrqct_cds, string svcrqst_lupdt, timestamp crsr_lupdt, string cntevsds_lupdt, i32 ignore_me, list<string> notes}
serialization.format
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
@@ -1178,6 +1186,8 @@ STAGE PLANS:
#### A masked pattern was here ####
name default.ct_events_clean
numFiles 1
+ numRows 0
+ rawDataSize 0
serialization.ddl struct ct_events_clean { string contact_event_id, string ce_create_dt, string ce_end_dt, string contact_type, string cnctevs_cd, string contact_mode, string cntvnst_stts_cd, i32 total_transfers, list<string> ce_notes}
serialization.format
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
@@ -1199,6 +1209,8 @@ STAGE PLANS:
#### A masked pattern was here ####
name default.ct_events_clean
numFiles 1
+ numRows 0
+ rawDataSize 0
serialization.ddl struct ct_events_clean { string contact_event_id, string ce_create_dt, string ce_end_dt, string contact_type, string cnctevs_cd, string contact_mode, string cntvnst_stts_cd, i32 total_transfers, list<string> ce_notes}
serialization.format
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
@@ -1281,6 +1293,8 @@ STAGE PLANS:
#### A masked pattern was here ####
name default.service_request_clean
numFiles 1
+ numRows 0
+ rawDataSize 0
serialization.ddl struct service_request_clean { string cnctevn_id, string svcrqst_id, string svcrqst_crt_dts, i32 subject_seq_no, string plan_component, string cust_segment, string cnctyp_cd, string cnctmd_cd, string cnctevs_cd, string svcrtyp_cd, string svrstyp_cd, string cmpltyp_cd, string catsrsn_cd, string apealvl_cd, string cnstnty_cd, string svcrqst_asrqst_ind, string svcrqst_rtnorig_in, string svcrqst_vwasof_dt, string sum_reason_cd, string sum_reason, string crsr_master_claim_index, list<string> svcrqct_cds, string svcrqst_lupdt, timestamp crsr_lupdt, string cntevsds_lupdt, i32 ignore_me, list<string> notes}
serialization.format
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
@@ -1302,6 +1316,8 @@ STAGE PLANS:
#### A masked pattern was here ####
name default.service_request_clean
numFiles 1
+ numRows 0
+ rawDataSize 0
serialization.ddl struct service_request_clean { string cnctevn_id, string svcrqst_id, string svcrqst_crt_dts, i32 subject_seq_no, string plan_component, string cust_segment, string cnctyp_cd, string cnctmd_cd, string cnctevs_cd, string svcrtyp_cd, string svrstyp_cd, string cmpltyp_cd, string catsrsn_cd, string apealvl_cd, string cnstnty_cd, string svcrqst_asrqst_ind, string svcrqst_rtnorig_in, string svcrqst_vwasof_dt, string sum_reason_cd, string sum_reason, string crsr_master_claim_index, list<string> svcrqct_cds, string svcrqst_lupdt, timestamp crsr_lupdt, string cntevsds_lupdt, i32 ignore_me, list<string> notes}
serialization.format
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
http://git-wip-us.apache.org/repos/asf/hive/blob/244ce09c/ql/src/test/results/clientpositive/tez/vectorized_ptf.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/tez/vectorized_ptf.q.out b/ql/src/test/results/clientpositive/tez/vectorized_ptf.q.out
index 1365626..0a62262 100644
--- a/ql/src/test/results/clientpositive/tez/vectorized_ptf.q.out
+++ b/ql/src/test/results/clientpositive/tez/vectorized_ptf.q.out
@@ -4652,15 +4652,20 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
+ COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"}
bucket_count -1
columns p_mfgr,p_name,p_size,r,dr,s
columns.comments
columns.types string:string:int:int:int:double
#### A masked pattern was here ####
name default.part_4
+ numFiles 0
+ numRows 0
+ rawDataSize 0
serialization.ddl struct part_4 { string p_mfgr, string p_name, i32 p_size, i32 r, i32 dr, double s}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ totalSize 0
#### A masked pattern was here ####
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.part_4
@@ -4770,15 +4775,20 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
+ COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"}
bucket_count -1
columns p_mfgr,p_name,p_size,s2,r,dr,cud,fv1
columns.comments
columns.types string:string:int:int:int:int:double:int
#### A masked pattern was here ####
name default.part_5
+ numFiles 0
+ numRows 0
+ rawDataSize 0
serialization.ddl struct part_5 { string p_mfgr, string p_name, i32 p_size, i32 s2, i32 r, i32 dr, double cud, i32 fv1}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ totalSize 0
#### A masked pattern was here ####
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.part_5
@@ -4798,15 +4808,20 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
+ COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"}
bucket_count -1
columns p_mfgr,p_name,p_size,r,dr,s
columns.comments
columns.types string:string:int:int:int:double
#### A masked pattern was here ####
name default.part_4
+ numFiles 0
+ numRows 0
+ rawDataSize 0
serialization.ddl struct part_4 { string p_mfgr, string p_name, i32 p_size, i32 r, i32 dr, double s}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ totalSize 0
#### A masked pattern was here ####
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.part_4
@@ -4824,15 +4839,20 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
+ COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"}
bucket_count -1
columns p_mfgr,p_name,p_size,s2,r,dr,cud,fv1
columns.comments
columns.types string:string:int:int:int:int:double:int
#### A masked pattern was here ####
name default.part_5
+ numFiles 0
+ numRows 0
+ rawDataSize 0
serialization.ddl struct part_5 { string p_mfgr, string p_name, i32 p_size, i32 s2, i32 r, i32 dr, double cud, i32 fv1}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ totalSize 0
#### A masked pattern was here ####
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.part_5
http://git-wip-us.apache.org/repos/asf/hive/blob/244ce09c/ql/src/test/results/clientpositive/truncate_column.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/truncate_column.q.out b/ql/src/test/results/clientpositive/truncate_column.q.out
index adbddfa..2efba75 100644
--- a/ql/src/test/results/clientpositive/truncate_column.q.out
+++ b/ql/src/test/results/clientpositive/truncate_column.q.out
@@ -104,6 +104,8 @@ Retention: 0
Table Type: MANAGED_TABLE
Table Parameters:
numFiles 1
+ numRows 10
+ rawDataSize 94
totalSize 150
#### A masked pattern was here ####
@@ -176,6 +178,8 @@ Retention: 0
Table Type: MANAGED_TABLE
Table Parameters:
numFiles 1
+ numRows 10
+ rawDataSize 94
totalSize 75
#### A masked pattern was here ####
@@ -238,6 +242,8 @@ Retention: 0
Table Type: MANAGED_TABLE
Table Parameters:
numFiles 1
+ numRows 10
+ rawDataSize 94
totalSize 75
#### A masked pattern was here ####
@@ -375,6 +381,8 @@ Table Type: MANAGED_TABLE
Table Parameters:
#### A masked pattern was here ####
numFiles 1
+ numRows 10
+ rawDataSize 94
totalSize 150
#### A masked pattern was here ####
@@ -438,6 +446,8 @@ Table Type: MANAGED_TABLE
Table Parameters:
#### A masked pattern was here ####
numFiles 1
+ numRows 10
+ rawDataSize 94
totalSize 75
#### A masked pattern was here ####
@@ -581,6 +591,8 @@ Table: test_tab_part
#### A masked pattern was here ####
Partition Parameters:
numFiles 1
+ numRows 10
+ rawDataSize 94
totalSize 150
#### A masked pattern was here ####
http://git-wip-us.apache.org/repos/asf/hive/blob/244ce09c/ql/src/test/results/clientpositive/truncate_column_list_bucket.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/truncate_column_list_bucket.q.out b/ql/src/test/results/clientpositive/truncate_column_list_bucket.q.out
index 39ffc6c..05ca155 100644
--- a/ql/src/test/results/clientpositive/truncate_column_list_bucket.q.out
+++ b/ql/src/test/results/clientpositive/truncate_column_list_bucket.q.out
@@ -88,8 +88,10 @@ STAGE PLANS:
#### A masked pattern was here ####
name default.test_tab
numFiles 2
+ numRows 500
partition_columns part
partition_columns.types string
+ rawDataSize 4812
serialization.ddl struct test_tab { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe
@@ -118,16 +120,16 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: test_tab
- Statistics: Num rows: 17 Data size: 1761 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 4812 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate: (key = '484') (type: boolean)
- Statistics: Num rows: 8 Data size: 828 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 250 Data size: 2406 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: '484' (type: string), value (type: string), '1' (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 8 Data size: 828 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 250 Data size: 2406 Basic stats: COMPLETE Column stats: NONE
ListSink
PREHOOK: query: SELECT * FROM test_tab WHERE part = '1' AND key = '484'
@@ -166,8 +168,10 @@ STAGE PLANS:
#### A masked pattern was here ####
name default.test_tab
numFiles 2
+ numRows 500
partition_columns part
partition_columns.types string
+ rawDataSize 4812
serialization.ddl struct test_tab { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe
@@ -196,16 +200,16 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: test_tab
- Statistics: Num rows: 17 Data size: 1761 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 4812 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate: (key = '0') (type: boolean)
- Statistics: Num rows: 8 Data size: 828 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 250 Data size: 2406 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: '0' (type: string), value (type: string), '1' (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 8 Data size: 828 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 250 Data size: 2406 Basic stats: COMPLETE Column stats: NONE
ListSink
PREHOOK: query: SELECT * FROM test_tab WHERE part = '1' AND key = '0'