[ https://issues.apache.org/jira/browse/PHOENIX-6387?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17394158#comment-17394158 ]
ASF GitHub Bot commented on PHOENIX-6387: ----------------------------------------- stoty commented on pull request #1281: URL: https://github.com/apache/phoenix/pull/1281#issuecomment-893588982 :broken_heart: **-1 overall** | Vote | Subsystem | Runtime | Comment | |:----:|----------:|--------:|:--------| | +0 :ok: | reexec | 1m 4s | Docker mode activated. | ||| _ Prechecks _ | | +1 :green_heart: | dupname | 0m 0s | No case conflicting files found. | | +1 :green_heart: | hbaseanti | 0m 0s | Patch does not have any anti-patterns. | | +1 :green_heart: | @author | 0m 0s | The patch does not contain any @author tags. | | +1 :green_heart: | test4tests | 0m 0s | The patch appears to include 1 new or modified test files. | ||| _ master Compile Tests _ | | +1 :green_heart: | mvninstall | 23m 55s | master passed | | +0 | hbaserecompile | 31m 32s | HBase recompiled. | | +1 :green_heart: | compile | 1m 5s | master passed | | +1 :green_heart: | checkstyle | 1m 36s | master passed | | +1 :green_heart: | javadoc | 0m 52s | master passed | | +0 :ok: | spotbugs | 3m 20s | phoenix-core in master has 973 extant spotbugs warnings. | ||| _ Patch Compile Tests _ | | +1 :green_heart: | mvninstall | 16m 57s | the patch passed | | +0 | hbaserecompile | 27m 21s | HBase recompiled. | | +1 :green_heart: | compile | 1m 7s | the patch passed | | +1 :green_heart: | javac | 1m 7s | the patch passed | | -1 :x: | checkstyle | 1m 43s | phoenix-core: The patch generated 231 new + 2099 unchanged - 38 fixed = 2330 total (was 2137) | | +1 :green_heart: | whitespace | 0m 0s | The patch has no whitespace issues. | | +1 :green_heart: | javadoc | 0m 52s | the patch passed | | -1 :x: | spotbugs | 3m 37s | phoenix-core generated 1 new + 971 unchanged - 2 fixed = 972 total (was 973) | ||| _ Other Tests _ | | -1 :x: | unit | 122m 16s | phoenix-core in the patch failed. | | +1 :green_heart: | asflicense | 0m 35s | The patch does not generate ASF License warnings. | | | | 196m 40s | | | Reason | Tests | |-------:|:------| | FindBugs | module:phoenix-core | | | Switch statement found in org.apache.phoenix.hbase.index.IndexRegionObserver.applyOnePendingDeleteMutation(IndexRegionObserver$BatchMutateContext, Delete) where default case is missing At IndexRegionObserver.java:Delete) where default case is missing At IndexRegionObserver.java:[lines 694-701] | | Failed junit tests | phoenix.end2end.ConcurrentUpsertsWithoutIndexedColsIT | | Subsystem | Report/Notes | |----------:|:-------------| | Docker | ClientAPI=1.41 ServerAPI=1.41 base: https://ci-hadoop.apache.org/job/Phoenix/job/Phoenix-PreCommit-GitHub-PR/job/PR-1281/2/artifact/yetus-general-check/output/Dockerfile | | GITHUB PR | https://github.com/apache/phoenix/pull/1281 | | Optional Tests | dupname asflicense javac javadoc unit spotbugs hbaserebuild hbaseanti checkstyle compile | | uname | Linux 0bbfd4d225dc 4.15.0-147-generic #151-Ubuntu SMP Fri Jun 18 19:21:19 UTC 2021 x86_64 x86_64 x86_64 GNU/Linux | | Build tool | maven | | Personality | dev/phoenix-personality.sh | | git revision | master / 025a4af | | Default Java | Private Build-1.8.0_242-8u242-b08-0ubuntu3~16.04-b08 | | checkstyle | https://ci-hadoop.apache.org/job/Phoenix/job/Phoenix-PreCommit-GitHub-PR/job/PR-1281/2/artifact/yetus-general-check/output/diff-checkstyle-phoenix-core.txt | | spotbugs | https://ci-hadoop.apache.org/job/Phoenix/job/Phoenix-PreCommit-GitHub-PR/job/PR-1281/2/artifact/yetus-general-check/output/new-spotbugs-phoenix-core.html | | unit | https://ci-hadoop.apache.org/job/Phoenix/job/Phoenix-PreCommit-GitHub-PR/job/PR-1281/2/artifact/yetus-general-check/output/patch-unit-phoenix-core.txt | | Test Results | https://ci-hadoop.apache.org/job/Phoenix/job/Phoenix-PreCommit-GitHub-PR/job/PR-1281/2/testReport/ | | Max. process+thread count | 10657 (vs. ulimit of 30000) | | modules | C: phoenix-core U: phoenix-core | | Console output | https://ci-hadoop.apache.org/job/Phoenix/job/Phoenix-PreCommit-GitHub-PR/job/PR-1281/2/console | | versions | git=2.7.4 maven=3.3.9 spotbugs=4.1.3 | | Powered by | Apache Yetus 0.12.0 https://yetus.apache.org | This message was automatically generated. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: issues-unsubscr...@phoenix.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org > Conditional updates on tables with indexes > ------------------------------------------ > > Key: PHOENIX-6387 > URL: https://issues.apache.org/jira/browse/PHOENIX-6387 > Project: Phoenix > Issue Type: Improvement > Affects Versions: 5.0.0, 4.15.0 > Reporter: Kadir OZDEMIR > Assignee: Tanuj Khurana > Priority: Major > Fix For: 4.17.0, 5.2.0, 5.1.3 > > > For a row update done by using the UPSERT VALUES statement, the exact values > of the columns to be updated are specified within the UPSERT statement. > Regardless of whether a given row exists or not, after the update, we know > what the content will be for these columns. However, this is not the case > when the ON DUPLICATE KEY clause is added the UPSERT VALUES statement. This > clause makes the update conditional and the end result is determined based on > the conditions stated within the clause and the current state of the row at > the time the update is done. Also, this clause makes the UPSERT VALUES > statement atomic. > Conditional updates are supported for the tables without indexes currently. > The current design leverages an HBase atomic operation and cannot be expanded > to support tables with indexes since the design requires holding (HBase > level) row locks while doing index table updates over RPCs. This results in > cluster wide deadlocks. This jira is to redesign conditional updates using > Phoenix level row locks instead of using HBase level row locks to also > support tables with indexes by leveraging the design of PHOENIX-6160 which > simplifies the concurrent mutation handling on tables with indexes. -- This message was sent by Atlassian Jira (v8.3.4#803005)