[
https://issues.apache.org/jira/browse/HIVE-19938?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16524092#comment-16524092
]
Thejas M Nair commented on HIVE-19938:
--------------------------------------
Discussed offline with Daniel - Setting the version using python had to
workaround many limitations in shell command support in beeline. As a result,
the there was no way to use variables like $HOME to create a more specific file
location for the version information file. Though a syntax that should work
with multiple versions of python has been chosen, there is still some risk with
the python command usage (python would be a new requirement AFAIK).
The longer term approach would be to consolidate the version of
information_schema and db_schema into a table in DB and information_schema just
being a view on top of it (like earlier patch). But that would require lot more
refactoring, which we can address seperately.
For now a safer approach would be to use "alter table " to set table property
containing version information of "insert into" .
For background: The issue with earlier usage of "insert into version" with
information_schema is that it would require a tez/spark task to run to execute
it. That means there would be new dependency on yarn to be up and running, and
the install could end up taking minutes in some cases.
> Upgrade scripts for information schema
> --------------------------------------
>
> Key: HIVE-19938
> URL: https://issues.apache.org/jira/browse/HIVE-19938
> Project: Hive
> Issue Type: Bug
> Reporter: Daniel Dai
> Assignee: Daniel Dai
> Priority: Major
> Attachments: HIVE-19938.1.patch, HIVE-19938.2.patch,
> HIVE-19938.3.patch, HIVE-19938.4.patch
>
>
> To make schematool -upgradeSchema work for information schema.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
