Hi,
I created tables with special characters in it. I am unable to delete those tables from my database. Please suggest me a fix.
I tried number of queries but I could not delete these tables. I have used back ticks to enclose the table name but it did not work.
DROP TABLE customer_id_partitioned_{$$.time.now}
DROP TABLE customer_id_partitioned_"{$$.time.now}"
DROP TABLE customer_id_partitioned_"{""$""$".time.now"}"
Error:
FAILED: SemanticException [Error 10255]: Invalid table name customer_id_partitioned_{$$.time.now}
This query ran against the "dev_systems" database, unless qualified by the query. Please post the error message on our forum or contact customer support with Query Id: 3ae412b1-044a-4b5c-abe3-f9e39568daa6
Is there a way to forcefully delete it?
Thanks,
Arora
Could you try this DROP TABLE customer_id_partitioned_{$$.time.now}
Could you next time provide a little more context like what is your environment, service in use etc to ease contribution?