Re: Does Table API connector, csv, has some option to ignore some columns

2022-07-25 Thread podunk
    Best regards, Yuxia   发件人: "podunk" 收件人: "User" 发送时间: 星期二, 2022年 7 月 12日 下午 5:13:05 主题: Re: Re: Does Table API connector, csv, has some option to ignore some columns   This is really surprising. When you import data from a file, you really rarely need to import ev

Re: Does Table API connector, csv, has some option to ignore some columns

2022-07-12 Thread yuxia
期二, 2022年 7 月 12日 下午 5:13:05 主题: Re: Re: Does Table API connector, csv, has some option to ignore some columns This is really surprising. When you import data from a file, you really rarely need to import everything from that file. Most often it is several columns. So the program that reads the

Re: Re: Does Table API connector, csv, has some option to ignore some columns

2022-07-12 Thread podunk
[1] https://nightlies.apache.org/flink/flink-docs-master/docs/connectors/table/formats/csv/   Best, Alexander Fedulov   On Mon, Jul 11, 2022 at 5:43 PM <pod...@gmx.com> wrote: No, I did not mean. I said 'Does Table API connector, CSV, has some option to ignore some columns i

Re: Re: Does Table API connector, csv, has some option to ignore some columns

2022-07-11 Thread Alexander Fedulov
ble/formats/csv/ Best, Alexander Fedulov On Mon, Jul 11, 2022 at 5:43 PM wrote: > No, I did not mean. > I said 'Does Table API connector, CSV, has some option to ignore some > columns in source file?' > > > *Sent:* Monday, July 11, 2022 at 5:28 PM > *From:* "Xuyan

Re: Re: Does Table API connector, csv, has some option to ignore some columns

2022-07-11 Thread podunk
No, I did not mean. I said 'Does Table API connector, CSV, has some option to ignore some columns in source file?'     Sent: Monday, July 11, 2022 at 5:28 PM From: "Xuyang" To: pod...@gmx.com Cc: user@flink.apache.org Subject: Re:Re: Does Table API connector, csv, has s

Re:Re: Does Table API connector, csv, has some option to ignore some columns

2022-07-11 Thread Xuyang
table not what I get from table. Sent: Monday, July 11, 2022 at 3:37 AM From: "Shengkai Fang" To: pod...@gmx.com Cc: "user" 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

Re: Does Table API connector, csv, has some option to ignore some columns

2022-07-11 Thread podunk
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" To: pod...@gmx.com Cc: "user" Subject: Re: Does Table API connector, csv, has some option to ignore some columns Hi.    In Flink SQL

Re: Does Table API connector, csv, has some option to ignore some columns

2022-07-10 Thread Shengkai Fang
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 于2022年7月9日周六 01:48写道: > Does Table API connector, CSV, has some option to ignore some columns in > source file? > For inst

Does Table API connector, csv, has some option to ignore some columns

2022-07-08 Thread podunk
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? CREATE TABLE some_table ( some_id BIGINT, ... ) WITH ( 'format' = 'csv', ... )