I have insert to s3 6bil rows table:

INSERT INTO FUNCTION
s3('https://s3.us-east-1.amazonaws.com/my-bucket/data.csv', 'DFGHJ', 'FGHJIJH, 'CSVWithNames', 'time DateTime, exchangeId UInt16, pairId UInt16, id String, price Decimal(38, 18), volume Decimal(38, 18)')
SELECT * FROM trade;

but it fails trying to upload part 10001 while aws s3 upload supports only 10k parts.

I had to export this select into CSV 600GB file on the disk and then perform successful aws s3 cp data.csv s3://my-bucket/data.csv

I expected Clickhouse would do it on his own successfully.

┌─version()─┐
│ 22.1.3.7 │
└───────────┘