Re: quick question about super columns

2011-01-08 Thread Rajkumar Gupta
Thanks. got it! On Sat, Jan 8, 2011 at 9:44 PM, Tyler Hobbs wrote: > A couple of alternatives off the top of my head: > > 1) A row of supercolumns becomes a row of standard columns with compound > column names. > > 2) A row of N supercolumns becomes N rows of standard columns (with compound > key

Re: quick question about super columns

2011-01-08 Thread Tyler Hobbs
A couple of alternatives off the top of my head: 1) A row of supercolumns becomes a row of standard columns with compound column names. 2) A row of N supercolumns becomes N rows of standard columns (with compound keys if needed); a separate timeline or index replaces the super column names. Ther

Re: quick question about super columns

2011-01-08 Thread Rajkumar Gupta
Thanks Tyler & Stu, Tyler, as the alternatives for large no of subcolumns in a supercolumn, what do you suggest ? Like splitting up a 'supercolumnFamily' into several 'columnfamilies' ?? What else ? On Sat, Jan 8, 2011 at 2:33 PM, Stu Hood wrote: > Raj: the super column indexing is a longstandi

Re: quick question about super columns

2011-01-08 Thread Stu Hood
Raj: the super column indexing is a longstanding issue that we've been considering recently, and would like to fix. See https://issues.apache.org/jira/browse/CASSANDRA-674 On Fri, Jan 7, 2011 at 10:53 PM, Tyler Hobbs wrote: > Not that I'm aware of. There are several other decent alternatives to

Re: quick question about super columns

2011-01-07 Thread Tyler Hobbs
Not that I'm aware of. There are several other decent alternatives to large amounts of subcolumns in a supercolumn, so I don't think it's a high priority. - Tyler On Fri, Jan 7, 2011 at 9:59 PM, Rajkumar Gupta wrote: > Hey Tyler, > > Is this limitation of supercolumns going to be removed anytim

Re: quick question about super columns

2011-01-07 Thread Rajkumar Gupta
Hey Tyler, Is this limitation of supercolumns going to be removed anytime sooner ? Raj On Fri, Jan 7, 2011 at 8:51 PM, Tyler Hobbs wrote: > An important bit to read about supercolumn limitations: > http://www.riptano.com/docs/0.6/data_model/supercolumns#limitations > > Don't make supercolumns w

Re: quick question about super columns

2011-01-07 Thread Tyler Hobbs
An important bit to read about supercolumn limitations: http://www.riptano.com/docs/0.6/data_model/supercolumns#limitations Don't make supercolumns with a huge number of subcolumns (or a few really large subcolumns) unless you plan to always read all of them at once. - Tyler On Fri, Jan 7, 2011

Re: quick question about super columns

2011-01-06 Thread Arijit Mukherjee
Thanx to both of you. I can now go ahead a bit more. Arijit On 7 January 2011 12:53, Narendra Sharma wrote: > With raw thrift APIs: > > 1. Fetch column from supercolumn: > > ColumnPath cp = new ColumnPath("ColumnFamily"); > cp.setSuper_column("SuperColumnName"); > cp.setColumn("ColumnName"); > C

Re: quick question about super columns

2011-01-06 Thread Narendra Sharma
With raw thrift APIs: 1. Fetch column from supercolumn: ColumnPath cp = new ColumnPath("ColumnFamily"); cp.setSuper_column("SuperColumnName"); cp.setColumn("ColumnName"); ColumnOrSuperColumn resp = client.get(getByteBuffer("RowKey"), cp, ConsistencyLevel.ONE); Column c = resp.getColumn(); 2. Add

Re: quick question about super columns

2011-01-06 Thread Roshan Dawrani
On Fri, Jan 7, 2011 at 12:12 PM, Arijit Mukherjee wrote: > Thank you. And is it similar if I want to search a subcolumn within a > given supercolumn? I mean I have the supercolumn key and the subcolumn > key - can I fetch the particular subcolumn? > > Can you share a small piece of example code fo

Re: quick question about super columns

2011-01-06 Thread Arijit Mukherjee
Thank you. And is it similar if I want to search a subcolumn within a given supercolumn? I mean I have the supercolumn key and the subcolumn key - can I fetch the particular subcolumn? Can you share a small piece of example code for both? I'm still new into this and trying to figure out the Thrif

Re: quick question about super columns

2011-01-06 Thread Roshan Dawrani
On Fri, Jan 7, 2011 at 11:39 AM, Arijit Mukherjee wrote: > Hi > > I've a quick question about supercolumns. > EventRecord = { >eventKey2: { >e2-ts1: {set of columns}, >e2-ts2: {set of columns}, >... >e2-tsn: {set of columns} >} > > } > > If I want to

quick question about super columns

2011-01-06 Thread Arijit Mukherjee
Hi I've a quick question about supercolumns. Say I've a structure like this (based on the supercolumn family structured mention in WTF is a SuperColum): EventRecord = { eventKey1: { e1-ts1: {set of columns}, e1-ts2: {set of columns}, ... e1-tsn: {set of columns