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


Reply via email to