MemSQL has introduced a new beta delivering Full Text Search with standard SQL. This broadens our data type support to cover relational, JSON, Geospatial, and now text. We leveraged the industry-standard Lucene engine and syntax to deliver a Full Text Index for scanning text data in MemSQL.
The benefits include:
High performance text search
Text search indexes are automatically distributed using the power of multiple nodes in parallel
Create a text index by adding a single line to the Create Table statement
Query the index using standard SQL, coupling Lucene query syntax with SQL to combine structured and full-text filters in a single query
Full Text Search works with all MemSQL management and security functions, such as RBAC and auditing