singapore mobile application developer,ruby on rails developer singapore,design agency singapore,mobile application developer singapore,mobile developer singapore,developers in singapore,singapore web development,web design services singapore,website developer singapore,singapore app developer,graphic designer in singapore,website development singapore,web design singapore,design firms in singapore,developer in singapore,web development company singapore,mobile app developer singapore,website design singapore,mobile app development singapore,mobile game developer singapore,mobile apps development singapore,singapore website design,singapore mobile app developer,app developer singapore,ios developer singapore,singapore web design,android developer singapore,web application singapore,singapore web design services,app development singapore,web designer singapore,web design company singapore,mobile apps singapore,mobile application development singapore,website designer singapore,web development singapore,ios app development 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