first query is not working in starrocks while second query is working absolutely fine, the only between these two queries is the path in the first query we have provided path as /year=2023/month=5/day=1/hour=0/.
Could someone please help to resolve this issue.
starrocks version : Latest-3.3
SELECT * FROM FILES
(
“path” = “s3://bucket-abc01-data/somepath/data/table/year=2023/month=5/day=1/hour=0/000000_0”,
“format” = “parquet”,
“aws.s3.access_key” = “AAAAAAAAAAAAAAAAA”,
“aws.s3.secret_key” = “BBBBBBBBBBBBBBBBBBBBBBB”,
“aws.s3.region” = “us-west-1”,
“aws.s3.endpoint” = “https://some_endpoint.com:9021”,
“aws.s3.enable_path_style_access” = “true”,
“aws.s3.enable_ssl” = “true”
)
LIMIT 3;
SELECT * FROM FILES
(
“path” = “s3://bucket-abc01-data/somepath/data/table/000000_0”,
“format” = “parquet”,
“aws.s3.access_key” = “AAAAAAAAAAAAAAAAA”,
“aws.s3.secret_key” = “BBBBBBBBBBBBBBBBBBBBBBB”,
“aws.s3.region” = “us-west-1”,
“aws.s3.endpoint” = “https://some_endpoint.com:9021”,
“aws.s3.enable_path_style_access” = “true”,
“aws.s3.enable_ssl” = “true”
)
LIMIT 3;
ERROR:
SQL Error [1064] [42000]: Access storage error. Error message: failed to get file schema, path: s3://bucket-abc01-data/somepath/data/table/year=2023/month=5/day=1/hour=0/000000_0, error: [Init parquet reader fail. IOError: BE access S3 file failed, SdkResponseCode=403, SdkErrorType=15, SdkErrorMessage=No response body., filename: s3://bucket-abc01-data/somepath/data/table/year=2023/month=5/day=1/hour=0/000000_0]