[
https://issues.apache.org/jira/browse/FLINK-29952?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17630823#comment-17630823
]
yuzelin commented on FLINK-29952:
---------------------------------
Currently, dropping a temporary table should add the keyword 'TEMPORARY'. I
think you are right, we need improve the exception message.
> Using DROP TABLE XXX to drop a temporary table （or view） in sql-client can
> get an exception with incomplete explaination.
> -------------------------------------------------------------------------------------------------------------------------
>
> Key: FLINK-29952
> URL: https://issues.apache.org/jira/browse/FLINK-29952
> Project: Flink
> Issue Type: Improvement
> Components: Table SQL / API
> Affects Versions: 1.16.0
> Environment: Flink 1.16.0
> Red Hat Enterprise Linux Server release 7.4
> Reporter: Hang HOU
> Priority: Major
> Labels: pull-request-available
> Attachments: image-2022-11-09-15-06-33-188.png
>
>
> Drop temporary table by using DROP TABLE XXX...always get "Drop it first
> before removing the permanent table" but I just create a temporary table and
> have no relation with any permanent table. Like the official example :
> -- create a word data generator table
> CREATE TEMPORARY TABLE word_table (
> word STRING
> ) WITH (
> 'connector' = 'datagen',
> 'fields.word.length' = '1'
> );
> current exception:
> !image-2022-11-09-15-06-33-188.png!
> So I guess the exception should append some notice like "please check
> whether miss a TEMPORARY before TABLE".
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
