Jing Zhang created FLINK-28003:
----------------------------------
Summary: 'pos ' field would be updated to 'POSITION' when use
SqlClient
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
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 must do something here.
The error could be reproduced using the attached file.
--
This message was sent by Atlassian Jira
(v8.20.7#820007)
