You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "James Taylor (JIRA)" <ji...@apache.org> on 2017/06/02 16:24:04 UTC
[jira] [Resolved] (PHOENIX-3209) Ensure scans run at specific
server timestamp for UPSERT SELECT to same table
[ https://issues.apache.org/jira/browse/PHOENIX-3209?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
James Taylor resolved PHOENIX-3209.
-----------------------------------
Resolution: Duplicate
This is fixed as part of PHOENIX-3823
> Ensure scans run at specific server timestamp for UPSERT SELECT to same table
> -----------------------------------------------------------------------------
>
> Key: PHOENIX-3209
> URL: https://issues.apache.org/jira/browse/PHOENIX-3209
> Project: Phoenix
> Issue Type: Sub-task
> Reporter: James Taylor
> Assignee: Maddineni Sukumar
> Fix For: 4.11.0
>
>
> This is a corner case of specifying an UPDATE_CACHE_FREQUENCY on a table and executing an UPSERT SELECT. Without an UPDATE_CACHE_FREQUENCY, we ping the server to ensure we have the latest version of the schema. We'll then run the query based on the server timestamp returned as a result of checking that the schema is up-to-date. If an UPDATE_CACHE_FREQUENCY is set, we skip this RPC which is a potential problem in this case. This becomes more likely when we introduce a default UPATE_CACHE_FREQUENCY with PHOENIX-2885. The fix is to ignore the UPDATE_CACHE_FREQUENCY when an UPSERT SELECT is performed where the source and target table are the same.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)