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 [8/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/s...
Modified: hive/branches/tez/ql/src/test/results/clientpositive/bucketmapjoin4.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/bucketmapjoin4.q.out?rev=1541190&r1=1541189&r2=1541190&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/bucketmapjoin4.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/bucketmapjoin4.q.out Tue Nov 12 18:23:05 2013
@@ -197,6 +197,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 2
bucket_field_name key
columns key,value
@@ -216,6 +217,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 2
bucket_field_name key
columns key,value
@@ -653,6 +655,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,value1,value2
columns.types string:string:string
@@ -682,6 +685,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 2
bucket_field_name key
columns key,value
@@ -701,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 2
bucket_field_name key
columns key,value
@@ -739,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,value1,value2
columns.types string:string:string
@@ -775,6 +781,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,value1,value2
columns.types string:string:string
@@ -802,6 +809,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,value1,value2
columns.types string:string:string
@@ -820,6 +828,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,value1,value2
columns.types string:string:string
@@ -854,6 +863,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,value1,value2
columns.types string:string:string
@@ -881,6 +891,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,value1,value2
columns.types string:string:string
@@ -899,6 +910,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,value1,value2
columns.types string:string:string
Modified: hive/branches/tez/ql/src/test/results/clientpositive/bucketmapjoin5.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/bucketmapjoin5.q.out?rev=1541190&r1=1541189&r2=1541190&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/bucketmapjoin5.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/bucketmapjoin5.q.out Tue Nov 12 18:23:05 2013
@@ -237,6 +237,7 @@ STAGE PLANS:
partition values:
ds 2008-04-08
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count 4
bucket_field_name key
columns key,value
@@ -279,6 +280,7 @@ STAGE PLANS:
partition values:
ds 2008-04-09
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count 4
bucket_field_name key
columns key,value
@@ -492,7 +494,6 @@ STAGE PLANS:
hdfs directory: true
#### A masked pattern was here ####
-
PREHOOK: query: insert overwrite table bucketmapjoin_tmp_result
select /*+mapjoin(a)*/ a.key, a.value, b.value
from srcbucket_mapjoin a join srcbucket_mapjoin_part b
@@ -746,6 +747,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,value1,value2
columns.types string:string:string
@@ -777,6 +779,7 @@ STAGE PLANS:
partition values:
ds 2008-04-08
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count 2
bucket_field_name key
columns key,value
@@ -819,6 +822,7 @@ STAGE PLANS:
partition values:
ds 2008-04-09
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count 2
bucket_field_name key
columns key,value
@@ -875,6 +879,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,value1,value2
columns.types string:string:string
@@ -911,6 +916,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,value1,value2
columns.types string:string:string
@@ -938,6 +944,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,value1,value2
columns.types string:string:string
@@ -956,6 +963,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,value1,value2
columns.types string:string:string
@@ -990,6 +998,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,value1,value2
columns.types string:string:string
@@ -1017,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,value1,value2
columns.types string:string:string
@@ -1035,6 +1045,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,value1,value2
columns.types string:string:string
Modified: hive/branches/tez/ql/src/test/results/clientpositive/bucketmapjoin7.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/bucketmapjoin7.q.out?rev=1541190&r1=1541189&r2=1541190&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/bucketmapjoin7.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/bucketmapjoin7.q.out Tue Nov 12 18:23:05 2013
@@ -75,6 +75,7 @@ STAGE PLANS:
ds 2008-04-08
hr 0
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count 2
bucket_field_name key
columns key,value
@@ -193,6 +194,7 @@ STAGE PLANS:
ds 2008-04-08
hr 0
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count 2
bucket_field_name key
columns key,value
Modified: hive/branches/tez/ql/src/test/results/clientpositive/bucketmapjoin8.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/bucketmapjoin8.q.out?rev=1541190&r1=1541189&r2=1541190&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/bucketmapjoin8.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/bucketmapjoin8.q.out Tue Nov 12 18:23:05 2013
@@ -82,6 +82,7 @@ STAGE PLANS:
partition values:
part 1
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count 2
bucket_field_name key
columns key,value
@@ -183,6 +184,7 @@ STAGE PLANS:
partition values:
part 1
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count 2
bucket_field_name key
columns key,value
@@ -321,6 +323,7 @@ STAGE PLANS:
partition values:
part 1
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count 2
bucket_field_name key
columns key,value
@@ -422,6 +425,7 @@ STAGE PLANS:
partition values:
part 1
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count 2
bucket_field_name key
columns key,value
Modified: hive/branches/tez/ql/src/test/results/clientpositive/bucketmapjoin9.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/bucketmapjoin9.q.out?rev=1541190&r1=1541189&r2=1541190&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/bucketmapjoin9.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/bucketmapjoin9.q.out Tue Nov 12 18:23:05 2013
@@ -88,6 +88,7 @@ STAGE PLANS:
partition values:
part 1
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count 3
bucket_field_name key
columns key,value
@@ -181,6 +182,7 @@ STAGE PLANS:
partition values:
part 1
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count 2
bucket_field_name key
columns key,value
@@ -348,6 +350,7 @@ STAGE PLANS:
partition values:
part 1
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count 2
bucket_field_name value
columns key,value
@@ -441,6 +444,7 @@ STAGE PLANS:
partition values:
part 1
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count 2
bucket_field_name key
columns key,value
Modified: hive/branches/tez/ql/src/test/results/clientpositive/bucketmapjoin_negative.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/bucketmapjoin_negative.q.out?rev=1541190&r1=1541189&r2=1541190&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/bucketmapjoin_negative.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/bucketmapjoin_negative.q.out Tue Nov 12 18:23:05 2013
@@ -84,6 +84,7 @@ STAGE PLANS:
partition values:
ds 2008-04-08
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count 3
bucket_field_name key
columns key,value
@@ -196,6 +197,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 2
bucket_field_name key
columns key,value
@@ -215,6 +217,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 2
bucket_field_name key
columns key,value
Modified: hive/branches/tez/ql/src/test/results/clientpositive/bucketmapjoin_negative2.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/bucketmapjoin_negative2.q.out?rev=1541190&r1=1541189&r2=1541190&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/bucketmapjoin_negative2.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/bucketmapjoin_negative2.q.out Tue Nov 12 18:23:05 2013
@@ -91,6 +91,7 @@ STAGE PLANS:
partition values:
ds 2008-04-08
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count 2
bucket_field_name key
columns key,value
@@ -131,6 +132,7 @@ STAGE PLANS:
partition values:
ds 2008-04-09
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count 2
bucket_field_name key
columns key,value
@@ -251,6 +253,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 2
bucket_field_name key
columns key,value
@@ -270,6 +273,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 2
bucket_field_name key
columns key,value
Modified: hive/branches/tez/ql/src/test/results/clientpositive/bucketmapjoin_negative3.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/bucketmapjoin_negative3.q.out?rev=1541190&r1=1541189&r2=1541190&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/bucketmapjoin_negative3.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/bucketmapjoin_negative3.q.out Tue Nov 12 18:23:05 2013
@@ -211,6 +211,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
+ COLUMN_STATS_ACCURATE true
SORTBUCKETCOLSPREFIX TRUE
bucket_count 3
bucket_field_name key
@@ -231,6 +232,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
+ COLUMN_STATS_ACCURATE true
SORTBUCKETCOLSPREFIX TRUE
bucket_count 3
bucket_field_name key
@@ -360,6 +362,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
+ COLUMN_STATS_ACCURATE true
SORTBUCKETCOLSPREFIX TRUE
bucket_count 3
bucket_field_name value
@@ -380,6 +383,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
+ COLUMN_STATS_ACCURATE true
SORTBUCKETCOLSPREFIX TRUE
bucket_count 3
bucket_field_name value
@@ -503,6 +507,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
+ COLUMN_STATS_ACCURATE true
SORTBUCKETCOLSPREFIX TRUE
bucket_count 3
bucket_field_name key
@@ -523,6 +528,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
+ COLUMN_STATS_ACCURATE true
SORTBUCKETCOLSPREFIX TRUE
bucket_count 3
bucket_field_name key
@@ -644,6 +650,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
+ COLUMN_STATS_ACCURATE true
SORTBUCKETCOLSPREFIX TRUE
bucket_count 3
bucket_field_name key
@@ -664,6 +671,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
+ COLUMN_STATS_ACCURATE true
SORTBUCKETCOLSPREFIX TRUE
bucket_count 3
bucket_field_name key
@@ -785,6 +793,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
+ COLUMN_STATS_ACCURATE true
SORTBUCKETCOLSPREFIX TRUE
bucket_count 3
bucket_field_name key
@@ -805,6 +814,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
+ COLUMN_STATS_ACCURATE true
SORTBUCKETCOLSPREFIX TRUE
bucket_count 3
bucket_field_name key
@@ -926,6 +936,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
+ COLUMN_STATS_ACCURATE true
SORTBUCKETCOLSPREFIX TRUE
bucket_count 3
bucket_field_name key
@@ -946,6 +957,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
+ COLUMN_STATS_ACCURATE true
SORTBUCKETCOLSPREFIX TRUE
bucket_count 3
bucket_field_name key
@@ -1067,6 +1079,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
+ COLUMN_STATS_ACCURATE true
SORTBUCKETCOLSPREFIX TRUE
bucket_count 3
bucket_field_name value
@@ -1087,6 +1100,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
+ COLUMN_STATS_ACCURATE true
SORTBUCKETCOLSPREFIX TRUE
bucket_count 3
bucket_field_name value
@@ -1208,6 +1222,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
+ COLUMN_STATS_ACCURATE true
SORTBUCKETCOLSPREFIX TRUE
bucket_count 3
bucket_field_name value
@@ -1228,6 +1243,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
+ COLUMN_STATS_ACCURATE true
SORTBUCKETCOLSPREFIX TRUE
bucket_count 3
bucket_field_name value
@@ -1349,6 +1365,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
+ COLUMN_STATS_ACCURATE true
SORTBUCKETCOLSPREFIX TRUE
bucket_count 3
bucket_field_name key
@@ -1369,6 +1386,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
+ COLUMN_STATS_ACCURATE true
SORTBUCKETCOLSPREFIX TRUE
bucket_count 3
bucket_field_name key
Modified: hive/branches/tez/ql/src/test/results/clientpositive/columnstats_partlvl.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/columnstats_partlvl.q.out?rev=1541190&r1=1541189&r2=1541190&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/columnstats_partlvl.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/columnstats_partlvl.q.out Tue Nov 12 18:23:05 2013
@@ -138,6 +138,7 @@ STAGE PLANS:
partition values:
employeesalary 2000.0
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns employeeid,employeename
columns.types int:string
@@ -343,6 +344,7 @@ STAGE PLANS:
partition values:
employeesalary 4000.0
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns employeeid,employeename
columns.types int:string
Modified: hive/branches/tez/ql/src/test/results/clientpositive/columnstats_tbllvl.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/columnstats_tbllvl.q.out?rev=1541190&r1=1541189&r2=1541190&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/columnstats_tbllvl.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/columnstats_tbllvl.q.out Tue Nov 12 18:23:05 2013
@@ -171,6 +171,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 sourceip,desturl,visitdate,adrevenue,useragent,ccode,lcode,skeyword,avgtimeonsite
columns.types string:string:string:float:string:string:string:string:int
@@ -190,6 +191,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 sourceip,desturl,visitdate,adrevenue,useragent,ccode,lcode,skeyword,avgtimeonsite
columns.types string:string:string:float:string:string:string:string:int
Modified: hive/branches/tez/ql/src/test/results/clientpositive/combine2_hadoop20.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/combine2_hadoop20.q.out?rev=1541190&r1=1541189&r2=1541190&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/combine2_hadoop20.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/combine2_hadoop20.q.out Tue Nov 12 18:23:05 2013
@@ -244,6 +244,7 @@ STAGE PLANS:
partition values:
value 2010-04-21 09:45:00
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key
columns.types string
@@ -284,6 +285,7 @@ STAGE PLANS:
partition values:
value val_0
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key
columns.types string
@@ -324,6 +326,7 @@ STAGE PLANS:
partition values:
value val_2
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key
columns.types string
@@ -364,6 +367,7 @@ STAGE PLANS:
partition values:
value val_4
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key
columns.types string
@@ -404,6 +408,7 @@ STAGE PLANS:
partition values:
value val_5
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key
columns.types string
@@ -444,6 +449,7 @@ STAGE PLANS:
partition values:
value val_8
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key
columns.types string
@@ -484,6 +490,7 @@ STAGE PLANS:
partition values:
value val_9
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key
columns.types string
@@ -524,6 +531,7 @@ STAGE PLANS:
partition values:
value |
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key
columns.types string
Modified: hive/branches/tez/ql/src/test/results/clientpositive/correlationoptimizer1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/correlationoptimizer1.q.out?rev=1541190&r1=1541189&r2=1541190&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/correlationoptimizer1.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/correlationoptimizer1.q.out Tue Nov 12 18:23:05 2013
@@ -1269,7 +1269,7 @@ POSTHOOK: Input: default@src1
#### A masked pattern was here ####
652447 47
PREHOOK: query: -- If the key of a GroupByOperator is the right table's key in
--- a Left Outer Join, we cannot use a single MR to execute these two
+-- a Left Outer Join, we cannot use a single MR to execute these two
-- operators because those keys with a null value are not grouped.
EXPLAIN
SELECT SUM(HASH(tmp.key)), SUM(HASH(tmp.cnt))
@@ -1278,7 +1278,7 @@ FROM (SELECT y.key AS key, count(1) AS c
GROUP BY y.key) tmp
PREHOOK: type: QUERY
POSTHOOK: query: -- If the key of a GroupByOperator is the right table's key in
--- a Left Outer Join, we cannot use a single MR to execute these two
+-- a Left Outer Join, we cannot use a single MR to execute these two
-- operators because those keys with a null value are not grouped.
EXPLAIN
SELECT SUM(HASH(tmp.key)), SUM(HASH(tmp.cnt))
@@ -1654,6 +1654,372 @@ POSTHOOK: Input: default@src
POSTHOOK: Input: default@src1
#### A masked pattern was here ####
652447 47
+PREHOOK: query: -- If a column of the key of a GroupByOperator is the right table's key in
+-- a Left Outer Join, we cannot use a single MR to execute these two
+-- operators because those keys with a null value are not grouped.
+EXPLAIN
+SELECT x.key, y.value, count(1) AS cnt
+FROM src1 x LEFT OUTER JOIN src y ON (x.key = y.key AND x.value = y.value)
+GROUP BY x.key, y.value
+PREHOOK: type: QUERY
+POSTHOOK: query: -- If a column of the key of a GroupByOperator is the right table's key in
+-- a Left Outer Join, we cannot use a single MR to execute these two
+-- operators because those keys with a null value are not grouped.
+EXPLAIN
+SELECT x.key, y.value, count(1) AS cnt
+FROM src1 x LEFT OUTER JOIN src y ON (x.key = y.key AND x.value = y.value)
+GROUP BY x.key, y.value
+POSTHOOK: type: QUERY
+ABSTRACT SYNTAX TREE:
+ (TOK_QUERY (TOK_FROM (TOK_LEFTOUTERJOIN (TOK_TABREF (TOK_TABNAME src1) x) (TOK_TABREF (TOK_TABNAME src) y) (AND (= (. (TOK_TABLE_OR_COL x) key) (. (TOK_TABLE_OR_COL y) key)) (= (. (TOK_TABLE_OR_COL x) value) (. (TOK_TABLE_OR_COL y) value))))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL x) key)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL y) value)) (TOK_SELEXPR (TOK_FUNCTION count 1) cnt)) (TOK_GROUPBY (. (TOK_TABLE_OR_COL x) key) (. (TOK_TABLE_OR_COL y) value))))
+
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-2 depends on stages: Stage-1
+ Stage-0 is a root stage
+
+STAGE PLANS:
+ Stage: Stage-1
+ Map Reduce
+ Alias -> Map Operator Tree:
+ x
+ TableScan
+ alias: x
+ Reduce Output Operator
+ key expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ sort order: ++
+ Map-reduce partition columns:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ tag: 0
+ value expressions:
+ expr: key
+ type: string
+ y
+ TableScan
+ alias: y
+ Reduce Output Operator
+ key expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ sort order: ++
+ Map-reduce partition columns:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ tag: 1
+ value expressions:
+ expr: value
+ type: string
+ Reduce Operator Tree:
+ Join Operator
+ condition map:
+ Left Outer Join0 to 1
+ condition expressions:
+ 0 {VALUE._col0}
+ 1 {VALUE._col1}
+ handleSkewJoin: false
+ outputColumnNames: _col0, _col5
+ Select Operator
+ expressions:
+ expr: _col0
+ type: string
+ expr: _col5
+ type: string
+ outputColumnNames: _col0, _col5
+ Group By Operator
+ aggregations:
+ expr: count(1)
+ bucketGroup: false
+ keys:
+ expr: _col0
+ type: string
+ expr: _col5
+ type: string
+ mode: hash
+ outputColumnNames: _col0, _col1, _col2
+ File Output Operator
+ compressed: false
+ GlobalTableId: 0
+ table:
+ input format: org.apache.hadoop.mapred.SequenceFileInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe
+
+ Stage: Stage-2
+ Map Reduce
+ Alias -> Map Operator Tree:
+#### A masked pattern was here ####
+ TableScan
+ Reduce Output Operator
+ key expressions:
+ expr: _col0
+ type: string
+ expr: _col1
+ type: string
+ sort order: ++
+ Map-reduce partition columns:
+ expr: _col0
+ type: string
+ expr: _col1
+ type: string
+ tag: -1
+ value expressions:
+ expr: _col2
+ type: bigint
+ Reduce Operator Tree:
+ Group By Operator
+ aggregations:
+ expr: count(VALUE._col0)
+ bucketGroup: false
+ keys:
+ expr: KEY._col0
+ type: string
+ expr: KEY._col1
+ type: string
+ mode: mergepartial
+ outputColumnNames: _col0, _col1, _col2
+ Select Operator
+ expressions:
+ expr: _col0
+ type: string
+ expr: _col1
+ type: string
+ expr: _col2
+ type: bigint
+ outputColumnNames: _col0, _col1, _col2
+ 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: -1
+
+
+PREHOOK: query: SELECT x.key, y.value, count(1) AS cnt
+FROM src1 x LEFT OUTER JOIN src y ON (x.key = y.key AND x.value = y.value)
+GROUP BY x.key, y.value
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Input: default@src1
+#### A masked pattern was here ####
+POSTHOOK: query: SELECT x.key, y.value, count(1) AS cnt
+FROM src1 x LEFT OUTER JOIN src y ON (x.key = y.key AND x.value = y.value)
+GROUP BY x.key, y.value
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Input: default@src1
+#### A masked pattern was here ####
+ NULL 10
+128 NULL 1
+146 val_146 2
+150 val_150 1
+213 val_213 2
+224 NULL 1
+238 val_238 2
+255 val_255 2
+273 val_273 3
+278 val_278 2
+311 val_311 3
+369 NULL 1
+401 val_401 5
+406 val_406 4
+66 val_66 1
+98 val_98 2
+PREHOOK: query: EXPLAIN
+SELECT x.key, y.value, count(1) AS cnt
+FROM src1 x LEFT OUTER JOIN src y ON (x.key = y.key AND x.value = y.value)
+GROUP BY x.key, y.value
+PREHOOK: type: QUERY
+POSTHOOK: query: EXPLAIN
+SELECT x.key, y.value, count(1) AS cnt
+FROM src1 x LEFT OUTER JOIN src y ON (x.key = y.key AND x.value = y.value)
+GROUP BY x.key, y.value
+POSTHOOK: type: QUERY
+ABSTRACT SYNTAX TREE:
+ (TOK_QUERY (TOK_FROM (TOK_LEFTOUTERJOIN (TOK_TABREF (TOK_TABNAME src1) x) (TOK_TABREF (TOK_TABNAME src) y) (AND (= (. (TOK_TABLE_OR_COL x) key) (. (TOK_TABLE_OR_COL y) key)) (= (. (TOK_TABLE_OR_COL x) value) (. (TOK_TABLE_OR_COL y) value))))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL x) key)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL y) value)) (TOK_SELEXPR (TOK_FUNCTION count 1) cnt)) (TOK_GROUPBY (. (TOK_TABLE_OR_COL x) key) (. (TOK_TABLE_OR_COL y) value))))
+
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-2 depends on stages: Stage-1
+ Stage-0 is a root stage
+
+STAGE PLANS:
+ Stage: Stage-1
+ Map Reduce
+ Alias -> Map Operator Tree:
+ x
+ TableScan
+ alias: x
+ Reduce Output Operator
+ key expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ sort order: ++
+ Map-reduce partition columns:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ tag: 0
+ value expressions:
+ expr: key
+ type: string
+ y
+ TableScan
+ alias: y
+ Reduce Output Operator
+ key expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ sort order: ++
+ Map-reduce partition columns:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ tag: 1
+ value expressions:
+ expr: value
+ type: string
+ Reduce Operator Tree:
+ Join Operator
+ condition map:
+ Left Outer Join0 to 1
+ condition expressions:
+ 0 {VALUE._col0}
+ 1 {VALUE._col1}
+ handleSkewJoin: false
+ outputColumnNames: _col0, _col5
+ Select Operator
+ expressions:
+ expr: _col0
+ type: string
+ expr: _col5
+ type: string
+ outputColumnNames: _col0, _col5
+ Group By Operator
+ aggregations:
+ expr: count(1)
+ bucketGroup: false
+ keys:
+ expr: _col0
+ type: string
+ expr: _col5
+ type: string
+ mode: hash
+ outputColumnNames: _col0, _col1, _col2
+ File Output Operator
+ compressed: false
+ GlobalTableId: 0
+ table:
+ input format: org.apache.hadoop.mapred.SequenceFileInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe
+
+ Stage: Stage-2
+ Map Reduce
+ Alias -> Map Operator Tree:
+#### A masked pattern was here ####
+ TableScan
+ Reduce Output Operator
+ key expressions:
+ expr: _col0
+ type: string
+ expr: _col1
+ type: string
+ sort order: ++
+ Map-reduce partition columns:
+ expr: _col0
+ type: string
+ expr: _col1
+ type: string
+ tag: -1
+ value expressions:
+ expr: _col2
+ type: bigint
+ Reduce Operator Tree:
+ Group By Operator
+ aggregations:
+ expr: count(VALUE._col0)
+ bucketGroup: false
+ keys:
+ expr: KEY._col0
+ type: string
+ expr: KEY._col1
+ type: string
+ mode: mergepartial
+ outputColumnNames: _col0, _col1, _col2
+ Select Operator
+ expressions:
+ expr: _col0
+ type: string
+ expr: _col1
+ type: string
+ expr: _col2
+ type: bigint
+ outputColumnNames: _col0, _col1, _col2
+ 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: -1
+
+
+PREHOOK: query: SELECT x.key, y.value, count(1) AS cnt
+FROM src1 x LEFT OUTER JOIN src y ON (x.key = y.key AND x.value = y.value)
+GROUP BY x.key, y.value
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Input: default@src1
+#### A masked pattern was here ####
+POSTHOOK: query: SELECT x.key, y.value, count(1) AS cnt
+FROM src1 x LEFT OUTER JOIN src y ON (x.key = y.key AND x.value = y.value)
+GROUP BY x.key, y.value
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Input: default@src1
+#### A masked pattern was here ####
+ NULL 10
+128 NULL 1
+146 val_146 2
+150 val_150 1
+213 val_213 2
+224 NULL 1
+238 val_238 2
+255 val_255 2
+273 val_273 3
+278 val_278 2
+311 val_311 3
+369 NULL 1
+401 val_401 5
+406 val_406 4
+66 val_66 1
+98 val_98 2
PREHOOK: query: -- If the key of a GroupByOperator is the right table's key in
-- a Right Outer Join, these two operators will be executed in
-- the same MR job when Correlation Optimizer is enabled.
Modified: hive/branches/tez/ql/src/test/results/clientpositive/create_alter_list_bucketing_table1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/create_alter_list_bucketing_table1.q.out?rev=1541190&r1=1541189&r2=1541190&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/create_alter_list_bucketing_table1.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/create_alter_list_bucketing_table1.q.out Tue Nov 12 18:23:05 2013
@@ -74,8 +74,11 @@ Retention: 0
#### A masked pattern was here ####
Table Type: MANAGED_TABLE
Table Parameters:
+ COLUMN_STATS_ACCURATE false
#### A masked pattern was here ####
numFiles 0
+ numRows -1
+ rawDataSize -1
totalSize 0
#### A masked pattern was here ####
@@ -119,8 +122,11 @@ Retention: 0
#### A masked pattern was here ####
Table Type: MANAGED_TABLE
Table Parameters:
+ COLUMN_STATS_ACCURATE false
#### A masked pattern was here ####
numFiles 0
+ numRows -1
+ rawDataSize -1
totalSize 0
#### A masked pattern was here ####
@@ -168,8 +174,11 @@ Retention: 0
#### A masked pattern was here ####
Table Type: MANAGED_TABLE
Table Parameters:
+ COLUMN_STATS_ACCURATE false
#### A masked pattern was here ####
numFiles 0
+ numRows -1
+ rawDataSize -1
totalSize 0
#### A masked pattern was here ####
@@ -213,8 +222,11 @@ Retention: 0
#### A masked pattern was here ####
Table Type: MANAGED_TABLE
Table Parameters:
+ COLUMN_STATS_ACCURATE false
#### A masked pattern was here ####
numFiles 0
+ numRows -1
+ rawDataSize -1
totalSize 0
#### A masked pattern was here ####
@@ -257,8 +269,11 @@ Retention: 0
#### A masked pattern was here ####
Table Type: MANAGED_TABLE
Table Parameters:
+ COLUMN_STATS_ACCURATE false
#### A masked pattern was here ####
numFiles 0
+ numRows -1
+ rawDataSize -1
totalSize 0
#### A masked pattern was here ####
Modified: hive/branches/tez/ql/src/test/results/clientpositive/ctas_colname.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/ctas_colname.q.out?rev=1541190&r1=1541189&r2=1541190&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/ctas_colname.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/ctas_colname.q.out Tue Nov 12 18:23:05 2013
@@ -125,6 +125,7 @@ Retention: 0
#### A masked pattern was here ####
Table Type: MANAGED_TABLE
Table Parameters:
+ COLUMN_STATS_ACCURATE true
numFiles 1
numRows 1
rawDataSize 25
@@ -257,6 +258,7 @@ Retention: 0
#### A masked pattern was here ####
Table Type: MANAGED_TABLE
Table Parameters:
+ COLUMN_STATS_ACCURATE true
numFiles 1
numRows 25
rawDataSize 242
@@ -439,6 +441,7 @@ Retention: 0
#### A masked pattern was here ####
Table Type: MANAGED_TABLE
Table Parameters:
+ COLUMN_STATS_ACCURATE true
numFiles 1
numRows 20
rawDataSize 268
@@ -592,6 +595,7 @@ Retention: 0
#### A masked pattern was here ####
Table Type: MANAGED_TABLE
Table Parameters:
+ COLUMN_STATS_ACCURATE true
numFiles 1
numRows 1
rawDataSize 5
@@ -726,6 +730,7 @@ Retention: 0
#### A masked pattern was here ####
Table Type: MANAGED_TABLE
Table Parameters:
+ COLUMN_STATS_ACCURATE true
numFiles 1
numRows 309
rawDataSize 864
@@ -1172,6 +1177,7 @@ Retention: 0
#### A masked pattern was here ####
Table Type: MANAGED_TABLE
Table Parameters:
+ COLUMN_STATS_ACCURATE true
numFiles 1
numRows 5
rawDataSize 5
@@ -1330,6 +1336,7 @@ Retention: 0
#### A masked pattern was here ####
Table Type: MANAGED_TABLE
Table Parameters:
+ COLUMN_STATS_ACCURATE true
numFiles 1
numRows 5
rawDataSize 35
Modified: hive/branches/tez/ql/src/test/results/clientpositive/ctas_hadoop20.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/ctas_hadoop20.q.out?rev=1541190&r1=1541189&r2=1541190&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/ctas_hadoop20.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/ctas_hadoop20.q.out Tue Nov 12 18:23:05 2013
@@ -160,6 +160,7 @@ Retention: 0
#### A masked pattern was here ####
Table Type: MANAGED_TABLE
Table Parameters:
+ COLUMN_STATS_ACCURATE true
numFiles 1
numRows 10
rawDataSize 96
@@ -321,6 +322,7 @@ Retention: 0
#### A masked pattern was here ####
Table Type: MANAGED_TABLE
Table Parameters:
+ COLUMN_STATS_ACCURATE true
numFiles 1
numRows 10
rawDataSize 96
@@ -483,6 +485,7 @@ Retention: 0
#### A masked pattern was here ####
Table Type: MANAGED_TABLE
Table Parameters:
+ COLUMN_STATS_ACCURATE true
numFiles 1
numRows 10
rawDataSize 120
@@ -549,6 +552,7 @@ Retention: 0
#### A masked pattern was here ####
Table Type: MANAGED_TABLE
Table Parameters:
+ COLUMN_STATS_ACCURATE true
numFiles 1
numRows 10
rawDataSize 120
@@ -711,6 +715,7 @@ Retention: 0
#### A masked pattern was here ####
Table Type: MANAGED_TABLE
Table Parameters:
+ COLUMN_STATS_ACCURATE true
numFiles 1
numRows 10
rawDataSize 96
@@ -779,6 +784,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
@@ -797,6 +803,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
@@ -965,3 +972,29 @@ POSTHOOK: Input: default@nzhang_ctas6
POSTHOOK: Output: default@nzhang_ctas7
POSTHOOK: Lineage: nzhang_ctas6.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: nzhang_ctas6.to SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+PREHOOK: query: create table nzhang_ctas8 as select 3.14BD from nzhang_ctas6 limit 1
+PREHOOK: type: CREATETABLE_AS_SELECT
+PREHOOK: Input: default@nzhang_ctas6
+POSTHOOK: query: create table nzhang_ctas8 as select 3.14BD from nzhang_ctas6 limit 1
+POSTHOOK: type: CREATETABLE_AS_SELECT
+POSTHOOK: Input: default@nzhang_ctas6
+POSTHOOK: Output: default@nzhang_ctas8
+POSTHOOK: Lineage: nzhang_ctas6.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: nzhang_ctas6.to SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+PREHOOK: query: desc nzhang_ctas8
+PREHOOK: type: DESCTABLE
+POSTHOOK: query: desc nzhang_ctas8
+POSTHOOK: type: DESCTABLE
+POSTHOOK: Lineage: nzhang_ctas6.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: nzhang_ctas6.to SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+_c0 decimal(3,2) None
+PREHOOK: query: drop table nzhang_ctas8
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@nzhang_ctas8
+PREHOOK: Output: default@nzhang_ctas8
+POSTHOOK: query: drop table nzhang_ctas8
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@nzhang_ctas8
+POSTHOOK: Output: default@nzhang_ctas8
+POSTHOOK: Lineage: nzhang_ctas6.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: nzhang_ctas6.to SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
Modified: hive/branches/tez/ql/src/test/results/clientpositive/ctas_uses_database_location.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/ctas_uses_database_location.q.out?rev=1541190&r1=1541189&r2=1541190&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/ctas_uses_database_location.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/ctas_uses_database_location.q.out Tue Nov 12 18:23:05 2013
@@ -144,6 +144,7 @@ Retention: 0
#### A masked pattern was here ####
Table Type: MANAGED_TABLE
Table Parameters:
+ COLUMN_STATS_ACCURATE true
numFiles 1
numRows 500
rawDataSize 5312
Modified: hive/branches/tez/ql/src/test/results/clientpositive/describe_comment_nonascii.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/describe_comment_nonascii.q.out?rev=1541190&r1=1541189&r2=1541190&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/describe_comment_nonascii.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/describe_comment_nonascii.q.out Tue Nov 12 18:23:05 2013
@@ -49,8 +49,11 @@ Retention: 0
#### A masked pattern was here ####
Table Type: MANAGED_TABLE
Table Parameters:
+ COLUMN_STATS_ACCURATE false
#### A masked pattern was here ####
numFiles 0
+ numRows -1
+ rawDataSize -1
totalSize 0
#### A masked pattern was here ####
Modified: hive/branches/tez/ql/src/test/results/clientpositive/describe_table.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/describe_table.q.out?rev=1541190&r1=1541189&r2=1541190&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/describe_table.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/describe_table.q.out Tue Nov 12 18:23:05 2013
@@ -133,6 +133,7 @@ Table: srcpart
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/disable_merge_for_bucketing.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/disable_merge_for_bucketing.q.out?rev=1541190&r1=1541189&r2=1541190&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/disable_merge_for_bucketing.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/disable_merge_for_bucketing.q.out Tue Nov 12 18:23:05 2013
@@ -54,6 +54,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
@@ -72,6 +73,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/dynamic_partition_skip_default.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/dynamic_partition_skip_default.q.out?rev=1541190&r1=1541189&r2=1541190&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/dynamic_partition_skip_default.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/dynamic_partition_skip_default.q.out Tue Nov 12 18:23:05 2013
@@ -105,15 +105,16 @@ STAGE PLANS:
partcol1 1
partcol2 1
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns intcol
columns.types int
#### A masked pattern was here ####
name default.dynamic_part_table
numFiles 1
- numRows 1
+ numRows 0
partition_columns partcol1/partcol2
- rawDataSize 1
+ rawDataSize 0
serialization.ddl struct dynamic_part_table { i32 intcol}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
@@ -205,15 +206,16 @@ STAGE PLANS:
partcol1 1
partcol2 1
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns intcol
columns.types int
#### A masked pattern was here ####
name default.dynamic_part_table
numFiles 1
- numRows 1
+ numRows 0
partition_columns partcol1/partcol2
- rawDataSize 1
+ rawDataSize 0
serialization.ddl struct dynamic_part_table { i32 intcol}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
@@ -305,15 +307,16 @@ STAGE PLANS:
partcol1 1
partcol2 1
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns intcol
columns.types int
#### A masked pattern was here ####
name default.dynamic_part_table
numFiles 1
- numRows 1
+ numRows 0
partition_columns partcol1/partcol2
- rawDataSize 1
+ rawDataSize 0
serialization.ddl struct dynamic_part_table { i32 intcol}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
@@ -346,15 +349,16 @@ STAGE PLANS:
partcol1 1
partcol2 __HIVE_DEFAULT_PARTITION__
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns intcol
columns.types int
#### A masked pattern was here ####
name default.dynamic_part_table
numFiles 1
- numRows 1
+ numRows 0
partition_columns partcol1/partcol2
- rawDataSize 1
+ rawDataSize 0
serialization.ddl struct dynamic_part_table { i32 intcol}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
Modified: hive/branches/tez/ql/src/test/results/clientpositive/filter_join_breaktask.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/filter_join_breaktask.q.out?rev=1541190&r1=1541189&r2=1541190&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/filter_join_breaktask.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/filter_join_breaktask.q.out Tue Nov 12 18:23:05 2013
@@ -92,6 +92,7 @@ STAGE PLANS:
partition values:
ds 2008-04-08
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value
columns.types int:string
@@ -224,6 +225,7 @@ STAGE PLANS:
partition values:
ds 2008-04-08
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value
columns.types int:string
Modified: hive/branches/tez/ql/src/test/results/clientpositive/groupby_map_ppr.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/groupby_map_ppr.q.out?rev=1541190&r1=1541189&r2=1541190&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/groupby_map_ppr.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/groupby_map_ppr.q.out Tue Nov 12 18:23:05 2013
@@ -80,6 +80,7 @@ STAGE PLANS:
ds 2008-04-08
hr 11
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value
columns.types string:string
@@ -121,6 +122,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/groupby_map_ppr_multi_distinct.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/groupby_map_ppr_multi_distinct.q.out?rev=1541190&r1=1541189&r2=1541190&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/groupby_map_ppr_multi_distinct.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/groupby_map_ppr_multi_distinct.q.out Tue Nov 12 18:23:05 2013
@@ -90,6 +90,7 @@ STAGE PLANS:
ds 2008-04-08
hr 11
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value
columns.types string:string
@@ -131,6 +132,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/groupby_ppr.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/groupby_ppr.q.out?rev=1541190&r1=1541189&r2=1541190&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/groupby_ppr.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/groupby_ppr.q.out Tue Nov 12 18:23:05 2013
@@ -63,6 +63,7 @@ STAGE PLANS:
ds 2008-04-08
hr 11
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value
columns.types string:string
@@ -104,6 +105,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/groupby_ppr_multi_distinct.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/groupby_ppr_multi_distinct.q.out?rev=1541190&r1=1541189&r2=1541190&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/groupby_ppr_multi_distinct.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/groupby_ppr_multi_distinct.q.out Tue Nov 12 18:23:05 2013
@@ -65,6 +65,7 @@ STAGE PLANS:
ds 2008-04-08
hr 11
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value
columns.types string:string
@@ -106,6 +107,7 @@ STAGE PLANS:
ds 2008-04-08
hr 12
properties:
+ COLUMN_STATS_ACCURATE true
bucket_count -1
columns key,value
columns.types string:string