产品概述
基本概念
集群架构
产品优势
应用场景
CREATE TABLE cos_engine_table(`int_id` UInt32)ENGINE = S3('http://clickhouse-xxx.myqcloud.com/clickhouse-xxx/cos/data.csv.gz', 'CSV', 'gzip')
CREATE TABLE test.test on cluster default_cluster(`int_id` UInt32)engine = MergeTree()order by int_id;
- 如果您的集群是双副本版：
create table test.test on cluster default_cluster(`int_id` UInt32)engine = ReplicatedMergeTree('/clickhouse/tables/test/test/{shard}', '{replica}')order by int_id;
- 创建分布式表：
create table test.test_dis on cluster default_clusterAS test.testengine = Distributed('default_cluster', 'test', 'test', rand());
INSERT INTO test.test SELECT * FROM cos_engine_table;
select * from test.test
文档反馈