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