Aliases in Cassandra CQL

Question

My question is about using aliases in CQL queries.
For example in SQL we can write:

SELECT p.name FROM Persons as p  

Is there something similar in CQL?

Answer 1

From cassandra 2.0, CQL 3 supports aliases in SELECT

http://www.datastax.com/dev/blog/cql-in-cassandra-2-0

SELECT event_id, dateOf(created_at) AS creation_date, blobAsText(content) AS content FROM timeline;

Answer 2

When I browsed through the documentation of CQL3 I didn't find any reference to using the as alias.

I'd advise you to have a read through datastax's documentation on what the SELECT statement can and cant do in `CQL 3.