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.*’