Converting Managed Hive Metastore Table to External Table with Mount Point Location

[shweta_m]

We have a managed Hive Metastore (HMS) table, and we would like to convert it into an external table and the location of that external hms table as mount points.

[Walter_C]

You could create the table as external table by using CREATE TABLE student_copy AS SELECT * FROM student; to pull the data from the managed table.