[jira] [Commented] (PHOENIX-14) UPSERT hint to avoid WAL writes

["Lars Hofhansl (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/PHOENIX-14?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13889127#comment-13889127 ] 

Lars Hofhansl commented on PHOENIX-14:
--------------------------------------

Actually, that said, should we have the above options as table hints? I.e. SKIP_WAL, ASYNC_WAL, SYNC_WAL, FSYNC_WAL?

In 0.96+ HBase will have these as column family options as well, but changing those would be a heavy weight operation (requiring reloading all regions, which currently cannot be done safely online - and this requires disabling and re-enabling the table).

With this controlled at the client even via table attributes is more lightweight. (In fact this is an interesting pattern for HBase itself)

> UPSERT hint to avoid WAL writes
> -------------------------------
>
>                 Key: PHOENIX-14
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-14
>             Project: Phoenix
>          Issue Type: Improvement
>            Reporter: Lars Hofhansl
>
> Since HBASE-7801 (0.94.7) HBase supports durability hints for Put and Delete operations. 
> We should support these via an UPSERT hint.
> At least /*+ SKIP_WAL */ to skip all WAL writes.
> Later we can add
> /*+ ASYNC_WAL */
> /*+ SYNC_WAL */
> /*+ FSYNC_WAL */



--
This message was sent by Atlassian JIRA
(v6.1.5#6160)