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/11 23:02:11 UTC
svn commit: r1624389 [2/3] - in /hive/branches/cbo: ./
common/src/java/org/apache/hadoop/hive/conf/
itests/hive-unit-hadoop2/src/test/java/org/apache/hadoop/hive/ql/security/
itests/hive-unit/src/test/java/org/apache/hadoop/hive/ql/security/
itests/hiv...
Modified: hive/branches/cbo/ql/src/test/resources/orc-file-dump-dictionary-threshold.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/resources/orc-file-dump-dictionary-threshold.out?rev=1624389&r1=1624388&r2=1624389&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/resources/orc-file-dump-dictionary-threshold.out (original)
+++ hive/branches/cbo/ql/src/test/resources/orc-file-dump-dictionary-threshold.out Thu Sep 11 21:02:09 2014
@@ -38,15 +38,15 @@ File Statistics:
Column 3: count: 21000 min: Darkness,-230 max: worst-54-290-346-648-908-996-1038-1080-1560-1584-1620-1744-1770-1798-1852-1966-2162-2244-2286-2296-2534-2660-3114-3676-3788-4068-4150-4706-4744-5350-5420-5582-5696-5726-6006-6020-6024-6098-6184-6568-6636-6802-6994-7004-7318-7498-7758-7780-7798-7920-7952-7960-7988-8232-8256-8390-8416-8478-8620-8840-8984-9038-9128-9236-9248-9344-9594-9650-9714-9928-9938-10178-10368-10414-10502-10732-10876-11008-11158-11410-11722-11836-11964-12054-12096-12126-12136-12202-12246-12298-12616-12774-12782-12790-12802-12976-13216-13246-13502-13766-14454-14974-15004-15124-15252-15294-15356-15530-15610-16316-16936-17024-17122-17214-17310-17528-17682-17742-17870-17878-18010-18410-18524-18788-19204-19254-19518-19596-19786-19874-19904-20390-20752-20936 sum: 6910238
Stripes:
- Stripe: offset: 3 data: 144733 rows: 5000 tail: 68 index: 693
+ Stripe: offset: 3 data: 151109 rows: 5000 tail: 68 index: 704
Stream: column 0 section ROW_INDEX start: 3 length 15
Stream: column 1 section ROW_INDEX start: 18 length 156
- Stream: column 2 section ROW_INDEX start: 174 length 170
- Stream: column 3 section ROW_INDEX start: 344 length 352
- Stream: column 1 section DATA start: 696 length 20029
- Stream: column 2 section DATA start: 20725 length 40035
- Stream: column 3 section DATA start: 60760 length 80382
- Stream: column 3 section LENGTH start: 141142 length 4287
+ Stream: column 2 section ROW_INDEX start: 174 length 172
+ Stream: column 3 section ROW_INDEX start: 346 length 361
+ Stream: column 1 section DATA start: 707 length 20029
+ Stream: column 2 section DATA start: 20736 length 40035
+ Stream: column 3 section DATA start: 60771 length 86757
+ Stream: column 3 section LENGTH start: 147528 length 4288
Encoding column 0: DIRECT
Encoding column 1: DIRECT_V2
Encoding column 2: DIRECT_V2
@@ -65,19 +65,19 @@ Stripes:
Entry 4: count: 1000 min: -9216505819108477308 max: 9196474183833079923 positions: 20006,8686,416
Row group index column 3:
Entry 0: count: 1000 min: Darkness,-230 max: worst-54-290-346-648-908-996 positions: 0,0,0,0,0
- Entry 1: count: 1000 min: Darkness,-230-368-488-586-862-930-1686 max: worst-54-290-346-648-908-996-1038-1080-1560-1584-1620-1744-1770-1798-1852-1966 positions: 2083,8442,0,696,18
- Entry 2: count: 1000 min: Darkness,-230-368-488-586-862-930-1686-2044 max: worst-54-290-346-648-908-996-1038-1080-1560-1584-1620-1744-1770-1798-1852-1966-2162-2244-2286-2296-2534-2660 positions: 11712,4780,0,1555,14
- Entry 3: count: 1000 min: Darkness,-230-368-488-586-862-930-1686-2044-2636-2652-2872-3108 max: worst-54-290-346-648-908-996-1038-1080-1560-1584-1620-1744-1770-1798-1852-1966-2162-2244-2286-2296-2534-2660-3114-3676-3788 positions: 28297,228,0,2373,90
- Entry 4: count: 1000 min: Darkness,-230-368-488-586-862-930-1686-2044-2636-2652-2872-3108-3162-3192-3404-3442-3508-3542-3550-3712-3980-4146 max: worst-54-290-346-648-908-996-1038-1080-1560-1584-1620-1744-1770-1798-1852-1966-2162-2244-2286-2296-2534-2660-3114-3676-3788-4068-4150-4706-4744 positions: 49599,5096,0,3355,108
- Stripe: offset: 145497 data: 321684 rows: 5000 tail: 68 index: 907
- Stream: column 0 section ROW_INDEX start: 145497 length 15
- Stream: column 1 section ROW_INDEX start: 145512 length 150
- Stream: column 2 section ROW_INDEX start: 145662 length 167
- Stream: column 3 section ROW_INDEX start: 145829 length 575
- Stream: column 1 section DATA start: 146404 length 20029
- Stream: column 2 section DATA start: 166433 length 40035
- Stream: column 3 section DATA start: 206468 length 256119
- Stream: column 3 section LENGTH start: 462587 length 5501
+ Entry 1: count: 1000 min: Darkness,-230-368-488-586-862-930-1686 max: worst-54-290-346-648-908-996-1038-1080-1560-1584-1620-1744-1770-1798-1852-1966 positions: 2777,8442,0,696,18
+ Entry 2: count: 1000 min: Darkness,-230-368-488-586-862-930-1686-2044 max: worst-54-290-346-648-908-996-1038-1080-1560-1584-1620-1744-1770-1798-1852-1966-2162-2244-2286-2296-2534-2660 positions: 13595,4780,0,1555,14
+ Entry 3: count: 1000 min: Darkness,-230-368-488-586-862-930-1686-2044-2636-2652-2872-3108 max: worst-54-290-346-648-908-996-1038-1080-1560-1584-1620-1744-1770-1798-1852-1966-2162-2244-2286-2296-2534-2660-3114-3676-3788 positions: 31432,228,0,2373,90
+ Entry 4: count: 1000 min: Darkness,-230-368-488-586-862-930-1686-2044-2636-2652-2872-3108-3162-3192-3404-3442-3508-3542-3550-3712-3980-4146 max: worst-54-290-346-648-908-996-1038-1080-1560-1584-1620-1744-1770-1798-1852-1966-2162-2244-2286-2296-2534-2660-3114-3676-3788-4068-4150-4706-4744 positions: 54111,5096,0,3355,108
+ Stripe: offset: 151884 data: 336358 rows: 5000 tail: 69 index: 941
+ Stream: column 0 section ROW_INDEX start: 151884 length 15
+ Stream: column 1 section ROW_INDEX start: 151899 length 150
+ Stream: column 2 section ROW_INDEX start: 152049 length 167
+ Stream: column 3 section ROW_INDEX start: 152216 length 609
+ Stream: column 1 section DATA start: 152825 length 20029
+ Stream: column 2 section DATA start: 172854 length 40035
+ Stream: column 3 section DATA start: 212889 length 270789
+ Stream: column 3 section LENGTH start: 483678 length 5505
Encoding column 0: DIRECT
Encoding column 1: DIRECT_V2
Encoding column 2: DIRECT_V2
@@ -96,19 +96,19 @@ Stripes:
Entry 4: count: 1000 min: -9201438531577205959 max: 9212462124593119846 positions: 20006,8686,416
Row group index column 3:
Entry 0: count: 1000 min: Darkness,-230-368-488-586-862-930-1686-2044-2636-2652-2872-3108-3162-3192-3404-3442-3508-3542-3550-3712-3980-4146-4204-4336-4390-4418-4424-4490-4512-4650-4768-4924-4950-5210 max: worst-54-290-346-648-908-996-1038-1080-1560-1584-1620-1744-1770-1798-1852-1966-2162-2244-2286-2296-2534-2660-3114-3676-3788-4068-4150-4706-4744-5350-5420-5582-5696-5726 positions: 0,0,0,0,0
- Entry 1: count: 1000 min: Darkness,-230-368-488-586-862-930-1686-2044-2636-2652-2872-3108-3162-3192-3404-3442-3508-3542-3550-3712-3980-4146-4204-4336-4390-4418-4424-4490-4512-4650-4768-4924-4950-5210-5524-5630-5678-5710-5758-5952-6238 max: worst-54-290-346-648-908-996-1038-1080-1560-1584-1620-1744-1770-1798-1852-1966-2162-2244-2286-2296-2534-2660-3114-3676-3788-4068-4150-4706-4744-5350-5420-5582-5696-5726-6006-6020-6024-6098-6184-6568-6636-6802-6994 positions: 35030,6320,0,967,90
- Entry 2: count: 1000 min: Darkness,-230-368-488-586-862-930-1686-2044-2636-2652-2872-3108-3162-3192-3404-3442-3508-3542-3550-3712-3980-4146-4204-4336-4390-4418-4424-4490-4512-4650-4768-4924-4950-5210-5524-5630-5678-5710-5758-5952-6238-6252-6300-6366-6668-6712-6926-6942-7100 max: worst-54-290-346-648-908-996-1038-1080-1560-1584-1620-1744-1770-1798-1852-1966-2162-2244-2286-2296-2534-2660-3114-3676-3788-4068-4150-4706-4744-5350-5420-5582-5696-5726-6006-6020-6024-6098-6184-6568-6636-6802-6994-7004-7318-7498-7758-7780-7798-7920-7952-7960-7988 positions: 76249,9756,0,1945,222
- Entry 3: count: 1000 min: Darkness,-230-368-488-586-862-930-1686-2044-2636-2652-2872-3108-3162-3192-3404-3442-3508-3542-3550-3712-3980-4146-4204-4336-4390-4418-4424-4490-4512-4650-4768-4924-4950-5210-5524-5630-5678-5710-5758-5952-6238-6252-6300-6366-6668-6712-6926-6942-7100-7194-7802-8030 max: worst-54-290-346-648-908-996-1038-1080-1560-1584-1620-1744-1770-1798-1852-1966-2162-2244-2286-2296-2534-2660-3114-3676-3788-4068-4150-4706-4744-5350-5420-5582-5696-5726-6006-6020-6024-6098-6184-6568-6636-6802-6994-7004-7318-7498-7758-7780-7798-7920-7952-7960-7988-8232-8256-8390-8416-8478-8620-8840-8984 positions: 129633,4496,0,3268,48
- Entry 4: count: 1000 min: Darkness,-230-368-488-586-862-930-1686-2044-2636-2652-2872-3108-3162-3192-3404-3442-3508-3542-3550-3712-3980-4146-4204-4336-4390-4418-4424-4490-4512-4650-4768-4924-4950-5210-5524-5630-5678-5710-5758-5952-6238-6252-6300-6366-6668-6712-6926-6942-7100-7194-7802-8030-8452-8608-8640-8862-8868-9134 max: worst-54-290-346-648-908-996-1038-1080-1560-1584-1620-1744-1770-1798-1852-1966-2162-2244-2286-2296-2534-2660-3114-3676-3788-4068-4150-4706-4744-5350-5420-5582-5696-5726-6006-6020-6024-6098-6184-6568-6636-6802-6994-7004-7318-7498-7758-7780-7798-7920-7952-7960-7988-8232-8256-8390-8416-8478-8620-8840-8984-9038-9128-9236-9248-9344-9594-9650-9714-9928-9938 positions: 187250,6590,0,4064,342
- Stripe: offset: 468156 data: 531773 rows: 5000 tail: 69 index: 1101
- Stream: column 0 section ROW_INDEX start: 468156 length 15
- Stream: column 1 section ROW_INDEX start: 468171 length 159
- Stream: column 2 section ROW_INDEX start: 468330 length 169
- Stream: column 3 section ROW_INDEX start: 468499 length 758
- Stream: column 1 section DATA start: 469257 length 20029
- Stream: column 2 section DATA start: 489286 length 40035
- Stream: column 3 section DATA start: 529321 length 466002
- Stream: column 3 section LENGTH start: 995323 length 5707
+ Entry 1: count: 1000 min: Darkness,-230-368-488-586-862-930-1686-2044-2636-2652-2872-3108-3162-3192-3404-3442-3508-3542-3550-3712-3980-4146-4204-4336-4390-4418-4424-4490-4512-4650-4768-4924-4950-5210-5524-5630-5678-5710-5758-5952-6238 max: worst-54-290-346-648-908-996-1038-1080-1560-1584-1620-1744-1770-1798-1852-1966-2162-2244-2286-2296-2534-2660-3114-3676-3788-4068-4150-4706-4744-5350-5420-5582-5696-5726-6006-6020-6024-6098-6184-6568-6636-6802-6994 positions: 37112,6320,0,967,90
+ Entry 2: count: 1000 min: Darkness,-230-368-488-586-862-930-1686-2044-2636-2652-2872-3108-3162-3192-3404-3442-3508-3542-3550-3712-3980-4146-4204-4336-4390-4418-4424-4490-4512-4650-4768-4924-4950-5210-5524-5630-5678-5710-5758-5952-6238-6252-6300-6366-6668-6712-6926-6942-7100 max: worst-54-290-346-648-908-996-1038-1080-1560-1584-1620-1744-1770-1798-1852-1966-2162-2244-2286-2296-2534-2660-3114-3676-3788-4068-4150-4706-4744-5350-5420-5582-5696-5726-6006-6020-6024-6098-6184-6568-6636-6802-6994-7004-7318-7498-7758-7780-7798-7920-7952-7960-7988 positions: 80822,9756,0,1945,222
+ Entry 3: count: 1000 min: Darkness,-230-368-488-586-862-930-1686-2044-2636-2652-2872-3108-3162-3192-3404-3442-3508-3542-3550-3712-3980-4146-4204-4336-4390-4418-4424-4490-4512-4650-4768-4924-4950-5210-5524-5630-5678-5710-5758-5952-6238-6252-6300-6366-6668-6712-6926-6942-7100-7194-7802-8030 max: worst-54-290-346-648-908-996-1038-1080-1560-1584-1620-1744-1770-1798-1852-1966-2162-2244-2286-2296-2534-2660-3114-3676-3788-4068-4150-4706-4744-5350-5420-5582-5696-5726-6006-6020-6024-6098-6184-6568-6636-6802-6994-7004-7318-7498-7758-7780-7798-7920-7952-7960-7988-8232-8256-8390-8416-8478-8620-8840-8984 positions: 137149,4496,0,3268,48
+ Entry 4: count: 1000 min: Darkness,-230-368-488-586-862-930-1686-2044-2636-2652-2872-3108-3162-3192-3404-3442-3508-3542-3550-3712-3980-4146-4204-4336-4390-4418-4424-4490-4512-4650-4768-4924-4950-5210-5524-5630-5678-5710-5758-5952-6238-6252-6300-6366-6668-6712-6926-6942-7100-7194-7802-8030-8452-8608-8640-8862-8868-9134 max: worst-54-290-346-648-908-996-1038-1080-1560-1584-1620-1744-1770-1798-1852-1966-2162-2244-2286-2296-2534-2660-3114-3676-3788-4068-4150-4706-4744-5350-5420-5582-5696-5726-6006-6020-6024-6098-6184-6568-6636-6802-6994-7004-7318-7498-7758-7780-7798-7920-7952-7960-7988-8232-8256-8390-8416-8478-8620-8840-8984-9038-9128-9236-9248-9344-9594-9650-9714-9928-9938 positions: 197972,6590,0,4064,342
+ Stripe: offset: 489252 data: 558031 rows: 5000 tail: 69 index: 1169
+ Stream: column 0 section ROW_INDEX start: 489252 length 15
+ Stream: column 1 section ROW_INDEX start: 489267 length 159
+ Stream: column 2 section ROW_INDEX start: 489426 length 169
+ Stream: column 3 section ROW_INDEX start: 489595 length 826
+ Stream: column 1 section DATA start: 490421 length 20029
+ Stream: column 2 section DATA start: 510450 length 40035
+ Stream: column 3 section DATA start: 550485 length 492258
+ Stream: column 3 section LENGTH start: 1042743 length 5709
Encoding column 0: DIRECT
Encoding column 1: DIRECT_V2
Encoding column 2: DIRECT_V2
@@ -127,19 +127,19 @@ Stripes:
Entry 4: count: 1000 min: -9215483580266514322 max: 9220102792864959501 positions: 20006,8686,416
Row group index column 3:
Entry 0: count: 1000 min: Darkness,-230-368-488-586-862-930-1686-2044-2636-2652-2872-3108-3162-3192-3404-3442-3508-3542-3550-3712-3980-4146-4204-4336-4390-4418-4424-4490-4512-4650-4768-4924-4950-5210-5524-5630-5678-5710-5758-5952-6238-6252-6300-6366-6668-6712-6926-6942-7100-7194-7802-8030-8452-8608-8640-8862-8868-9134-9234-9412-9602-9608-9642-9678-9740-9780-10426 max: worst-54-290-346-648-908-996-1038-1080-1560-1584-1620-1744-1770-1798-1852-1966-2162-2244-2286-2296-2534-2660-3114-3676-3788-4068-4150-4706-4744-5350-5420-5582-5696-5726-6006-6020-6024-6098-6184-6568-6636-6802-6994-7004-7318-7498-7758-7780-7798-7920-7952-7960-7988-8232-8256-8390-8416-8478-8620-8840-8984-9038-9128-9236-9248-9344-9594-9650-9714-9928-9938-10178-10368-10414-10502-10732-10876 positions: 0,0,0,0,0
- Entry 1: count: 1000 min: Darkness,-230-368-488-586-862-930-1686-2044-2636-2652-2872-3108-3162-3192-3404-3442-3508-3542-3550-3712-3980-4146-4204-4336-4390-4418-4424-4490-4512-4650-4768-4924-4950-5210-5524-5630-5678-5710-5758-5952-6238-6252-6300-6366-6668-6712-6926-6942-7100-7194-7802-8030-8452-8608-8640-8862-8868-9134-9234-9412-9602-9608-9642-9678-9740-9780-10426-10510-10514-10706-10814-10870-10942-11028 max: worst-54-290-346-648-908-996-1038-1080-1560-1584-1620-1744-1770-1798-1852-1966-2162-2244-2286-2296-2534-2660-3114-3676-3788-4068-4150-4706-4744-5350-5420-5582-5696-5726-6006-6020-6024-6098-6184-6568-6636-6802-6994-7004-7318-7498-7758-7780-7798-7920-7952-7960-7988-8232-8256-8390-8416-8478-8620-8840-8984-9038-9128-9236-9248-9344-9594-9650-9714-9928-9938-10178-10368-10414-10502-10732-10876-11008-11158-11410-11722-11836-11964 positions: 76243,3880,0,1097,28
- Entry 2: count: 1000 min: Darkness,-230-368-488-586-862-930-1686-2044-2636-2652-2872-3108-3162-3192-3404-3442-3508-3542-3550-3712-3980-4146-4204-4336-4390-4418-4424-4490-4512-4650-4768-4924-4950-5210-5524-5630-5678-5710-5758-5952-6238-6252-6300-6366-6668-6712-6926-6942-7100-7194-7802-8030-8452-8608-8640-8862-8868-9134-9234-9412-9602-9608-9642-9678-9740-9780-10426-10510-10514-10706-10814-10870-10942-11028-11244-11326-11462-11496-11656-11830-12022 max: worst-54-290-346-648-908-996-1038-1080-1560-1584-1620-1744-1770-1798-1852-1966-2162-2244-2286-2296-2534-2660-3114-3676-3788-4068-4150-4706-4744-5350-5420-5582-5696-5726-6006-6020-6024-6098-6184-6568-6636-6802-6994-7004-7318-7498-7758-7780-7798-7920-7952-7960-7988-8232-8256-8390-8416-8478-8620-8840-8984-9038-9128-9236-9248-9344-9594-9650-9714-9928-9938-10178-10368-10414-10502-10732-10876-11008-11158-11410-11722-11836-11964-12054-12096-12126-12136-12202-12246-12298-12616-12774-12782-12790-12802-12976 positions: 161945,3422,0,2077,16
2
- Entry 3: count: 1000 min: Darkness,-230-368-488-586-862-930-1686-2044-2636-2652-2872-3108-3162-3192-3404-3442-3508-3542-3550-3712-3980-4146-4204-4336-4390-4418-4424-4490-4512-4650-4768-4924-4950-5210-5524-5630-5678-5710-5758-5952-6238-6252-6300-6366-6668-6712-6926-6942-7100-7194-7802-8030-8452-8608-8640-8862-8868-9134-9234-9412-9602-9608-9642-9678-9740-9780-10426-10510-10514-10706-10814-10870-10942-11028-11244-11326-11462-11496-11656-11830-12022-12178-12418-12832-13304 max: worst-54-290-346-648-908-996-1038-1080-1560-1584-1620-1744-1770-1798-1852-1966-2162-2244-2286-2296-2534-2660-3114-3676-3788-4068-4150-4706-4744-5350-5420-5582-5696-5726-6006-6020-6024-6098-6184-6568-6636-6802-6994-7004-7318-7498-7758-7780-7798-7920-7952-7960-7988-8232-8256-8390-8416-8478-8620-8840-8984-9038-9128-9236-9248-9344-9594-9650-9714-9928-9938-10178-10368-10414-10502-10732-10876-11008-11158-11410-11722-11836-11964-12054-12096-12126-12136-12202-12246-12298-12616-12774-12782-12790-12802-12976-13216-13
246-13502-13766 positions: 254465,9960,0,3369,16
- Entry 4: count: 1000 min: Darkness,-230-368-488-586-862-930-1686-2044-2636-2652-2872-3108-3162-3192-3404-3442-3508-3542-3550-3712-3980-4146-4204-4336-4390-4418-4424-4490-4512-4650-4768-4924-4950-5210-5524-5630-5678-5710-5758-5952-6238-6252-6300-6366-6668-6712-6926-6942-7100-7194-7802-8030-8452-8608-8640-8862-8868-9134-9234-9412-9602-9608-9642-9678-9740-9780-10426-10510-10514-10706-10814-10870-10942-11028-11244-11326-11462-11496-11656-11830-12022-12178-12418-12832-13304-13448-13590-13618-13908-14188 max: worst-54-290-346-648-908-996-1038-1080-1560-1584-1620-1744-1770-1798-1852-1966-2162-2244-2286-2296-2534-2660-3114-3676-3788-4068-4150-4706-4744-5350-5420-5582-5696-5726-6006-6020-6024-6098-6184-6568-6636-6802-6994-7004-7318-7498-7758-7780-7798-7920-7952-7960-7988-8232-8256-8390-8416-8478-8620-8840-8984-9038-9128-9236-9248-9344-9594-9650-9714-9928-9938-10178-10368-10414-10502-10732-10876-11008-11158-11410-11722-11836-11964-12054-12096-12126-12136-12202-12246-12298-12616-12774-12
782-12790-12802-12976-13216-13246-13502-13766-14454-14974 positions: 357930,1620,0,4041,470
- Stripe: offset: 1001099 data: 751374 rows: 5000 tail: 69 index: 1278
- Stream: column 0 section ROW_INDEX start: 1001099 length 15
- Stream: column 1 section ROW_INDEX start: 1001114 length 149
- Stream: column 2 section ROW_INDEX start: 1001263 length 170
- Stream: column 3 section ROW_INDEX start: 1001433 length 944
- Stream: column 1 section DATA start: 1002377 length 20029
- Stream: column 2 section DATA start: 1022406 length 40035
- Stream: column 3 section DATA start: 1062441 length 685567
- Stream: column 3 section LENGTH start: 1748008 length 5743
+ Entry 1: count: 1000 min: Darkness,-230-368-488-586-862-930-1686-2044-2636-2652-2872-3108-3162-3192-3404-3442-3508-3542-3550-3712-3980-4146-4204-4336-4390-4418-4424-4490-4512-4650-4768-4924-4950-5210-5524-5630-5678-5710-5758-5952-6238-6252-6300-6366-6668-6712-6926-6942-7100-7194-7802-8030-8452-8608-8640-8862-8868-9134-9234-9412-9602-9608-9642-9678-9740-9780-10426-10510-10514-10706-10814-10870-10942-11028 max: worst-54-290-346-648-908-996-1038-1080-1560-1584-1620-1744-1770-1798-1852-1966-2162-2244-2286-2296-2534-2660-3114-3676-3788-4068-4150-4706-4744-5350-5420-5582-5696-5726-6006-6020-6024-6098-6184-6568-6636-6802-6994-7004-7318-7498-7758-7780-7798-7920-7952-7960-7988-8232-8256-8390-8416-8478-8620-8840-8984-9038-9128-9236-9248-9344-9594-9650-9714-9928-9938-10178-10368-10414-10502-10732-10876-11008-11158-11410-11722-11836-11964 positions: 80352,3880,0,1097,28
+ Entry 2: count: 1000 min: Darkness,-230-368-488-586-862-930-1686-2044-2636-2652-2872-3108-3162-3192-3404-3442-3508-3542-3550-3712-3980-4146-4204-4336-4390-4418-4424-4490-4512-4650-4768-4924-4950-5210-5524-5630-5678-5710-5758-5952-6238-6252-6300-6366-6668-6712-6926-6942-7100-7194-7802-8030-8452-8608-8640-8862-8868-9134-9234-9412-9602-9608-9642-9678-9740-9780-10426-10510-10514-10706-10814-10870-10942-11028-11244-11326-11462-11496-11656-11830-12022 max: worst-54-290-346-648-908-996-1038-1080-1560-1584-1620-1744-1770-1798-1852-1966-2162-2244-2286-2296-2534-2660-3114-3676-3788-4068-4150-4706-4744-5350-5420-5582-5696-5726-6006-6020-6024-6098-6184-6568-6636-6802-6994-7004-7318-7498-7758-7780-7798-7920-7952-7960-7988-8232-8256-8390-8416-8478-8620-8840-8984-9038-9128-9236-9248-9344-9594-9650-9714-9928-9938-10178-10368-10414-10502-10732-10876-11008-11158-11410-11722-11836-11964-12054-12096-12126-12136-12202-12246-12298-12616-12774-12782-12790-12802-12976 positions: 170641,3422,0,2077,16
2
+ Entry 3: count: 1000 min: Darkness,-230-368-488-586-862-930-1686-2044-2636-2652-2872-3108-3162-3192-3404-3442-3508-3542-3550-3712-3980-4146-4204-4336-4390-4418-4424-4490-4512-4650-4768-4924-4950-5210-5524-5630-5678-5710-5758-5952-6238-6252-6300-6366-6668-6712-6926-6942-7100-7194-7802-8030-8452-8608-8640-8862-8868-9134-9234-9412-9602-9608-9642-9678-9740-9780-10426-10510-10514-10706-10814-10870-10942-11028-11244-11326-11462-11496-11656-11830-12022-12178-12418-12832-13304 max: worst-54-290-346-648-908-996-1038-1080-1560-1584-1620-1744-1770-1798-1852-1966-2162-2244-2286-2296-2534-2660-3114-3676-3788-4068-4150-4706-4744-5350-5420-5582-5696-5726-6006-6020-6024-6098-6184-6568-6636-6802-6994-7004-7318-7498-7758-7780-7798-7920-7952-7960-7988-8232-8256-8390-8416-8478-8620-8840-8984-9038-9128-9236-9248-9344-9594-9650-9714-9928-9938-10178-10368-10414-10502-10732-10876-11008-11158-11410-11722-11836-11964-12054-12096-12126-12136-12202-12246-12298-12616-12774-12782-12790-12802-12976-13216-13
246-13502-13766 positions: 268420,9960,0,3369,16
+ Entry 4: count: 1000 min: Darkness,-230-368-488-586-862-930-1686-2044-2636-2652-2872-3108-3162-3192-3404-3442-3508-3542-3550-3712-3980-4146-4204-4336-4390-4418-4424-4490-4512-4650-4768-4924-4950-5210-5524-5630-5678-5710-5758-5952-6238-6252-6300-6366-6668-6712-6926-6942-7100-7194-7802-8030-8452-8608-8640-8862-8868-9134-9234-9412-9602-9608-9642-9678-9740-9780-10426-10510-10514-10706-10814-10870-10942-11028-11244-11326-11462-11496-11656-11830-12022-12178-12418-12832-13304-13448-13590-13618-13908-14188 max: worst-54-290-346-648-908-996-1038-1080-1560-1584-1620-1744-1770-1798-1852-1966-2162-2244-2286-2296-2534-2660-3114-3676-3788-4068-4150-4706-4744-5350-5420-5582-5696-5726-6006-6020-6024-6098-6184-6568-6636-6802-6994-7004-7318-7498-7758-7780-7798-7920-7952-7960-7988-8232-8256-8390-8416-8478-8620-8840-8984-9038-9128-9236-9248-9344-9594-9650-9714-9928-9938-10178-10368-10414-10502-10732-10876-11008-11158-11410-11722-11836-11964-12054-12096-12126-12136-12202-12246-12298-12616-12774-12
782-12790-12802-12976-13216-13246-13502-13766-14454-14974 positions: 377916,1620,0,4041,470
+ Stripe: offset: 1048521 data: 792850 rows: 5000 tail: 69 index: 1351
+ Stream: column 0 section ROW_INDEX start: 1048521 length 15
+ Stream: column 1 section ROW_INDEX start: 1048536 length 149
+ Stream: column 2 section ROW_INDEX start: 1048685 length 170
+ Stream: column 3 section ROW_INDEX start: 1048855 length 1017
+ Stream: column 1 section DATA start: 1049872 length 20029
+ Stream: column 2 section DATA start: 1069901 length 40035
+ Stream: column 3 section DATA start: 1109936 length 727038
+ Stream: column 3 section LENGTH start: 1836974 length 5748
Encoding column 0: DIRECT
Encoding column 1: DIRECT_V2
Encoding column 2: DIRECT_V2
@@ -158,19 +158,19 @@ Stripes:
Entry 4: count: 1000 min: -9197393848859294562 max: 9208134757538374043 positions: 20006,8686,416
Row group index column 3:
Entry 0: count: 1000 min: Darkness,-230-368-488-586-862-930-1686-2044-2636-2652-2872-3108-3162-3192-3404-3442-3508-3542-3550-3712-3980-4146-4204-4336-4390-4418-4424-4490-4512-4650-4768-4924-4950-5210-5524-5630-5678-5710-5758-5952-6238-6252-6300-6366-6668-6712-6926-6942-7100-7194-7802-8030-8452-8608-8640-8862-8868-9134-9234-9412-9602-9608-9642-9678-9740-9780-10426-10510-10514-10706-10814-10870-10942-11028-11244-11326-11462-11496-11656-11830-12022-12178-12418-12832-13304-13448-13590-13618-13908-14188-14246-14340-14364-14394-14762-14850-14964-15048 max: worst-54-290-346-648-908-996-1038-1080-1560-1584-1620-1744-1770-1798-1852-1966-2162-2244-2286-2296-2534-2660-3114-3676-3788-4068-4150-4706-4744-5350-5420-5582-5696-5726-6006-6020-6024-6098-6184-6568-6636-6802-6994-7004-7318-7498-7758-7780-7798-7920-7952-7960-7988-8232-8256-8390-8416-8478-8620-8840-8984-9038-9128-9236-9248-9344-9594-9650-9714-9928-9938-10178-10368-10414-10502-10732-10876-11008-11158-11410-11722-11836-11964-12054-12
096-12126-12136-12202-12246-12298-12616-12774-12782-12790-12802-12976-13216-13246-13502-13766-14454-14974-15004-15124-15252-15294-15356-15530-15610 positions: 0,0,0,0,0
- Entry 1: count: 1000 min: Darkness,-230-368-488-586-862-930-1686-2044-2636-2652-2872-3108-3162-3192-3404-3442-3508-3542-3550-3712-3980-4146-4204-4336-4390-4418-4424-4490-4512-4650-4768-4924-4950-5210-5524-5630-5678-5710-5758-5952-6238-6252-6300-6366-6668-6712-6926-6942-7100-7194-7802-8030-8452-8608-8640-8862-8868-9134-9234-9412-9602-9608-9642-9678-9740-9780-10426-10510-10514-10706-10814-10870-10942-11028-11244-11326-11462-11496-11656-11830-12022-12178-12418-12832-13304-13448-13590-13618-13908-14188-14246-14340-14364-14394-14762-14850-14964-15048-15494-15674-15726-16006 max: worst-54-290-346-648-908-996-1038-1080-1560-1584-1620-1744-1770-1798-1852-1966-2162-2244-2286-2296-2534-2660-3114-3676-3788-4068-4150-4706-4744-5350-5420-5582-5696-5726-6006-6020-6024-6098-6184-6568-6636-6802-6994-7004-7318-7498-7758-7780-7798-7920-7952-7960-7988-8232-8256-8390-8416-8478-8620-8840-8984-9038-9128-9236-9248-9344-9594-9650-9714-9928-9938-10178-10368-10414-10502-10732-10876-11008-11158-11410-11
722-11836-11964-12054-12096-12126-12136-12202-12246-12298-12616-12774-12782-12790-12802-12976-13216-13246-13502-13766-14454-14974-15004-15124-15252-15294-15356-15530-15610-16316-16936 positions: 120094,2916,0,1077,140
- Entry 2: count: 1000 min: Darkness,-230-368-488-586-862-930-1686-2044-2636-2652-2872-3108-3162-3192-3404-3442-3508-3542-3550-3712-3980-4146-4204-4336-4390-4418-4424-4490-4512-4650-4768-4924-4950-5210-5524-5630-5678-5710-5758-5952-6238-6252-6300-6366-6668-6712-6926-6942-7100-7194-7802-8030-8452-8608-8640-8862-8868-9134-9234-9412-9602-9608-9642-9678-9740-9780-10426-10510-10514-10706-10814-10870-10942-11028-11244-11326-11462-11496-11656-11830-12022-12178-12418-12832-13304-13448-13590-13618-13908-14188-14246-14340-14364-14394-14762-14850-14964-15048-15494-15674-15726-16006-16056-16180-16304-16332-16452-16598-16730-16810-16994-17210 max: worst-54-290-346-648-908-996-1038-1080-1560-1584-1620-1744-1770-1798-1852-1966-2162-2244-2286-2296-2534-2660-3114-3676-3788-4068-4150-4706-4744-5350-5420-5582-5696-5726-6006-6020-6024-6098-6184-6568-6636-6802-6994-7004-7318-7498-7758-7780-7798-7920-7952-7960-7988-8232-8256-8390-8416-8478-8620-8840-8984-9038-9128-9236-9248-9344-9594-9650-9714-9928-9
938-10178-10368-10414-10502-10732-10876-11008-11158-11410-11722-11836-11964-12054-12096-12126-12136-12202-12246-12298-12616-12774-12782-12790-12802-12976-13216-13246-13502-13766-14454-14974-15004-15124-15252-15294-15356-15530-15610-16316-16936-17024-17122-17214-17310-17528-17682-17742-17870-17878 positions: 248557,206,0,1926,462
- Entry 3: count: 1000 min: Darkness,-230-368-488-586-862-930-1686-2044-2636-2652-2872-3108-3162-3192-3404-3442-3508-3542-3550-3712-3980-4146-4204-4336-4390-4418-4424-4490-4512-4650-4768-4924-4950-5210-5524-5630-5678-5710-5758-5952-6238-6252-6300-6366-6668-6712-6926-6942-7100-7194-7802-8030-8452-8608-8640-8862-8868-9134-9234-9412-9602-9608-9642-9678-9740-9780-10426-10510-10514-10706-10814-10870-10942-11028-11244-11326-11462-11496-11656-11830-12022-12178-12418-12832-13304-13448-13590-13618-13908-14188-14246-14340-14364-14394-14762-14850-14964-15048-15494-15674-15726-16006-16056-16180-16304-16332-16452-16598-16730-16810-16994-17210-17268-17786-17962-18214 max: worst-54-290-346-648-908-996-1038-1080-1560-1584-1620-1744-1770-1798-1852-1966-2162-2244-2286-2296-2534-2660-3114-3676-3788-4068-4150-4706-4744-5350-5420-5582-5696-5726-6006-6020-6024-6098-6184-6568-6636-6802-6994-7004-7318-7498-7758-7780-7798-7920-7952-7960-7988-8232-8256-8390-8416-8478-8620-8840-8984-9038-9128-9236-9248-93
44-9594-9650-9714-9928-9938-10178-10368-10414-10502-10732-10876-11008-11158-11410-11722-11836-11964-12054-12096-12126-12136-12202-12246-12298-12616-12774-12782-12790-12802-12976-13216-13246-13502-13766-14454-14974-15004-15124-15252-15294-15356-15530-15610-16316-16936-17024-17122-17214-17310-17528-17682-17742-17870-17878-18010-18410-18524-18788 positions: 384576,8480,0,3444,250
- Entry 4: count: 1000 min: Darkness,-230-368-488-586-862-930-1686-2044-2636-2652-2872-3108-3162-3192-3404-3442-3508-3542-3550-3712-3980-4146-4204-4336-4390-4418-4424-4490-4512-4650-4768-4924-4950-5210-5524-5630-5678-5710-5758-5952-6238-6252-6300-6366-6668-6712-6926-6942-7100-7194-7802-8030-8452-8608-8640-8862-8868-9134-9234-9412-9602-9608-9642-9678-9740-9780-10426-10510-10514-10706-10814-10870-10942-11028-11244-11326-11462-11496-11656-11830-12022-12178-12418-12832-13304-13448-13590-13618-13908-14188-14246-14340-14364-14394-14762-14850-14964-15048-15494-15674-15726-16006-16056-16180-16304-16332-16452-16598-16730-16810-16994-17210-17268-17786-17962-18214-18444-18446-18724-18912-18952-19164 max: worst-54-290-346-648-908-996-1038-1080-1560-1584-1620-1744-1770-1798-1852-1966-2162-2244-2286-2296-2534-2660-3114-3676-3788-4068-4150-4706-4744-5350-5420-5582-5696-5726-6006-6020-6024-6098-6184-6568-6636-6802-6994-7004-7318-7498-7758-7780-7798-7920-7952-7960-7988-8232-8256-8390-8416-8478-8
620-8840-8984-9038-9128-9236-9248-9344-9594-9650-9714-9928-9938-10178-10368-10414-10502-10732-10876-11008-11158-11410-11722-11836-11964-12054-12096-12126-12136-12202-12246-12298-12616-12774-12782-12790-12802-12976-13216-13246-13502-13766-14454-14974-15004-15124-15252-15294-15356-15530-15610-16316-16936-17024-17122-17214-17310-17528-17682-17742-17870-17878-18010-18410-18524-18788-19204-19254-19518-19596-19786-19874-19904 positions: 530195,3058,0,4643,292
- Stripe: offset: 1753820 data: 177935 rows: 1000 tail: 67 index: 813
- Stream: column 0 section ROW_INDEX start: 1753820 length 10
- Stream: column 1 section ROW_INDEX start: 1753830 length 36
- Stream: column 2 section ROW_INDEX start: 1753866 length 39
- Stream: column 3 section ROW_INDEX start: 1753905 length 728
- Stream: column 1 section DATA start: 1754633 length 4007
- Stream: column 2 section DATA start: 1758640 length 8007
- Stream: column 3 section DATA start: 1766647 length 164661
- Stream: column 3 section LENGTH start: 1931308 length 1260
+ Entry 1: count: 1000 min: Darkness,-230-368-488-586-862-930-1686-2044-2636-2652-2872-3108-3162-3192-3404-3442-3508-3542-3550-3712-3980-4146-4204-4336-4390-4418-4424-4490-4512-4650-4768-4924-4950-5210-5524-5630-5678-5710-5758-5952-6238-6252-6300-6366-6668-6712-6926-6942-7100-7194-7802-8030-8452-8608-8640-8862-8868-9134-9234-9412-9602-9608-9642-9678-9740-9780-10426-10510-10514-10706-10814-10870-10942-11028-11244-11326-11462-11496-11656-11830-12022-12178-12418-12832-13304-13448-13590-13618-13908-14188-14246-14340-14364-14394-14762-14850-14964-15048-15494-15674-15726-16006 max: worst-54-290-346-648-908-996-1038-1080-1560-1584-1620-1744-1770-1798-1852-1966-2162-2244-2286-2296-2534-2660-3114-3676-3788-4068-4150-4706-4744-5350-5420-5582-5696-5726-6006-6020-6024-6098-6184-6568-6636-6802-6994-7004-7318-7498-7758-7780-7798-7920-7952-7960-7988-8232-8256-8390-8416-8478-8620-8840-8984-9038-9128-9236-9248-9344-9594-9650-9714-9928-9938-10178-10368-10414-10502-10732-10876-11008-11158-11410-11
722-11836-11964-12054-12096-12126-12136-12202-12246-12298-12616-12774-12782-12790-12802-12976-13216-13246-13502-13766-14454-14974-15004-15124-15252-15294-15356-15530-15610-16316-16936 positions: 126968,2916,0,1077,140
+ Entry 2: count: 1000 min: Darkness,-230-368-488-586-862-930-1686-2044-2636-2652-2872-3108-3162-3192-3404-3442-3508-3542-3550-3712-3980-4146-4204-4336-4390-4418-4424-4490-4512-4650-4768-4924-4950-5210-5524-5630-5678-5710-5758-5952-6238-6252-6300-6366-6668-6712-6926-6942-7100-7194-7802-8030-8452-8608-8640-8862-8868-9134-9234-9412-9602-9608-9642-9678-9740-9780-10426-10510-10514-10706-10814-10870-10942-11028-11244-11326-11462-11496-11656-11830-12022-12178-12418-12832-13304-13448-13590-13618-13908-14188-14246-14340-14364-14394-14762-14850-14964-15048-15494-15674-15726-16006-16056-16180-16304-16332-16452-16598-16730-16810-16994-17210 max: worst-54-290-346-648-908-996-1038-1080-1560-1584-1620-1744-1770-1798-1852-1966-2162-2244-2286-2296-2534-2660-3114-3676-3788-4068-4150-4706-4744-5350-5420-5582-5696-5726-6006-6020-6024-6098-6184-6568-6636-6802-6994-7004-7318-7498-7758-7780-7798-7920-7952-7960-7988-8232-8256-8390-8416-8478-8620-8840-8984-9038-9128-9236-9248-9344-9594-9650-9714-9928-9
938-10178-10368-10414-10502-10732-10876-11008-11158-11410-11722-11836-11964-12054-12096-12126-12136-12202-12246-12298-12616-12774-12782-12790-12802-12976-13216-13246-13502-13766-14454-14974-15004-15124-15252-15294-15356-15530-15610-16316-16936-17024-17122-17214-17310-17528-17682-17742-17870-17878 positions: 263111,206,0,1926,462
+ Entry 3: count: 1000 min: Darkness,-230-368-488-586-862-930-1686-2044-2636-2652-2872-3108-3162-3192-3404-3442-3508-3542-3550-3712-3980-4146-4204-4336-4390-4418-4424-4490-4512-4650-4768-4924-4950-5210-5524-5630-5678-5710-5758-5952-6238-6252-6300-6366-6668-6712-6926-6942-7100-7194-7802-8030-8452-8608-8640-8862-8868-9134-9234-9412-9602-9608-9642-9678-9740-9780-10426-10510-10514-10706-10814-10870-10942-11028-11244-11326-11462-11496-11656-11830-12022-12178-12418-12832-13304-13448-13590-13618-13908-14188-14246-14340-14364-14394-14762-14850-14964-15048-15494-15674-15726-16006-16056-16180-16304-16332-16452-16598-16730-16810-16994-17210-17268-17786-17962-18214 max: worst-54-290-346-648-908-996-1038-1080-1560-1584-1620-1744-1770-1798-1852-1966-2162-2244-2286-2296-2534-2660-3114-3676-3788-4068-4150-4706-4744-5350-5420-5582-5696-5726-6006-6020-6024-6098-6184-6568-6636-6802-6994-7004-7318-7498-7758-7780-7798-7920-7952-7960-7988-8232-8256-8390-8416-8478-8620-8840-8984-9038-9128-9236-9248-93
44-9594-9650-9714-9928-9938-10178-10368-10414-10502-10732-10876-11008-11158-11410-11722-11836-11964-12054-12096-12126-12136-12202-12246-12298-12616-12774-12782-12790-12802-12976-13216-13246-13502-13766-14454-14974-15004-15124-15252-15294-15356-15530-15610-16316-16936-17024-17122-17214-17310-17528-17682-17742-17870-17878-18010-18410-18524-18788 positions: 407371,8480,0,3444,250
+ Entry 4: count: 1000 min: Darkness,-230-368-488-586-862-930-1686-2044-2636-2652-2872-3108-3162-3192-3404-3442-3508-3542-3550-3712-3980-4146-4204-4336-4390-4418-4424-4490-4512-4650-4768-4924-4950-5210-5524-5630-5678-5710-5758-5952-6238-6252-6300-6366-6668-6712-6926-6942-7100-7194-7802-8030-8452-8608-8640-8862-8868-9134-9234-9412-9602-9608-9642-9678-9740-9780-10426-10510-10514-10706-10814-10870-10942-11028-11244-11326-11462-11496-11656-11830-12022-12178-12418-12832-13304-13448-13590-13618-13908-14188-14246-14340-14364-14394-14762-14850-14964-15048-15494-15674-15726-16006-16056-16180-16304-16332-16452-16598-16730-16810-16994-17210-17268-17786-17962-18214-18444-18446-18724-18912-18952-19164 max: worst-54-290-346-648-908-996-1038-1080-1560-1584-1620-1744-1770-1798-1852-1966-2162-2244-2286-2296-2534-2660-3114-3676-3788-4068-4150-4706-4744-5350-5420-5582-5696-5726-6006-6020-6024-6098-6184-6568-6636-6802-6994-7004-7318-7498-7758-7780-7798-7920-7952-7960-7988-8232-8256-8390-8416-8478-8
620-8840-8984-9038-9128-9236-9248-9344-9594-9650-9714-9928-9938-10178-10368-10414-10502-10732-10876-11008-11158-11410-11722-11836-11964-12054-12096-12126-12136-12202-12246-12298-12616-12774-12782-12790-12802-12976-13216-13246-13502-13766-14454-14974-15004-15124-15252-15294-15356-15530-15610-16316-16936-17024-17122-17214-17310-17528-17682-17742-17870-17878-18010-18410-18524-18788-19204-19254-19518-19596-19786-19874-19904 positions: 562094,3058,0,4643,292
+ Stripe: offset: 1842791 data: 188033 rows: 1000 tail: 67 index: 832
+ Stream: column 0 section ROW_INDEX start: 1842791 length 10
+ Stream: column 1 section ROW_INDEX start: 1842801 length 36
+ Stream: column 2 section ROW_INDEX start: 1842837 length 39
+ Stream: column 3 section ROW_INDEX start: 1842876 length 747
+ Stream: column 1 section DATA start: 1843623 length 4007
+ Stream: column 2 section DATA start: 1847630 length 8007
+ Stream: column 3 section DATA start: 1855637 length 174759
+ Stream: column 3 section LENGTH start: 2030396 length 1260
Encoding column 0: DIRECT
Encoding column 1: DIRECT_V2
Encoding column 2: DIRECT_V2
@@ -182,6 +182,6 @@ Stripes:
Row group index column 3:
Entry 0: count: 1000 min: Darkness,-230-368-488-586-862-930-1686-2044-2636-2652-2872-3108-3162-3192-3404-3442-3508-3542-3550-3712-3980-4146-4204-4336-4390-4418-4424-4490-4512-4650-4768-4924-4950-5210-5524-5630-5678-5710-5758-5952-6238-6252-6300-6366-6668-6712-6926-6942-7100-7194-7802-8030-8452-8608-8640-8862-8868-9134-9234-9412-9602-9608-9642-9678-9740-9780-10426-10510-10514-10706-10814-10870-10942-11028-11244-11326-11462-11496-11656-11830-12022-12178-12418-12832-13304-13448-13590-13618-13908-14188-14246-14340-14364-14394-14762-14850-14964-15048-15494-15674-15726-16006-16056-16180-16304-16332-16452-16598-16730-16810-16994-17210-17268-17786-17962-18214-18444-18446-18724-18912-18952-19164-19348-19400-19546-19776-19896-20084 max: worst-54-290-346-648-908-996-1038-1080-1560-1584-1620-1744-1770-1798-1852-1966-2162-2244-2286-2296-2534-2660-3114-3676-3788-4068-4150-4706-4744-5350-5420-5582-5696-5726-6006-6020-6024-6098-6184-6568-6636-6802-6994-7004-7318-7498-7758-7780-7798-7920-7952-
7960-7988-8232-8256-8390-8416-8478-8620-8840-8984-9038-9128-9236-9248-9344-9594-9650-9714-9928-9938-10178-10368-10414-10502-10732-10876-11008-11158-11410-11722-11836-11964-12054-12096-12126-12136-12202-12246-12298-12616-12774-12782-12790-12802-12976-13216-13246-13502-13766-14454-14974-15004-15124-15252-15294-15356-15530-15610-16316-16936-17024-17122-17214-17310-17528-17682-17742-17870-17878-18010-18410-18524-18788-19204-19254-19518-19596-19786-19874-19904-20390-20752-20936 positions: 0,0,0,0,0
-File length: 1934469 bytes
+File length: 2033559 bytes
Padding length: 0 bytes
Padding ratio: 0%
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=1624389&r1=1624388&r2=1624389&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 Thu Sep 11 21:02:09 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: 426
+ Stripe: offset: 3 data: 63766 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 170
- Stream: column 3 section ROW_INDEX start: 346 length 83
- Stream: column 1 section DATA start: 429 length 20029
- Stream: column 2 section DATA start: 20458 length 40035
- Stream: column 3 section DATA start: 60493 length 3544
- Stream: column 3 section LENGTH start: 64037 length 25
- Stream: column 3 section DICTIONARY_DATA start: 64062 length 133
+ 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
Encoding column 0: DIRECT
Encoding column 1: DIRECT_V2
Encoding column 2: DIRECT_V2
@@ -70,16 +70,16 @@ Stripes:
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: 64274 data: 63755 rows: 5000 tail: 79 index: 421
- Stream: column 0 section ROW_INDEX start: 64274 length 15
- Stream: column 1 section ROW_INDEX start: 64289 length 157
- Stream: column 2 section ROW_INDEX start: 64446 length 169
- Stream: column 3 section ROW_INDEX start: 64615 length 80
- Stream: column 1 section DATA start: 64695 length 20029
- Stream: column 2 section DATA start: 84724 length 40035
- Stream: column 3 section DATA start: 124759 length 3533
- Stream: column 3 section LENGTH start: 128292 length 25
- Stream: column 3 section DICTIONARY_DATA start: 128317 length 133
+ 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
Encoding column 0: DIRECT
Encoding column 1: DIRECT_V2
Encoding column 2: DIRECT_V2
@@ -102,16 +102,16 @@ Stripes:
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: 128529 data: 63766 rows: 5000 tail: 79 index: 421
- 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 84
- Stream: column 1 section DATA start: 128950 length 20029
- Stream: column 2 section DATA start: 148979 length 40035
- Stream: column 3 section DATA start: 189014 length 3544
- Stream: column 3 section LENGTH start: 192558 length 25
- Stream: column 3 section DICTIONARY_DATA start: 192583 length 133
+ 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
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: 192795 data: 63796 rows: 5000 tail: 79 index: 425
- Stream: column 0 section ROW_INDEX start: 192795 length 15
- Stream: column 1 section ROW_INDEX start: 192810 length 156
- Stream: column 2 section ROW_INDEX start: 192966 length 168
- Stream: column 3 section ROW_INDEX start: 193134 length 86
- Stream: column 1 section DATA start: 193220 length 20029
- Stream: column 2 section DATA start: 213249 length 40035
- Stream: column 3 section DATA start: 253284 length 3574
- Stream: column 3 section LENGTH start: 256858 length 25
- Stream: column 3 section DICTIONARY_DATA start: 256883 length 133
+ 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
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: 257095 data: 12940 rows: 1000 tail: 71 index: 123
- Stream: column 0 section ROW_INDEX start: 257095 length 10
- Stream: column 1 section ROW_INDEX start: 257105 length 36
- Stream: column 2 section ROW_INDEX start: 257141 length 39
- Stream: column 3 section ROW_INDEX start: 257180 length 38
- Stream: column 1 section DATA start: 257218 length 4007
- Stream: column 2 section DATA start: 261225 length 8007
- Stream: column 3 section DATA start: 269232 length 768
- Stream: column 3 section LENGTH start: 270000 length 25
- Stream: column 3 section DICTIONARY_DATA start: 270025 length 133
+ 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
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: 270756 bytes
+File length: 270759 bytes
Padding length: 0 bytes
Padding ratio: 0%
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/alter_merge_orc.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/alter_merge_orc.q.out?rev=1624389&r1=1624388&r2=1624389&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/alter_merge_orc.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/alter_merge_orc.q.out Thu Sep 11 21:02:09 2014
@@ -48,9 +48,9 @@ columns:struct columns { i32 key, string
partitioned:false
partitionColumns:
totalNumberFiles:3
-totalFileSize:7380
-maxFileSize:2460
-minFileSize:2460
+totalFileSize:7488
+maxFileSize:2496
+minFileSize:2496
#### A masked pattern was here ####
PREHOOK: query: select count(1) from src_orc_merge_test
@@ -91,9 +91,9 @@ columns:struct columns { i32 key, string
partitioned:false
partitionColumns:
totalNumberFiles:1
-totalFileSize:7059
-maxFileSize:7059
-minFileSize:7059
+totalFileSize:7167
+maxFileSize:7167
+minFileSize:7167
#### A masked pattern was here ####
PREHOOK: query: select count(1) from src_orc_merge_test
@@ -171,9 +171,9 @@ columns:struct columns { i32 key, string
partitioned:true
partitionColumns:struct partition_columns { string ds}
totalNumberFiles:3
-totalFileSize:7380
-maxFileSize:2460
-minFileSize:2460
+totalFileSize:7488
+maxFileSize:2496
+minFileSize:2496
#### A masked pattern was here ####
PREHOOK: query: select count(1) from src_orc_merge_test_part
@@ -218,9 +218,9 @@ columns:struct columns { i32 key, string
partitioned:true
partitionColumns:struct partition_columns { string ds}
totalNumberFiles:1
-totalFileSize:7059
-maxFileSize:7059
-minFileSize:7059
+totalFileSize:7167
+maxFileSize:7167
+minFileSize:7167
#### A masked pattern was here ####
PREHOOK: query: select count(1) from src_orc_merge_test_part
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/alter_merge_stats_orc.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/alter_merge_stats_orc.q.out?rev=1624389&r1=1624388&r2=1624389&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/alter_merge_stats_orc.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/alter_merge_stats_orc.q.out Thu Sep 11 21:02:09 2014
@@ -48,9 +48,9 @@ columns:struct columns { i32 key, string
partitioned:false
partitionColumns:
totalNumberFiles:3
-totalFileSize:7380
-maxFileSize:2460
-minFileSize:2460
+totalFileSize:7488
+maxFileSize:2496
+minFileSize:2496
#### A masked pattern was here ####
PREHOOK: query: desc extended src_orc_merge_test_stat
@@ -92,7 +92,7 @@ Table Parameters:
numFiles 3
numRows 1500
rawDataSize 141000
- totalSize 7380
+ totalSize 7488
#### A masked pattern was here ####
# Storage Information
@@ -142,7 +142,7 @@ Table Parameters:
numFiles 1
numRows 1500
rawDataSize 141000
- totalSize 7059
+ totalSize 7167
#### A masked pattern was here ####
# Storage Information
@@ -212,9 +212,9 @@ columns:struct columns { i32 key, string
partitioned:true
partitionColumns:struct partition_columns { string ds}
totalNumberFiles:3
-totalFileSize:7380
-maxFileSize:2460
-minFileSize:2460
+totalFileSize:7488
+maxFileSize:2496
+minFileSize:2496
#### A masked pattern was here ####
PREHOOK: query: desc formatted src_orc_merge_test_part_stat partition (ds='2011')
@@ -245,7 +245,7 @@ Partition Parameters:
numFiles 3
numRows 500
rawDataSize 47000
- totalSize 7380
+ totalSize 7488
#### A masked pattern was here ####
# Storage Information
@@ -294,7 +294,7 @@ Partition Parameters:
numFiles 3
numRows 1500
rawDataSize 141000
- totalSize 7380
+ totalSize 7488
#### A masked pattern was here ####
# Storage Information
@@ -351,7 +351,7 @@ Partition Parameters:
numFiles 1
numRows 1500
rawDataSize 141000
- totalSize 7059
+ totalSize 7167
#### A masked pattern was here ####
# Storage Information
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/groupby1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/groupby1.q.out?rev=1624389&r1=1624388&r2=1624389&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/groupby1.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/groupby1.q.out Thu Sep 11 21:02:09 2014
@@ -1,8 +1,12 @@
-PREHOOK: query: CREATE TABLE dest_g1(key INT, value DOUBLE) STORED AS TEXTFILE
+PREHOOK: query: -- SORT_QUERY_RESULTS
+
+CREATE TABLE dest_g1(key INT, value DOUBLE) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@dest_g1
-POSTHOOK: query: CREATE TABLE dest_g1(key INT, value DOUBLE) STORED AS TEXTFILE
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+
+CREATE TABLE dest_g1(key INT, value DOUBLE) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@dest_g1
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/groupby4.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/groupby4.q.out?rev=1624389&r1=1624388&r2=1624389&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/groupby4.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/groupby4.q.out Thu Sep 11 21:02:09 2014
@@ -1,8 +1,12 @@
-PREHOOK: query: CREATE TABLE dest1(c1 STRING) STORED AS TEXTFILE
+PREHOOK: query: -- SORT_QUERY_RESULTS
+
+CREATE TABLE dest1(c1 STRING) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@dest1
-POSTHOOK: query: CREATE TABLE dest1(c1 STRING) STORED AS TEXTFILE
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+
+CREATE TABLE dest1(c1 STRING) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@dest1
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/having.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/having.q.out?rev=1624389&r1=1624388&r2=1624389&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/having.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/having.q.out Thu Sep 11 21:02:09 2014
@@ -1,6 +1,8 @@
-PREHOOK: query: EXPLAIN SELECT count(value) AS c FROM src GROUP BY key HAVING c > 3
+PREHOOK: query: -- SORT_QUERY_RESULTS
+EXPLAIN SELECT count(value) AS c FROM src GROUP BY key HAVING c > 3
PREHOOK: type: QUERY
-POSTHOOK: query: EXPLAIN SELECT count(value) AS c FROM src GROUP BY key HAVING c > 3
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+EXPLAIN SELECT count(value) AS c FROM src GROUP BY key HAVING c > 3
POSTHOOK: type: QUERY
STAGE DEPENDENCIES:
Stage-1 is a root stage
@@ -67,14 +69,14 @@ POSTHOOK: Input: default@src
#### A masked pattern was here ####
4
4
-5
4
-5
-5
4
4
-5
4
+5
+5
+5
+5
PREHOOK: query: EXPLAIN SELECT key, max(value) AS c FROM src GROUP BY key HAVING key != 302
PREHOOK: type: QUERY
POSTHOOK: query: EXPLAIN SELECT key, max(value) AS c FROM src GROUP BY key HAVING key != 302
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/limit_pushdown.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/limit_pushdown.q.out?rev=1624389&r1=1624388&r2=1624389&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/limit_pushdown.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/limit_pushdown.q.out Thu Sep 11 21:02:09 2014
@@ -1,9 +1,13 @@
-PREHOOK: query: -- HIVE-3562 Some limit can be pushed down to map stage
+PREHOOK: query: -- SORT_QUERY_RESULTS
+
+-- HIVE-3562 Some limit can be pushed down to map stage
explain
select key,value from src order by key limit 20
PREHOOK: type: QUERY
-POSTHOOK: query: -- HIVE-3562 Some limit can be pushed down to map stage
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+
+-- HIVE-3562 Some limit can be pushed down to map stage
explain
select key,value from src order by key limit 20
@@ -136,26 +140,26 @@ POSTHOOK: query: select key,value from s
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
-98 val_98
-98 val_98
-97 val_97
-97 val_97
-96 val_96
-95 val_95
-95 val_95
-92 val_92
+82 val_82
+83 val_83
+83 val_83
+84 val_84
+84 val_84
+85 val_85
+86 val_86
+87 val_87
+9 val_9
90 val_90
90 val_90
90 val_90
-9 val_9
-87 val_87
-86 val_86
-85 val_85
-84 val_84
-84 val_84
-83 val_83
-83 val_83
-82 val_82
+92 val_92
+95 val_95
+95 val_95
+96 val_96
+97 val_97
+97 val_97
+98 val_98
+98 val_98
PREHOOK: query: explain
select value, sum(key + 1) as sum from src group by value limit 20
PREHOOK: type: QUERY
@@ -407,26 +411,26 @@ POSTHOOK: query: select distinct(cdouble
POSTHOOK: type: QUERY
POSTHOOK: Input: default@alltypesorc
#### A masked pattern was here ####
-NULL
--16379.0
--16373.0
--16372.0
--16369.0
--16355.0
--16339.0
--16324.0
--16311.0
--16310.0
--16309.0
--16307.0
--16306.0
--16305.0
--16300.0
--16296.0
--16280.0
--16277.0
--16274.0
-16269.0
+-16274.0
+-16277.0
+-16280.0
+-16296.0
+-16300.0
+-16305.0
+-16306.0
+-16307.0
+-16309.0
+-16310.0
+-16311.0
+-16324.0
+-16339.0
+-16355.0
+-16369.0
+-16372.0
+-16373.0
+-16379.0
+NULL
PREHOOK: query: explain
select ctinyint, count(distinct(cdouble)) from alltypesorc group by ctinyint limit 20
PREHOOK: type: QUERY
@@ -496,26 +500,26 @@ POSTHOOK: query: select ctinyint, count(
POSTHOOK: type: QUERY
POSTHOOK: Input: default@alltypesorc
#### A masked pattern was here ####
-NULL 2932
--64 24
--63 19
--62 27
--61 25
--60 27
--59 31
--58 23
--57 35
--56 36
--55 29
--54 26
--53 22
--52 33
--51 21
--50 30
--49 26
--48 29
--47 22
-46 24
+-47 22
+-48 29
+-49 26
+-50 30
+-51 21
+-52 33
+-53 22
+-54 26
+-55 29
+-56 36
+-57 35
+-58 23
+-59 31
+-60 27
+-61 25
+-62 27
+-63 19
+-64 24
+NULL 2932
PREHOOK: query: -- multi distinct
explain
select ctinyint, count(distinct(cstring1)), count(distinct(cstring2)) from alltypesorc group by ctinyint limit 20
@@ -587,26 +591,26 @@ POSTHOOK: query: select ctinyint, count(
POSTHOOK: type: QUERY
POSTHOOK: Input: default@alltypesorc
#### A masked pattern was here ####
-NULL 3065 3
--64 3 13
--63 3 16
--62 3 23
--61 3 25
--60 3 25
--59 3 27
--58 3 24
--57 3 23
--56 3 22
--55 3 21
--54 3 21
--53 3 17
--52 3 21
--51 1012 1045
--50 3 25
--49 3 24
--48 3 27
--47 3 23
-46 3 19
+-47 3 23
+-48 3 27
+-49 3 24
+-50 3 25
+-51 1012 1045
+-52 3 21
+-53 3 17
+-54 3 21
+-55 3 21
+-56 3 22
+-57 3 23
+-58 3 24
+-59 3 27
+-60 3 25
+-61 3 25
+-62 3 23
+-63 3 16
+-64 3 13
+NULL 3065 3
PREHOOK: query: -- limit zero
explain
select key,value from src order by key limit 0
@@ -726,25 +730,25 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
val_0 0.0
-val_2 2.0
-val_4 4.0
-val_8 8.0
-val_9 9.0
val_10 10.0
val_11 11.0
-val_5 15.0
+val_12 24.0
+val_15 30.0
val_17 17.0
+val_18 36.0
val_19 19.0
+val_2 2.0
val_20 20.0
-val_12 24.0
val_27 27.0
val_28 28.0
val_30 30.0
-val_15 30.0
val_33 33.0
val_34 34.0
-val_18 36.0
+val_4 4.0
val_41 41.0
+val_5 15.0
+val_8 8.0
+val_9 9.0
PREHOOK: query: -- subqueries
explain
select * from
@@ -1246,102 +1250,102 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
0.0
-200.0
-206.0
-208.0
-105.0
10.0
+105.0
+11.0
111.0
-226.0
114.0
+1150.0
116.0
-236.0
-357.0
-11.0
-240.0
-250.0
126.0
-384.0
-258.0
-24.0
131.0
133.0
-268.0
136.0
-274.0
-552.0
143.0
145.0
-292.0
-298.0
150.0
-304.0
153.0
155.0
156.0
157.0
158.0
-30.0
160.0
162.0
163.0
-328.0
-330.0
166.0
-501.0
168.0
-676.0
+17.0
170.0
-344.0
-348.0
-350.0
-352.0
177.0
178.0
-358.0
-17.0
180.0
181.0
183.0
186.0
-561.0
189.0
-36.0
+19.0
190.0
-382.0
192.0
-579.0
194.0
-390.0
196.0
-394.0
-597.0
-19.0
-400.0
+20.0
+200.0
201.0
202.0
+206.0
+208.0
+214.0
+218.0
+222.0
+226.0
+226.0
+228.0
+235.0
+236.0
+24.0
+240.0
+250.0
+258.0
+268.0
+274.0
+292.0
+298.0
+30.0
+304.0
+328.0
+330.0
+344.0
+348.0
+350.0
+352.0
+357.0
+358.0
+36.0
+382.0
+384.0
+390.0
+394.0
+400.0
406.0
410.0
414.0
-624.0
418.0
-20.0
426.0
-214.0
432.0
434.0
-218.0
438.0
442.0
-222.0
446.0
448.0
-226.0
-228.0
458.0
-1150.0
466.0
-235.0
474.0
476.0
478.0
+501.0
+552.0
+561.0
+579.0
+597.0
+624.0
+676.0
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/merge1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/merge1.q.out?rev=1624389&r1=1624388&r2=1624389&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/merge1.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/merge1.q.out Thu Sep 11 21:02:09 2014
@@ -1,8 +1,12 @@
-PREHOOK: query: create table dest1(key int, val int)
+PREHOOK: query: -- SORT_QUERY_RESULTS
+
+create table dest1(key int, val int)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@dest1
-POSTHOOK: query: create table dest1(key int, val int)
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+
+create table dest1(key int, val int)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@dest1
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/merge2.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/merge2.q.out?rev=1624389&r1=1624388&r2=1624389&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/merge2.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/merge2.q.out Thu Sep 11 21:02:09 2014
@@ -1,8 +1,12 @@
-PREHOOK: query: create table test1(key int, val int)
+PREHOOK: query: -- SORT_QUERY_RESULTS
+
+create table test1(key int, val int)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@test1
-POSTHOOK: query: create table test1(key int, val int)
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+
+create table test1(key int, val int)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@test1
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=1624389&r1=1624388&r2=1624389&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 Thu Sep 11 21:02:09 2014
@@ -105,7 +105,7 @@ Table Parameters:
numFiles 1
numRows 100
rawDataSize 52600
- totalSize 3098
+ totalSize 3123
#### A masked pattern was here ####
# Storage Information
@@ -195,7 +195,7 @@ Table Parameters:
numFiles 1
numRows 100
rawDataSize 52600
- totalSize 3098
+ totalSize 3123
#### A masked pattern was here ####
# Storage Information
@@ -309,7 +309,7 @@ Partition Parameters:
numFiles 1
numRows 50
rawDataSize 21950
- totalSize 2016
+ totalSize 2024
#### A masked pattern was here ####
# Storage Information
@@ -354,7 +354,7 @@ Partition Parameters:
numFiles 1
numRows 50
rawDataSize 22050
- totalSize 2036
+ totalSize 2043
#### A masked pattern was here ####
# Storage Information
@@ -456,7 +456,7 @@ Partition Parameters:
numFiles 1
numRows 50
rawDataSize 21950
- totalSize 2016
+ totalSize 2024
#### A masked pattern was here ####
# Storage Information
@@ -501,7 +501,7 @@ Partition Parameters:
numFiles 1
numRows 50
rawDataSize 22050
- totalSize 2036
+ totalSize 2043
#### A masked pattern was here ####
# Storage Information
@@ -621,7 +621,7 @@ Partition Parameters:
numFiles 4
numRows 50
rawDataSize 21980
- totalSize 4955
+ totalSize 4963
#### A masked pattern was here ####
# Storage Information
@@ -666,7 +666,7 @@ Partition Parameters:
numFiles 4
numRows 50
rawDataSize 22048
- totalSize 5046
+ totalSize 5051
#### A masked pattern was here ####
# Storage Information
@@ -774,7 +774,7 @@ Partition Parameters:
numFiles 4
numRows 50
rawDataSize 21980
- totalSize 4955
+ totalSize 4963
#### A masked pattern was here ####
# Storage Information
@@ -819,7 +819,7 @@ Partition Parameters:
numFiles 4
numRows 50
rawDataSize 22048
- totalSize 5046
+ totalSize 5051
#### A masked pattern was here ####
# Storage Information
@@ -984,7 +984,7 @@ Partition Parameters:
numFiles 1
numRows 50
rawDataSize 21950
- totalSize 2016
+ totalSize 2024
#### A masked pattern was here ####
# Storage Information
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/orc_merge3.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/orc_merge3.q.out?rev=1624389&r1=1624388&r2=1624389&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/orc_merge3.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/orc_merge3.q.out Thu Sep 11 21:02:09 2014
@@ -161,7 +161,7 @@ Table Parameters:
numFiles 1
numRows 1000
rawDataSize 94000
- totalSize 4762
+ totalSize 4834
#### A masked pattern was here ####
# Storage Information
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/orc_merge4.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/orc_merge4.q.out?rev=1624389&r1=1624388&r2=1624389&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/orc_merge4.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/orc_merge4.q.out Thu Sep 11 21:02:09 2014
@@ -64,7 +64,7 @@ Partition Parameters:
numFiles 1
numRows 500
rawDataSize 47000
- totalSize 2460
+ totalSize 2496
#### A masked pattern was here ####
# Storage Information
@@ -129,7 +129,7 @@ Partition Parameters:
numFiles 1
numRows 500
rawDataSize 47000
- totalSize 2460
+ totalSize 2496
#### A masked pattern was here ####
# Storage Information
@@ -170,7 +170,7 @@ Partition Parameters:
numFiles 1
numRows 500
rawDataSize 47000
- totalSize 2460
+ totalSize 2496
#### A masked pattern was here ####
# Storage Information
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/tez/alter_merge_orc.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/tez/alter_merge_orc.q.out?rev=1624389&r1=1624388&r2=1624389&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/tez/alter_merge_orc.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/tez/alter_merge_orc.q.out Thu Sep 11 21:02:09 2014
@@ -48,9 +48,9 @@ columns:struct columns { i32 key, string
partitioned:false
partitionColumns:
totalNumberFiles:3
-totalFileSize:7380
-maxFileSize:2460
-minFileSize:2460
+totalFileSize:7488
+maxFileSize:2496
+minFileSize:2496
#### A masked pattern was here ####
PREHOOK: query: select count(1) from src_orc_merge_test
@@ -91,9 +91,9 @@ columns:struct columns { i32 key, string
partitioned:false
partitionColumns:
totalNumberFiles:1
-totalFileSize:7059
-maxFileSize:7059
-minFileSize:7059
+totalFileSize:7167
+maxFileSize:7167
+minFileSize:7167
#### A masked pattern was here ####
PREHOOK: query: select count(1) from src_orc_merge_test
@@ -171,9 +171,9 @@ columns:struct columns { i32 key, string
partitioned:true
partitionColumns:struct partition_columns { string ds}
totalNumberFiles:3
-totalFileSize:7380
-maxFileSize:2460
-minFileSize:2460
+totalFileSize:7488
+maxFileSize:2496
+minFileSize:2496
#### A masked pattern was here ####
PREHOOK: query: select count(1) from src_orc_merge_test_part
@@ -218,9 +218,9 @@ columns:struct columns { i32 key, string
partitioned:true
partitionColumns:struct partition_columns { string ds}
totalNumberFiles:1
-totalFileSize:7059
-maxFileSize:7059
-minFileSize:7059
+totalFileSize:7167
+maxFileSize:7167
+minFileSize:7167
#### A masked pattern was here ####
PREHOOK: query: select count(1) from src_orc_merge_test_part
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/tez/alter_merge_stats_orc.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/tez/alter_merge_stats_orc.q.out?rev=1624389&r1=1624388&r2=1624389&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/tez/alter_merge_stats_orc.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/tez/alter_merge_stats_orc.q.out Thu Sep 11 21:02:09 2014
@@ -48,9 +48,9 @@ columns:struct columns { i32 key, string
partitioned:false
partitionColumns:
totalNumberFiles:3
-totalFileSize:7380
-maxFileSize:2460
-minFileSize:2460
+totalFileSize:7488
+maxFileSize:2496
+minFileSize:2496
#### A masked pattern was here ####
PREHOOK: query: desc extended src_orc_merge_test_stat
@@ -92,7 +92,7 @@ Table Parameters:
numFiles 3
numRows 1500
rawDataSize 141000
- totalSize 7380
+ totalSize 7488
#### A masked pattern was here ####
# Storage Information
@@ -142,7 +142,7 @@ Table Parameters:
numFiles 1
numRows 1500
rawDataSize 141000
- totalSize 7059
+ totalSize 7167
#### A masked pattern was here ####
# Storage Information
@@ -212,9 +212,9 @@ columns:struct columns { i32 key, string
partitioned:true
partitionColumns:struct partition_columns { string ds}
totalNumberFiles:3
-totalFileSize:7380
-maxFileSize:2460
-minFileSize:2460
+totalFileSize:7488
+maxFileSize:2496
+minFileSize:2496
#### A masked pattern was here ####
PREHOOK: query: desc formatted src_orc_merge_test_part_stat partition (ds='2011')
@@ -245,7 +245,7 @@ Partition Parameters:
numFiles 3
numRows 500
rawDataSize 47000
- totalSize 7380
+ totalSize 7488
#### A masked pattern was here ####
# Storage Information
@@ -294,7 +294,7 @@ Partition Parameters:
numFiles 3
numRows 1500
rawDataSize 141000
- totalSize 7380
+ totalSize 7488
#### A masked pattern was here ####
# Storage Information
@@ -351,7 +351,7 @@ Partition Parameters:
numFiles 1
numRows 1500
rawDataSize 141000
- totalSize 7059
+ totalSize 7167
#### A masked pattern was here ####
# Storage Information
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/tez/dynamic_partition_pruning_2.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/tez/dynamic_partition_pruning_2.q.out?rev=1624389&r1=1624388&r2=1624389&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/tez/dynamic_partition_pruning_2.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/tez/dynamic_partition_pruning_2.q.out Thu Sep 11 21:02:09 2014
@@ -267,3 +267,176 @@ POSTHOOK: Input: default@dim_shops
#### A masked pattern was here ####
bar 3 15
foo 3 6
+PREHOOK: query: EXPLAIN
+SELECT amount FROM agg_01, dim_shops WHERE dim_shops_id = id AND label = 'foo'
+UNION ALL
+SELECT amount FROM agg_01, dim_shops WHERE dim_shops_id = id AND label = 'bar'
+PREHOOK: type: QUERY
+POSTHOOK: query: EXPLAIN
+SELECT amount FROM agg_01, dim_shops WHERE dim_shops_id = id AND label = 'foo'
+UNION ALL
+SELECT amount FROM agg_01, dim_shops WHERE dim_shops_id = id AND label = 'bar'
+POSTHOOK: type: QUERY
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 depends on stages: Stage-1
+
+STAGE PLANS:
+ Stage: Stage-1
+ Tez
+ Edges:
+ Map 3 <- Map 1 (BROADCAST_EDGE), Union 4 (CONTAINS)
+ Map 5 <- Map 2 (BROADCAST_EDGE), Union 4 (CONTAINS)
+#### A masked pattern was here ####
+ Vertices:
+ Map 1
+ Map Operator Tree:
+ TableScan
+ alias: dim_shops
+ filterExpr: (id is not null and (label = 'bar')) (type: boolean)
+ Statistics: Num rows: 2 Data size: 18 Basic stats: COMPLETE Column stats: NONE
+ Filter Operator
+ predicate: (id is not null and (label = 'bar')) (type: boolean)
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+ Reduce Output Operator
+ key expressions: id (type: int)
+ sort order: +
+ Map-reduce partition columns: id (type: int)
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+ Select Operator
+ expressions: id (type: int)
+ outputColumnNames: _col0
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+ Group By Operator
+ keys: _col0 (type: int)
+ mode: hash
+ outputColumnNames: _col0
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+ Dynamic Partitioning Event Operator
+ Target Input: agg_01
+ Partition key expr: dim_shops_id
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+ Target column: dim_shops_id
+ Target Vertex: Map 3
+ Map 2
+ Map Operator Tree:
+ TableScan
+ alias: dim_shops
+ filterExpr: (id is not null and (label = 'foo')) (type: boolean)
+ Statistics: Num rows: 2 Data size: 18 Basic stats: COMPLETE Column stats: NONE
+ Filter Operator
+ predicate: (id is not null and (label = 'foo')) (type: boolean)
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+ Reduce Output Operator
+ key expressions: id (type: int)
+ sort order: +
+ Map-reduce partition columns: id (type: int)
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+ Select Operator
+ expressions: id (type: int)
+ outputColumnNames: _col0
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+ Group By Operator
+ keys: _col0 (type: int)
+ mode: hash
+ outputColumnNames: _col0
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+ Dynamic Partitioning Event Operator
+ Target Input: agg_01
+ Partition key expr: dim_shops_id
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+ Target column: dim_shops_id
+ Target Vertex: Map 5
+ Map 3
+ Map Operator Tree:
+ TableScan
+ alias: agg_01
+ filterExpr: dim_shops_id is not null (type: boolean)
+ Map Join Operator
+ condition map:
+ Inner Join 0 to 1
+ condition expressions:
+ 0 {amount} {dim_shops_id}
+ 1 {id}
+ keys:
+ 0 dim_shops_id (type: int)
+ 1 id (type: int)
+ outputColumnNames: _col0, _col1, _col5
+ Filter Operator
+ predicate: (_col1 = _col5) (type: boolean)
+ Select Operator
+ expressions: _col0 (type: decimal(10,0))
+ outputColumnNames: _col0
+ Select Operator
+ expressions: _col0 (type: decimal(10,0))
+ outputColumnNames: _col0
+ File Output Operator
+ compressed: false
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ Map 5
+ Map Operator Tree:
+ TableScan
+ alias: agg_01
+ filterExpr: dim_shops_id is not null (type: boolean)
+ Map Join Operator
+ condition map:
+ Inner Join 0 to 1
+ condition expressions:
+ 0 {amount} {dim_shops_id}
+ 1 {id}
+ keys:
+ 0 dim_shops_id (type: int)
+ 1 id (type: int)
+ outputColumnNames: _col0, _col1, _col5
+ Filter Operator
+ predicate: (_col1 = _col5) (type: boolean)
+ Select Operator
+ expressions: _col0 (type: decimal(10,0))
+ outputColumnNames: _col0
+ Select Operator
+ expressions: _col0 (type: decimal(10,0))
+ outputColumnNames: _col0
+ File Output Operator
+ compressed: false
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ Union 4
+ Vertex: Union 4
+
+ Stage: Stage-0
+ Fetch Operator
+ limit: -1
+ Processor Tree:
+ ListSink
+
+PREHOOK: query: SELECT amount FROM agg_01, dim_shops WHERE dim_shops_id = id AND label = 'foo'
+UNION ALL
+SELECT amount FROM agg_01, dim_shops WHERE dim_shops_id = id AND label = 'bar'
+PREHOOK: type: QUERY
+PREHOOK: Input: default@agg_01
+PREHOOK: Input: default@agg_01@dim_shops_id=1
+PREHOOK: Input: default@agg_01@dim_shops_id=2
+PREHOOK: Input: default@agg_01@dim_shops_id=3
+PREHOOK: Input: default@dim_shops
+#### A masked pattern was here ####
+POSTHOOK: query: SELECT amount FROM agg_01, dim_shops WHERE dim_shops_id = id AND label = 'foo'
+UNION ALL
+SELECT amount FROM agg_01, dim_shops WHERE dim_shops_id = id AND label = 'bar'
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@agg_01
+POSTHOOK: Input: default@agg_01@dim_shops_id=1
+POSTHOOK: Input: default@agg_01@dim_shops_id=2
+POSTHOOK: Input: default@agg_01@dim_shops_id=3
+POSTHOOK: Input: default@dim_shops
+#### A masked pattern was here ####
+4
+5
+6
+1
+2
+3
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/tez/groupby1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/tez/groupby1.q.out?rev=1624389&r1=1624388&r2=1624389&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/tez/groupby1.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/tez/groupby1.q.out Thu Sep 11 21:02:09 2014
@@ -1,8 +1,12 @@
-PREHOOK: query: CREATE TABLE dest_g1(key INT, value DOUBLE) STORED AS TEXTFILE
+PREHOOK: query: -- SORT_QUERY_RESULTS
+
+CREATE TABLE dest_g1(key INT, value DOUBLE) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@dest_g1
-POSTHOOK: query: CREATE TABLE dest_g1(key INT, value DOUBLE) STORED AS TEXTFILE
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+
+CREATE TABLE dest_g1(key INT, value DOUBLE) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@dest_g1
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/tez/having.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/tez/having.q.out?rev=1624389&r1=1624388&r2=1624389&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/tez/having.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/tez/having.q.out Thu Sep 11 21:02:09 2014
@@ -1,6 +1,8 @@
-PREHOOK: query: EXPLAIN SELECT count(value) AS c FROM src GROUP BY key HAVING c > 3
+PREHOOK: query: -- SORT_QUERY_RESULTS
+EXPLAIN SELECT count(value) AS c FROM src GROUP BY key HAVING c > 3
PREHOOK: type: QUERY
-POSTHOOK: query: EXPLAIN SELECT count(value) AS c FROM src GROUP BY key HAVING c > 3
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+EXPLAIN SELECT count(value) AS c FROM src GROUP BY key HAVING c > 3
POSTHOOK: type: QUERY
STAGE DEPENDENCIES:
Stage-1 is a root stage
@@ -73,14 +75,14 @@ POSTHOOK: Input: default@src
#### A masked pattern was here ####
4
4
-5
4
-5
-5
4
4
-5
4
+5
+5
+5
+5
PREHOOK: query: EXPLAIN SELECT key, max(value) AS c FROM src GROUP BY key HAVING key != 302
PREHOOK: type: QUERY
POSTHOOK: query: EXPLAIN SELECT key, max(value) AS c FROM src GROUP BY key HAVING key != 302
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/tez/limit_pushdown.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/tez/limit_pushdown.q.out?rev=1624389&r1=1624388&r2=1624389&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/tez/limit_pushdown.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/tez/limit_pushdown.q.out Thu Sep 11 21:02:09 2014
@@ -1,9 +1,13 @@
-PREHOOK: query: -- HIVE-3562 Some limit can be pushed down to map stage
+PREHOOK: query: -- SORT_QUERY_RESULTS
+
+-- HIVE-3562 Some limit can be pushed down to map stage
explain
select key,value from src order by key limit 20
PREHOOK: type: QUERY
-POSTHOOK: query: -- HIVE-3562 Some limit can be pushed down to map stage
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+
+-- HIVE-3562 Some limit can be pushed down to map stage
explain
select key,value from src order by key limit 20
@@ -148,26 +152,26 @@ POSTHOOK: query: select key,value from s
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
-98 val_98
-98 val_98
-97 val_97
-97 val_97
-96 val_96
-95 val_95
-95 val_95
-92 val_92
+82 val_82
+83 val_83
+83 val_83
+84 val_84
+84 val_84
+85 val_85
+86 val_86
+87 val_87
+9 val_9
90 val_90
90 val_90
90 val_90
-9 val_9
-87 val_87
-86 val_86
-85 val_85
-84 val_84
-84 val_84
-83 val_83
-83 val_83
-82 val_82
+92 val_92
+95 val_95
+95 val_95
+96 val_96
+97 val_97
+97 val_97
+98 val_98
+98 val_98
PREHOOK: query: explain
select value, sum(key + 1) as sum from src group by value limit 20
PREHOOK: type: QUERY
@@ -437,26 +441,26 @@ POSTHOOK: query: select distinct(cdouble
POSTHOOK: type: QUERY
POSTHOOK: Input: default@alltypesorc
#### A masked pattern was here ####
-NULL
--16379.0
--16373.0
--16372.0
--16369.0
--16355.0
--16339.0
--16324.0
--16311.0
--16310.0
--16309.0
--16307.0
--16306.0
--16305.0
--16300.0
--16296.0
--16280.0
--16277.0
--16274.0
-16269.0
+-16274.0
+-16277.0
+-16280.0
+-16296.0
+-16300.0
+-16305.0
+-16306.0
+-16307.0
+-16309.0
+-16310.0
+-16311.0
+-16324.0
+-16339.0
+-16355.0
+-16369.0
+-16372.0
+-16373.0
+-16379.0
+NULL
PREHOOK: query: explain
select ctinyint, count(distinct(cdouble)) from alltypesorc group by ctinyint limit 20
PREHOOK: type: QUERY
@@ -532,26 +536,26 @@ POSTHOOK: query: select ctinyint, count(
POSTHOOK: type: QUERY
POSTHOOK: Input: default@alltypesorc
#### A masked pattern was here ####
-NULL 2932
--64 24
--63 19
--62 27
--61 25
--60 27
--59 31
--58 23
--57 35
--56 36
--55 29
--54 26
--53 22
--52 33
--51 21
--50 30
--49 26
--48 29
--47 22
-46 24
+-47 22
+-48 29
+-49 26
+-50 30
+-51 21
+-52 33
+-53 22
+-54 26
+-55 29
+-56 36
+-57 35
+-58 23
+-59 31
+-60 27
+-61 25
+-62 27
+-63 19
+-64 24
+NULL 2932
PREHOOK: query: -- multi distinct
explain
select ctinyint, count(distinct(cstring1)), count(distinct(cstring2)) from alltypesorc group by ctinyint limit 20
@@ -629,26 +633,26 @@ POSTHOOK: query: select ctinyint, count(
POSTHOOK: type: QUERY
POSTHOOK: Input: default@alltypesorc
#### A masked pattern was here ####
-NULL 3065 3
--64 3 13
--63 3 16
--62 3 23
--61 3 25
--60 3 25
--59 3 27
--58 3 24
--57 3 23
--56 3 22
--55 3 21
--54 3 21
--53 3 17
--52 3 21
--51 1012 1045
--50 3 25
--49 3 24
--48 3 27
--47 3 23
-46 3 19
+-47 3 23
+-48 3 27
+-49 3 24
+-50 3 25
+-51 1012 1045
+-52 3 21
+-53 3 17
+-54 3 21
+-55 3 21
+-56 3 22
+-57 3 23
+-58 3 24
+-59 3 27
+-60 3 25
+-61 3 25
+-62 3 23
+-63 3 16
+-64 3 13
+NULL 3065 3
PREHOOK: query: -- limit zero
explain
select key,value from src order by key limit 0
@@ -764,25 +768,25 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
val_0 0.0
-val_2 2.0
-val_4 4.0
-val_8 8.0
-val_9 9.0
val_10 10.0
val_11 11.0
-val_5 15.0
+val_12 24.0
+val_15 30.0
val_17 17.0
+val_18 36.0
val_19 19.0
+val_2 2.0
val_20 20.0
-val_12 24.0
val_27 27.0
val_28 28.0
val_30 30.0
-val_15 30.0
val_33 33.0
val_34 34.0
-val_18 36.0
+val_4 4.0
val_41 41.0
+val_5 15.0
+val_8 8.0
+val_9 9.0
PREHOOK: query: -- subqueries
explain
select * from
@@ -1280,102 +1284,102 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
0.0
-200.0
-206.0
-208.0
-105.0
10.0
+105.0
+11.0
111.0
-226.0
114.0
+1150.0
116.0
-236.0
-357.0
-11.0
-240.0
-250.0
126.0
-384.0
-258.0
-24.0
131.0
133.0
-268.0
136.0
-274.0
-552.0
143.0
145.0
-292.0
-298.0
150.0
-304.0
153.0
155.0
156.0
157.0
158.0
-30.0
160.0
162.0
163.0
-328.0
-330.0
166.0
-501.0
168.0
-676.0
+17.0
170.0
-344.0
-348.0
-350.0
-352.0
177.0
178.0
-358.0
-17.0
180.0
181.0
183.0
186.0
-561.0
189.0
-36.0
+19.0
190.0
-382.0
192.0
-579.0
194.0
-390.0
196.0
-394.0
-597.0
-19.0
-400.0
+20.0
+200.0
201.0
202.0
+206.0
+208.0
+214.0
+218.0
+222.0
+226.0
+226.0
+228.0
+235.0
+236.0
+24.0
+240.0
+250.0
+258.0
+268.0
+274.0
+292.0
+298.0
+30.0
+304.0
+328.0
+330.0
+344.0
+348.0
+350.0
+352.0
+357.0
+358.0
+36.0
+382.0
+384.0
+390.0
+394.0
+400.0
406.0
410.0
414.0
-624.0
418.0
-20.0
426.0
-214.0
432.0
434.0
-218.0
438.0
442.0
-222.0
446.0
448.0
-226.0
-228.0
458.0
-1150.0
466.0
-235.0
474.0
476.0
478.0
+501.0
+552.0
+561.0
+579.0
+597.0
+624.0
+676.0