You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by vi...@apache.org on 2014/03/24 20:25:51 UTC
svn commit: r1581010 [3/5] - in /hive/branches/branch-0.13:
common/src/java/org/apache/hadoop/hive/conf/ conf/ itests/qtest/
ql/src/java/org/apache/hadoop/hive/ql/exec/
ql/src/java/org/apache/hadoop/hive/ql/exec/mr/
ql/src/java/org/apache/hadoop/hive/q...
Modified: hive/branches/branch-0.13/ql/src/test/results/clientpositive/infer_bucket_sort_dyn_part.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.13/ql/src/test/results/clientpositive/infer_bucket_sort_dyn_part.q.out?rev=1581010&r1=1581009&r2=1581010&view=diff
==============================================================================
--- hive/branches/branch-0.13/ql/src/test/results/clientpositive/infer_bucket_sort_dyn_part.q.out (original)
+++ hive/branches/branch-0.13/ql/src/test/results/clientpositive/infer_bucket_sort_dyn_part.q.out Mon Mar 24 19:25:48 2014
@@ -202,7 +202,7 @@ Partition Parameters:
numFiles 1
numRows 0
rawDataSize 0
- totalSize 1342
+ totalSize 1383
#### A masked pattern was here ####
# Storage Information
@@ -250,7 +250,7 @@ Partition Parameters:
numFiles 1
numRows 0
rawDataSize 0
- totalSize 1342
+ totalSize 1343
#### A masked pattern was here ####
# Storage Information
@@ -339,7 +339,7 @@ Partition Parameters:
numFiles 1
numRows 0
rawDataSize 0
- totalSize 719
+ totalSize 722
#### A masked pattern was here ####
# Storage Information
@@ -347,9 +347,9 @@ SerDe Library: org.apache.hadoop.h
InputFormat: org.apache.hadoop.hive.ql.io.RCFileInputFormat
OutputFormat: org.apache.hadoop.hive.ql.io.RCFileOutputFormat
Compressed: No
-Num Buckets: 1
-Bucket Columns: [key]
-Sort Columns: [Order(col:key, order:1)]
+Num Buckets: -1
+Bucket Columns: []
+Sort Columns: []
Storage Desc Params:
serialization.format 1
PREHOOK: query: DESCRIBE FORMATTED test_table PARTITION (ds='2008-04-08', hr='12')
@@ -391,7 +391,7 @@ Partition Parameters:
numFiles 1
numRows 0
rawDataSize 0
- totalSize 722
+ totalSize 754
#### A masked pattern was here ####
# Storage Information
@@ -399,9 +399,9 @@ SerDe Library: org.apache.hadoop.h
InputFormat: org.apache.hadoop.hive.ql.io.RCFileInputFormat
OutputFormat: org.apache.hadoop.hive.ql.io.RCFileOutputFormat
Compressed: No
-Num Buckets: 1
-Bucket Columns: [key]
-Sort Columns: [Order(col:key, order:1)]
+Num Buckets: -1
+Bucket Columns: []
+Sort Columns: []
Storage Desc Params:
serialization.format 1
PREHOOK: query: CREATE TABLE srcpart_merge_dp LIKE srcpart
@@ -637,13 +637,14 @@ POSTHOOK: Lineage: test_table PARTITION(
POSTHOOK: Lineage: test_table PARTITION(ds=2008-04-08,hr=12).value EXPRESSION [(srcpart)srcpart.null, ]
STAGE DEPENDENCIES:
Stage-1 is a root stage
- Stage-7 depends on stages: Stage-1 , consists of Stage-4, Stage-3, Stage-5
- Stage-4
- Stage-0 depends on stages: Stage-4, Stage-3, Stage-6
- Stage-2 depends on stages: Stage-0
- Stage-3
+ Stage-2 depends on stages: Stage-1
+ Stage-8 depends on stages: Stage-2 , consists of Stage-5, Stage-4, Stage-6
Stage-5
- Stage-6 depends on stages: Stage-5
+ Stage-0 depends on stages: Stage-5, Stage-4, Stage-7
+ Stage-3 depends on stages: Stage-0
+ Stage-4
+ Stage-6
+ Stage-7 depends on stages: Stage-6
STAGE PLANS:
Stage: Stage-1
@@ -681,17 +682,37 @@ STAGE PLANS:
Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
table:
- input format: org.apache.hadoop.hive.ql.io.RCFileInputFormat
- output format: org.apache.hadoop.hive.ql.io.RCFileOutputFormat
- serde: org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe
- name: default.test_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-7
+ Stage: Stage-2
+ Map Reduce
+ Map Operator Tree:
+ TableScan
+ Reduce Output Operator
+ key expressions: _col2 (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)
+ Reduce Operator Tree:
+ Extract
+ Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
+ File Output Operator
+ compressed: false
+ Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
+ table:
+ input format: org.apache.hadoop.hive.ql.io.RCFileInputFormat
+ output format: org.apache.hadoop.hive.ql.io.RCFileOutputFormat
+ serde: org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe
+ name: default.test_table
+
+ Stage: Stage-8
Conditional Operator
- Stage: Stage-4
+ Stage: Stage-5
Move Operator
files:
hdfs directory: true
@@ -710,16 +731,16 @@ STAGE PLANS:
serde: org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe
name: default.test_table
- Stage: Stage-2
+ Stage: Stage-3
Stats-Aggr Operator
- Stage: Stage-3
+ Stage: Stage-4
Block level merge
- Stage: Stage-5
+ Stage: Stage-6
Block level merge
- Stage: Stage-6
+ Stage: Stage-7
Move Operator
files:
hdfs directory: true
@@ -813,7 +834,7 @@ Partition Parameters:
numFiles 1
numRows 0
rawDataSize 0
- totalSize 115
+ totalSize 95
#### A masked pattern was here ####
# Storage Information
@@ -870,10 +891,10 @@ Protect Mode: None
#### A masked pattern was here ####
Partition Parameters:
COLUMN_STATS_ACCURATE true
- numFiles 2
+ numFiles 1
numRows 0
rawDataSize 0
- totalSize 1427
+ totalSize 1346
#### A masked pattern was here ####
# Storage Information
Modified: hive/branches/branch-0.13/ql/src/test/results/clientpositive/insert_into6.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.13/ql/src/test/results/clientpositive/insert_into6.q.out?rev=1581010&r1=1581009&r2=1581010&view=diff
==============================================================================
--- hive/branches/branch-0.13/ql/src/test/results/clientpositive/insert_into6.q.out (original)
+++ hive/branches/branch-0.13/ql/src/test/results/clientpositive/insert_into6.q.out Mon Mar 24 19:25:48 2014
@@ -138,13 +138,8 @@ POSTHOOK: Lineage: insert_into6a PARTITI
POSTHOOK: Lineage: insert_into6a PARTITION(ds=2).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
STAGE DEPENDENCIES:
Stage-1 is a root stage
- Stage-7 depends on stages: Stage-1 , consists of Stage-4, Stage-3, Stage-5
- Stage-4
- Stage-0 depends on stages: Stage-4, Stage-3, Stage-6
+ Stage-0 depends on stages: Stage-1
Stage-2 depends on stages: Stage-0
- Stage-3
- Stage-5
- Stage-6 depends on stages: Stage-5
STAGE PLANS:
Stage: Stage-1
@@ -157,23 +152,23 @@ STAGE PLANS:
expressions: key (type: int), value (type: string), ds (type: string)
outputColumnNames: _col0, _col1, _col2
Statistics: Num rows: 250 Data size: 2680 Basic stats: COMPLETE Column stats: NONE
- File Output Operator
- compressed: false
+ Reduce Output Operator
+ key expressions: _col2 (type: string)
+ sort order: +
+ Map-reduce partition columns: _col2 (type: string)
Statistics: Num rows: 250 Data size: 2680 Basic stats: COMPLETE Column stats: NONE
- 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
- name: default.insert_into6b
-
- Stage: Stage-7
- Conditional Operator
-
- Stage: Stage-4
- Move Operator
- files:
- hdfs directory: true
-#### A masked pattern was here ####
+ value expressions: _col0 (type: int), _col1 (type: string), _col2 (type: string)
+ Reduce Operator Tree:
+ Extract
+ Statistics: Num rows: 250 Data size: 2680 Basic stats: COMPLETE Column stats: NONE
+ File Output Operator
+ compressed: false
+ Statistics: Num rows: 250 Data size: 2680 Basic stats: COMPLETE Column stats: NONE
+ 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
+ name: default.insert_into6b
Stage: Stage-0
Move Operator
@@ -190,36 +185,6 @@ STAGE PLANS:
Stage: Stage-2
Stats-Aggr Operator
- Stage: Stage-3
- Map Reduce
- Map Operator Tree:
- TableScan
- File Output Operator
- compressed: false
- 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
- name: default.insert_into6b
-
- Stage: Stage-5
- Map Reduce
- Map Operator Tree:
- TableScan
- File Output Operator
- compressed: false
- 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
- name: default.insert_into6b
-
- Stage: Stage-6
- Move Operator
- files:
- hdfs directory: true
-#### A masked pattern was here ####
-
PREHOOK: query: INSERT INTO TABLE insert_into6b PARTITION (ds) SELECT * FROM insert_into6a
PREHOOK: type: QUERY
PREHOOK: Input: default@insert_into6a
Modified: hive/branches/branch-0.13/ql/src/test/results/clientpositive/load_dyn_part1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.13/ql/src/test/results/clientpositive/load_dyn_part1.q.out?rev=1581010&r1=1581009&r2=1581010&view=diff
==============================================================================
--- hive/branches/branch-0.13/ql/src/test/results/clientpositive/load_dyn_part1.q.out (original)
+++ hive/branches/branch-0.13/ql/src/test/results/clientpositive/load_dyn_part1.q.out Mon Mar 24 19:25:48 2014
@@ -48,20 +48,11 @@ insert overwrite table nzhang_part2 part
POSTHOOK: type: QUERY
STAGE DEPENDENCIES:
Stage-2 is a root stage
- Stage-8 depends on stages: Stage-2 , consists of Stage-5, Stage-4, Stage-6
- Stage-5
- Stage-0 depends on stages: Stage-5, Stage-4, Stage-7
+ Stage-0 depends on stages: Stage-2
Stage-3 depends on stages: Stage-0
- Stage-4
- Stage-6
- Stage-7 depends on stages: Stage-6
- Stage-14 depends on stages: Stage-2 , consists of Stage-11, Stage-10, Stage-12
- Stage-11
- Stage-1 depends on stages: Stage-11, Stage-10, Stage-13
- Stage-9 depends on stages: Stage-1
- Stage-10
- Stage-12
- Stage-13 depends on stages: Stage-12
+ Stage-4 depends on stages: Stage-2
+ Stage-1 depends on stages: Stage-4
+ Stage-5 depends on stages: Stage-1
STAGE PLANS:
Stage: Stage-2
@@ -77,14 +68,12 @@ STAGE PLANS:
expressions: key (type: string), value (type: string), ds (type: string), hr (type: string)
outputColumnNames: _col0, _col1, _col2, _col3
Statistics: Num rows: 38 Data size: 7615 Basic stats: COMPLETE Column stats: NONE
- File Output Operator
- compressed: false
+ Reduce Output Operator
+ key expressions: _col2 (type: string), _col3 (type: string)
+ sort order: ++
+ Map-reduce partition columns: _col2 (type: string), _col3 (type: string)
Statistics: Num rows: 38 Data size: 7615 Basic stats: COMPLETE Column stats: NONE
- 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
- name: default.nzhang_part1
+ value expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string), _col3 (type: string)
Filter Operator
predicate: (ds > '2008-04-08') (type: boolean)
Statistics: Num rows: 38 Data size: 7615 Basic stats: COMPLETE Column stats: NONE
@@ -94,21 +83,21 @@ STAGE PLANS:
Statistics: Num rows: 38 Data size: 7615 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 38 Data size: 7615 Basic stats: COMPLETE Column stats: NONE
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
- name: default.nzhang_part2
-
- Stage: Stage-8
- Conditional Operator
-
- Stage: Stage-5
- Move Operator
- files:
- hdfs directory: true
-#### A masked pattern was here ####
+ input format: org.apache.hadoop.mapred.SequenceFileInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe
+ Reduce Operator Tree:
+ Extract
+ Statistics: Num rows: 38 Data size: 7615 Basic stats: COMPLETE Column stats: NONE
+ File Output Operator
+ compressed: false
+ Statistics: Num rows: 38 Data size: 7615 Basic stats: COMPLETE Column stats: NONE
+ 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
+ name: default.nzhang_part1
Stage: Stage-0
Move Operator
@@ -130,40 +119,23 @@ STAGE PLANS:
Map Reduce
Map Operator Tree:
TableScan
- File Output Operator
- compressed: false
- 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
- name: default.nzhang_part1
-
- Stage: Stage-6
- Map Reduce
- Map Operator Tree:
- TableScan
- File Output Operator
- compressed: false
- 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
- name: default.nzhang_part1
-
- Stage: Stage-7
- Move Operator
- files:
- hdfs directory: true
-#### A masked pattern was here ####
-
- Stage: Stage-14
- Conditional Operator
-
- Stage: Stage-11
- Move Operator
- files:
- hdfs directory: true
-#### A masked pattern was here ####
+ Reduce Output Operator
+ key expressions: _col2 (type: string)
+ sort order: +
+ Map-reduce partition columns: _col2 (type: string)
+ Statistics: Num rows: 38 Data size: 7615 Basic stats: COMPLETE Column stats: NONE
+ value expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string)
+ Reduce Operator Tree:
+ Extract
+ Statistics: Num rows: 38 Data size: 7615 Basic stats: COMPLETE Column stats: NONE
+ File Output Operator
+ compressed: false
+ Statistics: Num rows: 38 Data size: 7615 Basic stats: COMPLETE Column stats: NONE
+ 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
+ name: default.nzhang_part2
Stage: Stage-1
Move Operator
@@ -178,39 +150,9 @@ STAGE PLANS:
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.nzhang_part2
- Stage: Stage-9
+ Stage: Stage-5
Stats-Aggr Operator
- Stage: Stage-10
- Map Reduce
- Map Operator Tree:
- TableScan
- File Output Operator
- compressed: false
- 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
- name: default.nzhang_part2
-
- Stage: Stage-12
- Map Reduce
- Map Operator Tree:
- TableScan
- File Output Operator
- compressed: false
- 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
- name: default.nzhang_part2
-
- Stage: Stage-13
- Move Operator
- files:
- hdfs directory: true
-#### A masked pattern was here ####
-
PREHOOK: query: from srcpart
insert overwrite table nzhang_part1 partition (ds, hr) select key, value, ds, hr where ds <= '2008-04-08'
insert overwrite table nzhang_part2 partition(ds='2008-12-31', hr) select key, value, hr where ds > '2008-04-08'
Modified: hive/branches/branch-0.13/ql/src/test/results/clientpositive/load_dyn_part10.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.13/ql/src/test/results/clientpositive/load_dyn_part10.q.out?rev=1581010&r1=1581009&r2=1581010&view=diff
==============================================================================
--- hive/branches/branch-0.13/ql/src/test/results/clientpositive/load_dyn_part10.q.out (original)
+++ hive/branches/branch-0.13/ql/src/test/results/clientpositive/load_dyn_part10.q.out Mon Mar 24 19:25:48 2014
@@ -53,14 +53,23 @@ STAGE PLANS:
expressions: key (type: string), value (type: string), hr (type: string)
outputColumnNames: _col0, _col1, _col2
Statistics: Num rows: 58 Data size: 11624 Basic stats: COMPLETE Column stats: NONE
- File Output Operator
- compressed: false
+ Reduce Output Operator
+ key expressions: _col2 (type: string)
+ sort order: +
+ Map-reduce partition columns: _col2 (type: string)
Statistics: Num rows: 58 Data size: 11624 Basic stats: COMPLETE Column stats: NONE
- 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
- name: default.nzhang_part10
+ value expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string)
+ Reduce Operator Tree:
+ Extract
+ Statistics: Num rows: 58 Data size: 11624 Basic stats: COMPLETE Column stats: NONE
+ File Output Operator
+ compressed: false
+ Statistics: Num rows: 58 Data size: 11624 Basic stats: COMPLETE Column stats: NONE
+ 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
+ name: default.nzhang_part10
Stage: Stage-0
Move Operator
Modified: hive/branches/branch-0.13/ql/src/test/results/clientpositive/load_dyn_part14.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.13/ql/src/test/results/clientpositive/load_dyn_part14.q.out?rev=1581010&r1=1581009&r2=1581010&view=diff
==============================================================================
--- hive/branches/branch-0.13/ql/src/test/results/clientpositive/load_dyn_part14.q.out (original)
+++ hive/branches/branch-0.13/ql/src/test/results/clientpositive/load_dyn_part14.q.out Mon Mar 24 19:25:48 2014
@@ -48,16 +48,11 @@ select key, value from (
POSTHOOK: type: QUERY
STAGE DEPENDENCIES:
Stage-1 is a root stage
- Stage-2 depends on stages: Stage-1, Stage-9, Stage-10
- Stage-8 depends on stages: Stage-2 , consists of Stage-5, Stage-4, Stage-6
- Stage-5
- Stage-0 depends on stages: Stage-5, Stage-4, Stage-7
+ Stage-2 depends on stages: Stage-1, Stage-4, Stage-5
+ Stage-0 depends on stages: Stage-2
Stage-3 depends on stages: Stage-0
- Stage-4
- Stage-6
- Stage-7 depends on stages: Stage-6
- Stage-9 is a root stage
- Stage-10 is a root stage
+ Stage-4 is a root stage
+ Stage-5 is a root stage
STAGE PLANS:
Stage: Stage-1
@@ -100,14 +95,12 @@ STAGE PLANS:
expressions: _col0 (type: string), _col1 (type: string)
outputColumnNames: _col0, _col1
Statistics: Num rows: 0 Data size: 17436 Basic stats: PARTIAL Column stats: COMPLETE
- File Output Operator
- compressed: false
+ Reduce Output Operator
+ key expressions: _col1 (type: string)
+ sort order: +
+ Map-reduce partition columns: _col1 (type: string)
Statistics: Num rows: 0 Data size: 17436 Basic stats: PARTIAL Column stats: COMPLETE
- 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
- name: default.nzhang_part14
+ value expressions: _col0 (type: string), _col1 (type: string)
TableScan
Union
Statistics: Num rows: 0 Data size: 17436 Basic stats: PARTIAL Column stats: COMPLETE
@@ -115,14 +108,12 @@ STAGE PLANS:
expressions: _col0 (type: string), _col1 (type: string)
outputColumnNames: _col0, _col1
Statistics: Num rows: 0 Data size: 17436 Basic stats: PARTIAL Column stats: COMPLETE
- File Output Operator
- compressed: false
+ Reduce Output Operator
+ key expressions: _col1 (type: string)
+ sort order: +
+ Map-reduce partition columns: _col1 (type: string)
Statistics: Num rows: 0 Data size: 17436 Basic stats: PARTIAL Column stats: COMPLETE
- 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
- name: default.nzhang_part14
+ value expressions: _col0 (type: string), _col1 (type: string)
TableScan
Union
Statistics: Num rows: 0 Data size: 17436 Basic stats: PARTIAL Column stats: COMPLETE
@@ -130,23 +121,27 @@ STAGE PLANS:
expressions: _col0 (type: string), _col1 (type: string)
outputColumnNames: _col0, _col1
Statistics: Num rows: 0 Data size: 17436 Basic stats: PARTIAL Column stats: COMPLETE
- File Output Operator
- compressed: false
+ Reduce Output Operator
+ key expressions: _col1 (type: string)
+ sort order: +
+ Map-reduce partition columns: _col1 (type: string)
Statistics: Num rows: 0 Data size: 17436 Basic stats: PARTIAL Column stats: COMPLETE
- 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
- name: default.nzhang_part14
-
- Stage: Stage-8
- Conditional Operator
-
- Stage: Stage-5
- Move Operator
- files:
- hdfs directory: true
-#### A masked pattern was here ####
+ value expressions: _col0 (type: string), _col1 (type: string)
+ Reduce Operator Tree:
+ Extract
+ Statistics: Num rows: 0 Data size: 17436 Basic stats: PARTIAL Column stats: COMPLETE
+ Select Operator
+ expressions: _col0 (type: string), _col1 (type: string)
+ outputColumnNames: _col0, _col1
+ Statistics: Num rows: 0 Data size: 17436 Basic stats: PARTIAL Column stats: COMPLETE
+ File Output Operator
+ compressed: false
+ Statistics: Num rows: 0 Data size: 17436 Basic stats: PARTIAL Column stats: COMPLETE
+ 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
+ name: default.nzhang_part14
Stage: Stage-0
Move Operator
@@ -167,36 +162,6 @@ STAGE PLANS:
Map Reduce
Map Operator Tree:
TableScan
- File Output Operator
- compressed: false
- 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
- name: default.nzhang_part14
-
- Stage: Stage-6
- Map Reduce
- Map Operator Tree:
- TableScan
- File Output Operator
- compressed: false
- 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
- name: default.nzhang_part14
-
- Stage: Stage-7
- Move Operator
- files:
- hdfs directory: true
-#### A masked pattern was here ####
-
- Stage: Stage-9
- Map Reduce
- Map Operator Tree:
- TableScan
alias: src
Statistics: Num rows: 0 Data size: 5812 Basic stats: PARTIAL Column stats: COMPLETE
Select Operator
@@ -223,7 +188,7 @@ STAGE PLANS:
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe
- Stage: Stage-10
+ Stage: Stage-5
Map Reduce
Map Operator Tree:
TableScan
Modified: hive/branches/branch-0.13/ql/src/test/results/clientpositive/load_dyn_part3.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.13/ql/src/test/results/clientpositive/load_dyn_part3.q.out?rev=1581010&r1=1581009&r2=1581010&view=diff
==============================================================================
--- hive/branches/branch-0.13/ql/src/test/results/clientpositive/load_dyn_part3.q.out (original)
+++ hive/branches/branch-0.13/ql/src/test/results/clientpositive/load_dyn_part3.q.out Mon Mar 24 19:25:48 2014
@@ -51,14 +51,23 @@ STAGE PLANS:
expressions: key (type: string), value (type: string), ds (type: string), hr (type: string)
outputColumnNames: _col0, _col1, _col2, _col3
Statistics: Num rows: 116 Data size: 23248 Basic stats: COMPLETE Column stats: NONE
- File Output Operator
- compressed: false
+ Reduce Output Operator
+ key expressions: _col2 (type: string), _col3 (type: string)
+ sort order: ++
+ Map-reduce partition columns: _col2 (type: string), _col3 (type: string)
Statistics: Num rows: 116 Data size: 23248 Basic stats: COMPLETE Column stats: NONE
- 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
- name: default.nzhang_part3
+ value expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string), _col3 (type: string)
+ Reduce Operator Tree:
+ Extract
+ Statistics: Num rows: 116 Data size: 23248 Basic stats: COMPLETE Column stats: NONE
+ File Output Operator
+ compressed: false
+ Statistics: Num rows: 116 Data size: 23248 Basic stats: COMPLETE Column stats: NONE
+ 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
+ name: default.nzhang_part3
Stage: Stage-0
Move Operator
Modified: hive/branches/branch-0.13/ql/src/test/results/clientpositive/load_dyn_part4.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.13/ql/src/test/results/clientpositive/load_dyn_part4.q.out?rev=1581010&r1=1581009&r2=1581010&view=diff
==============================================================================
--- hive/branches/branch-0.13/ql/src/test/results/clientpositive/load_dyn_part4.q.out (original)
+++ hive/branches/branch-0.13/ql/src/test/results/clientpositive/load_dyn_part4.q.out Mon Mar 24 19:25:48 2014
@@ -63,14 +63,23 @@ STAGE PLANS:
expressions: key (type: string), value (type: string), ds (type: string), hr (type: string)
outputColumnNames: _col0, _col1, _col2, _col3
Statistics: Num rows: 116 Data size: 23248 Basic stats: COMPLETE Column stats: NONE
- File Output Operator
- compressed: false
+ Reduce Output Operator
+ key expressions: _col2 (type: string), _col3 (type: string)
+ sort order: ++
+ Map-reduce partition columns: _col2 (type: string), _col3 (type: string)
Statistics: Num rows: 116 Data size: 23248 Basic stats: COMPLETE Column stats: NONE
- 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
- name: default.nzhang_part4
+ value expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string), _col3 (type: string)
+ Reduce Operator Tree:
+ Extract
+ Statistics: Num rows: 116 Data size: 23248 Basic stats: COMPLETE Column stats: NONE
+ File Output Operator
+ compressed: false
+ Statistics: Num rows: 116 Data size: 23248 Basic stats: COMPLETE Column stats: NONE
+ 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
+ name: default.nzhang_part4
Stage: Stage-0
Move Operator
Modified: hive/branches/branch-0.13/ql/src/test/results/clientpositive/load_dyn_part5.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.13/ql/src/test/results/clientpositive/load_dyn_part5.q.out?rev=1581010&r1=1581009&r2=1581010&view=diff
==============================================================================
--- hive/branches/branch-0.13/ql/src/test/results/clientpositive/load_dyn_part5.q.out (original)
+++ hive/branches/branch-0.13/ql/src/test/results/clientpositive/load_dyn_part5.q.out Mon Mar 24 19:25:48 2014
@@ -40,14 +40,23 @@ STAGE PLANS:
expressions: key (type: string), value (type: string)
outputColumnNames: _col0, _col1
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
- File Output Operator
- compressed: false
+ Reduce Output Operator
+ key expressions: _col1 (type: string)
+ sort order: +
+ Map-reduce partition columns: _col1 (type: string)
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
- 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
- name: default.nzhang_part5
+ value expressions: _col0 (type: string), _col1 (type: string)
+ Reduce Operator Tree:
+ Extract
+ Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
+ File Output Operator
+ compressed: false
+ Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
+ 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
+ name: default.nzhang_part5
Stage: Stage-0
Move Operator
Modified: hive/branches/branch-0.13/ql/src/test/results/clientpositive/load_dyn_part8.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.13/ql/src/test/results/clientpositive/load_dyn_part8.q.out?rev=1581010&r1=1581009&r2=1581010&view=diff
==============================================================================
Files hive/branches/branch-0.13/ql/src/test/results/clientpositive/load_dyn_part8.q.out (original) and hive/branches/branch-0.13/ql/src/test/results/clientpositive/load_dyn_part8.q.out Mon Mar 24 19:25:48 2014 differ
Modified: hive/branches/branch-0.13/ql/src/test/results/clientpositive/load_dyn_part9.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.13/ql/src/test/results/clientpositive/load_dyn_part9.q.out?rev=1581010&r1=1581009&r2=1581010&view=diff
==============================================================================
--- hive/branches/branch-0.13/ql/src/test/results/clientpositive/load_dyn_part9.q.out (original)
+++ hive/branches/branch-0.13/ql/src/test/results/clientpositive/load_dyn_part9.q.out Mon Mar 24 19:25:48 2014
@@ -53,14 +53,23 @@ STAGE PLANS:
expressions: key (type: string), value (type: string), ds (type: string), hr (type: string)
outputColumnNames: _col0, _col1, _col2, _col3
Statistics: Num rows: 58 Data size: 11624 Basic stats: COMPLETE Column stats: NONE
- File Output Operator
- compressed: false
+ Reduce Output Operator
+ key expressions: _col2 (type: string), _col3 (type: string)
+ sort order: ++
+ Map-reduce partition columns: _col2 (type: string), _col3 (type: string)
Statistics: Num rows: 58 Data size: 11624 Basic stats: COMPLETE Column stats: NONE
- 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
- name: default.nzhang_part9
+ value expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string), _col3 (type: string)
+ Reduce Operator Tree:
+ Extract
+ Statistics: Num rows: 58 Data size: 11624 Basic stats: COMPLETE Column stats: NONE
+ File Output Operator
+ compressed: false
+ Statistics: Num rows: 58 Data size: 11624 Basic stats: COMPLETE Column stats: NONE
+ 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
+ name: default.nzhang_part9
Stage: Stage-0
Move Operator
Modified: hive/branches/branch-0.13/ql/src/test/results/clientpositive/merge3.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.13/ql/src/test/results/clientpositive/merge3.q.out?rev=1581010&r1=1581009&r2=1581010&view=diff
==============================================================================
Files hive/branches/branch-0.13/ql/src/test/results/clientpositive/merge3.q.out (original) and hive/branches/branch-0.13/ql/src/test/results/clientpositive/merge3.q.out Mon Mar 24 19:25:48 2014 differ
Modified: hive/branches/branch-0.13/ql/src/test/results/clientpositive/merge4.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.13/ql/src/test/results/clientpositive/merge4.q.out?rev=1581010&r1=1581009&r2=1581010&view=diff
==============================================================================
--- hive/branches/branch-0.13/ql/src/test/results/clientpositive/merge4.q.out (original)
+++ hive/branches/branch-0.13/ql/src/test/results/clientpositive/merge4.q.out Mon Mar 24 19:25:48 2014
@@ -32,14 +32,23 @@ STAGE PLANS:
expressions: key (type: string), value (type: string), hr (type: string)
outputColumnNames: _col0, _col1, _col2
Statistics: Num rows: 58 Data size: 11624 Basic stats: COMPLETE Column stats: NONE
- File Output Operator
- compressed: false
+ Reduce Output Operator
+ key expressions: _col2 (type: string)
+ sort order: +
+ Map-reduce partition columns: _col2 (type: string)
Statistics: Num rows: 58 Data size: 11624 Basic stats: COMPLETE Column stats: NONE
- 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
- name: default.nzhang_part
+ value expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string)
+ Reduce Operator Tree:
+ Extract
+ Statistics: Num rows: 58 Data size: 11624 Basic stats: COMPLETE Column stats: NONE
+ File Output Operator
+ compressed: false
+ Statistics: Num rows: 58 Data size: 11624 Basic stats: COMPLETE Column stats: NONE
+ 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
+ name: default.nzhang_part
Stage: Stage-7
Conditional Operator
@@ -2838,14 +2847,12 @@ STAGE PLANS:
expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string)
outputColumnNames: _col0, _col1, _col2
Statistics: Num rows: 58 Data size: 17436 Basic stats: COMPLETE Column stats: COMPLETE
- File Output Operator
- compressed: false
+ Reduce Output Operator
+ key expressions: _col2 (type: string)
+ sort order: +
+ Map-reduce partition columns: _col2 (type: string)
Statistics: Num rows: 58 Data size: 17436 Basic stats: COMPLETE Column stats: COMPLETE
- 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
- name: default.nzhang_part
+ value expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string)
TableScan
Union
Statistics: Num rows: 58 Data size: 17436 Basic stats: COMPLETE Column stats: COMPLETE
@@ -2853,14 +2860,27 @@ STAGE PLANS:
expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string)
outputColumnNames: _col0, _col1, _col2
Statistics: Num rows: 58 Data size: 17436 Basic stats: COMPLETE Column stats: COMPLETE
- File Output Operator
- compressed: false
+ Reduce Output Operator
+ key expressions: _col2 (type: string)
+ sort order: +
+ Map-reduce partition columns: _col2 (type: string)
Statistics: Num rows: 58 Data size: 17436 Basic stats: COMPLETE Column stats: COMPLETE
- 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
- name: default.nzhang_part
+ value expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string)
+ Reduce Operator Tree:
+ Extract
+ Statistics: Num rows: 58 Data size: 17436 Basic stats: COMPLETE Column stats: COMPLETE
+ Select Operator
+ expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string)
+ outputColumnNames: _col0, _col1, _col2
+ Statistics: Num rows: 58 Data size: 0 Basic stats: PARTIAL Column stats: COMPLETE
+ File Output Operator
+ compressed: false
+ Statistics: Num rows: 58 Data size: 0 Basic stats: PARTIAL Column stats: COMPLETE
+ 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
+ name: default.nzhang_part
Stage: Stage-8
Conditional Operator
Modified: hive/branches/branch-0.13/ql/src/test/results/clientpositive/merge_dynamic_partition3.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.13/ql/src/test/results/clientpositive/merge_dynamic_partition3.q.out?rev=1581010&r1=1581009&r2=1581010&view=diff
==============================================================================
--- hive/branches/branch-0.13/ql/src/test/results/clientpositive/merge_dynamic_partition3.q.out (original)
+++ hive/branches/branch-0.13/ql/src/test/results/clientpositive/merge_dynamic_partition3.q.out Mon Mar 24 19:25:48 2014
@@ -147,14 +147,23 @@ STAGE PLANS:
expressions: key (type: string), value (type: string), ds (type: string), hr (type: string)
outputColumnNames: _col0, _col1, _col2, _col3
Statistics: Num rows: 174 Data size: 34830 Basic stats: COMPLETE Column stats: NONE
- File Output Operator
- compressed: false
+ Reduce Output Operator
+ key expressions: _col2 (type: string), _col3 (type: string)
+ sort order: ++
+ Map-reduce partition columns: _col2 (type: string), _col3 (type: string)
Statistics: Num rows: 174 Data size: 34830 Basic stats: COMPLETE Column stats: NONE
- 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
- name: default.merge_dynamic_part
+ value expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string), _col3 (type: string)
+ Reduce Operator Tree:
+ Extract
+ Statistics: Num rows: 174 Data size: 34830 Basic stats: COMPLETE Column stats: NONE
+ File Output Operator
+ compressed: false
+ Statistics: Num rows: 174 Data size: 34830 Basic stats: COMPLETE Column stats: NONE
+ 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
+ name: default.merge_dynamic_part
Stage: Stage-7
Conditional Operator
@@ -285,9 +294,9 @@ outputformat:org.apache.hadoop.hive.ql.i
columns:struct columns { string key, string value}
partitioned:true
partitionColumns:struct partition_columns { string ds, string hr}
-totalNumberFiles:6
+totalNumberFiles:4
totalFileSize:34830
-maxFileSize:5812
-minFileSize:5791
+maxFileSize:11603
+minFileSize:5812
#### A masked pattern was here ####
Modified: hive/branches/branch-0.13/ql/src/test/results/clientpositive/merge_dynamic_partition4.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.13/ql/src/test/results/clientpositive/merge_dynamic_partition4.q.out?rev=1581010&r1=1581009&r2=1581010&view=diff
==============================================================================
--- hive/branches/branch-0.13/ql/src/test/results/clientpositive/merge_dynamic_partition4.q.out (original)
+++ hive/branches/branch-0.13/ql/src/test/results/clientpositive/merge_dynamic_partition4.q.out Mon Mar 24 19:25:48 2014
@@ -159,14 +159,23 @@ STAGE PLANS:
expressions: key (type: string), value (type: string), if(((key % 2) = 0), 'a1', 'b1') (type: string)
outputColumnNames: _col0, _col1, _col2
Statistics: Num rows: 1000 Data size: 9624 Basic stats: COMPLETE Column stats: NONE
- File Output Operator
- compressed: false
+ Reduce Output Operator
+ key expressions: _col2 (type: string)
+ sort order: +
+ Map-reduce partition columns: _col2 (type: string)
Statistics: Num rows: 1000 Data size: 9624 Basic stats: COMPLETE Column stats: NONE
- table:
- input format: org.apache.hadoop.hive.ql.io.RCFileInputFormat
- output format: org.apache.hadoop.hive.ql.io.RCFileOutputFormat
- serde: org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe
- name: default.merge_dynamic_part
+ value expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string)
+ Reduce Operator Tree:
+ Extract
+ Statistics: Num rows: 1000 Data size: 9624 Basic stats: COMPLETE Column stats: NONE
+ File Output Operator
+ compressed: false
+ Statistics: Num rows: 1000 Data size: 9624 Basic stats: COMPLETE Column stats: NONE
+ table:
+ input format: org.apache.hadoop.hive.ql.io.RCFileInputFormat
+ output format: org.apache.hadoop.hive.ql.io.RCFileOutputFormat
+ serde: org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe
+ name: default.merge_dynamic_part
Stage: Stage-7
Conditional Operator
Modified: hive/branches/branch-0.13/ql/src/test/results/clientpositive/merge_dynamic_partition5.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.13/ql/src/test/results/clientpositive/merge_dynamic_partition5.q.out?rev=1581010&r1=1581009&r2=1581010&view=diff
==============================================================================
--- hive/branches/branch-0.13/ql/src/test/results/clientpositive/merge_dynamic_partition5.q.out (original)
+++ hive/branches/branch-0.13/ql/src/test/results/clientpositive/merge_dynamic_partition5.q.out Mon Mar 24 19:25:48 2014
@@ -133,14 +133,23 @@ STAGE PLANS:
expressions: key (type: string), value (type: string), if(((key % 100) = 0), 'a1', 'b1') (type: string)
outputColumnNames: _col0, _col1, _col2
Statistics: Num rows: 618 Data size: 5934 Basic stats: COMPLETE Column stats: NONE
- File Output Operator
- compressed: false
+ Reduce Output Operator
+ key expressions: _col2 (type: string)
+ sort order: +
+ Map-reduce partition columns: _col2 (type: string)
Statistics: Num rows: 618 Data size: 5934 Basic stats: COMPLETE Column stats: NONE
- table:
- input format: org.apache.hadoop.hive.ql.io.RCFileInputFormat
- output format: org.apache.hadoop.hive.ql.io.RCFileOutputFormat
- serde: org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe
- name: default.merge_dynamic_part
+ value expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string)
+ Reduce Operator Tree:
+ Extract
+ Statistics: Num rows: 618 Data size: 5934 Basic stats: COMPLETE Column stats: NONE
+ File Output Operator
+ compressed: false
+ Statistics: Num rows: 618 Data size: 5934 Basic stats: COMPLETE Column stats: NONE
+ table:
+ input format: org.apache.hadoop.hive.ql.io.RCFileInputFormat
+ output format: org.apache.hadoop.hive.ql.io.RCFileOutputFormat
+ serde: org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe
+ name: default.merge_dynamic_part
Stage: Stage-7
Conditional Operator
Modified: hive/branches/branch-0.13/ql/src/test/results/clientpositive/orc_analyze.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.13/ql/src/test/results/clientpositive/orc_analyze.q.out?rev=1581010&r1=1581009&r2=1581010&view=diff
==============================================================================
--- hive/branches/branch-0.13/ql/src/test/results/clientpositive/orc_analyze.q.out (original)
+++ hive/branches/branch-0.13/ql/src/test/results/clientpositive/orc_analyze.q.out Mon Mar 24 19:25:48 2014
@@ -429,7 +429,7 @@ Partition Parameters:
numFiles 1
numRows 50
rawDataSize 14450
- totalSize 1744
+ totalSize 1787
#### A masked pattern was here ####
# Storage Information
@@ -665,7 +665,7 @@ Partition Parameters:
numFiles 1
numRows 50
rawDataSize 14450
- totalSize 1744
+ totalSize 1787
#### A masked pattern was here ####
# Storage Information
@@ -915,10 +915,10 @@ Protect Mode: None
#### A masked pattern was here ####
Partition Parameters:
COLUMN_STATS_ACCURATE true
- numFiles 1
+ numFiles 4
numRows 50
- rawDataSize 14350
- totalSize 1728
+ rawDataSize 14380
+ totalSize 3901
#### A masked pattern was here ####
# Storage Information
@@ -990,10 +990,10 @@ Protect Mode: None
#### A masked pattern was here ####
Partition Parameters:
COLUMN_STATS_ACCURATE true
- numFiles 1
+ numFiles 4
numRows 50
- rawDataSize 14450
- totalSize 1744
+ rawDataSize 14448
+ totalSize 3960
#### A masked pattern was here ####
# Storage Information
@@ -1229,10 +1229,10 @@ Protect Mode: None
#### A masked pattern was here ####
Partition Parameters:
COLUMN_STATS_ACCURATE true
- numFiles 1
+ numFiles 4
numRows 50
- rawDataSize 14350
- totalSize 1728
+ rawDataSize 14380
+ totalSize 3901
#### A masked pattern was here ####
# Storage Information
@@ -1312,10 +1312,10 @@ Protect Mode: None
#### A masked pattern was here ####
Partition Parameters:
COLUMN_STATS_ACCURATE true
- numFiles 1
+ numFiles 4
numRows 50
- rawDataSize 14450
- totalSize 1744
+ rawDataSize 14448
+ totalSize 3960
#### A masked pattern was here ####
# Storage Information
Modified: hive/branches/branch-0.13/ql/src/test/results/clientpositive/orc_create.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.13/ql/src/test/results/clientpositive/orc_create.q.out?rev=1581010&r1=1581009&r2=1581010&view=diff
==============================================================================
--- hive/branches/branch-0.13/ql/src/test/results/clientpositive/orc_create.q.out (original)
+++ hive/branches/branch-0.13/ql/src/test/results/clientpositive/orc_create.q.out Mon Mar 24 19:25:48 2014
@@ -734,11 +734,11 @@ POSTHOOK: Lineage: orc_create_people PAR
95 Winifred Hopper Ap #140-8982 Velit Avenue
97 Dana Carter 814-601 Purus. Av.
99 Wynter Vincent 626-8492 Mollis Avenue
-92 Thane Oneil 6766 Lectus St.
-94 Lael Mclean 500-7010 Sit St.
-96 Rafael England P.O. Box 405, 7857 Eget Av.
98 Juliet Battle Ap #535-1965 Cursus St.
+96 Rafael England P.O. Box 405, 7857 Eget Av.
+92 Thane Oneil 6766 Lectus St.
100 Wang Mitchell 4023 Lacinia. Ave
+94 Lael Mclean 500-7010 Sit St.
PREHOOK: query: DROP TABLE orc_create
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@orc_create
Modified: hive/branches/branch-0.13/ql/src/test/results/clientpositive/sample10.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.13/ql/src/test/results/clientpositive/sample10.q.out?rev=1581010&r1=1581009&r2=1581010&view=diff
==============================================================================
Files hive/branches/branch-0.13/ql/src/test/results/clientpositive/sample10.q.out (original) and hive/branches/branch-0.13/ql/src/test/results/clientpositive/sample10.q.out Mon Mar 24 19:25:48 2014 differ
Modified: hive/branches/branch-0.13/ql/src/test/results/clientpositive/stats2.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.13/ql/src/test/results/clientpositive/stats2.q.out?rev=1581010&r1=1581009&r2=1581010&view=diff
==============================================================================
--- hive/branches/branch-0.13/ql/src/test/results/clientpositive/stats2.q.out (original)
+++ hive/branches/branch-0.13/ql/src/test/results/clientpositive/stats2.q.out Mon Mar 24 19:25:48 2014
@@ -26,14 +26,23 @@ STAGE PLANS:
expressions: key (type: string), value (type: string), ds (type: string), hr (type: string)
outputColumnNames: _col0, _col1, _col2, _col3
Statistics: Num rows: 116 Data size: 23248 Basic stats: COMPLETE Column stats: NONE
- File Output Operator
- compressed: false
+ Reduce Output Operator
+ key expressions: _col2 (type: string), _col3 (type: string)
+ sort order: ++
+ Map-reduce partition columns: _col2 (type: string), _col3 (type: string)
Statistics: Num rows: 116 Data size: 23248 Basic stats: COMPLETE Column stats: NONE
- 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
- name: default.analyze_t1
+ value expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string), _col3 (type: string)
+ Reduce Operator Tree:
+ Extract
+ Statistics: Num rows: 116 Data size: 23248 Basic stats: COMPLETE Column stats: NONE
+ File Output Operator
+ compressed: false
+ Statistics: Num rows: 116 Data size: 23248 Basic stats: COMPLETE Column stats: NONE
+ 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
+ name: default.analyze_t1
Stage: Stage-0
Move Operator
Modified: hive/branches/branch-0.13/ql/src/test/results/clientpositive/stats4.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.13/ql/src/test/results/clientpositive/stats4.q.out?rev=1581010&r1=1581009&r2=1581010&view=diff
==============================================================================
--- hive/branches/branch-0.13/ql/src/test/results/clientpositive/stats4.q.out (original)
+++ hive/branches/branch-0.13/ql/src/test/results/clientpositive/stats4.q.out Mon Mar 24 19:25:48 2014
@@ -40,20 +40,11 @@ insert overwrite table nzhang_part2 part
POSTHOOK: type: QUERY
STAGE DEPENDENCIES:
Stage-2 is a root stage
- Stage-8 depends on stages: Stage-2 , consists of Stage-5, Stage-4, Stage-6
- Stage-5
- Stage-0 depends on stages: Stage-5, Stage-4, Stage-7
+ Stage-0 depends on stages: Stage-2
Stage-3 depends on stages: Stage-0
- Stage-4
- Stage-6
- Stage-7 depends on stages: Stage-6
- Stage-14 depends on stages: Stage-2 , consists of Stage-11, Stage-10, Stage-12
- Stage-11
- Stage-1 depends on stages: Stage-11, Stage-10, Stage-13
- Stage-9 depends on stages: Stage-1
- Stage-10
- Stage-12
- Stage-13 depends on stages: Stage-12
+ Stage-4 depends on stages: Stage-2
+ Stage-1 depends on stages: Stage-4
+ Stage-5 depends on stages: Stage-1
STAGE PLANS:
Stage: Stage-2
@@ -69,14 +60,12 @@ STAGE PLANS:
expressions: key (type: string), value (type: string), ds (type: string), hr (type: string)
outputColumnNames: _col0, _col1, _col2, _col3
Statistics: Num rows: 38 Data size: 7615 Basic stats: COMPLETE Column stats: NONE
- File Output Operator
- compressed: false
+ Reduce Output Operator
+ key expressions: _col2 (type: string), _col3 (type: string)
+ sort order: ++
+ Map-reduce partition columns: _col2 (type: string), _col3 (type: string)
Statistics: Num rows: 38 Data size: 7615 Basic stats: COMPLETE Column stats: NONE
- 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
- name: default.nzhang_part1
+ value expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string), _col3 (type: string)
Filter Operator
predicate: (ds > '2008-04-08') (type: boolean)
Statistics: Num rows: 38 Data size: 7615 Basic stats: COMPLETE Column stats: NONE
@@ -86,21 +75,21 @@ STAGE PLANS:
Statistics: Num rows: 38 Data size: 7615 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 38 Data size: 7615 Basic stats: COMPLETE Column stats: NONE
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
- name: default.nzhang_part2
-
- Stage: Stage-8
- Conditional Operator
-
- Stage: Stage-5
- Move Operator
- files:
- hdfs directory: true
-#### A masked pattern was here ####
+ input format: org.apache.hadoop.mapred.SequenceFileInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe
+ Reduce Operator Tree:
+ Extract
+ Statistics: Num rows: 38 Data size: 7615 Basic stats: COMPLETE Column stats: NONE
+ File Output Operator
+ compressed: false
+ Statistics: Num rows: 38 Data size: 7615 Basic stats: COMPLETE Column stats: NONE
+ 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
+ name: default.nzhang_part1
Stage: Stage-0
Move Operator
@@ -122,40 +111,23 @@ STAGE PLANS:
Map Reduce
Map Operator Tree:
TableScan
- File Output Operator
- compressed: false
- 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
- name: default.nzhang_part1
-
- Stage: Stage-6
- Map Reduce
- Map Operator Tree:
- TableScan
- File Output Operator
- compressed: false
- 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
- name: default.nzhang_part1
-
- Stage: Stage-7
- Move Operator
- files:
- hdfs directory: true
-#### A masked pattern was here ####
-
- Stage: Stage-14
- Conditional Operator
-
- Stage: Stage-11
- Move Operator
- files:
- hdfs directory: true
-#### A masked pattern was here ####
+ Reduce Output Operator
+ key expressions: _col2 (type: string)
+ sort order: +
+ Map-reduce partition columns: _col2 (type: string)
+ Statistics: Num rows: 38 Data size: 7615 Basic stats: COMPLETE Column stats: NONE
+ value expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string)
+ Reduce Operator Tree:
+ Extract
+ Statistics: Num rows: 38 Data size: 7615 Basic stats: COMPLETE Column stats: NONE
+ File Output Operator
+ compressed: false
+ Statistics: Num rows: 38 Data size: 7615 Basic stats: COMPLETE Column stats: NONE
+ 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
+ name: default.nzhang_part2
Stage: Stage-1
Move Operator
@@ -170,39 +142,9 @@ STAGE PLANS:
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.nzhang_part2
- Stage: Stage-9
+ Stage: Stage-5
Stats-Aggr Operator
- Stage: Stage-10
- Map Reduce
- Map Operator Tree:
- TableScan
- File Output Operator
- compressed: false
- 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
- name: default.nzhang_part2
-
- Stage: Stage-12
- Map Reduce
- Map Operator Tree:
- TableScan
- File Output Operator
- compressed: false
- 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
- name: default.nzhang_part2
-
- Stage: Stage-13
- Move Operator
- files:
- hdfs directory: true
-#### A masked pattern was here ####
-
PREHOOK: query: from srcpart
insert overwrite table nzhang_part1 partition (ds, hr) select key, value, ds, hr where ds <= '2008-04-08'
insert overwrite table nzhang_part2 partition(ds='2008-12-31', hr) select key, value, hr where ds > '2008-04-08'
Modified: hive/branches/branch-0.13/ql/src/test/results/clientpositive/stats_empty_dyn_part.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.13/ql/src/test/results/clientpositive/stats_empty_dyn_part.q.out?rev=1581010&r1=1581009&r2=1581010&view=diff
==============================================================================
--- hive/branches/branch-0.13/ql/src/test/results/clientpositive/stats_empty_dyn_part.q.out (original)
+++ hive/branches/branch-0.13/ql/src/test/results/clientpositive/stats_empty_dyn_part.q.out Mon Mar 24 19:25:48 2014
@@ -19,13 +19,8 @@ POSTHOOK: query: explain insert overwrit
POSTHOOK: type: QUERY
STAGE DEPENDENCIES:
Stage-1 is a root stage
- Stage-7 depends on stages: Stage-1 , consists of Stage-4, Stage-3, Stage-5
- Stage-4
- Stage-0 depends on stages: Stage-4, Stage-3, Stage-6
+ Stage-0 depends on stages: Stage-1
Stage-2 depends on stages: Stage-0
- Stage-3
- Stage-5
- Stage-6 depends on stages: Stage-5
STAGE PLANS:
Stage: Stage-1
@@ -41,23 +36,23 @@ STAGE PLANS:
expressions: key (type: string), value (type: string)
outputColumnNames: _col0, _col1
Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE
- File Output Operator
- compressed: false
+ Reduce Output Operator
+ key expressions: _col1 (type: string)
+ sort order: +
+ Map-reduce partition columns: _col1 (type: string)
Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE
- 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
- name: default.tmptable
-
- Stage: Stage-7
- Conditional Operator
-
- Stage: Stage-4
- Move Operator
- files:
- hdfs directory: true
-#### A masked pattern was here ####
+ value expressions: _col0 (type: string), _col1 (type: string)
+ Reduce Operator Tree:
+ Extract
+ Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE
+ File Output Operator
+ compressed: false
+ Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE
+ 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
+ name: default.tmptable
Stage: Stage-0
Move Operator
@@ -74,36 +69,6 @@ STAGE PLANS:
Stage: Stage-2
Stats-Aggr Operator
- Stage: Stage-3
- Map Reduce
- Map Operator Tree:
- TableScan
- File Output Operator
- compressed: false
- 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
- name: default.tmptable
-
- Stage: Stage-5
- Map Reduce
- Map Operator Tree:
- TableScan
- File Output Operator
- compressed: false
- 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
- name: default.tmptable
-
- Stage: Stage-6
- Move Operator
- files:
- hdfs directory: true
-#### A masked pattern was here ####
-
PREHOOK: query: insert overwrite table tmptable partition (part) select key, value from src where key = 'no_such_value'
PREHOOK: type: QUERY
PREHOOK: Input: default@src