Catalog
null
Database
存储组全名,如 root.sg
Schema
存储组全名,如 root.sg
Table
- 默认的设备数据表:_defaultDeviceTable
- 每个设备类型一个表
- deviceType1
- deviceType2
- 宽表:_defaultWideTable
Column
- 默认的设备数据表:time,device,s1,s2, ...
- 一个设备类型表:time,device,s1,s2, ...
- 宽表:time,root.sg.d1.s1, root.sg.d1.s2, ...
Primary key
- 默认的设备数据表:time,device
- 一个设备类型表:time,device
- 宽表:time
SQL Example:
SELECT *, ‘1’ FROM "root.sg"._defaultDeviceTable
WHERE device = ‘root.sg.d1’ AND ("time" < 4 OR s1 < 20) LIMIT 2 OFFSET 1;
SELECT *, ‘1’ FROM "root.sg".devicetype1
WHERE device = ‘root.sg.d1’ AND ("time" < 4 OR s1 < 20) LIMIT 2 OFFSET 1;
SELECT *, ‘1’ FROM "root.sg".devicetype2
WHERE device = ‘root.sg.d1’ AND ("time" < 4 OR s1 < 20) LIMIT 2 OFFSET 1;
SELECT *, ‘1’ FROM "root.sg"._defaultWideTable
WHERE device = ‘root.sg.d1’ AND ("time" < 4 OR s1 < 20) LIMIT 2 OFFSET 1;