mobile apps singapore,singapore web design services,mobile app development singapore,web application singapore,design agency singapore,web development company singapore,singapore mobile application developer,developer in singapore,mobile developer singapore,design firms in singapore,website developer singapore,app development singapore,mobile app developer singapore,singapore mobile app developer,singapore app developer,mobile application development singapore,mobile game developer singapore,ios app development singapore,web design company singapore,ruby on rails developer singapore,web design singapore,web designer singapore,mobile apps development singapore,singapore web design,website development singapore,website designer singapore,android developer singapore,web design services singapore,singapore website design,mobile application developer singapore,developers in singapore,graphic designer in singapore,web development singapore,website design singapore,singapore web development,ios developer singapore,app developer singapore

CQL, the Cassandra Query Language


CREATE COLUMNFAMILY users (
...     key varchar PRIMARY KEY,
...     full_name varchar,
...     birth_date int,
...     state varchar ... );

CREATE INDEX ON users (birth_date);
CREATE INDEX ON users (state);

INSERT INTO users (key, full_name, birth_date, state) VALUES ('bsanderson', 'Brandon Sanderson', 1975, 'UT');
INSERT INTO users (key, full_name, birth_date, state) VALUES ('prothfuss', 'Patrick Rothfuss', 1973, 'WI');
INSERT INTO users (key, full_name, birth_date, state) VALUES ('htayler', 'Howard Tayler', 1968, 'UT');

SELECT key, state FROM users;
key        | state |
bsanderson |    UT |
prothfuss  |    WI |
htayler    |    UT |

SELECT * FROM users WHERE state='UT' AND birth_date > 1970;
KEY        | birth_date |         full_name | state |
bsanderson |       1975 | Brandon Sanderson |    UT |

HBase has PigLatin, now Cassandra has CQL. It’s a natural evolve step for distributed databases that depend of Map-Reduce to query and processing data.

Malcare WordPress Security