PowerExchange for Cassandra User Guide

10.5.9
- 10.5.8
- 10.5.7
- 10.5.6
- 10.5
- 10.4.0

Back Next

Query Mode

You can use PowerExchange for Cassandra to process the queries as SQL statement or as CQL statement. The Cassandra ODBC driver uses SQL with CQL fallback as the default query mode.

You can select one of the following query modes:

SQL: The ODBC driver treats all incoming queries as SQL and does not accept any CQL query syntax that is not standard SQL-92 syntax.
CQL: The ODBC driver treats all incoming queries as CQL and does not accept any non-CQL syntax.
SQL with CQL Fallback: The driver tries to treat the incoming query as SQL. If an error occurs while handling the query as SQL, the driver then passes the original query to Cassandra to execute as CQL. SQL with CQL fallback is the default query mode used by the ODBC driver.