pvignesh92
Honored Contributor

@Chris Konsur​ Hi. You did not mention the command you used to create the table. However the issue I could see here is that the table is already available in the catalog and you have to create a new table with the same name. If that's the case, the below two approaches could work.

  1. Drop the existing table using DROP TABLE command and then create your new table so that the old entry can be cleared from the Catalog.
  2. Using CREATE OR REPLACE TABLE command.

Deleting the filesystem path will not remove your table entry from the catalog but dropping the table will remove your file path if it is a managed table. I see your table could be a managed table as the source path is hive warehouse path. Please try and let us know if this works.