Bringing together the Apache Cassandra experts from the community and DataStax.

Want to learn? Have a question? Want to share your expertise? You are in the right place!

Not sure where to begin? Getting Started

 

question

wdeng avatar image
wdeng asked Erick Ramirez edited

cassandra 导入数据好慢怎么办?

cassandra 导入数据好慢。ftp_db.sql 数据文件200G,导入一个晚上没完成,还在进行中,半天又过去了。 同样的数据文件,我用mysql已经导入完成。

data load
10 |1000 characters needed characters left characters exceeded

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.

1 Answer

wdeng avatar image
wdeng answered

可以试一下Datastax的DSE Bulkloader(https://docs.datastax.com/en/dsbulk/doc/dsbulk/install/dsbulkInstall.html)。

这个程序使用最新的DataStax Java CQL Driver,利用了很多driver提供的优化,比你自己写程序用INSERT插入记录或者cqlsh COPY命令要更快。

Share
10 |1000 characters needed characters left characters exceeded

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.