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
