Help Center/
MapReduce Service/
Component Operation Guide (LTS)/
Using ClickHouse/
ClickHouse FAQ/
How Do I Migrate Data from OBS/S3 to ClickHouse?
Updated on 2024-05-29 GMT+08:00
How Do I Migrate Data from OBS/S3 to ClickHouse?
Question
How do I migrate data from OBS/S3 to ClickHouse?
Answer
- Query data stored in S3.
select * from s3(path [,aws_access_key_id, aws_secret_access_key] [,format] [,structure])
Parameter description:
- path: The bucket URL with a file path.
- format: The file format.
- aws_access_key_id and aws_secret_access_key: Long-term credentials of an AWS account. Credentials can be used to authenticate requests. These parameter are optional. If no credential is specified, credentials are read from the configuration file.
- structure: The table schema.
- ClickHouse obtains data from S3 to create a table.
CREATE TABLE test1_s3 (name String, value UInt32) ENGINE = S3(path, [aws_access_key_id, aws_secret_access_key,] format)
- View the created table.
Parent topic: ClickHouse FAQ
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
The system is busy. Please try again later.
For any further questions, feel free to contact us through the chatbot.
Chatbot