Ultimate access to all questions.
After creating a Delta Lake table with the following query that contains a typographical error:
CREATE TABLE prod.sales_by_stor
USING DELTA
LOCATION "/mnt/prod/sales_by_store"
The following command was executed to correct the table name:
ALTER TABLE prod.sales_by_stor RENAME TO prod.sales_by_store
What will be the outcome of executing the second command?