hi,
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
tommaso
On Friday, 11 July 2014, Sourabh Agrawal wrote:
> Yes, what about CQL style columns? Please clarify
>
>
> On Sat, Jul 5, 20
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 ul
hi Jack
thank you for your clear answer!
On Saturday, 12 July 2014, Jack Krupansky wrote:
> 1. What does your data look like – 100 small integers or short strings
> and dates, or... 100 massive blobs?
>
it will be only small short strings/varints no blobs or nested data
> 2. What operations
I have a column that I would like to have a different TTL than the whole
row.
because of the cassandra USING TTL clause I don't think this is possible to
do with one INSERT.
It seems like I need to have TWO inserts doing this… One for all the
columns with the first TTL, and then another insert wi
If I have a set.. can I have the individual members TTL , and not
just the whole 'column' ?
It's interesting considering I can use the UPDATE form whereby I just add
members to the set and have a TTL on that value… which would seem to imply
that I can set individual values.
Kevin
--
Founder/CE
My understanding is that yes you need two inserts which you could do as part of
a batch.
On Jul 12, 2014 7:24 PM, Kevin Burton wrote:
I have a column that I would like to have a different TTL than the whole row.
because of the cassandra USING TTL clause I don't think this is possible to do
wit
Yes each item in the set can have a different TTL so long as they are upserted
with commands having differing TTLs. You should read about how
collections/maps work in CQL3 in terms of their CQL2 structure.
On Jul 12, 2014 7:32 PM, Kevin Burton wrote:
If I have a set.. can I have the individual
On Sat, Jul 12, 2014 at 6:05 PM, Keith Wright wrote:
> Yes each item in the set can have a different TTL so long as they are
> upserted with commands having differing TTLs.
>
Ah… ok. So you can just insert them with unique UPDATE/INSERT commands with
different USING TTLs and it will work. That
