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 84DE51065A for ; Thu, 27 Feb 2014 20:48:33 +0000 (UTC) Received: (qmail 86019 invoked by uid 500); 27 Feb 2014 20:48:29 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 85880 invoked by uid 500); 27 Feb 2014 20:48:28 -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 85773 invoked by uid 99); 27 Feb 2014 20:48:27 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 27 Feb 2014 20:48:27 +0000 X-ASF-Spam-Status: No, hits=1.5 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of winnerdood@gmail.com designates 209.85.213.180 as permitted sender) Received: from [209.85.213.180] (HELO mail-ig0-f180.google.com) (209.85.213.180) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 27 Feb 2014 20:48:21 +0000 Received: by mail-ig0-f180.google.com with SMTP id uq10so5087145igb.1 for ; Thu, 27 Feb 2014 12:48:01 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:date:message-id:subject:from:to:content-type; bh=QLUD7TlbvPcXQCZfebbo3kU9NdU+wC4TFCuUzGNQK6A=; b=WPnPRgcC6HGnt+GDe9qZioQQIDxdDSlbECDrgkOdPN44D3w4EIenxipT6Ijyd2SoP2 lElyPKtJ2qjs0bOwm6H0NZZnLIKlqjJQ05TGwBTsOTbU2T0aAjhupRV2Max4hj0Y+2+J t3IvTRUZlm8nSKW7NzzEO7d5lDmEE0XX7gTkYpsrPsfeO2Pmo4qxkRfn+8j8bvOJeU7r 7n3cNilz0JJcCoQlJP6yJ1Sjh/thg8ashnzkdixUhlABDySmC9SU+OJOLxjAyGmRhRz1 kx/xVWvPFh6g/4eYyNC6AHGnlfNY8+E+J2wZZhUlyBOtFegemU4BDknmeMtYRDoMab2Y iMjw== MIME-Version: 1.0 X-Received: by 10.43.127.200 with SMTP id hb8mr3470837icc.80.1393534081190; Thu, 27 Feb 2014 12:48:01 -0800 (PST) Received: by 10.43.16.1 with HTTP; Thu, 27 Feb 2014 12:48:01 -0800 (PST) Date: Thu, 27 Feb 2014 15:48:01 -0500 Message-ID: Subject: From: Kumar Ranjan To: "user@cassandra.apache.org" Content-Type: multipart/alternative; boundary=001a11c214dee4522004f3696f58 X-Virus-Checked: Checked by ClamAV on apache.org --001a11c214dee4522004f3696f58 Content-Type: text/plain; charset=ISO-8859-1 Hey folks, I am dealing with a legacy CFs where super_column has been used and python client pycassa is being used. An example is given below. My question here is, can I make use of include_timestamp to select data between two returned timestamps e.g between 1393516744591751 and 1393516772131811. This is not exactly timeseries but just selected between two. Please help on this? Data is inserted like this TEST_CF.insert('test_r_key',{'1234': {'key_name_1': 'taf_test_1'}}) Data Fetch: TEST_CF.get('test_r_key', include_timestamp=True) OrderedDict([('1234', OrderedDict([('key_name_1', (u'taf_test_1', 1393451990902345))])), ('1235', OrderedDict([('key_name_2', (u'taf_test_2', 1393516744591751))])), ('1236', OrderedDict([('key_name_3', (u'taf_test_3', 1393516772131782))])) ('1237', OrderedDict([('key_name_4', (u'taf_test_4', 1393516772131799))])) ('1238', OrderedDict([('key_name_5', (u'taf_test_5', 1393516772131811))])) ('1239', OrderedDict([('key_name_6', (u'taf_test_6', 1393516772131854))])) ('1240', OrderedDict([('key_name_7', (u'taf_test_7', 1393516772131899))])) ]) --001a11c214dee4522004f3696f58 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable

Hey folks,

I am dealing with a legacy CFs wh= ere super_column has been used and python client pycassa is being used. An = example is given below. My question here is, can I make use of =A0include_t= imestamp to select data between two returned timestamps e.g between 1393516= 744591751 and 1393516772131811. This is not exactly timeseries but just sel= ected between two. Please help on this?


Data is inserted like this

TEST_CF.insert('test_r_key',{'1234': {'key_name_1= ': 'taf_test_1'}})


Data = Fetch:

TEST_CF.get('test_r_key', include_timestamp=3DTrue)


OrderedDict([('1234', Ordered= Dict([('key_name_1', (u'taf_test_1', 1393451990902345))])),=

=A0=A0 =A0 =A0 =A0 =A0 =A0 ('1235', OrderedDict([(= 9;key_name_2', (u'taf_test_2', 1393516744591751))])),

=A0=A0 =A0 =A0 =A0 =A0 =A0 ('1236', OrderedDict([('key_= name_3', (u'taf_test_3', 1393516772131782))]))

=A0=A0 =A0 =A0 =A0 =A0 =A0 ('1237', OrderedDict([(= 9;key_name_4', (u'taf_test_4', 1393516772131799))]))

=A0=A0 =A0 =A0 =A0 =A0 =A0 ('1238', OrderedDict([('key_n= ame_5', (u'taf_test_5', 1393516772131811))]))

=A0=A0 =A0 =A0 =A0 =A0 =A0 ('1239', OrderedDict([(= 9;key_name_6', (u'taf_test_6', 1393516772131854))]))

=A0=A0 =A0 =A0 =A0 =A0 =A0 ('1240', OrderedDict([('key_n= ame_7', (u'taf_test_7', 1393516772131899))]))

=A0 =A0 =A0 =A0 =A0 =A0=A0])

--001a11c214dee4522004f3696f58--