drill-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From amansi...@apache.org
Subject [1/2] drill git commit: DRILL-2063: Fix is in Calcite (ensure uniqueness of fields in the row type of AggregateRel). Added unit test and bumped up calcite version to 0.9-drill-r18.
Date Mon, 26 Jan 2015 07:55:24 GMT
Repository: drill
Updated Branches:
  refs/heads/master 5b2a11b7c -> 3c6d0ef65


DRILL-2063: Fix is in Calcite (ensure uniqueness of fields in the row type of AggregateRel).
 Added unit test and bumped up calcite version to 0.9-drill-r18.


Project: http://git-wip-us.apache.org/repos/asf/drill/repo
Commit: http://git-wip-us.apache.org/repos/asf/drill/commit/52b36ed9
Tree: http://git-wip-us.apache.org/repos/asf/drill/tree/52b36ed9
Diff: http://git-wip-us.apache.org/repos/asf/drill/diff/52b36ed9

Branch: refs/heads/master
Commit: 52b36ed9dabb51e63fd1c555094f95e192bb63a0
Parents: 5b2a11b
Author: Aman Sinha <asinha@maprtech.com>
Authored: Sat Jan 24 13:18:39 2015 -0800
Committer: Aman Sinha <asinha@maprtech.com>
Committed: Sat Jan 24 13:18:39 2015 -0800

----------------------------------------------------------------------
 .../java/org/apache/drill/TestExampleQueries.java    | 15 +++++++++++++++
 pom.xml                                              |  2 +-
 2 files changed, 16 insertions(+), 1 deletion(-)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/drill/blob/52b36ed9/exec/java-exec/src/test/java/org/apache/drill/TestExampleQueries.java
----------------------------------------------------------------------
diff --git a/exec/java-exec/src/test/java/org/apache/drill/TestExampleQueries.java b/exec/java-exec/src/test/java/org/apache/drill/TestExampleQueries.java
index a3b5ff1..8f04657 100644
--- a/exec/java-exec/src/test/java/org/apache/drill/TestExampleQueries.java
+++ b/exec/java-exec/src/test/java/org/apache/drill/TestExampleQueries.java
@@ -518,4 +518,19 @@ public class TestExampleQueries extends BaseTestQuery{
     assertEquals(expectedRecordCount, actualRecordCount);
   }
 
+  @Test // DRILL-2063
+  public void testAggExpressionWithGroupBy() throws Exception {
+    String query = "select l_suppkey, sum(l_extendedprice)/sum(l_quantity) as avg_price \n"
+
+           " from cp.`tpch/lineitem.parquet` where l_orderkey in \n" +
+           " (select o_orderkey from cp.`tpch/orders.parquet` where o_custkey = 2) \n" +
+           " and l_suppkey = 4 group by l_suppkey";
+
+    testBuilder()
+    .sqlQuery(query)
+    .ordered()
+    .baselineColumns("l_suppkey", "avg_price")
+    .baselineValues(4, 1374.47)
+    .build().run();
+
+  }
 }

http://git-wip-us.apache.org/repos/asf/drill/blob/52b36ed9/pom.xml
----------------------------------------------------------------------
diff --git a/pom.xml b/pom.xml
index 9492004..2087a0b 100644
--- a/pom.xml
+++ b/pom.xml
@@ -921,7 +921,7 @@
           <dependency>
             <groupId>net.hydromatic</groupId>
             <artifactId>optiq-core</artifactId>
-            <version>0.9-drill-r16</version>
+            <version>0.9-drill-r18</version>
             <exclusions>
               <exclusion>
                 <groupId>org.jgrapht</groupId>


Mime
View raw message