Although CQL and SQL have a similar syntax, there are many differences that may confuse users. I will explain what the CQL WHERE clause supports and how Cassandra processes it internally.
Benjamin Lerer - DataStax
Benjamin Lerer is a software engineer at DataStax where he is working on the Cassandra CQL layer. Prior to that he worked 7 years for a High Frequency Trading Company.