Repository: drill Updated Branches: refs/heads/master 1c37185bf -> 149928da5
DRILL-3337: Fix is in Calcite, see CALCITE-770. Add unit test and upgrade Calcite version. Project: http://git-wip-us.apache.org/repos/asf/drill/repo Commit: http://git-wip-us.apache.org/repos/asf/drill/commit/149928da Tree: http://git-wip-us.apache.org/repos/asf/drill/tree/149928da Diff: http://git-wip-us.apache.org/repos/asf/drill/diff/149928da Branch: refs/heads/master Commit: 149928da50ed0c48de2410af3cfe35682269ac76 Parents: 1c37185 Author: Aman Sinha <[email protected]> Authored: Sat Jun 27 09:25:39 2015 -0700 Committer: Aman Sinha <[email protected]> Committed: Sat Jun 27 17:32:09 2015 -0700 ---------------------------------------------------------------------- .../org/apache/drill/exec/TestWindowFunctions.java | 14 ++++++++++++++ pom.xml | 2 +- 2 files changed, 15 insertions(+), 1 deletion(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/drill/blob/149928da/exec/java-exec/src/test/java/org/apache/drill/exec/TestWindowFunctions.java ---------------------------------------------------------------------- diff --git a/exec/java-exec/src/test/java/org/apache/drill/exec/TestWindowFunctions.java b/exec/java-exec/src/test/java/org/apache/drill/exec/TestWindowFunctions.java index 66148f3..7f75771 100644 --- a/exec/java-exec/src/test/java/org/apache/drill/exec/TestWindowFunctions.java +++ b/exec/java-exec/src/test/java/org/apache/drill/exec/TestWindowFunctions.java @@ -352,4 +352,18 @@ public class TestWindowFunctions extends BaseTestQuery { .build() .run(); } + + @Test + public void testRankWithGroupBy() throws Exception { + final String query = "select dense_rank() over (order by l_suppkey) as rank1 " + + " from cp.`tpch/lineitem.parquet` group by l_partkey, l_suppkey order by 1 desc limit 1"; + + testBuilder() + .sqlQuery(query) + .unOrdered() + .baselineColumns("rank1") + .baselineValues(100l) + .go(); + } + } http://git-wip-us.apache.org/repos/asf/drill/blob/149928da/pom.xml ---------------------------------------------------------------------- diff --git a/pom.xml b/pom.xml index 772192b..724bcb2 100644 --- a/pom.xml +++ b/pom.xml @@ -1226,7 +1226,7 @@ <dependency> <groupId>org.apache.calcite</groupId> <artifactId>calcite-core</artifactId> - <version>1.1.0-drill-r11</version> + <version>1.1.0-drill-r12</version> <exclusions> <exclusion> <groupId>org.jgrapht</groupId>
