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

%d bloggers like this:
WordPress