drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Deneche A. Hakim (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-1487) Drill window functions return wrong results
Date Tue, 06 Jan 2015 17:53:34 GMT

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

Deneche A. Hakim commented on DRILL-1487:
-----------------------------------------

Changing *StreamingWindowFrameBatchCreator.getBatch()* to the following:
{code}
public RecordBatch getBatch(FragmentContext context, WindowPOP config, List<RecordBatch>
children) throws ExecutionSetupException {
    throw new ExecutionSetupException("Window functions have been disabled");
}
{code}

Do display *Window functions have been disabled* when a query contains an over clause. But
the following issues still arise and throw different exceptions: DRILL-1863, 	DRILL-1862,
DRILL-1852. Those issues seem to be caused by optiq validation.

Is there another way to disable windowing functionality ?

> Drill window functions return wrong results
> -------------------------------------------
>
>                 Key: DRILL-1487
>                 URL: https://issues.apache.org/jira/browse/DRILL-1487
>             Project: Apache Drill
>          Issue Type: Bug
>    Affects Versions: 0.6.0
>            Reporter: Neeraja
>            Assignee: Deneche A. Hakim
>            Priority: Critical
>             Fix For: 0.8.0
>
>
> Executing the following window function with the requirement to see how a given employee
salary would compare to the avg(salary) in his/her position. 
> Query executes fine however returns wrong results(expect the avg(salary) to stay same
for a given window (i.e position id)
> 0: jdbc:drill:zk=local> SELECT employee_id,position_id, salary, avg(salary) OVER (PARTITION
BY position_id order by position_id) FROM cp.`employee.json` order by employee_id;
> +-------------+-------------+------------+------------+
> | employee_id | position_id |   salary   |   EXPR$3   |
> +-------------+-------------+------------+------------+
> | 1           | 1           | 80000.0    | 80000.0    |
> | 2           | 2           | 40000.0    | 37500.0    |
> | 4           | 2           | 40000.0    | 38333.333333333336 |
> | 5           | 2           | 35000.0    | 35000.0    |
> | 6           | 3           | 25000.0    | 25000.0    |
> | 7           | 4           | 15000.0    | 15000.0    |
> | 8           | 11          | 10000.0    | 14333.333333333334 |
> | 9           | 11          | 17000.0    | 17000.0    |



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message