[
https://issues.apache.org/jira/browse/DRILL-719?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jacques Nadeau updated DRILL-719:
---------------------------------
Assignee: Suresh Ollala (was: Aman Sinha)
> right join with order by asserted
> ---------------------------------
>
> Key: DRILL-719
> URL: https://issues.apache.org/jira/browse/DRILL-719
> Project: Apache Drill
> Issue Type: Bug
> Components: Query Planning & Optimization
> Reporter: Chun Chang
> Assignee: Suresh Ollala
> Fix For: 0.5.0
>
>
> The following query asserted on drill.
> postgres:
> foodmart=# select store.store_id, store.store_name, store.store_city,
> store.store_state, store.store_postal_code, store.store_country,
> region.region_id, region.sales_city from store right join region on
> store.region_id = region.region_id order by region.region_id;
> store_id | store_name | store_city | store_state | store_postal_code |
> store_country | region_id | sales_city
> ----------+------------+---------------+-------------+-------------------+---------------+-----------+----------------
> 0 | HQ | Alameda | CA | 55555 |
> USA | 0 | None
> 14 | Store 14 | San Francisco | CA | 55555 |
> USA | 1 | San Francisco
> 9 | Store 9 | Mexico City | DF | 55555 |
> Mexico | 2 | Mexico City
> 7 | Store 7 | Los Angeles | CA | 55555 |
> USA | 3 | Los Angeles
> 5 | Store 5 | Guadalajara | Jalisco | 55555 |
> Mexico | 4 | Guadalajara
> 19 | Store 19 | Vancouver | BC | 55555 |
> Canada | 5 | Vancouver
> 20 | Store 20 | Victoria | BC | 55555 |
> Canada | 6 | Victoria
> 24 | Store 24 | San Diego | CA | 55555 |
> USA | 7 | San Diego
> ...
> drill:
> 0: jdbc:drill:schema=dfs> select store.store_id, store.store_name,
> store.store_city, store.store_state, store.store_postal_code,
> store.store_country, region.region_id, region.sales_city from store right
> join region on store.region_id = region.region_id order by region.region_id;
> Query failed: org.apache.drill.exec.rpc.RpcException: Remote failure while
> running query.[error_id: "4cc2425b-1cfb-4840-9b1a-6816c13fe043"
> endpoint {
> address: "qa-node118.qa.lab"
> user_port: 31010
> control_port: 31011
> data_port: 31012
> }
> error_type: 0
> message: "Failure while setting up Foreman. < AssertionError"
> ]
> Error: exception while executing query (state=,code=0)
--
This message was sent by Atlassian JIRA
(v6.2#6252)
