Return
-
Title
Converting from existing tool set (datastax) to Toad Data Point but can't connect to Cassandra DB. -
Description
Converting from existing tool set (datastax) to Toad data point but having an issue connecting to Cassandra. -
Resolution
The real issue is tables created in recent Cassandra versions without the compact storage option aren't visible to thrift-based clients such as Toad Data Point. As no tables are visible an error is raised.http://www.datastax.com/documentation/cql/3.0/cql/ddl/ddl_legacy_tables_c.html“You can create Thrift/CLI-compatible tables in CQL 3 using the COMPACT STORAGE directive”. Tables created without the COMPACT STORAGE directive created in CQL3 can’t be used by older (thrift-based) applications. If you create Cassandra tables using this directive, you should be able to query them in Toad Data Point.We are working on supporting the CQL3 API which should be in the next release.