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

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 Security