phoenix git commit: PHOENIX-4588 Clone expression also if it's children have Determinism.PER_INVOCATION

2018-02-08 Thread ankit 
Repository: phoenix
Updated Branches:
  refs/heads/master 82bbfdb1d -> 8f01b5fad


PHOENIX-4588 Clone expression also if it's children have 
Determinism.PER_INVOCATION


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

Branch: refs/heads/master
Commit: 8f01b5fad1e7a3202d911975bf01a23cfdbd3e0e
Parents: 82bbfdb
Author: Ankit Singhal 
Authored: Fri Feb 9 11:48:54 2018 +0530
Committer: Ankit Singhal 
Committed: Fri Feb 9 11:48:54 2018 +0530

--
 .../org/apache/phoenix/expression/BaseSingleExpression.java | 5 +
 1 file changed, 5 insertions(+)
--


http://git-wip-us.apache.org/repos/asf/phoenix/blob/8f01b5fa/phoenix-core/src/main/java/org/apache/phoenix/expression/BaseSingleExpression.java
--
diff --git 
a/phoenix-core/src/main/java/org/apache/phoenix/expression/BaseSingleExpression.java
 
b/phoenix-core/src/main/java/org/apache/phoenix/expression/BaseSingleExpression.java
index c0e2fea..fbe8040 100644
--- 
a/phoenix-core/src/main/java/org/apache/phoenix/expression/BaseSingleExpression.java
+++ 
b/phoenix-core/src/main/java/org/apache/phoenix/expression/BaseSingleExpression.java
@@ -113,4 +113,9 @@ public abstract class BaseSingleExpression extends 
BaseExpression {
 public boolean requiresFinalEvaluation() {
 return children.get(0).requiresFinalEvaluation();
 }
+
+@Override
+public Determinism getDeterminism() {
+return children.get(0).getDeterminism();
+}
 }

phoenix git commit: PHOENIX-4588 Clone expression also if it's children have Determinism.PER_INVOCATION

2018-02-08 Thread ankit 
Repository: phoenix
Updated Branches:
  refs/heads/4.x-HBase-0.98 63fa82e63 -> d2801ef98


PHOENIX-4588 Clone expression also if it's children have 
Determinism.PER_INVOCATION


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

Branch: refs/heads/4.x-HBase-0.98
Commit: d2801ef98cf9a20d13f03ac9faad7968b1597f54
Parents: 63fa82e
Author: Ankit Singhal 
Authored: Fri Feb 9 11:47:39 2018 +0530
Committer: Ankit Singhal 
Committed: Fri Feb 9 11:47:39 2018 +0530

--
 .../org/apache/phoenix/expression/BaseSingleExpression.java | 5 +
 1 file changed, 5 insertions(+)
--


http://git-wip-us.apache.org/repos/asf/phoenix/blob/d2801ef9/phoenix-core/src/main/java/org/apache/phoenix/expression/BaseSingleExpression.java
--
diff --git 
a/phoenix-core/src/main/java/org/apache/phoenix/expression/BaseSingleExpression.java
 
b/phoenix-core/src/main/java/org/apache/phoenix/expression/BaseSingleExpression.java
index c0e2fea..fbe8040 100644
--- 
a/phoenix-core/src/main/java/org/apache/phoenix/expression/BaseSingleExpression.java
+++ 
b/phoenix-core/src/main/java/org/apache/phoenix/expression/BaseSingleExpression.java
@@ -113,4 +113,9 @@ public abstract class BaseSingleExpression extends 
BaseExpression {
 public boolean requiresFinalEvaluation() {
 return children.get(0).requiresFinalEvaluation();
 }
+
+@Override
+public Determinism getDeterminism() {
+return children.get(0).getDeterminism();
+}
 }

phoenix git commit: PHOENIX-4588 Clone expression also if it's children have Determinism.PER_INVOCATION

2018-02-08 Thread ankit 
Repository: phoenix
Updated Branches:
  refs/heads/4.x-HBase-1.2 48d1df3dd -> 96c13c113


PHOENIX-4588 Clone expression also if it's children have 
Determinism.PER_INVOCATION


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

Branch: refs/heads/4.x-HBase-1.2
Commit: 96c13c11389ec5e2381fbbb1b8469fb346d0f64b
Parents: 48d1df3
Author: Ankit Singhal 
Authored: Fri Feb 9 11:46:56 2018 +0530
Committer: Ankit Singhal 
Committed: Fri Feb 9 11:46:56 2018 +0530

--
 .../org/apache/phoenix/expression/BaseSingleExpression.java | 5 +
 1 file changed, 5 insertions(+)
--


http://git-wip-us.apache.org/repos/asf/phoenix/blob/96c13c11/phoenix-core/src/main/java/org/apache/phoenix/expression/BaseSingleExpression.java
--
diff --git 
a/phoenix-core/src/main/java/org/apache/phoenix/expression/BaseSingleExpression.java
 
b/phoenix-core/src/main/java/org/apache/phoenix/expression/BaseSingleExpression.java
index c0e2fea..fbe8040 100644
--- 
a/phoenix-core/src/main/java/org/apache/phoenix/expression/BaseSingleExpression.java
+++ 
b/phoenix-core/src/main/java/org/apache/phoenix/expression/BaseSingleExpression.java
@@ -113,4 +113,9 @@ public abstract class BaseSingleExpression extends 
BaseExpression {
 public boolean requiresFinalEvaluation() {
 return children.get(0).requiresFinalEvaluation();
 }
+
+@Override
+public Determinism getDeterminism() {
+return children.get(0).getDeterminism();
+}
 }

phoenix git commit: PHOENIX-4588 Clone expression also if it's children have Determinism.PER_INVOCATION

2018-02-08 Thread ankit 
Repository: phoenix
Updated Branches:
  refs/heads/4.x-HBase-1.3 7bf3a5753 -> 60e5ff315


PHOENIX-4588 Clone expression also if it's children have 
Determinism.PER_INVOCATION


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

Branch: refs/heads/4.x-HBase-1.3
Commit: 60e5ff315e156402e0ebd010797c7b8e8f790cf5
Parents: 7bf3a57
Author: Ankit Singhal 
Authored: Fri Feb 9 11:46:29 2018 +0530
Committer: Ankit Singhal 
Committed: Fri Feb 9 11:46:29 2018 +0530

--
 .../org/apache/phoenix/expression/BaseSingleExpression.java | 5 +
 1 file changed, 5 insertions(+)
--


http://git-wip-us.apache.org/repos/asf/phoenix/blob/60e5ff31/phoenix-core/src/main/java/org/apache/phoenix/expression/BaseSingleExpression.java
--
diff --git 
a/phoenix-core/src/main/java/org/apache/phoenix/expression/BaseSingleExpression.java
 
b/phoenix-core/src/main/java/org/apache/phoenix/expression/BaseSingleExpression.java
index c0e2fea..fbe8040 100644
--- 
a/phoenix-core/src/main/java/org/apache/phoenix/expression/BaseSingleExpression.java
+++ 
b/phoenix-core/src/main/java/org/apache/phoenix/expression/BaseSingleExpression.java
@@ -113,4 +113,9 @@ public abstract class BaseSingleExpression extends 
BaseExpression {
 public boolean requiresFinalEvaluation() {
 return children.get(0).requiresFinalEvaluation();
 }
+
+@Override
+public Determinism getDeterminism() {
+return children.get(0).getDeterminism();
+}
 }

phoenix git commit: PHOENIX-4588 Clone expression also if it's children have Determinism.PER_INVOCATION

2018-02-08 Thread ankit 
Repository: phoenix
Updated Branches:
  refs/heads/5.x-HBase-2.0 a7bb5c44c -> 2cc3241d2


PHOENIX-4588 Clone expression also if it's children have 
Determinism.PER_INVOCATION


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

Branch: refs/heads/5.x-HBase-2.0
Commit: 2cc3241d2240d8bbe8994eaec35a3163977453f2
Parents: a7bb5c4
Author: Ankit Singhal 
Authored: Fri Feb 9 11:45:47 2018 +0530
Committer: Ankit Singhal 
Committed: Fri Feb 9 11:45:47 2018 +0530

--
 .../org/apache/phoenix/expression/BaseSingleExpression.java | 5 +
 1 file changed, 5 insertions(+)
--


http://git-wip-us.apache.org/repos/asf/phoenix/blob/2cc3241d/phoenix-core/src/main/java/org/apache/phoenix/expression/BaseSingleExpression.java
--
diff --git 
a/phoenix-core/src/main/java/org/apache/phoenix/expression/BaseSingleExpression.java
 
b/phoenix-core/src/main/java/org/apache/phoenix/expression/BaseSingleExpression.java
index c0e2fea..fbe8040 100644
--- 
a/phoenix-core/src/main/java/org/apache/phoenix/expression/BaseSingleExpression.java
+++ 
b/phoenix-core/src/main/java/org/apache/phoenix/expression/BaseSingleExpression.java
@@ -113,4 +113,9 @@ public abstract class BaseSingleExpression extends 
BaseExpression {
 public boolean requiresFinalEvaluation() {
 return children.get(0).requiresFinalEvaluation();
 }
+
+@Override
+public Determinism getDeterminism() {
+return children.get(0).getDeterminism();
+}
 }

Build failed in Jenkins: Phoenix | Master #1930

2018-02-08 Thread Apache Jenkins Server 
See 


Changes:

[maryannxue] PHOENIX-4586 UPSERT SELECT doesn't take in account comparison 
operators

--
[...truncated 90.15 KB...]
[INFO] Running org.apache.phoenix.end2end.OctetLengthFunctionEnd2EndIT
[INFO] Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 2.258 s 
- in org.apache.phoenix.end2end.OctetLengthFunctionEnd2EndIT
[INFO] Running org.apache.phoenix.end2end.OnDuplicateKeyIT
[INFO] Tests run: 44, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 176.707 
s - in org.apache.phoenix.end2end.NotQueryWithGlobalImmutableIndexesIT
[INFO] Running org.apache.phoenix.end2end.OrderByIT
[INFO] Tests run: 63, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 385.563 
s - in org.apache.phoenix.end2end.InQueryIT
[INFO] Tests run: 33, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 287.995 
s - in org.apache.phoenix.end2end.NotQueryWithLocalImmutableIndexesIT
[INFO] Running org.apache.phoenix.end2end.PartialScannerResultsDisabledIT
[INFO] Tests run: 63, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 413.768 
s - in org.apache.phoenix.end2end.GroupByIT
[INFO] Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 22.941 s 
- in org.apache.phoenix.end2end.PartialScannerResultsDisabledIT
[INFO] Tests run: 70, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 420.977 
s - in org.apache.phoenix.end2end.IntArithmeticIT
[INFO] Running org.apache.phoenix.end2end.PercentileIT
[INFO] Running org.apache.phoenix.end2end.PointInTimeQueryIT
[INFO] Running org.apache.phoenix.end2end.PhoenixRuntimeIT
[INFO] Running org.apache.phoenix.end2end.PowerFunctionEnd2EndIT
[INFO] Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 4.654 s 
- in org.apache.phoenix.end2end.PowerFunctionEnd2EndIT
[INFO] Running org.apache.phoenix.end2end.PrimitiveTypeIT
[INFO] Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 22.778 s 
- in org.apache.phoenix.end2end.PhoenixRuntimeIT
[INFO] Running org.apache.phoenix.end2end.ProductMetricsIT
[INFO] Tests run: 18, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 44.866 
s - in org.apache.phoenix.end2end.PercentileIT
[INFO] Running org.apache.phoenix.end2end.QueryDatabaseMetaDataIT
[INFO] Tests run: 9, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 22.202 s 
- in org.apache.phoenix.end2end.PrimitiveTypeIT
[INFO] Running org.apache.phoenix.end2end.QueryExecWithoutSCNIT
[INFO] Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 2.304 s 
- in org.apache.phoenix.end2end.QueryExecWithoutSCNIT
[INFO] Running org.apache.phoenix.end2end.QueryIT
[INFO] Tests run: 56, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 344.087 
s - in org.apache.phoenix.end2end.NullIT
[INFO] Running org.apache.phoenix.end2end.QueryMoreIT
[INFO] Tests run: 48, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 314.866 
s - in org.apache.phoenix.end2end.OnDuplicateKeyIT
[INFO] Tests run: 9, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 47.963 s 
- in org.apache.phoenix.end2end.QueryMoreIT
[INFO] Running org.apache.phoenix.end2end.RTrimFunctionIT
[INFO] Running org.apache.phoenix.end2end.QueryWithOffsetIT
[INFO] Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 4.509 s 
- in org.apache.phoenix.end2end.RTrimFunctionIT
[INFO] Running org.apache.phoenix.end2end.RangeScanIT
[INFO] Tests run: 18, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 106.785 
s - in org.apache.phoenix.end2end.QueryDatabaseMetaDataIT
[INFO] Tests run: 8, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 18.838 s 
- in org.apache.phoenix.end2end.QueryWithOffsetIT
[INFO] Running org.apache.phoenix.end2end.RegexpReplaceFunctionIT
[INFO] Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 4.52 s - 
in org.apache.phoenix.end2end.RegexpReplaceFunctionIT
[INFO] Running org.apache.phoenix.end2end.RegexpSplitFunctionIT
[INFO] Tests run: 55, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 135.15 
s - in org.apache.phoenix.end2end.ProductMetricsIT
[INFO] Running org.apache.phoenix.end2end.ReadOnlyIT
[INFO] Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 8.737 s 
- in org.apache.phoenix.end2end.ReadOnlyIT
[INFO] Running org.apache.phoenix.end2end.ReverseFunctionIT
[INFO] Tests run: 12, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 29.542 
s - in org.apache.phoenix.end2end.RegexpSplitFunctionIT
[INFO] Running org.apache.phoenix.end2end.ReverseScanIT
[INFO] Tests run: 5, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 11.28 s 
- in org.apache.phoenix.end2end.ReverseFunctionIT
[INFO] Running org.apache.phoenix.end2end.RoundFloorCeilFuncIT
[INFO] Running org.apache.phoenix.end2end.RegexpSubstrFunctionIT
[INFO] Tests run: 4, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 11.324 s 
- in org.apache.phoenix.end2end.ReverseScanIT
[INFO] Running org.apache.phoenix.end2end.RowTimestampIT
[INFO] Tests run: 2, Failures: 0, Errors: 0, Skipped: 0,

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

2018-02-08 Thread Apache Jenkins Server 
4.x-HBase-1.1 branch build status Successful

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

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

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

Changes
[maryannxue] PHOENIX-4586 UPSERT SELECT doesn't take in account comparison operators



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

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

2018-02-08 Thread Apache Jenkins Server 
4.x-HBase-1.2 branch build status Successful

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

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

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

Changes
[maryannxue] PHOENIX-4586 UPSERT SELECT doesn't take in account comparison operators



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

svn commit: r24843 - in /dev/phoenix/apache-phoenix-5.0.0-alpha-HBase-2.0-rc1: ./ bin/ src/

2018-02-08 Thread elserj 
Author: elserj
Date: Fri Feb  9 00:16:49 2018
New Revision: 24843

Log:
5.0.0-alpha rc1

Added:
dev/phoenix/apache-phoenix-5.0.0-alpha-HBase-2.0-rc1/
dev/phoenix/apache-phoenix-5.0.0-alpha-HBase-2.0-rc1/bin/

dev/phoenix/apache-phoenix-5.0.0-alpha-HBase-2.0-rc1/bin/apache-phoenix-5.0.0-alpha-HBase-2.0-bin.tar.gz
   (with props)

dev/phoenix/apache-phoenix-5.0.0-alpha-HBase-2.0-rc1/bin/apache-phoenix-5.0.0-alpha-HBase-2.0-bin.tar.gz.asc

dev/phoenix/apache-phoenix-5.0.0-alpha-HBase-2.0-rc1/bin/apache-phoenix-5.0.0-alpha-HBase-2.0-bin.tar.gz.md5

dev/phoenix/apache-phoenix-5.0.0-alpha-HBase-2.0-rc1/bin/apache-phoenix-5.0.0-alpha-HBase-2.0-bin.tar.gz.sha256

dev/phoenix/apache-phoenix-5.0.0-alpha-HBase-2.0-rc1/bin/apache-phoenix-5.0.0-alpha-HBase-2.0-bin.tar.gz.sha512
dev/phoenix/apache-phoenix-5.0.0-alpha-HBase-2.0-rc1/src/

dev/phoenix/apache-phoenix-5.0.0-alpha-HBase-2.0-rc1/src/apache-phoenix-5.0.0-alpha-HBase-2.0-src.tar.gz
   (with props)

dev/phoenix/apache-phoenix-5.0.0-alpha-HBase-2.0-rc1/src/apache-phoenix-5.0.0-alpha-HBase-2.0-src.tar.gz.asc

dev/phoenix/apache-phoenix-5.0.0-alpha-HBase-2.0-rc1/src/apache-phoenix-5.0.0-alpha-HBase-2.0-src.tar.gz.md5

dev/phoenix/apache-phoenix-5.0.0-alpha-HBase-2.0-rc1/src/apache-phoenix-5.0.0-alpha-HBase-2.0-src.tar.gz.sha256

dev/phoenix/apache-phoenix-5.0.0-alpha-HBase-2.0-rc1/src/apache-phoenix-5.0.0-alpha-HBase-2.0-src.tar.gz.sha512

Added: 
dev/phoenix/apache-phoenix-5.0.0-alpha-HBase-2.0-rc1/bin/apache-phoenix-5.0.0-alpha-HBase-2.0-bin.tar.gz
==
Binary file - no diff available.

Propchange: 
dev/phoenix/apache-phoenix-5.0.0-alpha-HBase-2.0-rc1/bin/apache-phoenix-5.0.0-alpha-HBase-2.0-bin.tar.gz
--
svn:mime-type = application/octet-stream

Added: 
dev/phoenix/apache-phoenix-5.0.0-alpha-HBase-2.0-rc1/bin/apache-phoenix-5.0.0-alpha-HBase-2.0-bin.tar.gz.asc
==
--- 
dev/phoenix/apache-phoenix-5.0.0-alpha-HBase-2.0-rc1/bin/apache-phoenix-5.0.0-alpha-HBase-2.0-bin.tar.gz.asc
 (added)
+++ 
dev/phoenix/apache-phoenix-5.0.0-alpha-HBase-2.0-rc1/bin/apache-phoenix-5.0.0-alpha-HBase-2.0-bin.tar.gz.asc
 Fri Feb  9 00:16:49 2018
@@ -0,0 +1,16 @@
+-BEGIN PGP SIGNATURE-
+
+iQIzBAABCAAdFiEEnmKCL0Zo8XsJcq3Zt9XNRUZ31mwFAlp80X4ACgkQt9XNRUZ3
+1mw7gRAAjcVM+0VmggD6yBNbJC5ogazIVpRz2tQwKs3pL/xqSiKgXHrWAbljcOQZ
+4wFemaQr+kccHM+TU8nStQJi8LGxMyNEHhZ6qlUOz1APWgmPd8xEwC4hoKR8/LmW
+Aso6SZtZTZqLgYiyhmuwGhZoijwl/RU1vumnnTBQ2MmbCQJxyMXjT1vBgzuDkbNQ
+9uYxKMhZAsyg/jJTxCl25SUD4aH3pHvt4TWOwP0TNSQp7NF9tIbnmG1IphLqDqQ1
+t1KyyJWcoivO2BCNA0uRnSXP3Fr4XZlMRyoqO+bbfUxeAv5L2QEKzx5PgST1IlqD
+XRQBshyTlai2foI4wQdhnIsLjAg0NvzypCcD3yJwBErNR9mM0Ij0985b/M6hVPMN
+stCOmianrwz+pCtqByFYqN9GR0c6dZ6yrt3XtEqrxQ9tQ89AK7Gbc9beLKrG3TiY
+t9YqzkaDFdQo7aVcYVLGnjBn544pRXgLTfeQ9JscW9U4CLo4oMj2nI8RzGx3XxwH
+ErRN3XzBhj6c55LnWot2qN6nK5i/qNJ+sjFbybYPXybbOiJLo7CO6gjdT2PKVuxu
+5zdrcKurDH1LWcjq538p33ZWZlePHQ0dXOhfngde4XYdhHCN0A631g4Iuz1gB533
+Xqovg1inRAID6qS04sM0mj75p4U3WR05KmEaZw7FRxxTK00SJws=
+=E+Wa
+-END PGP SIGNATURE-

Added: 
dev/phoenix/apache-phoenix-5.0.0-alpha-HBase-2.0-rc1/bin/apache-phoenix-5.0.0-alpha-HBase-2.0-bin.tar.gz.md5
==
--- 
dev/phoenix/apache-phoenix-5.0.0-alpha-HBase-2.0-rc1/bin/apache-phoenix-5.0.0-alpha-HBase-2.0-bin.tar.gz.md5
 (added)
+++ 
dev/phoenix/apache-phoenix-5.0.0-alpha-HBase-2.0-rc1/bin/apache-phoenix-5.0.0-alpha-HBase-2.0-bin.tar.gz.md5
 Fri Feb  9 00:16:49 2018
@@ -0,0 +1 @@
+MD5(apache-phoenix-5.0.0-alpha-HBase-2.0-bin.tar.gz)= 
361f9b671cdddf9326243afa6fa52d7f

Added: 
dev/phoenix/apache-phoenix-5.0.0-alpha-HBase-2.0-rc1/bin/apache-phoenix-5.0.0-alpha-HBase-2.0-bin.tar.gz.sha256
==
--- 
dev/phoenix/apache-phoenix-5.0.0-alpha-HBase-2.0-rc1/bin/apache-phoenix-5.0.0-alpha-HBase-2.0-bin.tar.gz.sha256
 (added)
+++ 
dev/phoenix/apache-phoenix-5.0.0-alpha-HBase-2.0-rc1/bin/apache-phoenix-5.0.0-alpha-HBase-2.0-bin.tar.gz.sha256
 Fri Feb  9 00:16:49 2018
@@ -0,0 +1 @@
+SHA256(apache-phoenix-5.0.0-alpha-HBase-2.0-bin.tar.gz)= 
866efae5f7dcbfd641c57bf42a3df2f2f746bd7eeba9b5ccc82c8ea6273e8384

Added: 
dev/phoenix/apache-phoenix-5.0.0-alpha-HBase-2.0-rc1/bin/apache-phoenix-5.0.0-alpha-HBase-2.0-bin.tar.gz.sha512
==
--- 
dev/phoenix/apache-phoenix-5.0.0-alpha-HBase-2.0-rc1/bin/apache-phoenix-5.0.0-alpha-HBase-2.0-bin.tar.gz.sha512
 (added)
+++ 
dev/phoenix/apache-phoenix-5.0.0-alpha-HBase-2.0-rc1/bin/apache-phoenix-5.0.0-alpha-HBase-2.0-bin.tar.gz.sha512
 Fri Feb  9 00:16:49 2018
@@ -0,0 +1 @@
+SHA512(apache-phoenix-5.0.0-alpha-HBase-2.0-bin.tar.gz)=

Build failed in Jenkins: Phoenix-4.x-HBase-1.3 #31

2018-02-08 Thread Apache Jenkins Server 
See 


Changes:

[maryannxue] PHOENIX-4586 UPSERT SELECT doesn't take in account comparison 
operators

--
[...truncated 127.62 KB...]
[INFO] Running org.apache.phoenix.end2end.index.LocalMutableTxIndexIT
[INFO] Running org.apache.phoenix.end2end.index.MutableIndexIT
[INFO] Tests run: 40, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 386.63 
s - in org.apache.phoenix.end2end.index.GlobalMutableTxIndexIT
[INFO] Tests run: 18, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 259.491 
s - in org.apache.phoenix.end2end.index.IndexWithTableSchemaChangeIT
[INFO] Running org.apache.phoenix.end2end.index.SaltedIndexIT
[INFO] Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 23.977 s 
- in org.apache.phoenix.end2end.index.SaltedIndexIT
[INFO] Running org.apache.phoenix.end2end.index.txn.MutableRollbackIT
[INFO] Running org.apache.phoenix.end2end.index.ViewIndexIT
[INFO] Tests run: 37, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 356.2 s 
- in org.apache.phoenix.end2end.index.IndexUsageIT
[INFO] Running org.apache.phoenix.end2end.index.txn.RollbackIT
[INFO] Tests run: 6, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 112.088 
s - in org.apache.phoenix.end2end.index.txn.MutableRollbackIT
[INFO] Running org.apache.phoenix.end2end.join.HashJoinCacheIT
[WARNING] Tests run: 12, Failures: 0, Errors: 0, Skipped: 2, Time elapsed: 
111.49 s - in org.apache.phoenix.end2end.index.ViewIndexIT
[INFO] Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 14.332 s 
- in org.apache.phoenix.end2end.join.HashJoinCacheIT
[INFO] Running org.apache.phoenix.end2end.join.HashJoinLocalIndexIT
[INFO] Running org.apache.phoenix.end2end.join.HashJoinGlobalIndexIT
[INFO] Tests run: 8, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 83.927 s 
- in org.apache.phoenix.end2end.index.txn.RollbackIT
[INFO] Running org.apache.phoenix.end2end.join.HashJoinMoreIT
[INFO] Tests run: 40, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 476.07 
s - in org.apache.phoenix.end2end.index.LocalImmutableNonTxIndexIT
[INFO] Tests run: 40, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 498.809 
s - in org.apache.phoenix.end2end.index.LocalImmutableTxIndexIT
[INFO] Running org.apache.phoenix.end2end.join.HashJoinNoIndexIT
[INFO] Tests run: 8, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 107.577 
s - in org.apache.phoenix.end2end.join.HashJoinMoreIT
[INFO] Running org.apache.phoenix.end2end.join.SortMergeJoinLocalIndexIT
[INFO] Running org.apache.phoenix.end2end.join.SortMergeJoinGlobalIndexIT
[INFO] Tests run: 40, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 480.596 
s - in org.apache.phoenix.end2end.index.LocalMutableNonTxIndexIT
[INFO] Running org.apache.phoenix.end2end.join.SortMergeJoinNoIndexIT
[INFO] Tests run: 40, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 498.834 
s - in org.apache.phoenix.end2end.index.LocalMutableTxIndexIT
[INFO] Running org.apache.phoenix.end2end.join.SubqueryIT
[INFO] Tests run: 64, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 746.887 
s - in org.apache.phoenix.end2end.index.MutableIndexIT
[INFO] Tests run: 33, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 373.671 
s - in org.apache.phoenix.end2end.join.HashJoinNoIndexIT
[INFO] Running org.apache.phoenix.end2end.join.SubqueryUsingSortMergeJoinIT
[INFO] Running org.apache.phoenix.end2end.salted.SaltedTableIT
[INFO] Tests run: 8, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 39.247 s 
- in org.apache.phoenix.end2end.salted.SaltedTableIT
[INFO] Running org.apache.phoenix.end2end.salted.SaltedTableUpsertSelectIT
[INFO] Tests run: 34, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 390.517 
s - in org.apache.phoenix.end2end.join.SortMergeJoinNoIndexIT
[INFO] Tests run: 33, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 630.639 
s - in org.apache.phoenix.end2end.join.HashJoinGlobalIndexIT
[INFO] Running org.apache.phoenix.end2end.salted.SaltedTableVarLengthRowKeyIT
[INFO] Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 4.455 s 
- in org.apache.phoenix.end2end.salted.SaltedTableVarLengthRowKeyIT
[INFO] Running org.apache.phoenix.iterate.RoundRobinResultIteratorIT
[INFO] Tests run: 6, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 74.248 s 
- in org.apache.phoenix.end2end.salted.SaltedTableUpsertSelectIT
[INFO] Running org.apache.phoenix.replication.SystemCatalogWALEntryFilterIT
[INFO] Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.841 s 
- in org.apache.phoenix.replication.SystemCatalogWALEntryFilterIT
[INFO] Running org.apache.phoenix.rpc.UpdateCacheIT
[INFO] Tests run: 24, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 422.54 
s - in org.apache.phoenix.end2end.join.SubqueryIT
[INFO] Running org.apache.phoenix.iterate.PhoenixQueryTimeoutIT
[INFO] Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 9.472 s 
- in

[phoenix] Git Push Summary

2018-02-08 Thread elserj 
Repository: phoenix
Updated Tags:  refs/tags/v5.0.0-alpha-HBase-2.0-rc1 [created] 451d6a37d

svn commit: r1823610 - in /phoenix/site: publish/ publish/language/ source/src/site/markdown/

2018-02-08 Thread elserj 
Author: elserj
Date: Thu Feb  8 23:30:24 2018
New Revision: 1823610

URL: http://svn.apache.org/viewvc?rev=1823610=rev
Log:
Stage some 5.0.0-alpha release notes

Modified:
phoenix/site/publish/Phoenix-in-15-minutes-or-less.html
phoenix/site/publish/array_type.html
phoenix/site/publish/atomic_upsert.html
phoenix/site/publish/building.html
phoenix/site/publish/building_website.html
phoenix/site/publish/bulk_dataload.html
phoenix/site/publish/columnencoding.html
phoenix/site/publish/contributing.html
phoenix/site/publish/cursors.html
phoenix/site/publish/develop.html
phoenix/site/publish/download.html
phoenix/site/publish/dynamic_columns.html
phoenix/site/publish/explainplan.html
phoenix/site/publish/faq.html
phoenix/site/publish/flume.html
phoenix/site/publish/hive_storage_handler.html
phoenix/site/publish/index.html
phoenix/site/publish/installation.html
phoenix/site/publish/issues.html
phoenix/site/publish/joins.html
phoenix/site/publish/kafka.html
phoenix/site/publish/language/datatypes.html
phoenix/site/publish/language/functions.html
phoenix/site/publish/language/index.html
phoenix/site/publish/mailing_list.html
phoenix/site/publish/metrics.html
phoenix/site/publish/multi-tenancy.html
phoenix/site/publish/namspace_mapping.html
phoenix/site/publish/news.html
phoenix/site/publish/paged.html
phoenix/site/publish/performance.html
phoenix/site/publish/pherf.html
phoenix/site/publish/phoenix_mr.html
phoenix/site/publish/phoenix_on_emr.html
phoenix/site/publish/phoenix_orm.html
phoenix/site/publish/phoenix_python.html
phoenix/site/publish/phoenix_spark.html
phoenix/site/publish/phoenixcon.html
phoenix/site/publish/pig_integration.html
phoenix/site/publish/recent.html
phoenix/site/publish/release.html
phoenix/site/publish/release_notes.html
phoenix/site/publish/resources.html
phoenix/site/publish/roadmap.html
phoenix/site/publish/rowtimestamp.html
phoenix/site/publish/salted.html
phoenix/site/publish/secondary_indexing.html
phoenix/site/publish/sequences.html
phoenix/site/publish/server.html
phoenix/site/publish/skip_scan.html
phoenix/site/publish/source.html
phoenix/site/publish/subqueries.html
phoenix/site/publish/tablesample.html
phoenix/site/publish/team.html
phoenix/site/publish/tracing.html
phoenix/site/publish/transactions.html
phoenix/site/publish/tuning.html
phoenix/site/publish/tuning_guide.html
phoenix/site/publish/udf.html
phoenix/site/publish/update_statistics.html
phoenix/site/publish/upgrading.html
phoenix/site/publish/views.html
phoenix/site/publish/who_is_using.html
phoenix/site/source/src/site/markdown/release_notes.md

Modified: phoenix/site/publish/Phoenix-in-15-minutes-or-less.html
URL: 
http://svn.apache.org/viewvc/phoenix/site/publish/Phoenix-in-15-minutes-or-less.html?rev=1823610=1823609=1823610=diff
==
--- phoenix/site/publish/Phoenix-in-15-minutes-or-less.html (original)
+++ phoenix/site/publish/Phoenix-in-15-minutes-or-less.html Thu Feb  8 23:30:24 
2018
@@ -1,7 +1,7 @@
 
 
 
 

Modified: phoenix/site/publish/array_type.html
URL: 
http://svn.apache.org/viewvc/phoenix/site/publish/array_type.html?rev=1823610=1823609=1823610=diff
==
--- phoenix/site/publish/array_type.html (original)
+++ phoenix/site/publish/array_type.html Thu Feb  8 23:30:24 2018
@@ -1,7 +1,7 @@
 
 
 
 

Modified: phoenix/site/publish/atomic_upsert.html
URL: 
http://svn.apache.org/viewvc/phoenix/site/publish/atomic_upsert.html?rev=1823610=1823609=1823610=diff
==
--- phoenix/site/publish/atomic_upsert.html (original)
+++ phoenix/site/publish/atomic_upsert.html Thu Feb  8 23:30:24 2018
@@ -1,7 +1,7 @@
 
 
 
 

Modified: phoenix/site/publish/building.html
URL: 
http://svn.apache.org/viewvc/phoenix/site/publish/building.html?rev=1823610=1823609=1823610=diff
==
--- phoenix/site/publish/building.html (original)
+++ phoenix/site/publish/building.html Thu Feb  8 23:30:24 2018
@@ -1,7 +1,7 @@
 
 
 
 

Modified: phoenix/site/publish/building_website.html
URL: 
http://svn.apache.org/viewvc/phoenix/site/publish/building_website.html?rev=1823610=1823609=1823610=diff
==
--- phoenix/site/publish/building_website.html (original)
+++ phoenix/site/publish/building_website.html Thu Feb  8 23:30:24 2018
@@ -1,7 +1,7 @@
 
 
 
 

Modified: phoenix/site/publish/bulk_dataload.html
URL: 
http://svn.apache.org/viewvc/phoenix/site/publish/bulk_dataload.html?rev=1823610=1823609=1823610=diff

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

2018-02-08 Thread Apache Jenkins Server 
See 


Changes:

[maryannxue] PHOENIX-4586 UPSERT SELECT doesn't take in account comparison 
operators

--
[...truncated 118.14 KB...]
at 
org.apache.phoenix.util.ServerUtil.throwIOException(ServerUtil.java:62)
at 
org.apache.phoenix.index.PhoenixTransactionalIndexer.postBatchMutateIndispensably(PhoenixTransactionalIndexer.java:240)
at 
org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost$37.call(RegionCoprocessorHost.java:1040)
at 
org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost$RegionOperation.call(RegionCoprocessorHost.java:1656)
at 
org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost.execOperation(RegionCoprocessorHost.java:1733)
at 
org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost.execOperation(RegionCoprocessorHost.java:1688)
at 
org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost.postBatchMutateIndispensably(RegionCoprocessorHost.java:1036)
at 
org.apache.hadoop.hbase.regionserver.HRegion.doMiniBatchMutation(HRegion.java:2767)
at 
org.apache.hadoop.hbase.regionserver.HRegion.batchMutate(HRegion.java:2359)
at 
org.apache.hadoop.hbase.regionserver.HRegion.batchMutate(HRegion.java:2314)
at 
org.apache.hadoop.hbase.regionserver.HRegion.batchMutate(HRegion.java:2318)
at 
org.apache.hadoop.hbase.regionserver.HRegionServer.doBatchOp(HRegionServer.java:4678)
at 
org.apache.hadoop.hbase.regionserver.HRegionServer.doNonAtomicRegionMutation(HRegionServer.java:3835)
at 
org.apache.hadoop.hbase.regionserver.HRegionServer.multi(HRegionServer.java:3680)
at 
org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$2.callBlockingMethod(ClientProtos.java:32500)
at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2195)
at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:104)
at 
org.apache.hadoop.hbase.ipc.RpcExecutor.consumerLoop(RpcExecutor.java:133)
at org.apache.hadoop.hbase.ipc.RpcExecutor$1.run(RpcExecutor.java:108)
at java.lang.Thread.run(Thread.java:745)
Caused by: org.apache.hadoop.hbase.client.RetriesExhaustedWithDetailsException: 
Failed 1 action: RegionOpeningException: 1 time, servers with issues: 
asf925.gq1.ygridcore.net,36415,1518129235264, 
at 
org.apache.hadoop.hbase.client.AsyncProcess$BatchErrors.makeException(AsyncProcess.java:211)
at 
org.apache.hadoop.hbase.client.AsyncProcess$BatchErrors.access$500(AsyncProcess.java:195)
at 
org.apache.hadoop.hbase.client.AsyncProcess.getErrors(AsyncProcess.java:1082)
at 
org.apache.hadoop.hbase.client.HConnectionManager$HConnectionImplementation.processBatchCallback(HConnectionManager.java:2479)
at org.apache.hadoop.hbase.client.HTable.batchCallback(HTable.java:898)
at org.apache.hadoop.hbase.client.HTable.batchCallback(HTable.java:913)
at org.apache.hadoop.hbase.client.HTable.batch(HTable.java:888)
at 
org.apache.phoenix.hbase.index.write.ParallelWriterIndexCommitter$1.call(ParallelWriterIndexCommitter.java:170)
at 
org.apache.phoenix.hbase.index.write.ParallelWriterIndexCommitter$1.call(ParallelWriterIndexCommitter.java:133)
at java.util.concurrent.FutureTask.run(FutureTask.java:262)
at 
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at 
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
... 1 more
: 1 time, servers with issues: asf925.gq1.ygridcore.net,36415,1518129235264, 
at 
org.apache.phoenix.tx.ParameterizedTransactionIT.testNonTxToTxTable(ParameterizedTransactionIT.java:288)
Caused by: org.apache.hadoop.hbase.client.RetriesExhaustedWithDetailsException: 
Failed 1 action: org.apache.hadoop.hbase.DoNotRetryIOException: Failed 1 
action: RegionOpeningException: 1 time, servers with issues: 
asf925.gq1.ygridcore.net,36415,1518129235264, 
at 
org.apache.phoenix.util.ServerUtil.createIOException(ServerUtil.java:80)
at 
org.apache.phoenix.util.ServerUtil.throwIOException(ServerUtil.java:62)
at 
org.apache.phoenix.index.PhoenixTransactionalIndexer.postBatchMutateIndispensably(PhoenixTransactionalIndexer.java:240)
at 
org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost$37.call(RegionCoprocessorHost.java:1040)
at 
org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost$RegionOperation.call(RegionCoprocessorHost.java:1656)
at 
org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost.execOperation(RegionCoprocessorHost.java:1733)
at 
org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost.execOperation(RegionCoprocessorHost.java:1688)
at 
org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost.postBatchMutateIndispensably(RegionCoprocessorHost.java:1036)

svn commit: r24842 - /dev/phoenix/apache-phoenix-5.0.0-alpha-HBase-2.0-rc0/

2018-02-08 Thread elserj 
Author: elserj
Date: Thu Feb  8 22:34:28 2018
New Revision: 24842

Log:
Remove 5.0.0-alpha rc0

Removed:
dev/phoenix/apache-phoenix-5.0.0-alpha-HBase-2.0-rc0/

phoenix git commit: PHOENIX-4586 UPSERT SELECT doesn't take in account comparison operators for subqueries.

2018-02-08 Thread maryannxue 
Repository: phoenix
Updated Branches:
  refs/heads/4.x-cdh5.11.2 6b693e93f -> ce7fae412


PHOENIX-4586 UPSERT SELECT doesn't take in account comparison operators for 
subqueries.


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

Branch: refs/heads/4.x-cdh5.11.2
Commit: ce7fae41268dc464e1dd236fb83d557c1d107e7a
Parents: 6b693e9
Author: maryannxue 
Authored: Thu Feb 8 12:52:59 2018 -0800
Committer: maryannxue 
Committed: Thu Feb 8 12:52:59 2018 -0800

--
 .../apache/phoenix/end2end/join/SubqueryIT.java | 41 
 .../apache/phoenix/compile/UpsertCompiler.java  |  3 +-
 .../org/apache/phoenix/parse/ParseNode.java | 26 -
 3 files changed, 68 insertions(+), 2 deletions(-)
--


http://git-wip-us.apache.org/repos/asf/phoenix/blob/ce7fae41/phoenix-core/src/it/java/org/apache/phoenix/end2end/join/SubqueryIT.java
--
diff --git 
a/phoenix-core/src/it/java/org/apache/phoenix/end2end/join/SubqueryIT.java 
b/phoenix-core/src/it/java/org/apache/phoenix/end2end/join/SubqueryIT.java
index 604db63..1da98d2 100644
--- a/phoenix-core/src/it/java/org/apache/phoenix/end2end/join/SubqueryIT.java
+++ b/phoenix-core/src/it/java/org/apache/phoenix/end2end/join/SubqueryIT.java
@@ -744,6 +744,47 @@ public class SubqueryIT extends BaseJoinIT {
 }
 
 @Test
+public void testNoncorrelatedSubqueryWithUpsert() throws Exception {
+String tempTable = generateUniqueName();
+Properties props = PropertiesUtil.deepCopy(TEST_PROPERTIES);
+Connection conn = DriverManager.getConnection(getUrl(), props);
+conn.setAutoCommit(true);
+try {
+conn.createStatement().execute("CREATE TABLE " + tempTable
++ "   (item_id varchar not null primary key, "
++ "name varchar)");
+conn.createStatement().execute("UPSERT INTO " + tempTable + " 
VALUES('1', 'a')");
+conn.createStatement().execute("UPSERT INTO " + tempTable + " 
VALUES('2', 'b')");
+conn.createStatement().execute("UPSERT INTO " + tempTable + 
"(item_id, name)"
++ "   SELECT item_id, 'x' FROM " + tempTable
++ "   WHERE item_id < 'z' AND name > ALL (SELECT name FROM 
" + tempTable + ")");
+
+String query = "SELECT name FROM " + tempTable + " ORDER BY 
item_id";
+PreparedStatement statement = conn.prepareStatement(query);
+ResultSet rs = statement.executeQuery();
+assertTrue(rs.next());
+assertEquals("a", rs.getString(1));
+assertTrue(rs.next());
+assertEquals("b", rs.getString(1));
+assertFalse(rs.next());
+
+conn.createStatement().execute("UPSERT INTO " + tempTable + 
"(item_id, name)"
++ "   SELECT item_id, 'x' FROM " + tempTable
++ "   WHERE item_id < 'z' AND name > ANY (SELECT name FROM 
" + tempTable + ")");
+
+statement = conn.prepareStatement(query);
+rs = statement.executeQuery();
+assertTrue(rs.next());
+assertEquals("a", rs.getString(1));
+assertTrue(rs.next());
+assertEquals("x", rs.getString(1));
+assertFalse(rs.next());
+} finally {
+conn.close();
+}
+}
+
+@Test
 public void testSubqueryWithDelete() throws Exception {
 String tempTable = generateUniqueName();
 Properties props = PropertiesUtil.deepCopy(TEST_PROPERTIES);

http://git-wip-us.apache.org/repos/asf/phoenix/blob/ce7fae41/phoenix-core/src/main/java/org/apache/phoenix/compile/UpsertCompiler.java
--
diff --git 
a/phoenix-core/src/main/java/org/apache/phoenix/compile/UpsertCompiler.java 
b/phoenix-core/src/main/java/org/apache/phoenix/compile/UpsertCompiler.java
index 08133a4..ba202c8 100644
--- a/phoenix-core/src/main/java/org/apache/phoenix/compile/UpsertCompiler.java
+++ b/phoenix-core/src/main/java/org/apache/phoenix/compile/UpsertCompiler.java
@@ -533,9 +533,10 @@ public class UpsertCompiler {
 // region space managed by region servers. So we bail out on 
executing on server side.
 // Disable running upsert select on server side if a table has 
global mutable secondary indexes on it
 boolean hasGlobalMutableIndexes = 
SchemaUtil.hasGlobalIndex(table) && !table.isImmutableRows();
+boolean hasWhereSubquery = select.getWhere() != null &&

phoenix git commit: PHOENIX-4586 UPSERT SELECT doesn't take in account comparison operators for subqueries.

2018-02-08 Thread maryannxue 
Repository: phoenix
Updated Branches:
  refs/heads/4.x-HBase-0.98 ea57ee008 -> 63fa82e63


PHOENIX-4586 UPSERT SELECT doesn't take in account comparison operators for 
subqueries.


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

Branch: refs/heads/4.x-HBase-0.98
Commit: 63fa82e6374a03f0d243820b1e135cc88e185381
Parents: ea57ee0
Author: maryannxue 
Authored: Thu Feb 8 12:51:16 2018 -0800
Committer: maryannxue 
Committed: Thu Feb 8 12:51:16 2018 -0800

--
 .../apache/phoenix/end2end/join/SubqueryIT.java | 41 
 .../apache/phoenix/compile/UpsertCompiler.java  |  3 +-
 .../org/apache/phoenix/parse/ParseNode.java | 26 -
 3 files changed, 68 insertions(+), 2 deletions(-)
--


http://git-wip-us.apache.org/repos/asf/phoenix/blob/63fa82e6/phoenix-core/src/it/java/org/apache/phoenix/end2end/join/SubqueryIT.java
--
diff --git 
a/phoenix-core/src/it/java/org/apache/phoenix/end2end/join/SubqueryIT.java 
b/phoenix-core/src/it/java/org/apache/phoenix/end2end/join/SubqueryIT.java
index 604db63..1da98d2 100644
--- a/phoenix-core/src/it/java/org/apache/phoenix/end2end/join/SubqueryIT.java
+++ b/phoenix-core/src/it/java/org/apache/phoenix/end2end/join/SubqueryIT.java
@@ -744,6 +744,47 @@ public class SubqueryIT extends BaseJoinIT {
 }
 
 @Test
+public void testNoncorrelatedSubqueryWithUpsert() throws Exception {
+String tempTable = generateUniqueName();
+Properties props = PropertiesUtil.deepCopy(TEST_PROPERTIES);
+Connection conn = DriverManager.getConnection(getUrl(), props);
+conn.setAutoCommit(true);
+try {
+conn.createStatement().execute("CREATE TABLE " + tempTable
++ "   (item_id varchar not null primary key, "
++ "name varchar)");
+conn.createStatement().execute("UPSERT INTO " + tempTable + " 
VALUES('1', 'a')");
+conn.createStatement().execute("UPSERT INTO " + tempTable + " 
VALUES('2', 'b')");
+conn.createStatement().execute("UPSERT INTO " + tempTable + 
"(item_id, name)"
++ "   SELECT item_id, 'x' FROM " + tempTable
++ "   WHERE item_id < 'z' AND name > ALL (SELECT name FROM 
" + tempTable + ")");
+
+String query = "SELECT name FROM " + tempTable + " ORDER BY 
item_id";
+PreparedStatement statement = conn.prepareStatement(query);
+ResultSet rs = statement.executeQuery();
+assertTrue(rs.next());
+assertEquals("a", rs.getString(1));
+assertTrue(rs.next());
+assertEquals("b", rs.getString(1));
+assertFalse(rs.next());
+
+conn.createStatement().execute("UPSERT INTO " + tempTable + 
"(item_id, name)"
++ "   SELECT item_id, 'x' FROM " + tempTable
++ "   WHERE item_id < 'z' AND name > ANY (SELECT name FROM 
" + tempTable + ")");
+
+statement = conn.prepareStatement(query);
+rs = statement.executeQuery();
+assertTrue(rs.next());
+assertEquals("a", rs.getString(1));
+assertTrue(rs.next());
+assertEquals("x", rs.getString(1));
+assertFalse(rs.next());
+} finally {
+conn.close();
+}
+}
+
+@Test
 public void testSubqueryWithDelete() throws Exception {
 String tempTable = generateUniqueName();
 Properties props = PropertiesUtil.deepCopy(TEST_PROPERTIES);

http://git-wip-us.apache.org/repos/asf/phoenix/blob/63fa82e6/phoenix-core/src/main/java/org/apache/phoenix/compile/UpsertCompiler.java
--
diff --git 
a/phoenix-core/src/main/java/org/apache/phoenix/compile/UpsertCompiler.java 
b/phoenix-core/src/main/java/org/apache/phoenix/compile/UpsertCompiler.java
index fcac335..ea32b9f 100644
--- a/phoenix-core/src/main/java/org/apache/phoenix/compile/UpsertCompiler.java
+++ b/phoenix-core/src/main/java/org/apache/phoenix/compile/UpsertCompiler.java
@@ -532,9 +532,10 @@ public class UpsertCompiler {
 // region space managed by region servers. So we bail out on 
executing on server side.
 // Disable running upsert select on server side if a table has 
global mutable secondary indexes on it
 boolean hasGlobalMutableIndexes = 
SchemaUtil.hasGlobalIndex(table) && !table.isImmutableRows();
+boolean hasWhereSubquery = select.getWhere() != null &&

phoenix git commit: PHOENIX-4586 UPSERT SELECT doesn't take in account comparison operators for subqueries.

2018-02-08 Thread maryannxue 
Repository: phoenix
Updated Branches:
  refs/heads/4.x-HBase-1.1 260278532 -> 587f78de2


PHOENIX-4586 UPSERT SELECT doesn't take in account comparison operators for 
subqueries.


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

Branch: refs/heads/4.x-HBase-1.1
Commit: 587f78de2f0c5b204523ed5116301566bb6559c9
Parents: 2602785
Author: maryannxue 
Authored: Thu Feb 8 12:50:31 2018 -0800
Committer: maryannxue 
Committed: Thu Feb 8 12:50:31 2018 -0800

--
 .../apache/phoenix/end2end/join/SubqueryIT.java | 41 
 .../apache/phoenix/compile/UpsertCompiler.java  |  3 +-
 .../org/apache/phoenix/parse/ParseNode.java | 26 -
 3 files changed, 68 insertions(+), 2 deletions(-)
--


http://git-wip-us.apache.org/repos/asf/phoenix/blob/587f78de/phoenix-core/src/it/java/org/apache/phoenix/end2end/join/SubqueryIT.java
--
diff --git 
a/phoenix-core/src/it/java/org/apache/phoenix/end2end/join/SubqueryIT.java 
b/phoenix-core/src/it/java/org/apache/phoenix/end2end/join/SubqueryIT.java
index 604db63..1da98d2 100644
--- a/phoenix-core/src/it/java/org/apache/phoenix/end2end/join/SubqueryIT.java
+++ b/phoenix-core/src/it/java/org/apache/phoenix/end2end/join/SubqueryIT.java
@@ -744,6 +744,47 @@ public class SubqueryIT extends BaseJoinIT {
 }
 
 @Test
+public void testNoncorrelatedSubqueryWithUpsert() throws Exception {
+String tempTable = generateUniqueName();
+Properties props = PropertiesUtil.deepCopy(TEST_PROPERTIES);
+Connection conn = DriverManager.getConnection(getUrl(), props);
+conn.setAutoCommit(true);
+try {
+conn.createStatement().execute("CREATE TABLE " + tempTable
++ "   (item_id varchar not null primary key, "
++ "name varchar)");
+conn.createStatement().execute("UPSERT INTO " + tempTable + " 
VALUES('1', 'a')");
+conn.createStatement().execute("UPSERT INTO " + tempTable + " 
VALUES('2', 'b')");
+conn.createStatement().execute("UPSERT INTO " + tempTable + 
"(item_id, name)"
++ "   SELECT item_id, 'x' FROM " + tempTable
++ "   WHERE item_id < 'z' AND name > ALL (SELECT name FROM 
" + tempTable + ")");
+
+String query = "SELECT name FROM " + tempTable + " ORDER BY 
item_id";
+PreparedStatement statement = conn.prepareStatement(query);
+ResultSet rs = statement.executeQuery();
+assertTrue(rs.next());
+assertEquals("a", rs.getString(1));
+assertTrue(rs.next());
+assertEquals("b", rs.getString(1));
+assertFalse(rs.next());
+
+conn.createStatement().execute("UPSERT INTO " + tempTable + 
"(item_id, name)"
++ "   SELECT item_id, 'x' FROM " + tempTable
++ "   WHERE item_id < 'z' AND name > ANY (SELECT name FROM 
" + tempTable + ")");
+
+statement = conn.prepareStatement(query);
+rs = statement.executeQuery();
+assertTrue(rs.next());
+assertEquals("a", rs.getString(1));
+assertTrue(rs.next());
+assertEquals("x", rs.getString(1));
+assertFalse(rs.next());
+} finally {
+conn.close();
+}
+}
+
+@Test
 public void testSubqueryWithDelete() throws Exception {
 String tempTable = generateUniqueName();
 Properties props = PropertiesUtil.deepCopy(TEST_PROPERTIES);

http://git-wip-us.apache.org/repos/asf/phoenix/blob/587f78de/phoenix-core/src/main/java/org/apache/phoenix/compile/UpsertCompiler.java
--
diff --git 
a/phoenix-core/src/main/java/org/apache/phoenix/compile/UpsertCompiler.java 
b/phoenix-core/src/main/java/org/apache/phoenix/compile/UpsertCompiler.java
index 08133a4..ba202c8 100644
--- a/phoenix-core/src/main/java/org/apache/phoenix/compile/UpsertCompiler.java
+++ b/phoenix-core/src/main/java/org/apache/phoenix/compile/UpsertCompiler.java
@@ -533,9 +533,10 @@ public class UpsertCompiler {
 // region space managed by region servers. So we bail out on 
executing on server side.
 // Disable running upsert select on server side if a table has 
global mutable secondary indexes on it
 boolean hasGlobalMutableIndexes = 
SchemaUtil.hasGlobalIndex(table) && !table.isImmutableRows();
+boolean hasWhereSubquery = select.getWhere() != null &&

phoenix git commit: PHOENIX-4586 UPSERT SELECT doesn't take in account comparison operators for subqueries.

2018-02-08 Thread maryannxue 
Repository: phoenix
Updated Branches:
  refs/heads/4.x-HBase-1.2 a642a5577 -> 48d1df3dd


PHOENIX-4586 UPSERT SELECT doesn't take in account comparison operators for 
subqueries.


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

Branch: refs/heads/4.x-HBase-1.2
Commit: 48d1df3dd6b7316ed56b46d5a0471525dc8709e5
Parents: a642a55
Author: maryannxue 
Authored: Thu Feb 8 12:50:07 2018 -0800
Committer: maryannxue 
Committed: Thu Feb 8 12:50:07 2018 -0800

--
 .../apache/phoenix/end2end/join/SubqueryIT.java | 41 
 .../apache/phoenix/compile/UpsertCompiler.java  |  3 +-
 .../org/apache/phoenix/parse/ParseNode.java | 26 -
 3 files changed, 68 insertions(+), 2 deletions(-)
--


http://git-wip-us.apache.org/repos/asf/phoenix/blob/48d1df3d/phoenix-core/src/it/java/org/apache/phoenix/end2end/join/SubqueryIT.java
--
diff --git 
a/phoenix-core/src/it/java/org/apache/phoenix/end2end/join/SubqueryIT.java 
b/phoenix-core/src/it/java/org/apache/phoenix/end2end/join/SubqueryIT.java
index 604db63..1da98d2 100644
--- a/phoenix-core/src/it/java/org/apache/phoenix/end2end/join/SubqueryIT.java
+++ b/phoenix-core/src/it/java/org/apache/phoenix/end2end/join/SubqueryIT.java
@@ -744,6 +744,47 @@ public class SubqueryIT extends BaseJoinIT {
 }
 
 @Test
+public void testNoncorrelatedSubqueryWithUpsert() throws Exception {
+String tempTable = generateUniqueName();
+Properties props = PropertiesUtil.deepCopy(TEST_PROPERTIES);
+Connection conn = DriverManager.getConnection(getUrl(), props);
+conn.setAutoCommit(true);
+try {
+conn.createStatement().execute("CREATE TABLE " + tempTable
++ "   (item_id varchar not null primary key, "
++ "name varchar)");
+conn.createStatement().execute("UPSERT INTO " + tempTable + " 
VALUES('1', 'a')");
+conn.createStatement().execute("UPSERT INTO " + tempTable + " 
VALUES('2', 'b')");
+conn.createStatement().execute("UPSERT INTO " + tempTable + 
"(item_id, name)"
++ "   SELECT item_id, 'x' FROM " + tempTable
++ "   WHERE item_id < 'z' AND name > ALL (SELECT name FROM 
" + tempTable + ")");
+
+String query = "SELECT name FROM " + tempTable + " ORDER BY 
item_id";
+PreparedStatement statement = conn.prepareStatement(query);
+ResultSet rs = statement.executeQuery();
+assertTrue(rs.next());
+assertEquals("a", rs.getString(1));
+assertTrue(rs.next());
+assertEquals("b", rs.getString(1));
+assertFalse(rs.next());
+
+conn.createStatement().execute("UPSERT INTO " + tempTable + 
"(item_id, name)"
++ "   SELECT item_id, 'x' FROM " + tempTable
++ "   WHERE item_id < 'z' AND name > ANY (SELECT name FROM 
" + tempTable + ")");
+
+statement = conn.prepareStatement(query);
+rs = statement.executeQuery();
+assertTrue(rs.next());
+assertEquals("a", rs.getString(1));
+assertTrue(rs.next());
+assertEquals("x", rs.getString(1));
+assertFalse(rs.next());
+} finally {
+conn.close();
+}
+}
+
+@Test
 public void testSubqueryWithDelete() throws Exception {
 String tempTable = generateUniqueName();
 Properties props = PropertiesUtil.deepCopy(TEST_PROPERTIES);

http://git-wip-us.apache.org/repos/asf/phoenix/blob/48d1df3d/phoenix-core/src/main/java/org/apache/phoenix/compile/UpsertCompiler.java
--
diff --git 
a/phoenix-core/src/main/java/org/apache/phoenix/compile/UpsertCompiler.java 
b/phoenix-core/src/main/java/org/apache/phoenix/compile/UpsertCompiler.java
index 08133a4..ba202c8 100644
--- a/phoenix-core/src/main/java/org/apache/phoenix/compile/UpsertCompiler.java
+++ b/phoenix-core/src/main/java/org/apache/phoenix/compile/UpsertCompiler.java
@@ -533,9 +533,10 @@ public class UpsertCompiler {
 // region space managed by region servers. So we bail out on 
executing on server side.
 // Disable running upsert select on server side if a table has 
global mutable secondary indexes on it
 boolean hasGlobalMutableIndexes = 
SchemaUtil.hasGlobalIndex(table) && !table.isImmutableRows();
+boolean hasWhereSubquery = select.getWhere() != null &&

phoenix git commit: PHOENIX-4586 UPSERT SELECT doesn't take in account comparison operators for subqueries.

2018-02-08 Thread maryannxue 
Repository: phoenix
Updated Branches:
  refs/heads/4.x-HBase-1.3 507f2b8ee -> 7bf3a5753


PHOENIX-4586 UPSERT SELECT doesn't take in account comparison operators for 
subqueries.


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

Branch: refs/heads/4.x-HBase-1.3
Commit: 7bf3a575339ff0003ddf1cce48b7484bc352337f
Parents: 507f2b8
Author: maryannxue 
Authored: Thu Feb 8 12:49:35 2018 -0800
Committer: maryannxue 
Committed: Thu Feb 8 12:49:35 2018 -0800

--
 .../apache/phoenix/end2end/join/SubqueryIT.java | 41 
 .../apache/phoenix/compile/UpsertCompiler.java  |  3 +-
 .../org/apache/phoenix/parse/ParseNode.java | 26 -
 3 files changed, 68 insertions(+), 2 deletions(-)
--


http://git-wip-us.apache.org/repos/asf/phoenix/blob/7bf3a575/phoenix-core/src/it/java/org/apache/phoenix/end2end/join/SubqueryIT.java
--
diff --git 
a/phoenix-core/src/it/java/org/apache/phoenix/end2end/join/SubqueryIT.java 
b/phoenix-core/src/it/java/org/apache/phoenix/end2end/join/SubqueryIT.java
index 604db63..1da98d2 100644
--- a/phoenix-core/src/it/java/org/apache/phoenix/end2end/join/SubqueryIT.java
+++ b/phoenix-core/src/it/java/org/apache/phoenix/end2end/join/SubqueryIT.java
@@ -744,6 +744,47 @@ public class SubqueryIT extends BaseJoinIT {
 }
 
 @Test
+public void testNoncorrelatedSubqueryWithUpsert() throws Exception {
+String tempTable = generateUniqueName();
+Properties props = PropertiesUtil.deepCopy(TEST_PROPERTIES);
+Connection conn = DriverManager.getConnection(getUrl(), props);
+conn.setAutoCommit(true);
+try {
+conn.createStatement().execute("CREATE TABLE " + tempTable
++ "   (item_id varchar not null primary key, "
++ "name varchar)");
+conn.createStatement().execute("UPSERT INTO " + tempTable + " 
VALUES('1', 'a')");
+conn.createStatement().execute("UPSERT INTO " + tempTable + " 
VALUES('2', 'b')");
+conn.createStatement().execute("UPSERT INTO " + tempTable + 
"(item_id, name)"
++ "   SELECT item_id, 'x' FROM " + tempTable
++ "   WHERE item_id < 'z' AND name > ALL (SELECT name FROM 
" + tempTable + ")");
+
+String query = "SELECT name FROM " + tempTable + " ORDER BY 
item_id";
+PreparedStatement statement = conn.prepareStatement(query);
+ResultSet rs = statement.executeQuery();
+assertTrue(rs.next());
+assertEquals("a", rs.getString(1));
+assertTrue(rs.next());
+assertEquals("b", rs.getString(1));
+assertFalse(rs.next());
+
+conn.createStatement().execute("UPSERT INTO " + tempTable + 
"(item_id, name)"
++ "   SELECT item_id, 'x' FROM " + tempTable
++ "   WHERE item_id < 'z' AND name > ANY (SELECT name FROM 
" + tempTable + ")");
+
+statement = conn.prepareStatement(query);
+rs = statement.executeQuery();
+assertTrue(rs.next());
+assertEquals("a", rs.getString(1));
+assertTrue(rs.next());
+assertEquals("x", rs.getString(1));
+assertFalse(rs.next());
+} finally {
+conn.close();
+}
+}
+
+@Test
 public void testSubqueryWithDelete() throws Exception {
 String tempTable = generateUniqueName();
 Properties props = PropertiesUtil.deepCopy(TEST_PROPERTIES);

http://git-wip-us.apache.org/repos/asf/phoenix/blob/7bf3a575/phoenix-core/src/main/java/org/apache/phoenix/compile/UpsertCompiler.java
--
diff --git 
a/phoenix-core/src/main/java/org/apache/phoenix/compile/UpsertCompiler.java 
b/phoenix-core/src/main/java/org/apache/phoenix/compile/UpsertCompiler.java
index 08133a4..ba202c8 100644
--- a/phoenix-core/src/main/java/org/apache/phoenix/compile/UpsertCompiler.java
+++ b/phoenix-core/src/main/java/org/apache/phoenix/compile/UpsertCompiler.java
@@ -533,9 +533,10 @@ public class UpsertCompiler {
 // region space managed by region servers. So we bail out on 
executing on server side.
 // Disable running upsert select on server side if a table has 
global mutable secondary indexes on it
 boolean hasGlobalMutableIndexes = 
SchemaUtil.hasGlobalIndex(table) && !table.isImmutableRows();
+boolean hasWhereSubquery = select.getWhere() != null &&

phoenix git commit: PHOENIX-4586 UPSERT SELECT doesn't take in account comparison operators for subqueries.

2018-02-08 Thread maryannxue 
Repository: phoenix
Updated Branches:
  refs/heads/5.x-HBase-2.0 d1ad1f585 -> a7bb5c44c


PHOENIX-4586 UPSERT SELECT doesn't take in account comparison operators for 
subqueries.


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

Branch: refs/heads/5.x-HBase-2.0
Commit: a7bb5c44c6b6b8ac5ec5c26555602280bf0680df
Parents: d1ad1f5
Author: maryannxue 
Authored: Thu Feb 8 12:40:29 2018 -0800
Committer: maryannxue 
Committed: Thu Feb 8 12:40:29 2018 -0800

--
 .../apache/phoenix/end2end/join/SubqueryIT.java | 41 
 .../apache/phoenix/compile/UpsertCompiler.java  |  3 +-
 .../org/apache/phoenix/parse/ParseNode.java | 26 -
 3 files changed, 68 insertions(+), 2 deletions(-)
--


http://git-wip-us.apache.org/repos/asf/phoenix/blob/a7bb5c44/phoenix-core/src/it/java/org/apache/phoenix/end2end/join/SubqueryIT.java
--
diff --git 
a/phoenix-core/src/it/java/org/apache/phoenix/end2end/join/SubqueryIT.java 
b/phoenix-core/src/it/java/org/apache/phoenix/end2end/join/SubqueryIT.java
index 604db63..1da98d2 100644
--- a/phoenix-core/src/it/java/org/apache/phoenix/end2end/join/SubqueryIT.java
+++ b/phoenix-core/src/it/java/org/apache/phoenix/end2end/join/SubqueryIT.java
@@ -744,6 +744,47 @@ public class SubqueryIT extends BaseJoinIT {
 }
 
 @Test
+public void testNoncorrelatedSubqueryWithUpsert() throws Exception {
+String tempTable = generateUniqueName();
+Properties props = PropertiesUtil.deepCopy(TEST_PROPERTIES);
+Connection conn = DriverManager.getConnection(getUrl(), props);
+conn.setAutoCommit(true);
+try {
+conn.createStatement().execute("CREATE TABLE " + tempTable
++ "   (item_id varchar not null primary key, "
++ "name varchar)");
+conn.createStatement().execute("UPSERT INTO " + tempTable + " 
VALUES('1', 'a')");
+conn.createStatement().execute("UPSERT INTO " + tempTable + " 
VALUES('2', 'b')");
+conn.createStatement().execute("UPSERT INTO " + tempTable + 
"(item_id, name)"
++ "   SELECT item_id, 'x' FROM " + tempTable
++ "   WHERE item_id < 'z' AND name > ALL (SELECT name FROM 
" + tempTable + ")");
+
+String query = "SELECT name FROM " + tempTable + " ORDER BY 
item_id";
+PreparedStatement statement = conn.prepareStatement(query);
+ResultSet rs = statement.executeQuery();
+assertTrue(rs.next());
+assertEquals("a", rs.getString(1));
+assertTrue(rs.next());
+assertEquals("b", rs.getString(1));
+assertFalse(rs.next());
+
+conn.createStatement().execute("UPSERT INTO " + tempTable + 
"(item_id, name)"
++ "   SELECT item_id, 'x' FROM " + tempTable
++ "   WHERE item_id < 'z' AND name > ANY (SELECT name FROM 
" + tempTable + ")");
+
+statement = conn.prepareStatement(query);
+rs = statement.executeQuery();
+assertTrue(rs.next());
+assertEquals("a", rs.getString(1));
+assertTrue(rs.next());
+assertEquals("x", rs.getString(1));
+assertFalse(rs.next());
+} finally {
+conn.close();
+}
+}
+
+@Test
 public void testSubqueryWithDelete() throws Exception {
 String tempTable = generateUniqueName();
 Properties props = PropertiesUtil.deepCopy(TEST_PROPERTIES);

http://git-wip-us.apache.org/repos/asf/phoenix/blob/a7bb5c44/phoenix-core/src/main/java/org/apache/phoenix/compile/UpsertCompiler.java
--
diff --git 
a/phoenix-core/src/main/java/org/apache/phoenix/compile/UpsertCompiler.java 
b/phoenix-core/src/main/java/org/apache/phoenix/compile/UpsertCompiler.java
index a0c0971..af9d183 100644
--- a/phoenix-core/src/main/java/org/apache/phoenix/compile/UpsertCompiler.java
+++ b/phoenix-core/src/main/java/org/apache/phoenix/compile/UpsertCompiler.java
@@ -530,9 +530,10 @@ public class UpsertCompiler {
 // region space managed by region servers. So we bail out on 
executing on server side.
 // Disable running upsert select on server side if a table has 
global mutable secondary indexes on it
 boolean hasGlobalMutableIndexes = 
SchemaUtil.hasGlobalIndex(table) && !table.isImmutableRows();
+boolean hasWhereSubquery = select.getWhere() != null &&

phoenix git commit: PHOENIX-4586 UPSERT SELECT doesn't take in account comparison operators for subqueries.

2018-02-08 Thread maryannxue 
Repository: phoenix
Updated Branches:
  refs/heads/master ba8bcefc9 -> 82bbfdb1d


PHOENIX-4586 UPSERT SELECT doesn't take in account comparison operators for 
subqueries.


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

Branch: refs/heads/master
Commit: 82bbfdb1d547664513274b2450fff2104bd6b234
Parents: ba8bcef
Author: maryannxue 
Authored: Thu Feb 8 12:38:52 2018 -0800
Committer: maryannxue 
Committed: Thu Feb 8 12:38:52 2018 -0800

--
 .../apache/phoenix/end2end/join/SubqueryIT.java | 41 
 .../apache/phoenix/compile/UpsertCompiler.java  |  3 +-
 .../org/apache/phoenix/parse/ParseNode.java | 26 -
 3 files changed, 68 insertions(+), 2 deletions(-)
--


http://git-wip-us.apache.org/repos/asf/phoenix/blob/82bbfdb1/phoenix-core/src/it/java/org/apache/phoenix/end2end/join/SubqueryIT.java
--
diff --git 
a/phoenix-core/src/it/java/org/apache/phoenix/end2end/join/SubqueryIT.java 
b/phoenix-core/src/it/java/org/apache/phoenix/end2end/join/SubqueryIT.java
index 604db63..1da98d2 100644
--- a/phoenix-core/src/it/java/org/apache/phoenix/end2end/join/SubqueryIT.java
+++ b/phoenix-core/src/it/java/org/apache/phoenix/end2end/join/SubqueryIT.java
@@ -744,6 +744,47 @@ public class SubqueryIT extends BaseJoinIT {
 }
 
 @Test
+public void testNoncorrelatedSubqueryWithUpsert() throws Exception {
+String tempTable = generateUniqueName();
+Properties props = PropertiesUtil.deepCopy(TEST_PROPERTIES);
+Connection conn = DriverManager.getConnection(getUrl(), props);
+conn.setAutoCommit(true);
+try {
+conn.createStatement().execute("CREATE TABLE " + tempTable
++ "   (item_id varchar not null primary key, "
++ "name varchar)");
+conn.createStatement().execute("UPSERT INTO " + tempTable + " 
VALUES('1', 'a')");
+conn.createStatement().execute("UPSERT INTO " + tempTable + " 
VALUES('2', 'b')");
+conn.createStatement().execute("UPSERT INTO " + tempTable + 
"(item_id, name)"
++ "   SELECT item_id, 'x' FROM " + tempTable
++ "   WHERE item_id < 'z' AND name > ALL (SELECT name FROM 
" + tempTable + ")");
+
+String query = "SELECT name FROM " + tempTable + " ORDER BY 
item_id";
+PreparedStatement statement = conn.prepareStatement(query);
+ResultSet rs = statement.executeQuery();
+assertTrue(rs.next());
+assertEquals("a", rs.getString(1));
+assertTrue(rs.next());
+assertEquals("b", rs.getString(1));
+assertFalse(rs.next());
+
+conn.createStatement().execute("UPSERT INTO " + tempTable + 
"(item_id, name)"
++ "   SELECT item_id, 'x' FROM " + tempTable
++ "   WHERE item_id < 'z' AND name > ANY (SELECT name FROM 
" + tempTable + ")");
+
+statement = conn.prepareStatement(query);
+rs = statement.executeQuery();
+assertTrue(rs.next());
+assertEquals("a", rs.getString(1));
+assertTrue(rs.next());
+assertEquals("x", rs.getString(1));
+assertFalse(rs.next());
+} finally {
+conn.close();
+}
+}
+
+@Test
 public void testSubqueryWithDelete() throws Exception {
 String tempTable = generateUniqueName();
 Properties props = PropertiesUtil.deepCopy(TEST_PROPERTIES);

http://git-wip-us.apache.org/repos/asf/phoenix/blob/82bbfdb1/phoenix-core/src/main/java/org/apache/phoenix/compile/UpsertCompiler.java
--
diff --git 
a/phoenix-core/src/main/java/org/apache/phoenix/compile/UpsertCompiler.java 
b/phoenix-core/src/main/java/org/apache/phoenix/compile/UpsertCompiler.java
index 08133a4..ba202c8 100644
--- a/phoenix-core/src/main/java/org/apache/phoenix/compile/UpsertCompiler.java
+++ b/phoenix-core/src/main/java/org/apache/phoenix/compile/UpsertCompiler.java
@@ -533,9 +533,10 @@ public class UpsertCompiler {
 // region space managed by region servers. So we bail out on 
executing on server side.
 // Disable running upsert select on server side if a table has 
global mutable secondary indexes on it
 boolean hasGlobalMutableIndexes = 
SchemaUtil.hasGlobalIndex(table) && !table.isImmutableRows();
+boolean hasWhereSubquery = select.getWhere() != null &&

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

2018-02-08 Thread Apache Jenkins Server 
4.x-HBase-1.2 branch build status Successful

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

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

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

Changes
[jtaylor] PHOENIX-3941 Filter regions to scan for local indexes based on data



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

Jenkins build is back to normal : Phoenix-4.x-HBase-1.1 #656

2018-02-08 Thread Apache Jenkins Server 
See

Build failed in Jenkins: Phoenix | Master #1929

2018-02-08 Thread Apache Jenkins Server 
See 


Changes:

[jtaylor] PHOENIX-3941 Filter regions to scan for local indexes based on data

--
[...truncated 138.10 KB...]
[INFO] Tests run: 40, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 412.116 
s - in org.apache.phoenix.tx.TxCheckpointIT
[INFO] 
[INFO] Results:
[INFO] 
[ERROR] Failures: 
[ERROR]   ConcurrentMutationsIT.testConcurrentDeletesAndUpsertValues:214 
Expected to find PK in data table: (0,0)
[ERROR]   DefaultColumnValueIT.testDefaultIndexed:978
[ERROR]   RowValueConstructorIT.testRVCLastPkIsTable1stPkIndex:1584
[ERROR]   
IndexMetadataIT.testMutableTableOnlyHasPrimaryKeyIndex:623->helpTestTableOnlyHasPrimaryKeyIndex:662
[ERROR] Errors: 
[ERROR]   
OrderByIT.testOrderByReverseOptimizationWithNUllsLastBug3491:969->doTestOrderByReverseOptimizationWithNUllsLastBug3491:1017->assertResultSet:1185
 » SQLTimeout
[ERROR]   
GlobalImmutableTxIndexIT>BaseIndexIT.createIndexOnTableWithSpecifiedDefaultCF:499
 » Runtime
[ERROR]   
GlobalImmutableTxIndexIT>BaseIndexIT.createIndexOnTableWithSpecifiedDefaultCF:499
 » Runtime
[ERROR]   
GlobalImmutableTxIndexIT>BaseIndexIT.testCreateIndexAfterUpsertStartedTxnl:264->BaseIndexIT.testCreateIndexAfterUpsertStarted:276
 » Runtime
[ERROR]   
GlobalImmutableTxIndexIT>BaseIndexIT.testCreateIndexAfterUpsertStartedTxnl:264->BaseIndexIT.testCreateIndexAfterUpsertStarted:276
 » Runtime
[ERROR]   
GlobalImmutableTxIndexIT>BaseIndexIT.testCreateIndexAfterUpsertStarted:256->BaseIndexIT.testCreateIndexAfterUpsertStarted:276
 » Runtime
[ERROR]   
GlobalImmutableTxIndexIT>BaseIndexIT.testCreateIndexAfterUpsertStarted:256->BaseIndexIT.testCreateIndexAfterUpsertStarted:276
 » Runtime
[ERROR]   
GlobalImmutableTxIndexIT>BaseIndexIT.testDeleteFromAllPKColumnIndex:192 » 
Runtime
[ERROR]   
GlobalImmutableTxIndexIT>BaseIndexIT.testDeleteFromAllPKColumnIndex:192 » 
Runtime
[ERROR]   
GlobalImmutableTxIndexIT>BaseIndexIT.testDeleteFromNonPKColumnIndex:370 » 
Runtime
[ERROR]   
GlobalImmutableTxIndexIT>BaseIndexIT.testDeleteFromNonPKColumnIndex:370 » 
Runtime
[ERROR]   GlobalImmutableTxIndexIT>BaseIndexIT.testGroupByCount:424 » Runtime 
org.apache...
[ERROR]   GlobalImmutableTxIndexIT>BaseIndexIT.testGroupByCount:424 » Runtime 
org.apache...
[ERROR]   
GlobalImmutableTxIndexIT>BaseIndexIT.testInClauseWithIndexOnColumnOfUsignedIntType:470
 » Runtime
[ERROR]   
GlobalImmutableTxIndexIT>BaseIndexIT.testInClauseWithIndexOnColumnOfUsignedIntType:470
 » Runtime
[ERROR]   GlobalImmutableTxIndexIT>BaseIndexIT.testInFilterOnIndexedTable:1008 
» Runtime
[ERROR]   GlobalImmutableTxIndexIT>BaseIndexIT.testInFilterOnIndexedTable:1008 
» Runtime
[ERROR]   
GlobalImmutableTxIndexIT>BaseIndexIT.testIndexWithCaseSensitiveCols:893 » 
Runtime
[ERROR]   
GlobalImmutableTxIndexIT>BaseIndexIT.testIndexWithCaseSensitiveCols:893 » 
Runtime
[ERROR]   GlobalImmutableTxIndexIT>BaseIndexIT.testIndexWithDecimalCol:1031 » 
Runtime or...
[ERROR]   GlobalImmutableTxIndexIT>BaseIndexIT.testIndexWithDecimalCol:1031 » 
Runtime or...
[ERROR]   GlobalImmutableTxIndexIT>BaseIndexIT.testIndexWithNullableDateCol:539 
» Runtime
[ERROR]   GlobalImmutableTxIndexIT>BaseIndexIT.testIndexWithNullableDateCol:539 
» Runtime
[ERROR]   
GlobalImmutableTxIndexIT>BaseIndexIT.testIndexWithNullableFixedWithCols:132 » 
Runtime
[ERROR]   
GlobalImmutableTxIndexIT>BaseIndexIT.testIndexWithNullableFixedWithCols:132 » 
Runtime
[ERROR]   
GlobalImmutableTxIndexIT>BaseIndexIT.testMultipleUpdatesAcrossRegions:803 » 
Runtime
[ERROR]   
GlobalImmutableTxIndexIT>BaseIndexIT.testMultipleUpdatesAcrossRegions:803 » 
Runtime
[ERROR]   
GlobalImmutableTxIndexIT>BaseIndexIT.testReturnedTimestamp:1168->BaseTest.initATableValues:1083->BaseTest.ensureTableCreated:717->BaseTest.createTestTable:775->BaseTest.createTestTable:811
 » Runtime
[ERROR]   
GlobalImmutableTxIndexIT>BaseIndexIT.testReturnedTimestamp:1168->BaseTest.initATableValues:1083->BaseTest.ensureTableCreated:717->BaseTest.createTestTable:775->BaseTest.createTestTable:811
 » Runtime
[ERROR]   
GlobalImmutableTxIndexIT>BaseIndexIT.testSelectAllAndAliasWithIndex:598 » 
Runtime
[ERROR]   
GlobalImmutableTxIndexIT>BaseIndexIT.testSelectAllAndAliasWithIndex:598 » 
Runtime
[ERROR]   GlobalImmutableTxIndexIT>BaseIndexIT.testSelectCF:677 » Runtime 
org.apache.thr...
[ERROR]   GlobalImmutableTxIndexIT>BaseIndexIT.testSelectCF:677 » Runtime 
org.apache.thr...
[ERROR]   
GlobalImmutableTxIndexIT>BaseIndexIT.testSelectDistinctOnTableWithSecondaryImmutableIndex:445
 » Runtime
[ERROR]   
GlobalImmutableTxIndexIT>BaseIndexIT.testSelectDistinctOnTableWithSecondaryImmutableIndex:445
 » Runtime
[ERROR]   GlobalImmutableTxIndexIT>BaseIndexIT.testTableDescriptorPriority:1093 
» Runtime
[ERROR]   GlobalImmutableTxIndexIT>BaseIndexIT.testTableDescriptorPriority:1093 
» Runtime
[ERROR]   GlobalImmutableTxIndexIT>BaseIndexIT.testUpsertAfterIndexDrop:738 » 
Runtime or...
[ERROR]

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

2018-02-08 Thread Apache Jenkins Server 
See 


Changes:

[jtaylor] PHOENIX-3941 Filter regions to scan for local indexes based on data

--
[...truncated 110.61 KB...]
org.apache.hadoop.hbase.client.RetriesExhaustedWithDetailsException: Failed 1 
action: org.apache.hadoop.hbase.DoNotRetryIOException: Failed 1 action: 
RegionOpeningException: 1 time, servers with issues: 
asf921.gq1.ygridcore.net,45266,1518084529538, 
at 
org.apache.phoenix.util.ServerUtil.createIOException(ServerUtil.java:80)
at 
org.apache.phoenix.util.ServerUtil.throwIOException(ServerUtil.java:62)
at 
org.apache.phoenix.index.PhoenixTransactionalIndexer.postBatchMutateIndispensably(PhoenixTransactionalIndexer.java:240)
at 
org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost$37.call(RegionCoprocessorHost.java:1040)
at 
org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost$RegionOperation.call(RegionCoprocessorHost.java:1656)
at 
org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost.execOperation(RegionCoprocessorHost.java:1733)
at 
org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost.execOperation(RegionCoprocessorHost.java:1688)
at 
org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost.postBatchMutateIndispensably(RegionCoprocessorHost.java:1036)
at 
org.apache.hadoop.hbase.regionserver.HRegion.doMiniBatchMutation(HRegion.java:2767)
at 
org.apache.hadoop.hbase.regionserver.HRegion.batchMutate(HRegion.java:2359)
at 
org.apache.hadoop.hbase.regionserver.HRegion.batchMutate(HRegion.java:2314)
at 
org.apache.hadoop.hbase.regionserver.HRegion.batchMutate(HRegion.java:2318)
at 
org.apache.hadoop.hbase.regionserver.HRegionServer.doBatchOp(HRegionServer.java:4678)
at 
org.apache.hadoop.hbase.regionserver.HRegionServer.doNonAtomicRegionMutation(HRegionServer.java:3835)
at 
org.apache.hadoop.hbase.regionserver.HRegionServer.multi(HRegionServer.java:3680)
at 
org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$2.callBlockingMethod(ClientProtos.java:32500)
at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2195)
at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:104)
at 
org.apache.hadoop.hbase.ipc.RpcExecutor.consumerLoop(RpcExecutor.java:133)
at org.apache.hadoop.hbase.ipc.RpcExecutor$1.run(RpcExecutor.java:108)
at java.lang.Thread.run(Thread.java:745)
Caused by: org.apache.hadoop.hbase.client.RetriesExhaustedWithDetailsException: 
Failed 1 action: RegionOpeningException: 1 time, servers with issues: 
asf921.gq1.ygridcore.net,45266,1518084529538, 
at 
org.apache.hadoop.hbase.client.AsyncProcess$BatchErrors.makeException(AsyncProcess.java:211)
at 
org.apache.hadoop.hbase.client.AsyncProcess$BatchErrors.access$500(AsyncProcess.java:195)
at 
org.apache.hadoop.hbase.client.AsyncProcess.getErrors(AsyncProcess.java:1082)
at 
org.apache.hadoop.hbase.client.HConnectionManager$HConnectionImplementation.processBatchCallback(HConnectionManager.java:2479)
at org.apache.hadoop.hbase.client.HTable.batchCallback(HTable.java:898)
at org.apache.hadoop.hbase.client.HTable.batchCallback(HTable.java:913)
at org.apache.hadoop.hbase.client.HTable.batch(HTable.java:888)
at 
org.apache.phoenix.hbase.index.write.ParallelWriterIndexCommitter$1.call(ParallelWriterIndexCommitter.java:170)
at 
org.apache.phoenix.hbase.index.write.ParallelWriterIndexCommitter$1.call(ParallelWriterIndexCommitter.java:133)
at java.util.concurrent.FutureTask.run(FutureTask.java:262)
at 
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at 
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
... 1 more
: 1 time, servers with issues: asf921.gq1.ygridcore.net,45266,1518084529538, 
at 
org.apache.phoenix.tx.ParameterizedTransactionIT.testNonTxToTxTable(ParameterizedTransactionIT.java:288)
Caused by: org.apache.hadoop.hbase.client.RetriesExhaustedWithDetailsException: 
Failed 1 action: org.apache.hadoop.hbase.DoNotRetryIOException: Failed 1 
action: RegionOpeningException: 1 time, servers with issues: 
asf921.gq1.ygridcore.net,45266,1518084529538, 
at 
org.apache.phoenix.util.ServerUtil.createIOException(ServerUtil.java:80)
at 
org.apache.phoenix.util.ServerUtil.throwIOException(ServerUtil.java:62)
at 
org.apache.phoenix.index.PhoenixTransactionalIndexer.postBatchMutateIndispensably(PhoenixTransactionalIndexer.java:240)
at 
org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost$37.call(RegionCoprocessorHost.java:1040)
at 
org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost$RegionOperation.call(RegionCoprocessorHost.java:1656)
at

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

2018-02-08 Thread Apache Jenkins Server 
4.x-HBase-1.2 branch build status Successful

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

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

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

Changes
[ankitsinghal59] PHOENIX-4546 Projected table cannot be read through



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

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

2018-02-08 Thread Apache Jenkins Server 
See 


Changes:

[ankitsinghal59] PHOENIX-4546 Projected table cannot be read through

--
[...truncated 110.22 KB...]
[INFO] Tests run: 34, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 784.688 
s - in org.apache.phoenix.end2end.join.SortMergeJoinLocalIndexIT
[INFO] Tests run: 8, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 102.019 
s - in org.apache.phoenix.trace.PhoenixTracingEndToEndIT
[ERROR] Tests run: 52, Failures: 0, Errors: 1, Skipped: 4, Time elapsed: 
302.606 s <<< FAILURE! - in org.apache.phoenix.tx.ParameterizedTransactionIT
[ERROR] 
testNonTxToTxTable[TransactionIT_mutable=true,columnEncoded=true](org.apache.phoenix.tx.ParameterizedTransactionIT)
  Time elapsed: 12.075 s  <<< ERROR!
org.apache.phoenix.execute.CommitException: 
org.apache.hadoop.hbase.client.RetriesExhaustedWithDetailsException: Failed 1 
action: org.apache.hadoop.hbase.DoNotRetryIOException: Failed 1 action: 
RegionOpeningException: 1 time, 
at 
org.apache.phoenix.util.ServerUtil.createIOException(ServerUtil.java:80)
at 
org.apache.phoenix.util.ServerUtil.throwIOException(ServerUtil.java:62)
at 
org.apache.phoenix.index.PhoenixTransactionalIndexer.postBatchMutateIndispensably(PhoenixTransactionalIndexer.java:240)
at 
org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost$37.call(RegionCoprocessorHost.java:1051)
at 
org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost$RegionOperation.call(RegionCoprocessorHost.java:1708)
at 
org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost.execOperation(RegionCoprocessorHost.java:1785)
at 
org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost.execOperation(RegionCoprocessorHost.java:1740)
at 
org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost.postBatchMutateIndispensably(RegionCoprocessorHost.java:1047)
at 
org.apache.hadoop.hbase.regionserver.HRegion.doMiniBatchMutation(HRegion.java:3298)
at 
org.apache.hadoop.hbase.regionserver.HRegion.batchMutate(HRegion.java:2855)
at 
org.apache.hadoop.hbase.regionserver.HRegion.batchMutate(HRegion.java:2797)
at 
org.apache.hadoop.hbase.regionserver.RSRpcServices.doBatchOp(RSRpcServices.java:708)
at 
org.apache.hadoop.hbase.regionserver.RSRpcServices.doNonAtomicRegionMutation(RSRpcServices.java:670)
at 
org.apache.hadoop.hbase.regionserver.RSRpcServices.multi(RSRpcServices.java:2066)
at 
org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$2.callBlockingMethod(ClientProtos.java:32393)
at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2137)
at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:107)
at 
org.apache.hadoop.hbase.ipc.RpcExecutor.consumerLoop(RpcExecutor.java:133)
at org.apache.hadoop.hbase.ipc.RpcExecutor$1.run(RpcExecutor.java:108)
at java.lang.Thread.run(Thread.java:745)
Caused by: org.apache.hadoop.hbase.client.RetriesExhaustedWithDetailsException: 
Failed 1 action: RegionOpeningException: 1 time, 
at 
org.apache.hadoop.hbase.client.AsyncProcess$BatchErrors.makeException(AsyncProcess.java:239)
at 
org.apache.hadoop.hbase.client.AsyncProcess$BatchErrors.access$1900(AsyncProcess.java:219)
at 
org.apache.hadoop.hbase.client.AsyncProcess$AsyncRequestFutureImpl.getErrors(AsyncProcess.java:1618)
at org.apache.hadoop.hbase.client.HTable.batch(HTable.java:913)
at org.apache.hadoop.hbase.client.HTable.batch(HTable.java:927)
at 
org.apache.phoenix.hbase.index.write.ParallelWriterIndexCommitter$1.call(ParallelWriterIndexCommitter.java:166)
at 
org.apache.phoenix.hbase.index.write.ParallelWriterIndexCommitter$1.call(ParallelWriterIndexCommitter.java:130)
at java.util.concurrent.FutureTask.run(FutureTask.java:262)
at 
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at 
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
... 1 more
: 1 time, 
at 
org.apache.phoenix.tx.ParameterizedTransactionIT.testNonTxToTxTable(ParameterizedTransactionIT.java:288)
Caused by: org.apache.hadoop.hbase.client.RetriesExhaustedWithDetailsException: 
Failed 1 action: org.apache.hadoop.hbase.DoNotRetryIOException: Failed 1 
action: RegionOpeningException: 1 time, 
at 
org.apache.phoenix.util.ServerUtil.createIOException(ServerUtil.java:80)
at 
org.apache.phoenix.util.ServerUtil.throwIOException(ServerUtil.java:62)
at 
org.apache.phoenix.index.PhoenixTransactionalIndexer.postBatchMutateIndispensably(PhoenixTransactionalIndexer.java:240)
at 
org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost$37.call(RegionCoprocessorHost.java:1051)
at