iotdb常用命令

 

 

#查看组
SHOW STORAGE GROUP
#创建TIMESERIES
CREATE TIMESERIES root.ln.wf01.wt01.status WITH DATATYPE=BOOLEAN, ENCODING=PLAIN
CREATE TIMESERIES root.ln.wf01.wt01.temperature WITH DATATYPE=FLOAT, ENCODING=RLE
CREATE TIMESERIES root.ln.wf01.wt01.dag_id WITH DATATYPE=TEXT, ENCODING=PLAIN
CREATE TIMESERIES root.ln.wf01.wt01.id WITH DATATYPE=INT32, ENCODING=PLAIN
CREATE TIMESERIES root.ln.wf01.wt01.state WITH DATATYPE=TEXT, ENCODING=PLAIN
#查看表
SHOW TIMESERIES
SHOW TIMESERIES root.ln.wf01.wt01.status
#插入数据
INSERT INTO root.ln.wf01.wt01(timestamp,status) values(100,true);
INSERT INTO root.ln.wf01.wt01(timestamp,status,temperature) values(200,false,20.71)
INSERT INTO root.ln.wf01.wt01(timestamp,id,dag_id,state) values(400,1,'test','success')
#查询数据
SELECT status FROM root.ln.wf01.wt01
SELECT id,dag_id,state FROM root.ln.wf01.wt01

# 插入更新 别名、标签、属性
ALTER timeseries root.turbine.d1.s1 UPSERT ALIAS=newAlias TAGS(unit=Degree, owner=me) ATTRIBUTES(description=ha, newAttr=v1)
# 删除表
delete from root.ln.wf01.wt01
# 查询最大最小时间
select MIN_TIME(id),MAX_TIME(id) from root.ln.wf01.wt01
#插入当前时间
insert into root.ln.wf01.wt01(timestamp,id,dag_id,state) values(now(),1,'www','failure')