键值对

键值对的键和值可以被定义为标识符或者常量。

下面将介绍键值对的使用场景。

  • 触发器中表示触发器属性的键值对。参考示例语句中 WITH 后的属性键值对。
  1. # 以字符串形式表示键值对
  2. CREATE TRIGGER `alert-listener-sg1d1s1`
  3. AFTER INSERT
  4. ON root.sg1.d1.s1
  5. AS 'org.apache.iotdb.db.engine.trigger.example.AlertListener'
  6. WITH (
  7.   'lo' = '0', 
  8.   'hi' = '100.0'
  9. )
  11. # 以标识符和常量形式表示键值对
  12. CREATE TRIGGER `alert-listener-sg1d1s1`
  13. AFTER INSERT
  14. ON root.sg1.d1.s1
  15. AS 'org.apache.iotdb.db.engine.trigger.example.AlertListener'
  16. WITH (
  17.   lo = 0, 
  18.   hi = 100.0
  19. )
  • 时间序列中用于表示标签和属性的键值对。
  1. # 创建时间序列时设定标签和属性，用字符串来表示键值对。
  2. CREATE timeseries root.turbine.d1.s1(temprature) 
  3. WITH datatype = FLOAT, encoding = RLE, compression = SNAPPY, 'max_point_number' = '5'
  4. TAGS('tag1' = 'v1', 'tag2'= 'v2') ATTRIBUTES('attr1' = 'v1', 'attr2' = 'v2')
  6. # 创建时间序列时设定标签和属性，用标识符和常量来表示键值对。
  7. CREATE timeseries root.turbine.d1.s1(temprature) 
  8. WITH datatype = FLOAT, encoding = RLE, compression = SNAPPY, max_point_number = 5
  9. TAGS(tag1 = v1, tag2 = v2) ATTRIBUTES(attr1 = v1, attr2 = v2)
  1. # 修改时间序列的标签和属性
  2. ALTER timeseries root.turbine.d1.s1 SET 'newTag1' = 'newV1', 'attr1' = 'newV1'
  4. ALTER timeseries root.turbine.d1.s1 SET newTag1 = newV1, attr1 = newV1
  1. # 修改标签名
  2. ALTER timeseries root.turbine.d1.s1 RENAME 'tag1' TO 'newTag1'
  4. ALTER timeseries root.turbine.d1.s1 RENAME tag1 TO newTag1
  1. # 插入别名、标签、属性
  2. ALTER timeseries root.turbine.d1.s1 UPSERT 
  3. ALIAS='newAlias' TAGS('tag2' = 'newV2', 'tag3' = 'v3') ATTRIBUTES('attr3' ='v3', 'attr4'='v4')
  5. ALTER timeseries root.turbine.d1.s1 UPSERT 
  6. ALIAS = newAlias TAGS(tag2 = newV2, tag3 = v3) ATTRIBUTES(attr3 = v3, attr4 = v4)
  1. # 添加新的标签
  2. ALTER timeseries root.turbine.d1.s1 ADD TAGS 'tag3' = 'v3', 'tag4' = 'v4'
  4. ALTER timeseries root.turbine.d1.s1 ADD TAGS tag3 = v3, tag4 = v4
  1. # 添加新的属性
  2. ALTER timeseries root.turbine.d1.s1 ADD ATTRIBUTES 'attr3' = 'v3', 'attr4' = 'v4'
  4. ALTER timeseries root.turbine.d1.s1 ADD ATTRIBUTES attr3 = v3, attr4 = v4
  1. # 查询符合条件的时间序列信息
  2. SHOW timeseries root.ln.** WHRER 'unit' = 'c'
  4. SHOW timeseries root.ln.** WHRER unit = c
  • 创建 Pipe 以及 PipeSink 时表示属性的键值对。
  1. # 创建 PipeSink 时表示属性
  2. CREATE PIPESINK my_iotdb AS IoTDB ('ip' = '输入你的IP')
  4. # 创建 Pipe 时在 WITH 子句中表示属性
  5. CREATE PIPE my_pipe TO my_iotdb FROM 
  6. (select ** from root WHERE time>=yyyy-mm-dd HH:MM:SS) WITH 'SyncDelOp' = 'true'