Chun Chang created DRILL-719:
--------------------------------
Summary: right join with order by asserted
Key: DRILL-719
URL: https://issues.apache.org/jira/browse/DRILL-719
Project: Apache Drill
Issue Type: Bug
Reporter: Chun Chang
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)
