Return-Path: Delivered-To: apmail-incubator-cassandra-user-archive@minotaur.apache.org Received: (qmail 92761 invoked from network); 7 Jul 2009 13:20:15 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 7 Jul 2009 13:20:15 -0000 Received: (qmail 94386 invoked by uid 500); 7 Jul 2009 13:20:26 -0000 Delivered-To: apmail-incubator-cassandra-user-archive@incubator.apache.org Received: (qmail 94371 invoked by uid 500); 7 Jul 2009 13:20:25 -0000 Mailing-List: contact cassandra-user-help@incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: cassandra-user@incubator.apache.org Delivered-To: mailing list cassandra-user@incubator.apache.org Received: (qmail 94362 invoked by uid 99); 7 Jul 2009 13:20:25 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 07 Jul 2009 13:20:25 +0000 X-ASF-Spam-Status: No, hits=2.2 required=10.0 tests=HTML_MESSAGE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of kevincastiglione@gmail.com designates 209.85.221.178 as permitted sender) Received: from [209.85.221.178] (HELO mail-qy0-f178.google.com) (209.85.221.178) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 07 Jul 2009 13:20:16 +0000 Received: by qyk8 with SMTP id 8so4964166qyk.32 for ; Tue, 07 Jul 2009 06:19:55 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :from:date:message-id:subject:to:content-type; bh=Ql9dkKJkBqfwLD7ikHq5AChmCdDAwQ9U2e/6+G//F7Q=; b=dzq/pZG4xhVUUuqJTcK1nBTVvFQUpHP9kt6BOWMzYGlma8muxWdNP1EF4xh+OGYLXm XMX6nUnBivaHUjrkpL+qL+n6AGtOIWGa34LgvuwxglH3ISqcyHnLI1kPMRkRQAQUhn1Y ZCNZCwwXVod4N7NqV/qwyg7+X4LA8r999mHBM= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :content-type; b=sQmCTxaLjhC/BP8QS8S9OapH1T4S6Gfe+9NLm3PxIktJieGk7o2ieWkR/sWLrpTxCP Hs2c/Bh2dTyxHAHKK+iHVGlNZVnEaSJOEyBgCsMhyaFIeyeV8TY/0k2xOFO07AbTWr1P ghmNEu94Fr9XS7DGE00l8U6Bf1mFUUtwceT54= MIME-Version: 1.0 Received: by 10.229.79.17 with SMTP id n17mr3086155qck.82.1246972791021; Tue, 07 Jul 2009 06:19:51 -0700 (PDT) In-Reply-To: References: From: Kevin Castiglione Date: Tue, 7 Jul 2009 06:19:28 -0700 Message-ID: Subject: Re: problems with python client To: cassandra-user@incubator.apache.org Content-Type: multipart/alternative; boundary=0016364ee4a84109ee046e1d7a00 X-Virus-Checked: Checked by ClamAV on apache.org --0016364ee4a84109ee046e1d7a00 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit thanks a lot for this! it works. can you pl. explain what start, finish, isAscending are? also the value i pass to offset gets passed to cassandra as limit, is this expected? >>> client.get_slice(tablename='Table1', key='1', columnParent='Standard1', start='', finish='', isAscending=True, offset=-1, count=1000) [column_t(columnName='age', value='24', timestamp=1246942866), column_t(columnName='name', value='Chris Goffinet', timestamp=1246943353)] DEBUG - weakreadlocal reading SliceFromReadCommand(table='Table1', key='1', columnFamily='Standard1', isAscending='true', limit='-1', count='1000') On Tue, Jul 7, 2009 at 6:12 AM, Jonathan Ellis wrote: > you want > > start='' > finish='' > offset=0 > > On Tue, Jul 7, 2009 at 8:01 AM, Kevin > Castiglione wrote: > > i have inserted a row into the table Table1 and Standard1 column family. > And > > this works with the cassandra-cli > > > > cassandra> get Table1.Standard1['1'] > > COLUMN_TIMESTAMP = 1246942866; COLUMN_VALUE = 24; COLUMN_KEY = age; > > COLUMN_TIMESTAMP = 1246943353; COLUMN_VALUE = Chris Goffinet; COLUMN_KEY > = > > name; > > Statement processed. > > > > > > but if i try to get this data using the python client I get an empty > list: > >>>> client.get_slice(tablename='Table1', key='1', > columnParent='Standard1', > >>>> start='0', finish='100', isAscending=True, offset=-1, count=1000) > > [ ] > > > > this is the output from cassandra > > DEBUG - weakreadlocal reading SliceFromReadCommand(table='Table1', > key='1', > > columnFamily='Standard1', isAscending='true', limit='-1', count='1000') > > DEBUG - clearing > > > > > > also notice that the argument 'offset' in the python client is actually > > passed to cassandra as 'limit'. > > > > > > is there something im missing here? > > thanks > > > --0016364ee4a84109ee046e1d7a00 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable thanks a lot for this! it works.
can you pl. explain what start, finish,= isAscending are?


also the value i pass to offset gets passed to= cassandra as limit, is this expected?


>>> client.get_s= lice(tablename=3D'Table1', key=3D'1', columnParent=3D'S= tandard1', start=3D'', finish=3D'', isAscending=3DTrue,= offset=3D-1, count=3D1000)
[column_t(columnName=3D'age', value=3D'24', timestamp=3D124= 6942866), column_t(columnName=3D'name', value=3D'Chris Goffinet= ', timestamp=3D1246943353)]

DEBUG - weakreadlocal reading SliceF= romReadCommand(table=3D'Table1', key=3D'1', columnFamily=3D= 'Standard1', isAscending=3D'true', limit=3D'-1', co= unt=3D'1000')



On Tue, Jul 7, 2009 at 6:12 AM, Jona= than Ellis <jbell= is@gmail.com> wrote:
you want

start=3D''
finish=3D''
offset=3D0

On Tue, Jul 7, 2009 at 8:01 AM, Kevin
Castiglione<kevincastiglio= ne@gmail.com> wrote:
> i have inserted a row into the table Table1 and Standard1 column famil= y. And
> this works with the cassandra-cli
>
> cassandra> get Table1.Standard1['1']
> COLUMN_TIMESTAMP =3D 1246942866; COLUMN_VALUE =3D 24; COLUMN_KEY =3D a= ge;
> COLUMN_TIMESTAMP =3D 1246943353; COLUMN_VALUE =3D Chris Goffinet; COLU= MN_KEY =3D
> name;
> Statement processed.
>
>
> but if i try to get this data using the python client I get an empty l= ist:
>>>> client.get_slice(tablename=3D'Table1', key=3D'= 1', columnParent=3D'Standard1',
>>>> start=3D'0', finish=3D'100', isAscending= =3DTrue, offset=3D-1, count=3D1000)
> [ ]
>
> this is the output from cassandra
> DEBUG - weakreadlocal reading SliceFromReadCommand(table=3D'Table1= ', key=3D'1',
> columnFamily=3D'Standard1', isAscending=3D'true', limi= t=3D'-1', count=3D'1000')
> DEBUG - clearing
>
>
> also notice that the argument 'offset' in the python client is= actually
> passed to cassandra as 'limit'.
>
>
> is there something im missing here?
> thanks
>

--0016364ee4a84109ee046e1d7a00--