By default in CASSANDRA , consistency level is one for all R/W operations. But when I am trying to import data into table via CSV I get this error :
Failed to import 7 rows: InvalidRequest - Error from server: code=2200 [Invalid query] message="Provided value ONE is not allowed for Write Consistency Level (disallowed values are: [ANY, ONE, LOCAL_ONE])"
why this level is not allowed ?
because when i set consistency as QUOROUM it worked for me. but why not with default consistency?
@pranali.khanna101994_189965 Can you please provide more information - what version of Cassandra are you running and how are you getting this error?
Please refer to the steps where it works.
@pranali.khanna101994_189965 DataStax Astra databases include guardrails that enforce best practices so new and experienced developers are off to a good start when using Apache Cassandra.
One of those best practices is to use a strong consistency level when writing data. The recommendation is to use LOCAL_QUORUM or QUORUM to mitigate against data loss in the event of a replica being unavailable.
For more information, see the DataStax Astra documentation. Cheers!
7 People are following this question.
