Apache-Phoenix | 4.x-HBase-0.98 | Build Successful

2016-03-15 Thread Apache Jenkins Server 
4.x-HBase-0.98 branch build status Successful

Source repository https://git-wip-us.apache.org/repos/asf?p=phoenix.git;a=shortlog;h=refs/heads/4.x-HBase-0.98

Compiled Artifacts https://builds.apache.org/job/Phoenix-4.x-HBase-0.98/lastSuccessfulBuild/artifact/

Test Report https://builds.apache.org/job/Phoenix-4.x-HBase-0.98/lastCompletedBuild/testReport/

Changes
[jtaylor] PHOENIX-2768 Add test for case sensitive table with index hint

[jtaylor] PHOENIX-2772 Upgrade pom to sqlline 1.1.9

[jtaylor] PHOENIX-2773 Remove unnecessary repos in poms



Build times for last couple of runsLatest build time is the right most | Legend blue: normal, red: test failure, gray: timeout

Apache-Phoenix | 4.x-HBase-1.0 | Build Successful

2016-03-15 Thread Apache Jenkins Server 
4.x-HBase-1.0 branch build status Successful

Source repository https://git-wip-us.apache.org/repos/asf?p=phoenix.git;a=shortlog;h=refs/heads/4.x-HBase-1.0

Compiled Artifacts https://builds.apache.org/job/Phoenix-4.x-HBase-1.0/lastSuccessfulBuild/artifact/

Test Report https://builds.apache.org/job/Phoenix-4.x-HBase-1.0/lastCompletedBuild/testReport/

Changes
[jtaylor] PHOENIX-2768 Add test for case sensitive table with index hint

[jtaylor] PHOENIX-2772 Upgrade pom to sqlline 1.1.9

[jtaylor] PHOENIX-2773 Remove unnecessary repos in poms



Build times for last couple of runsLatest build time is the right most | Legend blue: normal, red: test failure, gray: timeout

Build failed in Jenkins: Phoenix | Master #1174

2016-03-15 Thread Apache Jenkins Server 
See 

Changes:

[jtaylor] PHOENIX-2768 Add test for case sensitive table with index hint

[jtaylor] PHOENIX-2772 Upgrade pom to sqlline 1.1.19

[jtaylor] PHOENIX-2773 Remove unnecessary repos in poms

--
[...truncated 2045 lines...]

Running org.apache.phoenix.end2end.index.ImmutableIndexWithStatsIT
Tests run: 1, Failures: 0, Errors: 1, Skipped: 0, Time elapsed: 0.007 sec <<< 
FAILURE! - in org.apache.phoenix.end2end.index.ImmutableIndexWithStatsIT
org.apache.phoenix.end2end.index.ImmutableIndexWithStatsIT  Time elapsed: 0.006 
sec  <<< ERROR!
java.lang.RuntimeException: java.io.IOException: Shutting down
at 
org.apache.phoenix.end2end.index.ImmutableIndexWithStatsIT.doSetup(ImmutableIndexWithStatsIT.java:52)
Caused by: java.io.IOException: Shutting down
at 
org.apache.phoenix.end2end.index.ImmutableIndexWithStatsIT.doSetup(ImmutableIndexWithStatsIT.java:52)
Caused by: java.lang.RuntimeException: Master not initialized after 20ms 
seconds
at 
org.apache.phoenix.end2end.index.ImmutableIndexWithStatsIT.doSetup(ImmutableIndexWithStatsIT.java:52)

Running org.apache.phoenix.end2end.index.MutableIndexFailureIT
Tests run: 1, Failures: 0, Errors: 1, Skipped: 0, Time elapsed: 0.008 sec <<< 
FAILURE! - in org.apache.phoenix.end2end.index.MutableIndexFailureIT
org.apache.phoenix.end2end.index.MutableIndexFailureIT  Time elapsed: 0.007 sec 
 <<< ERROR!
java.lang.RuntimeException: java.io.IOException: Shutting down
at 
org.apache.phoenix.end2end.index.MutableIndexFailureIT.doSetup(MutableIndexFailureIT.java:108)
Caused by: java.io.IOException: Shutting down
at 
org.apache.phoenix.end2end.index.MutableIndexFailureIT.doSetup(MutableIndexFailureIT.java:108)
Caused by: java.lang.RuntimeException: Master not initialized after 20ms 
seconds
at 
org.apache.phoenix.end2end.index.MutableIndexFailureIT.doSetup(MutableIndexFailureIT.java:108)

Running org.apache.phoenix.hbase.index.FailForUnsupportedHBaseVersionsIT
Running org.apache.phoenix.end2end.index.MutableIndexReplicationIT
Tests run: 1, Failures: 0, Errors: 1, Skipped: 0, Time elapsed: 0.007 sec <<< 
FAILURE! - in org.apache.phoenix.end2end.index.MutableIndexReplicationIT
org.apache.phoenix.end2end.index.MutableIndexReplicationIT  Time elapsed: 0.006 
sec  <<< ERROR!
java.io.IOException: Shutting down
at 
org.apache.phoenix.end2end.index.MutableIndexReplicationIT.setupConfigsAndStartCluster(MutableIndexReplicationIT.java:170)
at 
org.apache.phoenix.end2end.index.MutableIndexReplicationIT.setUpBeforeClass(MutableIndexReplicationIT.java:108)
Caused by: java.lang.RuntimeException: Master not initialized after 20ms 
seconds
at 
org.apache.phoenix.end2end.index.MutableIndexReplicationIT.setupConfigsAndStartCluster(MutableIndexReplicationIT.java:170)
at 
org.apache.phoenix.end2end.index.MutableIndexReplicationIT.setUpBeforeClass(MutableIndexReplicationIT.java:108)

Running org.apache.phoenix.end2end.index.ReadOnlyIndexFailureIT
Tests run: 1, Failures: 0, Errors: 1, Skipped: 0, Time elapsed: 0.004 sec <<< 
FAILURE! - in org.apache.phoenix.end2end.index.ReadOnlyIndexFailureIT
org.apache.phoenix.end2end.index.ReadOnlyIndexFailureIT  Time elapsed: 0.004 
sec  <<< ERROR!
java.lang.RuntimeException: java.io.IOException: Shutting down
at 
org.apache.phoenix.end2end.index.ReadOnlyIndexFailureIT.doSetup(ReadOnlyIndexFailureIT.java:116)
Caused by: java.io.IOException: Shutting down
at 
org.apache.phoenix.end2end.index.ReadOnlyIndexFailureIT.doSetup(ReadOnlyIndexFailureIT.java:116)
Caused by: java.lang.RuntimeException: Master not initialized after 20ms 
seconds
at 
org.apache.phoenix.end2end.index.ReadOnlyIndexFailureIT.doSetup(ReadOnlyIndexFailureIT.java:116)

Running org.apache.phoenix.end2end.index.txn.TxWriteFailureIT
Tests run: 1, Failures: 0, Errors: 1, Skipped: 0, Time elapsed: 0.004 sec <<< 
FAILURE! - in org.apache.phoenix.end2end.index.txn.TxWriteFailureIT
org.apache.phoenix.end2end.index.txn.TxWriteFailureIT  Time elapsed: 0.004 sec  
<<< ERROR!
java.lang.RuntimeException: java.io.IOException: Shutting down
at 
org.apache.phoenix.end2end.index.txn.TxWriteFailureIT.doSetup(TxWriteFailureIT.java:86)
Caused by: java.io.IOException: Shutting down
at 
org.apache.phoenix.end2end.index.txn.TxWriteFailureIT.doSetup(TxWriteFailureIT.java:86)
Caused by: java.lang.RuntimeException: Master not initialized after 20ms 
seconds
at 
org.apache.phoenix.end2end.index.txn.TxWriteFailureIT.doSetup(TxWriteFailureIT.java:86)

Running org.apache.phoenix.execute.PartialCommitIT
Tests run: 1, Failures: 0, Errors: 1, Skipped: 0, Time elapsed: 0.005 sec <<< 
FAILURE! - in org.apache.phoenix.execute.PartialCommitIT
org.apache.phoenix.execute.PartialCommitIT  Time elapsed: 0.004 sec  <<< ERROR!
java.lang.RuntimeException: java.io.IOException: Shutting down

[1/3] phoenix git commit: PHOENIX-2768 Add test for case sensitive table with index hint

2016-03-15 Thread jamestaylor 
Repository: phoenix
Updated Branches:
  refs/heads/4.x-HBase-0.98 f0b76dd80 -> 4ddf63ec9


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/0c93d298
Tree: http://git-wip-us.apache.org/repos/asf/phoenix/tree/0c93d298
Diff: http://git-wip-us.apache.org/repos/asf/phoenix/diff/0c93d298

Branch: refs/heads/4.x-HBase-0.98
Commit: 0c93d2981ae1b1ed21bfeaa470216829cffda0d5
Parents: f0b76dd
Author: James Taylor 
Authored: Mon Mar 14 20:33:03 2016 -0700
Committer: James Taylor 
Committed: Tue Mar 15 16:36:28 2016 -0700

--
 .../phoenix/compile/QueryOptimizerTest.java | 28 
 1 file changed, 28 insertions(+)
--


http://git-wip-us.apache.org/repos/asf/phoenix/blob/0c93d298/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.9

2016-03-15 Thread jamestaylor 
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/0e309c23
Tree: http://git-wip-us.apache.org/repos/asf/phoenix/tree/0e309c23
Diff: http://git-wip-us.apache.org/repos/asf/phoenix/diff/0e309c23

Branch: refs/heads/4.x-HBase-0.98
Commit: 0e309c233667a1a8a2ca6cc7a0c7a7e5b4bb8a9a
Parents: 0c93d29
Author: James Taylor 
Authored: Tue Mar 15 09:43:59 2016 -0700
Committer: James Taylor 
Committed: Tue Mar 15 16:36:50 2016 -0700

--
 pom.xml | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)
--


http://git-wip-us.apache.org/repos/asf/phoenix/blob/0e309c23/pom.xml
--
diff --git a/pom.xml b/pom.xml
index 8a17c3e..3d20a02 100644
--- a/pom.xml
+++ b/pom.xml
@@ -97,7 +97,7 @@
 2.5
 1.2
 1.0
-1.1.8
+1.1.9
 13.0.1
 1.4.0
 1.3.2

[3/3] phoenix git commit: PHOENIX-2773 Remove unnecessary repos in poms

2016-03-15 Thread jamestaylor 
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/4ddf63ec
Tree: http://git-wip-us.apache.org/repos/asf/phoenix/tree/4ddf63ec
Diff: http://git-wip-us.apache.org/repos/asf/phoenix/diff/4ddf63ec

Branch: refs/heads/4.x-HBase-0.98
Commit: 4ddf63ec9c189ebb565c55bfc273b304df41d62d
Parents: 0e309c2
Author: James Taylor 
Authored: Tue Mar 15 10:24:37 2016 -0700
Committer: James Taylor 
Committed: Tue Mar 15 16:37:01 2016 -0700

--
 pom.xml | 19 ---
 1 file changed, 19 deletions(-)
--


http://git-wip-us.apache.org/repos/asf/phoenix/blob/4ddf63ec/pom.xml
--
diff --git a/pom.xml b/pom.xml
index 3d20a02..e0eb2ee 100644
--- a/pom.xml
+++ b/pom.xml
@@ -39,25 +39,6 @@
   apache release
   https://repository.apache.org/content/repositories/releases/
 
-
-  conjars.org
-  http://conjars.org/repo
-
-
-  apache snapshot
-  https://repository.apache.org/content/repositories/snapshots/
-  
-true
-  
-
-
-  sonatype-nexus-snapshots
-  Sonatype Nexus Snapshots
-  https://oss.sonatype.org/content/repositories/snapshots
-  
-true
-  
-

[1/3] phoenix git commit: PHOENIX-2768 Add test for case sensitive table with index hint

2016-03-15 Thread jamestaylor 
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 
Authored: Mon Mar 14 20:33:03 2016 -0700
Committer: James Taylor 
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

2016-03-15 Thread jamestaylor 
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 
Authored: Tue Mar 15 10:24:37 2016 -0700
Committer: James Taylor 
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 @@
   apache release
   https://repository.apache.org/content/repositories/releases/
 
-
-  conjars.org
-  http://conjars.org/repo
-
-
-  apache snapshot
-  https://repository.apache.org/content/repositories/snapshots/
-  
-true
-  
-
-
-  sonatype-nexus-snapshots
-  Sonatype Nexus Snapshots
-  https://oss.sonatype.org/content/repositories/snapshots
-  
-true
-  
-

[2/3] phoenix git commit: PHOENIX-2772 Upgrade pom to sqlline 1.1.9

2016-03-15 Thread jamestaylor 
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 
Authored: Tue Mar 15 09:43:59 2016 -0700
Committer: James Taylor 
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 @@
 2.5
 1.2
 1.0
-1.1.8
+1.1.9
 13.0.1
 1.4.0
 1.3.2

[1/3] phoenix git commit: PHOENIX-2773 Remove unnecessary repos in poms

2016-03-15 Thread jamestaylor 
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 
Authored: Tue Mar 15 10:24:37 2016 -0700
Committer: James Taylor 
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 @@
   apache release
   https://repository.apache.org/content/repositories/releases/
 
-
-  conjars.org
-  http://conjars.org/repo
-
-
-  apache snapshot
-  https://repository.apache.org/content/repositories/snapshots/
-  
-true
-  
-
-
-  sonatype-nexus-snapshots
-  Sonatype Nexus Snapshots
-  https://oss.sonatype.org/content/repositories/snapshots
-  
-true
-  
-

[3/3] phoenix git commit: PHOENIX-2768 Add test for case sensitive table with index hint

2016-03-15 Thread jamestaylor 
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 
Authored: Mon Mar 14 20:33:03 2016 -0700
Committer: James Taylor 
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

2016-03-15 Thread jamestaylor 
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 
Authored: Tue Mar 15 09:43:59 2016 -0700
Committer: James Taylor 
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 @@
 2.5
 1.2
 1.0
-1.1.8
+1.1.9
 13.0.1
 1.4.0
 1.3.2