topic Converting Managed Hive Metastore Table to External Table with Mount Point Location in Get Started Discussions https://community.databricks.com/t5/get-started-discussions/converting-managed-hive-metastore-table-to-external-table-with/m-p/102199#M4645 <P><SPAN>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.</SPAN></P> Mon, 16 Dec 2024 06:59:12 GMT shweta_m 2024-12-16T06:59:12Z Converting Managed Hive Metastore Table to External Table with Mount Point Location https://community.databricks.com/t5/get-started-discussions/converting-managed-hive-metastore-table-to-external-table-with/m-p/102199#M4645 <P><SPAN>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.</SPAN></P> Mon, 16 Dec 2024 06:59:12 GMT https://community.databricks.com/t5/get-started-discussions/converting-managed-hive-metastore-table-to-external-table-with/m-p/102199#M4645 shweta_m 2024-12-16T06:59:12Z Re: Converting Managed Hive Metastore Table to External Table with Mount Point Location https://community.databricks.com/t5/get-started-discussions/converting-managed-hive-metastore-table-to-external-table-with/m-p/102228#M4646 <P>You could create the table as external table by using&nbsp;<SPAN class="hljs-keyword">CREATE</SPAN> <SPAN class="hljs-keyword">TABLE</SPAN><SPAN> student_copy </SPAN><SPAN class="hljs-keyword">AS</SPAN> <SPAN class="hljs-keyword">SELECT</SPAN><SPAN> * </SPAN><SPAN class="hljs-keyword">FROM</SPAN><SPAN> student; to pull the data from the managed table.</SPAN></P> Mon, 16 Dec 2024 11:47:54 GMT https://community.databricks.com/t5/get-started-discussions/converting-managed-hive-metastore-table-to-external-table-with/m-p/102228#M4646 Walter_C 2024-12-16T11:47:54Z