Re: about "insert into table with IF NOT EXISTS" error

2015-02-09 Thread
How about delete the previous inserted lines? Then, insert it again? *Best Regards!* *Chao Yan--**My twitter:Andy Yan @yanchao727 * *My Weibo:http://weibo.com/herewearenow --* 2015-02-10 9:52 GMT+08:00 Alex

Re: Compaction failing to trigger

2015-01-18 Thread
Seems like Size Tier Compaction is based on table, which table did you set the compaction strategy? A minor compaction does not involve all the tables in a keyspace. Ref: http://datastax.com/documentation/cassandra/2.0/cassandra/operations/ops_configure_compaction_t.html http://datastax.com/documen

Re: Which files should I backup for data restoring/data migration?

2015-01-18 Thread
Check out this doc, I think it may help you: http://www.datastax.com/documentation/cassandra/2.0/cassandra/operations/ops_backup_restore_c.html *Best Regards!* *Chao Yan--**My twitter:Andy Yan @yanchao727 * *My Weibo:http://weibo.com/herewearenow

Re: [Cassandra] [Generation of SStableLoader slow]

2014-12-24 Thread
amazingly strange here, you don't have a lot > of RAM, nor CPU and I'm assuming the underlying disk is slow here as well. > Without more parameters and details it's hard to define if there is an > issue. > > On Dec 24, 2014 7:36 AM, "严超" wrote: &g

[Cassandra] [Generation of SStableLoader slow]

2014-12-24 Thread
Hi, Everyone: I'm importing a CSV file into Cassandra using SStableLoader. And I'm following the example here: https://github.com/yukim/cassandra-bulkload-example/ But, Even though the streaming of SSTables is very fast , I find that generation of SStables is quite slow for very large files (CSV,

Re: [Cassandra][SStableLoader Out of Heap Memory]

2014-12-10 Thread
ewearenow>--* 2014-12-10 20:24 GMT+08:00 严超 : > Thank you very much. > My version is 2.0.11. I'll have a try. > > *Best Regards!* > > > *Chao Yan--**My twitter:Andy Yan @yanchao727 > <https://twitter.com/yanchao727>* > > > *My

Re: [Cassandra][SStableLoader Out of Heap Memory]

2014-12-10 Thread
2.1 I was able load successfully even with all generated files (e.g. > .Filter etc) in the target directory. > > Rory > > > On Wed, Dec 10, 2014, 12:58 AM 严超 wrote: > >> Hi, Everyone: >> I'm importing a CSV file into Cassandra using SStableLoader. And

[Cassandra][SStableLoader Out of Heap Memory]

2014-12-09 Thread
Hi, Everyone: I'm importing a CSV file into Cassandra using SStableLoader. And I'm following the example here: https://github.com/yukim/cassandra-bulkload-example/ When i try to run the sstableloader, it fails with OOM. I also changed the sstableloader.sh script (that runs t

Re: [Import csv to Cassandra] Taking too much time

2014-12-04 Thread
ot developed for performing such heavy operations instead try > using SSTableLoader to import. > > > Best Regards > Akshay > > > > From:严超 > To:user@cassandra.apache.org > Date:12/04/2014 02:11 PM > Subject:[Import csv to Cassandra] T

[Import csv to Cassandra] Taking too much time

2014-12-04 Thread
Hi, Everyone: I'm importing a CSV file into Cassandra, and it always get error:"Request did not complete within rpc_timeout ", then I have to continue my COPY command of cql again. And the CSV file is 2.2 G . It is taking a long time. How can I speed up csv file importing ? Is there