[
https://issues.apache.org/jira/browse/PHOENIX-3547?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16401273#comment-16401273
]
Miles Spielberg commented on PHOENIX-3547:
------------------------------------------
Is there precedent or a preferred pattern for modifying data types of system
tables, i.e. upgrading SYSTEM.CATALOG.VIEW_INDEX_ID from a SMALLINT to BIGINT?
Looking at QueryServicesConnectionImpl.upgradeSystemTables() the dominant
operation is adding new columns, and I'm unsure whether it would be preferable
to perform an in-place rewrite of existing values or to create a new column of
the expanded size.
> Promote CATALOG.VIEW_INDEX_ID to an int
> ---------------------------------------
>
> Key: PHOENIX-3547
> URL: https://issues.apache.org/jira/browse/PHOENIX-3547
> Project: Phoenix
> Issue Type: New Feature
> Reporter: Jeremy Huffman
> Priority: Minor
>
> Increase the size of CATALOG.VIEW_INDEX_ID from smallint to int to support a
> large number of indexed views on a single table.
> Per James: "The code would just need to be tolerant when reading the data if
> the length is two byte short versus four byte int. At write time, we'd just
> always write an int."
> See:
> https://lists.apache.org/thread.html/22849e4fc73452cee3bea763cf6d5af7164dedcb44573ba6b9f452a2@%3Cuser.phoenix.apache.org%3E
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
