Re: HOW TO select a column or all columns that start with X

2011-08-17 Thread Alvin UW
Thanks. it helps. 2011/8/17 Boris Yen > Each compositeType consistes of a few components. Use ("bob", 1982) as an > example, it contains two components, I assume it is (utf8, integer). So when > you want to use a slice query, you need the start and end columns by add > components to them. That i

Re: HOW TO select a column or all columns that start with X

2011-08-17 Thread Boris Yen
Each compositeType consistes of a few components. Use ("bob", 1982) as an example, it contains two components, I assume it is (utf8, integer). So when you want to use a slice query, you need the start and end columns by add components to them. That is what start.addCompo and end.addCompo... mea

Re: HOW TO select a column or all columns that start with X

2011-08-16 Thread Alvin UW
Hello, can anyone give an explanation of start.addComponent("abc", StringSerializer.get()) ; end.addComponent("abc", StringSerializer.get(), "UTF8Type", AbstractComposite.ComponentEquality.GREATER_THAN_EQUAL) ; Suppose my composite column names are like ("bob", 1982), ("bob", 1976). There are m

Re: HOW TO select a column or all columns that start with X

2011-08-04 Thread Boris Yen
Assume you have a column family named "testCF" with comparator * CompositeType*(AsciiType, IntegerType(reversed=true), IntegerType); and a few columns have been inserted into record key "a". Composite start = new Composite() ; Composite end = new Composite() ;

Re: HOW TO select a column or all columns that start with X

2011-08-04 Thread Benoit Perroud
https://github.com/edanuff/CassandraIndexedCollections 2011/8/4 CASSANDRA learner : > Can you please gimme an example on this using hector client > > On Thu, Aug 4, 2011 at 7:18 AM, Boris Yen wrote: >> >> It seems to me that your column name consists of two components. If you >> have the luxury t

Re: HOW TO select a column or all columns that start with X

2011-08-04 Thread CASSANDRA learner
Can you please gimme an example on this using hector client On Thu, Aug 4, 2011 at 7:18 AM, Boris Yen wrote: > It seems to me that your column name consists of two components. If you > have the luxury to upgrade your cassandra to 0.8.1+, I think you can think > about using the composite type/col

Re: HOW TO select a column or all columns that start with X

2011-08-03 Thread Boris Yen
It seems to me that your column name consists of two components. If you have the luxury to upgrade your cassandra to 0.8.1+, I think you can think about using the composite type/column. Conceptually, it might suit your use case better. On Wed, Aug 3, 2011 at 5:28 AM, Eldad Yamin wrote: > Hello,

Re: HOW TO select a column or all columns that start with X

2011-08-03 Thread Ed Anuff
I believe you can set start to be "ABC_" and finish to be "ABC_\" (for UTF8) to get everything that contains exactly ABC_ and set finish to "ABC_\" 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,

Re: HOW TO select a column or all columns that start with X

2011-08-03 Thread Eldad Yamin
Thanks! On Wed, Aug 3, 2011 at 3:03 PM, aaron morton wrote: > and AsciiType > > > - > Aaron Morton > Freelance Cassandra Developer > @aaronmorton > http://www.thelastpickle.com > > On 3 Aug 2011, at 16:35, eldad87 wrote: > > Thank you! > Will this situation work only for UTF8Type

Re: HOW TO select a column or all columns that start with X

2011-08-03 Thread aaron morton
and AsciiType - Aaron Morton Freelance Cassandra Developer @aaronmorton http://www.thelastpickle.com On 3 Aug 2011, at 16:35, eldad87 wrote: > Thank you! > Will this situation work only for UTF8Type comparator? > > > On Wed, Aug 3, 2011 at 4:50 AM, Tyler Hobbs wrote: > A mino

Re: HOW TO select a column or all columns that start with X

2011-08-02 Thread eldad87
Thank you! Will this situation work only for UTF8Type comparator? On Wed, Aug 3, 2011 at 4:50 AM, Tyler Hobbs 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 th

Re: HOW TO select a column or all columns that start with X

2011-08-02 Thread Tyler Hobbs
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. Y

Re: HOW TO select a column or all columns that start with X

2011-08-02 Thread aaron morton
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_

HOW TO select a column or all columns that start with X

2011-08-02 Thread Eldad Yamin
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!