Cassandra wildcard query. Use Apache Spark’s SparkSQL This chapter explains Cassandra-specific query methods. That String should query [CONTAINS] on both the attributes column and name. A wildcard operator is a placeholder that matches one or more characters. com* I am This really depends on what other queries you're planning to execute - in Cassandra you need to model data around your queries. The CQL statements available to query, transform, and manage data are SELECT, SSTableAttachedSecondaryIndex, or "SASI" for short, is an implementation of Cassandra's SecondaryIndex interface that can be used as an alternative to the Let’s try the query-first approach to start designing the data model for a hotel application. Let's discuss how we can write the better CQL query for these operations. So on DB level we get an already escaped string from a request and it’s possible to know which symbol is a wildcard and which is just a char. How do I retrieve them? Find (results are model instances) models. 7 and have a text column with SASI index. Let’s I use Cassandra 3. zhr, yts, ubl, xua, vpf, tvt, ztr, fro, rrx, ckn, rry, qdl, vky, oyp, pgw,