You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@drill.apache.org by am...@apache.org on 2015/06/28 03:30:55 UTC
drill git commit: DRILL-3337: Fix is in Calcite,
see CALCITE-770. Add unit test and upgrade Calcite version.
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 <as...@maprtech.com>
Authored: Sat Jun 27 09:25:39 2015 -0700
Committer: Aman Sinha <as...@maprtech.com>
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>