Mailing-List: contact commits-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@cassandra.apache.org
Date: Thu, 23 Apr 2015 18:08:38 +0000 (UTC)
From: "Carl Yeksigian (JIRA)" <jira@apache.org>
To: commits@cassandra.apache.org
Message-ID: <JIRA.12745776.1412357277000.9173.1429812518766@Atlassian.JIRA>
In-Reply-To: <JIRA.12745776.1412357277000@Atlassian.JIRA>
References: <JIRA.12745776.1412357277000@Atlassian.JIRA>
 <JIRA.12745776.1412357277197@arcas>
Subject: [jira] [Commented] (CASSANDRA-8051) Add SERIAL and LOCAL_SERIAL
 consistency levels to cqlsh
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


    [ https://issues.apache.org/jira/browse/CASSANDRA-8051?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14509481#comment-14509481 ] 

Carl Yeksigian commented on CASSANDRA-8051:
-------------------------------------------

[~Stefania]: I agree that we should consider dropping {{SERIAL}}/{{LOCAL_SERIAL}} for selects, but I think we should create a separate ticket for that, as it will affect more than just cqlsh.

> Add SERIAL and LOCAL_SERIAL consistency levels to cqlsh
> -------------------------------------------------------
>
>                 Key: CASSANDRA-8051
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-8051
>             Project: Cassandra
>          Issue Type: Bug
>          Components: Tools
>            Reporter: Nicolas Favre-Felix
>            Assignee: Carl Yeksigian
>            Priority: Minor
>              Labels: cqlsh
>             Fix For: 2.0.15
>
>         Attachments: 8051-2.0.txt, 8051-2.1.txt, log-statements-2.0.txt, log-statements-2.1.txt, python-driver-fix.txt
>
>
> cqlsh does not support setting the serial consistency level. The default CL.SERIAL does not let users safely execute LWT alongside an app that runs at LOCAL_SERIAL, and can prevent any LWT from running when a DC is down (e.g. with 2 DCs, RF=3 in each.)
> Implementing this well is a bit tricky. A user setting the serial CL will probably not want all of their statements to have a serial CL attached, but only the conditional updates. At the same time it would be useful to support serial reads. "WITH CONSISTENCY LEVEL" used to provide this flexibility.
> I believe that it is currently impossible to run a SELECT at SERIAL or LOCAL_SERIAL; the only workaround seems to be to run a conditional update with a predicate that always resolves to False, and to rely on the CAS response to read the data.


--
This message was sent by Atlassian JIRA
(v6.3.4#6332)