You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by "Chun Chang (JIRA)" <ji...@apache.org> on 2014/05/14 00:25:15 UTC
[jira] [Created] (DRILL-719) right join with order by asserted
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)