[
https://issues.apache.org/jira/browse/PHOENIX-99?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13921870#comment-13921870
]
Mujtaba Chohan commented on PHOENIX-99:
---------------------------------------
If a table is get automatically upgraded when the table create DDL is executed
with 3.0 client doesn't it nullify the need for whitelisting altogether (no
upgrade required at connection time) for 3.0 clients that work with logic to
create table if not exists?
> Automatic white list based upgrade from 2.2 to 3.0
> --------------------------------------------------
>
> Key: PHOENIX-99
> URL: https://issues.apache.org/jira/browse/PHOENIX-99
> Project: Phoenix
> Issue Type: Bug
> Affects Versions: 3.0.0
> Reporter: James Taylor
> Assignee: James Taylor
> Fix For: 3.0.0
>
> Attachments: coproc-tweak.diff, patch-3.diff, patch.diff, patch.diff
>
>
> Auto upgrade tables from Phoenix 2.2.2/2.2.3 format to Phoenix 3.0 format.
> Note that upgrade is only attempted to be performed once, upon first
> connection to a cluster. A table is only upgraded if it is white listed based
> on the following new config property: phoenix.client.autoUpgradeWhiteList
> If this property is not present, no tables will be upgraded. The config
> property may have the following values:
> - * which means upgrade everything or
> - a comma separated list of fully qualified, case sensitive names (note that
> by default, Phoenix stores table names in uppercase unless put them in double
> quotes at DDL time)
> Examples:
> {code}
> <property>
> <name>phoenix.client.autoUpgradeWhiteList</name>
> <value>*</value> <!- will upgrade all tables ->
> </property>
> {code}
> {code}
> <property>
> <name>phoenix.client.autoUpgradeWhiteList</name>
> <value>MY_SCHEMA.MY_TABLE, OTHER_TABLE</value>
> </property>
> {code}
> The upgrade is only run once per connection to a cluster (when the
> SYSTEM.CATALOG is created). If you need to force it to run again after that,
> you can remove or set to "false" the UpgradeTo30 value that's stored in the
> metadata of the SYSTEM.CATALOG table.
--
This message was sent by Atlassian JIRA
(v6.2#6252)
