Build failed in Jenkins: Phoenix-4.x-HBase-1.1 #50

[Apache Jenkins Server]

See 

Changes:

[larsh] Revert "PHOENIX-2965 Use DistinctPrefixFilter logic for COUNT(DISTINCT

--
[...truncated 2082 lines...]
Caused by: java.io.IOException: Shutting down
Caused by: java.lang.RuntimeException: Master not initialized after 20ms 
seconds

Running org.apache.phoenix.end2end.index.ImmutableIndexWithStatsIT
Tests run: 1, Failures: 0, Errors: 1, Skipped: 0, Time elapsed: 0.006 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
Running org.apache.phoenix.end2end.index.MutableIndexReplicationIT
Tests run: 1, Failures: 0, Errors: 1, Skipped: 0, Time elapsed: 0.006 sec <<< 
FAILURE! - in org.apache.phoenix.end2end.index.MutableIndexFailureIT
org.apache.phoenix.end2end.index.MutableIndexFailureIT  Time elapsed: 0.005 sec 
 <<< ERROR!
java.lang.RuntimeException: java.io.IOException: Shutting down
at 
org.apache.phoenix.end2end.index.MutableIndexFailureIT.doSetup(MutableIndexFailureIT.java:113)
Caused by: java.io.IOException: Shutting down
at 
org.apache.phoenix.end2end.index.MutableIndexFailureIT.doSetup(MutableIndexFailureIT.java:113)
Caused by: java.lang.RuntimeException: Master not initialized after 20ms 
seconds
at 
org.apache.phoenix.end2end.index.MutableIndexFailureIT.doSetup(MutableIndexFailureIT.java:113)

Running org.apache.phoenix.hbase.index.FailForUnsupportedHBaseVersionsIT
Tests run: 1, Failures: 0, Errors: 1, Skipped: 0, Time elapsed: 0.004 sec <<< 
FAILURE! - in org.apache.phoenix.end2end.index.MutableIndexReplicationIT
org.apache.phoenix.end2end.index.MutableIndexReplicationIT  Time elapsed: 0.004 
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.006 sec <<< 
FAILURE! - in org.apache.phoenix.end2end.index.ReadOnlyIndexFailureIT
org.apache.phoenix.end2end.index.ReadOnlyIndexFailureIT  Time elapsed: 0.005 
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.006 sec <<< 
FAILURE! - in org.apache.phoenix.end2end.index.txn.TxWriteFailureIT
org.apache.phoenix.end2end.index.txn.TxWriteFailureIT  Time elapsed: 0.005 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.006 sec <<< 
FAILURE! - in org.apache.phoenix.execute.PartialCommitIT
org.apache.phoenix.execute.PartialCommitIT  Time elapsed: 0.005 sec  <<< ERROR!
java.lang.RuntimeException: 

Build failed in Jenkins: Phoenix-4.x-HBase-1.0 #497

[Apache Jenkins Server]

See 

Changes:

[larsh] PHOENIX-2986 Some queries are misoptimized by PHOENIX-258.

--
[...truncated 686 lines...]
Tests run: 7, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 19.298 sec - in 
org.apache.phoenix.rpc.UpdateCacheIT
Running org.apache.phoenix.trace.PhoenixTableMetricsWriterIT
Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 1.889 sec - in 
org.apache.phoenix.trace.PhoenixTableMetricsWriterIT
Running org.apache.phoenix.trace.PhoenixTraceReaderIT
Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.662 sec - in 
org.apache.phoenix.trace.PhoenixTraceReaderIT
Running org.apache.phoenix.trace.PhoenixTracingEndToEndIT
Tests run: 9, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 62.605 sec - in 
org.apache.phoenix.iterate.RoundRobinResultIteratorIT
Running org.apache.phoenix.tx.TransactionIT
Tests run: 28, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 222.845 sec - 
in org.apache.phoenix.end2end.index.MutableIndexIT
Running org.apache.phoenix.tx.TxCheckpointIT
Tests run: 40, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 289.292 sec - 
in org.apache.phoenix.end2end.index.LocalIndexIT
Tests run: 6, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 85.98 sec - in 
org.apache.phoenix.trace.PhoenixTracingEndToEndIT
Tests run: 20, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 78.556 sec - 
in org.apache.phoenix.tx.TxCheckpointIT
Tests run: 21, Failures: 0, Errors: 0, Skipped: 1, Time elapsed: 145.391 sec - 
in org.apache.phoenix.tx.TransactionIT
Tests run: 128, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 482.827 sec - 
in org.apache.phoenix.end2end.index.IndexIT

Results :

Tests run: 1177, Failures: 0, Errors: 0, Skipped: 5

[INFO] 
[INFO] --- maven-failsafe-plugin:2.19.1:integration-test 
(HBaseManagedTimeTableReuseTest) @ phoenix-core ---

---
 T E S T S
---
Running org.apache.phoenix.end2end.ArrayFillFunctionIT
Running org.apache.phoenix.end2end.AbsFunctionEnd2EndIT
Running org.apache.phoenix.end2end.ArithmeticQueryIT
Running org.apache.phoenix.end2end.AlterSessionIT
Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.132 sec - in 
org.apache.phoenix.end2end.AlterSessionIT
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 1.246 sec - in 
org.apache.phoenix.end2end.AbsFunctionEnd2EndIT
Running org.apache.phoenix.end2end.ArraysWithNullsIT
Running org.apache.phoenix.end2end.AutoCommitIT
Running org.apache.phoenix.end2end.ArrayToStringFunctionIT
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 1.367 sec - in 
org.apache.phoenix.end2end.AutoCommitIT
Running org.apache.phoenix.end2end.CbrtFunctionEnd2EndIT
Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.458 sec - in 
org.apache.phoenix.end2end.CbrtFunctionEnd2EndIT
Running org.apache.phoenix.end2end.ConvertTimezoneFunctionIT
Tests run: 26, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 7.83 sec - in 
org.apache.phoenix.end2end.ArrayFillFunctionIT
Running org.apache.phoenix.end2end.DecodeFunctionIT
Tests run: 7, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 5.871 sec - in 
org.apache.phoenix.end2end.ConvertTimezoneFunctionIT
Tests run: 36, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 12.723 sec - 
in org.apache.phoenix.end2end.ArrayToStringFunctionIT
Tests run: 6, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 7.737 sec - in 
org.apache.phoenix.end2end.DecodeFunctionIT
Running org.apache.phoenix.end2end.DynamicFamilyIT
Running org.apache.phoenix.end2end.DistinctPrefixFilterIT
Running org.apache.phoenix.end2end.DynamicUpsertIT
Tests run: 7, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.124 sec - in 
org.apache.phoenix.end2end.DynamicUpsertIT
Running org.apache.phoenix.end2end.FirstValueFunctionIT
Tests run: 4, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 2.849 sec - in 
org.apache.phoenix.end2end.DynamicFamilyIT
Tests run: 16, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 18.278 sec - 
in org.apache.phoenix.end2end.ArraysWithNullsIT
Running org.apache.phoenix.end2end.GetSetByteBitFunctionEnd2EndIT
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.137 sec - in 
org.apache.phoenix.end2end.GetSetByteBitFunctionEnd2EndIT
Running org.apache.phoenix.end2end.MD5FunctionIT
Running org.apache.phoenix.end2end.LikeExpressionIT
Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 2.134 sec - in 
org.apache.phoenix.end2end.LikeExpressionIT
Running org.apache.phoenix.end2end.MinMaxAggregateFunctionIT
Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 3.959 sec - in 
org.apache.phoenix.end2end.MD5FunctionIT
Tests run: 7, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 7.575 sec - in 
org.apache.phoenix.end2end.FirstValueFunctionIT
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time 

Jenkins build is back to normal : Phoenix-4.x-HBase-1.0 #496

[Apache Jenkins Server]

See 

Build failed in Jenkins: Phoenix | 4.x-HBase-0.98 #1175

[Apache Jenkins Server]

See 

Changes:

[larsh] PHOENIX-2986 Some queries are misoptimized by PHOENIX-258.

--
Started by an SCM change
[EnvInject] - Loading node environment variables.
Building remotely on ubuntu-1 (docker Ubuntu ubuntu yahoo-not-h2 ubuntu1) in 
workspace 
 > git rev-parse --is-inside-work-tree # timeout=10
Fetching changes from the remote Git repository
 > git config remote.origin.url 
 > https://git-wip-us.apache.org/repos/asf/phoenix.git # timeout=10
Fetching upstream changes from 
https://git-wip-us.apache.org/repos/asf/phoenix.git
 > git --version # timeout=10
 > git -c core.askpass=true fetch --tags --progress 
 > https://git-wip-us.apache.org/repos/asf/phoenix.git 
 > +refs/heads/*:refs/remotes/origin/*
 > git rev-parse origin/4.x-HBase-0.98^{commit} # timeout=10
Checking out Revision 7cc8a98e277c4250c15a29df90fff527fbe22a0f 
(origin/4.x-HBase-0.98)
 > git config core.sparsecheckout # timeout=10
 > git checkout -f 7cc8a98e277c4250c15a29df90fff527fbe22a0f
 > git rev-list 3a8d272c82ea2b5e6b0965272258b1f7319407e0 # timeout=10
No emails were triggered.
[EnvInject] - Executing scripts and injecting environment variables after the 
SCM step.
[EnvInject] - Injecting as environment variables the properties content 
MAVEN_OPTS=-Xmx3G

[EnvInject] - Variables injected successfully.
[Phoenix-4.x-HBase-0.98] $ /bin/bash -xe /tmp/hudson2495825495606088676.sh
+ echo 'DELETING ~/.m2/repository/org/apache/htrace. See 
https://issues.apache.org/jira/browse/PHOENIX-1802'
DELETING ~/.m2/repository/org/apache/htrace. See 
https://issues.apache.org/jira/browse/PHOENIX-1802
+ echo 'CURRENT CONTENT:'
CURRENT CONTENT:
+ ls /home/jenkins/.m2/repository/org/apache/htrace
ls: cannot access /home/jenkins/.m2/repository/org/apache/htrace: No such file 
or directory
+ :
FATAL: Failed to install 
https://repo.maven.apache.org/maven2/org/apache/maven/apache-maven/3.0.4/apache-maven-3.0.4-bin.zip
 to /home/jenkins/tools/maven/apache-maven-3.0.4
java.io.IOException: Failed to install 
https://repo.maven.apache.org/maven2/org/apache/maven/apache-maven/3.0.4/apache-maven-3.0.4-bin.zip
 to /home/jenkins/tools/maven/apache-maven-3.0.4
at hudson.FilePath.installIfNecessaryFrom(FilePath.java:832)
at 
hudson.tools.DownloadFromUrlInstaller.performInstallation(DownloadFromUrlInstaller.java:75)
at 
hudson.tools.InstallerTranslator.getToolHome(InstallerTranslator.java:68)
at 
hudson.tools.ToolLocationNodeProperty.getToolHome(ToolLocationNodeProperty.java:108)
at hudson.tools.ToolInstallation.translateFor(ToolInstallation.java:206)
at hudson.tasks.Maven$MavenInstallation.forNode(Maven.java:624)
at hudson.tasks.Maven.perform(Maven.java:288)
at hudson.tasks.BuildStepMonitor$1.perform(BuildStepMonitor.java:20)
at 
hudson.model.AbstractBuild$AbstractBuildExecution.perform(AbstractBuild.java:782)
at hudson.model.Build$BuildExecution.build(Build.java:205)
at hudson.model.Build$BuildExecution.doRun(Build.java:162)
at 
hudson.model.AbstractBuild$AbstractBuildExecution.run(AbstractBuild.java:534)
at hudson.model.Run.execute(Run.java:1738)
at hudson.model.FreeStyleBuild.run(FreeStyleBuild.java:43)
at hudson.model.ResourceController.execute(ResourceController.java:98)
at hudson.model.Executor.run(Executor.java:410)
Caused by: java.io.IOException: remote file operation failed: 
/home/jenkins/tools/maven/apache-maven-3.0.4 at 
hudson.remoting.Channel@2be9fe6d:ubuntu-1: java.nio.file.AccessDeniedException: 
/home/jenkins/tools/maven/apache-maven-3.0.4/conf/settings.xml
at hudson.FilePath.act(FilePath.java:986)
at hudson.FilePath.act(FilePath.java:968)
at hudson.FilePath.deleteContents(FilePath.java:1183)
at hudson.FilePath.installIfNecessaryFrom(FilePath.java:796)
... 15 more
Caused by: java.nio.file.AccessDeniedException: 
/home/jenkins/tools/maven/apache-maven-3.0.4/conf/settings.xml
at 
sun.nio.fs.UnixException.translateToIOException(UnixException.java:84)
at sun.nio.fs.UnixException.rethrowAsIOException(UnixException.java:102)
at sun.nio.fs.UnixException.rethrowAsIOException(UnixException.java:107)
at 
sun.nio.fs.UnixFileSystemProvider.implDelete(UnixFileSystemProvider.java:244)
at 
sun.nio.fs.AbstractFileSystemProvider.delete(AbstractFileSystemProvider.java:103)
at java.nio.file.Files.delete(Files.java:1077)
at sun.reflect.GeneratedMethodAccessor2276.invoke(Unknown Source)
at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at hudson.Util.deleteFile(Util.java:255)
at hudson.FilePath.deleteRecursive(FilePath.java:1203)
at 

Build failed in Jenkins: Phoenix | Master #1254

[Apache Jenkins Server]

See 

Changes:

[larsh] PHOENIX-2986 Some queries are misoptimized by PHOENIX-258.

--
Started by an SCM change
[EnvInject] - Loading node environment variables.
Building remotely on ubuntu-1 (docker Ubuntu ubuntu yahoo-not-h2 ubuntu1) in 
workspace 
 > git rev-parse --is-inside-work-tree # timeout=10
Fetching changes from the remote Git repository
 > git config remote.origin.url 
 > https://git-wip-us.apache.org/repos/asf/phoenix.git # timeout=10
Fetching upstream changes from 
https://git-wip-us.apache.org/repos/asf/phoenix.git
 > git --version # timeout=10
 > git -c core.askpass=true fetch --tags --progress 
 > https://git-wip-us.apache.org/repos/asf/phoenix.git 
 > +refs/heads/*:refs/remotes/origin/*
 > git rev-parse origin/master^{commit} # timeout=10
Checking out Revision af51d5607121c4924eb143c8eeb8b527581f9beb (origin/master)
 > git config core.sparsecheckout # timeout=10
 > git checkout -f af51d5607121c4924eb143c8eeb8b527581f9beb
 > git rev-list a4d498f349193610003b888fc501f5ce146e99b0 # timeout=10
No emails were triggered.
[EnvInject] - Executing scripts and injecting environment variables after the 
SCM step.
[EnvInject] - Injecting as environment variables the properties content 
MAVEN_OPTS=-Xmx3G

[EnvInject] - Variables injected successfully.
[Phoenix-master] $ /bin/bash -xe /tmp/hudson1997015276688873538.sh
+ ls /home/jenkins/.m2/repository/org/apache/htrace
ls: cannot access /home/jenkins/.m2/repository/org/apache/htrace: No such file 
or directory
+ :
+ ls /home/jenkins/.m2/repository/org/apache/hbase
ls: cannot access /home/jenkins/.m2/repository/org/apache/hbase: No such file 
or directory
+ :
FATAL: Failed to install 
https://repo.maven.apache.org/maven2/org/apache/maven/apache-maven/3.0.4/apache-maven-3.0.4-bin.zip
 to /home/jenkins/tools/maven/apache-maven-3.0.4
java.io.IOException: Failed to install 
https://repo.maven.apache.org/maven2/org/apache/maven/apache-maven/3.0.4/apache-maven-3.0.4-bin.zip
 to /home/jenkins/tools/maven/apache-maven-3.0.4
at hudson.FilePath.installIfNecessaryFrom(FilePath.java:832)
at 
hudson.tools.DownloadFromUrlInstaller.performInstallation(DownloadFromUrlInstaller.java:75)
at 
hudson.tools.InstallerTranslator.getToolHome(InstallerTranslator.java:68)
at 
hudson.tools.ToolLocationNodeProperty.getToolHome(ToolLocationNodeProperty.java:108)
at hudson.tools.ToolInstallation.translateFor(ToolInstallation.java:206)
at hudson.tasks.Maven$MavenInstallation.forNode(Maven.java:624)
at hudson.tasks.Maven.perform(Maven.java:288)
at hudson.tasks.BuildStepMonitor$1.perform(BuildStepMonitor.java:20)
at 
hudson.model.AbstractBuild$AbstractBuildExecution.perform(AbstractBuild.java:782)
at hudson.model.Build$BuildExecution.build(Build.java:205)
at hudson.model.Build$BuildExecution.doRun(Build.java:162)
at 
hudson.model.AbstractBuild$AbstractBuildExecution.run(AbstractBuild.java:534)
at hudson.model.Run.execute(Run.java:1738)
at hudson.model.FreeStyleBuild.run(FreeStyleBuild.java:43)
at hudson.model.ResourceController.execute(ResourceController.java:98)
at hudson.model.Executor.run(Executor.java:410)
Caused by: java.io.IOException: remote file operation failed: 
/home/jenkins/tools/maven/apache-maven-3.0.4 at 
hudson.remoting.Channel@2be9fe6d:ubuntu-1: java.nio.file.AccessDeniedException: 
/home/jenkins/tools/maven/apache-maven-3.0.4/conf/settings.xml
at hudson.FilePath.act(FilePath.java:986)
at hudson.FilePath.act(FilePath.java:968)
at hudson.FilePath.deleteContents(FilePath.java:1183)
at hudson.FilePath.installIfNecessaryFrom(FilePath.java:796)
... 15 more
Caused by: java.nio.file.AccessDeniedException: 
/home/jenkins/tools/maven/apache-maven-3.0.4/conf/settings.xml
at 
sun.nio.fs.UnixException.translateToIOException(UnixException.java:84)
at sun.nio.fs.UnixException.rethrowAsIOException(UnixException.java:102)
at sun.nio.fs.UnixException.rethrowAsIOException(UnixException.java:107)
at 
sun.nio.fs.UnixFileSystemProvider.implDelete(UnixFileSystemProvider.java:244)
at 
sun.nio.fs.AbstractFileSystemProvider.delete(AbstractFileSystemProvider.java:103)
at java.nio.file.Files.delete(Files.java:1077)
at sun.reflect.GeneratedMethodAccessor2276.invoke(Unknown Source)
at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at hudson.Util.deleteFile(Util.java:255)
at hudson.FilePath.deleteRecursive(FilePath.java:1203)
at hudson.FilePath.deleteContentsRecursive(FilePath.java:1212)
at hudson.FilePath.deleteRecursive(FilePath.java:1194)
at 

phoenix git commit: PHOENIX-2986 Some queries are misoptimized by PHOENIX-258.

[larsh]

Repository: phoenix
Updated Branches:
  refs/heads/master a4d498f34 -> af51d5607


PHOENIX-2986 Some queries are misoptimized by PHOENIX-258.


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

Branch: refs/heads/master
Commit: af51d5607121c4924eb143c8eeb8b527581f9beb
Parents: a4d498f
Author: Lars Hofhansl 
Authored: Fri Jun 10 19:33:19 2016 -0700
Committer: Lars Hofhansl 
Committed: Fri Jun 10 19:34:30 2016 -0700

--
 .../phoenix/end2end/DistinctPrefixFilterIT.java | 167 +--
 .../phoenix/iterate/BaseResultIterators.java|   3 +-
 2 files changed, 77 insertions(+), 93 deletions(-)
--


http://git-wip-us.apache.org/repos/asf/phoenix/blob/af51d560/phoenix-core/src/it/java/org/apache/phoenix/end2end/DistinctPrefixFilterIT.java
--
diff --git 
a/phoenix-core/src/it/java/org/apache/phoenix/end2end/DistinctPrefixFilterIT.java
 
b/phoenix-core/src/it/java/org/apache/phoenix/end2end/DistinctPrefixFilterIT.java
index c2776ed..4050314 100644
--- 
a/phoenix-core/src/it/java/org/apache/phoenix/end2end/DistinctPrefixFilterIT.java
+++ 
b/phoenix-core/src/it/java/org/apache/phoenix/end2end/DistinctPrefixFilterIT.java
@@ -19,9 +19,10 @@ import org.junit.BeforeClass;
 import org.junit.Test;
 
 public class DistinctPrefixFilterIT extends BaseHBaseManagedTimeTableReuseIT {
-private static String testTableF = generateRandomString();
-private static String testTableV = generateRandomString();
-private static String testSeq = testTableF + "_seq";
+private static final String testTableF = generateRandomString();
+private static final String testTableV = generateRandomString();
+private static final String testSeq = testTableF + "_seq";
+private static final String PREFIX = "SERVER DISTINCT PREFIX";
 private static Connection conn;
 
 @BeforeClass
@@ -118,104 +119,55 @@ public class DistinctPrefixFilterIT extends 
BaseHBaseManagedTimeTableReuseIT {
 
 @Test
 public void testPlans() throws Exception {
-final String PREFIX = "SERVER DISTINCT PREFIX";
-
 // use the filter even when the SkipScan filter is used
-String dataSql = "SELECT DISTINCT prefix1, prefix2 FROM "+testTableF+ 
" WHERE prefix1 IN (1,2)";
-ResultSet rs = conn.createStatement().executeQuery("EXPLAIN "+dataSql);
-assertTrue(QueryUtil.getExplainPlan(rs).contains(PREFIX));
-
-dataSql = "SELECT prefix1, 1, 2 FROM "+testTableF+" GROUP BY prefix1 
HAVING prefix1 = 1";
-rs = conn.createStatement().executeQuery("EXPLAIN "+dataSql);
-assertTrue(QueryUtil.getExplainPlan(rs).contains(PREFIX));
-
-dataSql = "SELECT prefix1 FROM "+testTableF+" GROUP BY prefix1, 
TRUNC(prefix1), TRUNC(prefix2)";
-rs = conn.createStatement().executeQuery("EXPLAIN "+dataSql);
-assertTrue(QueryUtil.getExplainPlan(rs).contains(PREFIX));
-
-dataSql = "SELECT DISTINCT prefix1, prefix2 FROM "+testTableV+ " WHERE 
prefix1 IN ('1','2')";
-rs = conn.createStatement().executeQuery("EXPLAIN "+dataSql);
-assertTrue(QueryUtil.getExplainPlan(rs).contains(PREFIX));
-
-dataSql = "SELECT prefix1, 1, 2 FROM "+testTableV+" GROUP BY prefix1 
HAVING prefix1 = '1'";
-rs = conn.createStatement().executeQuery("EXPLAIN "+dataSql);
-assertTrue(QueryUtil.getExplainPlan(rs).contains(PREFIX));
+testPlan("SELECT DISTINCT prefix1, prefix2 FROM "+testTableF+ " WHERE 
prefix1 IN (1,2)", true);
+testPlan("SELECT prefix1, 1, 2 FROM "+testTableF+" GROUP BY prefix1 
HAVING prefix1 = 1", true);
+testPlan("SELECT prefix1 FROM "+testTableF+" GROUP BY prefix1, 
TRUNC(prefix1), TRUNC(prefix2)", true);
+testPlan("SELECT DISTINCT prefix1, prefix2 FROM "+testTableV+ " WHERE 
prefix1 IN ('1','2')", true);
+testPlan("SELECT prefix1, 1, 2 FROM "+testTableV+" GROUP BY prefix1 
HAVING prefix1 = '1'", true);
+// make sure we do not mis-optimize this case
+testPlan("SELECT DISTINCT SUM(prefix1) FROM "+testTableF+" GROUP BY 
prefix1", false);
 
 testCommonPlans(testTableF, PREFIX);
 testCommonPlans(testTableV, PREFIX);
 }
 
 private void testCommonPlans(String testTable, String contains) throws 
Exception {
-
-String dataSql = "SELECT DISTINCT prefix1 FROM "+testTable;
-ResultSet rs = conn.createStatement().executeQuery("EXPLAIN "+dataSql);
-assertTrue(QueryUtil.getExplainPlan(rs).contains(contains));
-
-dataSql = "SELECT /*+ RANGE_SCAN */ DISTINCT prefix1 FROM "+testTable;
-rs = 

phoenix git commit: PHOENIX-2986 Some queries are misoptimized by PHOENIX-258.

[larsh]

Repository: phoenix
Updated Branches:
  refs/heads/4.x-HBase-1.1 54349d060 -> fa88fb254


PHOENIX-2986 Some queries are misoptimized by PHOENIX-258.


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

Branch: refs/heads/4.x-HBase-1.1
Commit: fa88fb2549a266a5da566b0497f889ac8131
Parents: 54349d0
Author: Lars Hofhansl 
Authored: Fri Jun 10 19:33:19 2016 -0700
Committer: Lars Hofhansl 
Committed: Fri Jun 10 19:34:15 2016 -0700

--
 .../phoenix/end2end/DistinctPrefixFilterIT.java | 167 +--
 .../phoenix/iterate/BaseResultIterators.java|   3 +-
 2 files changed, 77 insertions(+), 93 deletions(-)
--


http://git-wip-us.apache.org/repos/asf/phoenix/blob/fa88fb25/phoenix-core/src/it/java/org/apache/phoenix/end2end/DistinctPrefixFilterIT.java
--
diff --git 
a/phoenix-core/src/it/java/org/apache/phoenix/end2end/DistinctPrefixFilterIT.java
 
b/phoenix-core/src/it/java/org/apache/phoenix/end2end/DistinctPrefixFilterIT.java
index c2776ed..4050314 100644
--- 
a/phoenix-core/src/it/java/org/apache/phoenix/end2end/DistinctPrefixFilterIT.java
+++ 
b/phoenix-core/src/it/java/org/apache/phoenix/end2end/DistinctPrefixFilterIT.java
@@ -19,9 +19,10 @@ import org.junit.BeforeClass;
 import org.junit.Test;
 
 public class DistinctPrefixFilterIT extends BaseHBaseManagedTimeTableReuseIT {
-private static String testTableF = generateRandomString();
-private static String testTableV = generateRandomString();
-private static String testSeq = testTableF + "_seq";
+private static final String testTableF = generateRandomString();
+private static final String testTableV = generateRandomString();
+private static final String testSeq = testTableF + "_seq";
+private static final String PREFIX = "SERVER DISTINCT PREFIX";
 private static Connection conn;
 
 @BeforeClass
@@ -118,104 +119,55 @@ public class DistinctPrefixFilterIT extends 
BaseHBaseManagedTimeTableReuseIT {
 
 @Test
 public void testPlans() throws Exception {
-final String PREFIX = "SERVER DISTINCT PREFIX";
-
 // use the filter even when the SkipScan filter is used
-String dataSql = "SELECT DISTINCT prefix1, prefix2 FROM "+testTableF+ 
" WHERE prefix1 IN (1,2)";
-ResultSet rs = conn.createStatement().executeQuery("EXPLAIN "+dataSql);
-assertTrue(QueryUtil.getExplainPlan(rs).contains(PREFIX));
-
-dataSql = "SELECT prefix1, 1, 2 FROM "+testTableF+" GROUP BY prefix1 
HAVING prefix1 = 1";
-rs = conn.createStatement().executeQuery("EXPLAIN "+dataSql);
-assertTrue(QueryUtil.getExplainPlan(rs).contains(PREFIX));
-
-dataSql = "SELECT prefix1 FROM "+testTableF+" GROUP BY prefix1, 
TRUNC(prefix1), TRUNC(prefix2)";
-rs = conn.createStatement().executeQuery("EXPLAIN "+dataSql);
-assertTrue(QueryUtil.getExplainPlan(rs).contains(PREFIX));
-
-dataSql = "SELECT DISTINCT prefix1, prefix2 FROM "+testTableV+ " WHERE 
prefix1 IN ('1','2')";
-rs = conn.createStatement().executeQuery("EXPLAIN "+dataSql);
-assertTrue(QueryUtil.getExplainPlan(rs).contains(PREFIX));
-
-dataSql = "SELECT prefix1, 1, 2 FROM "+testTableV+" GROUP BY prefix1 
HAVING prefix1 = '1'";
-rs = conn.createStatement().executeQuery("EXPLAIN "+dataSql);
-assertTrue(QueryUtil.getExplainPlan(rs).contains(PREFIX));
+testPlan("SELECT DISTINCT prefix1, prefix2 FROM "+testTableF+ " WHERE 
prefix1 IN (1,2)", true);
+testPlan("SELECT prefix1, 1, 2 FROM "+testTableF+" GROUP BY prefix1 
HAVING prefix1 = 1", true);
+testPlan("SELECT prefix1 FROM "+testTableF+" GROUP BY prefix1, 
TRUNC(prefix1), TRUNC(prefix2)", true);
+testPlan("SELECT DISTINCT prefix1, prefix2 FROM "+testTableV+ " WHERE 
prefix1 IN ('1','2')", true);
+testPlan("SELECT prefix1, 1, 2 FROM "+testTableV+" GROUP BY prefix1 
HAVING prefix1 = '1'", true);
+// make sure we do not mis-optimize this case
+testPlan("SELECT DISTINCT SUM(prefix1) FROM "+testTableF+" GROUP BY 
prefix1", false);
 
 testCommonPlans(testTableF, PREFIX);
 testCommonPlans(testTableV, PREFIX);
 }
 
 private void testCommonPlans(String testTable, String contains) throws 
Exception {
-
-String dataSql = "SELECT DISTINCT prefix1 FROM "+testTable;
-ResultSet rs = conn.createStatement().executeQuery("EXPLAIN "+dataSql);
-assertTrue(QueryUtil.getExplainPlan(rs).contains(contains));
-
-dataSql = "SELECT /*+ RANGE_SCAN */ DISTINCT prefix1 FROM "+testTable;
-

phoenix git commit: PHOENIX-2986 Some queries are misoptimized by PHOENIX-258.

[larsh]

Repository: phoenix
Updated Branches:
  refs/heads/4.x-HBase-0.98 3a8d272c8 -> 7cc8a98e2


PHOENIX-2986 Some queries are misoptimized by PHOENIX-258.


Project: http://git-wip-us.apache.org/repos/asf/phoenix/repo
Commit: http://git-wip-us.apache.org/repos/asf/phoenix/commit/7cc8a98e
Tree: http://git-wip-us.apache.org/repos/asf/phoenix/tree/7cc8a98e
Diff: http://git-wip-us.apache.org/repos/asf/phoenix/diff/7cc8a98e

Branch: refs/heads/4.x-HBase-0.98
Commit: 7cc8a98e277c4250c15a29df90fff527fbe22a0f
Parents: 3a8d272
Author: Lars Hofhansl 
Authored: Fri Jun 10 19:33:19 2016 -0700
Committer: Lars Hofhansl 
Committed: Fri Jun 10 19:33:19 2016 -0700

--
 .../phoenix/end2end/DistinctPrefixFilterIT.java | 167 +--
 .../phoenix/iterate/BaseResultIterators.java|   3 +-
 2 files changed, 77 insertions(+), 93 deletions(-)
--


http://git-wip-us.apache.org/repos/asf/phoenix/blob/7cc8a98e/phoenix-core/src/it/java/org/apache/phoenix/end2end/DistinctPrefixFilterIT.java
--
diff --git 
a/phoenix-core/src/it/java/org/apache/phoenix/end2end/DistinctPrefixFilterIT.java
 
b/phoenix-core/src/it/java/org/apache/phoenix/end2end/DistinctPrefixFilterIT.java
index c2776ed..4050314 100644
--- 
a/phoenix-core/src/it/java/org/apache/phoenix/end2end/DistinctPrefixFilterIT.java
+++ 
b/phoenix-core/src/it/java/org/apache/phoenix/end2end/DistinctPrefixFilterIT.java
@@ -19,9 +19,10 @@ import org.junit.BeforeClass;
 import org.junit.Test;
 
 public class DistinctPrefixFilterIT extends BaseHBaseManagedTimeTableReuseIT {
-private static String testTableF = generateRandomString();
-private static String testTableV = generateRandomString();
-private static String testSeq = testTableF + "_seq";
+private static final String testTableF = generateRandomString();
+private static final String testTableV = generateRandomString();
+private static final String testSeq = testTableF + "_seq";
+private static final String PREFIX = "SERVER DISTINCT PREFIX";
 private static Connection conn;
 
 @BeforeClass
@@ -118,104 +119,55 @@ public class DistinctPrefixFilterIT extends 
BaseHBaseManagedTimeTableReuseIT {
 
 @Test
 public void testPlans() throws Exception {
-final String PREFIX = "SERVER DISTINCT PREFIX";
-
 // use the filter even when the SkipScan filter is used
-String dataSql = "SELECT DISTINCT prefix1, prefix2 FROM "+testTableF+ 
" WHERE prefix1 IN (1,2)";
-ResultSet rs = conn.createStatement().executeQuery("EXPLAIN "+dataSql);
-assertTrue(QueryUtil.getExplainPlan(rs).contains(PREFIX));
-
-dataSql = "SELECT prefix1, 1, 2 FROM "+testTableF+" GROUP BY prefix1 
HAVING prefix1 = 1";
-rs = conn.createStatement().executeQuery("EXPLAIN "+dataSql);
-assertTrue(QueryUtil.getExplainPlan(rs).contains(PREFIX));
-
-dataSql = "SELECT prefix1 FROM "+testTableF+" GROUP BY prefix1, 
TRUNC(prefix1), TRUNC(prefix2)";
-rs = conn.createStatement().executeQuery("EXPLAIN "+dataSql);
-assertTrue(QueryUtil.getExplainPlan(rs).contains(PREFIX));
-
-dataSql = "SELECT DISTINCT prefix1, prefix2 FROM "+testTableV+ " WHERE 
prefix1 IN ('1','2')";
-rs = conn.createStatement().executeQuery("EXPLAIN "+dataSql);
-assertTrue(QueryUtil.getExplainPlan(rs).contains(PREFIX));
-
-dataSql = "SELECT prefix1, 1, 2 FROM "+testTableV+" GROUP BY prefix1 
HAVING prefix1 = '1'";
-rs = conn.createStatement().executeQuery("EXPLAIN "+dataSql);
-assertTrue(QueryUtil.getExplainPlan(rs).contains(PREFIX));
+testPlan("SELECT DISTINCT prefix1, prefix2 FROM "+testTableF+ " WHERE 
prefix1 IN (1,2)", true);
+testPlan("SELECT prefix1, 1, 2 FROM "+testTableF+" GROUP BY prefix1 
HAVING prefix1 = 1", true);
+testPlan("SELECT prefix1 FROM "+testTableF+" GROUP BY prefix1, 
TRUNC(prefix1), TRUNC(prefix2)", true);
+testPlan("SELECT DISTINCT prefix1, prefix2 FROM "+testTableV+ " WHERE 
prefix1 IN ('1','2')", true);
+testPlan("SELECT prefix1, 1, 2 FROM "+testTableV+" GROUP BY prefix1 
HAVING prefix1 = '1'", true);
+// make sure we do not mis-optimize this case
+testPlan("SELECT DISTINCT SUM(prefix1) FROM "+testTableF+" GROUP BY 
prefix1", false);
 
 testCommonPlans(testTableF, PREFIX);
 testCommonPlans(testTableV, PREFIX);
 }
 
 private void testCommonPlans(String testTable, String contains) throws 
Exception {
-
-String dataSql = "SELECT DISTINCT prefix1 FROM "+testTable;
-ResultSet rs = conn.createStatement().executeQuery("EXPLAIN "+dataSql);
-assertTrue(QueryUtil.getExplainPlan(rs).contains(contains));
-
-dataSql = "SELECT /*+ RANGE_SCAN */ DISTINCT prefix1 FROM "+testTable;
-  

Build failed in Jenkins: Phoenix | 4.x-HBase-0.98 #1174

[Apache Jenkins Server]

See 

Changes:

[larsh] Revert "PHOENIX-2965 Use DistinctPrefixFilter logic for COUNT(DISTINCT

--
Started by an SCM change
[EnvInject] - Loading node environment variables.
Building remotely on ubuntu-1 (docker Ubuntu ubuntu yahoo-not-h2 ubuntu1) in 
workspace 
Cloning the remote Git repository
Cloning repository https://git-wip-us.apache.org/repos/asf/phoenix.git
 > git init  # 
 > timeout=10
Fetching upstream changes from 
https://git-wip-us.apache.org/repos/asf/phoenix.git
 > git --version # timeout=10
 > git -c core.askpass=true fetch --tags --progress 
 > https://git-wip-us.apache.org/repos/asf/phoenix.git 
 > +refs/heads/*:refs/remotes/origin/*
 > git config remote.origin.url 
 > https://git-wip-us.apache.org/repos/asf/phoenix.git # timeout=10
 > git config --add remote.origin.fetch +refs/heads/*:refs/remotes/origin/* # 
 > timeout=10
 > git config remote.origin.url 
 > https://git-wip-us.apache.org/repos/asf/phoenix.git # timeout=10
Fetching upstream changes from 
https://git-wip-us.apache.org/repos/asf/phoenix.git
 > git -c core.askpass=true fetch --tags --progress 
 > https://git-wip-us.apache.org/repos/asf/phoenix.git 
 > +refs/heads/*:refs/remotes/origin/*
 > git rev-parse origin/4.x-HBase-0.98^{commit} # timeout=10
Checking out Revision 3a8d272c82ea2b5e6b0965272258b1f7319407e0 
(origin/4.x-HBase-0.98)
 > git config core.sparsecheckout # timeout=10
 > git checkout -f 3a8d272c82ea2b5e6b0965272258b1f7319407e0
 > git rev-list 3f620f54f842505c3a2f3cc1e9e0bdacd9f19dec # timeout=10
No emails were triggered.
[EnvInject] - Executing scripts and injecting environment variables after the 
SCM step.
[EnvInject] - Injecting as environment variables the properties content 
MAVEN_OPTS=-Xmx3G

[EnvInject] - Variables injected successfully.
[Phoenix-4.x-HBase-0.98] $ /bin/bash -xe /tmp/hudson2163173149308406583.sh
+ echo 'DELETING ~/.m2/repository/org/apache/htrace. See 
https://issues.apache.org/jira/browse/PHOENIX-1802'
DELETING ~/.m2/repository/org/apache/htrace. See 
https://issues.apache.org/jira/browse/PHOENIX-1802
+ echo 'CURRENT CONTENT:'
CURRENT CONTENT:
+ ls /home/jenkins/.m2/repository/org/apache/htrace
ls: cannot access /home/jenkins/.m2/repository/org/apache/htrace: No such file 
or directory
+ :
FATAL: Failed to install 
https://repo.maven.apache.org/maven2/org/apache/maven/apache-maven/3.0.4/apache-maven-3.0.4-bin.zip
 to /home/jenkins/tools/maven/apache-maven-3.0.4
java.io.IOException: Failed to install 
https://repo.maven.apache.org/maven2/org/apache/maven/apache-maven/3.0.4/apache-maven-3.0.4-bin.zip
 to /home/jenkins/tools/maven/apache-maven-3.0.4
at hudson.FilePath.installIfNecessaryFrom(FilePath.java:832)
at 
hudson.tools.DownloadFromUrlInstaller.performInstallation(DownloadFromUrlInstaller.java:75)
at 
hudson.tools.InstallerTranslator.getToolHome(InstallerTranslator.java:68)
at 
hudson.tools.ToolLocationNodeProperty.getToolHome(ToolLocationNodeProperty.java:108)
at hudson.tools.ToolInstallation.translateFor(ToolInstallation.java:206)
at hudson.tasks.Maven$MavenInstallation.forNode(Maven.java:624)
at hudson.tasks.Maven.perform(Maven.java:288)
at hudson.tasks.BuildStepMonitor$1.perform(BuildStepMonitor.java:20)
at 
hudson.model.AbstractBuild$AbstractBuildExecution.perform(AbstractBuild.java:782)
at hudson.model.Build$BuildExecution.build(Build.java:205)
at hudson.model.Build$BuildExecution.doRun(Build.java:162)
at 
hudson.model.AbstractBuild$AbstractBuildExecution.run(AbstractBuild.java:534)
at hudson.model.Run.execute(Run.java:1738)
at hudson.model.FreeStyleBuild.run(FreeStyleBuild.java:43)
at hudson.model.ResourceController.execute(ResourceController.java:98)
at hudson.model.Executor.run(Executor.java:410)
Caused by: java.io.IOException: remote file operation failed: 
/home/jenkins/tools/maven/apache-maven-3.0.4 at 
hudson.remoting.Channel@2be9fe6d:ubuntu-1: java.nio.file.AccessDeniedException: 
/home/jenkins/tools/maven/apache-maven-3.0.4/conf/settings.xml
at hudson.FilePath.act(FilePath.java:986)
at hudson.FilePath.act(FilePath.java:968)
at hudson.FilePath.deleteContents(FilePath.java:1183)
at hudson.FilePath.installIfNecessaryFrom(FilePath.java:796)
... 15 more
Caused by: java.nio.file.AccessDeniedException: 
/home/jenkins/tools/maven/apache-maven-3.0.4/conf/settings.xml
at 
sun.nio.fs.UnixException.translateToIOException(UnixException.java:84)
at sun.nio.fs.UnixException.rethrowAsIOException(UnixException.java:102)
at sun.nio.fs.UnixException.rethrowAsIOException(UnixException.java:107)
at 
sun.nio.fs.UnixFileSystemProvider.implDelete(UnixFileSystemProvider.java:244)
  

Build failed in Jenkins: Phoenix | Master #1253

[Apache Jenkins Server]

See 

Changes:

[larsh] Revert "PHOENIX-2965 Use DistinctPrefixFilter logic for COUNT(DISTINCT

--
Started by an SCM change
[EnvInject] - Loading node environment variables.
Building remotely on ubuntu-1 (docker Ubuntu ubuntu yahoo-not-h2 ubuntu1) in 
workspace 
Cloning the remote Git repository
Cloning repository https://git-wip-us.apache.org/repos/asf/phoenix.git
 > git init  # timeout=10
Fetching upstream changes from 
https://git-wip-us.apache.org/repos/asf/phoenix.git
 > git --version # timeout=10
 > git -c core.askpass=true fetch --tags --progress 
 > https://git-wip-us.apache.org/repos/asf/phoenix.git 
 > +refs/heads/*:refs/remotes/origin/*
 > git config remote.origin.url 
 > https://git-wip-us.apache.org/repos/asf/phoenix.git # timeout=10
 > git config --add remote.origin.fetch +refs/heads/*:refs/remotes/origin/* # 
 > timeout=10
 > git config remote.origin.url 
 > https://git-wip-us.apache.org/repos/asf/phoenix.git # timeout=10
Fetching upstream changes from 
https://git-wip-us.apache.org/repos/asf/phoenix.git
 > git -c core.askpass=true fetch --tags --progress 
 > https://git-wip-us.apache.org/repos/asf/phoenix.git 
 > +refs/heads/*:refs/remotes/origin/*
 > git rev-parse origin/master^{commit} # timeout=10
Checking out Revision a4d498f349193610003b888fc501f5ce146e99b0 (origin/master)
 > git config core.sparsecheckout # timeout=10
 > git checkout -f a4d498f349193610003b888fc501f5ce146e99b0
 > git rev-list f88cbf8390b5a2f44a60cb9e585de5d2f08cefdb # timeout=10
No emails were triggered.
[EnvInject] - Executing scripts and injecting environment variables after the 
SCM step.
[EnvInject] - Injecting as environment variables the properties content 
MAVEN_OPTS=-Xmx3G

[EnvInject] - Variables injected successfully.
[Phoenix-master] $ /bin/bash -xe /tmp/hudson6717358624736603353.sh
+ ls /home/jenkins/.m2/repository/org/apache/htrace
ls: cannot access /home/jenkins/.m2/repository/org/apache/htrace: No such file 
or directory
+ :
+ ls /home/jenkins/.m2/repository/org/apache/hbase
ls: cannot access /home/jenkins/.m2/repository/org/apache/hbase: No such file 
or directory
+ :
FATAL: Failed to install 
https://repo.maven.apache.org/maven2/org/apache/maven/apache-maven/3.0.4/apache-maven-3.0.4-bin.zip
 to /home/jenkins/tools/maven/apache-maven-3.0.4
java.io.IOException: Failed to install 
https://repo.maven.apache.org/maven2/org/apache/maven/apache-maven/3.0.4/apache-maven-3.0.4-bin.zip
 to /home/jenkins/tools/maven/apache-maven-3.0.4
at hudson.FilePath.installIfNecessaryFrom(FilePath.java:832)
at 
hudson.tools.DownloadFromUrlInstaller.performInstallation(DownloadFromUrlInstaller.java:75)
at 
hudson.tools.InstallerTranslator.getToolHome(InstallerTranslator.java:68)
at 
hudson.tools.ToolLocationNodeProperty.getToolHome(ToolLocationNodeProperty.java:108)
at hudson.tools.ToolInstallation.translateFor(ToolInstallation.java:206)
at hudson.tasks.Maven$MavenInstallation.forNode(Maven.java:624)
at hudson.tasks.Maven.perform(Maven.java:288)
at hudson.tasks.BuildStepMonitor$1.perform(BuildStepMonitor.java:20)
at 
hudson.model.AbstractBuild$AbstractBuildExecution.perform(AbstractBuild.java:782)
at hudson.model.Build$BuildExecution.build(Build.java:205)
at hudson.model.Build$BuildExecution.doRun(Build.java:162)
at 
hudson.model.AbstractBuild$AbstractBuildExecution.run(AbstractBuild.java:534)
at hudson.model.Run.execute(Run.java:1738)
at hudson.model.FreeStyleBuild.run(FreeStyleBuild.java:43)
at hudson.model.ResourceController.execute(ResourceController.java:98)
at hudson.model.Executor.run(Executor.java:410)
Caused by: java.io.IOException: remote file operation failed: 
/home/jenkins/tools/maven/apache-maven-3.0.4 at 
hudson.remoting.Channel@2be9fe6d:ubuntu-1: java.nio.file.AccessDeniedException: 
/home/jenkins/tools/maven/apache-maven-3.0.4/conf/settings.xml
at hudson.FilePath.act(FilePath.java:986)
at hudson.FilePath.act(FilePath.java:968)
at hudson.FilePath.deleteContents(FilePath.java:1183)
at hudson.FilePath.installIfNecessaryFrom(FilePath.java:796)
... 15 more
Caused by: java.nio.file.AccessDeniedException: 
/home/jenkins/tools/maven/apache-maven-3.0.4/conf/settings.xml
at 
sun.nio.fs.UnixException.translateToIOException(UnixException.java:84)
at sun.nio.fs.UnixException.rethrowAsIOException(UnixException.java:102)
at sun.nio.fs.UnixException.rethrowAsIOException(UnixException.java:107)
at 
sun.nio.fs.UnixFileSystemProvider.implDelete(UnixFileSystemProvider.java:244)
at 
sun.nio.fs.AbstractFileSystemProvider.delete(AbstractFileSystemProvider.java:103)
at java.nio.file.Files.delete(Files.java:1077)
at 

phoenix git commit: Revert "PHOENIX-2965 Use DistinctPrefixFilter logic for COUNT(DISTINCT ...) and COUNT(...) GROUP BY."

[larsh]

Repository: phoenix
Updated Branches:
  refs/heads/4.x-HBase-1.1 df3acbbe7 -> 54349d060


Revert "PHOENIX-2965 Use DistinctPrefixFilter logic for COUNT(DISTINCT ...) and 
COUNT(...) GROUP BY."

This reverts commit 81878a1852d27780ce8255d8671a7f9c943a2fc9.


Project: http://git-wip-us.apache.org/repos/asf/phoenix/repo
Commit: http://git-wip-us.apache.org/repos/asf/phoenix/commit/54349d06
Tree: http://git-wip-us.apache.org/repos/asf/phoenix/tree/54349d06
Diff: http://git-wip-us.apache.org/repos/asf/phoenix/diff/54349d06

Branch: refs/heads/4.x-HBase-1.1
Commit: 54349d06064870e1179cd664199d17d027930a18
Parents: df3acbb
Author: Lars Hofhansl 
Authored: Fri Jun 10 19:22:49 2016 -0700
Committer: Lars Hofhansl 
Committed: Fri Jun 10 19:22:49 2016 -0700

--
 .../phoenix/end2end/DistinctPrefixFilterIT.java | 165 ++-
 .../apache/phoenix/compile/GroupByCompiler.java |  44 ++---
 .../phoenix/compile/OrderPreservingTracker.java |  15 --
 .../phoenix/iterate/BaseResultIterators.java|   2 +-
 4 files changed, 102 insertions(+), 124 deletions(-)
--


http://git-wip-us.apache.org/repos/asf/phoenix/blob/54349d06/phoenix-core/src/it/java/org/apache/phoenix/end2end/DistinctPrefixFilterIT.java
--
diff --git 
a/phoenix-core/src/it/java/org/apache/phoenix/end2end/DistinctPrefixFilterIT.java
 
b/phoenix-core/src/it/java/org/apache/phoenix/end2end/DistinctPrefixFilterIT.java
index 45eb798..c2776ed 100644
--- 
a/phoenix-core/src/it/java/org/apache/phoenix/end2end/DistinctPrefixFilterIT.java
+++ 
b/phoenix-core/src/it/java/org/apache/phoenix/end2end/DistinctPrefixFilterIT.java
@@ -19,10 +19,9 @@ import org.junit.BeforeClass;
 import org.junit.Test;
 
 public class DistinctPrefixFilterIT extends BaseHBaseManagedTimeTableReuseIT {
-private static final String testTableF = generateRandomString();
-private static final String testTableV = generateRandomString();
-private static final String testSeq = testTableF + "_seq";
-private static final String PREFIX = "SERVER DISTINCT PREFIX";
+private static String testTableF = generateRandomString();
+private static String testTableV = generateRandomString();
+private static String testSeq = testTableF + "_seq";
 private static Connection conn;
 
 @BeforeClass
@@ -119,53 +118,104 @@ public class DistinctPrefixFilterIT extends 
BaseHBaseManagedTimeTableReuseIT {
 
 @Test
 public void testPlans() throws Exception {
+final String PREFIX = "SERVER DISTINCT PREFIX";
+
 // use the filter even when the SkipScan filter is used
-testPlan("SELECT DISTINCT prefix1, prefix2 FROM "+testTableF+ " WHERE 
prefix1 IN (1,2)", true);
-testPlan("SELECT prefix1, 1, 2 FROM "+testTableF+" GROUP BY prefix1 
HAVING prefix1 = 1", true);
-testPlan("SELECT prefix1 FROM "+testTableF+" GROUP BY prefix1, 
TRUNC(prefix1), TRUNC(prefix2)", true);
-testPlan("SELECT DISTINCT prefix1, prefix2 FROM "+testTableV+ " WHERE 
prefix1 IN ('1','2')", true);
-testPlan("SELECT prefix1, 1, 2 FROM "+testTableV+" GROUP BY prefix1 
HAVING prefix1 = '1'", true);
-// make sure we do not mis-optimize this case
-testPlan("SELECT DISTINCT SUM(prefix1) FROM "+testTableF+" GROUP BY 
prefix1", false);
+String dataSql = "SELECT DISTINCT prefix1, prefix2 FROM "+testTableF+ 
" WHERE prefix1 IN (1,2)";
+ResultSet rs = conn.createStatement().executeQuery("EXPLAIN "+dataSql);
+assertTrue(QueryUtil.getExplainPlan(rs).contains(PREFIX));
+
+dataSql = "SELECT prefix1, 1, 2 FROM "+testTableF+" GROUP BY prefix1 
HAVING prefix1 = 1";
+rs = conn.createStatement().executeQuery("EXPLAIN "+dataSql);
+assertTrue(QueryUtil.getExplainPlan(rs).contains(PREFIX));
+
+dataSql = "SELECT prefix1 FROM "+testTableF+" GROUP BY prefix1, 
TRUNC(prefix1), TRUNC(prefix2)";
+rs = conn.createStatement().executeQuery("EXPLAIN "+dataSql);
+assertTrue(QueryUtil.getExplainPlan(rs).contains(PREFIX));
+
+dataSql = "SELECT DISTINCT prefix1, prefix2 FROM "+testTableV+ " WHERE 
prefix1 IN ('1','2')";
+rs = conn.createStatement().executeQuery("EXPLAIN "+dataSql);
+assertTrue(QueryUtil.getExplainPlan(rs).contains(PREFIX));
+
+dataSql = "SELECT prefix1, 1, 2 FROM "+testTableV+" GROUP BY prefix1 
HAVING prefix1 = '1'";
+rs = conn.createStatement().executeQuery("EXPLAIN "+dataSql);
+assertTrue(QueryUtil.getExplainPlan(rs).contains(PREFIX));
 
 testCommonPlans(testTableF, PREFIX);
 testCommonPlans(testTableV, PREFIX);
 }
 
 private void testCommonPlans(String testTable, String contains) throws 
Exception {
-testPlan("SELECT DISTINCT prefix1 FROM "+testTable, true);
-

phoenix git commit: Revert "PHOENIX-2965 Use DistinctPrefixFilter logic for COUNT(DISTINCT ...) and COUNT(...) GROUP BY."

[larsh]

Repository: phoenix
Updated Branches:
  refs/heads/master f88cbf839 -> a4d498f34


Revert "PHOENIX-2965 Use DistinctPrefixFilter logic for COUNT(DISTINCT ...) and 
COUNT(...) GROUP BY."

This reverts commit e7e8e130b4ec84b32ed507201c1a00939f1d3b7c.


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

Branch: refs/heads/master
Commit: a4d498f349193610003b888fc501f5ce146e99b0
Parents: f88cbf8
Author: Lars Hofhansl 
Authored: Fri Jun 10 19:23:19 2016 -0700
Committer: Lars Hofhansl 
Committed: Fri Jun 10 19:23:19 2016 -0700

--
 .../phoenix/end2end/DistinctPrefixFilterIT.java | 165 ++-
 .../apache/phoenix/compile/GroupByCompiler.java |  44 ++---
 .../phoenix/compile/OrderPreservingTracker.java |  15 --
 .../phoenix/iterate/BaseResultIterators.java|   2 +-
 4 files changed, 102 insertions(+), 124 deletions(-)
--


http://git-wip-us.apache.org/repos/asf/phoenix/blob/a4d498f3/phoenix-core/src/it/java/org/apache/phoenix/end2end/DistinctPrefixFilterIT.java
--
diff --git 
a/phoenix-core/src/it/java/org/apache/phoenix/end2end/DistinctPrefixFilterIT.java
 
b/phoenix-core/src/it/java/org/apache/phoenix/end2end/DistinctPrefixFilterIT.java
index 45eb798..c2776ed 100644
--- 
a/phoenix-core/src/it/java/org/apache/phoenix/end2end/DistinctPrefixFilterIT.java
+++ 
b/phoenix-core/src/it/java/org/apache/phoenix/end2end/DistinctPrefixFilterIT.java
@@ -19,10 +19,9 @@ import org.junit.BeforeClass;
 import org.junit.Test;
 
 public class DistinctPrefixFilterIT extends BaseHBaseManagedTimeTableReuseIT {
-private static final String testTableF = generateRandomString();
-private static final String testTableV = generateRandomString();
-private static final String testSeq = testTableF + "_seq";
-private static final String PREFIX = "SERVER DISTINCT PREFIX";
+private static String testTableF = generateRandomString();
+private static String testTableV = generateRandomString();
+private static String testSeq = testTableF + "_seq";
 private static Connection conn;
 
 @BeforeClass
@@ -119,53 +118,104 @@ public class DistinctPrefixFilterIT extends 
BaseHBaseManagedTimeTableReuseIT {
 
 @Test
 public void testPlans() throws Exception {
+final String PREFIX = "SERVER DISTINCT PREFIX";
+
 // use the filter even when the SkipScan filter is used
-testPlan("SELECT DISTINCT prefix1, prefix2 FROM "+testTableF+ " WHERE 
prefix1 IN (1,2)", true);
-testPlan("SELECT prefix1, 1, 2 FROM "+testTableF+" GROUP BY prefix1 
HAVING prefix1 = 1", true);
-testPlan("SELECT prefix1 FROM "+testTableF+" GROUP BY prefix1, 
TRUNC(prefix1), TRUNC(prefix2)", true);
-testPlan("SELECT DISTINCT prefix1, prefix2 FROM "+testTableV+ " WHERE 
prefix1 IN ('1','2')", true);
-testPlan("SELECT prefix1, 1, 2 FROM "+testTableV+" GROUP BY prefix1 
HAVING prefix1 = '1'", true);
-// make sure we do not mis-optimize this case
-testPlan("SELECT DISTINCT SUM(prefix1) FROM "+testTableF+" GROUP BY 
prefix1", false);
+String dataSql = "SELECT DISTINCT prefix1, prefix2 FROM "+testTableF+ 
" WHERE prefix1 IN (1,2)";
+ResultSet rs = conn.createStatement().executeQuery("EXPLAIN "+dataSql);
+assertTrue(QueryUtil.getExplainPlan(rs).contains(PREFIX));
+
+dataSql = "SELECT prefix1, 1, 2 FROM "+testTableF+" GROUP BY prefix1 
HAVING prefix1 = 1";
+rs = conn.createStatement().executeQuery("EXPLAIN "+dataSql);
+assertTrue(QueryUtil.getExplainPlan(rs).contains(PREFIX));
+
+dataSql = "SELECT prefix1 FROM "+testTableF+" GROUP BY prefix1, 
TRUNC(prefix1), TRUNC(prefix2)";
+rs = conn.createStatement().executeQuery("EXPLAIN "+dataSql);
+assertTrue(QueryUtil.getExplainPlan(rs).contains(PREFIX));
+
+dataSql = "SELECT DISTINCT prefix1, prefix2 FROM "+testTableV+ " WHERE 
prefix1 IN ('1','2')";
+rs = conn.createStatement().executeQuery("EXPLAIN "+dataSql);
+assertTrue(QueryUtil.getExplainPlan(rs).contains(PREFIX));
+
+dataSql = "SELECT prefix1, 1, 2 FROM "+testTableV+" GROUP BY prefix1 
HAVING prefix1 = '1'";
+rs = conn.createStatement().executeQuery("EXPLAIN "+dataSql);
+assertTrue(QueryUtil.getExplainPlan(rs).contains(PREFIX));
 
 testCommonPlans(testTableF, PREFIX);
 testCommonPlans(testTableV, PREFIX);
 }
 
 private void testCommonPlans(String testTable, String contains) throws 
Exception {
-testPlan("SELECT DISTINCT prefix1 FROM "+testTable, true);
-testPlan("SELECT 

Build failed in Jenkins: Phoenix | 4.x-HBase-0.98 #1173

[Apache Jenkins Server]

See 

Changes:

[jamestaylor] PHOENIX-2489 Support sequence metadata access through 
DatabaseMetaData

--
[...truncated 238 lines...]
Running org.apache.phoenix.jdbc.PhoenixResultSetMetadataTest
Tests run: 35, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.683 sec - in 
org.apache.phoenix.expression.ArrayConcatFunctionTest
Running org.apache.phoenix.jdbc.PhoenixEmbeddedDriverTest
Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.004 sec - in 
org.apache.phoenix.jdbc.PhoenixEmbeddedDriverTest
Running org.apache.phoenix.mapreduce.CsvToKeyValueMapperTest
Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.021 sec - in 
org.apache.phoenix.mapreduce.CsvToKeyValueMapperTest
Running org.apache.phoenix.mapreduce.FormatToBytesWritableMapperTest
Tests run: 11, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.256 sec - in 
org.apache.phoenix.jdbc.PhoenixPreparedStatementTest
Running org.apache.phoenix.mapreduce.bulkload.TestTableRowkeyPair
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.004 sec - in 
org.apache.phoenix.mapreduce.bulkload.TestTableRowkeyPair
Running org.apache.phoenix.mapreduce.util.ColumnInfoToStringEncoderDecoderTest
Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.05 sec - in 
org.apache.phoenix.mapreduce.util.ColumnInfoToStringEncoderDecoderTest
Running org.apache.phoenix.mapreduce.util.PhoenixConfigurationUtilTest
Tests run: 5, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.238 sec - in 
org.apache.phoenix.mapreduce.FormatToBytesWritableMapperTest
Running org.apache.phoenix.mapreduce.BulkLoadToolTest
Tests run: 12, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.046 sec - in 
org.apache.phoenix.mapreduce.BulkLoadToolTest
Running org.apache.phoenix.mapreduce.CsvBulkImportUtilTest
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.999 sec - in 
org.apache.phoenix.jdbc.PhoenixResultSetMetadataTest
Running org.apache.phoenix.util.JDBCUtilTest
Tests run: 10, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.016 sec - in 
org.apache.phoenix.util.JDBCUtilTest
Running org.apache.phoenix.util.PrefixByteEncoderDecoderTest
Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.011 sec - in 
org.apache.phoenix.util.PrefixByteEncoderDecoderTest
Running org.apache.phoenix.util.json.JsonUpsertExecutorTest
Tests run: 5, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.646 sec - in 
org.apache.phoenix.mapreduce.CsvBulkImportUtilTest
Running org.apache.phoenix.util.csv.StringToArrayConverterTest
Tests run: 9, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 1.112 sec - in 
org.apache.phoenix.mapreduce.util.PhoenixConfigurationUtilTest
Running org.apache.phoenix.util.csv.CsvUpsertExecutorTest
Tests run: 4, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.433 sec - in 
org.apache.phoenix.util.csv.StringToArrayConverterTest
Running org.apache.phoenix.util.ByteUtilTest
Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.197 sec - in 
org.apache.phoenix.util.ByteUtilTest
Running org.apache.phoenix.util.PhoenixRuntimeTest
Tests run: 5, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.767 sec - in 
org.apache.phoenix.util.json.JsonUpsertExecutorTest
Running org.apache.phoenix.util.ScanUtilTest
Tests run: 20, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.037 sec - in 
org.apache.phoenix.util.ScanUtilTest
Running org.apache.phoenix.util.StringUtilTest
Tests run: 5, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.004 sec - in 
org.apache.phoenix.util.StringUtilTest
Running org.apache.phoenix.util.SequenceUtilTest
Tests run: 18, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.029 sec - in 
org.apache.phoenix.util.SequenceUtilTest
Running org.apache.phoenix.util.Base62EncoderTest
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.017 sec - in 
org.apache.phoenix.util.Base62EncoderTest
Running org.apache.phoenix.util.TenantIdByteConversionTest
Tests run: 18, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.043 sec - in 
org.apache.phoenix.util.TenantIdByteConversionTest
Running org.apache.phoenix.util.DateUtilTest
Tests run: 6, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.564 sec - in 
org.apache.phoenix.util.csv.CsvUpsertExecutorTest
Running org.apache.phoenix.util.PropertiesUtilTest
Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.04 sec - in 
org.apache.phoenix.util.PropertiesUtilTest
Running org.apache.phoenix.util.ColumnInfoTest
Tests run: 5, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.007 sec - in 
org.apache.phoenix.util.ColumnInfoTest
Running org.apache.phoenix.util.PhoenixEncodeDecodeTest
Tests run: 22, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.089 sec - in 
org.apache.phoenix.util.DateUtilTest
Running org.apache.phoenix.util.LogUtilTest
Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.113 

Build failed in Jenkins: Phoenix-4.x-HBase-1.0 #495

[Apache Jenkins Server]

See 

Changes:

[jamestaylor] PHOENIX-2489 Support sequence metadata access through 
DatabaseMetaData

--
[...truncated 239 lines...]
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.001 sec - in 
org.apache.phoenix.hbase.index.covered.TestCoveredColumns
Running org.apache.phoenix.hbase.index.covered.filter.TestNewerTimestampFilter
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.001 sec - in 
org.apache.phoenix.hbase.index.covered.filter.TestNewerTimestampFilter
Running 
org.apache.phoenix.hbase.index.covered.filter.TestApplyAndFilterDeletesFilter
Tests run: 6, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.005 sec - in 
org.apache.phoenix.hbase.index.covered.filter.TestApplyAndFilterDeletesFilter
Running org.apache.phoenix.hbase.index.covered.data.TestIndexMemStore
Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.006 sec - in 
org.apache.phoenix.hbase.index.covered.data.TestIndexMemStore
Running org.apache.phoenix.hbase.index.covered.update.TestIndexUpdateManager
Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.004 sec - in 
org.apache.phoenix.hbase.index.covered.update.TestIndexUpdateManager
Running org.apache.phoenix.hbase.index.covered.example.TestColumnTracker
Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.002 sec - in 
org.apache.phoenix.hbase.index.covered.example.TestColumnTracker
Running 
org.apache.phoenix.hbase.index.covered.example.TestCoveredIndexSpecifierBuilder
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.003 sec - in 
org.apache.phoenix.hbase.index.covered.example.TestCoveredIndexSpecifierBuilder
Running 
org.apache.phoenix.hbase.index.covered.example.TestCoveredColumnIndexCodec
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.112 sec - in 
org.apache.phoenix.iterate.AggregateResultScannerTest
Running org.apache.phoenix.hbase.index.covered.TestLocalTableState
Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.136 sec - in 
org.apache.phoenix.hbase.index.covered.example.TestCoveredColumnIndexCodec
Running org.apache.phoenix.hbase.index.write.TestCachingHTableFactory
Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 4.898 sec - in 
org.apache.phoenix.query.ScannerLeaseRenewalTest
Running org.apache.phoenix.hbase.index.write.TestParalleWriterIndexCommitter
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.048 sec - in 
org.apache.phoenix.hbase.index.write.TestCachingHTableFactory
Running org.apache.phoenix.hbase.index.write.TestWALRecoveryCaching
Tests run: 1, Failures: 0, Errors: 0, Skipped: 1, Time elapsed: 0.007 sec - in 
org.apache.phoenix.hbase.index.write.TestWALRecoveryCaching
Running 
org.apache.phoenix.hbase.index.write.recovery.TestPerRegionIndexWriteCache
Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.179 sec - in 
org.apache.phoenix.hbase.index.covered.TestLocalTableState
Running org.apache.phoenix.hbase.index.write.TestIndexWriter
Tests run: 5, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.065 sec - in 
org.apache.phoenix.hbase.index.write.TestIndexWriter
Running org.apache.phoenix.hbase.index.write.TestParalleIndexWriter
Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.024 sec - in 
org.apache.phoenix.hbase.index.write.TestParalleIndexWriter
Running org.apache.phoenix.hbase.index.parallel.TestThreadPoolBuilder
Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.002 sec - in 
org.apache.phoenix.hbase.index.parallel.TestThreadPoolBuilder
Running org.apache.phoenix.hbase.index.parallel.TestThreadPoolManager
Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.005 sec - in 
org.apache.phoenix.hbase.index.parallel.TestThreadPoolManager
Running org.apache.phoenix.hbase.index.util.TestIndexManagementUtil
Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.009 sec - in 
org.apache.phoenix.hbase.index.util.TestIndexManagementUtil
Running org.apache.phoenix.trace.TraceMetricsSourceTest
Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.409 sec - in 
org.apache.phoenix.hbase.index.write.TestParalleWriterIndexCommitter
Running org.apache.phoenix.jdbc.PhoenixResultSetMetadataTest
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.364 sec - in 
org.apache.phoenix.jdbc.PhoenixResultSetMetadataTest
Running org.apache.phoenix.jdbc.PhoenixPreparedStatementTest
Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.761 sec - in 
org.apache.phoenix.hbase.index.write.recovery.TestPerRegionIndexWriteCache
Running org.apache.phoenix.jdbc.ReadOnlyPropertiesTest
Tests run: 4, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.003 sec - in 
org.apache.phoenix.jdbc.ReadOnlyPropertiesTest
Running org.apache.phoenix.jdbc.PhoenixDriverTest
Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.612 

Build failed in Jenkins: Phoenix | Master #1252

[Apache Jenkins Server]

See 

Changes:

[jamestaylor] PHOENIX-2489 Support sequence metadata access through 
DatabaseMetaData

--
[...truncated 268 lines...]
Running org.apache.phoenix.compile.QueryOptimizerTest
Tests run: 6, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.967 sec - in 
org.apache.phoenix.compile.TenantSpecificViewIndexCompileTest
Running org.apache.phoenix.compile.JoinQueryCompilerTest
Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.436 sec - in 
org.apache.phoenix.compile.ViewCompilerTest
Running org.apache.phoenix.compile.WhereCompilerTest
Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.325 sec - in 
org.apache.phoenix.compile.JoinQueryCompilerTest
Running org.apache.phoenix.compile.ScanRangesTest
Tests run: 34, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.068 sec - in 
org.apache.phoenix.compile.ScanRangesTest
Running org.apache.phoenix.compile.SelectStatementRewriterTest
Tests run: 45, Failures: 0, Errors: 0, Skipped: 1, Time elapsed: 0.42 sec - in 
org.apache.phoenix.compile.WhereCompilerTest
Running org.apache.phoenix.compile.HavingCompilerTest
Tests run: 5, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.22 sec - in 
org.apache.phoenix.compile.SelectStatementRewriterTest
Running org.apache.phoenix.compile.ScanRangesIntersectTest
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.002 sec - in 
org.apache.phoenix.compile.ScanRangesIntersectTest
Running org.apache.phoenix.compile.QueryCompilerTest
Tests run: 11, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.258 sec - in 
org.apache.phoenix.compile.HavingCompilerTest
Running org.apache.phoenix.index.IndexMaintainerTest
Tests run: 24, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.963 sec - in 
org.apache.phoenix.index.IndexMaintainerTest
Running org.apache.phoenix.hbase.index.util.TestIndexManagementUtil
Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.018 sec - in 
org.apache.phoenix.hbase.index.util.TestIndexManagementUtil
Running org.apache.phoenix.hbase.index.covered.TestLocalTableState
Tests run: 40, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 2.05 sec - in 
org.apache.phoenix.compile.QueryOptimizerTest
Running 
org.apache.phoenix.hbase.index.covered.example.TestCoveredIndexSpecifierBuilder
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.01 sec - in 
org.apache.phoenix.hbase.index.covered.example.TestCoveredIndexSpecifierBuilder
Running org.apache.phoenix.hbase.index.covered.example.TestColumnTracker
Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.005 sec - in 
org.apache.phoenix.hbase.index.covered.example.TestColumnTracker
Running 
org.apache.phoenix.hbase.index.covered.example.TestCoveredColumnIndexCodec
Tests run: 120, Failures: 1, Errors: 0, Skipped: 0, Time elapsed: 1.202 sec <<< 
FAILURE! - in org.apache.phoenix.compile.QueryCompilerTest
testNonAggInHavingClause(org.apache.phoenix.compile.QueryCompilerTest)  Time 
elapsed: 0.021 sec  <<< FAILURE!
java.lang.AssertionError: ERROR 1018 (42Y27): Aggregate may not contain columns 
not in GROUP BY. A_INTEGER
at 
org.apache.phoenix.compile.QueryCompilerTest.testNonAggInHavingClause(QueryCompilerTest.java:341)

Running org.apache.phoenix.hbase.index.covered.data.TestIndexMemStore
Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.009 sec - in 
org.apache.phoenix.hbase.index.covered.data.TestIndexMemStore
Running org.apache.phoenix.hbase.index.covered.TestCoveredColumns
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.002 sec - in 
org.apache.phoenix.hbase.index.covered.TestCoveredColumns
Running org.apache.phoenix.hbase.index.covered.update.TestIndexUpdateManager
Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.006 sec - in 
org.apache.phoenix.hbase.index.covered.update.TestIndexUpdateManager
Running org.apache.phoenix.hbase.index.covered.filter.TestNewerTimestampFilter
Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.055 sec - in 
org.apache.phoenix.hbase.index.covered.example.TestCoveredColumnIndexCodec
Running 
org.apache.phoenix.hbase.index.covered.filter.TestApplyAndFilterDeletesFilter
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.002 sec - in 
org.apache.phoenix.hbase.index.covered.filter.TestNewerTimestampFilter
Running org.apache.phoenix.hbase.index.write.TestIndexWriter
Tests run: 6, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.005 sec - in 
org.apache.phoenix.hbase.index.covered.filter.TestApplyAndFilterDeletesFilter
Running org.apache.phoenix.hbase.index.write.TestCachingHTableFactory
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.068 sec - in 
org.apache.phoenix.hbase.index.write.TestCachingHTableFactory
Running 
org.apache.phoenix.hbase.index.write.recovery.TestPerRegionIndexWriteCache
Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time 

Build failed in Jenkins: Phoenix-4.x-HBase-1.1 #49

[Apache Jenkins Server]

See 

Changes:

[jamestaylor] PHOENIX-2489 Support sequence metadata access through 
DatabaseMetaData

--
[...truncated 239 lines...]
Tests run: 103, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 1.078 sec - 
in org.apache.phoenix.compile.WhereOptimizerTest
Running org.apache.phoenix.compile.QueryOptimizerTest
Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.433 sec - in 
org.apache.phoenix.compile.ViewCompilerTest
Running org.apache.phoenix.compile.JoinQueryCompilerTest
Tests run: 6, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 1.103 sec - in 
org.apache.phoenix.compile.TenantSpecificViewIndexCompileTest
Running org.apache.phoenix.compile.WhereCompilerTest
Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.333 sec - in 
org.apache.phoenix.compile.JoinQueryCompilerTest
Running org.apache.phoenix.compile.ScanRangesTest
Tests run: 34, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.065 sec - in 
org.apache.phoenix.compile.ScanRangesTest
Running org.apache.phoenix.compile.SelectStatementRewriterTest
Tests run: 5, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.271 sec - in 
org.apache.phoenix.compile.SelectStatementRewriterTest
Running org.apache.phoenix.compile.HavingCompilerTest
Tests run: 45, Failures: 0, Errors: 0, Skipped: 1, Time elapsed: 0.416 sec - in 
org.apache.phoenix.compile.WhereCompilerTest
Running org.apache.phoenix.compile.ScanRangesIntersectTest
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.002 sec - in 
org.apache.phoenix.compile.ScanRangesIntersectTest
Running org.apache.phoenix.compile.QueryCompilerTest
Tests run: 11, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.267 sec - in 
org.apache.phoenix.compile.HavingCompilerTest
Running org.apache.phoenix.index.IndexMaintainerTest
Tests run: 40, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 2.013 sec - in 
org.apache.phoenix.compile.QueryOptimizerTest
Running org.apache.phoenix.hbase.index.util.TestIndexManagementUtil
Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.02 sec - in 
org.apache.phoenix.hbase.index.util.TestIndexManagementUtil
Running org.apache.phoenix.hbase.index.covered.TestLocalTableState
Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.183 sec - in 
org.apache.phoenix.hbase.index.covered.TestLocalTableState
Tests run: 24, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 1.035 sec - in 
org.apache.phoenix.index.IndexMaintainerTest
Running 
org.apache.phoenix.hbase.index.covered.example.TestCoveredIndexSpecifierBuilder
Running org.apache.phoenix.hbase.index.covered.example.TestColumnTracker
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.004 sec - in 
org.apache.phoenix.hbase.index.covered.example.TestCoveredIndexSpecifierBuilder
Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.004 sec - in 
org.apache.phoenix.hbase.index.covered.example.TestColumnTracker
Running 
org.apache.phoenix.hbase.index.covered.example.TestCoveredColumnIndexCodec
Tests run: 120, Failures: 1, Errors: 0, Skipped: 0, Time elapsed: 1.237 sec <<< 
FAILURE! - in org.apache.phoenix.compile.QueryCompilerTest
testNonAggInHavingClause(org.apache.phoenix.compile.QueryCompilerTest)  Time 
elapsed: 0.011 sec  <<< FAILURE!
java.lang.AssertionError: ERROR 1018 (42Y27): Aggregate may not contain columns 
not in GROUP BY. A_INTEGER
at 
org.apache.phoenix.compile.QueryCompilerTest.testNonAggInHavingClause(QueryCompilerTest.java:341)

Running org.apache.phoenix.hbase.index.covered.data.TestIndexMemStore
Running org.apache.phoenix.hbase.index.covered.TestCoveredColumns
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.001 sec - in 
org.apache.phoenix.hbase.index.covered.TestCoveredColumns
Running org.apache.phoenix.hbase.index.covered.update.TestIndexUpdateManager
Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.009 sec - in 
org.apache.phoenix.hbase.index.covered.data.TestIndexMemStore
Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.004 sec - in 
org.apache.phoenix.hbase.index.covered.update.TestIndexUpdateManager
Running org.apache.phoenix.hbase.index.covered.filter.TestNewerTimestampFilter
Running 
org.apache.phoenix.hbase.index.covered.filter.TestApplyAndFilterDeletesFilter
Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.013 sec - in 
org.apache.phoenix.hbase.index.covered.example.TestCoveredColumnIndexCodec
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.003 sec - in 
org.apache.phoenix.hbase.index.covered.filter.TestNewerTimestampFilter
Running org.apache.phoenix.hbase.index.write.TestIndexWriter
Running org.apache.phoenix.hbase.index.write.TestCachingHTableFactory
Tests run: 6, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.006 sec - in 
org.apache.phoenix.hbase.index.covered.filter.TestApplyAndFilterDeletesFilter
Running 

phoenix git commit: PHOENIX-2489 Support sequence metadata access through DatabaseMetaData interface

[jamestaylor]

Repository: phoenix
Updated Branches:
  refs/heads/4.x-HBase-0.98 3c205ac49 -> 3f620f54f


PHOENIX-2489 Support sequence metadata access through DatabaseMetaData interface


Project: http://git-wip-us.apache.org/repos/asf/phoenix/repo
Commit: http://git-wip-us.apache.org/repos/asf/phoenix/commit/3f620f54
Tree: http://git-wip-us.apache.org/repos/asf/phoenix/tree/3f620f54
Diff: http://git-wip-us.apache.org/repos/asf/phoenix/diff/3f620f54

Branch: refs/heads/4.x-HBase-0.98
Commit: 3f620f54f842505c3a2f3cc1e9e0bdacd9f19dec
Parents: 3c205ac
Author: James Taylor 
Authored: Fri Jun 10 09:45:28 2016 -0700
Committer: James Taylor 
Committed: Fri Jun 10 09:59:35 2016 -0700

--
 .../end2end/QueryDatabaseMetaDataIT.java|  99 ++-
 .../apache/phoenix/compile/UnionCompiler.java   |   2 +-
 .../phoenix/filter/BooleanExpressionFilter.java |   1 +
 .../filter/MultiKeyValueComparisonFilter.java   |   1 -
 .../phoenix/jdbc/PhoenixDatabaseMetaData.java   | 167 +--
 .../org/apache/phoenix/schema/ValueSchema.java  |  30 ++--
 6 files changed, 235 insertions(+), 65 deletions(-)
--


http://git-wip-us.apache.org/repos/asf/phoenix/blob/3f620f54/phoenix-core/src/it/java/org/apache/phoenix/end2end/QueryDatabaseMetaDataIT.java
--
diff --git 
a/phoenix-core/src/it/java/org/apache/phoenix/end2end/QueryDatabaseMetaDataIT.java
 
b/phoenix-core/src/it/java/org/apache/phoenix/end2end/QueryDatabaseMetaDataIT.java
index aa7a6b2..65ba0ad 100644
--- 
a/phoenix-core/src/it/java/org/apache/phoenix/end2end/QueryDatabaseMetaDataIT.java
+++ 
b/phoenix-core/src/it/java/org/apache/phoenix/end2end/QueryDatabaseMetaDataIT.java
@@ -175,6 +175,103 @@ public class QueryDatabaseMetaDataIT extends 
BaseClientManagedTimeIT {
 }
 
 @Test
+public void testTableTypes() throws SQLException {
+long ts = nextTimestamp();
+Properties props = new Properties();
+props.setProperty(PhoenixRuntime.CURRENT_SCN_ATTRIB, Long.toString(ts 
+ 10));
+Connection conn = DriverManager.getConnection(getUrl(), props);
+DatabaseMetaData dbmd = conn.getMetaData();
+ResultSet rs = dbmd.getTableTypes();
+assertTrue(rs.next());
+assertEquals("INDEX",rs.getString(1));
+assertTrue(rs.next());
+assertEquals("SEQUENCE",rs.getString(1));
+assertTrue(rs.next());
+assertEquals("SYSTEM TABLE",rs.getString(1));
+assertTrue(rs.next());
+assertEquals("TABLE",rs.getString(1));
+assertTrue(rs.next());
+assertEquals("VIEW",rs.getString(1));
+assertFalse(rs.next());
+}
+
+@Test
+public void testSequenceMetadataScan() throws SQLException {
+long ts = nextTimestamp();
+Properties props = new Properties();
+props.setProperty(PhoenixRuntime.CURRENT_SCN_ATTRIB, Long.toString(ts 
+ 10));
+Connection conn = DriverManager.getConnection(getUrl(), props);
+conn.createStatement().execute("CREATE SEQUENCE b.s1");
+conn.createStatement().execute("CREATE SEQUENCE a.s2");
+conn.createStatement().execute("CREATE SEQUENCE b.s3");
+conn.createStatement().execute("CREATE SEQUENCE c.s1");
+
+props.setProperty(PhoenixRuntime.CURRENT_SCN_ATTRIB, Long.toString(ts 
+ 20));
+conn = DriverManager.getConnection(getUrl(), props);
+DatabaseMetaData dbmd = conn.getMetaData();
+ResultSet rs = dbmd.getTables(null, null, null, new String[] {"FOO"});
+assertFalse(rs.next());
+
+rs = dbmd.getTables(null, null, null, new String[] 
{"FOO",PhoenixDatabaseMetaData.SEQUENCE_TABLE_TYPE});
+assertTrue(rs.next());
+assertNull(rs.getString("TABLE_CAT"));
+assertEquals("A", rs.getString("TABLE_SCHEM"));
+assertEquals("S2", rs.getString("TABLE_NAME"));
+assertTrue(rs.next());
+assertNull(rs.getString("TABLE_CAT"));
+assertEquals("B", rs.getString("TABLE_SCHEM"));
+assertEquals("S1", rs.getString("TABLE_NAME"));
+assertTrue(rs.next());
+assertNull(rs.getString("TABLE_CAT"));
+assertEquals("B", rs.getString("TABLE_SCHEM"));
+assertEquals("S3", rs.getString("TABLE_NAME"));
+assertTrue(rs.next());
+assertNull(rs.getString("TABLE_CAT"));
+assertEquals("C", rs.getString("TABLE_SCHEM"));
+assertEquals("S1", rs.getString("TABLE_NAME"));
+assertFalse(rs.next());
+
+conn.createStatement().execute("CREATE TABLE foo (k bigint primary 
key)");
+conn.createStatement().execute("CREATE TABLE z.bas (k bigint primary 
key)");
+
+props.setProperty(PhoenixRuntime.CURRENT_SCN_ATTRIB, Long.toString(ts 
+ 30));
+conn = 

phoenix git commit: PHOENIX-2489 Support sequence metadata access through DatabaseMetaData interface

[jamestaylor]

Repository: phoenix
Updated Branches:
  refs/heads/4.x-HBase-1.0 a747b459a -> 178b63b9a


PHOENIX-2489 Support sequence metadata access through DatabaseMetaData interface


Project: http://git-wip-us.apache.org/repos/asf/phoenix/repo
Commit: http://git-wip-us.apache.org/repos/asf/phoenix/commit/178b63b9
Tree: http://git-wip-us.apache.org/repos/asf/phoenix/tree/178b63b9
Diff: http://git-wip-us.apache.org/repos/asf/phoenix/diff/178b63b9

Branch: refs/heads/4.x-HBase-1.0
Commit: 178b63b9afe4de103ab2e98d2db2c41a747e1ece
Parents: a747b45
Author: James Taylor 
Authored: Fri Jun 10 09:45:28 2016 -0700
Committer: James Taylor 
Committed: Fri Jun 10 09:52:07 2016 -0700

--
 .../end2end/QueryDatabaseMetaDataIT.java|  99 ++-
 .../apache/phoenix/compile/UnionCompiler.java   |   2 +-
 .../phoenix/filter/BooleanExpressionFilter.java |   1 +
 .../filter/MultiKeyValueComparisonFilter.java   |   1 -
 .../phoenix/jdbc/PhoenixDatabaseMetaData.java   | 167 +--
 .../org/apache/phoenix/schema/ValueSchema.java  |  30 ++--
 6 files changed, 234 insertions(+), 66 deletions(-)
--


http://git-wip-us.apache.org/repos/asf/phoenix/blob/178b63b9/phoenix-core/src/it/java/org/apache/phoenix/end2end/QueryDatabaseMetaDataIT.java
--
diff --git 
a/phoenix-core/src/it/java/org/apache/phoenix/end2end/QueryDatabaseMetaDataIT.java
 
b/phoenix-core/src/it/java/org/apache/phoenix/end2end/QueryDatabaseMetaDataIT.java
index aa7a6b2..65ba0ad 100644
--- 
a/phoenix-core/src/it/java/org/apache/phoenix/end2end/QueryDatabaseMetaDataIT.java
+++ 
b/phoenix-core/src/it/java/org/apache/phoenix/end2end/QueryDatabaseMetaDataIT.java
@@ -175,6 +175,103 @@ public class QueryDatabaseMetaDataIT extends 
BaseClientManagedTimeIT {
 }
 
 @Test
+public void testTableTypes() throws SQLException {
+long ts = nextTimestamp();
+Properties props = new Properties();
+props.setProperty(PhoenixRuntime.CURRENT_SCN_ATTRIB, Long.toString(ts 
+ 10));
+Connection conn = DriverManager.getConnection(getUrl(), props);
+DatabaseMetaData dbmd = conn.getMetaData();
+ResultSet rs = dbmd.getTableTypes();
+assertTrue(rs.next());
+assertEquals("INDEX",rs.getString(1));
+assertTrue(rs.next());
+assertEquals("SEQUENCE",rs.getString(1));
+assertTrue(rs.next());
+assertEquals("SYSTEM TABLE",rs.getString(1));
+assertTrue(rs.next());
+assertEquals("TABLE",rs.getString(1));
+assertTrue(rs.next());
+assertEquals("VIEW",rs.getString(1));
+assertFalse(rs.next());
+}
+
+@Test
+public void testSequenceMetadataScan() throws SQLException {
+long ts = nextTimestamp();
+Properties props = new Properties();
+props.setProperty(PhoenixRuntime.CURRENT_SCN_ATTRIB, Long.toString(ts 
+ 10));
+Connection conn = DriverManager.getConnection(getUrl(), props);
+conn.createStatement().execute("CREATE SEQUENCE b.s1");
+conn.createStatement().execute("CREATE SEQUENCE a.s2");
+conn.createStatement().execute("CREATE SEQUENCE b.s3");
+conn.createStatement().execute("CREATE SEQUENCE c.s1");
+
+props.setProperty(PhoenixRuntime.CURRENT_SCN_ATTRIB, Long.toString(ts 
+ 20));
+conn = DriverManager.getConnection(getUrl(), props);
+DatabaseMetaData dbmd = conn.getMetaData();
+ResultSet rs = dbmd.getTables(null, null, null, new String[] {"FOO"});
+assertFalse(rs.next());
+
+rs = dbmd.getTables(null, null, null, new String[] 
{"FOO",PhoenixDatabaseMetaData.SEQUENCE_TABLE_TYPE});
+assertTrue(rs.next());
+assertNull(rs.getString("TABLE_CAT"));
+assertEquals("A", rs.getString("TABLE_SCHEM"));
+assertEquals("S2", rs.getString("TABLE_NAME"));
+assertTrue(rs.next());
+assertNull(rs.getString("TABLE_CAT"));
+assertEquals("B", rs.getString("TABLE_SCHEM"));
+assertEquals("S1", rs.getString("TABLE_NAME"));
+assertTrue(rs.next());
+assertNull(rs.getString("TABLE_CAT"));
+assertEquals("B", rs.getString("TABLE_SCHEM"));
+assertEquals("S3", rs.getString("TABLE_NAME"));
+assertTrue(rs.next());
+assertNull(rs.getString("TABLE_CAT"));
+assertEquals("C", rs.getString("TABLE_SCHEM"));
+assertEquals("S1", rs.getString("TABLE_NAME"));
+assertFalse(rs.next());
+
+conn.createStatement().execute("CREATE TABLE foo (k bigint primary 
key)");
+conn.createStatement().execute("CREATE TABLE z.bas (k bigint primary 
key)");
+
+props.setProperty(PhoenixRuntime.CURRENT_SCN_ATTRIB, Long.toString(ts 
+ 30));
+conn = 

phoenix git commit: PHOENIX-2489 Support sequence metadata access through DatabaseMetaData interface

[jamestaylor]

Repository: phoenix
Updated Branches:
  refs/heads/4.x-HBase-1.1 79bd03e08 -> df3acbbe7


PHOENIX-2489 Support sequence metadata access through DatabaseMetaData interface


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

Branch: refs/heads/4.x-HBase-1.1
Commit: df3acbbe73fd023642ebf3170dd42fb1e4379d3a
Parents: 79bd03e
Author: James Taylor 
Authored: Fri Jun 10 09:45:28 2016 -0700
Committer: James Taylor 
Committed: Fri Jun 10 09:46:43 2016 -0700

--
 .../end2end/QueryDatabaseMetaDataIT.java|  99 ++-
 .../apache/phoenix/compile/UnionCompiler.java   |   2 +-
 .../phoenix/filter/BooleanExpressionFilter.java |   1 +
 .../filter/MultiKeyValueComparisonFilter.java   |   1 -
 .../phoenix/jdbc/PhoenixDatabaseMetaData.java   | 167 +--
 .../org/apache/phoenix/schema/ValueSchema.java  |  30 ++--
 6 files changed, 234 insertions(+), 66 deletions(-)
--


http://git-wip-us.apache.org/repos/asf/phoenix/blob/df3acbbe/phoenix-core/src/it/java/org/apache/phoenix/end2end/QueryDatabaseMetaDataIT.java
--
diff --git 
a/phoenix-core/src/it/java/org/apache/phoenix/end2end/QueryDatabaseMetaDataIT.java
 
b/phoenix-core/src/it/java/org/apache/phoenix/end2end/QueryDatabaseMetaDataIT.java
index aa7a6b2..65ba0ad 100644
--- 
a/phoenix-core/src/it/java/org/apache/phoenix/end2end/QueryDatabaseMetaDataIT.java
+++ 
b/phoenix-core/src/it/java/org/apache/phoenix/end2end/QueryDatabaseMetaDataIT.java
@@ -175,6 +175,103 @@ public class QueryDatabaseMetaDataIT extends 
BaseClientManagedTimeIT {
 }
 
 @Test
+public void testTableTypes() throws SQLException {
+long ts = nextTimestamp();
+Properties props = new Properties();
+props.setProperty(PhoenixRuntime.CURRENT_SCN_ATTRIB, Long.toString(ts 
+ 10));
+Connection conn = DriverManager.getConnection(getUrl(), props);
+DatabaseMetaData dbmd = conn.getMetaData();
+ResultSet rs = dbmd.getTableTypes();
+assertTrue(rs.next());
+assertEquals("INDEX",rs.getString(1));
+assertTrue(rs.next());
+assertEquals("SEQUENCE",rs.getString(1));
+assertTrue(rs.next());
+assertEquals("SYSTEM TABLE",rs.getString(1));
+assertTrue(rs.next());
+assertEquals("TABLE",rs.getString(1));
+assertTrue(rs.next());
+assertEquals("VIEW",rs.getString(1));
+assertFalse(rs.next());
+}
+
+@Test
+public void testSequenceMetadataScan() throws SQLException {
+long ts = nextTimestamp();
+Properties props = new Properties();
+props.setProperty(PhoenixRuntime.CURRENT_SCN_ATTRIB, Long.toString(ts 
+ 10));
+Connection conn = DriverManager.getConnection(getUrl(), props);
+conn.createStatement().execute("CREATE SEQUENCE b.s1");
+conn.createStatement().execute("CREATE SEQUENCE a.s2");
+conn.createStatement().execute("CREATE SEQUENCE b.s3");
+conn.createStatement().execute("CREATE SEQUENCE c.s1");
+
+props.setProperty(PhoenixRuntime.CURRENT_SCN_ATTRIB, Long.toString(ts 
+ 20));
+conn = DriverManager.getConnection(getUrl(), props);
+DatabaseMetaData dbmd = conn.getMetaData();
+ResultSet rs = dbmd.getTables(null, null, null, new String[] {"FOO"});
+assertFalse(rs.next());
+
+rs = dbmd.getTables(null, null, null, new String[] 
{"FOO",PhoenixDatabaseMetaData.SEQUENCE_TABLE_TYPE});
+assertTrue(rs.next());
+assertNull(rs.getString("TABLE_CAT"));
+assertEquals("A", rs.getString("TABLE_SCHEM"));
+assertEquals("S2", rs.getString("TABLE_NAME"));
+assertTrue(rs.next());
+assertNull(rs.getString("TABLE_CAT"));
+assertEquals("B", rs.getString("TABLE_SCHEM"));
+assertEquals("S1", rs.getString("TABLE_NAME"));
+assertTrue(rs.next());
+assertNull(rs.getString("TABLE_CAT"));
+assertEquals("B", rs.getString("TABLE_SCHEM"));
+assertEquals("S3", rs.getString("TABLE_NAME"));
+assertTrue(rs.next());
+assertNull(rs.getString("TABLE_CAT"));
+assertEquals("C", rs.getString("TABLE_SCHEM"));
+assertEquals("S1", rs.getString("TABLE_NAME"));
+assertFalse(rs.next());
+
+conn.createStatement().execute("CREATE TABLE foo (k bigint primary 
key)");
+conn.createStatement().execute("CREATE TABLE z.bas (k bigint primary 
key)");
+
+props.setProperty(PhoenixRuntime.CURRENT_SCN_ATTRIB, Long.toString(ts 
+ 30));
+conn = 

phoenix git commit: PHOENIX-2489 Support sequence metadata access through DatabaseMetaData interface

[jamestaylor]

Repository: phoenix
Updated Branches:
  refs/heads/master 49618c835 -> f88cbf839


PHOENIX-2489 Support sequence metadata access through DatabaseMetaData interface


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

Branch: refs/heads/master
Commit: f88cbf8390b5a2f44a60cb9e585de5d2f08cefdb
Parents: 49618c8
Author: James Taylor 
Authored: Fri Jun 10 09:45:28 2016 -0700
Committer: James Taylor 
Committed: Fri Jun 10 09:45:28 2016 -0700

--
 .../end2end/QueryDatabaseMetaDataIT.java|  99 ++-
 .../apache/phoenix/compile/UnionCompiler.java   |   2 +-
 .../phoenix/filter/BooleanExpressionFilter.java |   1 +
 .../filter/MultiKeyValueComparisonFilter.java   |   1 -
 .../phoenix/jdbc/PhoenixDatabaseMetaData.java   | 167 +--
 .../org/apache/phoenix/schema/ValueSchema.java  |  30 ++--
 6 files changed, 234 insertions(+), 66 deletions(-)
--


http://git-wip-us.apache.org/repos/asf/phoenix/blob/f88cbf83/phoenix-core/src/it/java/org/apache/phoenix/end2end/QueryDatabaseMetaDataIT.java
--
diff --git 
a/phoenix-core/src/it/java/org/apache/phoenix/end2end/QueryDatabaseMetaDataIT.java
 
b/phoenix-core/src/it/java/org/apache/phoenix/end2end/QueryDatabaseMetaDataIT.java
index fbea0f0..167114a 100644
--- 
a/phoenix-core/src/it/java/org/apache/phoenix/end2end/QueryDatabaseMetaDataIT.java
+++ 
b/phoenix-core/src/it/java/org/apache/phoenix/end2end/QueryDatabaseMetaDataIT.java
@@ -175,6 +175,103 @@ public class QueryDatabaseMetaDataIT extends 
BaseClientManagedTimeIT {
 }
 
 @Test
+public void testTableTypes() throws SQLException {
+long ts = nextTimestamp();
+Properties props = new Properties();
+props.setProperty(PhoenixRuntime.CURRENT_SCN_ATTRIB, Long.toString(ts 
+ 10));
+Connection conn = DriverManager.getConnection(getUrl(), props);
+DatabaseMetaData dbmd = conn.getMetaData();
+ResultSet rs = dbmd.getTableTypes();
+assertTrue(rs.next());
+assertEquals("INDEX",rs.getString(1));
+assertTrue(rs.next());
+assertEquals("SEQUENCE",rs.getString(1));
+assertTrue(rs.next());
+assertEquals("SYSTEM TABLE",rs.getString(1));
+assertTrue(rs.next());
+assertEquals("TABLE",rs.getString(1));
+assertTrue(rs.next());
+assertEquals("VIEW",rs.getString(1));
+assertFalse(rs.next());
+}
+
+@Test
+public void testSequenceMetadataScan() throws SQLException {
+long ts = nextTimestamp();
+Properties props = new Properties();
+props.setProperty(PhoenixRuntime.CURRENT_SCN_ATTRIB, Long.toString(ts 
+ 10));
+Connection conn = DriverManager.getConnection(getUrl(), props);
+conn.createStatement().execute("CREATE SEQUENCE b.s1");
+conn.createStatement().execute("CREATE SEQUENCE a.s2");
+conn.createStatement().execute("CREATE SEQUENCE b.s3");
+conn.createStatement().execute("CREATE SEQUENCE c.s1");
+
+props.setProperty(PhoenixRuntime.CURRENT_SCN_ATTRIB, Long.toString(ts 
+ 20));
+conn = DriverManager.getConnection(getUrl(), props);
+DatabaseMetaData dbmd = conn.getMetaData();
+ResultSet rs = dbmd.getTables(null, null, null, new String[] {"FOO"});
+assertFalse(rs.next());
+
+rs = dbmd.getTables(null, null, null, new String[] 
{"FOO",PhoenixDatabaseMetaData.SEQUENCE_TABLE_TYPE});
+assertTrue(rs.next());
+assertNull(rs.getString("TABLE_CAT"));
+assertEquals("A", rs.getString("TABLE_SCHEM"));
+assertEquals("S2", rs.getString("TABLE_NAME"));
+assertTrue(rs.next());
+assertNull(rs.getString("TABLE_CAT"));
+assertEquals("B", rs.getString("TABLE_SCHEM"));
+assertEquals("S1", rs.getString("TABLE_NAME"));
+assertTrue(rs.next());
+assertNull(rs.getString("TABLE_CAT"));
+assertEquals("B", rs.getString("TABLE_SCHEM"));
+assertEquals("S3", rs.getString("TABLE_NAME"));
+assertTrue(rs.next());
+assertNull(rs.getString("TABLE_CAT"));
+assertEquals("C", rs.getString("TABLE_SCHEM"));
+assertEquals("S1", rs.getString("TABLE_NAME"));
+assertFalse(rs.next());
+
+conn.createStatement().execute("CREATE TABLE foo (k bigint primary 
key)");
+conn.createStatement().execute("CREATE TABLE z.bas (k bigint primary 
key)");
+
+props.setProperty(PhoenixRuntime.CURRENT_SCN_ATTRIB, Long.toString(ts 
+ 30));
+conn = 

Build failed in Jenkins: Phoenix | 4.x-HBase-0.98 #1172

[Apache Jenkins Server]

See 

Changes:

[ankitsinghal59] PHOENIX-2901 If namespaces are enabled, check for existence of 
schema

[ankitsinghal59] PHOENIX-2915 Dropping of Index can still leave some 
non-replayed writes

--
[...truncated 244 lines...]
Running org.apache.phoenix.expression.RegexpReplaceFunctionTest
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.009 sec - in 
org.apache.phoenix.expression.RegexpReplaceFunctionTest
Running org.apache.phoenix.expression.RegexpSubstrFunctionTest
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.007 sec - in 
org.apache.phoenix.expression.RegexpSubstrFunctionTest
Running org.apache.phoenix.expression.SignFunctionTest
Tests run: 25, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.135 sec - in 
org.apache.phoenix.expression.ArrayAppendFunctionTest
Running org.apache.phoenix.expression.StringToArrayFunctionTest
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.019 sec - in 
org.apache.phoenix.expression.SignFunctionTest
Running org.apache.phoenix.expression.ArrayConcatFunctionTest
Tests run: 20, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.025 sec - in 
org.apache.phoenix.expression.StringToArrayFunctionTest
Running org.apache.phoenix.expression.CoerceExpressionTest
Tests run: 5, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.005 sec - in 
org.apache.phoenix.expression.CoerceExpressionTest
Running org.apache.phoenix.expression.DeterminismTest
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.001 sec - in 
org.apache.phoenix.expression.DeterminismTest
Running org.apache.phoenix.expression.RegexpSplitFunctionTest
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.015 sec - in 
org.apache.phoenix.expression.RegexpSplitFunctionTest
Running org.apache.phoenix.util.DateUtilTest
Tests run: 22, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.033 sec - in 
org.apache.phoenix.util.DateUtilTest
Running org.apache.phoenix.util.ColumnInfoTest
Tests run: 5, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.006 sec - in 
org.apache.phoenix.util.ColumnInfoTest
Running org.apache.phoenix.util.ByteUtilTest
Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.073 sec - in 
org.apache.phoenix.util.ByteUtilTest
Running org.apache.phoenix.util.csv.CsvUpsertExecutorTest
Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.566 sec - in 
org.apache.phoenix.expression.GetSetByteBitFunctionTest
Running org.apache.phoenix.util.csv.StringToArrayConverterTest
Tests run: 35, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.635 sec - in 
org.apache.phoenix.expression.ArrayConcatFunctionTest
Running org.apache.phoenix.util.StringUtilTest
Tests run: 5, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.005 sec - in 
org.apache.phoenix.util.StringUtilTest
Running org.apache.phoenix.util.IndexUtilTest
Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.003 sec - in 
org.apache.phoenix.util.IndexUtilTest
Running org.apache.phoenix.util.LogUtilTest
Tests run: 6, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.549 sec - in 
org.apache.phoenix.util.csv.CsvUpsertExecutorTest
Running org.apache.phoenix.util.TenantIdByteConversionTest
Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.079 sec - in 
org.apache.phoenix.util.LogUtilTest
Running org.apache.phoenix.util.LikeExpressionTest
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.002 sec - in 
org.apache.phoenix.util.LikeExpressionTest
Running org.apache.phoenix.util.ScanUtilTest
Tests run: 18, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.038 sec - in 
org.apache.phoenix.util.TenantIdByteConversionTest
Running org.apache.phoenix.util.JDBCUtilTest
Tests run: 10, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.004 sec - in 
org.apache.phoenix.util.JDBCUtilTest
Running org.apache.phoenix.util.MetaDataUtilTest
Tests run: 20, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.024 sec - in 
org.apache.phoenix.util.ScanUtilTest
Running org.apache.phoenix.util.json.JsonUpsertExecutorTest
Tests run: 4, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.035 sec - in 
org.apache.phoenix.util.MetaDataUtilTest
Running org.apache.phoenix.util.PropertiesUtilTest
Tests run: 4, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.313 sec - in 
org.apache.phoenix.util.csv.StringToArrayConverterTest
Running org.apache.phoenix.util.SequenceUtilTest
Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.019 sec - in 
org.apache.phoenix.util.PropertiesUtilTest
Running org.apache.phoenix.util.QueryUtilTest
Tests run: 18, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.009 sec - in 
org.apache.phoenix.util.SequenceUtilTest
Running org.apache.phoenix.util.PhoenixEncodeDecodeTest
Tests run: 9, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.013 sec - in 

[1/2] phoenix git commit: PHOENIX-2901 If namespaces are enabled, check for existence of schema when sequence created

[ankit]

Repository: phoenix
Updated Branches:
  refs/heads/4.x-HBase-0.98 df65b174d -> 3c205ac49


PHOENIX-2901 If namespaces are enabled, check for existence of schema when 
sequence created


Project: http://git-wip-us.apache.org/repos/asf/phoenix/repo
Commit: http://git-wip-us.apache.org/repos/asf/phoenix/commit/45e4af51
Tree: http://git-wip-us.apache.org/repos/asf/phoenix/tree/45e4af51
Diff: http://git-wip-us.apache.org/repos/asf/phoenix/diff/45e4af51

Branch: refs/heads/4.x-HBase-0.98
Commit: 45e4af519ff90a7969ba0ef690c3a9c5fe178229
Parents: df65b17
Author: Ankit Singhal 
Authored: Fri Jun 10 16:49:54 2016 +0530
Committer: Ankit Singhal 
Committed: Fri Jun 10 16:49:54 2016 +0530

--
 .../org/apache/phoenix/end2end/SequenceIT.java  |  58 -
 .../end2end/TenantSpecificViewIndexIT.java  | 211 +--
 .../org/apache/phoenix/end2end/UpgradeIT.java   |  41 +++-
 .../phoenix/end2end/index/ViewIndexIT.java  |  22 +-
 .../apache/phoenix/compile/FromCompiler.java|   4 +
 .../phoenix/query/ConnectionQueryServices.java  |   1 -
 .../query/ConnectionQueryServicesImpl.java  |  26 ++-
 .../apache/phoenix/schema/MetaDataClient.java   |  21 +-
 .../org/apache/phoenix/util/MetaDataUtil.java   |  35 +--
 .../org/apache/phoenix/util/PhoenixRuntime.java |   6 +-
 .../org/apache/phoenix/util/UpgradeUtil.java|  55 -
 11 files changed, 367 insertions(+), 113 deletions(-)
--


http://git-wip-us.apache.org/repos/asf/phoenix/blob/45e4af51/phoenix-core/src/it/java/org/apache/phoenix/end2end/SequenceIT.java
--
diff --git 
a/phoenix-core/src/it/java/org/apache/phoenix/end2end/SequenceIT.java 
b/phoenix-core/src/it/java/org/apache/phoenix/end2end/SequenceIT.java
index 3e7ec31..3ed4fd7 100644
--- a/phoenix-core/src/it/java/org/apache/phoenix/end2end/SequenceIT.java
+++ b/phoenix-core/src/it/java/org/apache/phoenix/end2end/SequenceIT.java
@@ -37,6 +37,7 @@ import java.util.Properties;
 import org.apache.phoenix.exception.SQLExceptionCode;
 import org.apache.phoenix.jdbc.PhoenixStatement;
 import org.apache.phoenix.query.QueryServices;
+import org.apache.phoenix.schema.SchemaNotFoundException;
 import org.apache.phoenix.schema.SequenceAlreadyExistsException;
 import org.apache.phoenix.schema.SequenceNotFoundException;
 import org.apache.phoenix.util.PhoenixRuntime;
@@ -110,6 +111,49 @@ public class SequenceIT extends BaseClientManagedTimeIT {
}
}

+@Test
+public void testCreateSequenceWhenNamespaceEnabled() throws Exception {
+Properties props = PropertiesUtil.deepCopy(TEST_PROPERTIES);
+props.setProperty(QueryServices.IS_NAMESPACE_MAPPING_ENABLED, 
Boolean.toString(true));
+String sequenceSchemaName = "ALPHA";
+String sequenceName = sequenceSchemaName + ".M_OMEGA";
+
+nextConnection(props);
+try {
+conn.createStatement().execute("CREATE SEQUENCE " + sequenceName + 
" START WITH 2 INCREMENT BY 4");
+fail();
+} catch (SchemaNotFoundException e) {
+// expected
+}
+
+conn.createStatement().execute("CREATE SCHEMA " + sequenceSchemaName);
+nextConnection(props);
+conn.createStatement().execute("CREATE SEQUENCE " + sequenceName + " 
START WITH 2 INCREMENT BY 4");
+sequenceSchemaName = "TEST_SEQ_SCHEMA";
+sequenceName = "M_SEQ";
+conn.createStatement().execute("CREATE SCHEMA " + sequenceSchemaName);
+nextConnection(props);
+conn.createStatement().execute("USE " + sequenceSchemaName);
+conn.createStatement().execute("CREATE SEQUENCE " + sequenceName + " 
START WITH 2 INCREMENT BY 4");
+nextConnection(props);
+String query = "SELECT sequence_schema, sequence_name, current_value, 
increment_by FROM SYSTEM.\"SEQUENCE\" WHERE sequence_name='"
++ sequenceName + "'";
+ResultSet rs = conn.prepareStatement(query).executeQuery();
+assertTrue(rs.next());
+assertEquals(sequenceSchemaName, rs.getString("sequence_schema"));
+assertEquals(sequenceName, rs.getString("sequence_name"));
+assertEquals(2, rs.getInt("current_value"));
+assertEquals(4, rs.getInt("increment_by"));
+assertFalse(rs.next());
+try {
+conn.createStatement().execute(
+"CREATE SEQUENCE " + sequenceSchemaName + "." + 
sequenceName + " START WITH 2 INCREMENT BY 4");
+fail();
+} catch (SequenceAlreadyExistsException e) {
+
+}
+}
+   
@Test
 public void testCreateSequence() throws Exception { 
 nextConnection();
@@ -696,15 +740,19 @@ public class SequenceIT extends BaseClientManagedTimeIT {
 

[2/2] phoenix git commit: PHOENIX-2915 Dropping of Index can still leave some non-replayed writes in WAL

[ankit]

PHOENIX-2915 Dropping of Index can still leave some non-replayed writes in WAL


Project: http://git-wip-us.apache.org/repos/asf/phoenix/repo
Commit: http://git-wip-us.apache.org/repos/asf/phoenix/commit/3c205ac4
Tree: http://git-wip-us.apache.org/repos/asf/phoenix/tree/3c205ac4
Diff: http://git-wip-us.apache.org/repos/asf/phoenix/diff/3c205ac4

Branch: refs/heads/4.x-HBase-0.98
Commit: 3c205ac498e5873541bfcf26dea781a58cc22d3a
Parents: 45e4af5
Author: Ankit Singhal 
Authored: Fri Jun 10 16:50:46 2016 +0530
Committer: Ankit Singhal 
Committed: Fri Jun 10 16:50:46 2016 +0530

--
 .../query/ConnectionQueryServicesImpl.java  | 58 +---
 1 file changed, 39 insertions(+), 19 deletions(-)
--


http://git-wip-us.apache.org/repos/asf/phoenix/blob/3c205ac4/phoenix-core/src/main/java/org/apache/phoenix/query/ConnectionQueryServicesImpl.java
--
diff --git 
a/phoenix-core/src/main/java/org/apache/phoenix/query/ConnectionQueryServicesImpl.java
 
b/phoenix-core/src/main/java/org/apache/phoenix/query/ConnectionQueryServicesImpl.java
index fad79b8..b086113 100644
--- 
a/phoenix-core/src/main/java/org/apache/phoenix/query/ConnectionQueryServicesImpl.java
+++ 
b/phoenix-core/src/main/java/org/apache/phoenix/query/ConnectionQueryServicesImpl.java
@@ -1531,7 +1531,8 @@ public class ConnectionQueryServicesImpl extends 
DelegateQueryServices implement
 }
 
 @Override
-public MetaDataMutationResult dropTable(final List 
tableMetaData, final PTableType tableType, final boolean cascade) throws 
SQLException {
+public MetaDataMutationResult dropTable(final List 
tableMetaData, final PTableType tableType,
+final boolean cascade) throws SQLException {
 byte[][] rowKeyMetadata = new byte[3][];
 SchemaUtil.getVarChars(tableMetaData.get(0).getRow(), rowKeyMetadata);
 byte[] tenantIdBytes = 
rowKeyMetadata[PhoenixDatabaseMetaData.TENANT_ID_INDEX];
@@ -1566,18 +1567,14 @@ public class ConnectionQueryServicesImpl extends 
DelegateQueryServices implement
 case TABLE_ALREADY_EXISTS:
 ReadOnlyProps props = this.getProps();
 boolean dropMetadata = props.getBoolean(DROP_METADATA_ATTRIB, 
DEFAULT_DROP_METADATA);
+PTable table = result.getTable();
 if (dropMetadata) {
+flushParentPhysicalTable(table);
 dropTables(result.getTableNamesToDelete());
 }
 invalidateTables(result.getTableNamesToDelete());
 if (tableType == PTableType.TABLE) {
-boolean isNamespaceMapped = 
result.getTable().isNamespaceMapped();
-byte[] physicalName;
-if (!isNamespaceMapped) {
-physicalName = SchemaUtil.getTableNameAsBytes(schemaBytes, 
tableBytes);
-} else {
-physicalName = TableName.valueOf(schemaBytes, 
tableBytes).getName();
-}
+byte[] physicalName = table.getPhysicalName().getBytes();
 long timestamp = 
MetaDataUtil.getClientTimeStamp(tableMetaData);
 ensureViewIndexTableDropped(physicalName, timestamp);
 ensureLocalIndexTableDropped(physicalName, timestamp);
@@ -1590,6 +1587,25 @@ public class ConnectionQueryServicesImpl extends 
DelegateQueryServices implement
   return result;
 }
 
+/*
+ * PHOENIX-2915 while dropping index, flush data table to avoid stale WAL 
edits of indexes 1. Flush parent table if
+ * dropping view has indexes 2. Dropping table indexes 3. Dropping view 
indexes
+ */
+private void flushParentPhysicalTable(PTable table) throws SQLException {
+byte[] parentPhysicalTableName = null;
+if (PTableType.VIEW == table.getType()) {
+if (!table.getIndexes().isEmpty()) {
+parentPhysicalTableName = table.getPhysicalName().getBytes();
+}
+} else if (PTableType.INDEX == table.getType()) {
+PTable parentTable = getTable(null, 
table.getParentName().getString(), HConstants.LATEST_TIMESTAMP);
+parentPhysicalTableName = parentTable.getPhysicalName().getBytes();
+}
+if (parentPhysicalTableName != null) {
+flushTable(parentPhysicalTableName);
+}
+}
+
 @Override
 public MetaDataMutationResult dropFunction(final List 
functionData, final boolean ifExists) throws SQLException {
 byte[][] rowKeyMetadata = new byte[2][];
@@ -1661,31 +1677,35 @@ public class ConnectionQueryServicesImpl extends 
DelegateQueryServices implement
 
 private void ensureViewIndexTableCreated(PName tenantId, byte[] 
physicalIndexTableName, long timestamp,
 boolean isNamespaceMapped) 

Build failed in Jenkins: Phoenix-4.x-HBase-1.0 #494

[Apache Jenkins Server]

See 

Changes:

[ankitsinghal59] PHOENIX-2901 If namespaces are enabled, check for existence of 
schema

[ankitsinghal59] PHOENIX-2915 Dropping of Index can still leave some 
non-replayed writes

--
[...truncated 245 lines...]
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.015 sec - in 
org.apache.phoenix.expression.RegexpReplaceFunctionTest
Running org.apache.phoenix.expression.RegexpSubstrFunctionTest
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.01 sec - in 
org.apache.phoenix.expression.RegexpSubstrFunctionTest
Running org.apache.phoenix.expression.SignFunctionTest
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.021 sec - in 
org.apache.phoenix.expression.SignFunctionTest
Running org.apache.phoenix.expression.StringToArrayFunctionTest
Tests run: 20, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.021 sec - in 
org.apache.phoenix.expression.StringToArrayFunctionTest
Running org.apache.phoenix.expression.ArrayConcatFunctionTest
Tests run: 24, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.201 sec - in 
org.apache.phoenix.expression.SortOrderExpressionTest
Running org.apache.phoenix.expression.CoerceExpressionTest
Tests run: 5, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.004 sec - in 
org.apache.phoenix.expression.CoerceExpressionTest
Running org.apache.phoenix.expression.DeterminismTest
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.001 sec - in 
org.apache.phoenix.expression.DeterminismTest
Running org.apache.phoenix.expression.RegexpSplitFunctionTest
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.067 sec - in 
org.apache.phoenix.expression.RegexpSplitFunctionTest
Running org.apache.phoenix.util.DateUtilTest
Tests run: 22, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.092 sec - in 
org.apache.phoenix.util.DateUtilTest
Running org.apache.phoenix.util.ColumnInfoTest
Tests run: 5, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.008 sec - in 
org.apache.phoenix.util.ColumnInfoTest
Running org.apache.phoenix.util.ByteUtilTest
Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.041 sec - in 
org.apache.phoenix.util.ByteUtilTest
Running org.apache.phoenix.util.csv.CsvUpsertExecutorTest
Tests run: 35, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.481 sec - in 
org.apache.phoenix.expression.ArrayConcatFunctionTest
Running org.apache.phoenix.util.csv.StringToArrayConverterTest
Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.81 sec - in 
org.apache.phoenix.expression.GetSetByteBitFunctionTest
Running org.apache.phoenix.util.StringUtilTest
Tests run: 5, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.004 sec - in 
org.apache.phoenix.util.StringUtilTest
Running org.apache.phoenix.util.IndexUtilTest
Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.002 sec - in 
org.apache.phoenix.util.IndexUtilTest
Running org.apache.phoenix.util.LogUtilTest
Tests run: 4, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.297 sec - in 
org.apache.phoenix.util.csv.StringToArrayConverterTest
Running org.apache.phoenix.util.TenantIdByteConversionTest
Tests run: 6, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.546 sec - in 
org.apache.phoenix.util.csv.CsvUpsertExecutorTest
Running org.apache.phoenix.util.LikeExpressionTest
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.002 sec - in 
org.apache.phoenix.util.LikeExpressionTest
Running org.apache.phoenix.util.ScanUtilTest
Tests run: 18, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.039 sec - in 
org.apache.phoenix.util.TenantIdByteConversionTest
Running org.apache.phoenix.util.JDBCUtilTest
Tests run: 12, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.007 sec - in 
org.apache.phoenix.util.JDBCUtilTest
Running org.apache.phoenix.util.MetaDataUtilTest
Tests run: 20, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.036 sec - in 
org.apache.phoenix.util.ScanUtilTest
Running org.apache.phoenix.util.json.JsonUpsertExecutorTest
Tests run: 4, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.049 sec - in 
org.apache.phoenix.util.MetaDataUtilTest
Running org.apache.phoenix.util.PropertiesUtilTest
Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.024 sec - in 
org.apache.phoenix.util.PropertiesUtilTest
Running org.apache.phoenix.util.SequenceUtilTest
Tests run: 18, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.018 sec - in 
org.apache.phoenix.util.SequenceUtilTest
Running org.apache.phoenix.util.QueryUtilTest
Tests run: 9, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.01 sec - in 
org.apache.phoenix.util.QueryUtilTest
Running org.apache.phoenix.util.PhoenixEncodeDecodeTest
Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.292 sec - in 
org.apache.phoenix.util.LogUtilTest
Running org.apache.phoenix.util.PhoenixRuntimeTest
Tests run: 4, 

Build failed in Jenkins: Phoenix-4.x-HBase-1.1 #48

[Apache Jenkins Server]

See 

Changes:

[ankitsinghal59] PHOENIX-2901 If namespaces are enabled, check for existence of 
schema

--
[...truncated 238 lines...]
Running org.apache.phoenix.hbase.index.covered.TestCoveredColumns
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.002 sec - in 
org.apache.phoenix.hbase.index.covered.TestCoveredColumns
Running org.apache.phoenix.hbase.index.covered.filter.TestNewerTimestampFilter
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.003 sec - in 
org.apache.phoenix.hbase.index.covered.filter.TestNewerTimestampFilter
Running 
org.apache.phoenix.hbase.index.covered.filter.TestApplyAndFilterDeletesFilter
Tests run: 6, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.01 sec - in 
org.apache.phoenix.hbase.index.covered.filter.TestApplyAndFilterDeletesFilter
Running org.apache.phoenix.hbase.index.covered.data.TestIndexMemStore
Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.01 sec - in 
org.apache.phoenix.hbase.index.covered.data.TestIndexMemStore
Running org.apache.phoenix.hbase.index.covered.update.TestIndexUpdateManager
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.133 sec - in 
org.apache.phoenix.iterate.AggregateResultScannerTest
Running org.apache.phoenix.hbase.index.covered.example.TestColumnTracker
Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.004 sec - in 
org.apache.phoenix.hbase.index.covered.example.TestColumnTracker
Running 
org.apache.phoenix.hbase.index.covered.example.TestCoveredIndexSpecifierBuilder
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.005 sec - in 
org.apache.phoenix.hbase.index.covered.example.TestCoveredIndexSpecifierBuilder
Running 
org.apache.phoenix.hbase.index.covered.example.TestCoveredColumnIndexCodec
Tests run: 9, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.571 sec - in 
org.apache.phoenix.mapreduce.util.PhoenixConfigurationUtilTest
Running org.apache.phoenix.hbase.index.covered.TestLocalTableState
Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.136 sec - in 
org.apache.phoenix.hbase.index.covered.TestLocalTableState
Running org.apache.phoenix.hbase.index.write.TestCachingHTableFactory
Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.171 sec - in 
org.apache.phoenix.hbase.index.covered.example.TestCoveredColumnIndexCodec
Running org.apache.phoenix.hbase.index.write.TestParalleWriterIndexCommitter
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.032 sec - in 
org.apache.phoenix.hbase.index.write.TestCachingHTableFactory
Running org.apache.phoenix.hbase.index.write.TestWALRecoveryCaching
Tests run: 1, Failures: 0, Errors: 0, Skipped: 1, Time elapsed: 0.007 sec - in 
org.apache.phoenix.hbase.index.write.TestWALRecoveryCaching
Running 
org.apache.phoenix.hbase.index.write.recovery.TestPerRegionIndexWriteCache
Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.231 sec - in 
org.apache.phoenix.hbase.index.covered.update.TestIndexUpdateManager
Running org.apache.phoenix.hbase.index.write.TestIndexWriter
Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.067 sec - in 
org.apache.phoenix.hbase.index.write.TestParalleWriterIndexCommitter
Running org.apache.phoenix.hbase.index.write.TestParalleIndexWriter
Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.005 sec - in 
org.apache.phoenix.hbase.index.write.TestParalleIndexWriter
Running org.apache.phoenix.hbase.index.parallel.TestThreadPoolBuilder
Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.002 sec - in 
org.apache.phoenix.hbase.index.parallel.TestThreadPoolBuilder
Running org.apache.phoenix.hbase.index.parallel.TestThreadPoolManager
Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.005 sec - in 
org.apache.phoenix.hbase.index.parallel.TestThreadPoolManager
Running org.apache.phoenix.hbase.index.util.TestIndexManagementUtil
Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.014 sec - in 
org.apache.phoenix.hbase.index.util.TestIndexManagementUtil
Running org.apache.phoenix.trace.TraceMetricsSourceTest
Tests run: 5, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.218 sec - in 
org.apache.phoenix.hbase.index.write.TestIndexWriter
Running org.apache.phoenix.jdbc.PhoenixResultSetMetadataTest
Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.18 sec - in 
org.apache.phoenix.trace.TraceMetricsSourceTest
Running org.apache.phoenix.jdbc.PhoenixPreparedStatementTest
Tests run: 11, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.224 sec - in 
org.apache.phoenix.jdbc.PhoenixPreparedStatementTest
Running org.apache.phoenix.jdbc.ReadOnlyPropertiesTest
Tests run: 4, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.003 sec - in 
org.apache.phoenix.jdbc.ReadOnlyPropertiesTest
Running org.apache.phoenix.jdbc.PhoenixDriverTest
Tests run: 3, 

phoenix git commit: PHOENIX-2901 If namespaces are enabled, check for existence of schema when sequence created(Addendum)

[ankit]

Repository: phoenix
Updated Branches:
  refs/heads/4.x-HBase-1.1 5fc6fa184 -> 79bd03e08


PHOENIX-2901 If namespaces are enabled, check for existence of schema when 
sequence created(Addendum)


Project: http://git-wip-us.apache.org/repos/asf/phoenix/repo
Commit: http://git-wip-us.apache.org/repos/asf/phoenix/commit/79bd03e0
Tree: http://git-wip-us.apache.org/repos/asf/phoenix/tree/79bd03e0
Diff: http://git-wip-us.apache.org/repos/asf/phoenix/diff/79bd03e0

Branch: refs/heads/4.x-HBase-1.1
Commit: 79bd03e08547e0180eac4177105c50aa148ecfc3
Parents: 5fc6fa1
Author: Ankit Singhal 
Authored: Fri Jun 10 16:33:34 2016 +0530
Committer: Ankit Singhal 
Committed: Fri Jun 10 16:33:34 2016 +0530

--
 .../org/apache/phoenix/end2end/TenantSpecificViewIndexIT.java   | 5 +++--
 1 file changed, 3 insertions(+), 2 deletions(-)
--


http://git-wip-us.apache.org/repos/asf/phoenix/blob/79bd03e0/phoenix-core/src/it/java/org/apache/phoenix/end2end/TenantSpecificViewIndexIT.java
--
diff --git 
a/phoenix-core/src/it/java/org/apache/phoenix/end2end/TenantSpecificViewIndexIT.java
 
b/phoenix-core/src/it/java/org/apache/phoenix/end2end/TenantSpecificViewIndexIT.java
index 69d9140..9f95a77 100644
--- 
a/phoenix-core/src/it/java/org/apache/phoenix/end2end/TenantSpecificViewIndexIT.java
+++ 
b/phoenix-core/src/it/java/org/apache/phoenix/end2end/TenantSpecificViewIndexIT.java
@@ -199,8 +199,9 @@ public class TenantSpecificViewIndexIT extends 
BaseTenantSpecificViewIndexIT {
 rs = conn.createStatement().executeQuery("explain select pk2,col1 from 
" + viewName + " where col1='f'");
 if (localIndex) {
 assertEquals("CLIENT PARALLEL 1-WAY RANGE SCAN OVER "
-+ SchemaUtil.getPhysicalHBaseTableName(tableName, 
isNamespaceMapped, PTableType.TABLE) + " ['"
-+ tenantId + "',1,'f']\n" + "SERVER FILTER BY FIRST 
KEY ONLY\n" + "CLIENT MERGE SORT",
++ 
Bytes.toString(MetaDataUtil.getLocalIndexPhysicalName(SchemaUtil
+.getPhysicalHBaseTableName(tableName, 
isNamespaceMapped, PTableType.TABLE).getBytes())) + " ['"
++ tenantId + "',-32768,'f']\n" + "SERVER FILTER BY 
FIRST KEY ONLY\n" + "CLIENT MERGE SORT",
 QueryUtil.getExplainPlan(rs));
 } else {
 assertEquals("CLIENT PARALLEL 1-WAY RANGE SCAN OVER "

[2/2] phoenix git commit: PHOENIX-2915 Dropping of Index can still leave some non-replayed writes in WAL

[ankit]

PHOENIX-2915 Dropping of Index can still leave some non-replayed writes in WAL


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

Branch: refs/heads/4.x-HBase-1.0
Commit: a747b459a15ed271f536b1b08fab416eb5f03fb7
Parents: 5a5da14
Author: Ankit Singhal 
Authored: Fri Jun 10 16:26:08 2016 +0530
Committer: Ankit Singhal 
Committed: Fri Jun 10 16:26:08 2016 +0530

--
 .../query/ConnectionQueryServicesImpl.java  | 58 +---
 1 file changed, 39 insertions(+), 19 deletions(-)
--


http://git-wip-us.apache.org/repos/asf/phoenix/blob/a747b459/phoenix-core/src/main/java/org/apache/phoenix/query/ConnectionQueryServicesImpl.java
--
diff --git 
a/phoenix-core/src/main/java/org/apache/phoenix/query/ConnectionQueryServicesImpl.java
 
b/phoenix-core/src/main/java/org/apache/phoenix/query/ConnectionQueryServicesImpl.java
index c6d8683..b51be5d 100644
--- 
a/phoenix-core/src/main/java/org/apache/phoenix/query/ConnectionQueryServicesImpl.java
+++ 
b/phoenix-core/src/main/java/org/apache/phoenix/query/ConnectionQueryServicesImpl.java
@@ -1530,7 +1530,8 @@ public class ConnectionQueryServicesImpl extends 
DelegateQueryServices implement
 }
 
 @Override
-public MetaDataMutationResult dropTable(final List 
tableMetaData, final PTableType tableType, final boolean cascade) throws 
SQLException {
+public MetaDataMutationResult dropTable(final List 
tableMetaData, final PTableType tableType,
+final boolean cascade) throws SQLException {
 byte[][] rowKeyMetadata = new byte[3][];
 SchemaUtil.getVarChars(tableMetaData.get(0).getRow(), rowKeyMetadata);
 byte[] tenantIdBytes = 
rowKeyMetadata[PhoenixDatabaseMetaData.TENANT_ID_INDEX];
@@ -1565,18 +1566,14 @@ public class ConnectionQueryServicesImpl extends 
DelegateQueryServices implement
 case TABLE_ALREADY_EXISTS:
 ReadOnlyProps props = this.getProps();
 boolean dropMetadata = props.getBoolean(DROP_METADATA_ATTRIB, 
DEFAULT_DROP_METADATA);
+PTable table = result.getTable();
 if (dropMetadata) {
+flushParentPhysicalTable(table);
 dropTables(result.getTableNamesToDelete());
 }
 invalidateTables(result.getTableNamesToDelete());
 if (tableType == PTableType.TABLE) {
-boolean isNamespaceMapped = 
result.getTable().isNamespaceMapped();
-byte[] physicalName;
-if (!isNamespaceMapped) {
-physicalName = SchemaUtil.getTableNameAsBytes(schemaBytes, 
tableBytes);
-} else {
-physicalName = TableName.valueOf(schemaBytes, 
tableBytes).getName();
-}
+byte[] physicalName = table.getPhysicalName().getBytes();
 long timestamp = 
MetaDataUtil.getClientTimeStamp(tableMetaData);
 ensureViewIndexTableDropped(physicalName, timestamp);
 ensureLocalIndexTableDropped(physicalName, timestamp);
@@ -1589,6 +1586,25 @@ public class ConnectionQueryServicesImpl extends 
DelegateQueryServices implement
   return result;
 }
 
+/*
+ * PHOENIX-2915 while dropping index, flush data table to avoid stale WAL 
edits of indexes 1. Flush parent table if
+ * dropping view has indexes 2. Dropping table indexes 3. Dropping view 
indexes
+ */
+private void flushParentPhysicalTable(PTable table) throws SQLException {
+byte[] parentPhysicalTableName = null;
+if (PTableType.VIEW == table.getType()) {
+if (!table.getIndexes().isEmpty()) {
+parentPhysicalTableName = table.getPhysicalName().getBytes();
+}
+} else if (PTableType.INDEX == table.getType()) {
+PTable parentTable = getTable(null, 
table.getParentName().getString(), HConstants.LATEST_TIMESTAMP);
+parentPhysicalTableName = parentTable.getPhysicalName().getBytes();
+}
+if (parentPhysicalTableName != null) {
+flushTable(parentPhysicalTableName);
+}
+}
+
 @Override
 public MetaDataMutationResult dropFunction(final List 
functionData, final boolean ifExists) throws SQLException {
 byte[][] rowKeyMetadata = new byte[2][];
@@ -1660,31 +1676,35 @@ public class ConnectionQueryServicesImpl extends 
DelegateQueryServices implement
 
 private void ensureViewIndexTableCreated(PName tenantId, byte[] 
physicalIndexTableName, long timestamp,
 boolean isNamespaceMapped) 

[1/2] phoenix git commit: PHOENIX-2901 If namespaces are enabled, check for existence of schema when sequence created

[ankit]

Repository: phoenix
Updated Branches:
  refs/heads/4.x-HBase-1.1 891131c78 -> 5fc6fa184


PHOENIX-2901 If namespaces are enabled, check for existence of schema when 
sequence created


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

Branch: refs/heads/4.x-HBase-1.1
Commit: a50bee213269e249c8f4bbae0242aa5a3a3b8341
Parents: 891131c
Author: Ankit Singhal 
Authored: Fri Jun 10 16:09:13 2016 +0530
Committer: Ankit Singhal 
Committed: Fri Jun 10 16:09:13 2016 +0530

--
 .../org/apache/phoenix/end2end/SequenceIT.java  |  58 -
 .../end2end/TenantSpecificViewIndexIT.java  | 211 +--
 .../org/apache/phoenix/end2end/UpgradeIT.java   |  41 +++-
 .../phoenix/end2end/index/ViewIndexIT.java  |  22 +-
 .../apache/phoenix/compile/FromCompiler.java|   4 +
 .../phoenix/query/ConnectionQueryServices.java  |   1 -
 .../query/ConnectionQueryServicesImpl.java  |  26 ++-
 .../apache/phoenix/schema/MetaDataClient.java   |  21 +-
 .../org/apache/phoenix/util/MetaDataUtil.java   |  36 ++--
 .../org/apache/phoenix/util/PhoenixRuntime.java |   6 +-
 .../org/apache/phoenix/util/UpgradeUtil.java|  55 -
 11 files changed, 367 insertions(+), 114 deletions(-)
--


http://git-wip-us.apache.org/repos/asf/phoenix/blob/a50bee21/phoenix-core/src/it/java/org/apache/phoenix/end2end/SequenceIT.java
--
diff --git 
a/phoenix-core/src/it/java/org/apache/phoenix/end2end/SequenceIT.java 
b/phoenix-core/src/it/java/org/apache/phoenix/end2end/SequenceIT.java
index 3e7ec31..3ed4fd7 100644
--- a/phoenix-core/src/it/java/org/apache/phoenix/end2end/SequenceIT.java
+++ b/phoenix-core/src/it/java/org/apache/phoenix/end2end/SequenceIT.java
@@ -37,6 +37,7 @@ import java.util.Properties;
 import org.apache.phoenix.exception.SQLExceptionCode;
 import org.apache.phoenix.jdbc.PhoenixStatement;
 import org.apache.phoenix.query.QueryServices;
+import org.apache.phoenix.schema.SchemaNotFoundException;
 import org.apache.phoenix.schema.SequenceAlreadyExistsException;
 import org.apache.phoenix.schema.SequenceNotFoundException;
 import org.apache.phoenix.util.PhoenixRuntime;
@@ -110,6 +111,49 @@ public class SequenceIT extends BaseClientManagedTimeIT {
}
}

+@Test
+public void testCreateSequenceWhenNamespaceEnabled() throws Exception {
+Properties props = PropertiesUtil.deepCopy(TEST_PROPERTIES);
+props.setProperty(QueryServices.IS_NAMESPACE_MAPPING_ENABLED, 
Boolean.toString(true));
+String sequenceSchemaName = "ALPHA";
+String sequenceName = sequenceSchemaName + ".M_OMEGA";
+
+nextConnection(props);
+try {
+conn.createStatement().execute("CREATE SEQUENCE " + sequenceName + 
" START WITH 2 INCREMENT BY 4");
+fail();
+} catch (SchemaNotFoundException e) {
+// expected
+}
+
+conn.createStatement().execute("CREATE SCHEMA " + sequenceSchemaName);
+nextConnection(props);
+conn.createStatement().execute("CREATE SEQUENCE " + sequenceName + " 
START WITH 2 INCREMENT BY 4");
+sequenceSchemaName = "TEST_SEQ_SCHEMA";
+sequenceName = "M_SEQ";
+conn.createStatement().execute("CREATE SCHEMA " + sequenceSchemaName);
+nextConnection(props);
+conn.createStatement().execute("USE " + sequenceSchemaName);
+conn.createStatement().execute("CREATE SEQUENCE " + sequenceName + " 
START WITH 2 INCREMENT BY 4");
+nextConnection(props);
+String query = "SELECT sequence_schema, sequence_name, current_value, 
increment_by FROM SYSTEM.\"SEQUENCE\" WHERE sequence_name='"
++ sequenceName + "'";
+ResultSet rs = conn.prepareStatement(query).executeQuery();
+assertTrue(rs.next());
+assertEquals(sequenceSchemaName, rs.getString("sequence_schema"));
+assertEquals(sequenceName, rs.getString("sequence_name"));
+assertEquals(2, rs.getInt("current_value"));
+assertEquals(4, rs.getInt("increment_by"));
+assertFalse(rs.next());
+try {
+conn.createStatement().execute(
+"CREATE SEQUENCE " + sequenceSchemaName + "." + 
sequenceName + " START WITH 2 INCREMENT BY 4");
+fail();
+} catch (SequenceAlreadyExistsException e) {
+
+}
+}
+   
@Test
 public void testCreateSequence() throws Exception { 
 nextConnection();
@@ -696,15 +740,19 @@ public class SequenceIT extends BaseClientManagedTimeIT {
 

Build failed in Jenkins: Phoenix | Master #1251

[Apache Jenkins Server]

See 

Changes:

[ankitsinghal59] PHOENIX-2901 If namespaces are enabled, check for existence of 
schema

[ankitsinghal59] PHOENIX-2915 Dropping of Index can still leave some 
non-replayed writes

--
[...truncated 263 lines...]
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.001 sec - in 
org.apache.phoenix.hbase.index.covered.filter.TestNewerTimestampFilter
Running 
org.apache.phoenix.hbase.index.covered.filter.TestApplyAndFilterDeletesFilter
Tests run: 6, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.005 sec - in 
org.apache.phoenix.hbase.index.covered.filter.TestApplyAndFilterDeletesFilter
Running org.apache.phoenix.hbase.index.covered.data.TestIndexMemStore
Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.007 sec - in 
org.apache.phoenix.hbase.index.covered.data.TestIndexMemStore
Running org.apache.phoenix.hbase.index.covered.update.TestIndexUpdateManager
Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.004 sec - in 
org.apache.phoenix.hbase.index.covered.update.TestIndexUpdateManager
Running org.apache.phoenix.hbase.index.covered.example.TestColumnTracker
Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.002 sec - in 
org.apache.phoenix.hbase.index.covered.example.TestColumnTracker
Running 
org.apache.phoenix.hbase.index.covered.example.TestCoveredIndexSpecifierBuilder
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.003 sec - in 
org.apache.phoenix.hbase.index.covered.example.TestCoveredIndexSpecifierBuilder
Running 
org.apache.phoenix.hbase.index.covered.example.TestCoveredColumnIndexCodec
Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.032 sec - in 
org.apache.phoenix.hbase.index.covered.example.TestCoveredColumnIndexCodec
Running org.apache.phoenix.hbase.index.covered.TestLocalTableState
Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.087 sec - in 
org.apache.phoenix.hbase.index.covered.TestLocalTableState
Running org.apache.phoenix.hbase.index.write.TestCachingHTableFactory
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.037 sec - in 
org.apache.phoenix.hbase.index.write.TestCachingHTableFactory
Running org.apache.phoenix.hbase.index.write.TestParalleWriterIndexCommitter
Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.036 sec - in 
org.apache.phoenix.hbase.index.write.TestParalleWriterIndexCommitter
Running org.apache.phoenix.hbase.index.write.TestWALRecoveryCaching
Tests run: 1, Failures: 0, Errors: 0, Skipped: 1, Time elapsed: 0.005 sec - in 
org.apache.phoenix.hbase.index.write.TestWALRecoveryCaching
Running 
org.apache.phoenix.hbase.index.write.recovery.TestPerRegionIndexWriteCache
Tests run: 9, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.673 sec - in 
org.apache.phoenix.mapreduce.util.PhoenixConfigurationUtilTest
Running org.apache.phoenix.hbase.index.write.TestIndexWriter
Tests run: 5, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.212 sec - in 
org.apache.phoenix.hbase.index.write.TestIndexWriter
Running org.apache.phoenix.hbase.index.write.TestParalleIndexWriter
Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.015 sec - in 
org.apache.phoenix.hbase.index.write.TestParalleIndexWriter
Running org.apache.phoenix.hbase.index.parallel.TestThreadPoolBuilder
Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.002 sec - in 
org.apache.phoenix.hbase.index.parallel.TestThreadPoolBuilder
Running org.apache.phoenix.hbase.index.parallel.TestThreadPoolManager
Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.005 sec - in 
org.apache.phoenix.hbase.index.parallel.TestThreadPoolManager
Running org.apache.phoenix.hbase.index.util.TestIndexManagementUtil
Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.01 sec - in 
org.apache.phoenix.hbase.index.util.TestIndexManagementUtil
Running org.apache.phoenix.trace.TraceMetricsSourceTest
Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.421 sec - in 
org.apache.phoenix.hbase.index.write.recovery.TestPerRegionIndexWriteCache
Running org.apache.phoenix.jdbc.PhoenixResultSetMetadataTest
Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.182 sec - in 
org.apache.phoenix.trace.TraceMetricsSourceTest
Running org.apache.phoenix.jdbc.PhoenixPreparedStatementTest
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.181 sec - in 
org.apache.phoenix.jdbc.PhoenixResultSetMetadataTest
Running org.apache.phoenix.jdbc.ReadOnlyPropertiesTest
Tests run: 4, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.003 sec - in 
org.apache.phoenix.jdbc.ReadOnlyPropertiesTest
Running org.apache.phoenix.jdbc.PhoenixDriverTest
Tests run: 11, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.132 sec - in 
org.apache.phoenix.jdbc.PhoenixPreparedStatementTest
Running org.apache.phoenix.jdbc.PhoenixEmbeddedDriverTest

[2/2] phoenix git commit: PHOENIX-2915 Dropping of Index can still leave some non-replayed writes in WAL

[ankit]

PHOENIX-2915 Dropping of Index can still leave some non-replayed writes in WAL


Project: http://git-wip-us.apache.org/repos/asf/phoenix/repo
Commit: http://git-wip-us.apache.org/repos/asf/phoenix/commit/49618c83
Tree: http://git-wip-us.apache.org/repos/asf/phoenix/tree/49618c83
Diff: http://git-wip-us.apache.org/repos/asf/phoenix/diff/49618c83

Branch: refs/heads/master
Commit: 49618c835bf053d7e3846c809b2fba22418c4b26
Parents: 8eba8e2
Author: Ankit Singhal 
Authored: Fri Jun 10 16:00:32 2016 +0530
Committer: Ankit Singhal 
Committed: Fri Jun 10 16:00:32 2016 +0530

--
 .../query/ConnectionQueryServicesImpl.java  | 58 +---
 1 file changed, 39 insertions(+), 19 deletions(-)
--


http://git-wip-us.apache.org/repos/asf/phoenix/blob/49618c83/phoenix-core/src/main/java/org/apache/phoenix/query/ConnectionQueryServicesImpl.java
--
diff --git 
a/phoenix-core/src/main/java/org/apache/phoenix/query/ConnectionQueryServicesImpl.java
 
b/phoenix-core/src/main/java/org/apache/phoenix/query/ConnectionQueryServicesImpl.java
index 03ed549..56bd50c 100644
--- 
a/phoenix-core/src/main/java/org/apache/phoenix/query/ConnectionQueryServicesImpl.java
+++ 
b/phoenix-core/src/main/java/org/apache/phoenix/query/ConnectionQueryServicesImpl.java
@@ -1488,7 +1488,8 @@ public class ConnectionQueryServicesImpl extends 
DelegateQueryServices implement
 }
 
 @Override
-public MetaDataMutationResult dropTable(final List 
tableMetaData, final PTableType tableType, final boolean cascade) throws 
SQLException {
+public MetaDataMutationResult dropTable(final List 
tableMetaData, final PTableType tableType,
+final boolean cascade) throws SQLException {
 byte[][] rowKeyMetadata = new byte[3][];
 SchemaUtil.getVarChars(tableMetaData.get(0).getRow(), rowKeyMetadata);
 byte[] tenantIdBytes = 
rowKeyMetadata[PhoenixDatabaseMetaData.TENANT_ID_INDEX];
@@ -1523,19 +1524,15 @@ public class ConnectionQueryServicesImpl extends 
DelegateQueryServices implement
 case TABLE_ALREADY_EXISTS:
 ReadOnlyProps props = this.getProps();
 boolean dropMetadata = props.getBoolean(DROP_METADATA_ATTRIB, 
DEFAULT_DROP_METADATA);
+PTable table = result.getTable();
 if (dropMetadata) {
+flushParentPhysicalTable(table);
 dropTables(result.getTableNamesToDelete());
 }
 invalidateTables(result.getTableNamesToDelete());
 long timestamp = MetaDataUtil.getClientTimeStamp(tableMetaData);
 if (tableType == PTableType.TABLE) {
-boolean isNamespaceMapped = 
result.getTable().isNamespaceMapped();
-byte[] physicalName;
-if (!isNamespaceMapped) {
-physicalName = SchemaUtil.getTableNameAsBytes(schemaBytes, 
tableBytes);
-} else {
-physicalName = TableName.valueOf(schemaBytes, 
tableBytes).getName();
-}
+byte[] physicalName = table.getPhysicalName().getBytes();
 ensureViewIndexTableDropped(physicalName, timestamp);
 ensureLocalIndexTableDropped(physicalName, timestamp);
 tableStatsCache.invalidate(new 
ImmutableBytesPtr(physicalName));
@@ -1547,6 +1544,25 @@ public class ConnectionQueryServicesImpl extends 
DelegateQueryServices implement
   return result;
 }
 
+/*
+ * PHOENIX-2915 while dropping index, flush data table to avoid stale WAL 
edits of indexes 1. Flush parent table if
+ * dropping view has indexes 2. Dropping table indexes 3. Dropping view 
indexes
+ */
+private void flushParentPhysicalTable(PTable table) throws SQLException {
+byte[] parentPhysicalTableName = null;
+if (PTableType.VIEW == table.getType()) {
+if (!table.getIndexes().isEmpty()) {
+parentPhysicalTableName = table.getPhysicalName().getBytes();
+}
+} else if (PTableType.INDEX == table.getType()) {
+PTable parentTable = getTable(null, 
table.getParentName().getString(), HConstants.LATEST_TIMESTAMP);
+parentPhysicalTableName = parentTable.getPhysicalName().getBytes();
+}
+if (parentPhysicalTableName != null) {
+flushTable(parentPhysicalTableName);
+}
+}
+
 @Override
 public MetaDataMutationResult dropFunction(final List 
functionData, final boolean ifExists) throws SQLException {
 byte[][] rowKeyMetadata = new byte[2][];
@@ -1623,31 +1639,35 @@ public class ConnectionQueryServicesImpl extends 
DelegateQueryServices implement
 
 private void ensureViewIndexTableCreated(PName tenantId, byte[] 

Build failed in Jenkins: Phoenix-4.x-HBase-1.0 #493

[Apache Jenkins Server]

See 

Changes:

[ssa] PHOENIX-2975 CSVBulkLoad for local index only fails.

--
[...truncated 239 lines...]
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.002 sec - in 
org.apache.phoenix.hbase.index.covered.TestCoveredColumns
Running org.apache.phoenix.hbase.index.covered.filter.TestNewerTimestampFilter
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.001 sec - in 
org.apache.phoenix.hbase.index.covered.filter.TestNewerTimestampFilter
Running 
org.apache.phoenix.hbase.index.covered.filter.TestApplyAndFilterDeletesFilter
Tests run: 6, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.005 sec - in 
org.apache.phoenix.hbase.index.covered.filter.TestApplyAndFilterDeletesFilter
Running org.apache.phoenix.hbase.index.covered.data.TestIndexMemStore
Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.006 sec - in 
org.apache.phoenix.hbase.index.covered.data.TestIndexMemStore
Running org.apache.phoenix.hbase.index.covered.update.TestIndexUpdateManager
Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.003 sec - in 
org.apache.phoenix.hbase.index.covered.update.TestIndexUpdateManager
Running org.apache.phoenix.hbase.index.covered.example.TestColumnTracker
Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.002 sec - in 
org.apache.phoenix.hbase.index.covered.example.TestColumnTracker
Running 
org.apache.phoenix.hbase.index.covered.example.TestCoveredIndexSpecifierBuilder
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.003 sec - in 
org.apache.phoenix.hbase.index.covered.example.TestCoveredIndexSpecifierBuilder
Running 
org.apache.phoenix.hbase.index.covered.example.TestCoveredColumnIndexCodec
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.235 sec - in 
org.apache.phoenix.iterate.AggregateResultScannerTest
Running org.apache.phoenix.hbase.index.covered.TestLocalTableState
Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.13 sec - in 
org.apache.phoenix.hbase.index.covered.example.TestCoveredColumnIndexCodec
Running org.apache.phoenix.hbase.index.write.TestCachingHTableFactory
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.042 sec - in 
org.apache.phoenix.hbase.index.write.TestCachingHTableFactory
Running org.apache.phoenix.hbase.index.write.TestParalleWriterIndexCommitter
Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.031 sec - in 
org.apache.phoenix.hbase.index.write.TestParalleWriterIndexCommitter
Running org.apache.phoenix.hbase.index.write.TestWALRecoveryCaching
Tests run: 1, Failures: 0, Errors: 0, Skipped: 1, Time elapsed: 0.005 sec - in 
org.apache.phoenix.hbase.index.write.TestWALRecoveryCaching
Running 
org.apache.phoenix.hbase.index.write.recovery.TestPerRegionIndexWriteCache
Tests run: 9, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.658 sec - in 
org.apache.phoenix.mapreduce.util.PhoenixConfigurationUtilTest
Running org.apache.phoenix.hbase.index.write.TestIndexWriter
Tests run: 5, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.192 sec - in 
org.apache.phoenix.hbase.index.write.TestIndexWriter
Running org.apache.phoenix.hbase.index.write.TestParalleIndexWriter
Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.013 sec - in 
org.apache.phoenix.hbase.index.write.TestParalleIndexWriter
Running org.apache.phoenix.hbase.index.parallel.TestThreadPoolBuilder
Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.002 sec - in 
org.apache.phoenix.hbase.index.parallel.TestThreadPoolBuilder
Running org.apache.phoenix.hbase.index.parallel.TestThreadPoolManager
Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.006 sec - in 
org.apache.phoenix.hbase.index.parallel.TestThreadPoolManager
Running org.apache.phoenix.hbase.index.util.TestIndexManagementUtil
Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.01 sec - in 
org.apache.phoenix.hbase.index.util.TestIndexManagementUtil
Running org.apache.phoenix.trace.TraceMetricsSourceTest
Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.149 sec - in 
org.apache.phoenix.trace.TraceMetricsSourceTest
Running org.apache.phoenix.jdbc.PhoenixResultSetMetadataTest
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.111 sec - in 
org.apache.phoenix.jdbc.PhoenixResultSetMetadataTest
Running org.apache.phoenix.jdbc.PhoenixPreparedStatementTest
Tests run: 11, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.112 sec - in 
org.apache.phoenix.jdbc.PhoenixPreparedStatementTest
Running org.apache.phoenix.jdbc.ReadOnlyPropertiesTest
Tests run: 4, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.002 sec - in 
org.apache.phoenix.jdbc.ReadOnlyPropertiesTest
Running org.apache.phoenix.jdbc.PhoenixDriverTest
Tests run: 6, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.253 sec - in 

Build failed in Jenkins: Phoenix-4.x-HBase-1.1 #46

[Apache Jenkins Server]

See 

Changes:

[ssa] PHOENIX-2975 CSVBulkLoad for local index only fails.

--
[...truncated 239 lines...]
Tests run: 103, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.959 sec - 
in org.apache.phoenix.compile.WhereOptimizerTest
Running org.apache.phoenix.compile.QueryOptimizerTest
Tests run: 6, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.793 sec - in 
org.apache.phoenix.compile.TenantSpecificViewIndexCompileTest
Running org.apache.phoenix.compile.JoinQueryCompilerTest
Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.318 sec - in 
org.apache.phoenix.compile.ViewCompilerTest
Running org.apache.phoenix.compile.WhereCompilerTest
Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.232 sec - in 
org.apache.phoenix.compile.JoinQueryCompilerTest
Running org.apache.phoenix.compile.ScanRangesTest
Tests run: 34, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.054 sec - in 
org.apache.phoenix.compile.ScanRangesTest
Running org.apache.phoenix.compile.SelectStatementRewriterTest
Tests run: 45, Failures: 0, Errors: 0, Skipped: 1, Time elapsed: 0.449 sec - in 
org.apache.phoenix.compile.WhereCompilerTest
Running org.apache.phoenix.compile.HavingCompilerTest
Tests run: 5, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.163 sec - in 
org.apache.phoenix.compile.SelectStatementRewriterTest
Running org.apache.phoenix.compile.ScanRangesIntersectTest
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.001 sec - in 
org.apache.phoenix.compile.ScanRangesIntersectTest
Running org.apache.phoenix.compile.QueryCompilerTest
Tests run: 11, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.17 sec - in 
org.apache.phoenix.compile.HavingCompilerTest
Running org.apache.phoenix.index.IndexMaintainerTest
Tests run: 40, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 1.378 sec - in 
org.apache.phoenix.compile.QueryOptimizerTest
Running org.apache.phoenix.hbase.index.util.TestIndexManagementUtil
Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.014 sec - in 
org.apache.phoenix.hbase.index.util.TestIndexManagementUtil
Running org.apache.phoenix.hbase.index.covered.TestLocalTableState
Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.108 sec - in 
org.apache.phoenix.hbase.index.covered.TestLocalTableState
Running 
org.apache.phoenix.hbase.index.covered.example.TestCoveredIndexSpecifierBuilder
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.003 sec - in 
org.apache.phoenix.hbase.index.covered.example.TestCoveredIndexSpecifierBuilder
Running org.apache.phoenix.hbase.index.covered.example.TestColumnTracker
Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.002 sec - in 
org.apache.phoenix.hbase.index.covered.example.TestColumnTracker
Running 
org.apache.phoenix.hbase.index.covered.example.TestCoveredColumnIndexCodec
Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.009 sec - in 
org.apache.phoenix.hbase.index.covered.example.TestCoveredColumnIndexCodec
Running org.apache.phoenix.hbase.index.covered.data.TestIndexMemStore
Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.003 sec - in 
org.apache.phoenix.hbase.index.covered.data.TestIndexMemStore
Running org.apache.phoenix.hbase.index.covered.TestCoveredColumns
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.001 sec - in 
org.apache.phoenix.hbase.index.covered.TestCoveredColumns
Running org.apache.phoenix.hbase.index.covered.update.TestIndexUpdateManager
Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.004 sec - in 
org.apache.phoenix.hbase.index.covered.update.TestIndexUpdateManager
Running org.apache.phoenix.hbase.index.covered.filter.TestNewerTimestampFilter
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.001 sec - in 
org.apache.phoenix.hbase.index.covered.filter.TestNewerTimestampFilter
Running 
org.apache.phoenix.hbase.index.covered.filter.TestApplyAndFilterDeletesFilter
Tests run: 6, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.003 sec - in 
org.apache.phoenix.hbase.index.covered.filter.TestApplyAndFilterDeletesFilter
Running org.apache.phoenix.hbase.index.write.TestIndexWriter
Tests run: 24, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.79 sec - in 
org.apache.phoenix.index.IndexMaintainerTest
Running org.apache.phoenix.hbase.index.write.TestCachingHTableFactory
Tests run: 120, Failures: 1, Errors: 0, Skipped: 0, Time elapsed: 0.984 sec <<< 
FAILURE! - in org.apache.phoenix.compile.QueryCompilerTest
testNonAggInHavingClause(org.apache.phoenix.compile.QueryCompilerTest)  Time 
elapsed: 0.013 sec  <<< FAILURE!
java.lang.AssertionError: ERROR 1018 (42Y27): Aggregate may not contain columns 
not in GROUP BY. A_INTEGER
at 
org.apache.phoenix.compile.QueryCompilerTest.testNonAggInHavingClause(QueryCompilerTest.java:341)

Tests run: 5, Failures: 0, Errors: 0, 

Build failed in Jenkins: Phoenix | Master #1250

[Apache Jenkins Server]

See 

Changes:

[ssa] PHOENIX-2975 CSVBulkLoad for local index only fails.

--
[...truncated 262 lines...]
Running org.apache.phoenix.hbase.index.covered.filter.TestNewerTimestampFilter
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.001 sec - in 
org.apache.phoenix.hbase.index.covered.filter.TestNewerTimestampFilter
Running 
org.apache.phoenix.hbase.index.covered.filter.TestApplyAndFilterDeletesFilter
Tests run: 6, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.004 sec - in 
org.apache.phoenix.hbase.index.covered.filter.TestApplyAndFilterDeletesFilter
Running org.apache.phoenix.hbase.index.covered.data.TestIndexMemStore
Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.007 sec - in 
org.apache.phoenix.hbase.index.covered.data.TestIndexMemStore
Running org.apache.phoenix.hbase.index.covered.update.TestIndexUpdateManager
Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.003 sec - in 
org.apache.phoenix.hbase.index.covered.update.TestIndexUpdateManager
Running org.apache.phoenix.hbase.index.covered.example.TestColumnTracker
Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.002 sec - in 
org.apache.phoenix.hbase.index.covered.example.TestColumnTracker
Running 
org.apache.phoenix.hbase.index.covered.example.TestCoveredIndexSpecifierBuilder
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.002 sec - in 
org.apache.phoenix.hbase.index.covered.example.TestCoveredIndexSpecifierBuilder
Running 
org.apache.phoenix.hbase.index.covered.example.TestCoveredColumnIndexCodec
Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.126 sec - in 
org.apache.phoenix.hbase.index.covered.example.TestCoveredColumnIndexCodec
Running org.apache.phoenix.hbase.index.covered.TestLocalTableState
Tests run: 9, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.757 sec - in 
org.apache.phoenix.mapreduce.util.PhoenixConfigurationUtilTest
Running org.apache.phoenix.hbase.index.write.TestCachingHTableFactory
Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.085 sec - in 
org.apache.phoenix.hbase.index.covered.TestLocalTableState
Running org.apache.phoenix.hbase.index.write.TestParalleWriterIndexCommitter
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.058 sec - in 
org.apache.phoenix.hbase.index.write.TestCachingHTableFactory
Running org.apache.phoenix.hbase.index.write.TestWALRecoveryCaching
Tests run: 1, Failures: 0, Errors: 0, Skipped: 1, Time elapsed: 0.004 sec - in 
org.apache.phoenix.hbase.index.write.TestWALRecoveryCaching
Running 
org.apache.phoenix.hbase.index.write.recovery.TestPerRegionIndexWriteCache
Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.055 sec - in 
org.apache.phoenix.hbase.index.write.TestParalleWriterIndexCommitter
Running org.apache.phoenix.hbase.index.write.TestIndexWriter
Tests run: 5, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.029 sec - in 
org.apache.phoenix.hbase.index.write.TestIndexWriter
Running org.apache.phoenix.hbase.index.write.TestParalleIndexWriter
Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.006 sec - in 
org.apache.phoenix.hbase.index.write.TestParalleIndexWriter
Running org.apache.phoenix.hbase.index.parallel.TestThreadPoolBuilder
Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.002 sec - in 
org.apache.phoenix.hbase.index.parallel.TestThreadPoolBuilder
Running org.apache.phoenix.hbase.index.parallel.TestThreadPoolManager
Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.007 sec - in 
org.apache.phoenix.hbase.index.parallel.TestThreadPoolManager
Running org.apache.phoenix.hbase.index.util.TestIndexManagementUtil
Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.017 sec - in 
org.apache.phoenix.hbase.index.util.TestIndexManagementUtil
Running org.apache.phoenix.trace.TraceMetricsSourceTest
Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.34 sec - in 
org.apache.phoenix.trace.TraceMetricsSourceTest
Running org.apache.phoenix.jdbc.PhoenixResultSetMetadataTest
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.208 sec - in 
org.apache.phoenix.jdbc.PhoenixResultSetMetadataTest
Running org.apache.phoenix.jdbc.PhoenixPreparedStatementTest
Tests run: 11, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.209 sec - in 
org.apache.phoenix.jdbc.PhoenixPreparedStatementTest
Running org.apache.phoenix.jdbc.ReadOnlyPropertiesTest
Tests run: 4, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.003 sec - in 
org.apache.phoenix.jdbc.ReadOnlyPropertiesTest
Running org.apache.phoenix.jdbc.PhoenixDriverTest
Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.913 sec - in 
org.apache.phoenix.hbase.index.write.recovery.TestPerRegionIndexWriteCache
Running org.apache.phoenix.jdbc.PhoenixEmbeddedDriverTest
Tests run: 3, Failures: 0, Errors: 0, 

[1/4] phoenix git commit: PHOENIX-2975 CSVBulkLoad for local index only fails.

[ssa]

Repository: phoenix
Updated Branches:
  refs/heads/4.x-HBase-0.98 8296b9857 -> df65b174d
  refs/heads/4.x-HBase-1.0 16810a8af -> d0d6964af
  refs/heads/4.x-HBase-1.1 81878a185 -> 891131c78
  refs/heads/master e7e8e130b -> 865458fbf


PHOENIX-2975 CSVBulkLoad for local index only fails.


Project: http://git-wip-us.apache.org/repos/asf/phoenix/repo
Commit: http://git-wip-us.apache.org/repos/asf/phoenix/commit/865458fb
Tree: http://git-wip-us.apache.org/repos/asf/phoenix/tree/865458fb
Diff: http://git-wip-us.apache.org/repos/asf/phoenix/diff/865458fb

Branch: refs/heads/master
Commit: 865458fbfa2b7f4597076351b6011ec063c3aa09
Parents: e7e8e13
Author: Sergey Soldatov 
Authored: Thu Jun 9 17:59:51 2016 -0700
Committer: Sergey Soldatov 
Committed: Fri Jun 10 01:56:47 2016 -0700

--
 .../phoenix/mapreduce/FormatToBytesWritableMapper.java| 10 --
 1 file changed, 8 insertions(+), 2 deletions(-)
--


http://git-wip-us.apache.org/repos/asf/phoenix/blob/865458fb/phoenix-core/src/main/java/org/apache/phoenix/mapreduce/FormatToBytesWritableMapper.java
--
diff --git 
a/phoenix-core/src/main/java/org/apache/phoenix/mapreduce/FormatToBytesWritableMapper.java
 
b/phoenix-core/src/main/java/org/apache/phoenix/mapreduce/FormatToBytesWritableMapper.java
index a736fc4..cacbce7 100644
--- 
a/phoenix-core/src/main/java/org/apache/phoenix/mapreduce/FormatToBytesWritableMapper.java
+++ 
b/phoenix-core/src/main/java/org/apache/phoenix/mapreduce/FormatToBytesWritableMapper.java
@@ -248,7 +248,7 @@ public abstract class FormatToBytesWritableMapper 
extends Mapper 
extends Mapper

[3/4] phoenix git commit: PHOENIX-2975 CSVBulkLoad for local index only fails.

[ssa]

PHOENIX-2975 CSVBulkLoad for local index only fails.


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

Branch: refs/heads/4.x-HBase-1.0
Commit: d0d6964af67002c9290d756656bb09944726494b
Parents: 16810a8
Author: Sergey Soldatov 
Authored: Thu Jun 9 17:59:51 2016 -0700
Committer: Sergey Soldatov 
Committed: Fri Jun 10 01:57:43 2016 -0700

--
 .../phoenix/mapreduce/FormatToBytesWritableMapper.java| 10 --
 1 file changed, 8 insertions(+), 2 deletions(-)
--


http://git-wip-us.apache.org/repos/asf/phoenix/blob/d0d6964a/phoenix-core/src/main/java/org/apache/phoenix/mapreduce/FormatToBytesWritableMapper.java
--
diff --git 
a/phoenix-core/src/main/java/org/apache/phoenix/mapreduce/FormatToBytesWritableMapper.java
 
b/phoenix-core/src/main/java/org/apache/phoenix/mapreduce/FormatToBytesWritableMapper.java
index a736fc4..cacbce7 100644
--- 
a/phoenix-core/src/main/java/org/apache/phoenix/mapreduce/FormatToBytesWritableMapper.java
+++ 
b/phoenix-core/src/main/java/org/apache/phoenix/mapreduce/FormatToBytesWritableMapper.java
@@ -248,7 +248,7 @@ public abstract class FormatToBytesWritableMapper 
extends Mapper 
extends Mapper