unable to overwrite a table using add data in hive metastore.

[kkg33]

I used to see the dropdown of tables under hive_metastore while using add data -> Create or modify table from file upload -> overwrite existing table but not able to from couple days. No change in permissions. I can still see this for unity catalog tables. Does anything change on this in recent days.

 

[mmayorga]

hi @kkg33 

Thank you for reaching out and for your patience in awaiting a response.

Have you tried to query the table directly from a notebook or using the Catalog Explorer? Or is this behavior only happening on the "Upload File UI"? 
If you are unable to reach that table, perhaps the configuration related to table access control to that cluster for the hive metastore was updated. You may have to work with your platform administrator to confirm. Here are the steps to enable it.

Also, remember that Hive Metastore is now considered Legacy, and we recommend migrating to Unity Catalog to get all the great features these provide: enhanced security, governance, lineage, and more.

I hope this helps!