Hi all,

Following Dawei's suggestion, I would like to propose a new feature: regex
filter. The filter enables regex matching in the where clause. This
feature increases the expressiveness of IoTDB-SQL and can be useful in many
use cases.

The proposed grammar is as follows

SELECT ... FROM ... WHERE <*A>* MATCHES <*REGEX>*
SELECT ... FROM ... WHERE <*A>* NOT MATCHES <*REGEX>*
where
<A>= the measurement to match.
<REGEX> = the regular expression string literal.

Example:
select city from root.ln.wf01.wt01 where city matches ".*"

Let me know if you have any suggestions of this feature and/or the grammar.

JIRA :  https://issues.apache.org/jira/browse/IOTDB-1175
GitHub issue: https://github.com/apache/iotdb/issues/3362

Thanks,
Liu Jiajun

Reply via email to