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 2014/09/23 21:30:14 UTC
svn commit: r1627125 [3/7] - in /hive/branches/cbo: ./
beeline/src/java/org/apache/hive/beeline/ bin/ bin/ext/
common/src/java/org/apache/hadoop/hive/conf/
hcatalog/core/src/test/java/org/apache/hive/hcatalog/mapreduce/
hcatalog/webhcat/svr/src/test/ja...
Modified: hive/branches/cbo/ql/src/test/resources/orc-file-dump.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/resources/orc-file-dump.out?rev=1627125&r1=1627124&r2=1627125&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/resources/orc-file-dump.out (original)
+++ hive/branches/cbo/ql/src/test/resources/orc-file-dump.out Tue Sep 23 19:30:11 2014
@@ -38,16 +38,16 @@ File Statistics:
Column 3: count: 21000 min: Darkness, max: worst sum: 81761
Stripes:
- Stripe: offset: 3 data: 63766 rows: 5000 tail: 79 index: 428
+ Stripe: offset: 3 data: 63765 rows: 5000 tail: 79 index: 428
Stream: column 0 section ROW_INDEX start: 3 length 15
Stream: column 1 section ROW_INDEX start: 18 length 158
Stream: column 2 section ROW_INDEX start: 176 length 171
Stream: column 3 section ROW_INDEX start: 347 length 84
Stream: column 1 section DATA start: 431 length 20029
Stream: column 2 section DATA start: 20460 length 40035
- Stream: column 3 section DATA start: 60495 length 3544
- Stream: column 3 section LENGTH start: 64039 length 25
- Stream: column 3 section DICTIONARY_DATA start: 64064 length 133
+ Stream: column 3 section DATA start: 60495 length 3543
+ Stream: column 3 section LENGTH start: 64038 length 25
+ Stream: column 3 section DICTIONARY_DATA start: 64063 length 133
Encoding column 0: DIRECT
Encoding column 1: DIRECT_V2
Encoding column 2: DIRECT_V2
@@ -68,18 +68,18 @@ Stripes:
Entry 0: count: 1000 min: Darkness, max: worst positions: 0,0,0
Entry 1: count: 1000 min: Darkness, max: worst positions: 0,659,149
Entry 2: count: 1000 min: Darkness, max: worst positions: 0,1531,3
- Entry 3: count: 1000 min: Darkness, max: worst positions: 0,2282,32
- Entry 4: count: 1000 min: Darkness, max: worst positions: 0,3034,45
- Stripe: offset: 64276 data: 63755 rows: 5000 tail: 79 index: 421
- Stream: column 0 section ROW_INDEX start: 64276 length 15
- Stream: column 1 section ROW_INDEX start: 64291 length 157
- Stream: column 2 section ROW_INDEX start: 64448 length 169
- Stream: column 3 section ROW_INDEX start: 64617 length 80
- Stream: column 1 section DATA start: 64697 length 20029
- Stream: column 2 section DATA start: 84726 length 40035
- Stream: column 3 section DATA start: 124761 length 3533
- Stream: column 3 section LENGTH start: 128294 length 25
- Stream: column 3 section DICTIONARY_DATA start: 128319 length 133
+ Entry 3: count: 1000 min: Darkness, max: worst positions: 0,2281,32
+ Entry 4: count: 1000 min: Darkness, max: worst positions: 0,3033,45
+ Stripe: offset: 64275 data: 63754 rows: 5000 tail: 79 index: 421
+ Stream: column 0 section ROW_INDEX start: 64275 length 15
+ Stream: column 1 section ROW_INDEX start: 64290 length 157
+ Stream: column 2 section ROW_INDEX start: 64447 length 169
+ Stream: column 3 section ROW_INDEX start: 64616 length 80
+ Stream: column 1 section DATA start: 64696 length 20029
+ Stream: column 2 section DATA start: 84725 length 40035
+ Stream: column 3 section DATA start: 124760 length 3532
+ Stream: column 3 section LENGTH start: 128292 length 25
+ Stream: column 3 section DICTIONARY_DATA start: 128317 length 133
Encoding column 0: DIRECT
Encoding column 1: DIRECT_V2
Encoding column 2: DIRECT_V2
@@ -101,17 +101,17 @@ Stripes:
Entry 1: count: 1000 min: Darkness, max: worst positions: 0,761,12
Entry 2: count: 1000 min: Darkness, max: worst positions: 0,1472,70
Entry 3: count: 1000 min: Darkness, max: worst positions: 0,2250,43
- Entry 4: count: 1000 min: Darkness, max: worst positions: 0,2979,88
- Stripe: offset: 128531 data: 63766 rows: 5000 tail: 79 index: 422
- Stream: column 0 section ROW_INDEX start: 128531 length 15
- Stream: column 1 section ROW_INDEX start: 128546 length 153
- Stream: column 2 section ROW_INDEX start: 128699 length 169
- Stream: column 3 section ROW_INDEX start: 128868 length 85
- Stream: column 1 section DATA start: 128953 length 20029
- Stream: column 2 section DATA start: 148982 length 40035
- Stream: column 3 section DATA start: 189017 length 3544
- Stream: column 3 section LENGTH start: 192561 length 25
- Stream: column 3 section DICTIONARY_DATA start: 192586 length 133
+ Entry 4: count: 1000 min: Darkness, max: worst positions: 0,2978,88
+ Stripe: offset: 128529 data: 63766 rows: 5000 tail: 79 index: 422
+ Stream: column 0 section ROW_INDEX start: 128529 length 15
+ Stream: column 1 section ROW_INDEX start: 128544 length 153
+ Stream: column 2 section ROW_INDEX start: 128697 length 169
+ Stream: column 3 section ROW_INDEX start: 128866 length 85
+ Stream: column 1 section DATA start: 128951 length 20029
+ Stream: column 2 section DATA start: 148980 length 40035
+ Stream: column 3 section DATA start: 189015 length 3544
+ Stream: column 3 section LENGTH start: 192559 length 25
+ Stream: column 3 section DICTIONARY_DATA start: 192584 length 133
Encoding column 0: DIRECT
Encoding column 1: DIRECT_V2
Encoding column 2: DIRECT_V2
@@ -134,16 +134,16 @@ Stripes:
Entry 2: count: 1000 min: Darkness, max: worst positions: 0,1469,69
Entry 3: count: 1000 min: Darkness, max: worst positions: 0,2133,194
Entry 4: count: 1000 min: Darkness, max: worst positions: 0,3005,43
- Stripe: offset: 192798 data: 63796 rows: 5000 tail: 79 index: 425
- Stream: column 0 section ROW_INDEX start: 192798 length 15
- Stream: column 1 section ROW_INDEX start: 192813 length 156
- Stream: column 2 section ROW_INDEX start: 192969 length 168
- Stream: column 3 section ROW_INDEX start: 193137 length 86
- Stream: column 1 section DATA start: 193223 length 20029
- Stream: column 2 section DATA start: 213252 length 40035
- Stream: column 3 section DATA start: 253287 length 3574
- Stream: column 3 section LENGTH start: 256861 length 25
- Stream: column 3 section DICTIONARY_DATA start: 256886 length 133
+ Stripe: offset: 192796 data: 63796 rows: 5000 tail: 79 index: 425
+ Stream: column 0 section ROW_INDEX start: 192796 length 15
+ Stream: column 1 section ROW_INDEX start: 192811 length 156
+ Stream: column 2 section ROW_INDEX start: 192967 length 168
+ Stream: column 3 section ROW_INDEX start: 193135 length 86
+ Stream: column 1 section DATA start: 193221 length 20029
+ Stream: column 2 section DATA start: 213250 length 40035
+ Stream: column 3 section DATA start: 253285 length 3574
+ Stream: column 3 section LENGTH start: 256859 length 25
+ Stream: column 3 section DICTIONARY_DATA start: 256884 length 133
Encoding column 0: DIRECT
Encoding column 1: DIRECT_V2
Encoding column 2: DIRECT_V2
@@ -166,16 +166,16 @@ Stripes:
Entry 2: count: 1000 min: Darkness, max: worst positions: 0,1485,52
Entry 3: count: 1000 min: Darkness, max: worst positions: 0,2196,104
Entry 4: count: 1000 min: Darkness, max: worst positions: 0,2934,131
- Stripe: offset: 257098 data: 12940 rows: 1000 tail: 71 index: 123
- Stream: column 0 section ROW_INDEX start: 257098 length 10
- Stream: column 1 section ROW_INDEX start: 257108 length 36
- Stream: column 2 section ROW_INDEX start: 257144 length 39
- Stream: column 3 section ROW_INDEX start: 257183 length 38
- Stream: column 1 section DATA start: 257221 length 4007
- Stream: column 2 section DATA start: 261228 length 8007
- Stream: column 3 section DATA start: 269235 length 768
- Stream: column 3 section LENGTH start: 270003 length 25
- Stream: column 3 section DICTIONARY_DATA start: 270028 length 133
+ Stripe: offset: 257096 data: 12940 rows: 1000 tail: 71 index: 123
+ Stream: column 0 section ROW_INDEX start: 257096 length 10
+ Stream: column 1 section ROW_INDEX start: 257106 length 36
+ Stream: column 2 section ROW_INDEX start: 257142 length 39
+ Stream: column 3 section ROW_INDEX start: 257181 length 38
+ Stream: column 1 section DATA start: 257219 length 4007
+ Stream: column 2 section DATA start: 261226 length 8007
+ Stream: column 3 section DATA start: 269233 length 768
+ Stream: column 3 section LENGTH start: 270001 length 25
+ Stream: column 3 section DICTIONARY_DATA start: 270026 length 133
Encoding column 0: DIRECT
Encoding column 1: DIRECT_V2
Encoding column 2: DIRECT_V2
@@ -187,6 +187,6 @@ Stripes:
Row group index column 3:
Entry 0: count: 1000 min: Darkness, max: worst positions: 0,0,0
-File length: 270759 bytes
+File length: 270760 bytes
Padding length: 0 bytes
Padding ratio: 0%
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/annotate_stats_part.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/annotate_stats_part.q.out?rev=1627125&r1=1627124&r2=1627125&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/annotate_stats_part.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/annotate_stats_part.q.out Tue Sep 23 19:30:11 2014
@@ -98,11 +98,11 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: loc_orc
- Statistics: Num rows: 5 Data size: 724 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 5 Data size: 722 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: state (type: string), locid (type: int), zip (type: bigint), year (type: string)
outputColumnNames: _col0, _col1, _col2, _col3
- Statistics: Num rows: 5 Data size: 724 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 5 Data size: 722 Basic stats: COMPLETE Column stats: NONE
ListSink
PREHOOK: query: -- partition level analyze statistics for specific parition
@@ -135,11 +135,11 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: loc_orc
- Statistics: Num rows: 2 Data size: 325 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 323 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: state (type: string), locid (type: int), zip (type: bigint), year (type: string)
outputColumnNames: _col0, _col1, _col2, _col3
- Statistics: Num rows: 2 Data size: 325 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 323 Basic stats: COMPLETE Column stats: NONE
ListSink
PREHOOK: query: -- basicStatState: PARTIAL colStatState: NONE
@@ -158,11 +158,11 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: loc_orc
- Statistics: Num rows: 9 Data size: 724 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 9 Data size: 722 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: state (type: string), locid (type: int), zip (type: bigint), year (type: string)
outputColumnNames: _col0, _col1, _col2, _col3
- Statistics: Num rows: 9 Data size: 724 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 9 Data size: 722 Basic stats: COMPLETE Column stats: NONE
ListSink
PREHOOK: query: -- basicStatState: COMPLETE colStatState: NONE
@@ -222,11 +222,11 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: loc_orc
- Statistics: Num rows: 1 Data size: 325 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 323 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: state (type: string), locid (type: int), zip (type: bigint), year (type: string)
outputColumnNames: _col0, _col1, _col2, _col3
- Statistics: Num rows: 1 Data size: 325 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 323 Basic stats: COMPLETE Column stats: NONE
ListSink
PREHOOK: query: -- basicStatState: COMPLETE colStatState: NONE
@@ -245,11 +245,11 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: loc_orc
- Statistics: Num rows: 8 Data size: 724 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 8 Data size: 722 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: state (type: string), locid (type: int), zip (type: bigint), year (type: string)
outputColumnNames: _col0, _col1, _col2, _col3
- Statistics: Num rows: 8 Data size: 724 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 8 Data size: 722 Basic stats: COMPLETE Column stats: NONE
ListSink
PREHOOK: query: -- basicStatState: COMPLETE colStatState: NONE
@@ -268,11 +268,11 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: loc_orc
- Statistics: Num rows: 8 Data size: 724 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 8 Data size: 722 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: state (type: string), locid (type: int), zip (type: bigint), year (type: string)
outputColumnNames: _col0, _col1, _col2, _col3
- Statistics: Num rows: 8 Data size: 724 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 8 Data size: 722 Basic stats: COMPLETE Column stats: NONE
ListSink
PREHOOK: query: -- both partitions will be pruned
@@ -331,14 +331,14 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: loc_orc
- Statistics: Num rows: 8 Data size: 724 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 8 Data size: 722 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: zip (type: bigint)
outputColumnNames: _col0
- Statistics: Num rows: 8 Data size: 724 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 8 Data size: 722 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 8 Data size: 724 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 8 Data size: 722 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -366,7 +366,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: loc_orc
- Statistics: Num rows: 8 Data size: 724 Basic stats: COMPLETE Column stats: PARTIAL
+ Statistics: Num rows: 8 Data size: 722 Basic stats: COMPLETE Column stats: PARTIAL
Select Operator
expressions: state (type: string)
outputColumnNames: _col0
@@ -403,7 +403,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: loc_orc
- Statistics: Num rows: 8 Data size: 724 Basic stats: COMPLETE Column stats: PARTIAL
+ Statistics: Num rows: 8 Data size: 722 Basic stats: COMPLETE Column stats: PARTIAL
Select Operator
expressions: state (type: string), locid (type: int)
outputColumnNames: _col0, _col1
@@ -473,14 +473,14 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: loc_orc
- Statistics: Num rows: 1 Data size: 325 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 323 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: state (type: string), locid (type: int)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 325 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 323 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 1 Data size: 325 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 323 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -508,11 +508,11 @@ STAGE PLANS:
Processor Tree:
TableScan
alias: loc_orc
- Statistics: Num rows: 8 Data size: 724 Basic stats: COMPLETE Column stats: PARTIAL
+ Statistics: Num rows: 8 Data size: 722 Basic stats: COMPLETE Column stats: PARTIAL
Select Operator
expressions: state (type: string), locid (type: int), zip (type: bigint), year (type: string)
outputColumnNames: _col0, _col1, _col2, _col3
- Statistics: Num rows: 8 Data size: 724 Basic stats: COMPLETE Column stats: PARTIAL
+ Statistics: Num rows: 8 Data size: 722 Basic stats: COMPLETE Column stats: PARTIAL
ListSink
PREHOOK: query: -- This is to test filter expression evaluation on partition column
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/annotate_stats_select.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/annotate_stats_select.q.out?rev=1627125&r1=1627124&r2=1627125&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/annotate_stats_select.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/annotate_stats_select.q.out Tue Sep 23 19:30:11 2014
@@ -690,10 +690,10 @@ STAGE PLANS:
Select Operator
expressions: null (type: void)
outputColumnNames: _col0
- Statistics: Num rows: 2 Data size: 112 Basic stats: COMPLETE Column stats: COMPLETE
+ Statistics: Num rows: 2 Data size: 0 Basic stats: PARTIAL Column stats: COMPLETE
File Output Operator
compressed: false
- Statistics: Num rows: 2 Data size: 112 Basic stats: COMPLETE Column stats: COMPLETE
+ Statistics: Num rows: 2 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
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/auto_join8.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/auto_join8.q.out?rev=1627125&r1=1627124&r2=1627125&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/auto_join8.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/auto_join8.q.out Tue Sep 23 19:30:11 2014
@@ -97,7 +97,7 @@ STAGE PLANS:
predicate: _col2 is null (type: boolean)
Statistics: Num rows: 15 Data size: 163 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: UDFToInteger(_col0) (type: int), _col1 (type: string), UDFToInteger(_col2) (type: int), _col3 (type: string)
+ expressions: UDFToInteger(_col0) (type: int), _col1 (type: string), UDFToInteger(null) (type: int), _col3 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3
Statistics: Num rows: 15 Data size: 163 Basic stats: COMPLETE Column stats: NONE
File Output Operator
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/dynpart_sort_opt_vectorization.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/dynpart_sort_opt_vectorization.q.out?rev=1627125&r1=1627124&r2=1627125&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/dynpart_sort_opt_vectorization.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/dynpart_sort_opt_vectorization.q.out Tue Sep 23 19:30:11 2014
@@ -924,7 +924,7 @@ Partition Parameters:
numFiles 2
numRows 3
rawDataSize 60
- totalSize 1034
+ totalSize 1050
#### A masked pattern was here ####
# Storage Information
@@ -1012,7 +1012,7 @@ Partition Parameters:
numFiles 2
numRows 3
rawDataSize 60
- totalSize 1040
+ totalSize 1050
#### A masked pattern was here ####
# Storage Information
@@ -1055,7 +1055,7 @@ Partition Parameters:
numFiles 8
numRows 16
rawDataSize 320
- totalSize 4332
+ totalSize 4340
#### A masked pattern was here ####
# Storage Information
@@ -1141,7 +1141,7 @@ Partition Parameters:
numFiles 8
numRows 16
rawDataSize 320
- totalSize 4318
+ totalSize 4326
#### A masked pattern was here ####
# Storage Information
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/extrapolate_part_stats_full.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/extrapolate_part_stats_full.q.out?rev=1627125&r1=1627124&r2=1627125&view=diff
==============================================================================
Files hive/branches/cbo/ql/src/test/results/clientpositive/extrapolate_part_stats_full.q.out (original) and hive/branches/cbo/ql/src/test/results/clientpositive/extrapolate_part_stats_full.q.out Tue Sep 23 19:30:11 2014 differ
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/extrapolate_part_stats_partial.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/extrapolate_part_stats_partial.q.out?rev=1627125&r1=1627124&r2=1627125&view=diff
==============================================================================
Files hive/branches/cbo/ql/src/test/results/clientpositive/extrapolate_part_stats_partial.q.out (original) and hive/branches/cbo/ql/src/test/results/clientpositive/extrapolate_part_stats_partial.q.out Tue Sep 23 19:30:11 2014 differ
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/insert_values_non_partitioned.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/insert_values_non_partitioned.q.out?rev=1627125&r1=1627124&r2=1627125&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/insert_values_non_partitioned.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/insert_values_non_partitioned.q.out Tue Sep 23 19:30:11 2014
@@ -7,6 +7,7 @@ PREHOOK: query: create table acid_ivnp(t
de decimal(5,2),
t timestamp,
dt date,
+ b boolean,
s string,
vc varchar(128),
ch char(12)) clustered by (i) into 2 buckets stored as orc
@@ -22,6 +23,7 @@ POSTHOOK: query: create table acid_ivnp(
de decimal(5,2),
t timestamp,
dt date,
+ b boolean,
s string,
vc varchar(128),
ch char(12)) clustered by (i) into 2 buckets stored as orc
@@ -29,36 +31,40 @@ POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@acid_ivnp
PREHOOK: query: insert into table acid_ivnp values
- (1, 257, 65537, 4294967297, 3.14, 3.141592654, 109.23, '2014-08-25 17:21:30.0', '2014-08-25', 'mary had a little lamb', 'ring around the rosie', 'red'),
- (3, 25, 6553, 429496729, 0.14, 1923.141592654, 1.2301, '2014-08-24 17:21:30.0', '2014-08-26', 'its fleece was white as snow', 'a pocket full of posies', 'blue' )
+ (1, 257, 65537, 4294967297, 3.14, 3.141592654, 109.23, '2014-08-25 17:21:30.0', '2014-08-25', true, 'mary had a little lamb', 'ring around the rosie', 'red'),
+ (null, null, null, null, null, null, null, null, null, null, null, null, null),
+ (3, 25, 6553, null, 0.14, 1923.141592654, 1.2301, '2014-08-24 17:21:30.0', '2014-08-26', false, 'its fleece was white as snow', 'a pocket full of posies', 'blue' )
PREHOOK: type: QUERY
PREHOOK: Input: default@values__tmp__table__1
PREHOOK: Output: default@acid_ivnp
POSTHOOK: query: insert into table acid_ivnp values
- (1, 257, 65537, 4294967297, 3.14, 3.141592654, 109.23, '2014-08-25 17:21:30.0', '2014-08-25', 'mary had a little lamb', 'ring around the rosie', 'red'),
- (3, 25, 6553, 429496729, 0.14, 1923.141592654, 1.2301, '2014-08-24 17:21:30.0', '2014-08-26', 'its fleece was white as snow', 'a pocket full of posies', 'blue' )
+ (1, 257, 65537, 4294967297, 3.14, 3.141592654, 109.23, '2014-08-25 17:21:30.0', '2014-08-25', true, 'mary had a little lamb', 'ring around the rosie', 'red'),
+ (null, null, null, null, null, null, null, null, null, null, null, null, null),
+ (3, 25, 6553, null, 0.14, 1923.141592654, 1.2301, '2014-08-24 17:21:30.0', '2014-08-26', false, 'its fleece was white as snow', 'a pocket full of posies', 'blue' )
POSTHOOK: type: QUERY
POSTHOOK: Input: default@values__tmp__table__1
POSTHOOK: Output: default@acid_ivnp
+POSTHOOK: Lineage: acid_ivnp.b EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col10, type:string, comment:), ]
POSTHOOK: Lineage: acid_ivnp.bi EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col4, type:string, comment:), ]
-POSTHOOK: Lineage: acid_ivnp.ch EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col12, type:string, comment:), ]
+POSTHOOK: Lineage: acid_ivnp.ch EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col13, type:string, comment:), ]
POSTHOOK: Lineage: acid_ivnp.d EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col6, type:string, comment:), ]
POSTHOOK: Lineage: acid_ivnp.de EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col7, type:string, comment:), ]
POSTHOOK: Lineage: acid_ivnp.dt EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col9, type:string, comment:), ]
POSTHOOK: Lineage: acid_ivnp.f EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col5, type:string, comment:), ]
POSTHOOK: Lineage: acid_ivnp.i EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col3, type:string, comment:), ]
-POSTHOOK: Lineage: acid_ivnp.s SIMPLE [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col10, type:string, comment:), ]
+POSTHOOK: Lineage: acid_ivnp.s SIMPLE [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col11, type:string, comment:), ]
POSTHOOK: Lineage: acid_ivnp.si EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
POSTHOOK: Lineage: acid_ivnp.t EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col8, type:string, comment:), ]
POSTHOOK: Lineage: acid_ivnp.ti EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
-POSTHOOK: Lineage: acid_ivnp.vc EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col11, type:string, comment:), ]
-PREHOOK: query: select ti, si, i, bi, f, d, de, t, dt, s, vc, ch from acid_ivnp order by ti
+POSTHOOK: Lineage: acid_ivnp.vc EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col12, type:string, comment:), ]
+PREHOOK: query: select * from acid_ivnp order by ti
PREHOOK: type: QUERY
PREHOOK: Input: default@acid_ivnp
#### A masked pattern was here ####
-POSTHOOK: query: select ti, si, i, bi, f, d, de, t, dt, s, vc, ch from acid_ivnp order by ti
+POSTHOOK: query: select * from acid_ivnp order by ti
POSTHOOK: type: QUERY
POSTHOOK: Input: default@acid_ivnp
#### A masked pattern was here ####
-1 257 65537 4294967297 3.14 3.141592654 109.23 2014-08-25 17:21:30 2014-08-25 mary had a little lamb ring around the rosie red
-3 25 6553 429496729 0.14 1923.141592654 1.23 2014-08-24 17:21:30 2014-08-26 its fleece was white as snow a pocket full of posies blue
+NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
+1 257 65537 4294967297 3.14 3.141592654 109.23 2014-08-25 17:21:30 2014-08-25 true mary had a little lamb ring around the rosie red
+3 25 6553 NULL 0.14 1923.141592654 1.23 2014-08-24 17:21:30 2014-08-26 false its fleece was white as snow a pocket full of posies blue
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/insert_values_tmp_table.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/insert_values_tmp_table.q.out?rev=1627125&r1=1627124&r2=1627125&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/insert_values_tmp_table.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/insert_values_tmp_table.q.out Tue Sep 23 19:30:11 2014
@@ -8,13 +8,15 @@ POSTHOOK: Output: database:default
POSTHOOK: Output: default@acid_ivtt
PREHOOK: query: insert into table acid_ivtt values
(1, 109.23, 'mary had a little lamb'),
- (429496729, 0.14, 'its fleece was white as snow')
+ (429496729, 0.14, 'its fleece was white as snow'),
+ (-29496729, -0.14, 'negative values test')
PREHOOK: type: QUERY
PREHOOK: Input: default@values__tmp__table__1
PREHOOK: Output: default@acid_ivtt
POSTHOOK: query: insert into table acid_ivtt values
(1, 109.23, 'mary had a little lamb'),
- (429496729, 0.14, 'its fleece was white as snow')
+ (429496729, 0.14, 'its fleece was white as snow'),
+ (-29496729, -0.14, 'negative values test')
POSTHOOK: type: QUERY
POSTHOOK: Input: default@values__tmp__table__1
POSTHOOK: Output: default@acid_ivtt
@@ -29,5 +31,6 @@ POSTHOOK: query: select i, de, vc from a
POSTHOOK: type: QUERY
POSTHOOK: Input: default@acid_ivtt
#### A masked pattern was here ####
+-29496729 -0.14 negative values test
1 109.23 mary had a little lamb
429496729 0.14 its fleece was white as snow
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/join8.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/join8.q.out?rev=1627125&r1=1627124&r2=1627125&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/join8.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/join8.q.out Tue Sep 23 19:30:11 2014
@@ -90,7 +90,7 @@ STAGE PLANS:
predicate: _col2 is null (type: boolean)
Statistics: Num rows: 15 Data size: 163 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: UDFToInteger(_col0) (type: int), _col1 (type: string), UDFToInteger(_col2) (type: int), _col3 (type: string)
+ expressions: UDFToInteger(_col0) (type: int), _col1 (type: string), UDFToInteger(null) (type: int), _col3 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3
Statistics: Num rows: 15 Data size: 163 Basic stats: COMPLETE Column stats: NONE
File Output Operator
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/join_view.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/join_view.q.out?rev=1627125&r1=1627124&r2=1627125&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/join_view.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/join_view.q.out Tue Sep 23 19:30:11 2014
@@ -59,7 +59,7 @@ STAGE PLANS:
outputColumnNames: _col1, _col6
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Select Operator
- expressions: _col1 (type: string), _col6 (type: int), _col8 (type: string)
+ expressions: _col1 (type: string), _col6 (type: int), '2011-09-01' (type: string)
outputColumnNames: _col0, _col1, _col2
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
File Output Operator
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/lateral_view_ppd.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/lateral_view_ppd.q.out?rev=1627125&r1=1627124&r2=1627125&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/lateral_view_ppd.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/lateral_view_ppd.q.out Tue Sep 23 19:30:11 2014
@@ -109,7 +109,7 @@ STAGE PLANS:
outputColumnNames: _col1, _col5
Statistics: Num rows: 375 Data size: 3984 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col1 (type: string), _col5 (type: int)
+ expressions: _col1 (type: string), 1 (type: int)
outputColumnNames: _col0, _col1
Statistics: Num rows: 375 Data size: 3984 Basic stats: COMPLETE Column stats: NONE
File Output Operator
@@ -133,7 +133,7 @@ STAGE PLANS:
outputColumnNames: _col1, _col5
Statistics: Num rows: 375 Data size: 3984 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col1 (type: string), _col5 (type: int)
+ expressions: _col1 (type: string), 1 (type: int)
outputColumnNames: _col0, _col1
Statistics: Num rows: 375 Data size: 3984 Basic stats: COMPLETE Column stats: NONE
File Output Operator
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/list_bucket_query_oneskew_2.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/list_bucket_query_oneskew_2.q.out?rev=1627125&r1=1627124&r2=1627125&view=diff
==============================================================================
Files hive/branches/cbo/ql/src/test/results/clientpositive/list_bucket_query_oneskew_2.q.out (original) and hive/branches/cbo/ql/src/test/results/clientpositive/list_bucket_query_oneskew_2.q.out Tue Sep 23 19:30:11 2014 differ
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/orc_analyze.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/orc_analyze.q.out?rev=1627125&r1=1627124&r2=1627125&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/orc_analyze.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/orc_analyze.q.out Tue Sep 23 19:30:11 2014
@@ -105,7 +105,7 @@ Table Parameters:
numFiles 1
numRows 100
rawDataSize 52600
- totalSize 3123
+ totalSize 3121
#### A masked pattern was here ####
# Storage Information
@@ -195,7 +195,7 @@ Table Parameters:
numFiles 1
numRows 100
rawDataSize 52600
- totalSize 3123
+ totalSize 3121
#### A masked pattern was here ####
# Storage Information
@@ -621,7 +621,7 @@ Partition Parameters:
numFiles 4
numRows 50
rawDataSize 21980
- totalSize 4963
+ totalSize 4959
#### A masked pattern was here ####
# Storage Information
@@ -666,7 +666,7 @@ Partition Parameters:
numFiles 4
numRows 50
rawDataSize 22048
- totalSize 5051
+ totalSize 5044
#### A masked pattern was here ####
# Storage Information
@@ -774,7 +774,7 @@ Partition Parameters:
numFiles 4
numRows 50
rawDataSize 21980
- totalSize 4963
+ totalSize 4959
#### A masked pattern was here ####
# Storage Information
@@ -819,7 +819,7 @@ Partition Parameters:
numFiles 4
numRows 50
rawDataSize 22048
- totalSize 5051
+ totalSize 5044
#### A masked pattern was here ####
# Storage Information
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/orc_merge1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/orc_merge1.q.out?rev=1627125&r1=1627124&r2=1627125&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/orc_merge1.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/orc_merge1.q.out Tue Sep 23 19:30:11 2014
@@ -139,7 +139,7 @@ Partition Parameters:
numFiles 2
numRows 242
rawDataSize 22748
- totalSize 1750
+ totalSize 1747
#### A masked pattern was here ####
# Storage Information
@@ -295,7 +295,7 @@ Partition Parameters:
numFiles 1
numRows 242
rawDataSize 22748
- totalSize 1335
+ totalSize 1332
#### A masked pattern was here ####
# Storage Information
@@ -441,7 +441,7 @@ Partition Parameters:
numFiles 1
numRows 242
rawDataSize 22748
- totalSize 1626
+ totalSize 1623
#### A masked pattern was here ####
# Storage Information
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/orc_merge5.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/orc_merge5.q.out?rev=1627125&r1=1627124&r2=1627125&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/orc_merge5.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/orc_merge5.q.out Tue Sep 23 19:30:11 2014
@@ -121,7 +121,7 @@ Table Parameters:
numFiles 3
numRows 3
rawDataSize 765
- totalSize 1141
+ totalSize 1133
#### A masked pattern was here ####
# Storage Information
@@ -274,7 +274,7 @@ Table Parameters:
numFiles 1
numRows 3
rawDataSize 765
- totalSize 907
+ totalSize 899
#### A masked pattern was here ####
# Storage Information
@@ -343,7 +343,7 @@ Table Parameters:
numFiles 3
numRows 3
rawDataSize 765
- totalSize 1141
+ totalSize 1133
#### A masked pattern was here ####
# Storage Information
@@ -434,7 +434,7 @@ Table Parameters:
numFiles 1
numRows 3
rawDataSize 765
- totalSize 907
+ totalSize 899
#### A masked pattern was here ####
# Storage Information
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/orc_merge6.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/orc_merge6.q.out?rev=1627125&r1=1627124&r2=1627125&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/orc_merge6.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/orc_merge6.q.out Tue Sep 23 19:30:11 2014
@@ -155,7 +155,7 @@ Partition Parameters:
numFiles 3
numRows 3
rawDataSize 765
- totalSize 1141
+ totalSize 1133
#### A masked pattern was here ####
# Storage Information
@@ -200,7 +200,7 @@ Partition Parameters:
numFiles 3
numRows 3
rawDataSize 765
- totalSize 1141
+ totalSize 1133
#### A masked pattern was here ####
# Storage Information
@@ -400,7 +400,7 @@ Partition Parameters:
numFiles 1
numRows 3
rawDataSize 765
- totalSize 907
+ totalSize 899
#### A masked pattern was here ####
# Storage Information
@@ -445,7 +445,7 @@ Partition Parameters:
numFiles 1
numRows 3
rawDataSize 765
- totalSize 907
+ totalSize 899
#### A masked pattern was here ####
# Storage Information
@@ -558,7 +558,7 @@ Partition Parameters:
numFiles 3
numRows 3
rawDataSize 765
- totalSize 1141
+ totalSize 1133
#### A masked pattern was here ####
# Storage Information
@@ -603,7 +603,7 @@ Partition Parameters:
numFiles 3
numRows 3
rawDataSize 765
- totalSize 1141
+ totalSize 1133
#### A masked pattern was here ####
# Storage Information
@@ -736,7 +736,7 @@ Partition Parameters:
numFiles 1
numRows 3
rawDataSize 765
- totalSize 907
+ totalSize 899
#### A masked pattern was here ####
# Storage Information
@@ -781,7 +781,7 @@ Partition Parameters:
numFiles 1
numRows 3
rawDataSize 765
- totalSize 907
+ totalSize 899
#### A masked pattern was here ####
# Storage Information
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/orc_merge7.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/orc_merge7.q.out?rev=1627125&r1=1627124&r2=1627125&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/orc_merge7.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/orc_merge7.q.out Tue Sep 23 19:30:11 2014
@@ -187,7 +187,7 @@ Partition Parameters:
numFiles 1
numRows 1
rawDataSize 255
- totalSize 521
+ totalSize 513
#### A masked pattern was here ####
# Storage Information
@@ -231,7 +231,7 @@ Partition Parameters:
numFiles 2
numRows 2
rawDataSize 510
- totalSize 1058
+ totalSize 1044
#### A masked pattern was here ####
# Storage Information
@@ -464,7 +464,7 @@ Partition Parameters:
numFiles 1
numRows 1
rawDataSize 255
- totalSize 521
+ totalSize 513
#### A masked pattern was here ####
# Storage Information
@@ -508,7 +508,7 @@ Partition Parameters:
numFiles 1
numRows 2
rawDataSize 510
- totalSize 852
+ totalSize 838
#### A masked pattern was here ####
# Storage Information
@@ -659,7 +659,7 @@ Partition Parameters:
numFiles 1
numRows 1
rawDataSize 255
- totalSize 521
+ totalSize 513
#### A masked pattern was here ####
# Storage Information
@@ -703,7 +703,7 @@ Partition Parameters:
numFiles 2
numRows 2
rawDataSize 510
- totalSize 1058
+ totalSize 1044
#### A masked pattern was here ####
# Storage Information
@@ -837,7 +837,7 @@ Partition Parameters:
numFiles 1
numRows 1
rawDataSize 255
- totalSize 521
+ totalSize 513
#### A masked pattern was here ####
# Storage Information
@@ -881,7 +881,7 @@ Partition Parameters:
numFiles 1
numRows 2
rawDataSize 510
- totalSize 852
+ totalSize 838
#### A masked pattern was here ####
# Storage Information
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/orc_merge_incompat1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/orc_merge_incompat1.q.out?rev=1627125&r1=1627124&r2=1627125&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/orc_merge_incompat1.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/orc_merge_incompat1.q.out Tue Sep 23 19:30:11 2014
@@ -172,7 +172,7 @@ Table Parameters:
numFiles 5
numRows 15
rawDataSize 3825
- totalSize 2862
+ totalSize 2877
#### A masked pattern was here ####
# Storage Information
@@ -250,7 +250,7 @@ Table Parameters:
numFiles 3
numRows 15
rawDataSize 3825
- totalSize 2325
+ totalSize 2340
#### A masked pattern was here ####
# Storage Information
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/orc_merge_incompat2.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/orc_merge_incompat2.q.out?rev=1627125&r1=1627124&r2=1627125&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/orc_merge_incompat2.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/orc_merge_incompat2.q.out Tue Sep 23 19:30:11 2014
@@ -245,7 +245,7 @@ Partition Parameters:
numFiles 4
numRows 4
rawDataSize 1020
- totalSize 2092
+ totalSize 2060
#### A masked pattern was here ####
# Storage Information
@@ -289,7 +289,7 @@ Partition Parameters:
numFiles 4
numRows 8
rawDataSize 2040
- totalSize 2204
+ totalSize 2188
#### A masked pattern was here ####
# Storage Information
@@ -430,7 +430,7 @@ Partition Parameters:
numFiles 3
numRows 4
rawDataSize 1020
- totalSize 1851
+ totalSize 1819
#### A masked pattern was here ####
# Storage Information
@@ -474,7 +474,7 @@ Partition Parameters:
numFiles 3
numRows 8
rawDataSize 2040
- totalSize 1944
+ totalSize 1928
#### A masked pattern was here ####
# Storage Information
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/ppd_repeated_alias.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/ppd_repeated_alias.q.out?rev=1627125&r1=1627124&r2=1627125&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/ppd_repeated_alias.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/ppd_repeated_alias.q.out Tue Sep 23 19:30:11 2014
@@ -145,7 +145,7 @@ STAGE PLANS:
predicate: (_col7 = 3) (type: boolean)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Select Operator
- expressions: _col0 (type: int), _col6 (type: int), _col7 (type: int)
+ expressions: _col0 (type: int), _col6 (type: int), 3 (type: int)
outputColumnNames: _col0, _col1, _col2
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
File Output Operator
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/select_dummy_source.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/select_dummy_source.q.out?rev=1627125&r1=1627124&r2=1627125&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/select_dummy_source.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/select_dummy_source.q.out Tue Sep 23 19:30:11 2014
@@ -277,7 +277,7 @@ STAGE PLANS:
Row Limit Per Split: 1
Statistics: Num rows: 0 Data size: 1 Basic stats: PARTIAL Column stats: COMPLETE
Select Operator
- expressions: 5 (type: int), (1 + 2) (type: int)
+ expressions: 5 (type: int), 3 (type: int)
outputColumnNames: _col0, _col1
Statistics: Num rows: 0 Data size: 1 Basic stats: PARTIAL Column stats: COMPLETE
File Output Operator
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/subquery_multiinsert.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/subquery_multiinsert.q.out?rev=1627125&r1=1627124&r2=1627125&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/subquery_multiinsert.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/subquery_multiinsert.q.out Tue Sep 23 19:30:11 2014
@@ -99,7 +99,7 @@ STAGE PLANS:
predicate: (_col0 = 0) (type: boolean)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Select Operator
- expressions: _col0 (type: bigint)
+ expressions: 0 (type: bigint)
outputColumnNames: _col0
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Group By Operator
@@ -566,7 +566,7 @@ STAGE PLANS:
predicate: (_col0 = 0) (type: boolean)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Select Operator
- expressions: _col0 (type: bigint)
+ expressions: 0 (type: bigint)
outputColumnNames: _col0
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Group By Operator
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/subquery_notin.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/subquery_notin.q.out?rev=1627125&r1=1627124&r2=1627125&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/subquery_notin.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/subquery_notin.q.out Tue Sep 23 19:30:11 2014
@@ -150,7 +150,7 @@ STAGE PLANS:
predicate: (_col0 = 0) (type: boolean)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Select Operator
- expressions: _col0 (type: bigint)
+ expressions: 0 (type: bigint)
outputColumnNames: _col0
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Group By Operator
@@ -537,7 +537,7 @@ STAGE PLANS:
predicate: (_col0 = 0) (type: boolean)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Select Operator
- expressions: _col0 (type: bigint)
+ expressions: 0 (type: bigint)
outputColumnNames: _col0
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Group By Operator
@@ -823,7 +823,7 @@ STAGE PLANS:
predicate: (_col0 = 0) (type: boolean)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Select Operator
- expressions: _col0 (type: bigint)
+ expressions: 0 (type: bigint)
outputColumnNames: _col0
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Group By Operator
@@ -1145,7 +1145,7 @@ STAGE PLANS:
predicate: (_col0 = 0) (type: boolean)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Select Operator
- expressions: _col0 (type: bigint)
+ expressions: 0 (type: bigint)
outputColumnNames: _col0
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Group By Operator
@@ -1489,7 +1489,7 @@ STAGE PLANS:
predicate: (_col0 = 0) (type: boolean)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Select Operator
- expressions: _col0 (type: bigint)
+ expressions: 0 (type: bigint)
outputColumnNames: _col0
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Group By Operator
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/subquery_notin_having.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/subquery_notin_having.q.out?rev=1627125&r1=1627124&r2=1627125&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/subquery_notin_having.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/subquery_notin_having.q.out Tue Sep 23 19:30:11 2014
@@ -99,7 +99,7 @@ STAGE PLANS:
predicate: (_col0 = 0) (type: boolean)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Select Operator
- expressions: _col0 (type: bigint)
+ expressions: 0 (type: bigint)
outputColumnNames: _col0
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Group By Operator
@@ -476,7 +476,7 @@ STAGE PLANS:
predicate: (_col0 = 0) (type: boolean)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Select Operator
- expressions: _col0 (type: bigint)
+ expressions: 0 (type: bigint)
outputColumnNames: _col0
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Group By Operator
@@ -728,7 +728,7 @@ STAGE PLANS:
predicate: (_col0 = 0) (type: boolean)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Select Operator
- expressions: _col0 (type: bigint)
+ expressions: 0 (type: bigint)
outputColumnNames: _col0
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Group By Operator
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/subquery_unqualcolumnrefs.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/subquery_unqualcolumnrefs.q.out?rev=1627125&r1=1627124&r2=1627125&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/subquery_unqualcolumnrefs.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/subquery_unqualcolumnrefs.q.out Tue Sep 23 19:30:11 2014
@@ -928,7 +928,7 @@ STAGE PLANS:
predicate: (_col0 = 0) (type: boolean)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Select Operator
- expressions: _col0 (type: bigint)
+ expressions: 0 (type: bigint)
outputColumnNames: _col0
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Group By Operator
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/subquery_views.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/subquery_views.q.out?rev=1627125&r1=1627124&r2=1627125&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/subquery_views.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/subquery_views.q.out Tue Sep 23 19:30:11 2014
@@ -120,7 +120,7 @@ STAGE PLANS:
predicate: (_col0 = 0) (type: boolean)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Select Operator
- expressions: _col0 (type: bigint)
+ expressions: 0 (type: bigint)
outputColumnNames: _col0
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Group By Operator
@@ -287,7 +287,7 @@ STAGE PLANS:
predicate: (_col0 = 0) (type: boolean)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Select Operator
- expressions: _col0 (type: bigint)
+ expressions: 0 (type: bigint)
outputColumnNames: _col0
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Group By Operator
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/tez/dynpart_sort_opt_vectorization.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/tez/dynpart_sort_opt_vectorization.q.out?rev=1627125&r1=1627124&r2=1627125&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/tez/dynpart_sort_opt_vectorization.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/tez/dynpart_sort_opt_vectorization.q.out Tue Sep 23 19:30:11 2014
@@ -968,7 +968,7 @@ Partition Parameters:
numFiles 2
numRows 3
rawDataSize 60
- totalSize 1034
+ totalSize 1050
#### A masked pattern was here ####
# Storage Information
@@ -1056,7 +1056,7 @@ Partition Parameters:
numFiles 2
numRows 3
rawDataSize 60
- totalSize 1040
+ totalSize 1050
#### A masked pattern was here ####
# Storage Information
@@ -1099,7 +1099,7 @@ Partition Parameters:
numFiles 8
numRows 16
rawDataSize 320
- totalSize 4332
+ totalSize 4340
#### A masked pattern was here ####
# Storage Information
@@ -1185,7 +1185,7 @@ Partition Parameters:
numFiles 8
numRows 16
rawDataSize 320
- totalSize 4318
+ totalSize 4326
#### A masked pattern was here ####
# Storage Information
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/tez/insert_values_non_partitioned.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/tez/insert_values_non_partitioned.q.out?rev=1627125&r1=1627124&r2=1627125&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/tez/insert_values_non_partitioned.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/tez/insert_values_non_partitioned.q.out Tue Sep 23 19:30:11 2014
@@ -7,6 +7,7 @@ PREHOOK: query: create table acid_ivnp(t
de decimal(5,2),
t timestamp,
dt date,
+ b boolean,
s string,
vc varchar(128),
ch char(12)) clustered by (i) into 2 buckets stored as orc
@@ -22,6 +23,7 @@ POSTHOOK: query: create table acid_ivnp(
de decimal(5,2),
t timestamp,
dt date,
+ b boolean,
s string,
vc varchar(128),
ch char(12)) clustered by (i) into 2 buckets stored as orc
@@ -29,36 +31,40 @@ POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@acid_ivnp
PREHOOK: query: insert into table acid_ivnp values
- (1, 257, 65537, 4294967297, 3.14, 3.141592654, 109.23, '2014-08-25 17:21:30.0', '2014-08-25', 'mary had a little lamb', 'ring around the rosie', 'red'),
- (3, 25, 6553, 429496729, 0.14, 1923.141592654, 1.2301, '2014-08-24 17:21:30.0', '2014-08-26', 'its fleece was white as snow', 'a pocket full of posies', 'blue' )
+ (1, 257, 65537, 4294967297, 3.14, 3.141592654, 109.23, '2014-08-25 17:21:30.0', '2014-08-25', true, 'mary had a little lamb', 'ring around the rosie', 'red'),
+ (null, null, null, null, null, null, null, null, null, null, null, null, null),
+ (3, 25, 6553, null, 0.14, 1923.141592654, 1.2301, '2014-08-24 17:21:30.0', '2014-08-26', false, 'its fleece was white as snow', 'a pocket full of posies', 'blue' )
PREHOOK: type: QUERY
PREHOOK: Input: default@values__tmp__table__1
PREHOOK: Output: default@acid_ivnp
POSTHOOK: query: insert into table acid_ivnp values
- (1, 257, 65537, 4294967297, 3.14, 3.141592654, 109.23, '2014-08-25 17:21:30.0', '2014-08-25', 'mary had a little lamb', 'ring around the rosie', 'red'),
- (3, 25, 6553, 429496729, 0.14, 1923.141592654, 1.2301, '2014-08-24 17:21:30.0', '2014-08-26', 'its fleece was white as snow', 'a pocket full of posies', 'blue' )
+ (1, 257, 65537, 4294967297, 3.14, 3.141592654, 109.23, '2014-08-25 17:21:30.0', '2014-08-25', true, 'mary had a little lamb', 'ring around the rosie', 'red'),
+ (null, null, null, null, null, null, null, null, null, null, null, null, null),
+ (3, 25, 6553, null, 0.14, 1923.141592654, 1.2301, '2014-08-24 17:21:30.0', '2014-08-26', false, 'its fleece was white as snow', 'a pocket full of posies', 'blue' )
POSTHOOK: type: QUERY
POSTHOOK: Input: default@values__tmp__table__1
POSTHOOK: Output: default@acid_ivnp
+POSTHOOK: Lineage: acid_ivnp.b EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col10, type:string, comment:), ]
POSTHOOK: Lineage: acid_ivnp.bi EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col4, type:string, comment:), ]
-POSTHOOK: Lineage: acid_ivnp.ch EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col12, type:string, comment:), ]
+POSTHOOK: Lineage: acid_ivnp.ch EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col13, type:string, comment:), ]
POSTHOOK: Lineage: acid_ivnp.d EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col6, type:string, comment:), ]
POSTHOOK: Lineage: acid_ivnp.de EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col7, type:string, comment:), ]
POSTHOOK: Lineage: acid_ivnp.dt EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col9, type:string, comment:), ]
POSTHOOK: Lineage: acid_ivnp.f EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col5, type:string, comment:), ]
POSTHOOK: Lineage: acid_ivnp.i EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col3, type:string, comment:), ]
-POSTHOOK: Lineage: acid_ivnp.s SIMPLE [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col10, type:string, comment:), ]
+POSTHOOK: Lineage: acid_ivnp.s SIMPLE [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col11, type:string, comment:), ]
POSTHOOK: Lineage: acid_ivnp.si EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
POSTHOOK: Lineage: acid_ivnp.t EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col8, type:string, comment:), ]
POSTHOOK: Lineage: acid_ivnp.ti EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
-POSTHOOK: Lineage: acid_ivnp.vc EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col11, type:string, comment:), ]
-PREHOOK: query: select ti, si, i, bi, f, d, de, t, dt, s, vc, ch from acid_ivnp order by ti
+POSTHOOK: Lineage: acid_ivnp.vc EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col12, type:string, comment:), ]
+PREHOOK: query: select * from acid_ivnp order by ti
PREHOOK: type: QUERY
PREHOOK: Input: default@acid_ivnp
#### A masked pattern was here ####
-POSTHOOK: query: select ti, si, i, bi, f, d, de, t, dt, s, vc, ch from acid_ivnp order by ti
+POSTHOOK: query: select * from acid_ivnp order by ti
POSTHOOK: type: QUERY
POSTHOOK: Input: default@acid_ivnp
#### A masked pattern was here ####
-1 257 65537 4294967297 3.14 3.141592654 109.23 2014-08-25 17:21:30 2014-08-25 mary had a little lamb ring around the rosie red
-3 25 6553 429496729 0.14 1923.141592654 1.23 2014-08-24 17:21:30 2014-08-26 its fleece was white as snow a pocket full of posies blue
+NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
+1 257 65537 4294967297 3.14 3.141592654 109.23 2014-08-25 17:21:30 2014-08-25 true mary had a little lamb ring around the rosie red
+3 25 6553 NULL 0.14 1923.141592654 1.23 2014-08-24 17:21:30 2014-08-26 false its fleece was white as snow a pocket full of posies blue
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/tez/insert_values_tmp_table.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/tez/insert_values_tmp_table.q.out?rev=1627125&r1=1627124&r2=1627125&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/tez/insert_values_tmp_table.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/tez/insert_values_tmp_table.q.out Tue Sep 23 19:30:11 2014
@@ -8,13 +8,15 @@ POSTHOOK: Output: database:default
POSTHOOK: Output: default@acid_ivtt
PREHOOK: query: insert into table acid_ivtt values
(1, 109.23, 'mary had a little lamb'),
- (429496729, 0.14, 'its fleece was white as snow')
+ (429496729, 0.14, 'its fleece was white as snow'),
+ (-29496729, -0.14, 'negative values test')
PREHOOK: type: QUERY
PREHOOK: Input: default@values__tmp__table__1
PREHOOK: Output: default@acid_ivtt
POSTHOOK: query: insert into table acid_ivtt values
(1, 109.23, 'mary had a little lamb'),
- (429496729, 0.14, 'its fleece was white as snow')
+ (429496729, 0.14, 'its fleece was white as snow'),
+ (-29496729, -0.14, 'negative values test')
POSTHOOK: type: QUERY
POSTHOOK: Input: default@values__tmp__table__1
POSTHOOK: Output: default@acid_ivtt
@@ -29,5 +31,6 @@ POSTHOOK: query: select i, de, vc from a
POSTHOOK: type: QUERY
POSTHOOK: Input: default@acid_ivtt
#### A masked pattern was here ####
+-29496729 -0.14 negative values test
1 109.23 mary had a little lamb
429496729 0.14 its fleece was white as snow
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/tez/orc_analyze.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/tez/orc_analyze.q.out?rev=1627125&r1=1627124&r2=1627125&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/tez/orc_analyze.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/tez/orc_analyze.q.out Tue Sep 23 19:30:11 2014
@@ -105,7 +105,7 @@ Table Parameters:
numFiles 1
numRows 100
rawDataSize 52600
- totalSize 3123
+ totalSize 3121
#### A masked pattern was here ####
# Storage Information
@@ -195,7 +195,7 @@ Table Parameters:
numFiles 1
numRows 100
rawDataSize 52600
- totalSize 3123
+ totalSize 3121
#### A masked pattern was here ####
# Storage Information
@@ -621,7 +621,7 @@ Partition Parameters:
numFiles 4
numRows 50
rawDataSize 21980
- totalSize 4963
+ totalSize 4959
#### A masked pattern was here ####
# Storage Information
@@ -666,7 +666,7 @@ Partition Parameters:
numFiles 4
numRows 50
rawDataSize 22048
- totalSize 5051
+ totalSize 5044
#### A masked pattern was here ####
# Storage Information
@@ -774,7 +774,7 @@ Partition Parameters:
numFiles 4
numRows 50
rawDataSize 21980
- totalSize 4963
+ totalSize 4959
#### A masked pattern was here ####
# Storage Information
@@ -819,7 +819,7 @@ Partition Parameters:
numFiles 4
numRows 50
rawDataSize 22048
- totalSize 5051
+ totalSize 5044
#### A masked pattern was here ####
# Storage Information
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/tez/orc_merge1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/tez/orc_merge1.q.out?rev=1627125&r1=1627124&r2=1627125&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/tez/orc_merge1.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/tez/orc_merge1.q.out Tue Sep 23 19:30:11 2014
@@ -146,7 +146,7 @@ Partition Parameters:
numFiles 6
numRows 242
rawDataSize 22748
- totalSize 3046
+ totalSize 3037
#### A masked pattern was here ####
# Storage Information
@@ -315,7 +315,7 @@ Partition Parameters:
numFiles 1
numRows 242
rawDataSize 22748
- totalSize 1328
+ totalSize 1325
#### A masked pattern was here ####
# Storage Information
@@ -476,7 +476,7 @@ Partition Parameters:
numFiles 1
numRows 242
rawDataSize 22748
- totalSize 2401
+ totalSize 2392
#### A masked pattern was here ####
# Storage Information
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/tez/orc_merge5.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/tez/orc_merge5.q.out?rev=1627125&r1=1627124&r2=1627125&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/tez/orc_merge5.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/tez/orc_merge5.q.out Tue Sep 23 19:30:11 2014
@@ -128,7 +128,7 @@ Table Parameters:
numFiles 3
numRows 3
rawDataSize 765
- totalSize 1141
+ totalSize 1133
#### A masked pattern was here ####
# Storage Information
@@ -296,7 +296,7 @@ Table Parameters:
numFiles 1
numRows 3
rawDataSize 765
- totalSize 907
+ totalSize 899
#### A masked pattern was here ####
# Storage Information
@@ -365,7 +365,7 @@ Table Parameters:
numFiles 3
numRows 3
rawDataSize 765
- totalSize 1141
+ totalSize 1133
#### A masked pattern was here ####
# Storage Information
@@ -456,7 +456,7 @@ Table Parameters:
numFiles 1
numRows 3
rawDataSize 765
- totalSize 907
+ totalSize 899
#### A masked pattern was here ####
# Storage Information
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/tez/orc_merge6.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/tez/orc_merge6.q.out?rev=1627125&r1=1627124&r2=1627125&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/tez/orc_merge6.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/tez/orc_merge6.q.out Tue Sep 23 19:30:11 2014
@@ -162,7 +162,7 @@ Partition Parameters:
numFiles 3
numRows 3
rawDataSize 765
- totalSize 1141
+ totalSize 1133
#### A masked pattern was here ####
# Storage Information
@@ -207,7 +207,7 @@ Partition Parameters:
numFiles 3
numRows 3
rawDataSize 765
- totalSize 1141
+ totalSize 1133
#### A masked pattern was here ####
# Storage Information
@@ -422,7 +422,7 @@ Partition Parameters:
numFiles 1
numRows 3
rawDataSize 765
- totalSize 907
+ totalSize 899
#### A masked pattern was here ####
# Storage Information
@@ -467,7 +467,7 @@ Partition Parameters:
numFiles 1
numRows 3
rawDataSize 765
- totalSize 907
+ totalSize 899
#### A masked pattern was here ####
# Storage Information
@@ -580,7 +580,7 @@ Partition Parameters:
numFiles 3
numRows 3
rawDataSize 765
- totalSize 1141
+ totalSize 1133
#### A masked pattern was here ####
# Storage Information
@@ -625,7 +625,7 @@ Partition Parameters:
numFiles 3
numRows 3
rawDataSize 765
- totalSize 1141
+ totalSize 1133
#### A masked pattern was here ####
# Storage Information
@@ -758,7 +758,7 @@ Partition Parameters:
numFiles 1
numRows 3
rawDataSize 765
- totalSize 907
+ totalSize 899
#### A masked pattern was here ####
# Storage Information
@@ -803,7 +803,7 @@ Partition Parameters:
numFiles 1
numRows 3
rawDataSize 765
- totalSize 907
+ totalSize 899
#### A masked pattern was here ####
# Storage Information
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/tez/orc_merge7.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/tez/orc_merge7.q.out?rev=1627125&r1=1627124&r2=1627125&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/tez/orc_merge7.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/tez/orc_merge7.q.out Tue Sep 23 19:30:11 2014
@@ -194,7 +194,7 @@ Partition Parameters:
numFiles 1
numRows 1
rawDataSize 255
- totalSize 521
+ totalSize 513
#### A masked pattern was here ####
# Storage Information
@@ -238,7 +238,7 @@ Partition Parameters:
numFiles 2
numRows 2
rawDataSize 510
- totalSize 1058
+ totalSize 1044
#### A masked pattern was here ####
# Storage Information
@@ -486,7 +486,7 @@ Partition Parameters:
numFiles 1
numRows 1
rawDataSize 255
- totalSize 521
+ totalSize 513
#### A masked pattern was here ####
# Storage Information
@@ -530,7 +530,7 @@ Partition Parameters:
numFiles 1
numRows 2
rawDataSize 510
- totalSize 852
+ totalSize 838
#### A masked pattern was here ####
# Storage Information
@@ -681,7 +681,7 @@ Partition Parameters:
numFiles 1
numRows 1
rawDataSize 255
- totalSize 521
+ totalSize 513
#### A masked pattern was here ####
# Storage Information
@@ -725,7 +725,7 @@ Partition Parameters:
numFiles 2
numRows 2
rawDataSize 510
- totalSize 1058
+ totalSize 1044
#### A masked pattern was here ####
# Storage Information
@@ -859,7 +859,7 @@ Partition Parameters:
numFiles 1
numRows 1
rawDataSize 255
- totalSize 521
+ totalSize 513
#### A masked pattern was here ####
# Storage Information
@@ -903,7 +903,7 @@ Partition Parameters:
numFiles 1
numRows 2
rawDataSize 510
- totalSize 852
+ totalSize 838
#### A masked pattern was here ####
# Storage Information
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/tez/orc_merge_incompat1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/tez/orc_merge_incompat1.q.out?rev=1627125&r1=1627124&r2=1627125&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/tez/orc_merge_incompat1.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/tez/orc_merge_incompat1.q.out Tue Sep 23 19:30:11 2014
@@ -179,7 +179,7 @@ Table Parameters:
numFiles 5
numRows 15
rawDataSize 3825
- totalSize 2862
+ totalSize 2877
#### A masked pattern was here ####
# Storage Information
@@ -257,7 +257,7 @@ Table Parameters:
numFiles 3
numRows 15
rawDataSize 3825
- totalSize 2325
+ totalSize 2340
#### A masked pattern was here ####
# Storage Information
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/tez/orc_merge_incompat2.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/tez/orc_merge_incompat2.q.out?rev=1627125&r1=1627124&r2=1627125&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/tez/orc_merge_incompat2.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/tez/orc_merge_incompat2.q.out Tue Sep 23 19:30:11 2014
@@ -252,7 +252,7 @@ Partition Parameters:
numFiles 4
numRows 4
rawDataSize 1020
- totalSize 2092
+ totalSize 2060
#### A masked pattern was here ####
# Storage Information
@@ -296,7 +296,7 @@ Partition Parameters:
numFiles 4
numRows 8
rawDataSize 2040
- totalSize 2204
+ totalSize 2188
#### A masked pattern was here ####
# Storage Information
@@ -437,7 +437,7 @@ Partition Parameters:
numFiles 3
numRows 4
rawDataSize 1020
- totalSize 1851
+ totalSize 1819
#### A masked pattern was here ####
# Storage Information
@@ -481,7 +481,7 @@ Partition Parameters:
numFiles 3
numRows 8
rawDataSize 2040
- totalSize 1944
+ totalSize 1928
#### A masked pattern was here ####
# Storage Information