cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jack Krupansky" <>
Subject Re: keyspace with hundreds of columnfamilies
Date Sat, 12 Jul 2014 12:20:40 GMT
1. What does your data look like – 100 small integers or short strings and dates, or... 100
massive blobs?

2. What operations are you doing on those rows – reading and updating individual columns,
or mostly full-row upserts?

3. 100 columns in a CQL row is not so unreasonable, per se.

4. The ultimate answer to any “how will it perform” question is to do a “proof of concept”
implementation since it really all depends on your actual data and hardware setup, such as
memory, cpu, I/O, and networking – IOW, all the non-Cassandra factors can easily dwarf Cassandra

5. As far as 1K tables with 10 columns vs. 100 tables with 100 columns – it should primarily
be your queries (and updates) that drive the decision. Do fewer tables and more columns make
your queries (and updates) a lot simpler and cleaner?

-- Jack Krupansky

From: tommaso barbugli 
Sent: Saturday, July 12, 2014 7:58 AM
Subject: Re: keyspace with hundreds of columnfamilies

how is a table with hundreds columns is going to perform? 

i am moving from 1k column families each with 10 columns to 100 CFs each with 100 columns.

thank you

On Friday, 11 July 2014, Sourabh Agrawal <> wrote:

  Yes, what about CQL style columns? Please clarify

  On Sat, Jul 5, 2014 at 12:32 PM, tommaso barbugli <javascript:_e(%7B%7D,'cvml','');>

    Yes my question what about CQL-style columns.

    2014-07-04 12:40 GMT+02:00 Jens Rantil <javascript:_e(%7B%7D,'cvml','');>:

      Just so you guys aren't misunderstanding each other; Tommaso, you were not refering
to CQL-style columns, right? 


      On Fri, Jul 4, 2014 at 10:18 AM, Romain HARDOUIN <javascript:_e(%7B%7D,'cvml','');>

        Cassandra can handle many more columns (e.g. time series). 
        So 100 columns is OK. 


        tommaso barbugli <javascript:_e(%7B%7D,'cvml','');> a écrit
sur 03/07/2014 21:55:18 :

        > De : tommaso barbugli <javascript:_e(%7B%7D,'cvml','');>

        > A : javascript:_e(%7B%7D,'cvml','');, 
        > Date : 03/07/2014 21:55 

        > Objet : Re: keyspace with hundreds of columnfamilies 


        > thank you for the replies; I am rethinking the schema design, one 
        > possible solution is to "implode" one dimension and get N times less CFs.

        > With this approach I would come up with (cql) tables with up to 100 
        > columns; would that be a problem? 
        > Thank You, 
        > Tommaso 


  Sourabh Agrawal 
  +91 9945657973

sent from iphone (sorry for the typos)

View raw message