about insert into table with IF NOT EXISTS error

2015-02-09 Thread tom 
Hi:

  I setup one node cassandra server, and using node.js driver cql to query
db.

  But, when insert into table with IF NOT EXISTS statement, it report
error as below:

:ResponseError: Cannot achieve consistency level QUORUM

And, I try set nodejs cql query with consistency to ONE, still see that
error.

If I remove  IF NOT EXISTS from cql, insert passed.

 Please advice. thx.

best regards
  Tom

Re: about insert into table with IF NOT EXISTS error

2015-02-09 Thread Alex Popescu 
Tom, this question would have better chances to be answered on the Node.js
driver mailing list
https://groups.google.com/a/lists.datastax.com/forum/#!forum/nodejs-driver-user

On Mon, Feb 9, 2015 at 5:38 PM, tom zs68j...@gmail.com wrote:

 Hi:

   I setup one node cassandra server, and using node.js driver cql to query
 db.

   But, when insert into table with IF NOT EXISTS statement, it report
 error as below:

 :ResponseError: Cannot achieve consistency level QUORUM

 And, I try set nodejs cql query with consistency to ONE, still see that
 error.

 If I remove  IF NOT EXISTS from cql, insert passed.

  Please advice. thx.

 best regards
   Tom




-- 

[:-a)

Alex Popescu
Sen. Product Manager @ DataStax
@al3xandru

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
https://twitter.com/yanchao727*


*My Weibo：http://weibo.com/herewearenow
http://weibo.com/herewearenow--*

2015-02-10 9:52 GMT+08:00 Alex Popescu al...@datastax.com:

 Tom, this question would have better chances to be answered on the Node.js
 driver mailing list
 https://groups.google.com/a/lists.datastax.com/forum/#!forum/nodejs-driver-user

 On Mon, Feb 9, 2015 at 5:38 PM, tom zs68j...@gmail.com wrote:

 Hi:

   I setup one node cassandra server, and using node.js driver cql to
 query db.

   But, when insert into table with IF NOT EXISTS statement, it report
 error as below:

 :ResponseError: Cannot achieve consistency level QUORUM

 And, I try set nodejs cql query with consistency to ONE, still see that
 error.

 If I remove  IF NOT EXISTS from cql, insert passed.

  Please advice. thx.

 best regards
   Tom




 --

 [:-a)

 Alex Popescu
 Sen. Product Manager @ DataStax
 @al3xandru