I believe you can set start to be "ABC_" and finish to be "ABC_\0000" (for
UTF8) to get everything that contains exactly ABC_ and set finish to
"ABC_\FFFF" to get everything that starts with ABC_.  You probably want to
do a simple string comparison test to verify.


On Tue, Aug 2, 2011 at 6:50 PM, Tyler Hobbs <ty...@datastax.com> wrote:

> A minor correction:
>
> To get all columns starting with "ABC_", you would set column_start="ABC_"
> and column_finish="ABC`" (the '`' character comes after '_'), and ignore the
> last column in your results if it happened to be "ABC`".
>
> column_finish, or the "slice end" in other clients, is inclusive.  You
> could of course use "ABC_~" as column_finish and avoid the check if you know
> that you don't have column names like "ABC_~FOO" that you want to include.
>
> On Tue, Aug 2, 2011 at 7:17 PM, aaron morton <aa...@thelastpickle.com>wrote:
>
>> Yup, thats a pretty common pattern. How exactly depends on the client you
>> are using.
>>
>> Say you were using pycassam, you would do a get()
>> http://pycassa.github.com/pycassa/api/pycassa/columnfamily.html#pycassa.columnfamily.ColumnFamily.get
>>
>> with column_start="ABC_" , count to whatever, and column_finish not
>> provided.
>>
>> You can also provide a finish and use the highest encoded character, e.g.
>> ascii 126 is ~ so if you used column_finish = "ABC_~" you would get
>> everything that starts with ABC_
>>
>> Cheers
>>
>>  -----------------
>> Aaron Morton
>> Freelance Cassandra Developer
>> @aaronmorton
>> http://www.thelastpickle.com
>>
>> On 3 Aug 2011, at 09:28, Eldad Yamin wrote:
>>
>> Hello,
>> I wonder if I can select a column or all columns that start with X.
>> E.g I have columns ABC_1, ABC_2, ZZZ_1 and I want to select all columns
>> that start with ABC_ - is that possible?
>>
>>
>>
>> Thanks!
>>
>>
>>
>
>
> --
> Tyler Hobbs
> Software Engineer, DataStax <http://datastax.com/>
> Maintainer of the pycassa <http://github.com/pycassa/pycassa> Cassandra
> Python client library
>
>

Reply via email to