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?

已提問 2 年前檢視次數 55 次
沒有答案

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋,同時有助於提問者的專業成長。

回答問題指南