DataStax Academy FAQ

DataStax Academy migrated to a new learning management system (LMS) in July 2020. We are also moving to a new Cassandra Certification process so there are changes to exam bookings, voucher system and issuing of certificates.

Check out the Academy FAQ pages for answers to your questions:


question

wdeng avatar image
wdeng asked ·

cassandra 导入数据好慢怎么办?

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

import data
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.