You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@phoenix.apache.org by "Geoffrey Jacoby (Jira)" <ji...@apache.org> on 2021/04/26 18:43:00 UTC

[jira] [Created] (PHOENIX-6457) Optionally store schema version string in SYSTEM.CATALOG

Geoffrey Jacoby created PHOENIX-6457:
----------------------------------------

             Summary: Optionally store schema version string in SYSTEM.CATALOG
                 Key: PHOENIX-6457
                 URL: https://issues.apache.org/jira/browse/PHOENIX-6457
             Project: Phoenix
          Issue Type: New Feature
            Reporter: Geoffrey Jacoby
            Assignee: Geoffrey Jacoby
             Fix For: 4.17.0, 5.2.0


In many environments, schema changes to Phoenix tables are applied in batches associated with a version of an application. (For example, v1.0 of an app may start with one set of CREATE statements, v1.1 then adds some ALTER statements, etc.) 

It can be useful to be able to look up the latest app version in which a table or view was changed; this could potentially be added as a feature of the Schema Tool. 

This change would add an optional property to CREATE and ALTER statements, SCHEMA_VERSION, which would take a user-supplied string. 

This is also a pre-req for PHOENIX-6227, because we would want to pass the schema version string, if any, to an external schema repository in environments where we're integrating with one. 



--
This message was sent by Atlassian Jira
(v8.3.4#803005)