[
https://issues.apache.org/jira/browse/CASSANDRA-11851?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Alex Petrov resolved CASSANDRA-11851.
-------------------------------------
Resolution: Not A Problem
Table aliases are not supported in CQL because in Cassandra you usually select
from just one table, so {{AS}} would be kind of redundant as you'd have to
specify alias instead of simply specifying column name.
Column aliases are, however, supported. You can read more here:
[http://www.datastax.com/dev/blog/cql-in-cassandra-2-0]
> Table alias not supported
> --------------------------
>
> Key: CASSANDRA-11851
> URL: https://issues.apache.org/jira/browse/CASSANDRA-11851
> Project: Cassandra
> Issue Type: Bug
> Components: CQL
> Environment: [cqlsh 4.1.1 | Cassandra 2.0.17 | CQL spec 3.1.1 |
> Thrift protocol 19.39.0]
> Reporter: Prajakta Bhosale
> Priority: Minor
>
> Table alias not supported in CQL ... Getting below error message while
> accessing it ...
> {code}
> cqlsh:test>select e.emp_id from emp e;
> Bad Request: line 1:25 no viable alternative at input 'e'
> {code}
> Same query is working with w/o alias name as well as with column alias....
> Below are version details :
> {code}
> show version
> [cqlsh 4.1.1 | Cassandra 2.0.17 | CQL spec 3.1.1 | Thrift protocol 19.39.0]
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
