Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
Tested in Aqua Data Studio 14.0.3-14 Build #: 34647 on Ubuntu 12.04(Cassandra 2.0.1)
There is an editable column "Alias" in QB. But anything written there does not come to the SELECT statement.
Can you attach a sample sql which supports alias in Cassandra ? I tried the different combinations as in the attached screenshot and I got syntax error for all the combinations that uses alias.
Even though the CQL3 shows Any <selector> can be aliased using AS keyword (see examples).
in the link, http://cassandra.apache.org/doc/cql3/CQL.html I tried but could not see the same behaviour.
Tarif, alias it is indentifier. So it is name without quotes or in double quotes prefixed with " as " .
Tarif, alias it is indentifier. So it is name without quotes or in double quotes prefixed with " as " .
Thanks, below works
SELECT empid as c FROM emp
GO
SELECT empid as "c" FROM emp
GO
Thanks, below works
SELECT empid as c FROM emp
GO
SELECT empid as "c" FROM emp
GO
Column alias is supported in Cassandra 2.0 only.
For Cassandra 1.2, Query Builder continues to ignore the Alias field.
For Cassandra 2.0, Query Builder now applies the Alias field to the generated SELECT statement.
Column alias is supported in Cassandra 2.0 only.
For Cassandra 1.2, Query Builder continues to ignore the Alias field.
For Cassandra 2.0, Query Builder now applies the Alias field to the generated SELECT statement.
Re-opening to make sure it is incorporated in the new query builder
Re-opening to make sure it is incorporated in the new query builder
In new QueryBuilder, following is the behavior for Cassandra
In new QueryBuilder, following is the behavior for Cassandra
verified in ADS 15.0.0 dev-227
verified in ADS 15.0.0 dev-227
Issue #10674 |
| Closed |
| Fixed |
| Resolved |
Completion |
| No due date |
| Fixed Build ADS 15.0.0-dev-35 |
| No time estimate |
Can you attach a sample sql which supports alias in Cassandra ? I tried the different combinations as in the attached screenshot and I got syntax error for all the combinations that uses alias.
Even though the CQL3 shows Any
<selector>can be aliased usingASkeyword (see examples).in the link, http://cassandra.apache.org/doc/cql3/CQL.html I tried but could not see the same behaviour.