Compact storage only allows one column outside of the primary key so you'll
definitely need to recreate your table if you want to add columns.
Le jeu. 18 janv. 2018 à 12:18, Nicolas Guyomar
a écrit :
> Well it should be as easy as following this :
> https://docs.datastax.com/en/cql/3.1/cql/cql_u
Yeah, I want column4 to appear in each cell name (rather than just once)
which I think would be the same as altering the primary key.
2018-01-18 12:18 GMT+01:00 Nicolas Guyomar :
> Well it should be as easy as following this : https://docs.datastax.com/
> en/cql/3.1/cql/cql_using/use_alter_add.ht
Well it should be as easy as following this :
https://docs.datastax.com/en/cql/3.1/cql/cql_using/use_alter_add.html
But I'm worried that your initial requirement was to change the clustering
key, as Alexander stated, you need to create a new table and transfer your
data in it
On 18 January 2018 a
It was indeed created with C* 1.X
Do you have any links or otherwise on how I would add the column4? I don't
want to risk destroying my data.
Best regards,
Joel
2018-01-18 11:18 GMT+01:00 Nicolas Guyomar :
> Hi Joel,
>
> You cannot alter a table primary key.
>
> You can however alter your existi
Hi Joel,
You cannot alter a table primary key.
You can however alter your existing table to only add column4 using cqlsh
and cql, even if this table as created back with C* 1.X for instance
On 18 January 2018 at 11:14, Joel Samuelsson
wrote:
> So to rephrase that in CQL terms I have a table li
Hi Joel,
Sadly it's not possible to alter the primary key of a table in Cassandra.
That would require to rewrite all data on disk to match the new
partitioning and/or clustering.
You need to create a new table and transfer all data from the old one
programmatically.
Cheers,
Le jeu. 18 janv. 201
So to rephrase that in CQL terms I have a table like this:
CREATE TABLE events (
key text,
column1 int,
column2 int,
column3 text,
value text,
PRIMARY KEY(key, column1, column2, column3)
) WITH COMPACT STORAGE
and I'd like to change it to:
CREATE TA
Hi,
I have an older system (C* 2.1) using Thrift tables on which I want to
alter a column composite. Right now it looks like (int, int, string) but I
want it to be (int, int, string, string). Is it possible to do this on a
live cluster without deleting the old data? Can you point me to some
docume
Here's a slightly better version and a python script. -ml
-- put this in and run using 'cqlsh -f
DROP KEYSPACE latest;
CREATE KEYSPACE latest WITH replication = {
'class': 'SimpleStrategy',
'replication_factor' : 1
};
USE latest;
CREATE TABLE time_series (
bucket_userid text, --
Then you can do this. I handle millions of entries this way and it works
well if you are mostly interested in recent activity.
If you need to span all activity then you can use a separate table to
maintain the 'latest'. This table should also be sharded as entries will be
'hot'. Sharding will spre
Thanks Michael,
But I cannot sort the rows in memory, as the number of columns will be
quite huge.
>From the python script above:
select_stmt = "select * from time_series where userid = 'XYZ'"
This would return me many hundreds of thousands of columns. I need to go in
time-series order using
If you have set up the table as described in my previous message, you could
run this python snippet to return the desired result:
#!/usr/bin/env python
# -*- coding: utf-8 -*-
import logging
logging.basicConfig()
from operator import itemgetter
import cassandra
from cassandra.cluster import Clus
You could try this. C* doesn't do it all for you, but it will efficiently
get you the right data.
-ml
-- put this in and run using 'cqlsh -f
DROP KEYSPACE latest;
CREATE KEYSPACE latest WITH replication = {
'class': 'SimpleStrategy',
'replication_factor' : 1
};
USE latest;
CREATE TA
I have been faced with a problem of grouping composites on the second-part.
Lets say my CF contains this
TimeSeriesCF
key:UserID
composite-col-name:TimeUUID:PKID
Some sample data
UserID = XYZ
That looks correct, and I just double checked that xget behaves normally
for me for that case. What does it actually print? Can you try not
unpacking the tuple in your inner for-loop and print that?
Also, there's a pycassa mailing list (pycassa-disc...@googlegroups.com)
that would be a better lo
I have a column family defined as:
create column family LSItemIdsByFieldValueIndex_Integer
with column_type = 'Standard'
and comparator =
'CompositeType(org.apache.cassandra.db.marshal.IntegerType,org.apache.cassandra.db.marshal.UTF8Type)'
and default_validation_class = 'UTF8Type'
and key
gt;
>>
>> --
>> *From:* Wei Zhu
>> *To:* Cassandr usergroup
>> *Sent:* Wednesday, November 7, 2012 12:47 PM
>> *Subject:* composite column validation_class question
>>
>> Hi All,
>> I am trying to design my schema us
> Any thoughts?
>
> Thanks.
> -Wei
>
>
> --
> *From:* Wei Zhu
> *To:* Cassandr usergroup
> *Sent:* Wednesday, November 7, 2012 12:47 PM
> *Subject:* composite column validation_class question
>
> Hi All,
> I am trying to design my schem
Any thoughts?
Thanks.
-Wei
From: Wei Zhu
To: Cassandr usergroup
Sent: Wednesday, November 7, 2012 12:47 PM
Subject: composite column validation_class question
Hi All,
I am trying to design my schema using composite column. One thing I am a bit
confused
Ok, this article answered all the confusion in my head:
http://www.datastax.com/dev/blog/thrift-to-cql3
It's a must read for noobs (like me). It perfectly explains mappings and
diffs between internals and CQL3(abstractions). First read this and THEN go
study all the resources out there ;)
Lp,
Ala
Hi there!
I'm strugguling to figure out (for quite few hours now) how can I insert
for example column with TimeUUID name and empy value in CQL3 in fictional
table. And what's the table design? I'm interested in syntax (e.g. example).
I'm trying to do something like Matt Dennis did here (*Cassandr
Hi All,
I am trying to design my schema using composite column. One thing I am a bit
confused is how to define validation_class for the composite column, or is
there a way to define it?
for the composite column, I might insert different value based on the column
name, for example
I will insert
Thanks Tristan and Sylvain, it all makes sense now.
One follow up question regarding the composite column. It seems that for the
where clause I can only restrict the query on the first composite column
(friend_id, in my case). I understand it's determined by the underlining row
st
On Wed, Oct 31, 2012 at 7:14 PM, Wei Zhu wrote:
> I try to use CQL3 to create CF with composite columns,
>
> CREATE TABLE Friends (
> ... user_id bigint,
> ... friend_id bigint,
> ... status int,
> ... source int,
> ... created time
CQL3 handles columns/rows/keys differently than Cassandra itself
underneath. If you look closely you'll see that your real primary key
is in fact only a Long:
> Key Validation Class: org.apache.cassandra.db.marshal.LongType
If you want to know more about it, check these 2 articles:
http://
You didn't do anything wrong, it's how CQL3 works. I suggest having a
look at http://www.datastax.com/dev/blog/thrift-to-cql3. Especially
the section called "Non compact tables" might hopefully explains more.
--
Sylvain
On Wed, Oct 31, 2012 at 6:14 PM, Wei Zhu wrote:
> I try to use CQL3 to creat
I try to use CQL3 to create CF with composite columns,
CREATE TABLE Friends (
... user_id bigint,
... friend_id bigint,
... status int,
... source int,
... created timestamp,
... lastupdated timestamp,
...
Anybody in group got into such issues?
-Vivek
On Fri, Oct 19, 2012 at 3:28 PM, Vivek Mishra wrote:
> Ok. I did assume the same, here is what i have tried to fetch composite
> columns via thrift and CQL query as well!
>
> Not sure why thrift API is returning me column name as empty! (Tried with
Ok. I did assume the same, here is what i have tried to fetch composite
columns via thrift and CQL query as well!
Not sure why thrift API is returning me column name as empty! (Tried with
Cassandra 1.1.5)
Here is the program:
/
>> Yes, i understand that. Reason why i am asking is, with this i need to split
>> them to get actual column name using ":" as a seperator.
The ":" is a artefact of the cassandra-cli, nothing something you will have to
deal with via the thrift API. Internally we do not store the values with ":"
s
> Yes, i understand that. Reason why i am asking is, with this i need to split
> them to get actual column name using ":" as a seperator.
> Though i did not try it yet, but wondering if column name is like
> "alliance:movement", then how do it compute it?
You've lost me, sorry.
--
Sylvain
>
>
>
Yes, i understand that. Reason why i am asking is, with this i need to
split them to get actual column name using ":" as a seperator.
Though i did not try it yet, but wondering if column name is like
"alliance:movement", then how do it compute it?
On Wed, Oct 17, 2012 at 1:04 PM, Sylvain Lebresne
On Wed, Oct 17, 2012 at 3:17 AM, Vivek Mishra wrote:
> column name will be "2012-07-24:2:alliance_involvement" or
> "alliance_involvement"?
The former. Though let's clarify that
"2012-07-24:2:alliance_involvement" is the string representation of a
composite name (i.e. one compatible with Composit
column name will be "2012-07-24:2:alliance_involvement" or
"alliance_involvement"?
-Vivek
On Tue, Oct 16, 2012 at 10:25 PM, Sylvain Lebresne wrote:
> On Tue, Oct 16, 2012 at 12:31 PM, Vivek Mishra
> wrote:
> > Thanks Sylvain. I missed it. If i try to access these via thrift API,
> what
> > will
On Tue, Oct 16, 2012 at 12:31 PM, Vivek Mishra wrote:
> Thanks Sylvain. I missed it. If i try to access these via thrift API, what
> will be the column names?
I'm not sure I understand the question. The cli output is pretty much
what you get via the thrift API.
--
Sylvain
vek Mishra
> wrote:
> > ---
> > RowKey: Jayne Cobb
> > => (column=2012-07-24:2:alliance_involvement, value=false,
> > timestamp=135038100502)
> > => (column=2012-07-24:2:energy_used, value=4.6,
> timestamp=1350381005020001)
> >
&g
;
> Not sure, why is it not getting non-composite column(e.g. ships_destroyed in
> this case).
You have all the data in there. The ships_destroyed is the second
component of each of your column names. That's just the way CQL3
encodes things underneath.
--
Sylvain
> As I understand from the link below, burning column index-info onto the
> sstable index files will not only eliminate sstables but also reduce disk
> seeks from 3 to 2 for wide rows.
Yes.
> Shouldn't we be wary of the spike in heap usage by promoting column indexes
> to index file?
If you're t
ds good for composite columns.
> Currently,
> composite column name are completely opaque to the storage engine.
>
> > alone could have gone into the bloom-filter, speeding up
> my
> > queries really effectively
>
> True, though https://issues.apache.org/jira/browse/CASSANDRA-2
> Range queries do not use bloom filters. It holds good for composite-columns
> also right?
Since I assume you are referring to column's bloom filters (key's bloom filters
are always used) then yes, that holds good for composite columns. Currently,
composite column name are comp
n bloom filters when I specify an absolute value for Part1 of the
> composite column and a start/end value for Part2 of the composite column
>
> It is slowly dawning on me that I need a super-column to use column blooms
> effectively and at the same time don't want the entire
Yes Aaron, I was not clear about Bloom Filters. I was thinking about the
column bloom filters when I specify an absolute value for Part1 of the
composite column and a start/end value for Part2 of the composite column
It is slowly dawning on me that I need a super-column to use column blooms
> Freelance Developer
> @aaronmorton
> http://www.thelastpickle.com
>
> On 14/09/2012, at 8:31 AM, Adam Holmberg wrote:
>
>> I'm modeling a new application and considering the use of SuperColumn vs.
>> Composite Column paradigms. I understand that SuperColumns are d
;user@cassandra.apache.org<mailto:user@cassandra.apache.org>"
mailto:user@cassandra.apache.org>>
Date: Friday, September 14, 2012 9:08 AM
To: "user@cassandra.apache.org<mailto:user@cassandra.apache.org>"
mailto:user@cassandra.apache.org>>
Subject: Re: Comp
---
> Aaron Morton
> Freelance Developer
> @aaronmorton
> http://www.thelastpickle.com
>
> On 14/09/2012, at 8:31 AM, Adam Holmberg
> wrote:
>
> I'm modeling a new application and considering the use of SuperColumn vs.
> Composite Column paradigms. I understan
/blog/cql3_collections
Hope that helps.
-
Aaron Morton
Freelance Developer
@aaronmorton
http://www.thelastpickle.com
On 14/09/2012, at 8:31 AM, Adam Holmberg wrote:
> I'm modeling a new application and considering the use of SuperColumn vs.
> Composite Column p
in disk
>
> Yes, each combination is stored separately on disk (the storage engine
> itself doesn't have special casing for composite column, at least not
> yet). But as far as disk space is concerned, I suspect that sstable
> compression makes this largely a non issue.
>
> --
> Sylvain
>
I'm modeling a new application and considering the use of SuperColumn vs.
Composite Column paradigms. I understand that SuperColumns are discouraged
in new development, but I'm pondering a query where it seems like
SuperColumns might be better suited.
Consider a CF with SuperColumn
ely in disk
>
> Yes, each combination is stored separately on disk (the storage engine
> itself doesn't have special casing for composite column, at least not
> yet). But as far as disk space is concerned, I suspect that sstable
> compression makes this largely a non issue.
>
> --
> Sylvain
>
> Is every / combination stored separately in disk
Yes, each combination is stored separately on disk (the storage engine
itself doesn't have special casing for composite column, at least not
yet). But as far as disk space is concerned, I suspect that sstable
compression makes this large
> Is there a way to create a slice query that returns all columns where the
> _second_ component is A?
No.
You can only get a contiguous slice of columns.
Cheers
-
Aaron Morton
Freelance Developer
@aaronmorton
http://www.thelastpickle.com
On 16/08/2012, at 7:21 AM, Mike Hugo
Hello,
Given a row like this
"key1" => (A:A:C), (A:A:B), (B:A:C), (B:C:D)
Is there a way to create a slice query that returns all columns where the
_second_ component is A? That is, I would like to get back the following
columns by asking for columns where component[0] = * and component[1] = A
d, Jul 18, 2012 at 11:06 AM, rohit bhatia wrote:
> Hi,
>
> I don't think that composite columns have "parent columns". your point
> might be true for supercolumns ..
> but each composite column is probably independent..
>
> On Wed, Jul 18, 2012 at 9:14 PM, Thomas V
Hi,
I don't think that composite columns have "parent columns". your point
might be true for supercolumns ..
but each composite column is probably independent..
On Wed, Jul 18, 2012 at 9:14 PM, Thomas Van de Velde
wrote:
> Hi there,
>
> I am trying to understand th
Hi
I'm using Cassandra 1.1.0 from Datastax and attempting to load a
ColumnFamily with a single column with a Composite name. It seems to load
ok, but is much slower than similar code without the composite column.
I tried building the Composite outside the while loop and just copying it
b
Morton
Freelance Developer
@aaronmorton
http://www.thelastpickle.com
On 12/07/2012, at 9:04 AM, Michael Cherkasov wrote:
Hi all,
What is the right way to create CF with dynamic composite column and
composite key?
Now I use code like this:
private static final String DEFAULT_DYNAMIC_COMPOSITE_
Freelance Developer
@aaronmorton
http://www.thelastpickle.com
On 12/07/2012, at 9:04 AM, Michael Cherkasov wrote:
> Hi all,
>
> What is the right way to create CF with dynamic composite column and
> composite key?
>
> Now I use code like this:
>
> pri
zCassandra data model is best known for demoralize data. You must have
entry for column name in other column family.
Example is just for posterity, you should not put everything in single row,
very inefficient.
I do not use composite column. The way I do and others do is use complex
column
mail.com> wrote:
>
>> Aaron,
>>
>> Actually Aaron i am looking for a scenario on super columns being
>> replaced by composite column.
>> Say this is a data model using super column
>> rowKey{
>> superKey
n numbers of
column]"*
comaprator=CompositeType(UTF8Type1,UTF8Type2,...,n)
/Samal
On Thu, May 17, 2012 at 10:40 AM, Abhijit Chanda
wrote:
> Aaron,
>
> Actually Aaron i am looking for a scenario on super columns being replaced
> by composite column.
> Say this is a data
Aaron,
Actually Aaron i am looking for a scenario on super columns being replaced
by composite column.
Say this is a data model using super column
rowKey{
superKey1 {
Name,
Address,
City
rote:
> I have not used CC but yes you can.
> Below is not composite column. It is not not column with JSON hash value.
> Column value can be anything you like.
> date inside value are not indexed.
>
>
> On Tue, May 15, 2012 at 9:27 AM, Abhijit Chanda
> wrote:
> Is i
It is just column with JSON value
On Tue, May 15, 2012 at 4:00 PM, samal wrote:
> I have not used CC but yes you can.
> Below is not composite column. It is not not column with JSON hash value.
> Column value can be anything you like.
> date inside value are not indexed.
>
>
I have not used CC but yes you can.
Below is not composite column. It is not not column with JSON hash value.
Column value can be anything you like.
date inside value are not indexed.
On Tue, May 15, 2012 at 9:27 AM, Abhijit Chanda
wrote:
> Is it possible to create this data model with the h
tting
111:ticks
111:quote
222:ticks
222:quote
333:ticks
333:quote
444:ticks
If that is the case things are working as expected.
The slice operation gets a column range. So if you start at
111:ticks and end at 444:ticks you are asking for all the column in
between.
it is not possible to fi
case things are working as expected.
The slice operation gets a column range. So if you start at
111:ticks and end at 444:ticks you are asking for all the column in
between.
it is not possible to filter at each level of a composite column.
Hope that helps.
-
Aaron Morton
Free
> but it still seem a bit strange coming from years and years of sql.
Think of the composite column name as a composite key. You want to write an
efficient query that uses a seek and partial scan of the index b-tree, rather
than a full scan.
> split this CF into two?
Or change the or
and end at 444:ticks you are asking for all the column in between.
it is not possible to filter at each level of a composite column.
Hope that helps.
-
Aaron Morton
Freelance Developer
@aaronmorton
http://www.thelastpickle.com
On 10/02/2012, at 10:58 PM, Deno Vichas wrote:
all
If you want to get all the tick between two integers yes.
A
-
Aaron Morton
Freelance Developer
@aaronmorton
http://www.thelastpickle.com
On 14/02/2012, at 8:36 AM, Dave Brosius wrote:
> if the composite column was rearranged as
>
> ticks:111
>
> wouldn
if the composite column was rearranged as ticks:111wouldn't the result be as
desired? - Original Message -From: "aaron morton"
>;aa...@thelastpickle.com
111:ticks and end
at 444:ticks you are asking for all the column in between.
it is not possible to filter at each level of a composite column.
Hope that helps.
-
Aaron Morton
Freelance Developer
@aaronmorton
http://www.thelastpickle.com
On 10/02/2012, at 10:58 PM, Deno Vichas
all,
could somebody clue me to why the below code doesn't work. my schema is;
create column family StockHistory
with comparator = 'CompositeType(LongType,UTF8Type)'
and default_validation_class = 'UTF8Type'
and key_validation_class = 'UTF8Type';
the time part works but i'm gettin
> It is a sweet documentation but it doesn't help me. I a lower level
> documntation
Read the docs and then read the code to see how it works in pycassa.
Otherwise if you want low level docs the cassandra code is the place to go.
Cheers
-
Aaron Morton
Freelance Developer
@aaron
On Thu, Jan 5, 2012 at 9:13 PM, aaron morton wrote:
> What client are you using ?
>
I am writing a client.
> For example pycassa has some sweet documentation
> http://pycassa.github.com/pycassa/assorted/composite_types.html
>
It is a sweet documentation but it doesn't help me. I a lower level
do
What client are you using ?
For example pycassa has some sweet documentation
http://pycassa.github.com/pycassa/assorted/composite_types.html
Cheers
-
Aaron Morton
Freelance Developer
@aaronmorton
http://www.thelastpickle.com
On 6/01/2012, at 12:48 AM, Shimi Kiviti wrote:
> Is
Is there a doc for using composite columns with thrift?
Is
https://github.com/apache/cassandra/blob/trunk/src/java/org/apache/cassandra/db/marshal/CompositeType.java
the
only doc?
does the client needs to add the length to the get \ get_slice... queries
or is it taken care of on the server side?
S
pache/cassandra/blob/trunk/src/java/org/apache/cassandra/db/marshal/CompositeType.java
> >>
> >> Hope that helps.
> >> Aaron
> >>
> >> -
> >> Aaron Morton
> >> Freelance Developer
> >> @aaronmorton
> >&g
/blob/trunk/src/java/org/apache/cassandra/db/marshal/CompositeType.java
>>
>> Hope that helps.
>> Aaron
>>
>> -
>> Aaron Morton
>> Freelance Developer
>> @aaronmorton
>> http://www.thelastpickle.com
>>
>> On 2/01/2012, at 6:
-
> Aaron Morton
> Freelance Developer
> @aaronmorton
> http://www.thelastpickle.com
>
> On 2/01/2012, at 6:25 PM, Ertio Lew wrote:
>
> I am storing composite column names which are made up of two integer
> components. However I am shocked after seeing the
Developer
@aaronmorton
http://www.thelastpickle.com
On 2/01/2012, at 6:25 PM, Ertio Lew wrote:
> I am storing composite column names which are made up of two integer
> components. However I am shocked after seeing the storage overhead of these.
>
> I just tried out a composite name
I am storing composite column names which are made up of two integer
components. However I am shocked after seeing the storage overhead of these.
I just tried out a composite name (with single integer component):
Composite composite = new Composite();
composite.addComponent
On Wed, Dec 21, 2011 at 7:04 AM, Martin Arrowsmith
wrote:
> Dear Cassandra Experts,
>
> Are the number of composite attributes fixed for each column family ?
>
> I have been doing : "create column family MyCF with comparator =
> 'CompositeType(IntegerType, UTF8Type)'
>
> And this creates a composi
Dear Cassandra Experts,
Are the number of composite attributes fixed for each column family ?
I have been doing : "create column family MyCF with comparator =
'CompositeType(IntegerType, UTF8Type)'
And this creates a composite { integer:string }
Hector complains when I give a 3rd attribute.
If
sing Hector to implement and query information from Composite Columns.
>
> I found this site to be quite useful:
> http://randomizedsort.blogspot.com/2011/11/cassandra-range-query-using.html
>
> It goes through the steps of creating a composite column, to perform simple
> quer
Dear Cassandra and Hector experts,
I am using Hector to implement and query information from Composite Columns.
I found this site to be quite useful:
http://randomizedsort.blogspot.com/2011/11/cassandra-range-query-using.html
It goes through the steps of creating a composite column, to perform
Hi Jim,
The best resource I know so far is
http://www.slideshare.net/edanuff/indexing-in-cassandra
I just started working on a blog post about them last night, and I hope to
update the wiki with some information when I am done. Feel free to mail me
directly if you want to collaborate.
I'm
Using Cassandra 0.8.6, I've been trying to figure out how to use the
CLI to create column families using composite keys and column names.
The documentation on CompositeType seems pretty skimpy. But in the
course of writing this email to ask how to do it, I figured out the
proper syntax. In the hope
t;
. This works because ; is the character right after : in ASCII. I believe that
UNICODE is ordered similarly to ASCII, though I am not 100% sure on that issue.
- Original Message -
From: "Renato Costa"
To: user@cassandra.apache.org
Sent: Thursday, September 22, 2011 6:35
Hi,
I started do modeling my application over cassandra data model. I will have
to use composite Super columns name, i.e. "username:userid", i know that is
a lot of different ways to deal with this case, but once i have modeled with
composite Super Columns name is there any way to make a sarch ove
x27;constituent3'] = val
>> >
>> >
>> > On Tue, May 17, 2011 at 2:15 AM, Sameer Farooqui
>> >
>> > wrote:
>> >>
>> >> Cassandra wouldn't know that the column name is composite of two
>> >> different
>
gt; >> things. So you could just request the column names and values for a
> specific
> >> key like this and then just look at the column names that get returned:
> >> [default@MyKeyspace] get DemoCF[ascii('key_42')];
> >> => (column=CA_SanJose, value=50, tim
lt@MyKeyspace] get DemoCF[ascii('key_42')];
>> => (column=CA_SanJose, value=50, timestamp=1305236885112000)
>> => (column=CA_PaloAlto, value=49, timestamp=1305236885192000)
>> => (column=FL_Orlando, value=45, timestamp=130523688528)
>> => (column=N
tamp=130523688528)
> => (column=NY_NYC, value=40, timestamp=1305236885361000)
>
>
> And I'm not sure what you mean by inputting composite column names. You
> just input them like any other column name:
>
> [default@MyKeyspace] set DemoCF['key_42']['CA_S
(column=CA_SanJose, value=50, timestamp=1305236885112000)
=> (column=CA_PaloAlto, value=49, timestamp=1305236885192000)
=> (column=FL_Orlando, value=45, timestamp=130523688528)
=> (column=NY_NYC, value=40, timestamp=1305236885361000)
And I'm not sure what you mean by inputting
What do you mean by composite column names?
Do the data type functions supported by get and set help? Or the assume
statement?
Aaron
On 17/05/2011, at 3:21 AM, David Boxenhorn wrote:
> Is there a way to view composite column names in the CLI?
>
> Is there a way to input them (i.e. i
Is there a way to view composite column names in the CLI?
Is there a way to input them (i.e. in the set command)?
Thanks Aaron, very useful. I'll give some of your suggestions a go...
On 16 May 2011 19:13, aaron morton wrote:
> I'd stick with the RandomPartitioner until you have a really good reason to
> change :)
>
> I'd also go with your alternative design with some possible tweaks.
>
> Consider partition
I'd stick with the RandomPartitioner until you have a really good reason to
change :)
I'd also go with your alternative design with some possible tweaks.
Consider partitioning the rows by year or some other sensible value. If you
will generally be getting the most recent data this can reduce
Hi All,
New to Cassandra, so apologies if I don't fully grok stuff just yet.
I have data keyed by a key as well as a date. I want to run a query to get
multiple keys across multiple contiguous date ranges simultaneously. I'm
currently storing the date along with the row key like this:
key1|2011-
99 matches
Mail list logo
