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/15 23:56:11 UTC
[1/3] phoenix git commit: PHOENIX-2773 Remove unnecessary repos in
poms
Repository: phoenix
Updated Branches:
refs/heads/master c19c32157 -> e7bcfe4f2
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/e7bcfe4f
Tree: http://git-wip-us.apache.org/repos/asf/phoenix/tree/e7bcfe4f
Diff: http://git-wip-us.apache.org/repos/asf/phoenix/diff/e7bcfe4f
Branch: refs/heads/master
Commit: e7bcfe4f2b889575f7a20e0e2d9f76175282108c
Parents: 6eadadd
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 15:56:03 2016 -0700
----------------------------------------------------------------------
pom.xml | 19 -------------------
1 file changed, 19 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/phoenix/blob/e7bcfe4f/pom.xml
----------------------------------------------------------------------
diff --git a/pom.xml b/pom.xml
index 4c87161..0add065 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>
[3/3] phoenix git commit: PHOENIX-2768 Add test for case sensitive
table with index hint
Posted by ja...@apache.org.
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/d8b45bcb
Tree: http://git-wip-us.apache.org/repos/asf/phoenix/tree/d8b45bcb
Diff: http://git-wip-us.apache.org/repos/asf/phoenix/diff/d8b45bcb
Branch: refs/heads/master
Commit: d8b45bcb3d923124455788d27718aafd3c0158c1
Parents: c19c321
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 15:56:03 2016 -0700
----------------------------------------------------------------------
.../phoenix/compile/QueryOptimizerTest.java | 28 ++++++++++++++++++++
1 file changed, 28 insertions(+)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/phoenix/blob/d8b45bcb/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());
}
[2/3] phoenix git commit: PHOENIX-2772 Upgrade pom to sqlline 1.1.19
Posted by ja...@apache.org.
PHOENIX-2772 Upgrade pom to sqlline 1.1.19
Project: http://git-wip-us.apache.org/repos/asf/phoenix/repo
Commit: http://git-wip-us.apache.org/repos/asf/phoenix/commit/6eadadd2
Tree: http://git-wip-us.apache.org/repos/asf/phoenix/tree/6eadadd2
Diff: http://git-wip-us.apache.org/repos/asf/phoenix/diff/6eadadd2
Branch: refs/heads/master
Commit: 6eadadd2a4faa640fec4b141c357f7d4e2180dcc
Parents: d8b45bc
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 15:56:03 2016 -0700
----------------------------------------------------------------------
pom.xml | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/phoenix/blob/6eadadd2/pom.xml
----------------------------------------------------------------------
diff --git a/pom.xml b/pom.xml
index 4021a0a..4c87161 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>