You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@cassandra.apache.org by tom <zs...@gmail.com> on 2015/02/10 02:38:20 UTC
about "insert into table with IF NOT EXISTS" error
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
Posted by 严超 <ya...@gmail.com>.
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 <zs...@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
Posted by 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 <zs...@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