Limits on LindormSearch SQL syntax
Updated at:
LindormSearch supports a subset of SQL for querying search indexes. This page lists the supported conditional expressions and the constraints that apply.
Supported conditional expressions
The following operators and clauses are supported in queries.
| Expression | Description | Example |
|---|---|---|
OR, AND | Logical operators for combining conditions | WHERE c1 = 'a' AND c2 > 10 |
LIKE, NOT LIKE | Wildcard pattern matching on string fields | WHERE name LIKE 'ali%' |
IS NULL, NOT NULL | Match columns with or without a value | WHERE c1 IS NULL |
BETWEEN ... AND ... | Inclusive range match | WHERE c1 BETWEEN 2 AND 4 |
=, >, <, >=, <=, <> | Comparison operators | WHERE c1 >= 10 |
IN, NOT IN | Match against a set of values | WHERE p2 IN ('a', 'b') |
GROUP BY | Group rows sharing the same value | SELECT c1, Sum(c2) FROM dt WHERE p2 IN ('a', 'b') GROUP BY c1; |
ORDER BY | Sort query results in ascending or descending order | SELECT * FROM dt WHERE p2 IN ('a', 'b') ORDER BY c1;SELECT * FROM dt WHERE p2 IN ('a', 'b') ORDER BY c1 desc; |
Limitations
Data Control Language is not supported
Data Control Language (DCL) is not supported.
Column value length limits
| Scope | Maximum length |
|---|---|
| Single primary key column value | 2 KB |
| Total value length across all primary key columns | 30 KB |
| Single non-primary key column value | 2 MB |
Expressions cannot be used inside aggregate functions
Expressions inside aggregate functions are not supported. For example, SUM(c1+1) is not supported.
Expressions are not supported in WHERE clauses
The WHERE clause does not support expressions. For example, WHERE (a*10) > 100 is not supported.
Only single-table queries are supported
JOIN clauses, subqueries, and UNION clauses are not supported. All queries must target a single table.
Is this page helpful?