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
