You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by gu...@apache.org on 2013/11/12 19:23:14 UTC
svn commit: r1541190 [10/15] - in /hive/branches/tez: ./
ant/src/org/apache/hadoop/hive/ant/ beeline/
beeline/src/java/org/apache/hive/beeline/ cli/
cli/src/java/org/apache/hadoop/hive/cli/ common/
common/src/java/org/apache/hadoop/hive/common/ common/...
Modified: hive/branches/tez/ql/src/test/results/clientpositive/infer_bucket_sort.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/infer_bucket_sort.q.out?rev=1541190&r1=1541189&r2=1541190&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/infer_bucket_sort.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/infer_bucket_sort.q.out Tue Nov 12 18:23:05 2013
@@ -47,6 +47,7 @@ Table: test_table
Protect Mode: None
#### A masked pattern was here ####
Partition Parameters:
+ COLUMN_STATS_ACCURATE true
numFiles 1
numRows 309
rawDataSize 1482
@@ -105,6 +106,7 @@ Table: test_table
Protect Mode: None
#### A masked pattern was here ####
Partition Parameters:
+ COLUMN_STATS_ACCURATE true
numFiles 1
numRows 309
rawDataSize 1482
@@ -167,6 +169,7 @@ Table: test_table
Protect Mode: None
#### A masked pattern was here ####
Partition Parameters:
+ COLUMN_STATS_ACCURATE true
numFiles 1
numRows 1028
rawDataSize 10968
@@ -233,6 +236,7 @@ Table: test_table
Protect Mode: None
#### A masked pattern was here ####
Partition Parameters:
+ COLUMN_STATS_ACCURATE true
numFiles 1
numRows 1028
rawDataSize 10968
@@ -303,6 +307,7 @@ Table: test_table
Protect Mode: None
#### A masked pattern was here ####
Partition Parameters:
+ COLUMN_STATS_ACCURATE true
numFiles 1
numRows 1028
rawDataSize 4970
@@ -377,6 +382,7 @@ Table: test_table
Protect Mode: None
#### A masked pattern was here ####
Partition Parameters:
+ COLUMN_STATS_ACCURATE true
numFiles 1
numRows 2654
rawDataSize 28466
@@ -455,6 +461,7 @@ Table: test_table
Protect Mode: None
#### A masked pattern was here ####
Partition Parameters:
+ COLUMN_STATS_ACCURATE true
numFiles 1
numRows 2654
rawDataSize 28466
@@ -537,6 +544,7 @@ Table: test_table
Protect Mode: None
#### A masked pattern was here ####
Partition Parameters:
+ COLUMN_STATS_ACCURATE true
numFiles 1
numRows 500
rawDataSize 5312
@@ -623,6 +631,7 @@ Table: test_table
Protect Mode: None
#### A masked pattern was here ####
Partition Parameters:
+ COLUMN_STATS_ACCURATE true
numFiles 1
numRows 500
rawDataSize 5312
@@ -713,6 +722,7 @@ Table: test_table
Protect Mode: None
#### A masked pattern was here ####
Partition Parameters:
+ COLUMN_STATS_ACCURATE true
numFiles 1
numRows 500
rawDataSize 5312
@@ -807,6 +817,7 @@ Table: test_table
Protect Mode: None
#### A masked pattern was here ####
Partition Parameters:
+ COLUMN_STATS_ACCURATE true
numFiles 1
numRows 500
rawDataSize 5312
@@ -905,6 +916,7 @@ Table: test_table
Protect Mode: None
#### A masked pattern was here ####
Partition Parameters:
+ COLUMN_STATS_ACCURATE true
numFiles 1
numRows 500
rawDataSize 5312
@@ -1007,6 +1019,7 @@ Table: test_table
Protect Mode: None
#### A masked pattern was here ####
Partition Parameters:
+ COLUMN_STATS_ACCURATE true
numFiles 1
numRows 1028
rawDataSize 10968
@@ -1113,6 +1126,7 @@ Table: test_table
Protect Mode: None
#### A masked pattern was here ####
Partition Parameters:
+ COLUMN_STATS_ACCURATE true
numFiles 1
numRows 1028
rawDataSize 10968
@@ -1223,6 +1237,7 @@ Table: test_table
Protect Mode: None
#### A masked pattern was here ####
Partition Parameters:
+ COLUMN_STATS_ACCURATE true
numFiles 1
numRows 309
rawDataSize 1482
@@ -1337,6 +1352,7 @@ Table: test_table
Protect Mode: None
#### A masked pattern was here ####
Partition Parameters:
+ COLUMN_STATS_ACCURATE true
numFiles 1
numRows 309
rawDataSize 1482
@@ -1455,6 +1471,7 @@ Table: test_table
Protect Mode: None
#### A masked pattern was here ####
Partition Parameters:
+ COLUMN_STATS_ACCURATE true
numFiles 1
numRows 6
rawDataSize 18
@@ -1577,6 +1594,7 @@ Table: test_table
Protect Mode: None
#### A masked pattern was here ####
Partition Parameters:
+ COLUMN_STATS_ACCURATE true
numFiles 1
numRows 6
rawDataSize 18
@@ -1703,6 +1721,7 @@ Table: test_table
Protect Mode: None
#### A masked pattern was here ####
Partition Parameters:
+ COLUMN_STATS_ACCURATE true
numFiles 1
numRows 618
rawDataSize 2964
@@ -1835,6 +1854,7 @@ Table: test_table
Protect Mode: None
#### A masked pattern was here ####
Partition Parameters:
+ COLUMN_STATS_ACCURATE true
numFiles 1
numRows 5
rawDataSize 19
@@ -1971,6 +1991,7 @@ Table: test_table
Protect Mode: None
#### A masked pattern was here ####
Partition Parameters:
+ COLUMN_STATS_ACCURATE true
numFiles 1
numRows 309
rawDataSize 1482
@@ -2109,6 +2130,7 @@ Table: test_table
Protect Mode: None
#### A masked pattern was here ####
Partition Parameters:
+ COLUMN_STATS_ACCURATE true
numFiles 1
numRows 309
rawDataSize 1482
@@ -2251,6 +2273,7 @@ Table: test_table
Protect Mode: None
#### A masked pattern was here ####
Partition Parameters:
+ COLUMN_STATS_ACCURATE true
numFiles 1
numRows 309
rawDataSize 1482
@@ -2397,6 +2420,7 @@ Table: test_table
Protect Mode: None
#### A masked pattern was here ####
Partition Parameters:
+ COLUMN_STATS_ACCURATE true
numFiles 1
numRows 309
rawDataSize 1482
@@ -2547,6 +2571,7 @@ Table: test_table
Protect Mode: None
#### A masked pattern was here ####
Partition Parameters:
+ COLUMN_STATS_ACCURATE true
numFiles 1
numRows 309
rawDataSize 3582
Modified: hive/branches/tez/ql/src/test/results/clientpositive/infer_bucket_sort_bucketed_table.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/infer_bucket_sort_bucketed_table.q.out?rev=1541190&r1=1541189&r2=1541190&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/infer_bucket_sort_bucketed_table.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/infer_bucket_sort_bucketed_table.q.out Tue Nov 12 18:23:05 2013
@@ -49,6 +49,7 @@ Table: test_table_bucketed
Protect Mode: None
#### A masked pattern was here ####
Partition Parameters:
+ COLUMN_STATS_ACCURATE true
numFiles 3
numRows 0
rawDataSize 0
Modified: hive/branches/tez/ql/src/test/results/clientpositive/infer_bucket_sort_convert_join.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/infer_bucket_sort_convert_join.q.out?rev=1541190&r1=1541189&r2=1541190&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/infer_bucket_sort_convert_join.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/infer_bucket_sort_convert_join.q.out Tue Nov 12 18:23:05 2013
@@ -49,6 +49,7 @@ Table: test_table
Protect Mode: None
#### A masked pattern was here ####
Partition Parameters:
+ COLUMN_STATS_ACCURATE true
numFiles 1
numRows 1028
rawDataSize 10968
@@ -123,6 +124,7 @@ Table: test_table
Protect Mode: None
#### A masked pattern was here ####
Partition Parameters:
+ COLUMN_STATS_ACCURATE true
numFiles 1
numRows 1028
rawDataSize 10968
Modified: hive/branches/tez/ql/src/test/results/clientpositive/infer_bucket_sort_dyn_part.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/infer_bucket_sort_dyn_part.q.out?rev=1541190&r1=1541189&r2=1541190&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/infer_bucket_sort_dyn_part.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/infer_bucket_sort_dyn_part.q.out Tue Nov 12 18:23:05 2013
@@ -71,6 +71,7 @@ Table: test_table
Protect Mode: None
#### A masked pattern was here ####
Partition Parameters:
+ COLUMN_STATS_ACCURATE true
numFiles 1
numRows 0
rawDataSize 0
@@ -114,6 +115,7 @@ Table: test_table
Protect Mode: None
#### A masked pattern was here ####
Partition Parameters:
+ COLUMN_STATS_ACCURATE true
numFiles 1
numRows 0
rawDataSize 0
@@ -194,6 +196,7 @@ Table: test_table
Protect Mode: None
#### A masked pattern was here ####
Partition Parameters:
+ COLUMN_STATS_ACCURATE true
numFiles 1
numRows 0
rawDataSize 0
@@ -241,6 +244,7 @@ Table: test_table
Protect Mode: None
#### A masked pattern was here ####
Partition Parameters:
+ COLUMN_STATS_ACCURATE true
numFiles 1
numRows 0
rawDataSize 0
@@ -329,6 +333,7 @@ Table: test_table
Protect Mode: None
#### A masked pattern was here ####
Partition Parameters:
+ COLUMN_STATS_ACCURATE true
numFiles 1
numRows 0
rawDataSize 0
@@ -380,6 +385,7 @@ Table: test_table
Protect Mode: None
#### A masked pattern was here ####
Partition Parameters:
+ COLUMN_STATS_ACCURATE true
numFiles 1
numRows 0
rawDataSize 0
@@ -809,6 +815,7 @@ Table: test_table
Protect Mode: None
#### A masked pattern was here ####
Partition Parameters:
+ COLUMN_STATS_ACCURATE true
numFiles 1
numRows 0
rawDataSize 0
@@ -868,6 +875,7 @@ Table: test_table
Protect Mode: None
#### A masked pattern was here ####
Partition Parameters:
+ COLUMN_STATS_ACCURATE true
numFiles 2
numRows 0
rawDataSize 0
Modified: hive/branches/tez/ql/src/test/results/clientpositive/infer_bucket_sort_grouping_operators.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/infer_bucket_sort_grouping_operators.q.out?rev=1541190&r1=1541189&r2=1541190&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/infer_bucket_sort_grouping_operators.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/infer_bucket_sort_grouping_operators.q.out Tue Nov 12 18:23:05 2013
@@ -166,6 +166,7 @@ Table: test_table_out
Protect Mode: None
#### A masked pattern was here ####
Partition Parameters:
+ COLUMN_STATS_ACCURATE true
numFiles 1
numRows 619
rawDataSize 6309
@@ -234,6 +235,7 @@ Table: test_table_out_2
Protect Mode: None
#### A masked pattern was here ####
Partition Parameters:
+ COLUMN_STATS_ACCURATE true
numFiles 1
numRows 619
rawDataSize 7547
@@ -421,6 +423,7 @@ Table: test_table_out
Protect Mode: None
#### A masked pattern was here ####
Partition Parameters:
+ COLUMN_STATS_ACCURATE true
numFiles 1
numRows 928
rawDataSize 9954
@@ -503,6 +506,7 @@ Table: test_table_out_2
Protect Mode: None
#### A masked pattern was here ####
Partition Parameters:
+ COLUMN_STATS_ACCURATE true
numFiles 1
numRows 928
rawDataSize 11810
@@ -711,6 +715,7 @@ Table: test_table_out
Protect Mode: None
#### A masked pattern was here ####
Partition Parameters:
+ COLUMN_STATS_ACCURATE true
numFiles 1
numRows 618
rawDataSize 6054
@@ -807,6 +812,7 @@ Table: test_table_out_2
Protect Mode: None
#### A masked pattern was here ####
Partition Parameters:
+ COLUMN_STATS_ACCURATE true
numFiles 1
numRows 618
rawDataSize 7290
Modified: hive/branches/tez/ql/src/test/results/clientpositive/infer_bucket_sort_map_operators.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/infer_bucket_sort_map_operators.q.out?rev=1541190&r1=1541189&r2=1541190&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/infer_bucket_sort_map_operators.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/infer_bucket_sort_map_operators.q.out Tue Nov 12 18:23:05 2013
@@ -216,6 +216,7 @@ Table: test_table_out
Protect Mode: None
#### A masked pattern was here ####
Partition Parameters:
+ COLUMN_STATS_ACCURATE true
numFiles 1
numRows 0
rawDataSize 0
@@ -424,6 +425,7 @@ Table: test_table_out
Protect Mode: None
#### A masked pattern was here ####
Partition Parameters:
+ COLUMN_STATS_ACCURATE true
numFiles 1
numRows 0
rawDataSize 0
@@ -617,6 +619,7 @@ Table: test_table_out
Protect Mode: None
#### A masked pattern was here ####
Partition Parameters:
+ COLUMN_STATS_ACCURATE true
numFiles 1
numRows 0
rawDataSize 0
@@ -808,6 +811,7 @@ Table: test_table_out
Protect Mode: None
#### A masked pattern was here ####
Partition Parameters:
+ COLUMN_STATS_ACCURATE true
numFiles 1
numRows 0
rawDataSize 0
Modified: hive/branches/tez/ql/src/test/results/clientpositive/infer_bucket_sort_merge.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/infer_bucket_sort_merge.q.out?rev=1541190&r1=1541189&r2=1541190&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/infer_bucket_sort_merge.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/infer_bucket_sort_merge.q.out Tue Nov 12 18:23:05 2013
@@ -49,6 +49,7 @@ Table: test_table
Protect Mode: None
#### A masked pattern was here ####
Partition Parameters:
+ COLUMN_STATS_ACCURATE true
numFiles 1
numRows 0
rawDataSize 0
@@ -107,6 +108,7 @@ Table: test_table
Protect Mode: None
#### A masked pattern was here ####
Partition Parameters:
+ COLUMN_STATS_ACCURATE true
numFiles 2
numRows 0
rawDataSize 0
Modified: hive/branches/tez/ql/src/test/results/clientpositive/infer_bucket_sort_multi_insert.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/infer_bucket_sort_multi_insert.q.out?rev=1541190&r1=1541189&r2=1541190&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/infer_bucket_sort_multi_insert.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/infer_bucket_sort_multi_insert.q.out Tue Nov 12 18:23:05 2013
@@ -59,6 +59,7 @@ Table: test_table
Protect Mode: None
#### A masked pattern was here ####
Partition Parameters:
+ COLUMN_STATS_ACCURATE true
numFiles 1
numRows 500
rawDataSize 5312
@@ -101,6 +102,7 @@ Table: test_table
Protect Mode: None
#### A masked pattern was here ####
Partition Parameters:
+ COLUMN_STATS_ACCURATE true
numFiles 1
numRows 500
rawDataSize 5312
@@ -173,6 +175,7 @@ Table: test_table
Protect Mode: None
#### A masked pattern was here ####
Partition Parameters:
+ COLUMN_STATS_ACCURATE true
numFiles 1
numRows 309
rawDataSize 1482
@@ -219,6 +222,7 @@ Table: test_table
Protect Mode: None
#### A masked pattern was here ####
Partition Parameters:
+ COLUMN_STATS_ACCURATE true
numFiles 1
numRows 309
rawDataSize 2718
@@ -299,6 +303,7 @@ Table: test_table
Protect Mode: None
#### A masked pattern was here ####
Partition Parameters:
+ COLUMN_STATS_ACCURATE true
numFiles 1
numRows 309
rawDataSize 1482
@@ -349,6 +354,7 @@ Table: test_table
Protect Mode: None
#### A masked pattern was here ####
Partition Parameters:
+ COLUMN_STATS_ACCURATE true
numFiles 1
numRows 500
rawDataSize 5312
@@ -437,6 +443,7 @@ Table: test_table
Protect Mode: None
#### A masked pattern was here ####
Partition Parameters:
+ COLUMN_STATS_ACCURATE true
numFiles 1
numRows 309
rawDataSize 1482
@@ -491,6 +498,7 @@ Table: test_table
Protect Mode: None
#### A masked pattern was here ####
Partition Parameters:
+ COLUMN_STATS_ACCURATE true
numFiles 1
numRows 309
rawDataSize 2690
Modified: hive/branches/tez/ql/src/test/results/clientpositive/infer_bucket_sort_num_buckets.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/infer_bucket_sort_num_buckets.q.out?rev=1541190&r1=1541189&r2=1541190&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/infer_bucket_sort_num_buckets.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/infer_bucket_sort_num_buckets.q.out Tue Nov 12 18:23:05 2013
@@ -164,6 +164,7 @@ Table: test_table
Protect Mode: None
#### A masked pattern was here ####
Partition Parameters:
+ COLUMN_STATS_ACCURATE true
numFiles 2
numRows 0
rawDataSize 0
@@ -207,6 +208,7 @@ Table: test_table
Protect Mode: None
#### A masked pattern was here ####
Partition Parameters:
+ COLUMN_STATS_ACCURATE true
numFiles 1
numRows 0
rawDataSize 0
Modified: hive/branches/tez/ql/src/test/results/clientpositive/infer_bucket_sort_reducers_power_two.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/infer_bucket_sort_reducers_power_two.q.out?rev=1541190&r1=1541189&r2=1541190&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/infer_bucket_sort_reducers_power_two.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/infer_bucket_sort_reducers_power_two.q.out Tue Nov 12 18:23:05 2013
@@ -49,6 +49,7 @@ Table: test_table
Protect Mode: None
#### A masked pattern was here ####
Partition Parameters:
+ COLUMN_STATS_ACCURATE true
numFiles 4
numRows 0
rawDataSize 0
@@ -107,6 +108,7 @@ Table: test_table
Protect Mode: None
#### A masked pattern was here ####
Partition Parameters:
+ COLUMN_STATS_ACCURATE true
numFiles 4
numRows 0
rawDataSize 0
@@ -169,6 +171,7 @@ Table: test_table
Protect Mode: None
#### A masked pattern was here ####
Partition Parameters:
+ COLUMN_STATS_ACCURATE true
numFiles 4
numRows 0
rawDataSize 0
@@ -235,6 +238,7 @@ Table: test_table
Protect Mode: None
#### A masked pattern was here ####
Partition Parameters:
+ COLUMN_STATS_ACCURATE true
numFiles 4
numRows 0
rawDataSize 0
@@ -305,6 +309,7 @@ Table: test_table
Protect Mode: None
#### A masked pattern was here ####
Partition Parameters:
+ COLUMN_STATS_ACCURATE true
numFiles 16
numRows 0
rawDataSize 0
@@ -381,6 +386,7 @@ Table: test_table
Protect Mode: None
#### A masked pattern was here ####
Partition Parameters:
+ COLUMN_STATS_ACCURATE true
numFiles 1
numRows 0
rawDataSize 0
Modified: hive/branches/tez/ql/src/test/results/clientpositive/input23.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/input23.q.out?rev=1541190&r1=1541189&r2=1541190&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/input23.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/input23.q.out Tue Nov 12 18:23:05 2013
@@ -64,6 +64,7 @@ STAGE PLANS:
ds 2008-04-08
hr 11
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value
columns.types string:string
Modified: hive/branches/tez/ql/src/test/results/clientpositive/input42.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/input42.q.out?rev=1541190&r1=1541189&r2=1541190&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/input42.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/input42.q.out Tue Nov 12 18:23:05 2013
@@ -59,6 +59,7 @@ STAGE PLANS:
ds 2008-04-08
hr 11
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value
columns.types string:string
@@ -100,6 +101,7 @@ STAGE PLANS:
ds 2008-04-08
hr 12
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value
columns.types string:string
@@ -1242,6 +1244,7 @@ STAGE PLANS:
ds 2008-04-08
hr 11
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value
columns.types string:string
@@ -1283,6 +1286,7 @@ STAGE PLANS:
ds 2008-04-08
hr 12
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value
columns.types string:string
@@ -1803,6 +1807,7 @@ STAGE PLANS:
ds 2008-04-08
hr 11
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value
columns.types string:string
@@ -1844,6 +1849,7 @@ STAGE PLANS:
ds 2008-04-08
hr 12
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value
columns.types string:string
Modified: hive/branches/tez/ql/src/test/results/clientpositive/input_part1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/input_part1.q.out?rev=1541190&r1=1541189&r2=1541190&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/input_part1.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/input_part1.q.out Tue Nov 12 18:23:05 2013
@@ -84,6 +84,7 @@ STAGE PLANS:
ds 2008-04-08
hr 12
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value
columns.types string:string
Modified: hive/branches/tez/ql/src/test/results/clientpositive/input_part2.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/input_part2.q.out?rev=1541190&r1=1541189&r2=1541190&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/input_part2.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/input_part2.q.out Tue Nov 12 18:23:05 2013
@@ -138,6 +138,7 @@ STAGE PLANS:
ds 2008-04-08
hr 12
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value
columns.types string:string
@@ -179,6 +180,7 @@ STAGE PLANS:
ds 2008-04-09
hr 12
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value
columns.types string:string
Modified: hive/branches/tez/ql/src/test/results/clientpositive/input_part7.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/input_part7.q.out?rev=1541190&r1=1541189&r2=1541190&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/input_part7.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/input_part7.q.out Tue Nov 12 18:23:05 2013
@@ -143,6 +143,7 @@ STAGE PLANS:
ds 2008-04-08
hr 11
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value
columns.types string:string
@@ -184,6 +185,7 @@ STAGE PLANS:
ds 2008-04-08
hr 12
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value
columns.types string:string
Modified: hive/branches/tez/ql/src/test/results/clientpositive/input_part9.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/input_part9.q.out?rev=1541190&r1=1541189&r2=1541190&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/input_part9.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/input_part9.q.out Tue Nov 12 18:23:05 2013
@@ -64,6 +64,7 @@ STAGE PLANS:
ds 2008-04-08
hr 11
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value
columns.types string:string
@@ -105,6 +106,7 @@ STAGE PLANS:
ds 2008-04-08
hr 12
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value
columns.types string:string
Modified: hive/branches/tez/ql/src/test/results/clientpositive/join17.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/join17.q.out?rev=1541190&r1=1541189&r2=1541190&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/join17.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/join17.q.out Tue Nov 12 18:23:05 2013
@@ -68,6 +68,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value
columns.types string:string
@@ -86,6 +87,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value
columns.types string:string
Modified: hive/branches/tez/ql/src/test/results/clientpositive/join26.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/join26.q.out?rev=1541190&r1=1541189&r2=1541190&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/join26.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/join26.q.out Tue Nov 12 18:23:05 2013
@@ -140,6 +140,7 @@ STAGE PLANS:
ds 2008-04-08
hr 11
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value
columns.types string:string
Modified: hive/branches/tez/ql/src/test/results/clientpositive/join32.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/join32.q.out?rev=1541190&r1=1541189&r2=1541190&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/join32.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/join32.q.out Tue Nov 12 18:23:05 2013
@@ -47,6 +47,7 @@ STAGE PLANS:
ds 2008-04-08
hr 11
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value
columns.types string:string
@@ -182,6 +183,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value
columns.types string:string
@@ -200,6 +202,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value
columns.types string:string
@@ -222,6 +225,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value
columns.types string:string
@@ -240,6 +244,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value
columns.types string:string
@@ -265,6 +270,7 @@ STAGE PLANS:
ds 2008-04-08
hr 11
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value
columns.types string:string
Modified: hive/branches/tez/ql/src/test/results/clientpositive/join32_lessSize.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/join32_lessSize.q.out?rev=1541190&r1=1541189&r2=1541190&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/join32_lessSize.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/join32_lessSize.q.out Tue Nov 12 18:23:05 2013
@@ -104,6 +104,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value
columns.types string:string
@@ -122,6 +123,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value
columns.types string:string
@@ -144,6 +146,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value
columns.types string:string
@@ -162,6 +165,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value
columns.types string:string
@@ -196,6 +200,7 @@ STAGE PLANS:
ds 2008-04-08
hr 11
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value
columns.types string:string
@@ -328,6 +333,7 @@ STAGE PLANS:
ds 2008-04-08
hr 11
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value
columns.types string:string
@@ -612,6 +618,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value
columns.types string:string
@@ -630,6 +637,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value
columns.types string:string
@@ -652,6 +660,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value
columns.types string:string
@@ -670,6 +679,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value
columns.types string:string
@@ -773,6 +783,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value,val2
columns.types string:string:string
@@ -822,6 +833,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value
columns.types string:string
@@ -840,6 +852,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value
columns.types string:string
@@ -862,6 +875,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value
columns.types string:string
@@ -880,6 +894,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value
columns.types string:string
@@ -908,6 +923,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value,val2
columns.types string:string:string
@@ -1010,6 +1026,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value,val2
columns.types string:string:string
@@ -1059,6 +1076,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value
columns.types string:string
@@ -1077,6 +1095,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value
columns.types string:string
@@ -1099,6 +1118,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value
columns.types string:string
@@ -1117,6 +1137,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value
columns.types string:string
@@ -1217,6 +1238,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value,val2
columns.types string:string:string
@@ -1266,6 +1288,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value
columns.types string:string
@@ -1284,6 +1307,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value
columns.types string:string
@@ -1306,6 +1330,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value
columns.types string:string
@@ -1324,6 +1349,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value
columns.types string:string
@@ -1422,6 +1448,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value
columns.types string:string
@@ -1440,6 +1467,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value
columns.types string:string
@@ -1462,6 +1490,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value
columns.types string:string
@@ -1480,6 +1509,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value
columns.types string:string
@@ -1531,6 +1561,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value,val2
columns.types string:string:string
@@ -1779,6 +1810,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value
columns.types string:string
@@ -1797,6 +1829,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value
columns.types string:string
@@ -1819,6 +1852,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value
columns.types string:string
@@ -1837,6 +1871,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value
columns.types string:string
@@ -1871,6 +1906,7 @@ STAGE PLANS:
ds 2008-04-08
hr 11
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value
columns.types string:string
@@ -2003,6 +2039,7 @@ STAGE PLANS:
ds 2008-04-08
hr 11
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value
columns.types string:string
@@ -2304,6 +2341,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value
columns.types string:string
@@ -2322,6 +2360,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value
columns.types string:string
@@ -2344,6 +2383,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value
columns.types string:string
@@ -2362,6 +2402,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value
columns.types string:string
@@ -2396,6 +2437,7 @@ STAGE PLANS:
ds 2008-04-08
hr 11
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value
columns.types string:string
@@ -2480,6 +2522,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value,val2
columns.types string:string:string
@@ -2532,6 +2575,7 @@ STAGE PLANS:
ds 2008-04-08
hr 11
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value
columns.types string:string
@@ -2576,6 +2620,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value,val2
columns.types string:string:string
@@ -2597,6 +2642,7 @@ STAGE PLANS:
Stats-Aggr Operator
#### A masked pattern was here ####
+
PREHOOK: query: INSERT OVERWRITE TABLE dest_j2
SELECT res.key, z.value, res.value
FROM (select x.key, x.value from src1 x LEFT OUTER JOIN src y ON (x.key = y.key)) res
Modified: hive/branches/tez/ql/src/test/results/clientpositive/join33.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/join33.q.out?rev=1541190&r1=1541189&r2=1541190&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/join33.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/join33.q.out Tue Nov 12 18:23:05 2013
@@ -47,6 +47,7 @@ STAGE PLANS:
ds 2008-04-08
hr 11
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value
columns.types string:string
@@ -182,6 +183,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value
columns.types string:string
@@ -200,6 +202,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value
columns.types string:string
@@ -222,6 +225,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value
columns.types string:string
@@ -240,6 +244,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value
columns.types string:string
@@ -265,6 +270,7 @@ STAGE PLANS:
ds 2008-04-08
hr 11
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value
columns.types string:string
Modified: hive/branches/tez/ql/src/test/results/clientpositive/join34.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/join34.q.out?rev=1541190&r1=1541189&r2=1541190&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/join34.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/join34.q.out Tue Nov 12 18:23:05 2013
@@ -196,6 +196,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value
columns.types string:string
@@ -214,6 +215,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value
columns.types string:string
@@ -236,6 +238,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value
columns.types string:string
@@ -254,6 +257,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value
columns.types string:string
Modified: hive/branches/tez/ql/src/test/results/clientpositive/join35.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/join35.q.out?rev=1541190&r1=1541189&r2=1541190&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/join35.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/join35.q.out Tue Nov 12 18:23:05 2013
@@ -90,6 +90,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value
columns.types string:string
@@ -108,6 +109,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value
columns.types string:string
@@ -338,6 +340,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value
columns.types string:string
@@ -356,6 +359,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value
columns.types string:string
@@ -541,6 +545,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value
columns.types string:string
@@ -559,6 +564,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value
columns.types string:string
@@ -680,6 +686,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value
columns.types string:string
@@ -698,6 +705,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value
columns.types string:string
@@ -808,6 +816,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value
columns.types string:string
@@ -826,6 +835,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value
columns.types string:string
Modified: hive/branches/tez/ql/src/test/results/clientpositive/join9.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/join9.q.out?rev=1541190&r1=1541189&r2=1541190&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/join9.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/join9.q.out Tue Nov 12 18:23:05 2013
@@ -64,6 +64,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value
columns.types string:string
@@ -82,6 +83,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value
columns.types string:string
@@ -107,6 +109,7 @@ STAGE PLANS:
ds 2008-04-08
hr 12
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value
columns.types string:string
Modified: hive/branches/tez/ql/src/test/results/clientpositive/join_filters_overlap.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/join_filters_overlap.q.out?rev=1541190&r1=1541189&r2=1541190&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/join_filters_overlap.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/join_filters_overlap.q.out Tue Nov 12 18:23:05 2013
@@ -99,6 +99,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value
columns.types int:int
@@ -117,6 +118,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value
columns.types int:int
@@ -306,6 +308,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value
columns.types int:int
@@ -324,6 +327,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value
columns.types int:int
@@ -513,6 +517,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value
columns.types int:int
@@ -531,6 +536,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value
columns.types int:int
@@ -738,6 +744,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value
columns.types int:int
@@ -756,6 +763,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value
columns.types int:int
@@ -967,6 +975,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value
columns.types int:int
@@ -985,6 +994,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value
columns.types int:int
Modified: hive/branches/tez/ql/src/test/results/clientpositive/join_map_ppr.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/join_map_ppr.q.out?rev=1541190&r1=1541189&r2=1541190&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/join_map_ppr.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/join_map_ppr.q.out Tue Nov 12 18:23:05 2013
@@ -142,6 +142,7 @@ STAGE PLANS:
ds 2008-04-08
hr 11
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value
columns.types string:string
@@ -658,6 +659,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value,val2
columns.types string:string:string
@@ -690,6 +692,7 @@ STAGE PLANS:
ds 2008-04-08
hr 11
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value
columns.types string:string
@@ -743,6 +746,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value,val2
columns.types string:string:string
@@ -779,6 +783,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value,val2
columns.types string:string:string
@@ -806,6 +811,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value,val2
columns.types string:string:string
@@ -824,6 +830,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value,val2
columns.types string:string:string
@@ -858,6 +865,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value,val2
columns.types string:string:string
@@ -885,6 +893,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value,val2
columns.types string:string:string
@@ -903,6 +912,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value,val2
columns.types string:string:string
Modified: hive/branches/tez/ql/src/test/results/clientpositive/limit_pushdown.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/limit_pushdown.q.out?rev=1541190&r1=1541189&r2=1541190&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/limit_pushdown.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/limit_pushdown.q.out Tue Nov 12 18:23:05 2013
@@ -392,14 +392,14 @@ val_129 130.0
val_131 132.0
PREHOOK: query: -- distincts
explain
-select distinct(key) from src limit 20
+select distinct(cdouble) from alltypesorc limit 20
PREHOOK: type: QUERY
POSTHOOK: query: -- distincts
explain
-select distinct(key) from src limit 20
+select distinct(cdouble) from alltypesorc limit 20
POSTHOOK: type: QUERY
ABSTRACT SYNTAX TREE:
- (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECTDI (TOK_SELEXPR (TOK_TABLE_OR_COL key))) (TOK_LIMIT 20)))
+ (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME alltypesorc))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECTDI (TOK_SELEXPR (TOK_TABLE_OR_COL cdouble))) (TOK_LIMIT 20)))
STAGE DEPENDENCIES:
Stage-1 is a root stage
@@ -409,29 +409,29 @@ STAGE PLANS:
Stage: Stage-1
Map Reduce
Alias -> Map Operator Tree:
- src
+ alltypesorc
TableScan
- alias: src
+ alias: alltypesorc
Select Operator
expressions:
- expr: key
- type: string
- outputColumnNames: key
+ expr: cdouble
+ type: double
+ outputColumnNames: cdouble
Group By Operator
bucketGroup: false
keys:
- expr: key
- type: string
+ expr: cdouble
+ type: double
mode: hash
outputColumnNames: _col0
Reduce Output Operator
key expressions:
expr: _col0
- type: string
+ type: double
sort order: +
Map-reduce partition columns:
expr: _col0
- type: string
+ type: double
tag: -1
TopN: 20
TopN Hash Memory Usage: 0.3
@@ -440,13 +440,13 @@ STAGE PLANS:
bucketGroup: false
keys:
expr: KEY._col0
- type: string
+ type: double
mode: mergepartial
outputColumnNames: _col0
Select Operator
expressions:
expr: _col0
- type: string
+ type: double
outputColumnNames: _col0
Limit
File Output Operator
@@ -462,42 +462,42 @@ STAGE PLANS:
limit: 20
-PREHOOK: query: select distinct(key) from src limit 20
+PREHOOK: query: select distinct(cdouble) from alltypesorc limit 20
PREHOOK: type: QUERY
-PREHOOK: Input: default@src
+PREHOOK: Input: default@alltypesorc
#### A masked pattern was here ####
-POSTHOOK: query: select distinct(key) from src limit 20
+POSTHOOK: query: select distinct(cdouble) from alltypesorc limit 20
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@src
+POSTHOOK: Input: default@alltypesorc
#### A masked pattern was here ####
-0
-10
-100
-103
-104
-105
-11
-111
-113
-114
-116
-118
-119
-12
-120
-125
-126
-128
-129
-131
+NULL
+-16379.0
+-16373.0
+-16372.0
+-16369.0
+-16355.0
+-16339.0
+-16324.0
+-16311.0
+-16310.0
+-16309.0
+-16307.0
+-16306.0
+-16305.0
+-16300.0
+-16296.0
+-16280.0
+-16277.0
+-16274.0
+-16269.0
PREHOOK: query: explain
-select key, count(distinct(key)) from src group by key limit 20
+select ctinyint, count(distinct(cdouble)) from alltypesorc group by ctinyint limit 20
PREHOOK: type: QUERY
POSTHOOK: query: explain
-select key, count(distinct(key)) from src group by key limit 20
+select ctinyint, count(distinct(cdouble)) from alltypesorc group by ctinyint limit 20
POSTHOOK: type: QUERY
ABSTRACT SYNTAX TREE:
- (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TABLE_OR_COL key)) (TOK_SELEXPR (TOK_FUNCTIONDI count (TOK_TABLE_OR_COL key)))) (TOK_GROUPBY (TOK_TABLE_OR_COL key)) (TOK_LIMIT 20)))
+ (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME alltypesorc))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TABLE_OR_COL ctinyint)) (TOK_SELEXPR (TOK_FUNCTIONDI count (TOK_TABLE_OR_COL cdouble)))) (TOK_GROUPBY (TOK_TABLE_OR_COL ctinyint)) (TOK_LIMIT 20)))
STAGE DEPENDENCIES:
Stage-1 is a root stage
@@ -507,36 +507,42 @@ STAGE PLANS:
Stage: Stage-1
Map Reduce
Alias -> Map Operator Tree:
- src
+ alltypesorc
TableScan
- alias: src
+ alias: alltypesorc
Select Operator
expressions:
- expr: key
- type: string
- outputColumnNames: key
+ expr: ctinyint
+ type: tinyint
+ expr: cdouble
+ type: double
+ outputColumnNames: ctinyint, cdouble
Group By Operator
aggregations:
- expr: count(DISTINCT key)
+ expr: count(DISTINCT cdouble)
bucketGroup: false
keys:
- expr: key
- type: string
+ expr: ctinyint
+ type: tinyint
+ expr: cdouble
+ type: double
mode: hash
- outputColumnNames: _col0, _col1
+ outputColumnNames: _col0, _col1, _col2
Reduce Output Operator
key expressions:
expr: _col0
- type: string
+ type: tinyint
+ expr: _col1
+ type: double
sort order: ++
Map-reduce partition columns:
expr: _col0
- type: string
+ type: tinyint
tag: -1
TopN: 20
TopN Hash Memory Usage: 0.3
value expressions:
- expr: _col1
+ expr: _col2
type: bigint
Reduce Operator Tree:
Group By Operator
@@ -545,13 +551,13 @@ STAGE PLANS:
bucketGroup: false
keys:
expr: KEY._col0
- type: string
+ type: tinyint
mode: mergepartial
outputColumnNames: _col0, _col1
Select Operator
expressions:
expr: _col0
- type: string
+ type: tinyint
expr: _col1
type: bigint
outputColumnNames: _col0, _col1
@@ -569,34 +575,161 @@ STAGE PLANS:
limit: 20
-PREHOOK: query: select key, count(distinct(key)) from src group by key limit 20
+PREHOOK: query: select ctinyint, count(distinct(cdouble)) from alltypesorc group by ctinyint limit 20
PREHOOK: type: QUERY
-PREHOOK: Input: default@src
+PREHOOK: Input: default@alltypesorc
#### A masked pattern was here ####
-POSTHOOK: query: select key, count(distinct(key)) from src group by key limit 20
+POSTHOOK: query: select ctinyint, count(distinct(cdouble)) from alltypesorc group by ctinyint limit 20
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@src
+POSTHOOK: Input: default@alltypesorc
+#### A masked pattern was here ####
+NULL 2932
+-64 24
+-63 19
+-62 27
+-61 25
+-60 27
+-59 31
+-58 23
+-57 35
+-56 36
+-55 29
+-54 26
+-53 22
+-52 33
+-51 21
+-50 30
+-49 26
+-48 29
+-47 22
+-46 24
+PREHOOK: query: -- multi distinct
+explain
+select ctinyint, count(distinct(cstring1)), count(distinct(cstring2)) from alltypesorc group by ctinyint limit 20
+PREHOOK: type: QUERY
+POSTHOOK: query: -- multi distinct
+explain
+select ctinyint, count(distinct(cstring1)), count(distinct(cstring2)) from alltypesorc group by ctinyint limit 20
+POSTHOOK: type: QUERY
+ABSTRACT SYNTAX TREE:
+ (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME alltypesorc))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TABLE_OR_COL ctinyint)) (TOK_SELEXPR (TOK_FUNCTIONDI count (TOK_TABLE_OR_COL cstring1))) (TOK_SELEXPR (TOK_FUNCTIONDI count (TOK_TABLE_OR_COL cstring2)))) (TOK_GROUPBY (TOK_TABLE_OR_COL ctinyint)) (TOK_LIMIT 20)))
+
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 is a root stage
+
+STAGE PLANS:
+ Stage: Stage-1
+ Map Reduce
+ Alias -> Map Operator Tree:
+ alltypesorc
+ TableScan
+ alias: alltypesorc
+ Select Operator
+ expressions:
+ expr: ctinyint
+ type: tinyint
+ expr: cstring1
+ type: string
+ expr: cstring2
+ type: string
+ outputColumnNames: ctinyint, cstring1, cstring2
+ Group By Operator
+ aggregations:
+ expr: count(DISTINCT cstring1)
+ expr: count(DISTINCT cstring2)
+ bucketGroup: false
+ keys:
+ expr: ctinyint
+ type: tinyint
+ expr: cstring1
+ type: string
+ expr: cstring2
+ type: string
+ mode: hash
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4
+ Reduce Output Operator
+ key expressions:
+ expr: _col0
+ type: tinyint
+ expr: _col1
+ type: string
+ expr: _col2
+ type: string
+ sort order: +++
+ Map-reduce partition columns:
+ expr: _col0
+ type: tinyint
+ tag: -1
+ TopN: 20
+ TopN Hash Memory Usage: 0.3
+ value expressions:
+ expr: _col3
+ type: bigint
+ expr: _col4
+ type: bigint
+ Reduce Operator Tree:
+ Group By Operator
+ aggregations:
+ expr: count(DISTINCT KEY._col1:0._col0)
+ expr: count(DISTINCT KEY._col1:1._col0)
+ bucketGroup: false
+ keys:
+ expr: KEY._col0
+ type: tinyint
+ mode: mergepartial
+ outputColumnNames: _col0, _col1, _col2
+ Select Operator
+ expressions:
+ expr: _col0
+ type: tinyint
+ expr: _col1
+ type: bigint
+ expr: _col2
+ type: bigint
+ outputColumnNames: _col0, _col1, _col2
+ Limit
+ File Output Operator
+ compressed: false
+ GlobalTableId: 0
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+
+ Stage: Stage-0
+ Fetch Operator
+ limit: 20
+
+
+PREHOOK: query: select ctinyint, count(distinct(cstring1)), count(distinct(cstring2)) from alltypesorc group by ctinyint limit 20
+PREHOOK: type: QUERY
+PREHOOK: Input: default@alltypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select ctinyint, count(distinct(cstring1)), count(distinct(cstring2)) from alltypesorc group by ctinyint limit 20
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@alltypesorc
#### A masked pattern was here ####
-0 1
-10 1
-100 1
-103 1
-104 1
-105 1
-11 1
-111 1
-113 1
-114 1
-116 1
-118 1
-119 1
-12 1
-120 1
-125 1
-126 1
-128 1
-129 1
-131 1
+NULL 3065 3
+-64 3 13
+-63 3 16
+-62 3 23
+-61 3 25
+-60 3 25
+-59 3 27
+-58 3 24
+-57 3 23
+-56 3 22
+-55 3 21
+-54 3 21
+-53 3 17
+-52 3 21
+-51 1012 1045
+-50 3 25
+-49 3 24
+-48 3 27
+-47 3 23
+-46 3 19
PREHOOK: query: -- limit zero
explain
select key,value from src order by key limit 0