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