[jira] [Commented] (FLINK-28003) Hive sql is wrongly modified by SqlCompleter in SQL client when using -f {file}

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

    [ https://issues.apache.org/jira/browse/FLINK-28003?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17563090#comment-17563090 ] 

Liu commented on FLINK-28003:
-----------------------------

I have discussed with [~jingzhang] and solve it in our inner flink version. Could you review the code, [~fsk119] . Thanks.

> Hive sql is wrongly modified by SqlCompleter in SQL client when using -f {file}
> -------------------------------------------------------------------------------
>
>                 Key: FLINK-28003
>                 URL: https://issues.apache.org/jira/browse/FLINK-28003
>             Project: Flink
>          Issue Type: Bug
>          Components: Table SQL / Client
>    Affects Versions: 1.15.0
>            Reporter: Jing Zhang
>            Assignee: Shengkai Fang
>            Priority: Major
>              Labels: pull-request-available
>         Attachments: zj_test.sql
>
>
> When I run the following sql in SqlClient using 'sql-client.sh -f zj_test.sql'
> {code:java}
> create table if not exists db.zj_test(
> pos                   int,
> rank_cmd              string
> )
> partitioned by (
> `p_date` string,
> `p_hourmin` string);
> INSERT OVERWRITE TABLE db.zj_test PARTITION (p_date='20220605', p_hourmin = '0100')
> SELECT
> pos ,
> rank_cmd
> FROM db.sourceT
> where p_date = '20220605' and p_hourmin = '0100'; {code}
> An error would be thrown out because the 'pos' field is changed to 'POSITION'. I guess `SqlCompleter` in sqlClient module might do something wrong.
> The error could be reproduced using the attached file.
>  
>  



--
This message was sent by Atlassian Jira
(v8.20.10#820010)