You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@phoenix.apache.org by ma...@apache.org on 2016/01/05 15:50:35 UTC
[2/2] phoenix git commit: PHOENIX-2257 Failing integration test in
DerivedTableIT (addendum)
PHOENIX-2257 Failing integration test in DerivedTableIT (addendum)
Project: http://git-wip-us.apache.org/repos/asf/phoenix/repo
Commit: http://git-wip-us.apache.org/repos/asf/phoenix/commit/316871ba
Tree: http://git-wip-us.apache.org/repos/asf/phoenix/tree/316871ba
Diff: http://git-wip-us.apache.org/repos/asf/phoenix/diff/316871ba
Branch: refs/heads/4.x-HBase-1.0
Commit: 316871ba47a53696cdbfd4dbf6634e1eadaef013
Parents: a593e98
Author: maryannxue <ma...@gmail.com>
Authored: Tue Jan 5 09:36:36 2016 -0500
Committer: maryannxue <ma...@gmail.com>
Committed: Tue Jan 5 09:36:36 2016 -0500
----------------------------------------------------------------------
.../java/org/apache/phoenix/end2end/DerivedTableIT.java | 10 ++++++----
1 file changed, 6 insertions(+), 4 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/phoenix/blob/316871ba/phoenix-core/src/it/java/org/apache/phoenix/end2end/DerivedTableIT.java
----------------------------------------------------------------------
diff --git a/phoenix-core/src/it/java/org/apache/phoenix/end2end/DerivedTableIT.java b/phoenix-core/src/it/java/org/apache/phoenix/end2end/DerivedTableIT.java
index 95a7fed..82a742b 100644
--- a/phoenix-core/src/it/java/org/apache/phoenix/end2end/DerivedTableIT.java
+++ b/phoenix-core/src/it/java/org/apache/phoenix/end2end/DerivedTableIT.java
@@ -104,7 +104,8 @@ public class DerivedTableIT extends BaseClientManagedTimeIT {
"CLIENT MERGE SORT\n" +
"CLIENT SORTED BY [A]\n" +
"CLIENT AGGREGATE INTO DISTINCT ROWS BY [A]\n" +
- "CLIENT DISTINCT ON [COLLECTDISTINCT(B)]"}});
+ "CLIENT DISTINCT ON [COLLECTDISTINCT(B)]\n" +
+ "CLIENT SORTED BY [A DESC]"}});
testCases.add(new String[][] {
{}, {
"CLIENT PARALLEL 4-WAY FULL SCAN OVER ATABLE\n" +
@@ -120,7 +121,8 @@ public class DerivedTableIT extends BaseClientManagedTimeIT {
"CLIENT MERGE SORT\n" +
"CLIENT SORTED BY [A]\n" +
"CLIENT AGGREGATE INTO DISTINCT ROWS BY [A]\n" +
- "CLIENT DISTINCT ON [COLLECTDISTINCT(B)]"}});
+ "CLIENT DISTINCT ON [COLLECTDISTINCT(B)]\n" +
+ "CLIENT SORTED BY [A DESC]"}});
return testCases;
}
@@ -311,8 +313,8 @@ public class DerivedTableIT extends BaseClientManagedTimeIT {
rs = conn.createStatement().executeQuery("EXPLAIN " + query);
assertEquals(plans[0], QueryUtil.getExplainPlan(rs));
- // distinct b (groupby a, b) groupby a
- query = "SELECT DISTINCT COLLECTDISTINCT(t.b) FROM (SELECT b_string b, a_string a FROM aTable GROUP BY a_string, b_string) AS t GROUP BY t.a";
+ // distinct b (groupby a, b) groupby a orderby a
+ query = "SELECT DISTINCT COLLECTDISTINCT(t.b) FROM (SELECT b_string b, a_string a FROM aTable GROUP BY a_string, b_string) AS t GROUP BY t.a ORDER BY t.a DESC";
statement = conn.prepareStatement(query);
rs = statement.executeQuery();
assertTrue (rs.next());