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

[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  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

[严超]

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 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  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
>