drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Abhishek Girish (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-2329) TPCDS query 95 and simplified variant fail to execute
Date Fri, 27 Feb 2015 01:02:58 GMT
Abhishek Girish created DRILL-2329:

             Summary: TPCDS query 95 and simplified variant fail to execute
                 Key: DRILL-2329
                 URL: https://issues.apache.org/jira/browse/DRILL-2329
             Project: Apache Drill
          Issue Type: Bug
          Components: Query Planning & Optimization
    Affects Versions: 0.8.0
            Reporter: Abhishek Girish
            Assignee: Jinfeng Ni

TPCDS query 95 (attached) fails to validate. 

*A simplified variant of the query (may not have much semantics) that fails:*
       SELECT *
       FROM   web_sales)
         Count(DISTINCT ws_order_number) AS a1 ,
         Sum(ws_ext_ship_cost)           AS a2 
FROM     web_sales ws 
WHERE     ws.ws_ship_addr_sk = 1
AND      ws.ws_web_site_sk = web_site_sk
ORDER BY count(DISTINCT ws_order_number)
LIMIT 100;

Query failed: SqlValidatorException: Aggregate expression is illegal in ORDER BY clause of
non-aggregating SELECT

This message was sent by Atlassian JIRA

View raw message