question Re: Change Hive database location. in Support Questions

question Re: Change Hive database location. in Support Questions https://community.cloudera.com/t5/Support-Questions/Change-Hive-database-location/m-p/291110#M215293 Is this a cluster with sentry and sentry hdfs synchronisation enabled? If it is just hive without sentry or sentry hdfs synchronisation enabled and you want to switch from default /user/hive/warehouse to a new path then following steps would do <LI-CODE lang="markup">Step1: Stop hive Step2: Take backup of your metastore database Step3: Change the CM > Hive > Configuration > hive.metastore.warehouse.dir setting to '<new path>' - Deploy client configuration Step4: Move the current directory i.e hdfs dfs -mv /user/hive/warehouse <new_path> Step5: Update HMS DB tables. Login to backend hms db and update the following tables in metastore database. update SDS set location = (select replace(location, '/user/hive/warehouse', '<new_path>') ) where location like '%/user/hive/warehouse%'; update DBS set DB_LOCATION_URI = (select replace(DB_LOCATION_URI, '/user/hive/warehouse', '<new_path>') ) where DB_LOCATION_URI like '%/user/hive/warehouse%'; update SKEWED_COL_VALUE_LOC_MAP set LOCATION = (select replace(LOCATION, '/user/hive/warehouse', '<new path>') ) where LOCATION like '%/user/hive/warehouse%'; update SERDE_PARAMS set PARAM_VALUE = (select replace(PARAM_VALUE, '/user/hive/warehouse', '<new path>') ) where PARAM_VALUE like '%/user/hive/warehouse%'; update TABLE_PARAMS set PARAM_VALUE = (select replace(PARAM_VALUE, '/user/hive/warehouse', '<new path>') ) where PARAM_VALUE like '%/user/hive/warehouse%'; Step6: - Start hive</LI-CODE>  Make sure to test this steps on your test clusters first before proceeding towards production cluster.   Thu, 05 Mar 2020 04:50:20 GMT venkatsambath 2020-03-05T04:50:20Z