Apache Phoenix - Timeout crawler - Build https://builds.apache.org/job/Phoenix-master-matrix/7/

[Apache Jenkins Server]

[...truncated 30 lines...]
Looking at the log, list of test(s) that timed-out:

Build:
https://builds.apache.org/job/Phoenix-master-matrix/7/


Affected test class(es):
Set(['as SYSTEM'])


Build step 'Execute shell' marked build as failure
Email was triggered for: Failure - Any
Sending email for trigger: Failure - Any

Apache Phoenix - Timeout crawler - Build https://builds.apache.org/job/Phoenix-master/2654/

[Apache Jenkins Server]

[...truncated 37 lines...]
Looking at the log, list of test(s) that timed-out:

Build:
https://builds.apache.org/job/Phoenix-master/2654/


Affected test class(es):
Set(['as SYSTEM'])


Build step 'Execute shell' marked build as failure
Email was triggered for: Failure - Any
Sending email for trigger: Failure - Any

Build failed in Jenkins: Phoenix | Master #2654

[Apache Jenkins Server]

See 


Changes:

[chinmayskulkarni] PHOENIX-5633: Add table name info to scan logging


--
[...truncated 130.73 KB...]
[INFO] Running org.apache.phoenix.end2end.DropSchemaIT
[INFO] Running org.apache.phoenix.end2end.FlappingLocalIndexIT
[INFO] Running org.apache.phoenix.end2end.IndexBuildTimestampIT
[INFO] Running org.apache.phoenix.end2end.IndexExtendedIT
[INFO] Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 32.249 s 
- in org.apache.phoenix.end2end.DropSchemaIT
[INFO] Tests run: 16, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 168.21 
s - in org.apache.phoenix.end2end.CsvBulkLoadToolIT
[INFO] Running org.apache.phoenix.end2end.IndexRebuildTaskIT
[INFO] Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 33.477 s 
- in org.apache.phoenix.end2end.IndexRebuildTaskIT
[INFO] Running org.apache.phoenix.end2end.IndexScrutinyToolForTenantIT
[INFO] Tests run: 10, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 328.841 
s - in org.apache.phoenix.end2end.ConcurrentMutationsExtendedIT
[INFO] Running org.apache.phoenix.end2end.IndexScrutinyToolIT
[INFO] Tests run: 12, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 264.671 
s - in org.apache.phoenix.end2end.FlappingLocalIndexIT
[INFO] Tests run: 16, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 259.041 
s - in org.apache.phoenix.end2end.IndexBuildTimestampIT
[INFO] Tests run: 6, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 104.726 
s - in org.apache.phoenix.end2end.IndexScrutinyToolForTenantIT
[INFO] Tests run: 48, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 292.701 
s - in org.apache.phoenix.end2end.IndexExtendedIT
[INFO] Running org.apache.phoenix.end2end.IndexToolForPartialBuildIT
[INFO] Running org.apache.phoenix.end2end.MigrateSystemTablesToSystemNamespaceIT
[INFO] Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 31.908 s 
- in org.apache.phoenix.end2end.IndexToolForPartialBuildIT
[INFO] Running org.apache.phoenix.end2end.IndexToolIT
[INFO] Running 
org.apache.phoenix.end2end.IndexToolForPartialBuildWithNamespaceEnabledIT
[INFO] Running org.apache.phoenix.end2end.LocalIndexSplitMergeIT
[INFO] Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 65.943 s 
- in org.apache.phoenix.end2end.IndexToolForPartialBuildWithNamespaceEnabledIT
[INFO] Running 
org.apache.phoenix.end2end.OrderByWithServerClientSpoolingDisabledIT
[INFO] Running org.apache.phoenix.end2end.OrderByWithServerMemoryLimitIT
[INFO] Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 4.601 s 
- in org.apache.phoenix.end2end.OrderByWithServerMemoryLimitIT
[INFO] Running org.apache.phoenix.end2end.OrderByWithSpillingIT
[INFO] Tests run: 20, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 694.911 
s - in org.apache.phoenix.end2end.CostBasedDecisionIT
[INFO] Running org.apache.phoenix.end2end.ParameterizedIndexUpgradeToolIT
[INFO] Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 304.794 
s - in org.apache.phoenix.end2end.LocalIndexSplitMergeIT
[INFO] Running org.apache.phoenix.end2end.PartialResultServerConfigurationIT
[INFO] Tests run: 16, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 275.099 
s - in org.apache.phoenix.end2end.OrderByWithServerClientSpoolingDisabledIT
[WARNING] Tests run: 33, Failures: 0, Errors: 0, Skipped: 3, Time elapsed: 
509.775 s - in org.apache.phoenix.end2end.IndexScrutinyToolIT
[INFO] Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 61.143 s 
- in org.apache.phoenix.end2end.PartialResultServerConfigurationIT
[INFO] Running org.apache.phoenix.end2end.PermissionNSDisabledIT
[INFO] Running org.apache.phoenix.end2end.PermissionNSEnabledIT
[INFO] Running org.apache.phoenix.end2end.PermissionsCacheIT
[INFO] Tests run: 4, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 563.938 
s - in org.apache.phoenix.end2end.MigrateSystemTablesToSystemNamespaceIT
[INFO] Running org.apache.phoenix.end2end.PhoenixDriverIT
[INFO] Tests run: 16, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 385.496 
s - in org.apache.phoenix.end2end.OrderByWithSpillingIT
[INFO] Tests run: 4, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 118.943 
s - in org.apache.phoenix.end2end.PhoenixDriverIT
[INFO] Running org.apache.phoenix.end2end.QueryLoggerIT
[INFO] Running org.apache.phoenix.end2end.QueryTimeoutIT
[INFO] Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 11.097 s 
- in org.apache.phoenix.end2end.QueryTimeoutIT
[INFO] Tests run: 7, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 67.519 s 
- in org.apache.phoenix.end2end.QueryLoggerIT
[INFO] Running org.apache.phoenix.end2end.QueryWithLimitIT
[INFO] Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 13.537 s 
- in org.apache.phoenix.end2end.QueryWithLimitIT
[INFO] Running org.apache.phoenix.end2end.RebuildIndexConnectionPropsIT
[INFO] Tests run: 1, Failures: 0, Errors: 0, Skipped: 

Build failed in Jenkins: Phoenix-4.x-HBase-1.5 #275

[Apache Jenkins Server]

See 


Changes:

[chinmayskulkarni] PHOENIX-5633: Add table name info to scan logging


--
[...truncated 700.48 KB...]
at 
org.apache.hadoop.hbase.client.ZooKeeperKeepAliveConnection.(ZooKeeperKeepAliveConnection.java:43)
at 
org.apache.hadoop.hbase.client.ConnectionManager$HConnectionImplementation.getKeepAliveZooKeeperWatcher(ConnectionManager.java:1772)
at 
org.apache.hadoop.hbase.client.ZooKeeperRegistry.getClusterId(ZooKeeperRegistry.java:104)
at 
org.apache.hadoop.hbase.client.ConnectionManager$HConnectionImplementation.retrieveClusterId(ConnectionManager.java:953)
at 
org.apache.hadoop.hbase.client.ConnectionManager$HConnectionImplementation.(ConnectionManager.java:729)
at 
org.apache.hadoop.hbase.client.ConnectionManager$HConnectionImplementation.(ConnectionManager.java:649)
... 32 more

Caused by: org.apache.hadoop.hbase.ipc.RemoteWithExtrasException: 
java.io.IOException: java.io.IOException: 
java.lang.reflect.InvocationTargetException
at org.apache.hadoop.hbase.security.User.runAsLoginUser(User.java:212)
at 
org.apache.hadoop.hbase.security.access.AccessController.revoke(AccessController.java:2220)
at 
org.apache.hadoop.hbase.protobuf.generated.AccessControlProtos$AccessControlService$1.revoke(AccessControlProtos.java:10031)
at 
org.apache.hadoop.hbase.protobuf.generated.AccessControlProtos$AccessControlService.callMethod(AccessControlProtos.java:10192)
at 
org.apache.hadoop.hbase.regionserver.HRegion.execService(HRegion.java:8523)
at 
org.apache.hadoop.hbase.regionserver.RSRpcServices.execServiceOnRegion(RSRpcServices.java:2282)
at 
org.apache.hadoop.hbase.regionserver.RSRpcServices.execService(RSRpcServices.java:2264)
at 
org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$2.callBlockingMethod(ClientProtos.java:36808)
at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2399)
at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:124)
at 
org.apache.hadoop.hbase.ipc.RpcExecutor$Handler.run(RpcExecutor.java:311)
at 
org.apache.hadoop.hbase.ipc.RpcExecutor$Handler.run(RpcExecutor.java:291)
Caused by: java.io.IOException: java.lang.reflect.InvocationTargetException
at 
org.apache.hadoop.hbase.client.ConnectionFactory.createConnection(ConnectionFactory.java:240)
at 
org.apache.hadoop.hbase.client.ConnectionFactory.createConnection(ConnectionFactory.java:218)
at 
org.apache.hadoop.hbase.client.ConnectionFactory.createConnection(ConnectionFactory.java:119)
at 
org.apache.hadoop.hbase.security.access.AccessControlLists.getPermissions(AccessControlLists.java:539)
at 
org.apache.hadoop.hbase.security.access.AccessControlLists.getUserPermissions(AccessControlLists.java:575)
at 
org.apache.hadoop.hbase.security.access.AccessControlLists.removeUserPermission(AccessControlLists.java:236)
at 
org.apache.hadoop.hbase.security.access.AccessController$9.run(AccessController.java:2223)
at 
org.apache.hadoop.hbase.security.access.AccessController$9.run(AccessController.java:2220)
at java.security.AccessController.doPrivileged(Native Method)
at javax.security.auth.Subject.doAs(Subject.java:422)
at 
org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1754)
at 
org.apache.hadoop.security.SecurityUtil.doAsUser(SecurityUtil.java:448)
at 
org.apache.hadoop.security.SecurityUtil.doAsLoginUser(SecurityUtil.java:429)
at sun.reflect.GeneratedMethodAccessor84.invoke(Unknown Source)
at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.apache.hadoop.hbase.util.Methods.call(Methods.java:39)
at org.apache.hadoop.hbase.security.User.runAsLoginUser(User.java:210)
... 11 more
Caused by: java.lang.reflect.InvocationTargetException
at sun.reflect.GeneratedConstructorAccessor54.newInstance(Unknown 
Source)
at 
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at 
org.apache.hadoop.hbase.client.ConnectionFactory.createConnection(ConnectionFactory.java:238)
... 28 more
Caused by: java.lang.OutOfMemoryError: unable to create new native thread
at java.lang.Thread.start0(Native Method)
at java.lang.Thread.start(Thread.java:717)
at org.apache.zookeeper.ClientCnxn.start(ClientCnxn.java:420)
at org.apache.zookeeper.ZooKeeper.(ZooKeeper.java:450)
at org.apache.zookeeper.ZooKeeper.(ZooKeeper.java:380)
at 

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

[Apache Jenkins Server]

See 


Changes:

[chinmayskulkarni] PHOENIX-5633: Add table name info to scan logging


--
[...truncated 189.56 KB...]
[INFO] 
[INFO] --- maven-failsafe-plugin:2.22.0:integration-test 
(NeedTheirOwnClusterTests) @ phoenix-core ---
[INFO] 
[INFO] ---
[INFO]  T E S T S
[INFO] ---
[INFO] Running 
org.apache.hadoop.hbase.regionserver.wal.WALReplayWithIndexWritesAndCompressedWALIT
[WARNING] Tests run: 1, Failures: 0, Errors: 0, Skipped: 1, Time elapsed: 0.003 
s - in 
org.apache.hadoop.hbase.regionserver.wal.WALReplayWithIndexWritesAndCompressedWALIT
[INFO] Running org.apache.phoenix.end2end.ConnectionUtilIT
[INFO] Running 
org.apache.hadoop.hbase.regionserver.wal.WALRecoveryRegionPostOpenIT
[INFO] Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 11.642 s 
- in org.apache.hadoop.hbase.regionserver.wal.WALRecoveryRegionPostOpenIT
[INFO] Running org.apache.phoenix.end2end.ConcurrentMutationsExtendedIT
[INFO] Running org.apache.phoenix.end2end.ColumnEncodedMutableTxStatsCollectorIT
[INFO] Running 
org.apache.phoenix.end2end.ColumnEncodedImmutableTxStatsCollectorIT
[INFO] Running 
org.apache.phoenix.end2end.ColumnEncodedMutableNonTxStatsCollectorIT
[INFO] Running 
org.apache.phoenix.end2end.ColumnEncodedImmutableNonTxStatsCollectorIT
[INFO] Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 53.92 s 
- in org.apache.phoenix.end2end.ConnectionUtilIT
[INFO] Running org.apache.phoenix.end2end.ContextClassloaderIT
[INFO] Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 4.666 s 
- in org.apache.phoenix.end2end.ContextClassloaderIT
[INFO] Running org.apache.phoenix.end2end.CostBasedDecisionIT
[INFO] Running org.apache.phoenix.end2end.CountDistinctCompressionIT
[INFO] Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 4.615 s 
- in org.apache.phoenix.end2end.CountDistinctCompressionIT
[WARNING] Tests run: 28, Failures: 0, Errors: 0, Skipped: 4, Time elapsed: 
206.647 s - in 
org.apache.phoenix.end2end.ColumnEncodedMutableNonTxStatsCollectorIT
[WARNING] Tests run: 28, Failures: 0, Errors: 0, Skipped: 4, Time elapsed: 
208.963 s - in 
org.apache.phoenix.end2end.ColumnEncodedImmutableNonTxStatsCollectorIT
[WARNING] Tests run: 28, Failures: 0, Errors: 0, Skipped: 4, Time elapsed: 
216.553 s - in 
org.apache.phoenix.end2end.ColumnEncodedImmutableTxStatsCollectorIT
[WARNING] Tests run: 28, Failures: 0, Errors: 0, Skipped: 4, Time elapsed: 
217.14 s - in org.apache.phoenix.end2end.ColumnEncodedMutableTxStatsCollectorIT
[INFO] Running org.apache.phoenix.end2end.CsvBulkLoadToolIT
[INFO] Tests run: 10, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 289.054 
s - in org.apache.phoenix.end2end.ConcurrentMutationsExtendedIT
[INFO] Running org.apache.phoenix.end2end.DropSchemaIT
[INFO] Running org.apache.phoenix.end2end.IndexExtendedIT
[INFO] Running org.apache.phoenix.end2end.IndexBuildTimestampIT
[INFO] Running org.apache.phoenix.end2end.FlappingLocalIndexIT
[INFO] Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 39.023 s 
- in org.apache.phoenix.end2end.DropSchemaIT
[INFO] Running org.apache.phoenix.end2end.IndexRebuildTaskIT
[INFO] Tests run: 16, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 157.369 
s - in org.apache.phoenix.end2end.CsvBulkLoadToolIT
[INFO] Running org.apache.phoenix.end2end.IndexScrutinyToolForTenantIT
[INFO] Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 34.694 s 
- in org.apache.phoenix.end2end.IndexRebuildTaskIT
[INFO] Running org.apache.phoenix.end2end.IndexScrutinyToolIT
[INFO] Running org.apache.phoenix.end2end.IndexToolForPartialBuildIT
[INFO] Tests run: 6, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 93.165 s 
- in org.apache.phoenix.end2end.IndexScrutinyToolForTenantIT
[INFO] Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 23.192 s 
- in org.apache.phoenix.end2end.IndexToolForPartialBuildIT
[INFO] Tests run: 12, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 199.386 
s - in org.apache.phoenix.end2end.FlappingLocalIndexIT
[INFO] Tests run: 16, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 210.658 
s - in org.apache.phoenix.end2end.IndexBuildTimestampIT
[INFO] Tests run: 48, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 255.584 
s - in org.apache.phoenix.end2end.IndexExtendedIT
[INFO] Running org.apache.phoenix.end2end.MigrateSystemTablesToSystemNamespaceIT
[INFO] Running 
org.apache.phoenix.end2end.IndexToolForPartialBuildWithNamespaceEnabledIT
[INFO] Running org.apache.phoenix.end2end.IndexToolIT
[INFO] Running org.apache.phoenix.end2end.MaxLookbackIT
[INFO] Running org.apache.phoenix.end2end.LocalIndexSplitMergeIT
[INFO] Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 53.153 s 
- in 

Jenkins build is back to normal : Phoenix-4.x-HBase-1.4 #399

[Apache Jenkins Server]

See 

Apache Phoenix - Timeout crawler - Build https://builds.apache.org/job/Phoenix-master-matrix/6/

[Apache Jenkins Server]

[...truncated 21 lines...]
Looking at the log, list of test(s) that timed-out:

Build:
https://builds.apache.org/job/Phoenix-master-matrix/6/


Affected test class(es):
Set(['as SYSTEM'])


Build step 'Execute shell' marked build as failure
Email was triggered for: Failure - Any
Sending email for trigger: Failure - Any

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

[Apache Jenkins Server]

See 


Changes:

[abhishek.chouhan] PHOENIX-5529 Creating a grand-child view on a table with an 
index fails


--
[...truncated 141.09 KB...]
at 
org.apache.hadoop.hbase.client.RpcRetryingCallerWithReadReplicas.getRegionLocations(RpcRetryingCallerWithReadReplicas.java:303)
at 
org.apache.hadoop.hbase.client.ScannerCallableWithReplicas.call(ScannerCallableWithReplicas.java:156)
at 
org.apache.hadoop.hbase.client.ScannerCallableWithReplicas.call(ScannerCallableWithReplicas.java:60)
at 
org.apache.hadoop.hbase.client.RpcRetryingCaller.callWithoutRetries(RpcRetryingCaller.java:212)
... 27 more


[INFO] Tests run: 4, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 64.628 s 
- in org.apache.phoenix.end2end.DropIndexedColsIT
[INFO] Tests run: 4, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 62.917 s 
- in org.apache.phoenix.end2end.TenantSpecificViewIndexSaltedIT
[INFO] Tests run: 9, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 146.592 
s - in org.apache.phoenix.end2end.AlterMultiTenantTableWithViewsIT
[ERROR] Tests run: 10, Failures: 0, Errors: 1, Skipped: 0, Time elapsed: 134.26 
s <<< FAILURE! - in org.apache.phoenix.end2end.TenantSpecificViewIndexIT
[ERROR] 
testMultiCFViewLocalIndex(org.apache.phoenix.end2end.TenantSpecificViewIndexIT) 
 Time elapsed: 10.767 s  <<< ERROR!
org.apache.phoenix.exception.PhoenixIOException: 
org.apache.hadoop.hbase.DoNotRetryIOException: SCHEMA2.N02: 
java.lang.RuntimeException: java.lang.OutOfMemoryError: unable to create new 
native thread
at 
org.apache.phoenix.util.ServerUtil.createIOException(ServerUtil.java:120)
at 
org.apache.phoenix.coprocessor.MetaDataEndpointImpl.createTable(MetaDataEndpointImpl.java:2106)
at 
org.apache.phoenix.coprocessor.generated.MetaDataProtos$MetaDataService.callMethod(MetaDataProtos.java:17218)
at 
org.apache.hadoop.hbase.regionserver.HRegion.execService(HRegion.java:8350)
at 
org.apache.hadoop.hbase.regionserver.RSRpcServices.execServiceOnRegion(RSRpcServices.java:2170)
at 
org.apache.hadoop.hbase.regionserver.RSRpcServices.execService(RSRpcServices.java:2152)
at 
org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$2.callBlockingMethod(ClientProtos.java:35076)
at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2376)
at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:123)
at 
org.apache.hadoop.hbase.ipc.RpcExecutor$Handler.run(RpcExecutor.java:188)
at 
org.apache.hadoop.hbase.ipc.RpcExecutor$Handler.run(RpcExecutor.java:168)
Caused by: java.lang.RuntimeException: java.lang.RuntimeException: 
java.lang.OutOfMemoryError: unable to create new native thread
at 
org.apache.hadoop.hbase.client.RpcRetryingCaller.callWithoutRetries(RpcRetryingCaller.java:220)
at 
org.apache.hadoop.hbase.client.ClientScanner.call(ClientScanner.java:314)
at 
org.apache.hadoop.hbase.client.ClientScanner.nextScanner(ClientScanner.java:289)
at 
org.apache.hadoop.hbase.client.ClientScanner.initializeScannerInConstruction(ClientScanner.java:164)
at 
org.apache.hadoop.hbase.client.ClientScanner.(ClientScanner.java:159)
at org.apache.hadoop.hbase.client.HTable.getScanner(HTable.java:796)
at 
org.apache.hadoop.hbase.client.HTableWrapper.getScanner(HTableWrapper.java:215)
at org.apache.phoenix.util.ViewUtil.findRelatedViews(ViewUtil.java:124)
at org.apache.phoenix.util.ViewUtil.dropChildViews(ViewUtil.java:197)
at 
org.apache.phoenix.coprocessor.MetaDataEndpointImpl.createTable(MetaDataEndpointImpl.java:1762)
... 9 more
Caused by: java.lang.RuntimeException: java.lang.OutOfMemoryError: unable to 
create new native thread
at 
org.apache.hadoop.hbase.client.RpcRetryingCaller.callWithoutRetries(RpcRetryingCaller.java:220)
at 
org.apache.hadoop.hbase.client.ClientSmallReversedScanner.loadCache(ClientSmallReversedScanner.java:228)
at 
org.apache.hadoop.hbase.client.ClientSmallReversedScanner.next(ClientSmallReversedScanner.java:202)
at 
org.apache.hadoop.hbase.client.ConnectionManager$HConnectionImplementation.locateRegionInMeta(ConnectionManager.java:1298)
at 
org.apache.hadoop.hbase.client.ConnectionManager$HConnectionImplementation.locateRegion(ConnectionManager.java:1197)
at 
org.apache.hadoop.hbase.client.CoprocessorHConnection.locateRegion(CoprocessorHConnection.java:41)
at 
org.apache.hadoop.hbase.client.RpcRetryingCallerWithReadReplicas.getRegionLocations(RpcRetryingCallerWithReadReplicas.java:303)
at 
org.apache.hadoop.hbase.client.ScannerCallableWithReplicas.call(ScannerCallableWithReplicas.java:156)
at 
org.apache.hadoop.hbase.client.ScannerCallableWithReplicas.call(ScannerCallableWithReplicas.java:60)
at 

[phoenix] branch 4.15-HBase-1.4 updated: PHOENIX-5633: Add table name info to scan logging

[chinmayskulkarni]

This is an automated email from the ASF dual-hosted git repository.

chinmayskulkarni pushed a commit to branch 4.15-HBase-1.4
in repository https://gitbox.apache.org/repos/asf/phoenix.git


The following commit(s) were added to refs/heads/4.15-HBase-1.4 by this push:
 new 3e54447  PHOENIX-5633: Add table name info to scan logging
3e54447 is described below

commit 3e54447140302f3632af4efeebb94600f7460f86
Author: Christine Feng 
AuthorDate: Thu Jan 23 12:27:36 2020 -0800

PHOENIX-5633: Add table name info to scan logging

Signed-off-by: Chinmay Kulkarni 
---
 .../src/main/java/org/apache/phoenix/execute/BaseQueryPlan.java   | 4 ++--
 .../src/main/java/org/apache/phoenix/iterate/BaseResultIterators.java | 2 +-
 2 files changed, 3 insertions(+), 3 deletions(-)

diff --git 
a/phoenix-core/src/main/java/org/apache/phoenix/execute/BaseQueryPlan.java 
b/phoenix-core/src/main/java/org/apache/phoenix/execute/BaseQueryPlan.java
index caa60a0..89c5233 100644
--- a/phoenix-core/src/main/java/org/apache/phoenix/execute/BaseQueryPlan.java
+++ b/phoenix-core/src/main/java/org/apache/phoenix/execute/BaseQueryPlan.java
@@ -359,13 +359,13 @@ public abstract class BaseQueryPlan implements QueryPlan {
 
 if (LOGGER.isDebugEnabled()) {
 LOGGER.debug(LogUtil.addCustomAnnotations(
-   "Scan ready for iteration: " + scan, connection));
+"Scan on table " + 
context.getCurrentTable().getTable().getName() + " ready for iteration: " + 
scan, connection));
 }
 
 ResultIterator iterator =  newIterator(scanGrouper, scan, caches);
 if (LOGGER.isDebugEnabled()) {
 LOGGER.debug(LogUtil.addCustomAnnotations(
-   "Iterator ready: " + iterator, connection));
+"Iterator for table " + 
context.getCurrentTable().getTable().getName() + " ready: " + iterator, 
connection));
 }
 
 // wrap the iterator so we start/end tracing as we expect
diff --git 
a/phoenix-core/src/main/java/org/apache/phoenix/iterate/BaseResultIterators.java
 
b/phoenix-core/src/main/java/org/apache/phoenix/iterate/BaseResultIterators.java
index 45b4d4d..56c27c9 100644
--- 
a/phoenix-core/src/main/java/org/apache/phoenix/iterate/BaseResultIterators.java
+++ 
b/phoenix-core/src/main/java/org/apache/phoenix/iterate/BaseResultIterators.java
@@ -1229,7 +1229,7 @@ public abstract class BaseResultIterators extends 
ExplainTable implements Result
 public List getIterators() throws SQLException {
 if (LOGGER.isDebugEnabled()) {
 LOGGER.debug(LogUtil.addCustomAnnotations("Getting iterators for " 
+ this,
-ScanUtil.getCustomAnnotations(scan)));
+ScanUtil.getCustomAnnotations(scan)) + "on table " + 
context.getCurrentTable().getTable().getName());
 }
 boolean isReverse = ScanUtil.isReversed(scan);
 boolean isLocalIndex = getTable().getIndexType() == IndexType.LOCAL;

[phoenix] branch 4.15-HBase-1.5 updated: PHOENIX-5633: Add table name info to scan logging

[chinmayskulkarni]

This is an automated email from the ASF dual-hosted git repository.

chinmayskulkarni pushed a commit to branch 4.15-HBase-1.5
in repository https://gitbox.apache.org/repos/asf/phoenix.git


The following commit(s) were added to refs/heads/4.15-HBase-1.5 by this push:
 new 3a3eee6  PHOENIX-5633: Add table name info to scan logging
3a3eee6 is described below

commit 3a3eee64a47927afecaf4b3c8f058ffa7238bc2e
Author: Christine Feng 
AuthorDate: Thu Jan 23 12:27:36 2020 -0800

PHOENIX-5633: Add table name info to scan logging

Signed-off-by: Chinmay Kulkarni 
---
 .../src/main/java/org/apache/phoenix/execute/BaseQueryPlan.java   | 4 ++--
 .../src/main/java/org/apache/phoenix/iterate/BaseResultIterators.java | 2 +-
 2 files changed, 3 insertions(+), 3 deletions(-)

diff --git 
a/phoenix-core/src/main/java/org/apache/phoenix/execute/BaseQueryPlan.java 
b/phoenix-core/src/main/java/org/apache/phoenix/execute/BaseQueryPlan.java
index caa60a0..89c5233 100644
--- a/phoenix-core/src/main/java/org/apache/phoenix/execute/BaseQueryPlan.java
+++ b/phoenix-core/src/main/java/org/apache/phoenix/execute/BaseQueryPlan.java
@@ -359,13 +359,13 @@ public abstract class BaseQueryPlan implements QueryPlan {
 
 if (LOGGER.isDebugEnabled()) {
 LOGGER.debug(LogUtil.addCustomAnnotations(
-   "Scan ready for iteration: " + scan, connection));
+"Scan on table " + 
context.getCurrentTable().getTable().getName() + " ready for iteration: " + 
scan, connection));
 }
 
 ResultIterator iterator =  newIterator(scanGrouper, scan, caches);
 if (LOGGER.isDebugEnabled()) {
 LOGGER.debug(LogUtil.addCustomAnnotations(
-   "Iterator ready: " + iterator, connection));
+"Iterator for table " + 
context.getCurrentTable().getTable().getName() + " ready: " + iterator, 
connection));
 }
 
 // wrap the iterator so we start/end tracing as we expect
diff --git 
a/phoenix-core/src/main/java/org/apache/phoenix/iterate/BaseResultIterators.java
 
b/phoenix-core/src/main/java/org/apache/phoenix/iterate/BaseResultIterators.java
index 45b4d4d..56c27c9 100644
--- 
a/phoenix-core/src/main/java/org/apache/phoenix/iterate/BaseResultIterators.java
+++ 
b/phoenix-core/src/main/java/org/apache/phoenix/iterate/BaseResultIterators.java
@@ -1229,7 +1229,7 @@ public abstract class BaseResultIterators extends 
ExplainTable implements Result
 public List getIterators() throws SQLException {
 if (LOGGER.isDebugEnabled()) {
 LOGGER.debug(LogUtil.addCustomAnnotations("Getting iterators for " 
+ this,
-ScanUtil.getCustomAnnotations(scan)));
+ScanUtil.getCustomAnnotations(scan)) + "on table " + 
context.getCurrentTable().getTable().getName());
 }
 boolean isReverse = ScanUtil.isReversed(scan);
 boolean isLocalIndex = getTable().getIndexType() == IndexType.LOCAL;

Build failed in Jenkins: Phoenix-4.x-HBase-1.4 #398

[Apache Jenkins Server]

See 


Changes:

[abhishek.chouhan] PHOENIX-5529 Creating a grand-child view on a table with an 
index fails


--
[...truncated 188.96 KB...]
[INFO] 
[INFO] ---
[INFO]  T E S T S
[INFO] ---
[INFO] 
[INFO] Results:
[INFO] 
[INFO] Tests run: 0, Failures: 0, Errors: 0, Skipped: 0
[INFO] 
[INFO] 
[INFO] --- maven-failsafe-plugin:2.22.0:integration-test 
(NeedTheirOwnClusterTests) @ phoenix-core ---
[INFO] 
[INFO] ---
[INFO]  T E S T S
[INFO] ---
[INFO] Running 
org.apache.hadoop.hbase.regionserver.wal.WALReplayWithIndexWritesAndCompressedWALIT
[WARNING] Tests run: 1, Failures: 0, Errors: 0, Skipped: 1, Time elapsed: 0.003 
s - in 
org.apache.hadoop.hbase.regionserver.wal.WALReplayWithIndexWritesAndCompressedWALIT
[INFO] Running org.apache.phoenix.end2end.ConnectionUtilIT
[INFO] Running 
org.apache.hadoop.hbase.regionserver.wal.WALRecoveryRegionPostOpenIT
[INFO] Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 9.504 s 
- in org.apache.hadoop.hbase.regionserver.wal.WALRecoveryRegionPostOpenIT
[INFO] Running org.apache.phoenix.end2end.ConcurrentMutationsExtendedIT
[INFO] Running org.apache.phoenix.end2end.CountDistinctCompressionIT
[INFO] Running org.apache.phoenix.end2end.CsvBulkLoadToolIT
[INFO] Running org.apache.phoenix.end2end.ContextClassloaderIT
[INFO] Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 4.85 s - 
in org.apache.phoenix.end2end.CountDistinctCompressionIT
[INFO] Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 4.62 s - 
in org.apache.phoenix.end2end.ContextClassloaderIT
[INFO] Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 64.784 s 
- in org.apache.phoenix.end2end.ConnectionUtilIT
[INFO] Running org.apache.phoenix.end2end.CostBasedDecisionIT
[INFO] Running org.apache.phoenix.end2end.DropSchemaIT
[INFO] Running org.apache.phoenix.end2end.IndexBuildTimestampIT
[INFO] Running org.apache.phoenix.end2end.IndexExtendedIT
[INFO] Running org.apache.phoenix.end2end.FlappingLocalIndexIT
[INFO] Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 34.479 s 
- in org.apache.phoenix.end2end.DropSchemaIT
[INFO] Tests run: 16, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 154.62 
s - in org.apache.phoenix.end2end.CsvBulkLoadToolIT
[INFO] Running org.apache.phoenix.end2end.IndexRebuildTaskIT
[INFO] Running org.apache.phoenix.end2end.IndexScrutinyToolForTenantIT
[INFO] Tests run: 10, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 283.482 
s - in org.apache.phoenix.end2end.ConcurrentMutationsExtendedIT
[INFO] Tests run: 16, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 199.572 
s - in org.apache.phoenix.end2end.IndexBuildTimestampIT
[INFO] Tests run: 12, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 204.046 
s - in org.apache.phoenix.end2end.FlappingLocalIndexIT
[INFO] Tests run: 6, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 97.242 s 
- in org.apache.phoenix.end2end.IndexScrutinyToolForTenantIT
[INFO] Running org.apache.phoenix.end2end.IndexScrutinyToolIT
[INFO] Tests run: 48, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 250.597 
s - in org.apache.phoenix.end2end.IndexExtendedIT
[INFO] Running org.apache.phoenix.end2end.IndexToolForPartialBuildIT
[INFO] Running 
org.apache.phoenix.end2end.IndexToolForPartialBuildWithNamespaceEnabledIT
[INFO] Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 26.35 s 
- in org.apache.phoenix.end2end.IndexToolForPartialBuildIT
[INFO] Running org.apache.phoenix.end2end.IndexToolIT
[ERROR] Tests run: 1, Failures: 1, Errors: 0, Skipped: 0, Time elapsed: 231.42 
s <<< FAILURE! - in org.apache.phoenix.end2end.IndexRebuildTaskIT
[ERROR] testIndexRebuildTask(org.apache.phoenix.end2end.IndexRebuildTaskIT)  
Time elapsed: 231.42 s  <<< FAILURE!
java.lang.AssertionError: Ran out of time waiting for task state to become 
COMPLETED
at 
org.apache.phoenix.end2end.IndexRebuildTaskIT.waitForTaskState(IndexRebuildTaskIT.java:196)
at 
org.apache.phoenix.end2end.IndexRebuildTaskIT.testIndexRebuildTask(IndexRebuildTaskIT.java:156)

[INFO] Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 44.853 s 
- in org.apache.phoenix.end2end.IndexToolForPartialBuildWithNamespaceEnabledIT
[INFO] Running org.apache.phoenix.end2end.MigrateSystemTablesToSystemNamespaceIT
[INFO] Running org.apache.phoenix.end2end.LocalIndexSplitMergeIT
[INFO] Running org.apache.phoenix.end2end.MaxLookbackIT
[INFO] Running 
org.apache.phoenix.end2end.OrderByWithServerClientSpoolingDisabledIT
[INFO] Tests run: 4, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 66.136 s 
- in org.apache.phoenix.end2end.MaxLookbackIT
[INFO] Tests run: 3, Failures: 0, Errors: 0, 

[phoenix] branch 4.x-HBase-1.4 updated: PHOENIX-5633: Add table name info to scan logging

[chinmayskulkarni]

This is an automated email from the ASF dual-hosted git repository.

chinmayskulkarni pushed a commit to branch 4.x-HBase-1.4
in repository https://gitbox.apache.org/repos/asf/phoenix.git


The following commit(s) were added to refs/heads/4.x-HBase-1.4 by this push:
 new a6e1c71  PHOENIX-5633: Add table name info to scan logging
a6e1c71 is described below

commit a6e1c713fccaae1c0f06c3e48e7b9e9d7f10f959
Author: Christine Feng 
AuthorDate: Thu Jan 23 12:27:36 2020 -0800

PHOENIX-5633: Add table name info to scan logging

Signed-off-by: Chinmay Kulkarni 
---
 .../src/main/java/org/apache/phoenix/execute/BaseQueryPlan.java   | 4 ++--
 .../src/main/java/org/apache/phoenix/iterate/BaseResultIterators.java | 2 +-
 2 files changed, 3 insertions(+), 3 deletions(-)

diff --git 
a/phoenix-core/src/main/java/org/apache/phoenix/execute/BaseQueryPlan.java 
b/phoenix-core/src/main/java/org/apache/phoenix/execute/BaseQueryPlan.java
index caa60a0..89c5233 100644
--- a/phoenix-core/src/main/java/org/apache/phoenix/execute/BaseQueryPlan.java
+++ b/phoenix-core/src/main/java/org/apache/phoenix/execute/BaseQueryPlan.java
@@ -359,13 +359,13 @@ public abstract class BaseQueryPlan implements QueryPlan {
 
 if (LOGGER.isDebugEnabled()) {
 LOGGER.debug(LogUtil.addCustomAnnotations(
-   "Scan ready for iteration: " + scan, connection));
+"Scan on table " + 
context.getCurrentTable().getTable().getName() + " ready for iteration: " + 
scan, connection));
 }
 
 ResultIterator iterator =  newIterator(scanGrouper, scan, caches);
 if (LOGGER.isDebugEnabled()) {
 LOGGER.debug(LogUtil.addCustomAnnotations(
-   "Iterator ready: " + iterator, connection));
+"Iterator for table " + 
context.getCurrentTable().getTable().getName() + " ready: " + iterator, 
connection));
 }
 
 // wrap the iterator so we start/end tracing as we expect
diff --git 
a/phoenix-core/src/main/java/org/apache/phoenix/iterate/BaseResultIterators.java
 
b/phoenix-core/src/main/java/org/apache/phoenix/iterate/BaseResultIterators.java
index 2dcc88b..3d61236 100644
--- 
a/phoenix-core/src/main/java/org/apache/phoenix/iterate/BaseResultIterators.java
+++ 
b/phoenix-core/src/main/java/org/apache/phoenix/iterate/BaseResultIterators.java
@@ -1238,7 +1238,7 @@ public abstract class BaseResultIterators extends 
ExplainTable implements Result
 public List getIterators() throws SQLException {
 if (LOGGER.isDebugEnabled()) {
 LOGGER.debug(LogUtil.addCustomAnnotations("Getting iterators for " 
+ this,
-ScanUtil.getCustomAnnotations(scan)));
+ScanUtil.getCustomAnnotations(scan)) + "on table " + 
context.getCurrentTable().getTable().getName());
 }
 boolean isReverse = ScanUtil.isReversed(scan);
 boolean isLocalIndex = getTable().getIndexType() == IndexType.LOCAL;

[phoenix] branch 4.15-HBase-1.3 updated: PHOENIX-5633: Add table name info to scan logging

[chinmayskulkarni]

This is an automated email from the ASF dual-hosted git repository.

chinmayskulkarni pushed a commit to branch 4.15-HBase-1.3
in repository https://gitbox.apache.org/repos/asf/phoenix.git


The following commit(s) were added to refs/heads/4.15-HBase-1.3 by this push:
 new 00594cc  PHOENIX-5633: Add table name info to scan logging
00594cc is described below

commit 00594cc900a57e8bdcae13a548d0dc1d4ccc9b15
Author: Christine Feng 
AuthorDate: Thu Jan 23 12:27:36 2020 -0800

PHOENIX-5633: Add table name info to scan logging

Signed-off-by: Chinmay Kulkarni 
---
 .../src/main/java/org/apache/phoenix/execute/BaseQueryPlan.java   | 4 ++--
 .../src/main/java/org/apache/phoenix/iterate/BaseResultIterators.java | 2 +-
 2 files changed, 3 insertions(+), 3 deletions(-)

diff --git 
a/phoenix-core/src/main/java/org/apache/phoenix/execute/BaseQueryPlan.java 
b/phoenix-core/src/main/java/org/apache/phoenix/execute/BaseQueryPlan.java
index caa60a0..89c5233 100644
--- a/phoenix-core/src/main/java/org/apache/phoenix/execute/BaseQueryPlan.java
+++ b/phoenix-core/src/main/java/org/apache/phoenix/execute/BaseQueryPlan.java
@@ -359,13 +359,13 @@ public abstract class BaseQueryPlan implements QueryPlan {
 
 if (LOGGER.isDebugEnabled()) {
 LOGGER.debug(LogUtil.addCustomAnnotations(
-   "Scan ready for iteration: " + scan, connection));
+"Scan on table " + 
context.getCurrentTable().getTable().getName() + " ready for iteration: " + 
scan, connection));
 }
 
 ResultIterator iterator =  newIterator(scanGrouper, scan, caches);
 if (LOGGER.isDebugEnabled()) {
 LOGGER.debug(LogUtil.addCustomAnnotations(
-   "Iterator ready: " + iterator, connection));
+"Iterator for table " + 
context.getCurrentTable().getTable().getName() + " ready: " + iterator, 
connection));
 }
 
 // wrap the iterator so we start/end tracing as we expect
diff --git 
a/phoenix-core/src/main/java/org/apache/phoenix/iterate/BaseResultIterators.java
 
b/phoenix-core/src/main/java/org/apache/phoenix/iterate/BaseResultIterators.java
index 45b4d4d..56c27c9 100644
--- 
a/phoenix-core/src/main/java/org/apache/phoenix/iterate/BaseResultIterators.java
+++ 
b/phoenix-core/src/main/java/org/apache/phoenix/iterate/BaseResultIterators.java
@@ -1229,7 +1229,7 @@ public abstract class BaseResultIterators extends 
ExplainTable implements Result
 public List getIterators() throws SQLException {
 if (LOGGER.isDebugEnabled()) {
 LOGGER.debug(LogUtil.addCustomAnnotations("Getting iterators for " 
+ this,
-ScanUtil.getCustomAnnotations(scan)));
+ScanUtil.getCustomAnnotations(scan)) + "on table " + 
context.getCurrentTable().getTable().getName());
 }
 boolean isReverse = ScanUtil.isReversed(scan);
 boolean isLocalIndex = getTable().getIndexType() == IndexType.LOCAL;

[phoenix] branch master updated: PHOENIX-5633: Add table name info to scan logging

[chinmayskulkarni]

This is an automated email from the ASF dual-hosted git repository.

chinmayskulkarni pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/phoenix.git


The following commit(s) were added to refs/heads/master by this push:
 new f592bfd  PHOENIX-5633: Add table name info to scan logging
f592bfd is described below

commit f592bfdecbf5a50b54f71bad82f52a0504d6eaf5
Author: Christine Feng 
AuthorDate: Thu Jan 23 12:27:36 2020 -0800

PHOENIX-5633: Add table name info to scan logging

Signed-off-by: Chinmay Kulkarni 
---
 .../src/main/java/org/apache/phoenix/execute/BaseQueryPlan.java   | 4 ++--
 .../src/main/java/org/apache/phoenix/iterate/BaseResultIterators.java | 2 +-
 2 files changed, 3 insertions(+), 3 deletions(-)

diff --git 
a/phoenix-core/src/main/java/org/apache/phoenix/execute/BaseQueryPlan.java 
b/phoenix-core/src/main/java/org/apache/phoenix/execute/BaseQueryPlan.java
index 3f10ad0..42cc6f7 100644
--- a/phoenix-core/src/main/java/org/apache/phoenix/execute/BaseQueryPlan.java
+++ b/phoenix-core/src/main/java/org/apache/phoenix/execute/BaseQueryPlan.java
@@ -359,13 +359,13 @@ public abstract class BaseQueryPlan implements QueryPlan {
 
 if (LOGGER.isDebugEnabled()) {
 LOGGER.debug(LogUtil.addCustomAnnotations(
-"Scan ready for iteration: " + scan, connection));
+"Scan on table " + 
context.getCurrentTable().getTable().getName() + " ready for iteration: " + 
scan, connection));
 }
 
 ResultIterator iterator =  newIterator(scanGrouper, scan, caches);
 if (LOGGER.isDebugEnabled()) {
 LOGGER.debug(LogUtil.addCustomAnnotations(
-"Iterator ready: " + iterator, connection));
+"Iterator for table " + 
context.getCurrentTable().getTable().getName() + " ready: " + iterator, 
connection));
 }
 
 // wrap the iterator so we start/end tracing as we expect
diff --git 
a/phoenix-core/src/main/java/org/apache/phoenix/iterate/BaseResultIterators.java
 
b/phoenix-core/src/main/java/org/apache/phoenix/iterate/BaseResultIterators.java
index 12a6b3a..02e7e6c 100644
--- 
a/phoenix-core/src/main/java/org/apache/phoenix/iterate/BaseResultIterators.java
+++ 
b/phoenix-core/src/main/java/org/apache/phoenix/iterate/BaseResultIterators.java
@@ -1238,7 +1238,7 @@ public abstract class BaseResultIterators extends 
ExplainTable implements Result
 public List getIterators() throws SQLException {
 if (LOGGER.isDebugEnabled()) {
 LOGGER.debug(LogUtil.addCustomAnnotations("Getting iterators for " 
+ this,
-ScanUtil.getCustomAnnotations(scan)));
+ScanUtil.getCustomAnnotations(scan)) + "on table " + 
context.getCurrentTable().getTable().getName());
 }
 boolean isReverse = ScanUtil.isReversed(scan);
 boolean isLocalIndex = getTable().getIndexType() == IndexType.LOCAL;

[phoenix] branch 4.x-HBase-1.5 updated: PHOENIX-5633: Add table name info to scan logging

[chinmayskulkarni]

This is an automated email from the ASF dual-hosted git repository.

chinmayskulkarni pushed a commit to branch 4.x-HBase-1.5
in repository https://gitbox.apache.org/repos/asf/phoenix.git


The following commit(s) were added to refs/heads/4.x-HBase-1.5 by this push:
 new ec86e26  PHOENIX-5633: Add table name info to scan logging
ec86e26 is described below

commit ec86e26969434eb96a038824462703e6790dc377
Author: Christine Feng 
AuthorDate: Thu Jan 23 12:27:36 2020 -0800

PHOENIX-5633: Add table name info to scan logging

Signed-off-by: Chinmay Kulkarni 
---
 .../src/main/java/org/apache/phoenix/execute/BaseQueryPlan.java   | 4 ++--
 .../src/main/java/org/apache/phoenix/iterate/BaseResultIterators.java | 2 +-
 2 files changed, 3 insertions(+), 3 deletions(-)

diff --git 
a/phoenix-core/src/main/java/org/apache/phoenix/execute/BaseQueryPlan.java 
b/phoenix-core/src/main/java/org/apache/phoenix/execute/BaseQueryPlan.java
index caa60a0..89c5233 100644
--- a/phoenix-core/src/main/java/org/apache/phoenix/execute/BaseQueryPlan.java
+++ b/phoenix-core/src/main/java/org/apache/phoenix/execute/BaseQueryPlan.java
@@ -359,13 +359,13 @@ public abstract class BaseQueryPlan implements QueryPlan {
 
 if (LOGGER.isDebugEnabled()) {
 LOGGER.debug(LogUtil.addCustomAnnotations(
-   "Scan ready for iteration: " + scan, connection));
+"Scan on table " + 
context.getCurrentTable().getTable().getName() + " ready for iteration: " + 
scan, connection));
 }
 
 ResultIterator iterator =  newIterator(scanGrouper, scan, caches);
 if (LOGGER.isDebugEnabled()) {
 LOGGER.debug(LogUtil.addCustomAnnotations(
-   "Iterator ready: " + iterator, connection));
+"Iterator for table " + 
context.getCurrentTable().getTable().getName() + " ready: " + iterator, 
connection));
 }
 
 // wrap the iterator so we start/end tracing as we expect
diff --git 
a/phoenix-core/src/main/java/org/apache/phoenix/iterate/BaseResultIterators.java
 
b/phoenix-core/src/main/java/org/apache/phoenix/iterate/BaseResultIterators.java
index 2dcc88b..3d61236 100644
--- 
a/phoenix-core/src/main/java/org/apache/phoenix/iterate/BaseResultIterators.java
+++ 
b/phoenix-core/src/main/java/org/apache/phoenix/iterate/BaseResultIterators.java
@@ -1238,7 +1238,7 @@ public abstract class BaseResultIterators extends 
ExplainTable implements Result
 public List getIterators() throws SQLException {
 if (LOGGER.isDebugEnabled()) {
 LOGGER.debug(LogUtil.addCustomAnnotations("Getting iterators for " 
+ this,
-ScanUtil.getCustomAnnotations(scan)));
+ScanUtil.getCustomAnnotations(scan)) + "on table " + 
context.getCurrentTable().getTable().getName());
 }
 boolean isReverse = ScanUtil.isReversed(scan);
 boolean isLocalIndex = getTable().getIndexType() == IndexType.LOCAL;

[phoenix] branch 4.x-HBase-1.3 updated: PHOENIX-5633: Add table name info to scan logging

[chinmayskulkarni]

This is an automated email from the ASF dual-hosted git repository.

chinmayskulkarni pushed a commit to branch 4.x-HBase-1.3
in repository https://gitbox.apache.org/repos/asf/phoenix.git


The following commit(s) were added to refs/heads/4.x-HBase-1.3 by this push:
 new efd443b  PHOENIX-5633: Add table name info to scan logging
efd443b is described below

commit efd443b12ededa000e73a32545266c16058f3b31
Author: Christine Feng 
AuthorDate: Thu Jan 23 12:27:36 2020 -0800

PHOENIX-5633: Add table name info to scan logging

Signed-off-by: Chinmay Kulkarni 
---
 .../src/main/java/org/apache/phoenix/execute/BaseQueryPlan.java   | 4 ++--
 .../src/main/java/org/apache/phoenix/iterate/BaseResultIterators.java | 2 +-
 2 files changed, 3 insertions(+), 3 deletions(-)

diff --git 
a/phoenix-core/src/main/java/org/apache/phoenix/execute/BaseQueryPlan.java 
b/phoenix-core/src/main/java/org/apache/phoenix/execute/BaseQueryPlan.java
index caa60a0..89c5233 100644
--- a/phoenix-core/src/main/java/org/apache/phoenix/execute/BaseQueryPlan.java
+++ b/phoenix-core/src/main/java/org/apache/phoenix/execute/BaseQueryPlan.java
@@ -359,13 +359,13 @@ public abstract class BaseQueryPlan implements QueryPlan {
 
 if (LOGGER.isDebugEnabled()) {
 LOGGER.debug(LogUtil.addCustomAnnotations(
-   "Scan ready for iteration: " + scan, connection));
+"Scan on table " + 
context.getCurrentTable().getTable().getName() + " ready for iteration: " + 
scan, connection));
 }
 
 ResultIterator iterator =  newIterator(scanGrouper, scan, caches);
 if (LOGGER.isDebugEnabled()) {
 LOGGER.debug(LogUtil.addCustomAnnotations(
-   "Iterator ready: " + iterator, connection));
+"Iterator for table " + 
context.getCurrentTable().getTable().getName() + " ready: " + iterator, 
connection));
 }
 
 // wrap the iterator so we start/end tracing as we expect
diff --git 
a/phoenix-core/src/main/java/org/apache/phoenix/iterate/BaseResultIterators.java
 
b/phoenix-core/src/main/java/org/apache/phoenix/iterate/BaseResultIterators.java
index 2dcc88b..3d61236 100644
--- 
a/phoenix-core/src/main/java/org/apache/phoenix/iterate/BaseResultIterators.java
+++ 
b/phoenix-core/src/main/java/org/apache/phoenix/iterate/BaseResultIterators.java
@@ -1238,7 +1238,7 @@ public abstract class BaseResultIterators extends 
ExplainTable implements Result
 public List getIterators() throws SQLException {
 if (LOGGER.isDebugEnabled()) {
 LOGGER.debug(LogUtil.addCustomAnnotations("Getting iterators for " 
+ this,
-ScanUtil.getCustomAnnotations(scan)));
+ScanUtil.getCustomAnnotations(scan)) + "on table " + 
context.getCurrentTable().getTable().getName());
 }
 boolean isReverse = ScanUtil.isReversed(scan);
 boolean isLocalIndex = getTable().getIndexType() == IndexType.LOCAL;

Build failed in Jenkins: Phoenix | Master #2653

[Apache Jenkins Server]

See 


Changes:

[abhishek.chouhan] PHOENIX-5529 Creating a grand-child view on a table with an 
index fails


--
[...truncated 600.26 KB...]
[INFO] --- maven-source-plugin:3.0.1:jar-no-fork (attach-sources) @ 
phoenix-assembly ---
[INFO] 
[INFO] --- maven-jar-plugin:3.1.0:test-jar (default) @ phoenix-assembly ---
[INFO] Skipping packaging of the test-jar
[INFO] 
[INFO] --- maven-site-plugin:3.7.1:attach-descriptor (attach-descriptor) @ 
phoenix-assembly ---
[INFO] No site descriptor found: nothing to attach.
[INFO] 
[INFO] --- maven-assembly-plugin:3.0.0:single (package-to-tar) @ 
phoenix-assembly ---
[INFO] Reading assembly descriptor: src/build/package-to-tar-all.xml
[WARNING] The assembly descriptor contains a filesystem-root relative 
reference, which is not cross platform compatible /
[WARNING] The assembly descriptor contains a filesystem-root relative 
reference, which is not cross platform compatible /
[WARNING] The assembly descriptor contains a filesystem-root relative 
reference, which is not cross platform compatible /
[INFO] artifact net.minidev:json-smart: checking for updates from apache release
[INFO] artifact net.minidev:json-smart: checking for updates from central
[INFO] artifact net.minidev:json-smart: checking for updates from project.local
[INFO] artifact net.minidev:json-smart: checking for updates from 
dynamodb-local-oregon
[INFO] artifact net.minidev:json-smart: checking for updates from 
apache.snapshots.https
[INFO] artifact net.minidev:json-smart: checking for updates from 
repository.jboss.org
[INFO] artifact net.minidev:json-smart: checking for updates from apache release
[INFO] artifact net.minidev:json-smart: checking for updates from central
[INFO] artifact net.minidev:json-smart: checking for updates from project.local
[INFO] artifact net.minidev:json-smart: checking for updates from 
dynamodb-local-oregon
[INFO] artifact net.minidev:json-smart: checking for updates from 
apache.snapshots.https
[INFO] artifact net.minidev:json-smart: checking for updates from 
repository.jboss.org
[INFO] artifact org.glassfish:javax.el: checking for updates from apache release
[INFO] artifact org.glassfish:javax.el: checking for updates from central
[INFO] artifact org.glassfish:javax.el: checking for updates from project.local
[INFO] artifact org.glassfish:javax.el: checking for updates from 
java.net.Releases
[INFO] artifact net.minidev:json-smart: checking for updates from apache release
[INFO] artifact net.minidev:json-smart: checking for updates from central
[INFO] artifact net.minidev:json-smart: checking for updates from project.local
[INFO] artifact net.minidev:json-smart: checking for updates from 
dynamodb-local-oregon
[INFO] artifact net.minidev:json-smart: checking for updates from 
apache.snapshots.https
[INFO] artifact net.minidev:json-smart: checking for updates from 
repository.jboss.org
[INFO] artifact org.glassfish:javax.el: checking for updates from apache release
[INFO] artifact org.glassfish:javax.el: checking for updates from central
[INFO] artifact org.glassfish:javax.el: checking for updates from project.local
[INFO] artifact org.glassfish:javax.el: checking for updates from 
java.net.Releases
[INFO] artifact net.minidev:json-smart: checking for updates from apache release
[INFO] artifact net.minidev:json-smart: checking for updates from central
[INFO] artifact net.minidev:json-smart: checking for updates from project.local
[INFO] artifact net.minidev:json-smart: checking for updates from 
dynamodb-local-oregon
[INFO] artifact net.minidev:json-smart: checking for updates from 
apache.snapshots.https
[INFO] artifact net.minidev:json-smart: checking for updates from 
repository.jboss.org
[INFO] artifact net.minidev:json-smart: checking for updates from apache release
[INFO] artifact net.minidev:json-smart: checking for updates from central
[INFO] artifact net.minidev:json-smart: checking for updates from project.local
[INFO] artifact net.minidev:json-smart: checking for updates from 
dynamodb-local-oregon
[INFO] artifact net.minidev:json-smart: checking for updates from 
apache.snapshots.https
[INFO] artifact net.minidev:json-smart: checking for updates from 
repository.jboss.org
[INFO] artifact org.glassfish:javax.el: checking for updates from apache release
[INFO] artifact org.glassfish:javax.el: checking for updates from central
[INFO] artifact org.glassfish:javax.el: checking for updates from project.local
[INFO] artifact org.glassfish:javax.el: checking for updates from 
java.net.Releases
[INFO] artifact net.minidev:json-smart: checking for updates from apache release
[INFO] artifact net.minidev:json-smart: checking for updates from central
[INFO] artifact net.minidev:json-smart: checking for updates from project.local
[INFO] artifact net.minidev:json-smart: checking for updates from 
dynamodb-local-oregon
[INFO] artifact 

Apache Phoenix - Timeout crawler - Build https://builds.apache.org/job/Phoenix-master/2653/

[Apache Jenkins Server]

[...truncated 47 lines...]
Looking at the log, list of test(s) that timed-out:

Build:
https://builds.apache.org/job/Phoenix-master/2653/


Affected test class(es):
Set(['as SYSTEM'])


Build step 'Execute shell' marked build as failure
Email was triggered for: Failure - Any
Sending email for trigger: Failure - Any

[phoenix] branch 4.14-HBase-1.3 updated: PHOENIX-5529 Creating a grand-child view on a table with an index fails

[achouhan]

This is an automated email from the ASF dual-hosted git repository.

achouhan pushed a commit to branch 4.14-HBase-1.3
in repository https://gitbox.apache.org/repos/asf/phoenix.git


The following commit(s) were added to refs/heads/4.14-HBase-1.3 by this push:
 new 3a5926d  PHOENIX-5529 Creating a grand-child view on a table with an 
index fails
3a5926d is described below

commit 3a5926d74ff2d3d645a65fe1790a4bd6389fee28
Author: Abhishek Singh Chouhan 
AuthorDate: Fri Feb 14 10:45:15 2020 -0800

PHOENIX-5529 Creating a grand-child view on a table with an index fails
---
 .../it/java/org/apache/phoenix/end2end/ViewIT.java | 70 +-
 .../org/apache/phoenix/schema/MetaDataClient.java  |  2 +-
 2 files changed, 70 insertions(+), 2 deletions(-)

diff --git a/phoenix-core/src/it/java/org/apache/phoenix/end2end/ViewIT.java 
b/phoenix-core/src/it/java/org/apache/phoenix/end2end/ViewIT.java
index a6e066b..61c809b 100644
--- a/phoenix-core/src/it/java/org/apache/phoenix/end2end/ViewIT.java
+++ b/phoenix-core/src/it/java/org/apache/phoenix/end2end/ViewIT.java
@@ -47,6 +47,7 @@ import org.apache.phoenix.jdbc.PhoenixConnection;
 import org.apache.phoenix.query.KeyRange;
 import org.apache.phoenix.query.QueryServices;
 import org.apache.phoenix.schema.ColumnAlreadyExistsException;
+import org.apache.phoenix.schema.PTable;
 import org.apache.phoenix.schema.ReadOnlyTableException;
 import org.apache.phoenix.schema.TableNotFoundException;
 import org.apache.phoenix.util.PhoenixRuntime;
@@ -559,7 +560,74 @@ public class ViewIT extends BaseViewIT {
 "CLIENT PARALLEL 1-WAY SKIP SCAN ON 4 KEYS OVER " + 
fullIndexName1 + " [1,100] - [2,109]\n" + 
 "SERVER FILTER BY (\"S2\" = 'bas' AND \"S1\" = 
'foo')", queryPlan);
 }
-}
+}
+
+@Test
+public void testCreateChildViewWithBaseTableLocalIndex() throws Exception {
+testCreateChildViewWithBaseTableIndex(true);
+}
+
+@Test
+public void testCreateChildViewWithBaseTableGlobalIndex() throws Exception 
{
+testCreateChildViewWithBaseTableIndex(false);
+}
+
+public void testCreateChildViewWithBaseTableIndex(boolean localIndex) 
throws Exception {
+String schema1 = "S_" + generateUniqueName();
+String schema2 = "S_" + generateUniqueName();
+String fullTableName = SchemaUtil.getTableName(schema1, 
generateUniqueName());
+String fullViewName = SchemaUtil.getTableName(schema2, 
generateUniqueName());
+String indexName = "I_" + generateUniqueName();
+String fullChildViewName = SchemaUtil.getTableName(schema2, 
generateUniqueName());
+try (Connection conn = DriverManager.getConnection(getUrl())) {
+String sql =
+"CREATE TABLE " + fullTableName
++ " (ID INTEGER NOT NULL PRIMARY KEY, HOST 
VARCHAR(10), FLAG BOOLEAN)";
+conn.createStatement().execute(sql);
+sql =
+"CREATE VIEW " + fullViewName
++ " (COL1 INTEGER, COL2 INTEGER, COL3 INTEGER, 
COL4 INTEGER) AS SELECT * FROM "
++ fullTableName + " WHERE ID > 5";
+conn.createStatement().execute(sql);
+sql =
+"CREATE " + (localIndex ? "LOCAL " : "") + " INDEX " + 
indexName + " ON "
++ fullTableName + "(HOST)";
+conn.createStatement().execute(sql);
+sql =
+"CREATE VIEW " + fullChildViewName + " AS SELECT * FROM " 
+ fullViewName
++ " WHERE COL1 > 2";
+conn.createStatement().execute(sql);
+// Sanity upserts in baseTable, view, child view
+conn.createStatement()
+.executeUpdate("upsert into " + fullTableName + " values 
(1, 'host1', TRUE)");
+conn.createStatement()
+.executeUpdate("upsert into " + fullTableName + " values 
(5, 'host5', FALSE)");
+conn.createStatement()
+.executeUpdate("upsert into " + fullTableName + " values 
(7, 'host7', TRUE)");
+conn.commit();
+// View is not updateable
+try {
+conn.createStatement().executeUpdate("upsert into " + 
fullViewName
++ " (ID, HOST, FLAG, COL1) values (7, 'host7', TRUE, 
1)");
+fail();
+} catch (Exception e) {
+}
+// Check view inherits index, but child view doesn't
+PTable table = PhoenixRuntime.getTable(conn, fullViewName);
+assertEquals(1, table.getIndexes().size());
+table = PhoenixRuntime.getTable(conn, fullChildViewName);
+assertEquals(0, table.getIndexes().size());
+
+ResultSet rs =
+conn.createStatement().executeQuery("select count(*) from 
" + fullTableName);
+assertTrue(rs.next());

[phoenix] branch 4.14-HBase-1.4 updated: PHOENIX-5529 Creating a grand-child view on a table with an index fails

[achouhan]

This is an automated email from the ASF dual-hosted git repository.

achouhan pushed a commit to branch 4.14-HBase-1.4
in repository https://gitbox.apache.org/repos/asf/phoenix.git


The following commit(s) were added to refs/heads/4.14-HBase-1.4 by this push:
 new 3e8ddde  PHOENIX-5529 Creating a grand-child view on a table with an 
index fails
3e8ddde is described below

commit 3e8ddde696fb5b7ca006857e01ec7d471c163e05
Author: Abhishek Singh Chouhan 
AuthorDate: Fri Feb 14 10:45:15 2020 -0800

PHOENIX-5529 Creating a grand-child view on a table with an index fails
---
 .../it/java/org/apache/phoenix/end2end/ViewIT.java | 70 +-
 .../org/apache/phoenix/schema/MetaDataClient.java  |  2 +-
 2 files changed, 70 insertions(+), 2 deletions(-)

diff --git a/phoenix-core/src/it/java/org/apache/phoenix/end2end/ViewIT.java 
b/phoenix-core/src/it/java/org/apache/phoenix/end2end/ViewIT.java
index a6e066b..61c809b 100644
--- a/phoenix-core/src/it/java/org/apache/phoenix/end2end/ViewIT.java
+++ b/phoenix-core/src/it/java/org/apache/phoenix/end2end/ViewIT.java
@@ -47,6 +47,7 @@ import org.apache.phoenix.jdbc.PhoenixConnection;
 import org.apache.phoenix.query.KeyRange;
 import org.apache.phoenix.query.QueryServices;
 import org.apache.phoenix.schema.ColumnAlreadyExistsException;
+import org.apache.phoenix.schema.PTable;
 import org.apache.phoenix.schema.ReadOnlyTableException;
 import org.apache.phoenix.schema.TableNotFoundException;
 import org.apache.phoenix.util.PhoenixRuntime;
@@ -559,7 +560,74 @@ public class ViewIT extends BaseViewIT {
 "CLIENT PARALLEL 1-WAY SKIP SCAN ON 4 KEYS OVER " + 
fullIndexName1 + " [1,100] - [2,109]\n" + 
 "SERVER FILTER BY (\"S2\" = 'bas' AND \"S1\" = 
'foo')", queryPlan);
 }
-}
+}
+
+@Test
+public void testCreateChildViewWithBaseTableLocalIndex() throws Exception {
+testCreateChildViewWithBaseTableIndex(true);
+}
+
+@Test
+public void testCreateChildViewWithBaseTableGlobalIndex() throws Exception 
{
+testCreateChildViewWithBaseTableIndex(false);
+}
+
+public void testCreateChildViewWithBaseTableIndex(boolean localIndex) 
throws Exception {
+String schema1 = "S_" + generateUniqueName();
+String schema2 = "S_" + generateUniqueName();
+String fullTableName = SchemaUtil.getTableName(schema1, 
generateUniqueName());
+String fullViewName = SchemaUtil.getTableName(schema2, 
generateUniqueName());
+String indexName = "I_" + generateUniqueName();
+String fullChildViewName = SchemaUtil.getTableName(schema2, 
generateUniqueName());
+try (Connection conn = DriverManager.getConnection(getUrl())) {
+String sql =
+"CREATE TABLE " + fullTableName
++ " (ID INTEGER NOT NULL PRIMARY KEY, HOST 
VARCHAR(10), FLAG BOOLEAN)";
+conn.createStatement().execute(sql);
+sql =
+"CREATE VIEW " + fullViewName
++ " (COL1 INTEGER, COL2 INTEGER, COL3 INTEGER, 
COL4 INTEGER) AS SELECT * FROM "
++ fullTableName + " WHERE ID > 5";
+conn.createStatement().execute(sql);
+sql =
+"CREATE " + (localIndex ? "LOCAL " : "") + " INDEX " + 
indexName + " ON "
++ fullTableName + "(HOST)";
+conn.createStatement().execute(sql);
+sql =
+"CREATE VIEW " + fullChildViewName + " AS SELECT * FROM " 
+ fullViewName
++ " WHERE COL1 > 2";
+conn.createStatement().execute(sql);
+// Sanity upserts in baseTable, view, child view
+conn.createStatement()
+.executeUpdate("upsert into " + fullTableName + " values 
(1, 'host1', TRUE)");
+conn.createStatement()
+.executeUpdate("upsert into " + fullTableName + " values 
(5, 'host5', FALSE)");
+conn.createStatement()
+.executeUpdate("upsert into " + fullTableName + " values 
(7, 'host7', TRUE)");
+conn.commit();
+// View is not updateable
+try {
+conn.createStatement().executeUpdate("upsert into " + 
fullViewName
++ " (ID, HOST, FLAG, COL1) values (7, 'host7', TRUE, 
1)");
+fail();
+} catch (Exception e) {
+}
+// Check view inherits index, but child view doesn't
+PTable table = PhoenixRuntime.getTable(conn, fullViewName);
+assertEquals(1, table.getIndexes().size());
+table = PhoenixRuntime.getTable(conn, fullChildViewName);
+assertEquals(0, table.getIndexes().size());
+
+ResultSet rs =
+conn.createStatement().executeQuery("select count(*) from 
" + fullTableName);
+assertTrue(rs.next());

[phoenix] branch 4.15-HBase-1.3 updated: PHOENIX-5529 Creating a grand-child view on a table with an index fails

[achouhan]

This is an automated email from the ASF dual-hosted git repository.

achouhan pushed a commit to branch 4.15-HBase-1.3
in repository https://gitbox.apache.org/repos/asf/phoenix.git


The following commit(s) were added to refs/heads/4.15-HBase-1.3 by this push:
 new 16f6a46  PHOENIX-5529 Creating a grand-child view on a table with an 
index fails
16f6a46 is described below

commit 16f6a46c19bc9b131697cc5abec73faffc62af18
Author: Abhishek Singh Chouhan 
AuthorDate: Tue Feb 11 11:31:06 2020 -0800

PHOENIX-5529 Creating a grand-child view on a table with an index fails
---
 .../it/java/org/apache/phoenix/end2end/ViewIT.java | 67 +-
 .../java/org/apache/phoenix/util/ViewUtil.java |  2 +-
 2 files changed, 67 insertions(+), 2 deletions(-)

diff --git a/phoenix-core/src/it/java/org/apache/phoenix/end2end/ViewIT.java 
b/phoenix-core/src/it/java/org/apache/phoenix/end2end/ViewIT.java
index aeec7f0..c962740 100644
--- a/phoenix-core/src/it/java/org/apache/phoenix/end2end/ViewIT.java
+++ b/phoenix-core/src/it/java/org/apache/phoenix/end2end/ViewIT.java
@@ -410,7 +410,72 @@ public class ViewIT extends SplitSystemCatalogIT {
 "CLIENT PARALLEL 1-WAY SKIP SCAN ON 4 KEYS OVER " + 
fullIndexName1 + " [1,100] - [2,109]\n" + 
 "SERVER FILTER BY (\"S2\" = 'bas' AND \"S1\" = 
'foo')", queryPlan);
 }
-}
+}
+
+@Test
+public void testCreateChildViewWithBaseTableLocalIndex() throws Exception {
+testCreateChildViewWithBaseTableIndex(true);
+}
+
+@Test
+public void testCreateChildViewWithBaseTableGlobalIndex() throws Exception 
{
+testCreateChildViewWithBaseTableIndex(false);
+}
+
+public void testCreateChildViewWithBaseTableIndex(boolean localIndex) 
throws Exception {
+String fullTableName = SchemaUtil.getTableName(SCHEMA1, 
generateUniqueName());
+String fullViewName = SchemaUtil.getTableName(SCHEMA2, 
generateUniqueName());
+String indexName = "I_" + generateUniqueName();
+String fullChildViewName = SchemaUtil.getTableName(SCHEMA2, 
generateUniqueName());
+try (Connection conn = DriverManager.getConnection(getUrl())) {
+String sql =
+"CREATE TABLE " + fullTableName
++ " (ID INTEGER NOT NULL PRIMARY KEY, HOST 
VARCHAR(10), FLAG BOOLEAN)";
+conn.createStatement().execute(sql);
+sql =
+"CREATE VIEW " + fullViewName
++ " (COL1 INTEGER, COL2 INTEGER, COL3 INTEGER, 
COL4 INTEGER) AS SELECT * FROM "
++ fullTableName + " WHERE ID > 5";
+conn.createStatement().execute(sql);
+sql =
+"CREATE " + (localIndex ? "LOCAL " : "") + " INDEX " + 
indexName + " ON "
++ fullTableName + "(HOST)";
+conn.createStatement().execute(sql);
+sql =
+"CREATE VIEW " + fullChildViewName + " AS SELECT * FROM " 
+ fullViewName
++ " WHERE COL1 > 2";
+conn.createStatement().execute(sql);
+// Sanity upserts in baseTable, view, child view
+conn.createStatement()
+.executeUpdate("upsert into " + fullTableName + " values 
(1, 'host1', TRUE)");
+conn.createStatement()
+.executeUpdate("upsert into " + fullTableName + " values 
(5, 'host5', FALSE)");
+conn.createStatement()
+.executeUpdate("upsert into " + fullTableName + " values 
(7, 'host7', TRUE)");
+conn.commit();
+// View is not updateable
+try {
+conn.createStatement().executeUpdate("upsert into " + 
fullViewName
++ " (ID, HOST, FLAG, COL1) values (7, 'host7', TRUE, 
1)");
+fail();
+} catch (Exception e) {
+}
+// Check view inherits index, but child view doesn't
+PTable table = PhoenixRuntime.getTable(conn, fullViewName);
+assertEquals(1, table.getIndexes().size());
+table = PhoenixRuntime.getTable(conn, fullChildViewName);
+assertEquals(0, table.getIndexes().size());
+
+ResultSet rs =
+conn.createStatement().executeQuery("select count(*) from 
" + fullTableName);
+assertTrue(rs.next());
+assertEquals(3, rs.getInt(1));
+
+rs = conn.createStatement().executeQuery("select count(*) from " + 
fullViewName);
+assertTrue(rs.next());
+assertEquals(1, rs.getInt(1));
+}
+}
 
 @Test
 public void testCreateViewDefinesPKColumn() throws Exception {
diff --git a/phoenix-core/src/main/java/org/apache/phoenix/util/ViewUtil.java 
b/phoenix-core/src/main/java/org/apache/phoenix/util/ViewUtil.java
index d08a9d9..a1f5718 100644
--- 

[phoenix] branch 4.15-HBase-1.4 updated: PHOENIX-5529 Creating a grand-child view on a table with an index fails

[achouhan]

This is an automated email from the ASF dual-hosted git repository.

achouhan pushed a commit to branch 4.15-HBase-1.4
in repository https://gitbox.apache.org/repos/asf/phoenix.git


The following commit(s) were added to refs/heads/4.15-HBase-1.4 by this push:
 new 23ae709  PHOENIX-5529 Creating a grand-child view on a table with an 
index fails
23ae709 is described below

commit 23ae7096d0dd49215b3281e4c531b529ecaef8c5
Author: Abhishek Singh Chouhan 
AuthorDate: Tue Feb 11 11:31:06 2020 -0800

PHOENIX-5529 Creating a grand-child view on a table with an index fails
---
 .../it/java/org/apache/phoenix/end2end/ViewIT.java | 67 +-
 .../java/org/apache/phoenix/util/ViewUtil.java |  2 +-
 2 files changed, 67 insertions(+), 2 deletions(-)

diff --git a/phoenix-core/src/it/java/org/apache/phoenix/end2end/ViewIT.java 
b/phoenix-core/src/it/java/org/apache/phoenix/end2end/ViewIT.java
index aeec7f0..c962740 100644
--- a/phoenix-core/src/it/java/org/apache/phoenix/end2end/ViewIT.java
+++ b/phoenix-core/src/it/java/org/apache/phoenix/end2end/ViewIT.java
@@ -410,7 +410,72 @@ public class ViewIT extends SplitSystemCatalogIT {
 "CLIENT PARALLEL 1-WAY SKIP SCAN ON 4 KEYS OVER " + 
fullIndexName1 + " [1,100] - [2,109]\n" + 
 "SERVER FILTER BY (\"S2\" = 'bas' AND \"S1\" = 
'foo')", queryPlan);
 }
-}
+}
+
+@Test
+public void testCreateChildViewWithBaseTableLocalIndex() throws Exception {
+testCreateChildViewWithBaseTableIndex(true);
+}
+
+@Test
+public void testCreateChildViewWithBaseTableGlobalIndex() throws Exception 
{
+testCreateChildViewWithBaseTableIndex(false);
+}
+
+public void testCreateChildViewWithBaseTableIndex(boolean localIndex) 
throws Exception {
+String fullTableName = SchemaUtil.getTableName(SCHEMA1, 
generateUniqueName());
+String fullViewName = SchemaUtil.getTableName(SCHEMA2, 
generateUniqueName());
+String indexName = "I_" + generateUniqueName();
+String fullChildViewName = SchemaUtil.getTableName(SCHEMA2, 
generateUniqueName());
+try (Connection conn = DriverManager.getConnection(getUrl())) {
+String sql =
+"CREATE TABLE " + fullTableName
++ " (ID INTEGER NOT NULL PRIMARY KEY, HOST 
VARCHAR(10), FLAG BOOLEAN)";
+conn.createStatement().execute(sql);
+sql =
+"CREATE VIEW " + fullViewName
++ " (COL1 INTEGER, COL2 INTEGER, COL3 INTEGER, 
COL4 INTEGER) AS SELECT * FROM "
++ fullTableName + " WHERE ID > 5";
+conn.createStatement().execute(sql);
+sql =
+"CREATE " + (localIndex ? "LOCAL " : "") + " INDEX " + 
indexName + " ON "
++ fullTableName + "(HOST)";
+conn.createStatement().execute(sql);
+sql =
+"CREATE VIEW " + fullChildViewName + " AS SELECT * FROM " 
+ fullViewName
++ " WHERE COL1 > 2";
+conn.createStatement().execute(sql);
+// Sanity upserts in baseTable, view, child view
+conn.createStatement()
+.executeUpdate("upsert into " + fullTableName + " values 
(1, 'host1', TRUE)");
+conn.createStatement()
+.executeUpdate("upsert into " + fullTableName + " values 
(5, 'host5', FALSE)");
+conn.createStatement()
+.executeUpdate("upsert into " + fullTableName + " values 
(7, 'host7', TRUE)");
+conn.commit();
+// View is not updateable
+try {
+conn.createStatement().executeUpdate("upsert into " + 
fullViewName
++ " (ID, HOST, FLAG, COL1) values (7, 'host7', TRUE, 
1)");
+fail();
+} catch (Exception e) {
+}
+// Check view inherits index, but child view doesn't
+PTable table = PhoenixRuntime.getTable(conn, fullViewName);
+assertEquals(1, table.getIndexes().size());
+table = PhoenixRuntime.getTable(conn, fullChildViewName);
+assertEquals(0, table.getIndexes().size());
+
+ResultSet rs =
+conn.createStatement().executeQuery("select count(*) from 
" + fullTableName);
+assertTrue(rs.next());
+assertEquals(3, rs.getInt(1));
+
+rs = conn.createStatement().executeQuery("select count(*) from " + 
fullViewName);
+assertTrue(rs.next());
+assertEquals(1, rs.getInt(1));
+}
+}
 
 @Test
 public void testCreateViewDefinesPKColumn() throws Exception {
diff --git a/phoenix-core/src/main/java/org/apache/phoenix/util/ViewUtil.java 
b/phoenix-core/src/main/java/org/apache/phoenix/util/ViewUtil.java
index d08a9d9..a1f5718 100644
--- 

[phoenix] branch 4.15-HBase-1.5 updated: PHOENIX-5529 Creating a grand-child view on a table with an index fails

[achouhan]

This is an automated email from the ASF dual-hosted git repository.

achouhan pushed a commit to branch 4.15-HBase-1.5
in repository https://gitbox.apache.org/repos/asf/phoenix.git


The following commit(s) were added to refs/heads/4.15-HBase-1.5 by this push:
 new 8fb692c  PHOENIX-5529 Creating a grand-child view on a table with an 
index fails
8fb692c is described below

commit 8fb692c04cffaedb67d4588f8eb63312743651d6
Author: Abhishek Singh Chouhan 
AuthorDate: Tue Feb 11 11:31:06 2020 -0800

PHOENIX-5529 Creating a grand-child view on a table with an index fails
---
 .../it/java/org/apache/phoenix/end2end/ViewIT.java | 67 +-
 .../java/org/apache/phoenix/util/ViewUtil.java |  2 +-
 2 files changed, 67 insertions(+), 2 deletions(-)

diff --git a/phoenix-core/src/it/java/org/apache/phoenix/end2end/ViewIT.java 
b/phoenix-core/src/it/java/org/apache/phoenix/end2end/ViewIT.java
index aeec7f0..c962740 100644
--- a/phoenix-core/src/it/java/org/apache/phoenix/end2end/ViewIT.java
+++ b/phoenix-core/src/it/java/org/apache/phoenix/end2end/ViewIT.java
@@ -410,7 +410,72 @@ public class ViewIT extends SplitSystemCatalogIT {
 "CLIENT PARALLEL 1-WAY SKIP SCAN ON 4 KEYS OVER " + 
fullIndexName1 + " [1,100] - [2,109]\n" + 
 "SERVER FILTER BY (\"S2\" = 'bas' AND \"S1\" = 
'foo')", queryPlan);
 }
-}
+}
+
+@Test
+public void testCreateChildViewWithBaseTableLocalIndex() throws Exception {
+testCreateChildViewWithBaseTableIndex(true);
+}
+
+@Test
+public void testCreateChildViewWithBaseTableGlobalIndex() throws Exception 
{
+testCreateChildViewWithBaseTableIndex(false);
+}
+
+public void testCreateChildViewWithBaseTableIndex(boolean localIndex) 
throws Exception {
+String fullTableName = SchemaUtil.getTableName(SCHEMA1, 
generateUniqueName());
+String fullViewName = SchemaUtil.getTableName(SCHEMA2, 
generateUniqueName());
+String indexName = "I_" + generateUniqueName();
+String fullChildViewName = SchemaUtil.getTableName(SCHEMA2, 
generateUniqueName());
+try (Connection conn = DriverManager.getConnection(getUrl())) {
+String sql =
+"CREATE TABLE " + fullTableName
++ " (ID INTEGER NOT NULL PRIMARY KEY, HOST 
VARCHAR(10), FLAG BOOLEAN)";
+conn.createStatement().execute(sql);
+sql =
+"CREATE VIEW " + fullViewName
++ " (COL1 INTEGER, COL2 INTEGER, COL3 INTEGER, 
COL4 INTEGER) AS SELECT * FROM "
++ fullTableName + " WHERE ID > 5";
+conn.createStatement().execute(sql);
+sql =
+"CREATE " + (localIndex ? "LOCAL " : "") + " INDEX " + 
indexName + " ON "
++ fullTableName + "(HOST)";
+conn.createStatement().execute(sql);
+sql =
+"CREATE VIEW " + fullChildViewName + " AS SELECT * FROM " 
+ fullViewName
++ " WHERE COL1 > 2";
+conn.createStatement().execute(sql);
+// Sanity upserts in baseTable, view, child view
+conn.createStatement()
+.executeUpdate("upsert into " + fullTableName + " values 
(1, 'host1', TRUE)");
+conn.createStatement()
+.executeUpdate("upsert into " + fullTableName + " values 
(5, 'host5', FALSE)");
+conn.createStatement()
+.executeUpdate("upsert into " + fullTableName + " values 
(7, 'host7', TRUE)");
+conn.commit();
+// View is not updateable
+try {
+conn.createStatement().executeUpdate("upsert into " + 
fullViewName
++ " (ID, HOST, FLAG, COL1) values (7, 'host7', TRUE, 
1)");
+fail();
+} catch (Exception e) {
+}
+// Check view inherits index, but child view doesn't
+PTable table = PhoenixRuntime.getTable(conn, fullViewName);
+assertEquals(1, table.getIndexes().size());
+table = PhoenixRuntime.getTable(conn, fullChildViewName);
+assertEquals(0, table.getIndexes().size());
+
+ResultSet rs =
+conn.createStatement().executeQuery("select count(*) from 
" + fullTableName);
+assertTrue(rs.next());
+assertEquals(3, rs.getInt(1));
+
+rs = conn.createStatement().executeQuery("select count(*) from " + 
fullViewName);
+assertTrue(rs.next());
+assertEquals(1, rs.getInt(1));
+}
+}
 
 @Test
 public void testCreateViewDefinesPKColumn() throws Exception {
diff --git a/phoenix-core/src/main/java/org/apache/phoenix/util/ViewUtil.java 
b/phoenix-core/src/main/java/org/apache/phoenix/util/ViewUtil.java
index d08a9d9..a1f5718 100644
--- 

[phoenix] branch 4.x-HBase-1.3 updated: PHOENIX-5529 Creating a grand-child view on a table with an index fails

[achouhan]

This is an automated email from the ASF dual-hosted git repository.

achouhan pushed a commit to branch 4.x-HBase-1.3
in repository https://gitbox.apache.org/repos/asf/phoenix.git


The following commit(s) were added to refs/heads/4.x-HBase-1.3 by this push:
 new 9792ed0  PHOENIX-5529 Creating a grand-child view on a table with an 
index fails
9792ed0 is described below

commit 9792ed0943dfaf1ba4bc1f518f3ab996476e9515
Author: Abhishek Singh Chouhan 
AuthorDate: Tue Feb 11 11:31:06 2020 -0800

PHOENIX-5529 Creating a grand-child view on a table with an index fails
---
 .../it/java/org/apache/phoenix/end2end/ViewIT.java | 67 +-
 .../java/org/apache/phoenix/util/ViewUtil.java |  2 +-
 2 files changed, 67 insertions(+), 2 deletions(-)

diff --git a/phoenix-core/src/it/java/org/apache/phoenix/end2end/ViewIT.java 
b/phoenix-core/src/it/java/org/apache/phoenix/end2end/ViewIT.java
index aeec7f0..c962740 100644
--- a/phoenix-core/src/it/java/org/apache/phoenix/end2end/ViewIT.java
+++ b/phoenix-core/src/it/java/org/apache/phoenix/end2end/ViewIT.java
@@ -410,7 +410,72 @@ public class ViewIT extends SplitSystemCatalogIT {
 "CLIENT PARALLEL 1-WAY SKIP SCAN ON 4 KEYS OVER " + 
fullIndexName1 + " [1,100] - [2,109]\n" + 
 "SERVER FILTER BY (\"S2\" = 'bas' AND \"S1\" = 
'foo')", queryPlan);
 }
-}
+}
+
+@Test
+public void testCreateChildViewWithBaseTableLocalIndex() throws Exception {
+testCreateChildViewWithBaseTableIndex(true);
+}
+
+@Test
+public void testCreateChildViewWithBaseTableGlobalIndex() throws Exception 
{
+testCreateChildViewWithBaseTableIndex(false);
+}
+
+public void testCreateChildViewWithBaseTableIndex(boolean localIndex) 
throws Exception {
+String fullTableName = SchemaUtil.getTableName(SCHEMA1, 
generateUniqueName());
+String fullViewName = SchemaUtil.getTableName(SCHEMA2, 
generateUniqueName());
+String indexName = "I_" + generateUniqueName();
+String fullChildViewName = SchemaUtil.getTableName(SCHEMA2, 
generateUniqueName());
+try (Connection conn = DriverManager.getConnection(getUrl())) {
+String sql =
+"CREATE TABLE " + fullTableName
++ " (ID INTEGER NOT NULL PRIMARY KEY, HOST 
VARCHAR(10), FLAG BOOLEAN)";
+conn.createStatement().execute(sql);
+sql =
+"CREATE VIEW " + fullViewName
++ " (COL1 INTEGER, COL2 INTEGER, COL3 INTEGER, 
COL4 INTEGER) AS SELECT * FROM "
++ fullTableName + " WHERE ID > 5";
+conn.createStatement().execute(sql);
+sql =
+"CREATE " + (localIndex ? "LOCAL " : "") + " INDEX " + 
indexName + " ON "
++ fullTableName + "(HOST)";
+conn.createStatement().execute(sql);
+sql =
+"CREATE VIEW " + fullChildViewName + " AS SELECT * FROM " 
+ fullViewName
++ " WHERE COL1 > 2";
+conn.createStatement().execute(sql);
+// Sanity upserts in baseTable, view, child view
+conn.createStatement()
+.executeUpdate("upsert into " + fullTableName + " values 
(1, 'host1', TRUE)");
+conn.createStatement()
+.executeUpdate("upsert into " + fullTableName + " values 
(5, 'host5', FALSE)");
+conn.createStatement()
+.executeUpdate("upsert into " + fullTableName + " values 
(7, 'host7', TRUE)");
+conn.commit();
+// View is not updateable
+try {
+conn.createStatement().executeUpdate("upsert into " + 
fullViewName
++ " (ID, HOST, FLAG, COL1) values (7, 'host7', TRUE, 
1)");
+fail();
+} catch (Exception e) {
+}
+// Check view inherits index, but child view doesn't
+PTable table = PhoenixRuntime.getTable(conn, fullViewName);
+assertEquals(1, table.getIndexes().size());
+table = PhoenixRuntime.getTable(conn, fullChildViewName);
+assertEquals(0, table.getIndexes().size());
+
+ResultSet rs =
+conn.createStatement().executeQuery("select count(*) from 
" + fullTableName);
+assertTrue(rs.next());
+assertEquals(3, rs.getInt(1));
+
+rs = conn.createStatement().executeQuery("select count(*) from " + 
fullViewName);
+assertTrue(rs.next());
+assertEquals(1, rs.getInt(1));
+}
+}
 
 @Test
 public void testCreateViewDefinesPKColumn() throws Exception {
diff --git a/phoenix-core/src/main/java/org/apache/phoenix/util/ViewUtil.java 
b/phoenix-core/src/main/java/org/apache/phoenix/util/ViewUtil.java
index 22e3a40..7e622b5 100644
--- 

[phoenix] branch 4.x-HBase-1.5 updated: PHOENIX-5529 Creating a grand-child view on a table with an index fails

[achouhan]

This is an automated email from the ASF dual-hosted git repository.

achouhan pushed a commit to branch 4.x-HBase-1.5
in repository https://gitbox.apache.org/repos/asf/phoenix.git


The following commit(s) were added to refs/heads/4.x-HBase-1.5 by this push:
 new c891ca9  PHOENIX-5529 Creating a grand-child view on a table with an 
index fails
c891ca9 is described below

commit c891ca97acd3bdc4534234e9a944e60fdc1fd0d0
Author: Abhishek Singh Chouhan 
AuthorDate: Tue Feb 11 11:31:06 2020 -0800

PHOENIX-5529 Creating a grand-child view on a table with an index fails
---
 .../it/java/org/apache/phoenix/end2end/ViewIT.java | 67 +-
 .../java/org/apache/phoenix/util/ViewUtil.java |  2 +-
 2 files changed, 67 insertions(+), 2 deletions(-)

diff --git a/phoenix-core/src/it/java/org/apache/phoenix/end2end/ViewIT.java 
b/phoenix-core/src/it/java/org/apache/phoenix/end2end/ViewIT.java
index aeec7f0..c962740 100644
--- a/phoenix-core/src/it/java/org/apache/phoenix/end2end/ViewIT.java
+++ b/phoenix-core/src/it/java/org/apache/phoenix/end2end/ViewIT.java
@@ -410,7 +410,72 @@ public class ViewIT extends SplitSystemCatalogIT {
 "CLIENT PARALLEL 1-WAY SKIP SCAN ON 4 KEYS OVER " + 
fullIndexName1 + " [1,100] - [2,109]\n" + 
 "SERVER FILTER BY (\"S2\" = 'bas' AND \"S1\" = 
'foo')", queryPlan);
 }
-}
+}
+
+@Test
+public void testCreateChildViewWithBaseTableLocalIndex() throws Exception {
+testCreateChildViewWithBaseTableIndex(true);
+}
+
+@Test
+public void testCreateChildViewWithBaseTableGlobalIndex() throws Exception 
{
+testCreateChildViewWithBaseTableIndex(false);
+}
+
+public void testCreateChildViewWithBaseTableIndex(boolean localIndex) 
throws Exception {
+String fullTableName = SchemaUtil.getTableName(SCHEMA1, 
generateUniqueName());
+String fullViewName = SchemaUtil.getTableName(SCHEMA2, 
generateUniqueName());
+String indexName = "I_" + generateUniqueName();
+String fullChildViewName = SchemaUtil.getTableName(SCHEMA2, 
generateUniqueName());
+try (Connection conn = DriverManager.getConnection(getUrl())) {
+String sql =
+"CREATE TABLE " + fullTableName
++ " (ID INTEGER NOT NULL PRIMARY KEY, HOST 
VARCHAR(10), FLAG BOOLEAN)";
+conn.createStatement().execute(sql);
+sql =
+"CREATE VIEW " + fullViewName
++ " (COL1 INTEGER, COL2 INTEGER, COL3 INTEGER, 
COL4 INTEGER) AS SELECT * FROM "
++ fullTableName + " WHERE ID > 5";
+conn.createStatement().execute(sql);
+sql =
+"CREATE " + (localIndex ? "LOCAL " : "") + " INDEX " + 
indexName + " ON "
++ fullTableName + "(HOST)";
+conn.createStatement().execute(sql);
+sql =
+"CREATE VIEW " + fullChildViewName + " AS SELECT * FROM " 
+ fullViewName
++ " WHERE COL1 > 2";
+conn.createStatement().execute(sql);
+// Sanity upserts in baseTable, view, child view
+conn.createStatement()
+.executeUpdate("upsert into " + fullTableName + " values 
(1, 'host1', TRUE)");
+conn.createStatement()
+.executeUpdate("upsert into " + fullTableName + " values 
(5, 'host5', FALSE)");
+conn.createStatement()
+.executeUpdate("upsert into " + fullTableName + " values 
(7, 'host7', TRUE)");
+conn.commit();
+// View is not updateable
+try {
+conn.createStatement().executeUpdate("upsert into " + 
fullViewName
++ " (ID, HOST, FLAG, COL1) values (7, 'host7', TRUE, 
1)");
+fail();
+} catch (Exception e) {
+}
+// Check view inherits index, but child view doesn't
+PTable table = PhoenixRuntime.getTable(conn, fullViewName);
+assertEquals(1, table.getIndexes().size());
+table = PhoenixRuntime.getTable(conn, fullChildViewName);
+assertEquals(0, table.getIndexes().size());
+
+ResultSet rs =
+conn.createStatement().executeQuery("select count(*) from 
" + fullTableName);
+assertTrue(rs.next());
+assertEquals(3, rs.getInt(1));
+
+rs = conn.createStatement().executeQuery("select count(*) from " + 
fullViewName);
+assertTrue(rs.next());
+assertEquals(1, rs.getInt(1));
+}
+}
 
 @Test
 public void testCreateViewDefinesPKColumn() throws Exception {
diff --git a/phoenix-core/src/main/java/org/apache/phoenix/util/ViewUtil.java 
b/phoenix-core/src/main/java/org/apache/phoenix/util/ViewUtil.java
index 22e3a40..7e622b5 100644
--- 

[phoenix] branch 4.x-HBase-1.4 updated: PHOENIX-5529 Creating a grand-child view on a table with an index fails

[achouhan]

This is an automated email from the ASF dual-hosted git repository.

achouhan pushed a commit to branch 4.x-HBase-1.4
in repository https://gitbox.apache.org/repos/asf/phoenix.git


The following commit(s) were added to refs/heads/4.x-HBase-1.4 by this push:
 new 5064ff0  PHOENIX-5529 Creating a grand-child view on a table with an 
index fails
5064ff0 is described below

commit 5064ff0d1924c49c8fe3fd84fb15d55360602a4d
Author: Abhishek Singh Chouhan 
AuthorDate: Tue Feb 11 11:31:06 2020 -0800

PHOENIX-5529 Creating a grand-child view on a table with an index fails
---
 .../it/java/org/apache/phoenix/end2end/ViewIT.java | 67 +-
 .../java/org/apache/phoenix/util/ViewUtil.java |  2 +-
 2 files changed, 67 insertions(+), 2 deletions(-)

diff --git a/phoenix-core/src/it/java/org/apache/phoenix/end2end/ViewIT.java 
b/phoenix-core/src/it/java/org/apache/phoenix/end2end/ViewIT.java
index aeec7f0..c962740 100644
--- a/phoenix-core/src/it/java/org/apache/phoenix/end2end/ViewIT.java
+++ b/phoenix-core/src/it/java/org/apache/phoenix/end2end/ViewIT.java
@@ -410,7 +410,72 @@ public class ViewIT extends SplitSystemCatalogIT {
 "CLIENT PARALLEL 1-WAY SKIP SCAN ON 4 KEYS OVER " + 
fullIndexName1 + " [1,100] - [2,109]\n" + 
 "SERVER FILTER BY (\"S2\" = 'bas' AND \"S1\" = 
'foo')", queryPlan);
 }
-}
+}
+
+@Test
+public void testCreateChildViewWithBaseTableLocalIndex() throws Exception {
+testCreateChildViewWithBaseTableIndex(true);
+}
+
+@Test
+public void testCreateChildViewWithBaseTableGlobalIndex() throws Exception 
{
+testCreateChildViewWithBaseTableIndex(false);
+}
+
+public void testCreateChildViewWithBaseTableIndex(boolean localIndex) 
throws Exception {
+String fullTableName = SchemaUtil.getTableName(SCHEMA1, 
generateUniqueName());
+String fullViewName = SchemaUtil.getTableName(SCHEMA2, 
generateUniqueName());
+String indexName = "I_" + generateUniqueName();
+String fullChildViewName = SchemaUtil.getTableName(SCHEMA2, 
generateUniqueName());
+try (Connection conn = DriverManager.getConnection(getUrl())) {
+String sql =
+"CREATE TABLE " + fullTableName
++ " (ID INTEGER NOT NULL PRIMARY KEY, HOST 
VARCHAR(10), FLAG BOOLEAN)";
+conn.createStatement().execute(sql);
+sql =
+"CREATE VIEW " + fullViewName
++ " (COL1 INTEGER, COL2 INTEGER, COL3 INTEGER, 
COL4 INTEGER) AS SELECT * FROM "
++ fullTableName + " WHERE ID > 5";
+conn.createStatement().execute(sql);
+sql =
+"CREATE " + (localIndex ? "LOCAL " : "") + " INDEX " + 
indexName + " ON "
++ fullTableName + "(HOST)";
+conn.createStatement().execute(sql);
+sql =
+"CREATE VIEW " + fullChildViewName + " AS SELECT * FROM " 
+ fullViewName
++ " WHERE COL1 > 2";
+conn.createStatement().execute(sql);
+// Sanity upserts in baseTable, view, child view
+conn.createStatement()
+.executeUpdate("upsert into " + fullTableName + " values 
(1, 'host1', TRUE)");
+conn.createStatement()
+.executeUpdate("upsert into " + fullTableName + " values 
(5, 'host5', FALSE)");
+conn.createStatement()
+.executeUpdate("upsert into " + fullTableName + " values 
(7, 'host7', TRUE)");
+conn.commit();
+// View is not updateable
+try {
+conn.createStatement().executeUpdate("upsert into " + 
fullViewName
++ " (ID, HOST, FLAG, COL1) values (7, 'host7', TRUE, 
1)");
+fail();
+} catch (Exception e) {
+}
+// Check view inherits index, but child view doesn't
+PTable table = PhoenixRuntime.getTable(conn, fullViewName);
+assertEquals(1, table.getIndexes().size());
+table = PhoenixRuntime.getTable(conn, fullChildViewName);
+assertEquals(0, table.getIndexes().size());
+
+ResultSet rs =
+conn.createStatement().executeQuery("select count(*) from 
" + fullTableName);
+assertTrue(rs.next());
+assertEquals(3, rs.getInt(1));
+
+rs = conn.createStatement().executeQuery("select count(*) from " + 
fullViewName);
+assertTrue(rs.next());
+assertEquals(1, rs.getInt(1));
+}
+}
 
 @Test
 public void testCreateViewDefinesPKColumn() throws Exception {
diff --git a/phoenix-core/src/main/java/org/apache/phoenix/util/ViewUtil.java 
b/phoenix-core/src/main/java/org/apache/phoenix/util/ViewUtil.java
index 22e3a40..7e622b5 100644
--- 

[phoenix] branch master updated: PHOENIX-5529 Creating a grand-child view on a table with an index fails

[achouhan]

This is an automated email from the ASF dual-hosted git repository.

achouhan pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/phoenix.git


The following commit(s) were added to refs/heads/master by this push:
 new cf51c60  PHOENIX-5529 Creating a grand-child view on a table with an 
index fails
cf51c60 is described below

commit cf51c60bbf2e06e22d05af5a8e66d2ce43ca21f2
Author: Abhishek Singh Chouhan 
AuthorDate: Tue Feb 11 11:31:06 2020 -0800

PHOENIX-5529 Creating a grand-child view on a table with an index fails
---
 .../it/java/org/apache/phoenix/end2end/ViewIT.java | 67 +-
 .../java/org/apache/phoenix/util/ViewUtil.java |  2 +-
 2 files changed, 67 insertions(+), 2 deletions(-)

diff --git a/phoenix-core/src/it/java/org/apache/phoenix/end2end/ViewIT.java 
b/phoenix-core/src/it/java/org/apache/phoenix/end2end/ViewIT.java
index 1ee3dd7..bea5aa3 100644
--- a/phoenix-core/src/it/java/org/apache/phoenix/end2end/ViewIT.java
+++ b/phoenix-core/src/it/java/org/apache/phoenix/end2end/ViewIT.java
@@ -420,7 +420,72 @@ public class ViewIT extends SplitSystemCatalogIT {
 "CLIENT PARALLEL 1-WAY SKIP SCAN ON 4 KEYS OVER " + 
fullIndexName1 + " [1,100] - [2,109]\n" + 
 "SERVER FILTER BY (\"S2\" = 'bas' AND \"S1\" = 
'foo')", queryPlan);
 }
-}
+}
+
+@Test
+public void testCreateChildViewWithBaseTableLocalIndex() throws Exception {
+testCreateChildViewWithBaseTableIndex(true);
+}
+
+@Test
+public void testCreateChildViewWithBaseTableGlobalIndex() throws Exception 
{
+testCreateChildViewWithBaseTableIndex(false);
+}
+
+public void testCreateChildViewWithBaseTableIndex(boolean localIndex) 
throws Exception {
+String fullTableName = SchemaUtil.getTableName(SCHEMA1, 
generateUniqueName());
+String fullViewName = SchemaUtil.getTableName(SCHEMA2, 
generateUniqueName());
+String indexName = "I_" + generateUniqueName();
+String fullChildViewName = SchemaUtil.getTableName(SCHEMA2, 
generateUniqueName());
+try (Connection conn = DriverManager.getConnection(getUrl())) {
+String sql =
+"CREATE TABLE " + fullTableName
++ " (ID INTEGER NOT NULL PRIMARY KEY, HOST 
VARCHAR(10), FLAG BOOLEAN)";
+conn.createStatement().execute(sql);
+sql =
+"CREATE VIEW " + fullViewName
++ " (COL1 INTEGER, COL2 INTEGER, COL3 INTEGER, 
COL4 INTEGER) AS SELECT * FROM "
++ fullTableName + " WHERE ID > 5";
+conn.createStatement().execute(sql);
+sql =
+"CREATE " + (localIndex ? "LOCAL " : "") + " INDEX " + 
indexName + " ON "
++ fullTableName + "(HOST)";
+conn.createStatement().execute(sql);
+sql =
+"CREATE VIEW " + fullChildViewName + " AS SELECT * FROM " 
+ fullViewName
++ " WHERE COL1 > 2";
+conn.createStatement().execute(sql);
+// Sanity upserts in baseTable, view, child view
+conn.createStatement()
+.executeUpdate("upsert into " + fullTableName + " values 
(1, 'host1', TRUE)");
+conn.createStatement()
+.executeUpdate("upsert into " + fullTableName + " values 
(5, 'host5', FALSE)");
+conn.createStatement()
+.executeUpdate("upsert into " + fullTableName + " values 
(7, 'host7', TRUE)");
+conn.commit();
+// View is not updateable
+try {
+conn.createStatement().executeUpdate("upsert into " + 
fullViewName
++ " (ID, HOST, FLAG, COL1) values (7, 'host7', TRUE, 
1)");
+fail();
+} catch (Exception e) {
+}
+// Check view inherits index, but child view doesn't
+PTable table = PhoenixRuntime.getTable(conn, fullViewName);
+assertEquals(1, table.getIndexes().size());
+table = PhoenixRuntime.getTable(conn, fullChildViewName);
+assertEquals(0, table.getIndexes().size());
+
+ResultSet rs =
+conn.createStatement().executeQuery("select count(*) from 
" + fullTableName);
+assertTrue(rs.next());
+assertEquals(3, rs.getInt(1));
+
+rs = conn.createStatement().executeQuery("select count(*) from " + 
fullViewName);
+assertTrue(rs.next());
+assertEquals(1, rs.getInt(1));
+}
+}
 
 @Test
 public void testCreateViewDefinesPKColumn() throws Exception {
diff --git a/phoenix-core/src/main/java/org/apache/phoenix/util/ViewUtil.java 
b/phoenix-core/src/main/java/org/apache/phoenix/util/ViewUtil.java
index 424acc0..d0f6fc5 100644
--- 

Build failed in Jenkins: Phoenix Compile Compatibility with HBase #1270

[Apache Jenkins Server]

See 


Changes:


--
Started by timer
Running as SYSTEM
[EnvInject] - Loading node environment variables.
Building remotely on H35 (ubuntu) in workspace 

[Phoenix_Compile_Compat_wHBase] $ /bin/bash /tmp/jenkins5926118589655358680.sh
core file size  (blocks, -c) 0
data seg size   (kbytes, -d) unlimited
scheduling priority (-e) 0
file size   (blocks, -f) unlimited
pending signals (-i) 386461
max locked memory   (kbytes, -l) 16384
max memory size (kbytes, -m) unlimited
open files  (-n) 6
pipe size(512 bytes, -p) 8
POSIX message queues (bytes, -q) 819200
real-time priority  (-r) 0
stack size  (kbytes, -s) 8192
cpu time   (seconds, -t) unlimited
max user processes  (-u) 10240
virtual memory  (kbytes, -v) unlimited
file locks  (-x) unlimited
core id : 0
core id : 1
core id : 2
core id : 3
core id : 4
core id : 5
physical id : 0
physical id : 1
MemTotal:   98978412 kB
MemFree: 3071820 kB
Filesystem  Size  Used Avail Use% Mounted on
udev 48G 0   48G   0% /dev
tmpfs   9.5G  1.7M  9.5G   1% /run
/dev/sda3   3.6T  532G  2.9T  16% /
tmpfs48G  4.0K   48G   1% /dev/shm
tmpfs   5.0M 0  5.0M   0% /run/lock
tmpfs48G 0   48G   0% /sys/fs/cgroup
/dev/sda2   473M  159M  290M  36% /boot
tmpfs   9.5G  4.0K  9.5G   1% /run/user/910
/dev/loop0   90M   90M 0 100% /snap/core/8268
/dev/loop2   55M   55M 0 100% /snap/core18/1650
/dev/loop6   60M   60M 0 100% /snap/snapcraft/3943
/dev/loop5   60M   60M 0 100% /snap/snapcraft/3970
/dev/loop1   55M   55M 0 100% /snap/core18/1668
/dev/loop7   67M   67M 0 100% /snap/lxd/13253
/dev/loop4   67M   67M 0 100% /snap/lxd/13300
/dev/loop3   92M   92M 0 100% /snap/core/8592
apache-maven-2.2.1
apache-maven-3.0.5
apache-maven-3.1.1
apache-maven-3.2.5
apache-maven-3.3.9
apache-maven-3.5.2
apache-maven-3.5.4
apache-maven-3.6.0
apache-maven-3.6.2
apache-maven-3.6.3
latest
latest2
latest3


===
Verifying compile level compatibility with HBase 0.98 with Phoenix 
4.x-HBase-0.98
===

Cloning into 'hbase'...
Checking out files:  75% (3830/5045)   Checking out files:  76% (3835/5045)   
Checking out files:  77% (3885/5045)   Checking out files:  78% (3936/5045)   
Checking out files:  79% (3986/5045)   Checking out files:  80% (4036/5045)   
Checking out files:  81% (4087/5045)   Checking out files:  82% (4137/5045)   
Checking out files:  83% (4188/5045)   Checking out files:  84% (4238/5045)   
Checking out files:  85% (4289/5045)   Checking out files:  86% (4339/5045)   
Checking out files:  87% (4390/5045)   Checking out files:  88% (4440/5045)   
Checking out files:  89% (4491/5045)   Checking out files:  90% (4541/5045)   
Checking out files:  91% (4591/5045)   Checking out files:  92% (4642/5045)   
Checking out files:  93% (4692/5045)   Checking out files:  94% (4743/5045)   
Checking out files:  95% (4793/5045)   Checking out files:  96% (4844/5045)   
Checking out files:  97% (4894/5045)   Checking out files:  98% (4945/5045)   
Checking out files:  99% (4995/5045)   Checking out files: 100% (5045/5045)   
Checking out files: 100% (5045/5045), done.
Switched to a new branch '0.98'
Branch '0.98' set up to track remote branch '0.98' from 'origin'.
[ERROR] Plugin org.codehaus.mojo:findbugs-maven-plugin:2.5.2 or one of its 
dependencies could not be resolved: Failed to read artifact descriptor for 
org.codehaus.mojo:findbugs-maven-plugin:jar:2.5.2: Could not transfer artifact 
org.codehaus.mojo:findbugs-maven-plugin:pom:2.5.2 from/to central 
(https://repo.maven.apache.org/maven2): Transfer failed for 
https://repo.maven.apache.org/maven2/org/codehaus/mojo/findbugs-maven-plugin/2.5.2/findbugs-maven-plugin-2.5.2.pom:
 Received fatal alert: protocol_version -> [Help 1]
[ERROR] 
[ERROR] To see the full stack trace of the errors, re-run Maven with the -e 
switch.
[ERROR] Re-run Maven using the -X switch to enable full debug logging.
[ERROR] 
[ERROR] For more information about the errors and possible solutions, please 
read the following articles:
[ERROR] [Help 1] 
http://cwiki.apache.org/confluence/display/MAVEN/PluginResolutionException
Build step 'Execute shell' marked build as failure