Hi, did you mean `insert into table1 select col1, col2, col3 ... from table2`?
If this doesn't meet your requirement, what about using UDF to custom what you
want in runtime.
--
Best！
Xuyang
在 2022-07-11 16:10:00，pod...@gmx.com 写道：
I want to control what I insert in table not what I get from table.
Sent: Monday, July 11, 2022 at 3:37 AM
From: "Shengkai Fang" <fskm...@gmail.com>
To: pod...@gmx.com
Cc: "user" <user@flink.apache.org>
Subject: Re: Does Table API connector, csv, has some option to ignore some
columns
Hi.
In Flink SQL, you can select the column that you wants in the query. For
example, you can use
```
SELECT col_a, col_b FROM some_table;
```
Best,
Shengkai
<pod...@gmx.com> 于2022年7月9日周六 01:48写道：
Does Table API connector, CSV, has some option to ignore some columns in source
file?
For instance read only first, second, nine... but not the others?
Or any other trick?
CREATETABLEsome_table(some_idBIGINT,
...
)WITH('format'='csv',
...
)
