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

• Type: Bug
• Status: Closed
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: 1.15.0
• Fix Version/s: 1.16.0
• Component/s: Table SQL / Client
• Labels: pull-request-available
• Assignee: Liu
• Reporter: Jing Zhang
• Created: 10/Jun/22 12:40
• Updated: 16/Aug/22 04:10
• Resolved: 16/Aug/22 04:10

Description

When I run the following sql in SqlClient using 'sql-client.sh -f zj_test.sql'

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'; 

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.

 

 

Issue Links

• links to: GitHub Pull Request #20182