This is an automated email from the ASF dual-hosted git repository.
sankarh pushed a commit to branch branch-3
in repository https://gitbox.apache.org/repos/asf/hive.git
The following commit(s) were added to refs/heads/branch-3 by this push:
new 6e6a176c2d3 HIVE-27540: Fix orc_merge10.q test in branch-3 (#4523)
6e6a176c2d3 is described below
commit 6e6a176c2d3b5c9127dfdc215d6cbc44ce27e02c
Author: Aman Raj <104416558+amanraj2...@users.noreply.github.com>
AuthorDate: Thu Aug 3 19:12:17 2023 +0530
HIVE-27540: Fix orc_merge10.q test in branch-3 (#4523)
Signed-off-by: Sankar Hariappan <sank...@apache.org>
Closes (#4523)
---
.../test/results/clientpositive/orc_merge10.q.out | 116 ++++++++++-----------
1 file changed, 58 insertions(+), 58 deletions(-)
diff --git a/ql/src/test/results/clientpositive/orc_merge10.q.out
b/ql/src/test/results/clientpositive/orc_merge10.q.out
index 33e8d58ab1f..18435a824ee 100644
--- a/ql/src/test/results/clientpositive/orc_merge10.q.out
+++ b/ql/src/test/results/clientpositive/orc_merge10.q.out
@@ -640,13 +640,13 @@ Type: struct<key:int,value:string>
Stripe Statistics:
Stripe 1:
- Column 0: count: 152 hasNull: false
- Column 1: count: 152 hasNull: false bytesOnDisk: 309 min: 0 max: 497 sum:
38034
- Column 2: count: 152 hasNull: false bytesOnDisk: 679 min: val_0 max:
val_97 sum: 1034
- Stripe 2:
Column 0: count: 90 hasNull: false
Column 1: count: 90 hasNull: false bytesOnDisk: 185 min: 0 max: 495 sum:
22736
Column 2: count: 90 hasNull: false bytesOnDisk: 428 min: val_0 max: val_86
sum: 612
+ Stripe 2:
+ Column 0: count: 152 hasNull: false
+ Column 1: count: 152 hasNull: false bytesOnDisk: 309 min: 0 max: 497 sum:
38034
+ Column 2: count: 152 hasNull: false bytesOnDisk: 679 min: val_0 max:
val_97 sum: 1034
File Statistics:
Column 0: count: 242 hasNull: false
@@ -654,47 +654,47 @@ File Statistics:
Column 2: count: 242 hasNull: false bytesOnDisk: 1107 min: val_0 max: val_97
sum: 1646
Stripes:
- Stripe: offset: 3 data: 988 rows: 152 tail: 72 index: 77
- Stream: column 0 section ROW_INDEX start: 3 length 12
- Stream: column 1 section ROW_INDEX start: 15 length 28
- Stream: column 2 section ROW_INDEX start: 43 length 37
- Stream: column 1 section DATA start: 80 length 309
- Stream: column 2 section DATA start: 389 length 157
- Stream: column 2 section LENGTH start: 546 length 60
- Stream: column 2 section DICTIONARY_DATA start: 606 length 462
+ Stripe: offset: 3 data: 613 rows: 90 tail: 61 index: 76
+ Stream: column 0 section ROW_INDEX start: 3 length 11
+ Stream: column 1 section ROW_INDEX start: 14 length 27
+ Stream: column 2 section ROW_INDEX start: 41 length 38
+ Stream: column 1 section DATA start: 79 length 185
+ Stream: column 2 section DATA start: 264 length 377
+ Stream: column 2 section LENGTH start: 641 length 51
Encoding column 0: DIRECT
Encoding column 1: DIRECT_V2
- Encoding column 2: DICTIONARY_V2[114]
+ Encoding column 2: DIRECT_V2
Row group indices for column 0:
- Entry 0: count: 152 hasNull: false positions:
+ Entry 0: count: 90 hasNull: false positions:
Row group indices for column 1:
- Entry 0: count: 152 hasNull: false min: 0 max: 497 sum: 38034 positions:
0,0,0
+ Entry 0: count: 90 hasNull: false min: 0 max: 495 sum: 22736 positions:
0,0,0
Row group indices for column 2:
- Entry 0: count: 152 hasNull: false min: val_0 max: val_97 sum: 1034
positions: 0,0,0
- Stripe: offset: 1140 data: 613 rows: 90 tail: 61 index: 76
- Stream: column 0 section ROW_INDEX start: 1140 length 11
- Stream: column 1 section ROW_INDEX start: 1151 length 27
- Stream: column 2 section ROW_INDEX start: 1178 length 38
- Stream: column 1 section DATA start: 1216 length 185
- Stream: column 2 section DATA start: 1401 length 377
- Stream: column 2 section LENGTH start: 1778 length 51
+ Entry 0: count: 90 hasNull: false min: val_0 max: val_86 sum: 612
positions: 0,0,0,0,0
+ Stripe: offset: 753 data: 988 rows: 152 tail: 72 index: 77
+ Stream: column 0 section ROW_INDEX start: 753 length 12
+ Stream: column 1 section ROW_INDEX start: 765 length 28
+ Stream: column 2 section ROW_INDEX start: 793 length 37
+ Stream: column 1 section DATA start: 830 length 309
+ Stream: column 2 section DATA start: 1139 length 157
+ Stream: column 2 section LENGTH start: 1296 length 60
+ Stream: column 2 section DICTIONARY_DATA start: 1356 length 462
Encoding column 0: DIRECT
Encoding column 1: DIRECT_V2
- Encoding column 2: DIRECT_V2
+ Encoding column 2: DICTIONARY_V2[114]
Row group indices for column 0:
- Entry 0: count: 90 hasNull: false positions:
+ Entry 0: count: 152 hasNull: false positions:
Row group indices for column 1:
- Entry 0: count: 90 hasNull: false min: 0 max: 495 sum: 22736 positions:
0,0,0
+ Entry 0: count: 152 hasNull: false min: 0 max: 497 sum: 38034 positions:
0,0,0
Row group indices for column 2:
- Entry 0: count: 90 hasNull: false min: val_0 max: val_86 sum: 612
positions: 0,0,0,0,0
+ Entry 0: count: 152 hasNull: false min: val_0 max: val_97 sum: 1034
positions: 0,0,0
-File length: 2155 bytes
+File length: 2157 bytes
Padding length: 0 bytes
Padding ratio: 0%
________________________________________________________________________________________________________________________
-- END ORC FILE DUMP --
-172 val_172 1 0
+86 val_86 1 0
PREHOOK: query: select * from orcfile_merge1c where ds='1' and part='0' limit 1
PREHOOK: type: QUERY
PREHOOK: Input: default@orcfile_merge1c
@@ -710,13 +710,13 @@ Type: struct<key:int,value:string>
Stripe Statistics:
Stripe 1:
- Column 0: count: 152 hasNull: false
- Column 1: count: 152 hasNull: false bytesOnDisk: 309 min: 0 max: 497 sum:
38034
- Column 2: count: 152 hasNull: false bytesOnDisk: 679 min: val_0 max:
val_97 sum: 1034
- Stripe 2:
Column 0: count: 90 hasNull: false
Column 1: count: 90 hasNull: false bytesOnDisk: 185 min: 0 max: 495 sum:
22736
Column 2: count: 90 hasNull: false bytesOnDisk: 428 min: val_0 max: val_86
sum: 612
+ Stripe 2:
+ Column 0: count: 152 hasNull: false
+ Column 1: count: 152 hasNull: false bytesOnDisk: 309 min: 0 max: 497 sum:
38034
+ Column 2: count: 152 hasNull: false bytesOnDisk: 679 min: val_0 max:
val_97 sum: 1034
File Statistics:
Column 0: count: 242 hasNull: false
@@ -724,47 +724,47 @@ File Statistics:
Column 2: count: 242 hasNull: false bytesOnDisk: 1107 min: val_0 max: val_97
sum: 1646
Stripes:
- Stripe: offset: 3 data: 988 rows: 152 tail: 72 index: 77
- Stream: column 0 section ROW_INDEX start: 3 length 12
- Stream: column 1 section ROW_INDEX start: 15 length 28
- Stream: column 2 section ROW_INDEX start: 43 length 37
- Stream: column 1 section DATA start: 80 length 309
- Stream: column 2 section DATA start: 389 length 157
- Stream: column 2 section LENGTH start: 546 length 60
- Stream: column 2 section DICTIONARY_DATA start: 606 length 462
+ Stripe: offset: 3 data: 613 rows: 90 tail: 61 index: 76
+ Stream: column 0 section ROW_INDEX start: 3 length 11
+ Stream: column 1 section ROW_INDEX start: 14 length 27
+ Stream: column 2 section ROW_INDEX start: 41 length 38
+ Stream: column 1 section DATA start: 79 length 185
+ Stream: column 2 section DATA start: 264 length 377
+ Stream: column 2 section LENGTH start: 641 length 51
Encoding column 0: DIRECT
Encoding column 1: DIRECT_V2
- Encoding column 2: DICTIONARY_V2[114]
+ Encoding column 2: DIRECT_V2
Row group indices for column 0:
- Entry 0: count: 152 hasNull: false positions:
+ Entry 0: count: 90 hasNull: false positions:
Row group indices for column 1:
- Entry 0: count: 152 hasNull: false min: 0 max: 497 sum: 38034 positions:
0,0,0
+ Entry 0: count: 90 hasNull: false min: 0 max: 495 sum: 22736 positions:
0,0,0
Row group indices for column 2:
- Entry 0: count: 152 hasNull: false min: val_0 max: val_97 sum: 1034
positions: 0,0,0
- Stripe: offset: 1140 data: 613 rows: 90 tail: 61 index: 76
- Stream: column 0 section ROW_INDEX start: 1140 length 11
- Stream: column 1 section ROW_INDEX start: 1151 length 27
- Stream: column 2 section ROW_INDEX start: 1178 length 38
- Stream: column 1 section DATA start: 1216 length 185
- Stream: column 2 section DATA start: 1401 length 377
- Stream: column 2 section LENGTH start: 1778 length 51
+ Entry 0: count: 90 hasNull: false min: val_0 max: val_86 sum: 612
positions: 0,0,0,0,0
+ Stripe: offset: 753 data: 988 rows: 152 tail: 72 index: 77
+ Stream: column 0 section ROW_INDEX start: 753 length 12
+ Stream: column 1 section ROW_INDEX start: 765 length 28
+ Stream: column 2 section ROW_INDEX start: 793 length 37
+ Stream: column 1 section DATA start: 830 length 309
+ Stream: column 2 section DATA start: 1139 length 157
+ Stream: column 2 section LENGTH start: 1296 length 60
+ Stream: column 2 section DICTIONARY_DATA start: 1356 length 462
Encoding column 0: DIRECT
Encoding column 1: DIRECT_V2
- Encoding column 2: DIRECT_V2
+ Encoding column 2: DICTIONARY_V2[114]
Row group indices for column 0:
- Entry 0: count: 90 hasNull: false positions:
+ Entry 0: count: 152 hasNull: false positions:
Row group indices for column 1:
- Entry 0: count: 90 hasNull: false min: 0 max: 495 sum: 22736 positions:
0,0,0
+ Entry 0: count: 152 hasNull: false min: 0 max: 497 sum: 38034 positions:
0,0,0
Row group indices for column 2:
- Entry 0: count: 90 hasNull: false min: val_0 max: val_86 sum: 612
positions: 0,0,0,0,0
+ Entry 0: count: 152 hasNull: false min: val_0 max: val_97 sum: 1034
positions: 0,0,0
-File length: 2155 bytes
+File length: 2157 bytes
Padding length: 0 bytes
Padding ratio: 0%
________________________________________________________________________________________________________________________
-- END ORC FILE DUMP --
-172 val_172 1 0
+86 val_86 1 0
PREHOOK: query: DROP TABLE orcfile_merge1
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@orcfile_merge1
