[jira] [Commented] (FLINK-29952) Using DROP TABLE XXX to drop a temporary table （or view） in sql-client can get an exception with incomplete explaination.

["yuzelin (Jira)" <ji...@apache.org>]

    [ 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)