DML example,
insert into user_score_v3(name, highscore, x,y,z)
values ('abc', 299.76, 1001, '*', '*');
...
2012/4/26 Data Craftsman :
> Data model:
>
> REM CQL 3.0
>
>
> $> cqlsh --cql3
>
> drop COLUMNFAMILY user_score_v3;
>
> CREATE COLUMNFAMILY user_score_v3
> (name varchar,
> highscore
Data model:
REM CQL 3.0
$> cqlsh --cql3
drop COLUMNFAMILY user_score_v3;
CREATE COLUMNFAMILY user_score_v3
(name varchar,
highscore float,
x int,
y varchar,
z varchar,
PRIMARY KEY (name, highscore)
);
DML is as usual, as commom, as RDBMS SQL.
Query:
Top 3,
SELECT name, highscore,
