search

aws-quickstart / quickstart-clickhouse-cluster

AWS Quick Start Team
Apache License 2.0
14 stars 16 forks source link

Access Denied:While executing S3. #39

Open tianyinglan66 opened 2 years ago

tianyinglan66 commented 2 years ago

i install the clickhouse in the EC instance ,and create table sucessfully, but when i query , the console Shows that
Received exception from server (version 22.2.3): Code: 499. DB::Exception: Received from 172.31.30.179:9000. DB::Exception: Access Denied: While executing CSVRowInputFormat: While executing S3. (S3_ERROR)

i don't know what means, the Create table statement is ， CREATE TABLE test.facet_table( idd String, id String, date String, store_nbr String, family String, sales String, onpromotion String, city String, state String, type_x String, cluster String, type_y String, locale String, locale_name String, description String, transferred String )ENGINE = S3('https://clickhouse-forghorn.s3.amazonaws.com/facet_table.csv', CSVWithNames)

the endpoint is built with the S3 bucket. please help me.

sandeeppnaik commented 2 years ago

Hi there, I am able to connect using s3 function. Can you make sure the IAM of the EC2 you are on has access to your bucket and the objects ?