If you are upgrading from Apache Ambari 2.4.0 to Apache Ambari 2.5.2 and want to upgrade and migrate the data and queries from Hive View to Hive View 2.0, first create a new instance of the Hive View and then migrate your queries.

Migrating your queries into the new view

Create a new Hive View 2.0 instance and then migrate the saved queries from the Hive View 1.5 instance to the new instance. To do that, run the following curl command.

curl -v -u admin:admin -X PUT -H X-Requested-By:1 http://<host/ip ambari server>:8080/api/v1/views/<view name>/versions/<version of target view>/instances/<instance name of target view>/migrate/<version of source view>/<instance name of source view>

For information on where to get the specific parameters listed in the curl command, refer to the following figure: