You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by se...@apache.org on 2014/04/12 02:14:04 UTC
svn commit: r1586801 [4/7] - in /hive/trunk: data/conf/tez/
ql/src/java/org/apache/hadoop/hive/ql/optimizer/
ql/src/test/queries/clientpositive/ ql/src/test/results/clientpositive/
ql/src/test/results/clientpositive/tez/
Modified: hive/trunk/ql/src/test/results/clientpositive/infer_bucket_sort_dyn_part.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/infer_bucket_sort_dyn_part.q.out?rev=1586801&r1=1586800&r2=1586801&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/infer_bucket_sort_dyn_part.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/infer_bucket_sort_dyn_part.q.out Sat Apr 12 00:14:03 2014
@@ -208,7 +208,7 @@ Partition Parameters:
numFiles 1
numRows 0
rawDataSize 0
- totalSize 1383
+ totalSize 1342
#### A masked pattern was here ####
# Storage Information
@@ -258,7 +258,7 @@ Partition Parameters:
numFiles 1
numRows 0
rawDataSize 0
- totalSize 1343
+ totalSize 1342
#### A masked pattern was here ####
# Storage Information
@@ -349,7 +349,7 @@ Partition Parameters:
numFiles 1
numRows 0
rawDataSize 0
- totalSize 722
+ totalSize 719
#### A masked pattern was here ####
# Storage Information
@@ -403,7 +403,7 @@ Partition Parameters:
numFiles 1
numRows 0
rawDataSize 0
- totalSize 754
+ totalSize 722
#### A masked pattern was here ####
# Storage Information
@@ -704,8 +704,8 @@ STAGE PLANS:
Map Operator Tree:
TableScan
Reduce Output Operator
- key expressions: _col2 (type: string)
- sort order: +
+ key expressions: _col2 (type: string), _col0 (type: string)
+ sort order: ++
Map-reduce partition columns: _col2 (type: string)
Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string)
@@ -848,7 +848,7 @@ Partition Parameters:
numFiles 1
numRows 0
rawDataSize 0
- totalSize 95
+ totalSize 94
#### A masked pattern was here ####
# Storage Information
@@ -910,7 +910,7 @@ Partition Parameters:
numFiles 1
numRows 0
rawDataSize 0
- totalSize 1346
+ totalSize 1341
#### A masked pattern was here ####
# Storage Information
Modified: hive/trunk/ql/src/test/results/clientpositive/orc_analyze.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/orc_analyze.q.out?rev=1586801&r1=1586800&r2=1586801&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/orc_analyze.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/orc_analyze.q.out Sat Apr 12 00:14:03 2014
@@ -54,11 +54,11 @@ STORED AS orc
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@orc_create_people
-PREHOOK: query: INSERT OVERWRITE TABLE orc_create_people SELECT * FROM orc_create_people_staging
+PREHOOK: query: INSERT OVERWRITE TABLE orc_create_people SELECT * FROM orc_create_people_staging ORDER BY id
PREHOOK: type: QUERY
PREHOOK: Input: default@orc_create_people_staging
PREHOOK: Output: default@orc_create_people
-POSTHOOK: query: INSERT OVERWRITE TABLE orc_create_people SELECT * FROM orc_create_people_staging
+POSTHOOK: query: INSERT OVERWRITE TABLE orc_create_people SELECT * FROM orc_create_people_staging ORDER BY id
POSTHOOK: type: QUERY
POSTHOOK: Input: default@orc_create_people_staging
POSTHOOK: Output: default@orc_create_people
@@ -177,11 +177,11 @@ POSTHOOK: Lineage: orc_create_people.las
POSTHOOK: Lineage: orc_create_people.salary SIMPLE [(orc_create_people_staging)orc_create_people_staging.FieldSchema(name:salary, type:decimal(10,0), comment:null), ]
POSTHOOK: Lineage: orc_create_people.start_date SIMPLE [(orc_create_people_staging)orc_create_people_staging.FieldSchema(name:start_date, type:timestamp, comment:null), ]
POSTHOOK: Lineage: orc_create_people.state SIMPLE [(orc_create_people_staging)orc_create_people_staging.FieldSchema(name:state, type:string, comment:null), ]
-PREHOOK: query: INSERT OVERWRITE TABLE orc_create_people SELECT * FROM orc_create_people_staging
+PREHOOK: query: INSERT OVERWRITE TABLE orc_create_people SELECT * FROM orc_create_people_staging ORDER BY id
PREHOOK: type: QUERY
PREHOOK: Input: default@orc_create_people_staging
PREHOOK: Output: default@orc_create_people
-POSTHOOK: query: INSERT OVERWRITE TABLE orc_create_people SELECT * FROM orc_create_people_staging
+POSTHOOK: query: INSERT OVERWRITE TABLE orc_create_people SELECT * FROM orc_create_people_staging ORDER BY id
POSTHOOK: type: QUERY
POSTHOOK: Input: default@orc_create_people_staging
POSTHOOK: Output: default@orc_create_people
@@ -318,12 +318,12 @@ POSTHOOK: Lineage: orc_create_people.sta
POSTHOOK: Lineage: orc_create_people.state SIMPLE [(orc_create_people_staging)orc_create_people_staging.FieldSchema(name:state, type:string, comment:null), ]
POSTHOOK: Lineage: orc_create_people.state SIMPLE [(orc_create_people_staging)orc_create_people_staging.FieldSchema(name:state, type:string, comment:null), ]
PREHOOK: query: INSERT OVERWRITE TABLE orc_create_people PARTITION (state)
- SELECT * FROM orc_create_people_staging
+ SELECT * FROM orc_create_people_staging ORDER BY id
PREHOOK: type: QUERY
PREHOOK: Input: default@orc_create_people_staging
PREHOOK: Output: default@orc_create_people
POSTHOOK: query: INSERT OVERWRITE TABLE orc_create_people PARTITION (state)
- SELECT * FROM orc_create_people_staging
+ SELECT * FROM orc_create_people_staging ORDER BY id
POSTHOOK: type: QUERY
POSTHOOK: Input: default@orc_create_people_staging
POSTHOOK: Output: default@orc_create_people@state=Ca
@@ -519,7 +519,7 @@ Partition Parameters:
numFiles 1
numRows 50
rawDataSize 22050
- totalSize 2068
+ totalSize 1969
#### A masked pattern was here ####
# Storage Information
@@ -618,12 +618,12 @@ POSTHOOK: Lineage: orc_create_people PAR
POSTHOOK: Lineage: orc_create_people PARTITION(state=Or).salary SIMPLE [(orc_create_people_staging)orc_create_people_staging.FieldSchema(name:salary, type:decimal(10,0), comment:null), ]
POSTHOOK: Lineage: orc_create_people PARTITION(state=Or).start_date SIMPLE [(orc_create_people_staging)orc_create_people_staging.FieldSchema(name:start_date, type:timestamp, comment:null), ]
PREHOOK: query: INSERT OVERWRITE TABLE orc_create_people PARTITION (state)
- SELECT * FROM orc_create_people_staging
+ SELECT * FROM orc_create_people_staging ORDER BY id
PREHOOK: type: QUERY
PREHOOK: Input: default@orc_create_people_staging
PREHOOK: Output: default@orc_create_people
POSTHOOK: query: INSERT OVERWRITE TABLE orc_create_people PARTITION (state)
- SELECT * FROM orc_create_people_staging
+ SELECT * FROM orc_create_people_staging ORDER BY id
POSTHOOK: type: QUERY
POSTHOOK: Input: default@orc_create_people_staging
POSTHOOK: Output: default@orc_create_people@state=Ca
@@ -819,7 +819,7 @@ Partition Parameters:
numFiles 1
numRows 50
rawDataSize 22050
- totalSize 2068
+ totalSize 1969
#### A masked pattern was here ####
# Storage Information
@@ -950,12 +950,12 @@ POSTHOOK: Lineage: orc_create_people PAR
POSTHOOK: Lineage: orc_create_people PARTITION(state=Or).salary SIMPLE [(orc_create_people_staging)orc_create_people_staging.FieldSchema(name:salary, type:decimal(10,0), comment:null), ]
POSTHOOK: Lineage: orc_create_people PARTITION(state=Or).start_date SIMPLE [(orc_create_people_staging)orc_create_people_staging.FieldSchema(name:start_date, type:timestamp, comment:null), ]
PREHOOK: query: INSERT OVERWRITE TABLE orc_create_people PARTITION (state)
- SELECT * FROM orc_create_people_staging
+ SELECT * FROM orc_create_people_staging ORDER BY id
PREHOOK: type: QUERY
PREHOOK: Input: default@orc_create_people_staging
PREHOOK: Output: default@orc_create_people
POSTHOOK: query: INSERT OVERWRITE TABLE orc_create_people PARTITION (state)
- SELECT * FROM orc_create_people_staging
+ SELECT * FROM orc_create_people_staging ORDER BY id
POSTHOOK: type: QUERY
POSTHOOK: Input: default@orc_create_people_staging
POSTHOOK: Output: default@orc_create_people@state=Ca
@@ -1152,7 +1152,7 @@ Partition Parameters:
numFiles 4
numRows 50
rawDataSize 21980
- totalSize 4747
+ totalSize 4780
#### A masked pattern was here ####
# Storage Information
@@ -1247,7 +1247,7 @@ Partition Parameters:
numFiles 4
numRows 50
rawDataSize 22048
- totalSize 4832
+ totalSize 4859
#### A masked pattern was here ####
# Storage Information
@@ -1400,12 +1400,12 @@ POSTHOOK: Lineage: orc_create_people PAR
POSTHOOK: Lineage: orc_create_people PARTITION(state=Or).salary SIMPLE [(orc_create_people_staging)orc_create_people_staging.FieldSchema(name:salary, type:decimal(10,0), comment:null), ]
POSTHOOK: Lineage: orc_create_people PARTITION(state=Or).start_date SIMPLE [(orc_create_people_staging)orc_create_people_staging.FieldSchema(name:start_date, type:timestamp, comment:null), ]
PREHOOK: query: INSERT OVERWRITE TABLE orc_create_people PARTITION (state)
- SELECT * FROM orc_create_people_staging
+ SELECT * FROM orc_create_people_staging ORDER BY id
PREHOOK: type: QUERY
PREHOOK: Input: default@orc_create_people_staging
PREHOOK: Output: default@orc_create_people
POSTHOOK: query: INSERT OVERWRITE TABLE orc_create_people PARTITION (state)
- SELECT * FROM orc_create_people_staging
+ SELECT * FROM orc_create_people_staging ORDER BY id
POSTHOOK: type: QUERY
POSTHOOK: Input: default@orc_create_people_staging
POSTHOOK: Output: default@orc_create_people@state=Ca
@@ -1566,7 +1566,7 @@ Partition Parameters:
numFiles 4
numRows 50
rawDataSize 21980
- totalSize 4747
+ totalSize 4780
#### A masked pattern was here ####
# Storage Information
@@ -1673,7 +1673,7 @@ Partition Parameters:
numFiles 4
numRows 50
rawDataSize 22048
- totalSize 4832
+ totalSize 4859
#### A masked pattern was here ####
# Storage Information
@@ -1848,12 +1848,12 @@ POSTHOOK: Lineage: orc_create_people PAR
POSTHOOK: Lineage: orc_create_people PARTITION(state=Or).salary SIMPLE [(orc_create_people_staging)orc_create_people_staging.FieldSchema(name:salary, type:decimal(10,0), comment:null), ]
POSTHOOK: Lineage: orc_create_people PARTITION(state=Or).start_date SIMPLE [(orc_create_people_staging)orc_create_people_staging.FieldSchema(name:start_date, type:timestamp, comment:null), ]
PREHOOK: query: INSERT OVERWRITE TABLE orc_create_people PARTITION (state)
- SELECT * FROM orc_create_people_staging
+ SELECT * FROM orc_create_people_staging ORDER BY id
PREHOOK: type: QUERY
PREHOOK: Input: default@orc_create_people_staging
PREHOOK: Output: default@orc_create_people
POSTHOOK: query: INSERT OVERWRITE TABLE orc_create_people PARTITION (state)
- SELECT * FROM orc_create_people_staging
+ SELECT * FROM orc_create_people_staging ORDER BY id
POSTHOOK: type: QUERY
POSTHOOK: Input: default@orc_create_people_staging
POSTHOOK: Output: default@orc_create_people@state=Ca