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;