RE: Number of columns per row for composite columns?

2014-08-13 Thread Mohammed Guller
4 Mohammed From: hlqv [mailto:hlqvu...@gmail.com] Sent: Tuesday, August 12, 2014 11:44 PM To: user@cassandra.apache.org Subject: Re: Number of columns per row for composite columns? For more specifically, I declared a column family create column family Column_Family with

Re: Number of columns per row for composite columns?

2014-08-13 Thread DuyHai Doan
d in the table. >> >> If you need to review the terminology: >> >> http://www.datastax.com/dev/blog/does-cql-support-dynamic-columns-wide-rows >> >> -- Jack Krupansky >> >> *From:* hlqv >> *Sent:* Tuesday, August 12, 2014 1:13 PM >> *To:* us

Re: Number of columns per row for composite columns?

2014-08-12 Thread hlqv
es the > number of columns you have declared in the table. > > If you need to review the terminology: > http://www.datastax.com/dev/blog/does-cql-support-dynamic-columns-wide-rows > > -- Jack Krupansky > > *From:* hlqv > *Sent:* Tuesday, August 12, 2014 1:13 PM > *To

Re: Number of columns per row for composite columns?

2014-08-12 Thread Jack Krupansky
, August 12, 2014 1:13 PM To: user@cassandra.apache.org Subject: Number of columns per row for composite columns? Hi everyone, I'm confused with number of columns in a row of Cassandra, as far as I know there is 2 billions columns per row. Like that if I have a composite column name in each row

Number of columns per row for composite columns?

2014-08-12 Thread hlqv
Hi everyone, I'm confused with number of columns in a row of Cassandra, as far as I know there is 2 billions columns per row. Like that if I have a composite column name in each row, for ex: (timestamp, userid), then number of columns per row is the number of distinct 'timestamp' or each distinct '

Cassandra-cli and Composite columns

2014-02-25 Thread Ken Hancock
I've been trying to do some simple data modeling and since we're currently using Hector have been doing that modeling with cassandra-cli and running into issues with CompositeType columns. If I do a "help set", I see: The help for "create column family" shows: create column family UseComposites

Re: Composite keys and composite columns

2013-10-17 Thread Dave Brosius
The explanation for Composite columns is muddied by verbage depending on whether you are talking about the thrift interface which tends to talk about things in low terms, or cql which tends to talk about things in higher level terms. At a thrift/low level, a composite column, really now

Composite keys and composite columns

2013-10-17 Thread Hartzman, Leslie
Hi, I'm looking for clarification on composite keys and composite columns. From what I've read with regards to composite keys, you have a collection of columns where of 'n' columns, the first n-1 form the composite primary key and the last column is the data for that comp

Re: Cassandra column family using Composite Columns

2013-09-19 Thread Raihan Jamal
my above example, I have show only one columns but it might have more > columns and those columns will also follow the same concept. > > Now I am not sure, how to store these three things always at a column > value level? Should I use composite columns at a column level? if yes, then &g

Cassandra column family using Composite Columns

2013-09-17 Thread Raihan Jamal
level? Should I use composite columns at a column level? if yes, then I am not sure how to make a column family like this in Cassandra. Column1-value will be in binary, Column1-SchemaName will be String, LMD will be DateType. This is what I have so far- create column family USER_DATA with

Re: Bulk loading into CQL3 Composite Columns

2013-05-31 Thread Hiller, Dean
"user@cassandra.apache.org<mailto:user@cassandra.apache.org>" mailto:user@cassandra.apache.org>> Date: Friday, May 31, 2013 9:01 AM To: "user@cassandra.apache.org<mailto:user@cassandra.apache.org>" mailto:user@cassandra.apache.org>> Subject: Re: Bulk loading into

Re: Bulk loading into CQL3 Composite Columns

2013-05-31 Thread Daniel Morton
> ) > > You can see the source for CompositeSerializer here: > http://grepcode.com/file/repo1.maven.org/maven2/com.netflix.astyanax/astyanax/1.56.26/com/netflix/astyanax/serializers/CompositeSerializer.java > > Good luck! > > From: Daniel Morton > Reply-To: "user@cas

Re: Bulk loading into CQL3 Composite Columns

2013-05-30 Thread Keith Wright
ache.org<mailto:user@cassandra.apache.org>" mailto:user@cassandra.apache.org>> Subject: Re: Bulk loading into CQL3 Composite Columns Hi Keith... Thanks for the help. I'm presently not importing the Hector library (Which is where classes like CompositeSerializer and Stri

Re: Bulk loading into CQL3 Composite Columns

2013-05-30 Thread Daniel Morton
umnComposite), null, >> System.currentTimeMillis() ); >> >> From: Keith Wright >> Date: Thursday, May 30, 2013 3:32 PM >> To: "user@cassandra.apache.org" >> Subject: Re: Bulk loading into CQL3 Composite Columns >> >> You do not want to repeat t

Re: Bulk loading into CQL3 Composite Columns

2013-05-30 Thread Daniel Morton
: Daniel Morton > Reply-To: "user@cassandra.apache.org" > Date: Thursday, May 30, 2013 1:06 PM > To: "user@cassandra.apache.org" > Subject: Bulk loading into CQL3 Composite Columns > > Hi All. I am trying to bulk load some data into a CQL3 table using the > sstableloa

Re: Bulk loading into CQL3 Composite Columns

2013-05-30 Thread Edward Capriolo
> > ssTableWriter.addColumn( > CompositeSerializer.get().toByteBuffer(columnComposite), null, > System.currentTimeMillis() ); > > From: Keith Wright > Date: Thursday, May 30, 2013 3:32 PM > To: "user@cassandra.apache.org" > Subject: Re: Bulk loading into CQL3 Compo

Re: Bulk loading into CQL3 Composite Columns

2013-05-30 Thread Keith Wright
ssandra.apache.org>> Subject: Re: Bulk loading into CQL3 Composite Columns You do not want to repeat the first item of your primary key again. If you recall, in CQL3 a primary key as defined below indicates that the row key is the first item (key) and then the column names are composites of

Re: Bulk loading into CQL3 Composite Columns

2013-05-30 Thread Keith Wright
t;" mailto:user@cassandra.apache.org>> Date: Thursday, May 30, 2013 1:06 PM To: "user@cassandra.apache.org<mailto:user@cassandra.apache.org>" mailto:user@cassandra.apache.org>> Subject: Bulk loading into CQL3 Composite Columns Hi All. I am trying to bulk load

Bulk loading into CQL3 Composite Columns

2013-05-30 Thread Daniel Morton
Hi All. I am trying to bulk load some data into a CQL3 table using the sstableloader utility and I am having some difficulty figuring out how to use the SSTableSimpleUnsortedWriter with composite columns. I have created this simple contrived table for testing: create table test (key varchar

Re: Composite columns

2013-03-21 Thread aaron morton
this blog post by Datastax, it provides a good explanation of CQL3 > abstractions. > > http://www.datastax.com/dev/blog/cql3-for-cassandra-experts > > regards, > > ondrej cernos > > On Wed, Mar 20, 2013 at 8:50 AM, Thierry Templier > wrote: >> Hello, >>

Re: Composite columns

2013-03-20 Thread Ondřej Černoš
Hey, try this blog post by Datastax, it provides a good explanation of CQL3 abstractions. http://www.datastax.com/dev/blog/cql3-for-cassandra-experts regards, ondrej cernos On Wed, Mar 20, 2013 at 8:50 AM, Thierry Templier wrote: > Hello, > > I have a question regarding composit

Composite columns

2013-03-20 Thread Thierry Templier
Hello, I have a question regarding composite columns. What is the way to create and use them basing on CQL3? Are there some documentations regarding this feature? Is it supported with both versions 1.1 and 1.2 of Cassandra? Thanks very much for your help! Thierry

Re: Using Composite columns

2012-10-09 Thread Sylvain Lebresne
Yeah, you might want to check 1.1.5, 1.1.2 is so ancient :) -- Sylvain On Tue, Oct 9, 2012 at 9:44 AM, Vivek Mishra wrote: > I am trying it with 1.1.2 cassandra release. > > -Vivek > > > On Tue, Oct 9, 2012 at 1:13 PM, Sylvain Lebresne > wrote: >> >> On Tue, Oct 9, 2012 at 3:59 AM, Vivek Mi

Re: Using Composite columns

2012-10-09 Thread Vivek Mishra
I am trying it with 1.1.2 cassandra release. -Vivek On Tue, Oct 9, 2012 at 1:13 PM, Sylvain Lebresne wrote: > On Tue, Oct 9, 2012 at 3:59 AM, Vivek Mishra > wrote: > > it is giving me an error: > > > > [timestamp out of range for platform time_t] > > Hum, I can't reproduce that with the current

Re: Using Composite columns

2012-10-09 Thread Sylvain Lebresne
On Tue, Oct 9, 2012 at 3:59 AM, Vivek Mishra wrote: > it is giving me an error: > > [timestamp out of range for platform time_t] Hum, I can't reproduce that with the current 1.1 branch (nor in trunk). So my bet is that this was an error from cqlsh that has been fixed recently. A quick JIRA search

Using Composite columns

2012-10-08 Thread Vivek Mishra
Hi, I am trying to use compound primary key with cassandra and i am referring to: http://www.datastax.com/dev/blog/whats-new-in-cql-3-0 I have created a column family as: CREATE TABLE altercations ( instigator text, started_at timestamp, ships_destroyed int, energy_use

Re: Data Modeling - JSON vs Composite columns

2012-09-21 Thread Bill
2 options :- A) use composite columns UserId1 : { : = Betty Crocker, : = Cake : = 5 : = Nutella, : = Choc spread : = 15 } B) use a json with the data UserId1 : { = {name: Betty Crocker,descr: Cake, Qty: 5}, ={name: Nutella,descr: Choc spread, Qty: 15} } Essentially A is better if one

Re: Data Modeling - JSON vs Composite columns

2012-09-20 Thread Sylvain Lebresne
On Wed, Sep 19, 2012 at 3:32 PM, Brian O'Neill wrote: > That said, I'm keeping a close watch on: > https://issues.apache.org/jira/browse/CASSANDRA-3647 > > But if this is CQL only, I'm not sure how much use it will be for us > since we're coming in from different clients. > Anyone know how/if coll

Re: Data Modeling - JSON vs Composite columns

2012-09-20 Thread Sylvain Lebresne
entity item column > family , I have 2 options :- > > A) use composite columns > UserId1 : { > : = Betty Crocker, > : = Cake > : = 5 > : = Nutella, > : = Choc spread > : = 15 > } > > B) use a json with the data > UserId1 : { > = {name: Betty Crocker,descr:

Re: Data Modeling - JSON vs Composite columns

2012-09-19 Thread Michael Kjellman
an item, and I want to also store 3 commonly used attributes without needing to go to an entity item column family , I have 2 options :- A) use composite columns UserId1 : { : = Betty Crocker, : = Cake : = 5 : = Nutella, : = Choc spread : = 15 } B) use a json with the data UserId1 : {

Re: Data Modeling - JSON vs Composite columns

2012-09-19 Thread Brian O'Neill
ng to go to an entity item column > family , I have 2 options :- > > A) use composite columns > UserId1 : { > : = Betty Crocker, > : = Cake > : = 5 > : = Nutella, > : = Choc spread > : = 15 > } > > B) use a json with the data > UserId1 : { &

Understanding Cassandra + MapReduce + Composite Columns

2012-08-27 Thread Víctor Penela
Hi! I'm trying to use Hadoop's MapReduce on top of a Cassandra environment, and I've running into some issues while using Composite Columns. I'm currently using Cassandra 1.1.2 (I wouldn't mind having to update it) and Hadoop 1.0.3 (I'd rather keep this version). W

Query for last (composite) columns

2012-08-11 Thread Ersin Er
Hi, I am new to Cassandra and trying to understand whether it's a good fit for my problems. So here is a case from my domain: Assume that we're storing session events of users in composite columns within a column family partitioned by user id. This is from an example given about

Re: Request Timeout with Composite Columns and CQL3

2012-07-04 Thread Sylvain Lebresne
shouldn't happen. You didn't happen to change the >>> comparator for the column family or something like that from the >>> hector side? >>> Are you able to reproduce from a blank DB? >>> >>> -- >>> Sylvain >>> >>>> >&g

Re: Request Timeout with Composite Columns and CQL3

2012-07-04 Thread Henning Kropp
>> will not allow two ranges be specified for two key parts. Obviously I still >>> lack a profound understanding of cassandras architecture to have a clue. >>> And while client side filtering might seem like a valid option I am still >>> trying to get might head around a

Re: Re: Request Timeout with Composite Columns and CQL3

2012-06-29 Thread Sylvain Lebresne
valid option I am still >> trying to get might head around a cassandra data model that would allow >> this. >> >> best regards >> >> >> Von: Sylvain Lebresne [sylv...@datastax.com] >> Gesendet: Dienstag,

AW: Re: Request Timeout with Composite Columns and CQL3

2012-06-28 Thread Henning Kropp
ll > trying to get might head around a cassandra data model that would allow this. > > best regards > > ____ > Von: Sylvain Lebresne [sylv...@datastax.com] > Gesendet: Dienstag, 26. Juni 2012 10:21 > Bis: user@cassandra.apache.org > Betref

Re: Request Timeout with Composite Columns and CQL3

2012-06-26 Thread Sylvain Lebresne
ure to have a clue. > And while client side filtering might seem like a valid option I am still > trying to get might head around a cassandra data model that would allow this. > > best regards > > ____ > Von: Sylvain Lebresne [sylv...@datastax

AW: Request Timeout with Composite Columns and CQL3

2012-06-26 Thread Henning Kropp
this. best regards Von: Sylvain Lebresne [sylv...@datastax.com] Gesendet: Dienstag, 26. Juni 2012 10:21 Bis: user@cassandra.apache.org Betreff: Re: Request Timeout with Composite Columns and CQL3 On Mon, Jun 25, 2012 at 11:10 PM, Henning Kropp wrote:

Re: Request Timeout with Composite Columns and CQL3

2012-06-26 Thread Sylvain Lebresne
On Mon, Jun 25, 2012 at 11:10 PM, Henning Kropp wrote: > Hi, > > I am running into timeout issues using composite columns in cassandra 1.1.1 > and cql 3. > > My keyspace and table is defined as the following: > > create keyspace bn_logs >     with strategy_optio

Request Timeout with Composite Columns and CQL3

2012-06-25 Thread Henning Kropp
Hi, I am running into timeout issues using composite columns in cassandra 1.1.1 and cql 3. My keyspace and table is defined as the following: create keyspace bn_logs with strategy_options = [{replication_factor:1}] and placement_strategy = 'org.apache.cassandra.locator.SimpleStr

Forward compatibility for CQL3 composite columns

2012-06-12 Thread Tom Duffield (Mailing Lists)
Is there documentation on a way to create a pre-CQL3 composite column CF with indexing that will be compatible with the built-in composite column capabilities in CQL3? -- Tom Duffield Sent with Sparrow (http://www.sparrowmailapp.com/?sig)

Re: Composite columns: CLI or CQL?

2012-06-11 Thread Georg Köster
I used Pelops and now I tried Astyanax and I get no details on the value that cassandra is analyzing - only the composite key is in the error message. If I insert a String instead of the Long (Long.toString(...) and Long.valueOf()) my tests work but my column size is larger of course. I can use it

Re: Composite columns: CLI or CQL?

2012-06-11 Thread Sylvain Lebresne
More details would help, like at least the query you're using to do the insertion and that fails, as well as the exact error message. -- Sylvain On Mon, Jun 11, 2012 at 2:42 AM, Georg Köster wrote: > Dear all, > > I'm really excited about Cassandra's peer-to-peer architecture and sorted > values

Composite columns: CLI or CQL?

2012-06-10 Thread Georg Köster
Dear all, I'm really excited about Cassandra's peer-to-peer architecture and sorted values. Currently I'm blocked in trials: I cannot insert longs into 'val' in: create columnfamily entries ( id varchar, va varchar, ts bigint, val bigint, PRIMARY KEY (id, va, ts) ); I g

Re: composite columns vs super columns

2012-04-10 Thread aaron morton
Super Columns: top level column to have a list of sub column. e.g. row key: foo column: bar sub columns: baz = qux Composite columns: data types are defined by combining multiple types, instances of the type are compared by comparing each component in turn. e.g. row key: foo column

Re: yet a couple more questions on composite columns

2012-02-06 Thread Yiming Sun
} for a metadata column where the Composite is > >> DateType:UTF8Type. > >> > >> Jim > >> > >> On Sat, Feb 4, 2012 at 2:13 PM, Yiming Sun > wrote: > >> > Thanks Andrey and Chris. It sounds like we don't necessarily have to > >> &g

Re: yet a couple more questions on composite columns

2012-02-06 Thread Jim Ancona
etadata column where the Composite is >> DateType:UTF8Type. >> >> Jim >> >> On Sat, Feb 4, 2012 at 2:13 PM, Yiming Sun wrote: >> > Thanks Andrey and Chris.  It sounds like we don't necessarily have to >> > use >> > composite columns.  Fr

Re: yet a couple more questions on composite columns

2012-02-05 Thread Yiming Sun
t;>> Jim >>> >>> On Sat, Feb 4, 2012 at 2:13 PM, Yiming Sun wrote: >>> > Thanks Andrey and Chris. It sounds like we don't necessarily have to >>> use >>> > composite columns. From what I understand about dynamic CF, each row

Re: yet a couple more questions on composite columns

2012-02-05 Thread R. Verlangen
n where the Composite is >> DateType:UTF8Type. >> >> Jim >> >> On Sat, Feb 4, 2012 at 2:13 PM, Yiming Sun wrote: >> > Thanks Andrey and Chris. It sounds like we don't necessarily have to >> use >> > composite columns. From what I understand a

Re: yet a couple more questions on composite columns

2012-02-04 Thread Yiming Sun
ata columns, e.g. a column of > 1970-01-01:{accountId} for a metadata column where the Composite is > DateType:UTF8Type. > > Jim > > On Sat, Feb 4, 2012 at 2:13 PM, Yiming Sun wrote: > > Thanks Andrey and Chris. It sounds like we don't necessarily have to use > >

Re: yet a couple more questions on composite columns

2012-02-04 Thread Yiming Sun
like this a while ago. I decided to go for the >>> 2-rows-solution: by doing that you don't have the need for super columns. >>> Cassandra is really good at reading, so this should not be an issue. >>> >>> Cheers! >>> >>> >>> 2012/2/4 Yimi

Re: yet a couple more questions on composite columns

2012-02-04 Thread Jim Ancona
Chris.  It sounds like we don't necessarily have to use > composite columns.  From what I understand about dynamic CF, each row may > have completely different data from other rows;  but in our case, the data > in each row is similar to other rows; my concern was more about the &

Re: yet a couple more questions on composite columns

2012-02-04 Thread R. Verlangen
2/2/4 Yiming Sun >> >>> Thanks Andrey and Chris. It sounds like we don't necessarily have to >>> use composite columns. From what I understand about dynamic CF, each row >>> may have completely different data from other rows; but in our case, the >&g

Re: yet a couple more questions on composite columns

2012-02-04 Thread Yiming Sun
really good at reading, so this should not be an issue. > > Cheers! > > > 2012/2/4 Yiming Sun > >> Thanks Andrey and Chris. It sounds like we don't necessarily have to use >> composite columns. From what I understand about dynamic CF, each row may >> have comp

Re: yet a couple more questions on composite columns

2012-02-04 Thread R. Verlangen
we don't necessarily have to use > composite columns. From what I understand about dynamic CF, each row may > have completely different data from other rows; but in our case, the data > in each row is similar to other rows; my concern was more about the > homogeneity of the data be

Re: yet a couple more questions on composite columns

2012-02-04 Thread Yiming Sun
Thanks Andrey and Chris. It sounds like we don't necessarily have to use composite columns. From what I understand about dynamic CF, each row may have completely different data from other rows; but in our case, the data in each row is similar to other rows; my concern was more abou

Re: yet a couple more questions on composite columns

2012-02-03 Thread Chris Gerken
> > > On 4 February 2012 06:21, Yiming Sun wrote: > I cannot have one composite column name with 3 components while another with > 4 components? > Just put 4 components and left last empty (if it is same type)?! > > Another question I have is how flexible composite c

Re: yet a couple more questions on composite columns

2012-02-03 Thread Andrey V. Panov
On 4 February 2012 06:21, Yiming Sun wrote: > I cannot have one composite column name with 3 components while another > with 4 components? Just put 4 components and left last empty (if it is same type)?! Another question I have is how flexible composite columns actually are. If >

yet a couple more questions on composite columns

2012-02-03 Thread Yiming Sun
Hi, We are getting close to replacing our super-column based schema to something more efficient, and I am trying to wrap my heads around composite columns. An email from another list member has clarified that composite and non-composite columns should not be mixed in the same CF because only one

Re: data model with composite columns

2012-02-02 Thread Deno Vichas
this is what i thought. thanks for clarifying. On 2/2/2012 10:44 PM, aaron morton wrote: Short answer is no. The slightly longer answer is nope. All column names in a CF are compared using the same comparator. You will need to create a new CF. Cheers. - Aaron Morton Freelan

Re: data model with composite columns

2012-02-02 Thread aaron morton
Short answer is no. The slightly longer answer is nope. All column names in a CF are compared using the same comparator. You will need to create a new CF. Cheers. - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 3/02/2012, at 10:25 AM, Deno Vich

data model with composite columns

2012-02-02 Thread Deno Vichas
hey all! i have a CF that has ~10 columns in it and now i'm finding the need to use composite column names. can you, or should mix and match composite and non-composite column names in the same CF? if you can/should how does sorting work with a single comparator? thanks, deno

Re: Replacing supercolumns with composite columns; Getting the equivalent of retrieving a list of supercolumns by name

2012-01-04 Thread Guy Incognito
ave ids steve or greg. Cheers, Steve -Original Message- From: Jeremiah Jordan [mailto:jeremiah.jor...@morningstar.com] Sent: Tuesday, January 03, 2012 3:12 PM To: user@cassandra.apache.org Cc: Asil Klin Subject: Re: Replacing supercolumns with composite columns; Getting the eq

Re: Replacing supercolumns with composite columns; Getting the equivalent of retrieving a list of supercolumns by name

2012-01-04 Thread Jeremiah Jordan
Unless you are running into an issue with using super columns that make the composite columns better fit what you are trying to do, I would just stick with super-columns. "if it ain't broke don't fix it". -Jeremiah On 01/03/2012 11:21 PM, Asil Klin wrote: @Stephan: i

Re: Replacing supercolumns with composite columns; Getting the equivalent of retrieving a list of supercolumns by name

2012-01-04 Thread Jeremiah Jordan
ers between 4 and 10 which have ids steve or greg. Cheers, Steve -Original Message- From: Jeremiah Jordan [mailto:jeremiah.jor...@morningstar.com] Sent: Tuesday, January 03, 2012 3:12 PM To: user@cassandra.apache.org Cc: Asil Klin Subject: Re: Replacing supercolumns with composite columns; Getting

RE: Replacing supercolumns with composite columns; Getting the equivalent of retrieving a list of supercolumns by name

2012-01-04 Thread Stephen Pope
Cheers, Steve From: rajkumar@gmail.com [mailto:rajkumar@gmail.com] On Behalf Of Asil Klin Sent: Wednesday, January 04, 2012 12:21 AM To: user@cassandra.apache.org Subject: Re: Replacing supercolumns with composite columns; Getting the equivalent of retrieving a list of supercolumns by name

Re: Replacing supercolumns with composite columns; Getting the equivalent of retrieving a list of supercolumns by name

2012-01-03 Thread Asil Klin
@Stephan: in that case, you can easily tell the names of all columns you want to retrieve, so you can make a query to retrieve those list of composite columns. @Jeremiah, So where is my best bet ? Should I leave the supercolumns as it is as of now, since I can find a good way to use them incase

RE: Replacing supercolumns with composite columns; Getting the equivalent of retrieving a list of supercolumns by name

2012-01-03 Thread Stephen Pope
e ids steve or greg. Cheers, Steve -Original Message- From: Jeremiah Jordan [mailto:jeremiah.jor...@morningstar.com] Sent: Tuesday, January 03, 2012 3:12 PM To: user@cassandra.apache.org Cc: Asil Klin Subject: Re: Replacing supercolumns with composite columns; Getting the equivale

Re: Replacing supercolumns with composite columns; Getting the equivalent of retrieving a list of supercolumns by name

2012-01-03 Thread Jeremiah Jordan
The main issue with replacing super columns with composite columns right now is that if you don't know all your sub-column names you can't select multiple "super columns" worth of data in the same query without getting extra stuff. You have to use a slice to get all s

Replacing supercolumns with composite columns; Getting the equivalent of retrieving a list of supercolumns by name

2012-01-03 Thread Asil Klin
I have a super columns family which I always use to retrieve a list of supercolumns(with all subcolumns) by name. I am looking forward to replace all SuperColumns in my schema with the composite columns. How could I design schema so that I could do the equivalent of retrieving a list of

Re: Retrieve all composite columns from a row, whose composite name's first component matches from a list of Integers

2011-12-30 Thread Philippe
columns. I could and would switch to full composite columns because I am fishing for every drop of performance I can. However, I would need "Letting multiget_slice accept multiple SlicePredicates per key could also accomplish this." Can anyone on the dev team comment on doing this ? Is

Re: Retrieve all composite columns from a row, whose composite name's first component matches from a list of Integers

2011-12-29 Thread Tyler Hobbs
On Thu, Dec 29, 2011 at 3:13 PM, Edward Capriolo wrote: > > You seen to say you can query for a list of supercolumns, I am not > sure how this works because the ColumnParent seems to only accept a > single SuperColumn, but if you can do it I am not calling you a liar. > If you don't specify a sup

Re: Retrieve all composite columns from a row, whose composite name's first component matches from a list of Integers

2011-12-29 Thread Edward Capriolo
cf [b][7][b]=value >> >> and you want to slice: >> scf [b][1][*] >> >> Which would result in >> >> scf [b][1][a]=value >> scf [b][1][x]=value >> >> ? >> > > Exactly I have this! > And as for the queries, I want to retriev

Re: Retrieve all composite columns from a row, whose composite name's first component matches from a list of Integers

2011-12-29 Thread Aditya
][1][x]=value > > ? > Exactly I have this! And as for the queries, I want to retrieve columns (satisfying from a list of wildcard names) , something like below : scf [b][1][*] scf [b][7][*] Now this type of queries are not possible with composite columns but it is very easily achievable

Re: Retrieve all composite columns from a row, whose composite name's first component matches from a list of Integers

2011-12-29 Thread Edward Capriolo
: > @Edward: Perhaps you missed to notice that I need to always retrieve 'all > columns' under the supercolumn at any time.. and as per my query > requirements if I use composite columns instead of supercolumns then it is > impossible to do wildcard queries like the ones asked in th

Re: Retrieve all composite columns from a row, whose composite name's first component matches from a list of Integers

2011-12-29 Thread Aditya
ays retrieve 'all > columns' under the supercolumn at any time.. and as per my query > requirements if I use composite columns instead of supercolumns then it is > impossible to do wildcard queries like the ones asked in this thread's > headline but which is much easier to do t

Re: Retrieve all composite columns from a row, whose composite name's first component matches from a list of Integers

2011-12-29 Thread Aditya
@Edward: Perhaps you missed to notice that I need to always retrieve 'all columns' under the supercolumn at any time.. and as per my query requirements if I use composite columns instead of supercolumns then it is impossible to do wildcard queries like the ones asked in this thread'

Re: Retrieve all composite columns from a row, whose composite name's first component matches from a list of Integers

2011-12-29 Thread Edward Capriolo
e replaced in future c* version behind the scenes by composite columns anyway SuperColumns: Usually an afterthought for API developers, (support for them comes "later") SuperColumns: Almost always utilized incorrectly by users, users speak of '10%' performance gains after they swi

Re: Retrieve all composite columns from a row, whose composite name's first component matches from a list of Integers

2011-12-29 Thread Philippe
vity by a user's followie on an item, a column is stored in >>> 'rowX'. The column has a composite type column name made up of >>> itemId+userId (which makes it unique col. name) in rowX. (& column value >>> contains the activity data related to that item by that followie) >>> > >>> > Now I want to retrieve activity by all users on a list of items. So I >>> need to retrieve all composite columns with composite's first component >>> matching the itemId. Is it possible to do such a query to Cassandra ? I am >>> using Hector. >>> >> >> >

Re: Retrieve all composite columns from a row, whose composite name's first component matches from a list of Integers

2011-12-28 Thread Martin Arrowsmith
tored in >>> 'rowX'. The column has a composite type column name made up of >>> itemId+userId (which makes it unique col. name) in rowX. (& column value >>> contains the activity data related to that item by that followie) >>> > >>> > Now I want to retrieve activity by all users on a list of items. So I >>> need to retrieve all composite columns with composite's first component >>> matching the itemId. Is it possible to do such a query to Cassandra ? I am >>> using Hector. >>> >> >> >

Re: Retrieve all composite columns from a row, whose composite name's first component matches from a list of Integers

2011-12-28 Thread Edward Capriolo
y by a user's followie on an item, a column is stored in >> 'rowX'. The column has a composite type column name made up of >> itemId+userId (which makes it unique col. name) in rowX. (& column value >> contains the activity data related to that item by that foll

Re: Retrieve all composite columns from a row, whose composite name's first component matches from a list of Integers

2011-12-28 Thread Aditya
> > > Now I want to retrieve activity by all users on a list of items. So I > need to retrieve all composite columns with composite's first component > matching the itemId. Is it possible to do such a query to Cassandra ? I am > using Hector. >

Re: Retrieve all composite columns from a row, whose composite name's first component matches from a list of Integers

2011-12-28 Thread Edward Capriolo
hat followie) > > Now I want to retrieve activity by all users on a list of items. So I need to retrieve all composite columns with composite's first component matching the itemId. Is it possible to do such a query to Cassandra ? I am using Hector.

Retrieve all composite columns from a row, whose composite name's first component matches from a list of Integers

2011-12-26 Thread Aditya
mn has a composite type column name made up of itemId+userId (which makes it unique col. name) in rowX. (& column value contains the activity data related to that item by that followie) Now I want to retrieve activity by all users on a list of items. So I need to retrieve all composite column

Re: Composite columns vs Protocol Buffers when all you need is to pack many things in a single column

2011-12-08 Thread Sylvain Lebresne
CompositeType is meant as a comparator to deal with composite column names. While it is possible to use it as a column value validator, I don't see any good use of that. -- Sylvain On Thu, Dec 8, 2011 at 6:13 AM, Asil Klin wrote: > I know Composite columns are used for some very

Composite columns vs Protocol Buffers when all you need is to pack many things in a single column

2011-12-07 Thread Asil Klin
I know Composite columns are used for some very useful scenarios(like to replace super columns) which cannot be helped with anything else. But, for situations when you just need to pack many things in a single column efficiently and such that the retrievals are also performant, which one should

Re: looking for information on composite columns

2011-09-02 Thread Yiming Sun
Thanks Edward. What's the link to your blog? On Fri, Sep 2, 2011 at 10:43 AM, Edward Capriolo wrote: > > On Fri, Sep 2, 2011 at 9:15 AM, Yiming Sun wrote: > >> Hi, >> >> I am looking for information/tutorials on the use of composite columns, >> including h

Re: looking for information on composite columns

2011-09-02 Thread Edward Capriolo
On Fri, Sep 2, 2011 at 9:15 AM, Yiming Sun wrote: > Hi, > > I am looking for information/tutorials on the use of composite columns, > including how to use it, what kind of indexing it can offer, and its > advantage over super columns. I googled but came up with very little > i

looking for information on composite columns

2011-09-02 Thread Yiming Sun
Hi, I am looking for information/tutorials on the use of composite columns, including how to use it, what kind of indexing it can offer, and its advantage over super columns. I googled but came up with very little information. There is a blog article from high performance cassandra on the

Re: Secondary index on composite columns?

2011-08-01 Thread Jonathan Ellis
To the best of my ability to predict the future, we would probably enhance "native" composite columns with those features, but not expose them in the old supercolumn API. So again, if supercolumns work for you, we won't pull the rug out from under you, but don't start using th

Re: Secondary index on composite columns?

2011-08-01 Thread Boris Yen
ering if anyone would know if secondary index can be enabled on > > composite columns? > > Regards > > Boris > > > > -- > Jonathan Ellis > Project Chair, Apache Cassandra > co-founder of DataStax, the source for professional Cassandra support > http://www.datastax.com >

Re: Secondary index on composite columns?

2011-07-31 Thread Jonathan Ellis
Sure, but it's still only useful for equality predicates. On Sun, Jul 31, 2011 at 8:50 PM, Boris Yen wrote: > Hi, > I was wondering if anyone would know if secondary index can be enabled on > composite columns? > Regards > Boris -- Jonathan Ellis Project Chair, Apache Cas

Secondary index on composite columns?

2011-07-31 Thread Boris Yen
Hi, I was wondering if anyone would know if secondary index can be enabled on composite columns? Regards Boris