[
https://issues.apache.org/jira/browse/FLINK-28003?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jing Zhang updated FLINK-28003:
-------------------------------
Description:
When I run the following sql in SqlClient when 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.
was:
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.
> '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
> Priority: Major
> Attachments: zj_test.sql
>
>
> When I run the following sql in SqlClient when 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)
