[ 
https://issues.apache.org/jira/browse/IMPALA-9843?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17134598#comment-17134598
 ] 

ASF subversion and git services commented on IMPALA-9843:
---------------------------------------------------------

Commit f8c28f8adfd781727c311b15546a532ce65881e0 in impala's branch 
refs/heads/master from Vihang Karajgaonkar
[ https://gitbox.apache.org/repos/asf?p=impala.git;h=f8c28f8 ]

IMPALA-9843: Add support for metastore db schema upgrade

This change adds support to upgrade the HMS database schema using the
hive schema tool. It adds a new option to the buildall.sh script
which can be provided to upgrade the HMS db schema. Alternatively,
users can directly upgrade the schema using the
create-test-configuration.sh script. The logs for the schema upgrade
are available in logs/cluster/schematool.log.

Following invocations will upgrade the HMS database schema.

1. buildall.sh -upgrade_metastore_db
2. bin/create-test-configuration.sh -upgrade_metastore_db

This upgrade option is idempotent. It is a no-op if the metastore
schema is already at its latest version. In case of any errors, the
only fallback currently is to format the metastore schema and load
the test data again.

Testing:
Upgraded the HMS schema on my local dev environment and made
sure that the HMS service starts without any errors.

Change-Id: I85af8d57e110ff284832056a1661f94b85ed3b09
Reviewed-on: http://gerrit.cloudera.org:8080/16054
Reviewed-by: Impala Public Jenkins <[email protected]>
Tested-by: Impala Public Jenkins <[email protected]>


> Add ability to run schematool against HMS in minicluster
> --------------------------------------------------------
>
>                 Key: IMPALA-9843
>                 URL: https://issues.apache.org/jira/browse/IMPALA-9843
>             Project: IMPALA
>          Issue Type: Improvement
>            Reporter: Sahil Takiar
>            Assignee: Vihang Karajgaonkar
>            Priority: Major
>             Fix For: Impala 4.0
>
>
> When the CDP version is bumped, we often need to re-format the HMS postgres 
> database because the HMS schema needs updating. Hive provides a standalone 
> tool for performing schema updates: 
> [https://cwiki.apache.org/confluence/display/Hive/Hive+Schema+Tool]
> Impala should be able to integrate with this tool, so that developers don't 
> have to blow away their HMS database every time the CDP version is bumped up. 
> Even worse, blowing away the HMS data requires performing a full data load.
> It would be great to have a wrapper around the schematool that can easily be 
> invoked by developers.



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

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to