[
https://issues.apache.org/jira/browse/PHOENIX-1095?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
James Taylor resolved PHOENIX-1095.
-----------------------------------
Resolution: Fixed
Fix Version/s: 3.2
4.2
5.0.0
I believe this is fixed now, but if not, please re-open.
> Cannot add column to SYSTEM.CATALOG using Alter Table
> ------------------------------------------------------
>
> Key: PHOENIX-1095
> URL: https://issues.apache.org/jira/browse/PHOENIX-1095
> Project: Phoenix
> Issue Type: Bug
> Reporter: Jeffrey Zhong
> Assignee: Jeffrey Zhong
> Fix For: 5.0.0, 4.2, 3.2
>
>
> When using ALTER TABLE command to extend SYSTEM.CATALOG table(this would
> happen when creating features to store more stats in CATALOG table like
> Phoenix-950, Phoenix-1038), you will get following error:
> {noformat}
> org.apache.phoenix.schema.TableNotFoundException: ERROR 1012 (42M03): Table
> undefined. tableName=CATALOG
> {noformat}
> This is due to Alter Table statement after SQL parsing will use
> PTableType.TABLE for table SYSTEM.CATALOG while the following check will fail
> during MetaDataEndpointImpl#mutateColumn update
> {noformat}
> if (type != expectedType) {
> return new
> MetaDataMutationResult(MutationCode.TABLE_NOT_FOUND,
> EnvironmentEdgeManager.currentTimeMillis(), null);
> }
> {noformat}
>
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
