[
https://issues.apache.org/jira/browse/DRILL-1156?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jacques Nadeau resolved DRILL-1156.
-----------------------------------
Resolution: Duplicate
Assignee: Chun Chang
This duplicates DRILL-1062. Please copy information and test case to that bug.
> mondrian117.q - result set with group by stitched wrong
> -------------------------------------------------------
>
> Key: DRILL-1156
> URL: https://issues.apache.org/jira/browse/DRILL-1156
> Project: Apache Drill
> Issue Type: Bug
> Components: Execution - Operators
> Reporter: Chun Chang
> Assignee: Chun Chang
>
> #Mon Jul 14 10:10:52 PDT 2014
> git.commit.id.abbrev=699851b
> For this mondrian query (query117.q), with group by, result set is stitched
> together in a wrong order. For example, for some columns, like c6, c7, c8,
> c9, row oder is wrong.
> postgres:
> foodmart=# select store.store_country as c0, store.store_state as c1,
> store.store_city as c2, store.store_name as c3, store.store_type as c4,
> store.store_manager as c5, store.store_sqft as c6, store.grocery_sqft as c7,
> store.frozen_sqft as c8, store.meat_sqft as c9, store.coffee_bar as c10,
> store.store_street_address as c11 from store as store group by
> store.store_country, store.store_state, store.store_city, store.store_name,
> store.store_type, store.store_manager, store.store_sqft, store.grocery_sqft,
> store.frozen_sqft, store.meat_sqft, store.coffee_bar,
> store.store_street_address order by store.store_country ASC NULLS LAST,
> store.store_state ASC NULLS LAST, store.store_city ASC NULLS LAST,
> store.store_name ASC NULLS LAST;
> c0 | c1 | c2 | c3 | c4 | c5
> | c6 | c7 | c8 | c9 | c10 | c11
> --------+-----------+---------------+----------+---------------------+----------+-------+-------+------+------+-----+---------------------------
> Canada | BC | Vancouver | Store 19 | Deluxe Supermarket | Ruth
> | 23112 | 16418 | 4016 | 2678 | t | 6644 Sudance Drive
> Canada | BC | Victoria | Store 20 | Mid-Size Grocery | Cobb
> | 34452 | 27463 | 4193 | 2795 | t | 3706 Marvelle Ln
> Mexico | DF | Mexico City | Store 9 | Mid-Size Grocery | Stuber
> | 36509 | 22450 | 8435 | 5624 | f | 1872 El Pintado Road
> Mexico | DF | San Andres | Store 21 | Deluxe Supermarket | Jones
> | | | | | t | 4093 Steven Circle
> Mexico | Guerrero | Acapulco | Store 1 | Supermarket | Jones
> | 23593 | 17475 | 3671 | 2447 | f | 2853 Bailey Rd
> Mexico | Jalisco | Guadalajara | Store 5 | Small Grocery | Green
> | 24597 | 15012 | 5751 | 3834 | t | 1250 Coggins Drive
> Mexico | Veracruz | Orizaba | Store 10 | Supermarket | Merz
> | 34791 | 26354 | 5062 | 3375 | f | 7894 Rotherham Dr
> Mexico | Yucatan | Merida | Store 8 | Deluxe Supermarket |
> Williams | 30797 | 20141 | 6393 | 4262 | t | 3173 Buena Vista Ave
> Mexico | Zacatecas | Camacho | Store 4 | Gourmet Supermarket |
> Johnson | 23759 | 16844 | 4149 | 2766 | t | 433 St George Dr
> Mexico | Zacatecas | Hidalgo | Store 12 | Deluxe Supermarket | Kalman
> | 30584 | 21938 | 5188 | 3458 | t | 1120 Westchester Pl
> Mexico | Zacatecas | Hidalgo | Store 18 | Mid-Size Grocery | Brown
> | 38382 | 30351 | 4819 | 3213 | f | 6764 Glen Road
> USA | CA | Alameda | HQ | HeadQuarters |
> | | | | | f | 1 Alameda Way
> USA | CA | Beverly Hills | Store 6 | Gourmet Supermarket | Maris
> | 23688 | 15337 | 5011 | 3340 | t | 5495 Mitchell Canyon Road
> USA | CA | Los Angeles | Store 7 | Supermarket | White
> | 23598 | 14210 | 5633 | 3755 | f | 1077 Wharf Drive
> USA | CA | San Diego | Store 24 | Supermarket | Byrd
> | | | | | t | 2342 Waltham St.
> USA | CA | San Francisco | Store 14 | Small Grocery |
> Strehlo | 22478 | 15321 | 4294 | 2863 | t | 4365 Indigo Ct
> drill:
> Canada BC Vancouver Store 19 Deluxe Supermarket
> Ruth 23112 16418 4016 2678 t 6644 Sudance Drive
> Canada BC Victoria Store 20 Mid-Size Grocery
> Cobb 34452 27463 4193 2795 t 3706 Marvelle Ln
> Mexico DF Mexico City Store 9 Mid-Size Grocery Stuber
> 36509 22450 8435 5624 f 1872 El Pintado Road
> Mexico DF San Andres Store 21 Deluxe Supermarket
> Jones \N \N \N \N t 4093 Steven Circle
> Mexico Guerrero Acapulco Store 1 Supermarket Jones
> 23593 17475 3671 2447 f 2853 Bailey Rd
> Mexico Jalisco Guadalajara Store 5 Small Grocery Green 24597
> 15012 5751 3834 t 1250 Coggins Drive
> Mexico Veracruz Orizaba Store 10 Supermarket Merz
> 34791 26354 5062 3375 f 7894 Rotherham Dr
> Mexico Yucatan Merida Store 8 Deluxe Supermarket Williams
> 30797 20141 6393 4262 t 3173 Buena Vista Ave
> Mexico Zacatecas Camacho Store 4 Gourmet Supermarket Johnson
> 23759 16844 4149 2766 t 433 St George Dr
> Mexico Zacatecas Hidalgo Store 12 Deluxe Supermarket
> Kalman 30584 21938 5188 3458 t 1120 Westchester Pl
> Mexico Zacatecas Hidalgo Store 18 Mid-Size Grocery
> Brown 38382 30351 4819 3213 f 6764 Glen Road
> USA CA Alameda HQ HeadQuarters \N \N \N \N
> \N f 1 Alameda Way
> USA CA Beverly Hills Store 6 Gourmet Supermarket Maris 23688
> 15337 5011 3340 t 5495 Mitchell Canyon Road
> USA CA Los Angeles Store 7 Supermarket White 23598 14210
> 5633 3755 f 1077 Wharf Drive
> USA CA San Diego Store 24 Supermarket Byrd \N
> \N \N \N t 2342 Waltham St.
> USA CA San Francisco Store 14 Small Grocery Strehlo 22478
> 15321 4294 2863 t 4365 Indigo Ct
--
This message was sent by Atlassian JIRA
(v6.2#6252)
