drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Chun Chang (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-719) right join with order by asserted
Date Mon, 11 Aug 2014 20:46:12 GMT

    [ https://issues.apache.org/jira/browse/DRILL-719?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14093264#comment-14093264
] 

Chun Chang commented on DRILL-719:
----------------------------------

This query works with the 0.4 release.

#Thu Jul 31 07:44:54 PDT 2014
git.commit.id.abbrev=ee3a4b5

> 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)

Mime
View raw message