You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@cassandra.apache.org by Tyler Hobbs <ty...@datastax.com> on 2014/02/28 20:13:00 UTC
Re:
Can you clarify exactly what you need help with? It seems like you already
know how to fetch the timestamps. Are you just looking for python code to
filter data that's not in a time range?
By the way, there's a pycassa-specific mailing list here:
https://groups.google.com/forum/#!forum/pycassa-discuss
On Thu, Feb 27, 2014 at 2:48 PM, Kumar Ranjan <wi...@gmail.com> wrote:
> 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))]))
>
> ])
>
--
Tyler Hobbs
DataStax <http://datastax.com/>
Re:
Posted by Kumar Ranjan <wi...@gmail.com>.
Thanks Tyler. Yes, I scanned through pycassaShell code couple of times but
did not find anything like that.
On Fri, Feb 28, 2014 at 3:24 PM, Tyler Hobbs <ty...@datastax.com> wrote:
> No, pycassa won't do anything fancy with timestamps automatically, you'll
> have to keep doing yourself.
>
>
> On Fri, Feb 28, 2014 at 1:28 PM, Kumar Ranjan <wi...@gmail.com>wrote:
>
>> Yes, filter out based on time range. Currently i do this in python . Just
>> curious to see if this can be done using pycassa somehow?
>> --
>> Sent from Mailbox <https://www.dropbox.com/mailbox> for iPhone
>>
>>
>> On Fri, Feb 28, 2014 at 2:13 PM, Tyler Hobbs <ty...@datastax.com> wrote:
>>
>>> Can you clarify exactly what you need help with? It seems like you
>>> already know how to fetch the timestamps. Are you just looking for python
>>> code to filter data that's not in a time range?
>>>
>>> By the way, there's a pycassa-specific mailing list here:
>>> https://groups.google.com/forum/#!forum/pycassa-discuss
>>>
>>>
>>> On Thu, Feb 27, 2014 at 2:48 PM, Kumar Ranjan <wi...@gmail.com>wrote:
>>>
>>>> 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))]))
>>>>
>>>> ])
>>>>
>>>
>>>
>>>
>>> --
>>> Tyler Hobbs
>>> DataStax <http://datastax.com/>
>>>
>>
>>
>
>
> --
> Tyler Hobbs
> DataStax <http://datastax.com/>
>
Re:
Posted by Tyler Hobbs <ty...@datastax.com>.
No, pycassa won't do anything fancy with timestamps automatically, you'll
have to keep doing yourself.
On Fri, Feb 28, 2014 at 1:28 PM, Kumar Ranjan <wi...@gmail.com> wrote:
> Yes, filter out based on time range. Currently i do this in python . Just
> curious to see if this can be done using pycassa somehow?
> --
> Sent from Mailbox <https://www.dropbox.com/mailbox> for iPhone
>
>
> On Fri, Feb 28, 2014 at 2:13 PM, Tyler Hobbs <ty...@datastax.com> wrote:
>
>> Can you clarify exactly what you need help with? It seems like you
>> already know how to fetch the timestamps. Are you just looking for python
>> code to filter data that's not in a time range?
>>
>> By the way, there's a pycassa-specific mailing list here:
>> https://groups.google.com/forum/#!forum/pycassa-discuss
>>
>>
>> On Thu, Feb 27, 2014 at 2:48 PM, Kumar Ranjan <wi...@gmail.com>wrote:
>>
>>> 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))]))
>>>
>>> ])
>>>
>>
>>
>>
>> --
>> Tyler Hobbs
>> DataStax <http://datastax.com/>
>>
>
>
--
Tyler Hobbs
DataStax <http://datastax.com/>
Re:
Posted by Kumar Ranjan <wi...@gmail.com>.
Yes, filter out based on time range. Currently i do this in python . Just curious to see if this can be done using pycassa somehow?—
Sent from Mailbox for iPhone
On Fri, Feb 28, 2014 at 2:13 PM, Tyler Hobbs <ty...@datastax.com> wrote:
> Can you clarify exactly what you need help with? It seems like you already
> know how to fetch the timestamps. Are you just looking for python code to
> filter data that's not in a time range?
> By the way, there's a pycassa-specific mailing list here:
> https://groups.google.com/forum/#!forum/pycassa-discuss
> On Thu, Feb 27, 2014 at 2:48 PM, Kumar Ranjan <wi...@gmail.com> wrote:
>> 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))]))
>>
>> ])
>>
> --
> Tyler Hobbs
> DataStax <http://datastax.com/>