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?

Sobersided

Answer 1

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.

Terrel

Thanks a lot for your help ! It seems like Cassandra doesn't support using aliases in queries :/ – Sobersided

@Sobersided Dont forget, CQL is still fairly new and its feature set is growing rapidly! Perhaps you can propose the 'as' alias to be a future feature in the CQL select statement. – Terrel

Answer 2

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;

Undenominational