Identify Table Location Missing HDFS Schema

[wenclr]

Some Hive tables in CDH5 clusters with absolute path, such as "/user/hive/warehouse/mytable", in the location property would got "Validate Hive Metastore Schema" error while upgrading to CDP7.1.7.

https://my.cloudera.com/knowledge/Failed-to-Validate-Hive-Metastore-Schema?id=76056
The message "Error: missing location scheme" is a warning that the table/partition location has been created without specifying the scheme of the location, like s3a://mybucket or hdfs://nameservice1. To make it unambiguous, it is advised to fix these locations to include the missing prefix ("hdfs://nameservice1" - cluster specific for example, if the table is on hdfs).

Following SQL would fix individual tables during the upgrading process. But ideally, we'd like to use hive-sre tool to identify and fix these before kicking off the upgrade to reduce the downtime.
ALTER TABLE table_name SET LOCATION 'hdfs://nameservice1/user/hive/warehouse/mytable';

[wenclr]

I think this is similar to #12