Drop tables error due to special symbol

0

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?

gefragt vor 2 Jahren55 Aufrufe
Keine Antworten

Du bist nicht angemeldet. Anmelden um eine Antwort zu veröffentlichen.

Eine gute Antwort beantwortet die Frage klar, gibt konstruktives Feedback und fördert die berufliche Weiterentwicklung des Fragenstellers.

Richtlinien für die Beantwortung von Fragen