You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@phoenix.apache.org by ja...@apache.org on 2016/03/16 00:35:47 UTC
[1/3] phoenix git commit: PHOENIX-2768 Add test for case sensitive
table with index hint
Repository: phoenix
Updated Branches:
refs/heads/4.x-HBase-1.0 885f4453e -> d672cdf2d
PHOENIX-2768 Add test for case sensitive table with index hint
Project: http://git-wip-us.apache.org/repos/asf/phoenix/repo
Commit: http://git-wip-us.apache.org/repos/asf/phoenix/commit/f72f7cf4
Tree: http://git-wip-us.apache.org/repos/asf/phoenix/tree/f72f7cf4
Diff: http://git-wip-us.apache.org/repos/asf/phoenix/diff/f72f7cf4
Branch: refs/heads/4.x-HBase-1.0
Commit: f72f7cf40d77e09994efa9d43916866a175e78a2
Parents: 885f445
Author: James Taylor <jt...@salesforce.com>
Authored: Mon Mar 14 20:33:03 2016 -0700
Committer: James Taylor <jt...@salesforce.com>
Committed: Tue Mar 15 16:18:54 2016 -0700
----------------------------------------------------------------------
.../phoenix/compile/QueryOptimizerTest.java | 28 ++++++++++++++++++++
1 file changed, 28 insertions(+)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/phoenix/blob/f72f7cf4/phoenix-core/src/test/java/org/apache/phoenix/compile/QueryOptimizerTest.java
----------------------------------------------------------------------
diff --git a/phoenix-core/src/test/java/org/apache/phoenix/compile/QueryOptimizerTest.java b/phoenix-core/src/test/java/org/apache/phoenix/compile/QueryOptimizerTest.java
index e528d3b..c3345ba 100644
--- a/phoenix-core/src/test/java/org/apache/phoenix/compile/QueryOptimizerTest.java
+++ b/phoenix-core/src/test/java/org/apache/phoenix/compile/QueryOptimizerTest.java
@@ -273,6 +273,34 @@ public class QueryOptimizerTest extends BaseConnectionlessQueryTest {
PhoenixStatement stmt = conn.createStatement().unwrap(PhoenixStatement.class);
QueryPlan plan = stmt.optimizeQuery("SELECT /*+ INDEX(t idx1) */ k FROM t WHERE v1 = 'foo' AND v2 = 'bar'");
assertEquals("IDX1", plan.getTableRef().getTable().getTableName().getString());
+ plan = stmt.optimizeQuery("SELECT k FROM t WHERE v1 = 'foo' AND v2 = 'bar'");
+ assertEquals("IDX2", plan.getTableRef().getTable().getTableName().getString());
+ }
+
+ @Test
+ public void testChooseIndexFromCaseSensitiveHint() throws Exception {
+ Connection conn = DriverManager.getConnection(getUrl());
+ conn.createStatement().execute("CREATE TABLE \"t\" (k INTEGER NOT NULL PRIMARY KEY, v1 VARCHAR, v2 VARCHAR) IMMUTABLE_ROWS=true");
+ conn.createStatement().execute("CREATE INDEX idx1 ON \"t\"(v1) INCLUDE(v2)");
+ conn.createStatement().execute("CREATE INDEX idx2 ON \"t\"(v1,v2)");
+ PhoenixStatement stmt = conn.createStatement().unwrap(PhoenixStatement.class);
+ QueryPlan plan = stmt.optimizeQuery("SELECT /*+ INDEX(\"t\" idx1) */ k FROM \"t\" WHERE v1 = 'foo' AND v2 = 'bar'");
+ assertEquals("IDX1", plan.getTableRef().getTable().getTableName().getString());
+ plan = stmt.optimizeQuery("SELECT k FROM \"t\" WHERE v1 = 'foo' AND v2 = 'bar'");
+ assertEquals("IDX2", plan.getTableRef().getTable().getTableName().getString());
+ }
+
+ @Test
+ public void testChooseIndexFromCaseSensitiveHint2() throws Exception {
+ Connection conn = DriverManager.getConnection(getUrl());
+ conn.createStatement().execute("CREATE TABLE \"t\" (k INTEGER NOT NULL PRIMARY KEY, v1 VARCHAR, v2 VARCHAR) IMMUTABLE_ROWS=true");
+ conn.createStatement().execute("CREATE INDEX \"idx1\" ON \"t\"(v1) INCLUDE(v2)");
+ conn.createStatement().execute("CREATE INDEX \"idx2\" ON \"t\"(v1,v2)");
+ PhoenixStatement stmt = conn.createStatement().unwrap(PhoenixStatement.class);
+ QueryPlan plan = stmt.optimizeQuery("SELECT /*+ INDEX(\"t\" \"idx1\") */ k FROM \"t\" WHERE v1 = 'foo' AND v2 = 'bar'");
+ assertEquals("idx1", plan.getTableRef().getTable().getTableName().getString());
+ plan = stmt.optimizeQuery("SELECT k FROM \"t\" WHERE v1 = 'foo' AND v2 = 'bar'");
+ assertEquals("idx2", plan.getTableRef().getTable().getTableName().getString());
}
[3/3] phoenix git commit: PHOENIX-2773 Remove unnecessary repos in
poms
Posted by ja...@apache.org.
PHOENIX-2773 Remove unnecessary repos in poms
Project: http://git-wip-us.apache.org/repos/asf/phoenix/repo
Commit: http://git-wip-us.apache.org/repos/asf/phoenix/commit/d672cdf2
Tree: http://git-wip-us.apache.org/repos/asf/phoenix/tree/d672cdf2
Diff: http://git-wip-us.apache.org/repos/asf/phoenix/diff/d672cdf2
Branch: refs/heads/4.x-HBase-1.0
Commit: d672cdf2dcdeec8e6aa15962db8db4b3303c0f62
Parents: 42f855e
Author: James Taylor <jt...@salesforce.com>
Authored: Tue Mar 15 10:24:37 2016 -0700
Committer: James Taylor <jt...@salesforce.com>
Committed: Tue Mar 15 16:22:12 2016 -0700
----------------------------------------------------------------------
pom.xml | 19 -------------------
1 file changed, 19 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/phoenix/blob/d672cdf2/pom.xml
----------------------------------------------------------------------
diff --git a/pom.xml b/pom.xml
index 59ce1b3..f5fb914 100644
--- a/pom.xml
+++ b/pom.xml
@@ -39,25 +39,6 @@
<id>apache release</id>
<url>https://repository.apache.org/content/repositories/releases/</url>
</repository>
- <repository>
- <id>conjars.org</id>
- <url>http://conjars.org/repo</url>
- </repository>
- <repository>
- <id>apache snapshot</id>
- <url>https://repository.apache.org/content/repositories/snapshots/</url>
- <snapshots>
- <enabled>true</enabled>
- </snapshots>
- </repository>
- <repository>
- <id>sonatype-nexus-snapshots</id>
- <name>Sonatype Nexus Snapshots</name>
- <url>https://oss.sonatype.org/content/repositories/snapshots</url>
- <snapshots>
- <enabled>true</enabled>
- </snapshots>
- </repository>
</repositories>
<parent>
[2/3] phoenix git commit: PHOENIX-2772 Upgrade pom to sqlline 1.1.9
Posted by ja...@apache.org.
PHOENIX-2772 Upgrade pom to sqlline 1.1.9
Project: http://git-wip-us.apache.org/repos/asf/phoenix/repo
Commit: http://git-wip-us.apache.org/repos/asf/phoenix/commit/42f855e2
Tree: http://git-wip-us.apache.org/repos/asf/phoenix/tree/42f855e2
Diff: http://git-wip-us.apache.org/repos/asf/phoenix/diff/42f855e2
Branch: refs/heads/4.x-HBase-1.0
Commit: 42f855e22e3674ca8c52a93e8dbaac817abcd082
Parents: f72f7cf
Author: James Taylor <jt...@salesforce.com>
Authored: Tue Mar 15 09:43:59 2016 -0700
Committer: James Taylor <jt...@salesforce.com>
Committed: Tue Mar 15 16:21:23 2016 -0700
----------------------------------------------------------------------
pom.xml | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/phoenix/blob/42f855e2/pom.xml
----------------------------------------------------------------------
diff --git a/pom.xml b/pom.xml
index 9b6deb8..59ce1b3 100644
--- a/pom.xml
+++ b/pom.xml
@@ -97,7 +97,7 @@
<commons-lang.version>2.5</commons-lang.version>
<commons-logging.version>1.2</commons-logging.version>
<commons-csv.version>1.0</commons-csv.version>
- <sqlline.version>1.1.8</sqlline.version>
+ <sqlline.version>1.1.9</sqlline.version>
<guava.version>13.0.1</guava.version>
<flume.version>1.4.0</flume.version>
<findbugs.version>1.3.2</findbugs.version>