openTSDB 2.X Query Filters

openTSDB 2.X Query Filters

Filters 目前只对tag values有效

literal_or
精准匹配，大小写敏感，多个以‘|’分割

host=literal_or(tagv1|tagv2|tagv3)
类似SQL: WHERE host IN (‘tagv1’, ‘tagv2’, ‘tagv3’)
host=literal_or(tagv1)
类似SQL: WHERE host = ‘tagv1’

ilteral_or
精准匹配，忽略大小写，多个以‘|’分割

host=ilteral_or(tagV1|tagV2|tagV3)
类似SQL: WHERE host IN (‘tagV1’, ‘tagV2’, ‘tagV3’)
host=ilteral_or(tagV1)
类似SQL: WHERE host = ‘tagV1’

not_literal_or
非匹配，大小写敏感，多个以‘|’分割，与literal_or对应

host=not_literal_or(tagv1|tagv2|tagv3)
类似SQL: WHERE host NOT IN (‘tagv1’, ‘tagv2’, ‘tagv3’)
host=not_literal_or(tagv1)
类似SQL: WHERE host <> ‘tagv1’

not_iliteral_or
非匹配，忽略大小写，多个以‘|’分割，与ilteral_or对应

host=not_iliteral_or(tagV1|tagV2|tagV3)
类似SQL: WHERE host NOT IN (‘tagV1’, ‘tagV2’, ‘tagV3’)
host=not_iliteral_or(tagV1)
类似SQL: WHERE host <> ‘tagV1’

wildcard
通配符匹配，大小写敏感

host=wildcard(tag*)
类似 SQL: WHERE host=‘tag%’

iwildcard
通配符匹配，忽略大小写

host=wildcard(taG*)
类似 SQL: WHERE host=‘taG%’

regexp
正则匹配

regexp(tag.*)
类似 SQL: WHERE host REGEXP ‘tag.*’