From user-return-34693-apmail-cassandra-user-archive=cassandra.apache.org@cassandra.apache.org Wed Jun 19 09:41:33 2013 Return-Path: X-Original-To: apmail-cassandra-user-archive@www.apache.org Delivered-To: apmail-cassandra-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 2502DC15C for ; Wed, 19 Jun 2013 09:41:33 +0000 (UTC) Received: (qmail 9167 invoked by uid 500); 19 Jun 2013 09:41:30 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 9148 invoked by uid 500); 19 Jun 2013 09:41:30 -0000 Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@cassandra.apache.org Delivered-To: mailing list user@cassandra.apache.org Received: (qmail 9138 invoked by uid 99); 19 Jun 2013 09:41:29 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 19 Jun 2013 09:41:29 +0000 X-ASF-Spam-Status: No, hits=2.2 required=5.0 tests=HTML_MESSAGE,SPF_PASS,T_FILL_THIS_FORM_SHORT X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: local policy) Received: from [203.199.18.84] (HELO mail1.impetus.co.in) (203.199.18.84) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 19 Jun 2013 09:41:22 +0000 Received: from MAIL3.impetus.co.in ([fe80::443f:4f25:6889:b268]) by mail1.impetus.co.in ([fe80::4c95:4ec3:183e:2d3%15]) with mapi id 14.02.0318.004; Wed, 19 Jun 2013 15:10:59 +0530 From: Amresh Kumar Singh To: "user@cassandra.apache.org" Subject: TTL can't be speciefied at column level using CQL 3 in Cassandra 1.2.x Thread-Topic: TTL can't be speciefied at column level using CQL 3 in Cassandra 1.2.x Thread-Index: Ac5s0RpWJzJnN70TT/emVK9mkSKZvw== Date: Wed, 19 Jun 2013 09:40:58 +0000 Message-ID: <8645D40887F5104F9B94D1AC7A3D1FA5DB1CFE03@Mail3.impetus.co.in> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [192.168.145.66] Content-Type: multipart/alternative; boundary="_000_8645D40887F5104F9B94D1AC7A3D1FA5DB1CFE03Mail3impetuscoi_" MIME-Version: 1.0 X-Virus-Checked: Checked by ClamAV on apache.org --_000_8645D40887F5104F9B94D1AC7A3D1FA5DB1CFE03Mail3impetuscoi_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi, Using Thrift, we are allowed to specify different TTL values for each colum= ns in a row. But CQL3 doesn't provide a way for this. For instance, this is allowed: INSERT INTO users (user_name, password, gender, state) VALUES ('xamry2, 'a= aaaaa', 'm', 'UP') using TTL 50000; But something like this is not achievable: INSERT INTO users (user_name, password, gender, state) VALUES ('xamry' usi= ng TTL 33333, 'aaaaaa' using TTL 4444, 'm' using TTL 1111, 'UP' using TTL 6= 666); Why is such inconsistency. Should we not be able to achieve this using CQL = looking at the fact that CQL usage is encouraged as a replacement for Thrif= t. Sincerely, Amresh ________________________________ NOTE: This message may contain information that is confidential, proprietar= y, privileged or otherwise protected by law. The message is intended solely= for the named addressee. If received in error, please destroy and notify t= he sender. Any use of this email is prohibited when received in error. Impe= tus does not represent, warrant and/or guarantee, that the integrity of thi= s communication has been maintained nor that the communication is free of e= rrors, virus, interception or interference. --_000_8645D40887F5104F9B94D1AC7A3D1FA5DB1CFE03Mail3impetuscoi_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hi,

Using Thrift, we are allowed to specify different TTL values for each colum= ns in a row.

But CQL3 doesn't provide a way for this.

For instance, this is allowed:
INSERT INTO users (user_name, password, gender, state)  VALUES ('xamry= 2, 'aaaaaa', 'm', 'UP') using TTL 50000;

But something like this is not achievable:
INSERT INTO users (user_name, password, gender, state)  VALUES ('xamry= ' using TTL 33333, 'aaaaaa' using TTL 4444, 'm' using TTL 1111, 'UP' using = TTL 6666);


Why is such inconsistency. Should we not be able to achieve this using CQL = looking at the fact that CQL usage is encouraged as a replacement for Thrif= t.

Sincerely,
Amresh









NOTE: This message may contain information that is confidential, proprietar= y, privileged or otherwise protected by law. The message is intended solely= for the named addressee. If received in error, please destroy and notify t= he sender. Any use of this email is prohibited when received in error. Impetus does not represent, warrant = and/or guarantee, that the integrity of this communication has been maintai= ned nor that the communication is free of errors, virus, interception or in= terference.
--_000_8645D40887F5104F9B94D1AC7A3D1FA5DB1CFE03Mail3impetuscoi_--