Return-Path: X-Original-To: apmail-cassandra-commits-archive@www.apache.org Delivered-To: apmail-cassandra-commits-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 019E410B39 for ; Mon, 18 Nov 2013 19:21:22 +0000 (UTC) Received: (qmail 29139 invoked by uid 500); 18 Nov 2013 19:21:21 -0000 Delivered-To: apmail-cassandra-commits-archive@cassandra.apache.org Received: (qmail 29118 invoked by uid 500); 18 Nov 2013 19:21:21 -0000 Mailing-List: contact commits-help@cassandra.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@cassandra.apache.org Delivered-To: mailing list commits@cassandra.apache.org Received: (qmail 29109 invoked by uid 99); 18 Nov 2013 19:21:21 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 18 Nov 2013 19:21:21 +0000 Date: Mon, 18 Nov 2013 19:21:21 +0000 (UTC) From: "Alex Liu (JIRA)" To: commits@cassandra.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Commented] (CASSANDRA-5892) Support user defined where clause in cluster columns for CqlPagingRecordRead MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/CASSANDRA-5892?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13825646#comment-13825646 ] Alex Liu commented on CASSANDRA-5892: ------------------------------------- This is auto-fixed in CASSANDRA-6311 which will be in C* 2.x release > Support user defined where clause in cluster columns for CqlPagingRecordRead > ---------------------------------------------------------------------------- > > Key: CASSANDRA-5892 > URL: https://issues.apache.org/jira/browse/CASSANDRA-5892 > Project: Cassandra > Issue Type: Bug > Components: Hadoop > Reporter: Adam Masters > Assignee: Alex Liu > Priority: Minor > Fix For: 2.0.3 > > Attachments: 5892-1.2-branch.txt, 5892-v2-1.2-branch.txt > > > When using CqlPagingRecordReader, specifying a custom where clause using CqlConfigHelper.setInputWhereClauses() throws an exception when a GT (>) comparator is used. > Exception: > java.lang.RuntimeException at org.apache.cassandra.hadoop.cql3.CqlPagingRecordReader$RowIterator.executeQuery(CqlPagingRecordReader.java:646) Caused by: InvalidRequestException(why:Invalid restrictions found on ts) at org.apache.cassandra.thrift.Cassandra$prepare_cql3_query_result.read(Cassandra.java:39567) > This is due to the paging mechanism inserting a GT comparator on the same composite key as the custom where clause, resulting in an invalid CQL statement. For example ("ts > '634926385000000000'" being the custom where clause): > SELECT * FROM "test_cf" > WHERE token("key") = token( ? ) AND "ts" > ? > AND ts > '634926385000000000' LIMIT 3 ALLOW FILTERING -- This message was sent by Atlassian JIRA (v6.1#6144)