Isn’t the correct way to do this in CQL3 to use sets and user defined types (in
C* 2.1) ?:
create type sensorreading( date timestamp, name text, value int);
CREATE TABLE sensordata (
name text,
data set>,
PRIMARY KEY (name)
);
insert into keyspace2.sensordata (name, data) values ('1234', {{date:
On Thu, Sep 25, 2014 at 6:13 AM, shahab wrote:
> It seems that I was not clear in my question, I would like to store values
> in the column name, for example column.name would be event_name
> ("temperature") and column-content would be the respective value (e.g.
> 40.5) . And I need to know how t
I’m not sure I understand correctly “for example column.name would be
event_name("temperature")“, what I gather however is that you have multiple
events that may or may not have certain properties, in your example I
believe you mean you want a CF for events with a type event_name that
contains a co
Thanks,
It seems that I was not clear in my question, I would like to store values
in the column name, for example column.name would be event_name
("temperature") and column-content would be the respective value (e.g.
40.5) . And I need to know how the schema should look like in CQL 3
best,
/Shaha
Dynamic thing in Thrift ≈ clustering columns in CQL
Can you give more details about your data model ?
On Wed, Sep 24, 2014 at 1:11 PM, shahab wrote:
> Hi,
>
> I would like to define schema for a table where the column (cell) names
> are defined dynamically. Apparently there is a way to do this
Hi,
I would like to define schema for a table where the column (cell) names
are defined dynamically. Apparently there is a way to do this in Thrift (
http://www.datastax.com/dev/blog/does-cql-support-dynamic-columns-wide-rows)
but i couldn't find how i can do the same using CQL?
Any resource/ex
