官网资料:
https://docs.datastax.com/en/cql/3.3/cql/cql_reference/cqlshCopy.html
数据文件
可以是任意分隔符文件,带表头不带表头均可,这里带表头了
- test.file:
c1|c2|c3|value
1|1|1|a
2|2|2|a
建表
-
创建表空间
CREATE KEYSPACE myks WITH REPLICATION = { ‘class’ : ‘SimpleStrategy’, ‘replication_factor’ : 1 }; -
建表
create table mytable(c1 int,c2 int,c3 int,value text, primary key(c1,c2,c3));
数据导入
语法:
COPY table_name [( column_list )]
FROM 'file_name'[, 'file2_name', ...] | STDIN
[WITH option = 'value' [AND ...]]
示例:
copy myks.mytable from '/path/to/test.file' with delimiter='|' and header=true;
输出ÿ