[jira] [Commented] (PHOENIX-4737) Use position as column qualifier for APPEND_ONLY_SCHEMA

["James Taylor (JIRA)" <ji...@apache.org>]

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

James Taylor commented on PHOENIX-4737:
---------------------------------------

[~tdsilva] - please review. The check that prevents add columns to tables/views is the only check necessary, since a view derived from another view will add any new columns to the position after the inherited parent columns.

> Use position as column qualifier for APPEND_ONLY_SCHEMA
> -------------------------------------------------------
>
>                 Key: PHOENIX-4737
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-4737
>             Project: Phoenix
>          Issue Type: Improvement
>            Reporter: James Taylor
>            Assignee: James Taylor
>            Priority: Major
>             Fix For: 4.14.0, 5.0.0
>
>         Attachments: PHOENIX-4737_v1.patch
>
>
> An easy way to prevent gaps in the column encoding used to define column qualifiers is to use the position to define the column qualifier. This only works if:
>  * You disallow removes of columns
>  * You disallow adding columns to the base table
> This is pretty easy to enforce and will enable column encoding to be used effectively when a base table has many views.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)