Tested in Aqua Data Studio 14.0.3-4 Build #: 34540 on Ubuntu 12.04(Cassandra 2.0.1)
Query builder automatically adds table name to the column name in WHERE and ORDER BY clauses. This does not correct for Cassandra and such quiries do not work. I played with many options in File/Options but can't change this
E.g.
select "id" from "idtable" where "idtable"."id"=1
In the toolbar, you'll see an option called 'Filters'. Click on it & then uncheck 'Fully Qualified Tables' - as a UI improvement, we could disable this option for Cassandra
Sachin, do you mean tool bar in the Query Builder? I have unchecked 'Fully Qualified Tables' but this is for adding keyspace name to the table name in the FROM but not for table name to the column name. Seems this option not need to be disabled.
Sachin, do you mean tool bar in the Query Builder? I have unchecked 'Fully Qualified Tables' but this is for adding keyspace name to the table name in the FROM but not for table name to the column name. Seems this option not need to be disabled.
Slava, you are correct.
@Jenny: for v14, we could ignore the Fully Qualified Tables checkbox for Cassandra. Seems that is what we do for MySQL?
Slava, you are correct.
@Jenny: for v14, we could ignore the Fully Qualified Tables checkbox for Cassandra. Seems that is what we do for MySQL?
Verified in Aqua Data Studio 14.0.3-14 Build #: 34647 on Ubuntu 12.04(Cassandra 2.0.1)
Verified in Aqua Data Studio 14.0.3-14 Build #: 34647 on Ubuntu 12.04(Cassandra 2.0.1)
Incorporated the fix in new Query Builder v15. Svn# 34734
Incorporated the fix in new Query Builder v15. Svn# 34734
Issue #10624 |
Closed |
Fixed |
Resolved |
Completion |
No due date |
Fixed Build ADS 14.0.3-8 |
No time estimate |
In the toolbar, you'll see an option called 'Filters'. Click on it & then uncheck 'Fully Qualified Tables' - as a UI improvement, we could disable this option for Cassandra