clickhouse-docs icon indicating copy to clipboard operation
clickhouse-docs copied to clipboard

Quick start tutorial is not working as expected with ny taxi data

Open akramh opened this issue 1 year ago • 0 comments

Basically running the query below generates an error. I just tried the quick start tutorial and seems something is not correct with the S3 data format

This only happens when you run the quick start tutorial using the binary https://clickhouse.com/docs/en/getting-started/quick-start

Machine is M2 Mac OSX

Describe the issue

SELECT * FROM s3('https://datasets-documentation.s3.eu-west-3.amazonaws.com/nyc-taxi/trips_*.gz', 'TabSeparatedWithNames') LIMIT 10

Query id: ce94985a-15d6-454c-9481-ecefeebf36f0

Elapsed: 4.750 sec.

Received exception from server (version 24.2.1): Code: 499. DB::Exception: Received from localhost:9000. DB::Exception: Could not list objects in bucket 'datasets-documentation' with prefix 'nyc-taxi/trips_', S3 exception: AccessDenied, message: 'Access Denied'. (S3_ERROR)

Additional context Add any other context about the problem here.

akramh avatar Feb 02 '24 16:02 akramh