Is there any query for Cassandra as same as SQL:LIKE Condition?

by

Since Cassandra 3.4 (3.5 recommended), LIKE queries can be achieved using a SSTable Attached Secondary Index (SASI).

For example:

CREATE TABLE cycling.cyclist_name ( 
  id UUID PRIMARY KEY, 
  lastname text, 
  firstname text
);

Creating the SASI as follows:

CREATE CUSTOM INDEX  fn_prefix ON cyclist_name (firstname)
USING 'org.apache.cassandra.index.sasi.SASIIndex';

Then a prefix LIKE query is working:

SELECT * FROM cyclist_name WHERE firstname LIKE 'M%';
SELECT * FROM cyclist_name WHERE firstname LIKE 'Mic%';

These examples and more configuration options, like suffix queries, can be found in the documentation

A more in depth explanation about how SASI works can be found here.

More Related Contents:

  1. SQL query for salary in emp table
  2. What is wrong with this DB Diagram? [closed]
  3. SQL Combine two rows into one
  4. I’m getting ‘Column name is invalid in the select list’ error when i execute the query
  5. SQL Server Subquery a
  6. You can’t specify target table for update in FROM clause
  7. Not equal != operator on NULL
  8. SET NOCOUNT ON usage
  9. Oracle: how to UPSERT (update or insert into a table?)
  10. How can I get column names from a table in SQL Server?
  11. How can I select the first day of a month in SQL?
  12. Copy tables from one database to another in SQL Server
  13. What are valid table names in SQLite?
  14. error, string or binary data would be truncated when trying to insert
  15. What exactly do quotation marks around the table name do?
  16. Reset auto increment counter in postgres
  17. JOIN two SELECT statement results
  18. What mysql database tables and relationships would support a Q&A survey with conditional questions? [closed]
  19. sqlite database default time value ‘now’
  20. How can I send email from PostgreSQL trigger?
  21. “select * from table” vs “select colA, colB, etc. from table” interesting behaviour in SQL Server 2005
  22. Is it possible to run native sql with entity framework?
  23. Postgres sql insert query syntax error from phpPgAdmin
  24. What are views good for?
  25. SQLite auto-increment non-primary key field
  26. SQL ORDER BY date problem
  27. The object ‘DF__*’ is dependent on column ‘*’ – Changing int to double
  28. Regular Expression to Match All Comments in a T-SQL Script
  29. How to combine aggregate functions in MySQL?
  30. Oracle- Split string comma delimited (string contains spaces and consecutive commas)

Leave a Comment