[ https://issues.apache.org/jira/browse/FLINK-24052 ]


    Moses deleted comment on FLINK-24052:
    -------------------------------

was (Author: zhangchaoming):
There is something wrong with my S3 cluster. And I solved this by using another 
cluster.

> Flink SQL reads S3 bucket data.
> -------------------------------
>
>                 Key: FLINK-24052
>                 URL: https://issues.apache.org/jira/browse/FLINK-24052
>             Project: Flink
>          Issue Type: Improvement
>          Components: Table SQL / Ecosystem
>            Reporter: Moses
>            Priority: Not a Priority
>
> I wanna use Flink SQL reads S3 bucket data. But now I found it ONLY supports 
> absolute path, which means I can not read all content in the bucket. 
> My SQL statements write as below:
> {code:sql}
> CREATE TABLE file_data (
>     a BIGINT, b STRING, c STRING, d DOUBLE, e BOOLEAN, f DATE, g STRING,h 
> STRING,
>     i STRING, j STRING, k STRING, l STRING, m STRING, n STRING, o STRING, p 
> FLOAT
> ) WITH (
>     'connector' = 'filesystem',
>     'path' = 's3a://my-bucket',
>     'format' = 'parquet'
> );
> SELECT COUNT(*) FROM file_data;
> {code}
> The exception info:
> {code:java}
> Caused by: java.lang.IllegalArgumentException: path must be absolute
>       at 
> com.google.common.base.Preconditions.checkArgument(Preconditions.java:88) 
> ~[flink-s3-fs-hadoop-1.13.1.jar:1.13.1]
>       at 
> org.apache.hadoop.fs.s3a.s3guard.PathMetadata.<init>(PathMetadata.java:68) 
> ~[flink-s3-fs-hadoop-1.13.1.jar:1.13.1]
>       at 
> org.apache.hadoop.fs.s3a.s3guard.PathMetadata.<init>(PathMetadata.java:60) 
> ~[flink-s3-fs-hadoop-1.13.1.jar:1.13.1]
>       at 
> org.apache.hadoop.fs.s3a.s3guard.PathMetadata.<init>(PathMetadata.java:56) 
> ~[flink-s3-fs-hadoop-1.13.1.jar:1.13.1]
>       at 
> org.apache.hadoop.fs.s3a.s3guard.S3Guard.putAndReturn(S3Guard.java:149) 
> ~[flink-s3-fs-hadoop-1.13.1.jar:1.13.1]
> {code}
> Is there any solution to meet my requirement ?



--
This message was sent by Atlassian Jira
(v8.20.1#820001)

Reply via email to