[
https://issues.apache.org/jira/browse/DRILL-3327?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14601624#comment-14601624
]
Victoria Markman commented on DRILL-3327:
-----------------------------------------
Verified fixed in 1.1
#Thu Jun 25 09:15:06 EDT 2015
git.commit.id.abbrev=58c3c4c
Tests will be checked in under: window_functions/order_by,
window_functions/partition_by
Test description: partition spanning multiple batches (by creating multiple
parquet files), sort below window function going to disk and queries with
either only order by or partitioned by one column that has the same value.
> row_number function returns incorrect result when only order by clause is
> specified
> -----------------------------------------------------------------------------------
>
> Key: DRILL-3327
> URL: https://issues.apache.org/jira/browse/DRILL-3327
> Project: Apache Drill
> Issue Type: Bug
> Components: Query Planning & Optimization
> Affects Versions: 1.0.0
> Reporter: Victoria Markman
> Assignee: Victoria Markman
> Priority: Critical
> Labels: window_function
> Fix For: 1.1.0
>
> Attachments:
> 0001-DRILL-3327-If-no-partition-by-is-specified-read-all-.patch, j1.tar,
> row_number_wrong_result.tar
>
>
> Queries returning wrong result:
> {code}
> select c_integer, row_number() over(order by c_integer) from j1 order by 2;
> select c_integer, row_number() over(order by c_integer) from j1 order by 2
> desc;
> select c_integer, row_number() over(order by c_integer desc) from j1 order by
> 2;
> select c_integer, row_number() over(order by c_integer desc) from j1 order by
> 2;
> select c_integer, row_number() over(order by c_integer nulls first) from j1
> order by c_integer nulls last, row_number() over(order by c_integer nulls
> first);
> select c_integer, row_number() over(order by c_integer nulls last) from j1
> order by c_integer nulls first, row_number() over(order by c_integer nulls
> last);
> {code}
> In attached tar file (row_number_wrong_result.tar) you will find:
> 1. *.sql - file that contains query
> 2. *.res - expected result (generated from Postgres)
> 3. *.out - result returned by drill
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
