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ビュー
回答なし

ログインしていません。 ログイン 回答を投稿する。

優れた回答とは、質問に明確に答え、建設的なフィードバックを提供し、質問者の専門分野におけるスキルの向上を促すものです。

質問に答えるためのガイドライン

関連するコンテンツ