| <!DOCTYPE html> |
| <html lang="en-US"> |
| <head> |
| <meta charset="utf-8"> |
| <meta name="viewport" content="width=device-width,initial-scale=1"> |
| <title> </title> |
| <meta name="generator" content="VuePress 1.7.1"> |
| <link rel="icon" href="/favicon.ico"> |
| <meta name="description" content=" "> |
| <meta name="Description" content="Apache IoTDB: Time Series Database for IoT"> |
| <meta name="Keywords" content="TSDB, time series, time series database, IoTDB, IoT database, IoT data management,时序数据库, 时间序列管理, IoTDB, 物联网数据库, 实时数据库, 物联网数据管理, 物联网数据"> |
| <meta name="baidu-site-verification" content="wfKETzB3OT"> |
| <meta name="google-site-verification" content="mZWAoRY0yj_HAr-s47zHCGHzx5Ju-RVm5wDbPnwQYFo"> |
| |
| <link rel="preload" href="/assets/css/0.styles.679f71b6.css" as="style"><link rel="preload" href="/assets/js/app.ee472f44.js" as="script"><link rel="preload" href="/assets/js/3.49f0f20a.js" as="script"><link rel="preload" href="/assets/js/83.e5773686.js" as="script"><link rel="prefetch" href="/assets/js/10.a9e4399a.js"><link rel="prefetch" href="/assets/js/100.68c72120.js"><link rel="prefetch" href="/assets/js/101.b6fa0a59.js"><link rel="prefetch" href="/assets/js/102.a64e2bb2.js"><link rel="prefetch" href="/assets/js/103.3e232964.js"><link rel="prefetch" href="/assets/js/104.12a0c146.js"><link rel="prefetch" href="/assets/js/105.c82addea.js"><link rel="prefetch" href="/assets/js/106.d95539e1.js"><link rel="prefetch" href="/assets/js/107.3a8e4204.js"><link rel="prefetch" href="/assets/js/108.445910dc.js"><link rel="prefetch" href="/assets/js/109.e592a10a.js"><link rel="prefetch" href="/assets/js/11.1a825151.js"><link rel="prefetch" href="/assets/js/110.f2ff7f26.js"><link rel="prefetch" href="/assets/js/111.ce7b4bb8.js"><link rel="prefetch" href="/assets/js/112.c0fb665c.js"><link rel="prefetch" href="/assets/js/113.27feecaf.js"><link rel="prefetch" href="/assets/js/114.4610bfa2.js"><link rel="prefetch" href="/assets/js/115.0857c1d6.js"><link rel="prefetch" href="/assets/js/116.530d568b.js"><link rel="prefetch" href="/assets/js/117.9deade83.js"><link rel="prefetch" href="/assets/js/118.cbb62265.js"><link rel="prefetch" href="/assets/js/119.8822d43b.js"><link rel="prefetch" href="/assets/js/12.4679de68.js"><link rel="prefetch" href="/assets/js/120.355ddd53.js"><link rel="prefetch" href="/assets/js/121.94505f4a.js"><link rel="prefetch" href="/assets/js/122.6c825584.js"><link rel="prefetch" href="/assets/js/123.d2965d60.js"><link rel="prefetch" href="/assets/js/124.bb17af3e.js"><link rel="prefetch" href="/assets/js/125.a523475b.js"><link rel="prefetch" href="/assets/js/126.309eb2a0.js"><link rel="prefetch" href="/assets/js/127.31f131d5.js"><link rel="prefetch" href="/assets/js/128.d6961094.js"><link rel="prefetch" href="/assets/js/129.9f80c586.js"><link rel="prefetch" href="/assets/js/13.821d2576.js"><link rel="prefetch" href="/assets/js/130.8b3034e2.js"><link rel="prefetch" href="/assets/js/131.5c952a0b.js"><link rel="prefetch" href="/assets/js/132.9b312915.js"><link rel="prefetch" href="/assets/js/133.229545d4.js"><link rel="prefetch" href="/assets/js/134.6ef84d4d.js"><link rel="prefetch" href="/assets/js/135.63dcccc3.js"><link rel="prefetch" href="/assets/js/136.693bbb9e.js"><link rel="prefetch" href="/assets/js/137.065787a2.js"><link rel="prefetch" href="/assets/js/138.199d56aa.js"><link rel="prefetch" href="/assets/js/139.93368911.js"><link rel="prefetch" href="/assets/js/14.f2409887.js"><link rel="prefetch" href="/assets/js/140.cb3339d6.js"><link rel="prefetch" href="/assets/js/141.0ffa040d.js"><link rel="prefetch" href="/assets/js/142.c3e197d4.js"><link rel="prefetch" href="/assets/js/143.9e4dc6ae.js"><link rel="prefetch" href="/assets/js/144.27249482.js"><link rel="prefetch" href="/assets/js/145.f9305e04.js"><link rel="prefetch" href="/assets/js/146.a953796c.js"><link rel="prefetch" href="/assets/js/147.5ffa8a4e.js"><link rel="prefetch" href="/assets/js/148.5f5c0ad8.js"><link rel="prefetch" href="/assets/js/149.6690aae1.js"><link rel="prefetch" href="/assets/js/15.9354febe.js"><link rel="prefetch" href="/assets/js/150.36dae2d3.js"><link rel="prefetch" href="/assets/js/151.2ca29374.js"><link rel="prefetch" href="/assets/js/152.fceb9b61.js"><link rel="prefetch" href="/assets/js/153.93489dbc.js"><link rel="prefetch" href="/assets/js/154.d9c14ff8.js"><link rel="prefetch" href="/assets/js/155.b6eec7f7.js"><link rel="prefetch" href="/assets/js/156.8718f8bc.js"><link rel="prefetch" href="/assets/js/157.8484231e.js"><link rel="prefetch" href="/assets/js/158.d1755131.js"><link rel="prefetch" href="/assets/js/159.8a8be7d5.js"><link rel="prefetch" href="/assets/js/16.590590ab.js"><link rel="prefetch" href="/assets/js/160.67e2efd2.js"><link rel="prefetch" href="/assets/js/161.0e22ffff.js"><link rel="prefetch" href="/assets/js/162.f47c5fdc.js"><link rel="prefetch" href="/assets/js/163.da74b426.js"><link rel="prefetch" href="/assets/js/164.f88f06d5.js"><link rel="prefetch" href="/assets/js/165.9a1b5b41.js"><link rel="prefetch" href="/assets/js/166.8832a7a4.js"><link rel="prefetch" href="/assets/js/167.ff58fb1f.js"><link rel="prefetch" href="/assets/js/168.9a351c30.js"><link rel="prefetch" href="/assets/js/169.23c06c42.js"><link rel="prefetch" href="/assets/js/17.4cb5664d.js"><link rel="prefetch" href="/assets/js/170.ea0af6cf.js"><link rel="prefetch" href="/assets/js/171.e11e1bb7.js"><link rel="prefetch" href="/assets/js/172.273f4d56.js"><link rel="prefetch" href="/assets/js/173.fca03089.js"><link rel="prefetch" href="/assets/js/174.434334ff.js"><link rel="prefetch" href="/assets/js/175.a8acb6b2.js"><link rel="prefetch" href="/assets/js/176.a1c55473.js"><link rel="prefetch" href="/assets/js/177.ebb38cec.js"><link rel="prefetch" href="/assets/js/178.79b8a327.js"><link rel="prefetch" href="/assets/js/179.6319af14.js"><link rel="prefetch" href="/assets/js/18.f5fe433e.js"><link rel="prefetch" href="/assets/js/180.28a1d783.js"><link rel="prefetch" href="/assets/js/181.a29f39c5.js"><link rel="prefetch" href="/assets/js/182.9f3d9c76.js"><link rel="prefetch" href="/assets/js/183.338ae9a8.js"><link rel="prefetch" href="/assets/js/184.18c28159.js"><link rel="prefetch" href="/assets/js/185.05381100.js"><link rel="prefetch" href="/assets/js/186.ce9412eb.js"><link rel="prefetch" href="/assets/js/187.30a80942.js"><link rel="prefetch" href="/assets/js/188.5a77f986.js"><link rel="prefetch" href="/assets/js/189.f34dc967.js"><link rel="prefetch" href="/assets/js/19.d02f7224.js"><link rel="prefetch" href="/assets/js/190.d9762047.js"><link rel="prefetch" href="/assets/js/191.8c52689f.js"><link rel="prefetch" href="/assets/js/192.10ae9786.js"><link rel="prefetch" href="/assets/js/193.4a83ff5f.js"><link rel="prefetch" href="/assets/js/194.1d9f888b.js"><link rel="prefetch" href="/assets/js/195.ac95d80c.js"><link rel="prefetch" href="/assets/js/196.305a7cc8.js"><link rel="prefetch" href="/assets/js/197.3950b155.js"><link rel="prefetch" href="/assets/js/198.60367e76.js"><link rel="prefetch" href="/assets/js/199.a5eec1cf.js"><link rel="prefetch" href="/assets/js/20.02900ba2.js"><link rel="prefetch" href="/assets/js/200.7b42f970.js"><link rel="prefetch" href="/assets/js/201.c176b7b8.js"><link rel="prefetch" href="/assets/js/202.eb6989b5.js"><link rel="prefetch" href="/assets/js/203.77522ed7.js"><link rel="prefetch" href="/assets/js/204.d5e4c11b.js"><link rel="prefetch" href="/assets/js/205.b174d51b.js"><link rel="prefetch" href="/assets/js/206.4c489028.js"><link rel="prefetch" href="/assets/js/207.afdf032a.js"><link rel="prefetch" href="/assets/js/208.e5a0bdd5.js"><link rel="prefetch" href="/assets/js/209.67c9cab8.js"><link rel="prefetch" href="/assets/js/21.3b6ef7f6.js"><link rel="prefetch" href="/assets/js/210.99085605.js"><link rel="prefetch" href="/assets/js/211.62045ced.js"><link rel="prefetch" href="/assets/js/212.5d4b9b33.js"><link rel="prefetch" href="/assets/js/213.8d2fc243.js"><link rel="prefetch" href="/assets/js/214.081b8259.js"><link rel="prefetch" href="/assets/js/215.a9c42b7b.js"><link rel="prefetch" href="/assets/js/216.e4177064.js"><link rel="prefetch" href="/assets/js/217.00d389be.js"><link rel="prefetch" href="/assets/js/218.53691557.js"><link rel="prefetch" href="/assets/js/219.fce8476d.js"><link rel="prefetch" href="/assets/js/22.ab7a2af8.js"><link rel="prefetch" href="/assets/js/220.8ca717ad.js"><link rel="prefetch" href="/assets/js/221.b774095e.js"><link rel="prefetch" href="/assets/js/222.abb49f0a.js"><link rel="prefetch" href="/assets/js/223.506eb112.js"><link rel="prefetch" href="/assets/js/224.7e33133f.js"><link rel="prefetch" href="/assets/js/225.4443cf9b.js"><link rel="prefetch" href="/assets/js/226.5d64564f.js"><link rel="prefetch" href="/assets/js/227.e647cf42.js"><link rel="prefetch" href="/assets/js/228.7b8e1561.js"><link rel="prefetch" href="/assets/js/229.c6b936b3.js"><link rel="prefetch" href="/assets/js/23.b428286f.js"><link rel="prefetch" href="/assets/js/230.484dfbbc.js"><link rel="prefetch" href="/assets/js/231.04cb07f3.js"><link rel="prefetch" href="/assets/js/232.cb5f7cf4.js"><link rel="prefetch" href="/assets/js/233.fd5563aa.js"><link rel="prefetch" href="/assets/js/234.bf0c8bd7.js"><link rel="prefetch" href="/assets/js/235.c910d0ff.js"><link rel="prefetch" href="/assets/js/236.2fa96a32.js"><link rel="prefetch" href="/assets/js/237.4d40bac8.js"><link rel="prefetch" href="/assets/js/238.8f8a5f39.js"><link rel="prefetch" href="/assets/js/239.8c8e2f64.js"><link rel="prefetch" href="/assets/js/24.a3749d36.js"><link rel="prefetch" href="/assets/js/240.b662bcd8.js"><link rel="prefetch" href="/assets/js/241.04b9e3ed.js"><link rel="prefetch" href="/assets/js/242.bae1b833.js"><link rel="prefetch" href="/assets/js/243.174da90a.js"><link rel="prefetch" href="/assets/js/244.1ad856fc.js"><link rel="prefetch" href="/assets/js/245.a622849c.js"><link rel="prefetch" href="/assets/js/246.dc04cc61.js"><link rel="prefetch" href="/assets/js/247.d9f48a2f.js"><link rel="prefetch" href="/assets/js/248.85018b5a.js"><link rel="prefetch" href="/assets/js/249.6ba9e6c7.js"><link rel="prefetch" href="/assets/js/25.bc6a97e8.js"><link rel="prefetch" href="/assets/js/250.9ca65c13.js"><link rel="prefetch" href="/assets/js/251.8f4abe5e.js"><link rel="prefetch" href="/assets/js/252.cb8b4901.js"><link rel="prefetch" href="/assets/js/253.e43c464a.js"><link rel="prefetch" href="/assets/js/254.bc5748be.js"><link rel="prefetch" href="/assets/js/255.ad9c3e74.js"><link rel="prefetch" href="/assets/js/256.48bf6b1c.js"><link rel="prefetch" href="/assets/js/257.aae9e4a7.js"><link rel="prefetch" href="/assets/js/258.d27a0224.js"><link rel="prefetch" href="/assets/js/259.8b338cff.js"><link rel="prefetch" href="/assets/js/26.81ae73cb.js"><link rel="prefetch" href="/assets/js/260.9302e533.js"><link rel="prefetch" href="/assets/js/261.ea1ed48a.js"><link rel="prefetch" href="/assets/js/262.08d81cca.js"><link rel="prefetch" href="/assets/js/263.c2598230.js"><link rel="prefetch" href="/assets/js/264.89fadf4b.js"><link rel="prefetch" href="/assets/js/265.9e7e3b87.js"><link rel="prefetch" href="/assets/js/266.63098760.js"><link rel="prefetch" href="/assets/js/267.df285aaf.js"><link rel="prefetch" href="/assets/js/268.56ef99a0.js"><link rel="prefetch" href="/assets/js/269.86c3bd00.js"><link rel="prefetch" href="/assets/js/27.5361988c.js"><link rel="prefetch" href="/assets/js/270.69d8c77d.js"><link rel="prefetch" href="/assets/js/271.49550e05.js"><link rel="prefetch" href="/assets/js/272.bf7fe25a.js"><link rel="prefetch" href="/assets/js/273.bac87430.js"><link rel="prefetch" href="/assets/js/274.1a5b6778.js"><link rel="prefetch" href="/assets/js/275.59d1fe0c.js"><link rel="prefetch" href="/assets/js/276.c21f1bb7.js"><link rel="prefetch" href="/assets/js/277.3416c059.js"><link rel="prefetch" href="/assets/js/278.1e47cbc9.js"><link rel="prefetch" href="/assets/js/279.a285ca6b.js"><link rel="prefetch" href="/assets/js/28.902cf242.js"><link rel="prefetch" href="/assets/js/280.b1cfd58b.js"><link rel="prefetch" href="/assets/js/281.5014dd8c.js"><link rel="prefetch" href="/assets/js/282.f46c3f5f.js"><link rel="prefetch" href="/assets/js/283.c8fa806b.js"><link rel="prefetch" href="/assets/js/284.1bca3237.js"><link rel="prefetch" href="/assets/js/285.ca102a1f.js"><link rel="prefetch" href="/assets/js/286.312b549d.js"><link rel="prefetch" href="/assets/js/287.56daf71d.js"><link rel="prefetch" href="/assets/js/288.4d6ee237.js"><link rel="prefetch" href="/assets/js/289.8990a52d.js"><link rel="prefetch" href="/assets/js/29.8878a84b.js"><link rel="prefetch" href="/assets/js/290.79c4d4bb.js"><link rel="prefetch" href="/assets/js/291.e39a8f59.js"><link rel="prefetch" href="/assets/js/292.09b1dbf3.js"><link rel="prefetch" href="/assets/js/293.c11758cc.js"><link rel="prefetch" href="/assets/js/294.efe1c620.js"><link rel="prefetch" href="/assets/js/295.9a4ce682.js"><link rel="prefetch" href="/assets/js/296.5d55e2b4.js"><link rel="prefetch" href="/assets/js/297.0c74b494.js"><link rel="prefetch" href="/assets/js/298.61015025.js"><link rel="prefetch" href="/assets/js/299.95b2a709.js"><link rel="prefetch" href="/assets/js/30.144a5c6c.js"><link rel="prefetch" href="/assets/js/300.1ded6f5a.js"><link rel="prefetch" href="/assets/js/301.0c60ca57.js"><link rel="prefetch" href="/assets/js/302.a4e4ce29.js"><link rel="prefetch" href="/assets/js/303.f51290d8.js"><link rel="prefetch" href="/assets/js/304.5b9d354a.js"><link rel="prefetch" href="/assets/js/305.4fc3fa36.js"><link rel="prefetch" href="/assets/js/306.d2ccf3d8.js"><link rel="prefetch" href="/assets/js/307.137ddc6c.js"><link rel="prefetch" href="/assets/js/308.d093842e.js"><link rel="prefetch" href="/assets/js/309.8d85e9c5.js"><link rel="prefetch" href="/assets/js/31.03034f21.js"><link rel="prefetch" href="/assets/js/310.610cadf2.js"><link rel="prefetch" href="/assets/js/311.3f9bc269.js"><link rel="prefetch" href="/assets/js/312.ac085561.js"><link rel="prefetch" href="/assets/js/313.39e131a4.js"><link rel="prefetch" href="/assets/js/314.62ae7afd.js"><link rel="prefetch" href="/assets/js/315.312dd0ad.js"><link rel="prefetch" href="/assets/js/316.3daa3b97.js"><link rel="prefetch" href="/assets/js/317.385cce00.js"><link rel="prefetch" href="/assets/js/318.6e75f908.js"><link rel="prefetch" href="/assets/js/319.4a8516ae.js"><link rel="prefetch" href="/assets/js/32.bad93e79.js"><link rel="prefetch" href="/assets/js/320.e6ea8799.js"><link rel="prefetch" href="/assets/js/321.c192a35e.js"><link rel="prefetch" href="/assets/js/322.c675d3fd.js"><link rel="prefetch" href="/assets/js/323.cf867cd9.js"><link rel="prefetch" href="/assets/js/324.38af9dd2.js"><link rel="prefetch" href="/assets/js/325.dd39b2de.js"><link rel="prefetch" href="/assets/js/326.b3197783.js"><link rel="prefetch" href="/assets/js/327.7ab3256f.js"><link rel="prefetch" href="/assets/js/328.a51703c6.js"><link rel="prefetch" href="/assets/js/329.d4f2f214.js"><link rel="prefetch" href="/assets/js/33.00e7d6b5.js"><link rel="prefetch" href="/assets/js/330.1fb7bbad.js"><link rel="prefetch" href="/assets/js/331.52605dbf.js"><link rel="prefetch" href="/assets/js/332.58cff2f4.js"><link rel="prefetch" href="/assets/js/333.fa7136ab.js"><link rel="prefetch" href="/assets/js/334.0de0062b.js"><link rel="prefetch" href="/assets/js/335.a5e18bb9.js"><link rel="prefetch" href="/assets/js/336.448ec9fa.js"><link rel="prefetch" href="/assets/js/337.c877f6df.js"><link rel="prefetch" href="/assets/js/338.e071e415.js"><link rel="prefetch" href="/assets/js/339.194f47f4.js"><link rel="prefetch" href="/assets/js/34.44ac5494.js"><link rel="prefetch" href="/assets/js/340.5755d00b.js"><link rel="prefetch" href="/assets/js/341.070a9aed.js"><link rel="prefetch" href="/assets/js/342.35edcb5e.js"><link rel="prefetch" href="/assets/js/343.a86abe3e.js"><link rel="prefetch" href="/assets/js/344.22456a86.js"><link rel="prefetch" href="/assets/js/345.054131fa.js"><link rel="prefetch" href="/assets/js/346.d850e5ce.js"><link rel="prefetch" href="/assets/js/347.7b8936a1.js"><link rel="prefetch" href="/assets/js/348.5ee2b670.js"><link rel="prefetch" href="/assets/js/349.f37573c7.js"><link rel="prefetch" href="/assets/js/35.7f32ce73.js"><link rel="prefetch" href="/assets/js/350.312ee288.js"><link rel="prefetch" href="/assets/js/351.aabc93dc.js"><link rel="prefetch" href="/assets/js/352.99aa4418.js"><link rel="prefetch" href="/assets/js/353.9c90d422.js"><link rel="prefetch" href="/assets/js/354.8a7c72b5.js"><link rel="prefetch" href="/assets/js/355.1008fd17.js"><link rel="prefetch" href="/assets/js/356.546f7242.js"><link rel="prefetch" href="/assets/js/357.3f84c383.js"><link rel="prefetch" href="/assets/js/358.57ab0f48.js"><link rel="prefetch" href="/assets/js/359.715ee9c0.js"><link rel="prefetch" href="/assets/js/36.d1e9d19f.js"><link rel="prefetch" href="/assets/js/360.92093399.js"><link rel="prefetch" href="/assets/js/361.8e8a2657.js"><link rel="prefetch" href="/assets/js/362.c6796915.js"><link rel="prefetch" href="/assets/js/363.e17af86a.js"><link rel="prefetch" href="/assets/js/364.6274b87c.js"><link rel="prefetch" href="/assets/js/365.211ac0fc.js"><link rel="prefetch" href="/assets/js/366.e5297f1f.js"><link rel="prefetch" href="/assets/js/367.d778a1f0.js"><link rel="prefetch" href="/assets/js/368.d55765fc.js"><link rel="prefetch" href="/assets/js/369.d357817a.js"><link rel="prefetch" href="/assets/js/37.3351af87.js"><link rel="prefetch" href="/assets/js/370.14439cd0.js"><link rel="prefetch" href="/assets/js/371.8f1680c9.js"><link rel="prefetch" href="/assets/js/372.61718293.js"><link rel="prefetch" href="/assets/js/373.4b4647e8.js"><link rel="prefetch" href="/assets/js/374.71d42042.js"><link rel="prefetch" href="/assets/js/375.e4d369f2.js"><link rel="prefetch" href="/assets/js/376.51cd667f.js"><link rel="prefetch" href="/assets/js/377.023da5c6.js"><link rel="prefetch" href="/assets/js/378.726a5f82.js"><link rel="prefetch" href="/assets/js/379.720646dc.js"><link rel="prefetch" href="/assets/js/38.2334aea2.js"><link rel="prefetch" href="/assets/js/380.4d823b98.js"><link rel="prefetch" href="/assets/js/381.bdcccbea.js"><link rel="prefetch" href="/assets/js/382.8cce8942.js"><link rel="prefetch" href="/assets/js/383.cb7d71d3.js"><link rel="prefetch" href="/assets/js/384.bf2af7c5.js"><link rel="prefetch" href="/assets/js/385.1cc639e2.js"><link rel="prefetch" href="/assets/js/386.684b64ab.js"><link rel="prefetch" href="/assets/js/387.e16f4a68.js"><link rel="prefetch" href="/assets/js/388.c9b30f3b.js"><link rel="prefetch" href="/assets/js/389.a8b0f99a.js"><link rel="prefetch" href="/assets/js/39.683bc07a.js"><link rel="prefetch" href="/assets/js/390.b43004ff.js"><link rel="prefetch" href="/assets/js/391.c316049a.js"><link rel="prefetch" href="/assets/js/392.2c559de6.js"><link rel="prefetch" href="/assets/js/393.3055fc0a.js"><link rel="prefetch" href="/assets/js/394.7585ce4c.js"><link rel="prefetch" href="/assets/js/395.6f04bac1.js"><link rel="prefetch" href="/assets/js/396.a6536f32.js"><link rel="prefetch" href="/assets/js/397.e9807e10.js"><link rel="prefetch" href="/assets/js/398.b89dcc8a.js"><link rel="prefetch" href="/assets/js/399.da459f94.js"><link rel="prefetch" href="/assets/js/4.47196852.js"><link rel="prefetch" href="/assets/js/40.f2d861cf.js"><link rel="prefetch" href="/assets/js/400.d8b3b5fd.js"><link rel="prefetch" href="/assets/js/401.4a5b409e.js"><link rel="prefetch" href="/assets/js/402.f2c8802d.js"><link rel="prefetch" href="/assets/js/403.bd98e777.js"><link rel="prefetch" href="/assets/js/404.d2dab4f7.js"><link rel="prefetch" href="/assets/js/405.f83ce379.js"><link rel="prefetch" href="/assets/js/406.69a91345.js"><link rel="prefetch" href="/assets/js/407.3bc1a860.js"><link rel="prefetch" href="/assets/js/408.8b88a93c.js"><link rel="prefetch" href="/assets/js/409.269ef2c9.js"><link rel="prefetch" href="/assets/js/41.79fbb067.js"><link rel="prefetch" href="/assets/js/410.40dc1b76.js"><link rel="prefetch" href="/assets/js/411.6679eea2.js"><link rel="prefetch" href="/assets/js/412.2cdd21ea.js"><link rel="prefetch" href="/assets/js/413.f5418356.js"><link rel="prefetch" href="/assets/js/414.ed9da9ad.js"><link rel="prefetch" href="/assets/js/415.4cd14246.js"><link rel="prefetch" href="/assets/js/416.cd80178b.js"><link rel="prefetch" href="/assets/js/417.d650a560.js"><link rel="prefetch" href="/assets/js/418.ad71cbc7.js"><link rel="prefetch" href="/assets/js/419.8e6c87c0.js"><link rel="prefetch" href="/assets/js/42.101ecd13.js"><link rel="prefetch" href="/assets/js/420.71ec69ad.js"><link rel="prefetch" href="/assets/js/421.91d6b7be.js"><link rel="prefetch" href="/assets/js/422.353f77c5.js"><link rel="prefetch" href="/assets/js/423.60ef06c0.js"><link rel="prefetch" href="/assets/js/424.2e57687c.js"><link rel="prefetch" href="/assets/js/425.9413632b.js"><link rel="prefetch" href="/assets/js/426.e1b29e8b.js"><link rel="prefetch" href="/assets/js/427.ed640a0c.js"><link rel="prefetch" href="/assets/js/428.90a9eecd.js"><link rel="prefetch" href="/assets/js/429.bcc51151.js"><link rel="prefetch" href="/assets/js/43.cf663bf1.js"><link rel="prefetch" href="/assets/js/430.d7a129bf.js"><link rel="prefetch" href="/assets/js/431.6f0b95f4.js"><link rel="prefetch" href="/assets/js/432.c9964a14.js"><link rel="prefetch" href="/assets/js/433.fb0bc3bb.js"><link rel="prefetch" href="/assets/js/434.cbb78303.js"><link rel="prefetch" href="/assets/js/435.7633d592.js"><link rel="prefetch" href="/assets/js/436.dd3d00e6.js"><link rel="prefetch" href="/assets/js/437.40a87461.js"><link rel="prefetch" href="/assets/js/438.640ceed6.js"><link rel="prefetch" href="/assets/js/439.4bc626d3.js"><link rel="prefetch" href="/assets/js/44.0e34047e.js"><link rel="prefetch" href="/assets/js/440.840fff96.js"><link rel="prefetch" href="/assets/js/441.e8e14977.js"><link rel="prefetch" href="/assets/js/442.0f0a17b6.js"><link rel="prefetch" href="/assets/js/443.44c2279e.js"><link rel="prefetch" href="/assets/js/444.6d775f58.js"><link rel="prefetch" href="/assets/js/445.dfec1767.js"><link rel="prefetch" href="/assets/js/446.8282b220.js"><link rel="prefetch" href="/assets/js/447.4b8f1a4c.js"><link rel="prefetch" href="/assets/js/448.03b53f95.js"><link rel="prefetch" href="/assets/js/449.39dea464.js"><link rel="prefetch" href="/assets/js/45.fa02a8c0.js"><link rel="prefetch" href="/assets/js/450.948c5957.js"><link rel="prefetch" href="/assets/js/451.b4e00223.js"><link rel="prefetch" href="/assets/js/452.634de921.js"><link rel="prefetch" href="/assets/js/453.957a3638.js"><link rel="prefetch" href="/assets/js/454.d410cf71.js"><link rel="prefetch" href="/assets/js/455.8c5a2163.js"><link rel="prefetch" href="/assets/js/456.877d611f.js"><link rel="prefetch" href="/assets/js/457.8b24b950.js"><link rel="prefetch" href="/assets/js/458.591d759d.js"><link rel="prefetch" href="/assets/js/459.e114c85b.js"><link rel="prefetch" href="/assets/js/46.3a265755.js"><link rel="prefetch" href="/assets/js/460.1a928144.js"><link rel="prefetch" href="/assets/js/461.2a0384d2.js"><link rel="prefetch" href="/assets/js/462.5c3649e2.js"><link rel="prefetch" href="/assets/js/463.4221227c.js"><link rel="prefetch" href="/assets/js/464.866ac902.js"><link rel="prefetch" href="/assets/js/465.05a96c32.js"><link rel="prefetch" href="/assets/js/466.3efed881.js"><link rel="prefetch" href="/assets/js/467.ddd524e5.js"><link rel="prefetch" href="/assets/js/468.9eebe3d9.js"><link rel="prefetch" href="/assets/js/469.281b53ec.js"><link rel="prefetch" href="/assets/js/47.2d120101.js"><link rel="prefetch" href="/assets/js/470.decda882.js"><link rel="prefetch" href="/assets/js/471.242be672.js"><link rel="prefetch" href="/assets/js/472.da4abae1.js"><link rel="prefetch" href="/assets/js/473.9d64ea3e.js"><link rel="prefetch" href="/assets/js/474.5362ec5b.js"><link rel="prefetch" href="/assets/js/475.6904e585.js"><link rel="prefetch" href="/assets/js/476.c460d90a.js"><link rel="prefetch" href="/assets/js/477.474813fa.js"><link rel="prefetch" href="/assets/js/478.d51e07b1.js"><link rel="prefetch" href="/assets/js/479.f0fa0689.js"><link rel="prefetch" href="/assets/js/48.57af7d42.js"><link rel="prefetch" href="/assets/js/480.8b194bbe.js"><link rel="prefetch" href="/assets/js/481.f2f1aeeb.js"><link rel="prefetch" href="/assets/js/482.6903e11b.js"><link rel="prefetch" href="/assets/js/483.65d04ad9.js"><link rel="prefetch" href="/assets/js/484.51e94629.js"><link rel="prefetch" href="/assets/js/485.415550f4.js"><link rel="prefetch" href="/assets/js/486.d24d0355.js"><link rel="prefetch" href="/assets/js/487.9eea1be6.js"><link rel="prefetch" href="/assets/js/488.eb3d4584.js"><link rel="prefetch" href="/assets/js/489.6f97c453.js"><link rel="prefetch" href="/assets/js/49.3de3d3a7.js"><link rel="prefetch" href="/assets/js/490.e83cd7f7.js"><link rel="prefetch" href="/assets/js/491.4a6acdf2.js"><link rel="prefetch" href="/assets/js/492.e0548c45.js"><link rel="prefetch" href="/assets/js/493.29b0d0b2.js"><link rel="prefetch" href="/assets/js/494.9f66922c.js"><link rel="prefetch" href="/assets/js/495.31a136ac.js"><link rel="prefetch" href="/assets/js/496.4c1f303f.js"><link rel="prefetch" href="/assets/js/497.b03e6c3f.js"><link rel="prefetch" href="/assets/js/498.a8178b3e.js"><link rel="prefetch" href="/assets/js/499.9f38526a.js"><link rel="prefetch" href="/assets/js/5.33db7f08.js"><link rel="prefetch" href="/assets/js/50.27055b53.js"><link rel="prefetch" href="/assets/js/500.262b9103.js"><link rel="prefetch" href="/assets/js/501.c97f4e75.js"><link rel="prefetch" href="/assets/js/502.5d5c5edd.js"><link rel="prefetch" href="/assets/js/503.62a2a01d.js"><link rel="prefetch" href="/assets/js/504.855415b5.js"><link rel="prefetch" href="/assets/js/505.79d4fddb.js"><link rel="prefetch" href="/assets/js/506.f2675378.js"><link rel="prefetch" href="/assets/js/507.7d811dcb.js"><link rel="prefetch" href="/assets/js/508.6c63d710.js"><link rel="prefetch" href="/assets/js/509.a6dbe871.js"><link rel="prefetch" href="/assets/js/51.82e12c0c.js"><link rel="prefetch" href="/assets/js/510.6ba536a4.js"><link rel="prefetch" href="/assets/js/511.47fcc7dd.js"><link rel="prefetch" href="/assets/js/512.f5b2b05c.js"><link rel="prefetch" href="/assets/js/513.d1a9a405.js"><link rel="prefetch" href="/assets/js/514.4768319a.js"><link rel="prefetch" href="/assets/js/515.4a7312b1.js"><link rel="prefetch" href="/assets/js/516.2a75898b.js"><link rel="prefetch" href="/assets/js/517.0734d077.js"><link rel="prefetch" href="/assets/js/518.a0affa56.js"><link rel="prefetch" href="/assets/js/519.3b143230.js"><link rel="prefetch" href="/assets/js/52.08471186.js"><link rel="prefetch" href="/assets/js/520.98088423.js"><link rel="prefetch" href="/assets/js/521.09d6f9e3.js"><link rel="prefetch" href="/assets/js/522.0a7f1cfd.js"><link rel="prefetch" href="/assets/js/523.460a682d.js"><link rel="prefetch" href="/assets/js/53.81c949e4.js"><link rel="prefetch" href="/assets/js/54.23834020.js"><link rel="prefetch" href="/assets/js/55.98bddbab.js"><link rel="prefetch" href="/assets/js/56.f33c89be.js"><link rel="prefetch" href="/assets/js/57.974b4102.js"><link rel="prefetch" href="/assets/js/58.e357e1b7.js"><link rel="prefetch" href="/assets/js/59.1cf2f460.js"><link rel="prefetch" href="/assets/js/6.d37d398a.js"><link rel="prefetch" href="/assets/js/60.bccde908.js"><link rel="prefetch" href="/assets/js/61.33679650.js"><link rel="prefetch" href="/assets/js/62.fe42a718.js"><link rel="prefetch" href="/assets/js/63.910cc28d.js"><link rel="prefetch" href="/assets/js/64.3a046b10.js"><link rel="prefetch" href="/assets/js/65.6bc58366.js"><link rel="prefetch" href="/assets/js/66.29ed3089.js"><link rel="prefetch" href="/assets/js/67.3a4a22d1.js"><link rel="prefetch" href="/assets/js/68.05fa411c.js"><link rel="prefetch" href="/assets/js/69.44dfc2db.js"><link rel="prefetch" href="/assets/js/7.8c733af6.js"><link rel="prefetch" href="/assets/js/70.059cdd51.js"><link rel="prefetch" href="/assets/js/71.d58561d2.js"><link rel="prefetch" href="/assets/js/72.056ba678.js"><link rel="prefetch" href="/assets/js/73.25916778.js"><link rel="prefetch" href="/assets/js/74.1f1823dc.js"><link rel="prefetch" href="/assets/js/75.2f5b0b73.js"><link rel="prefetch" href="/assets/js/76.06e76fe6.js"><link rel="prefetch" href="/assets/js/77.206d48bf.js"><link rel="prefetch" href="/assets/js/78.2f07e42d.js"><link rel="prefetch" href="/assets/js/79.994c527d.js"><link rel="prefetch" href="/assets/js/8.e8c4adeb.js"><link rel="prefetch" href="/assets/js/80.82c6c4f9.js"><link rel="prefetch" href="/assets/js/81.83bd28d9.js"><link rel="prefetch" href="/assets/js/82.7fbb77e1.js"><link rel="prefetch" href="/assets/js/84.13db35cf.js"><link rel="prefetch" href="/assets/js/85.e6a2aa9d.js"><link rel="prefetch" href="/assets/js/86.715ac425.js"><link rel="prefetch" href="/assets/js/87.10b54644.js"><link rel="prefetch" href="/assets/js/88.477faa20.js"><link rel="prefetch" href="/assets/js/89.a562feda.js"><link rel="prefetch" href="/assets/js/9.635384b9.js"><link rel="prefetch" href="/assets/js/90.c7874d64.js"><link rel="prefetch" href="/assets/js/91.e61cbe07.js"><link rel="prefetch" href="/assets/js/92.45b11d5e.js"><link rel="prefetch" href="/assets/js/93.f587deb4.js"><link rel="prefetch" href="/assets/js/94.19940b43.js"><link rel="prefetch" href="/assets/js/95.d9763768.js"><link rel="prefetch" href="/assets/js/96.3ed0322b.js"><link rel="prefetch" href="/assets/js/97.d368e630.js"><link rel="prefetch" href="/assets/js/98.8b86b8af.js"><link rel="prefetch" href="/assets/js/99.53eb946a.js"><link rel="prefetch" href="/assets/js/vendors~docsearch.262891fb.js"> |
| <link rel="stylesheet" href="/assets/css/0.styles.679f71b6.css"> |
| </head> |
| <body> |
| <div id="app" data-server-rendered="true"><div class="theme-container"><header class="navbar"><div class="sidebar-button"><svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" role="img" viewBox="0 0 448 512" class="icon"><path fill="currentColor" d="M436 124H12c-6.627 0-12-5.373-12-12V80c0-6.627 5.373-12 12-12h424c6.627 0 12 5.373 12 12v32c0 6.627-5.373 12-12 12zm0 160H12c-6.627 0-12-5.373-12-12v-32c0-6.627 5.373-12 12-12h424c6.627 0 12 5.373 12 12v32c0 6.627-5.373 12-12 12zm0 160H12c-6.627 0-12-5.373-12-12v-32c0-6.627 5.373-12 12-12h424c6.627 0 12 5.373 12 12v32c0 6.627-5.373 12-12 12z"></path></svg></div> <a href="/" class="home-link router-link-active"><img src="/img/logo.png" alt=" " class="logo"></a> <div class="links"><div class="search-box"><input aria-label="Search" autocomplete="off" spellcheck="false" value=""> <!----></div> <nav class="nav-links can-hide"><div class="nav-item"><div class="dropdown-wrapper"><a class="dropdown-title"><span class="title">Document</span> <span class="arrow right"></span></a> <ul class="nav-dropdown" style="display:none;"><li class="dropdown-item"><!----> <a href="/UserGuide/Master/Get Started/QuickStart.html" class="nav-link">In progress</a></li><li class="dropdown-item"><!----> <a href="/UserGuide/V0.11.x/Get Started/QuickStart.html" class="nav-link">V0.11.x</a></li><li class="dropdown-item"><!----> <a href="/UserGuide/V0.10.x/Get Started/QuickStart.html" class="nav-link">V0.10.x</a></li><li class="dropdown-item"><!----> <a href="/UserGuide/V0.9.x/0-Get Started/1-QuickStart.html" class="nav-link">V0.9.x</a></li><li class="dropdown-item"><!----> <a href="/UserGuide/V0.8.x/0-Get Started/1-QuickStart.html" class="nav-link">V0.8.x</a></li></ul></div></div><div class="nav-item"><a href="/SystemDesign/Architecture/Architecture.html" class="nav-link">System design</a></div><div class="nav-item"><a href="/Download/" class="nav-link">Download</a></div><div class="nav-item"><div class="dropdown-wrapper"><a class="dropdown-title"><span class="title">Community</span> <span class="arrow right"></span></a> <ul class="nav-dropdown" style="display:none;"><li class="dropdown-item"><!----> <a href="https://cwiki.apache.org/confluence/display/iotdb" class="nav-link external"> |
| Wiki |
| <!----></a></li><li class="dropdown-item"><!----> <a href="/Community/Community-Project Committers.html" class="nav-link">People</a></li><li class="dropdown-item"><!----> <a href="/Community/Community-Powered By.html" class="nav-link">Powered By</a></li><li class="dropdown-item"><!----> <a href="/Community/Materials.html" class="nav-link">Resources</a></li><li class="dropdown-item"><!----> <a href="/Community/Feedback.html" class="nav-link">Feedback</a></li></ul></div></div><div class="nav-item"><div class="dropdown-wrapper"><a class="dropdown-title"><span class="title">Development</span> <span class="arrow right"></span></a> <ul class="nav-dropdown" style="display:none;"><li class="dropdown-item"><!----> <a href="/Development/VoteRelease.html" class="nav-link">How to vote</a></li><li class="dropdown-item"><!----> <a href="/Development/HowToCommit.html" class="nav-link">How to Commit</a></li><li class="dropdown-item"><!----> <a href="/Development/Committer.html" class="nav-link">Become a Committer</a></li><li class="dropdown-item"><!----> <a href="/Development/ContributeGuide.html" class="nav-link">ContributeGuide</a></li><li class="dropdown-item"><!----> <a href="/Development/format-changelist.html" class="nav-link">Changelist of TsFile</a></li><li class="dropdown-item"><!----> <a href="/Development/rpc-changelist.html" class="nav-link">Changelist of RPC</a></li></ul></div></div><div class="nav-item"><div class="dropdown-wrapper"><a class="dropdown-title"><span class="title">Blog</span> <span class="arrow right"></span></a> <ul class="nav-dropdown" style="display:none;"><li class="dropdown-item"><!----> <a href="/Blog/Index.html" class="nav-link">Overview</a></li><li class="dropdown-item"><!----> <a href="/Blog/Release0_93.html" class="nav-link">Some Notes on Release 0.9.3 and upcoming 0.10.0</a></li></ul></div></div><div class="nav-item"><div class="dropdown-wrapper"><a class="dropdown-title"><span class="title">ASF</span> <span class="arrow right"></span></a> <ul class="nav-dropdown" style="display:none;"><li class="dropdown-item"><!----> <a href="http://www.apache.org/" class="nav-link external"> |
| Foundation |
| <!----></a></li><li class="dropdown-item"><!----> <a href="http://www.apache.org/licenses/" class="nav-link external"> |
| License |
| <!----></a></li><li class="dropdown-item"><!----> <a href="http://www.apache.org/security/" class="nav-link external"> |
| Security |
| <!----></a></li><li class="dropdown-item"><!----> <a href="http://www.apache.org/foundation/sponsorship.html" class="nav-link external"> |
| Sponsorship |
| <!----></a></li><li class="dropdown-item"><!----> <a href="http://www.apache.org/foundation/thanks.html" class="nav-link external"> |
| Thanks |
| <!----></a></li><li class="dropdown-item"><!----> <a href="http://www.apache.org/events/current-event" class="nav-link external"> |
| Current Events |
| <!----></a></li></ul></div></div><div class="nav-item"><div class="dropdown-wrapper"><a class="dropdown-title"><span class="title">Languages</span> <span class="arrow right"></span></a> <ul class="nav-dropdown" style="display:none;"><li class="dropdown-item"><!----> <a href="/UserGuide/Master/Operation Manual/DML Data Manipulation Language.html" class="nav-link">English</a></li><li class="dropdown-item"><!----> <a href="/zh/UserGuide/Master/Operation Manual/DML Data Manipulation Language.html" class="nav-link">简体中文</a></li></ul></div></div> <a href="https://github.com/apache/iotdb.git" target="_blank" rel="noopener noreferrer" class="repo-link"> |
| gitHub |
| <span><svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewBox="0 0 100 100" width="15" height="15" class="icon outbound"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path> <polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg> <span class="sr-only">(opens new window)</span></span></a></nav></div></header> <div class="sidebar-mask"></div> <aside class="sidebar"><nav class="nav-links"><div class="nav-item"><div class="dropdown-wrapper"><a class="dropdown-title"><span class="title">Document</span> <span class="arrow right"></span></a> <ul class="nav-dropdown" style="display:none;"><li class="dropdown-item"><!----> <a href="/UserGuide/Master/Get Started/QuickStart.html" class="nav-link">In progress</a></li><li class="dropdown-item"><!----> <a href="/UserGuide/V0.11.x/Get Started/QuickStart.html" class="nav-link">V0.11.x</a></li><li class="dropdown-item"><!----> <a href="/UserGuide/V0.10.x/Get Started/QuickStart.html" class="nav-link">V0.10.x</a></li><li class="dropdown-item"><!----> <a href="/UserGuide/V0.9.x/0-Get Started/1-QuickStart.html" class="nav-link">V0.9.x</a></li><li class="dropdown-item"><!----> <a href="/UserGuide/V0.8.x/0-Get Started/1-QuickStart.html" class="nav-link">V0.8.x</a></li></ul></div></div><div class="nav-item"><a href="/SystemDesign/Architecture/Architecture.html" class="nav-link">System design</a></div><div class="nav-item"><a href="/Download/" class="nav-link">Download</a></div><div class="nav-item"><div class="dropdown-wrapper"><a class="dropdown-title"><span class="title">Community</span> <span class="arrow right"></span></a> <ul class="nav-dropdown" style="display:none;"><li class="dropdown-item"><!----> <a href="https://cwiki.apache.org/confluence/display/iotdb" class="nav-link external"> |
| Wiki |
| <!----></a></li><li class="dropdown-item"><!----> <a href="/Community/Community-Project Committers.html" class="nav-link">People</a></li><li class="dropdown-item"><!----> <a href="/Community/Community-Powered By.html" class="nav-link">Powered By</a></li><li class="dropdown-item"><!----> <a href="/Community/Materials.html" class="nav-link">Resources</a></li><li class="dropdown-item"><!----> <a href="/Community/Feedback.html" class="nav-link">Feedback</a></li></ul></div></div><div class="nav-item"><div class="dropdown-wrapper"><a class="dropdown-title"><span class="title">Development</span> <span class="arrow right"></span></a> <ul class="nav-dropdown" style="display:none;"><li class="dropdown-item"><!----> <a href="/Development/VoteRelease.html" class="nav-link">How to vote</a></li><li class="dropdown-item"><!----> <a href="/Development/HowToCommit.html" class="nav-link">How to Commit</a></li><li class="dropdown-item"><!----> <a href="/Development/Committer.html" class="nav-link">Become a Committer</a></li><li class="dropdown-item"><!----> <a href="/Development/ContributeGuide.html" class="nav-link">ContributeGuide</a></li><li class="dropdown-item"><!----> <a href="/Development/format-changelist.html" class="nav-link">Changelist of TsFile</a></li><li class="dropdown-item"><!----> <a href="/Development/rpc-changelist.html" class="nav-link">Changelist of RPC</a></li></ul></div></div><div class="nav-item"><div class="dropdown-wrapper"><a class="dropdown-title"><span class="title">Blog</span> <span class="arrow right"></span></a> <ul class="nav-dropdown" style="display:none;"><li class="dropdown-item"><!----> <a href="/Blog/Index.html" class="nav-link">Overview</a></li><li class="dropdown-item"><!----> <a href="/Blog/Release0_93.html" class="nav-link">Some Notes on Release 0.9.3 and upcoming 0.10.0</a></li></ul></div></div><div class="nav-item"><div class="dropdown-wrapper"><a class="dropdown-title"><span class="title">ASF</span> <span class="arrow right"></span></a> <ul class="nav-dropdown" style="display:none;"><li class="dropdown-item"><!----> <a href="http://www.apache.org/" class="nav-link external"> |
| Foundation |
| <!----></a></li><li class="dropdown-item"><!----> <a href="http://www.apache.org/licenses/" class="nav-link external"> |
| License |
| <!----></a></li><li class="dropdown-item"><!----> <a href="http://www.apache.org/security/" class="nav-link external"> |
| Security |
| <!----></a></li><li class="dropdown-item"><!----> <a href="http://www.apache.org/foundation/sponsorship.html" class="nav-link external"> |
| Sponsorship |
| <!----></a></li><li class="dropdown-item"><!----> <a href="http://www.apache.org/foundation/thanks.html" class="nav-link external"> |
| Thanks |
| <!----></a></li><li class="dropdown-item"><!----> <a href="http://www.apache.org/events/current-event" class="nav-link external"> |
| Current Events |
| <!----></a></li></ul></div></div><div class="nav-item"><div class="dropdown-wrapper"><a class="dropdown-title"><span class="title">Languages</span> <span class="arrow right"></span></a> <ul class="nav-dropdown" style="display:none;"><li class="dropdown-item"><!----> <a href="/UserGuide/Master/Operation Manual/DML Data Manipulation Language.html" class="nav-link">English</a></li><li class="dropdown-item"><!----> <a href="/zh/UserGuide/Master/Operation Manual/DML Data Manipulation Language.html" class="nav-link">简体中文</a></li></ul></div></div> <a href="https://github.com/apache/iotdb.git" target="_blank" rel="noopener noreferrer" class="repo-link"> |
| gitHub |
| <span><svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewBox="0 0 100 100" width="15" height="15" class="icon outbound"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path> <polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg> <span class="sr-only">(opens new window)</span></span></a></nav> <ul class="sidebar-links"><li><section class="sidebar-group depth-0"><p class="sidebar-heading"><span>IoTDB User Guide (In progress)</span> <!----></p> <!----></section></li><li><section class="sidebar-group collapsable depth-0"><p class="sidebar-heading"><span>Get Started</span> <span class="arrow right"></span></p> <!----></section></li><li><section class="sidebar-group collapsable depth-0"><p class="sidebar-heading"><span>Overview</span> <span class="arrow right"></span></p> <!----></section></li><li><section class="sidebar-group collapsable depth-0"><p class="sidebar-heading"><span>Concept</span> <span class="arrow right"></span></p> <!----></section></li><li><section class="sidebar-group collapsable depth-0"><p class="sidebar-heading"><span>Server</span> <span class="arrow right"></span></p> <!----></section></li><li><section class="sidebar-group collapsable depth-0"><p class="sidebar-heading"><span>Client</span> <span class="arrow right"></span></p> <!----></section></li><li><section class="sidebar-group collapsable depth-0"><p class="sidebar-heading open"><span>Operation Manual</span> <span class="arrow down"></span></p> <ul class="sidebar-links sidebar-group-items"><li><a href="/UserGuide/Master/Operation Manual/DDL Data Definition Language.html" class="sidebar-link">DDL (Data Definition Language)</a></li><li><a href="/UserGuide/Master/Operation Manual/DML Data Manipulation Language.html" class="active sidebar-link">DML (Data Manipulation Language)</a></li><li><a href="/UserGuide/Master/Operation Manual/Administration.html" class="sidebar-link">Administration</a></li><li><a href="/UserGuide/Master/Operation Manual/SQL Reference.html" class="sidebar-link">SQL Reference</a></li></ul></section></li><li><section class="sidebar-group collapsable depth-0"><p class="sidebar-heading"><span>System Tools</span> <span class="arrow right"></span></p> <!----></section></li><li><section class="sidebar-group collapsable depth-0"><p class="sidebar-heading"><span>Ecosystem Integration</span> <span class="arrow right"></span></p> <!----></section></li><li><section class="sidebar-group collapsable depth-0"><p class="sidebar-heading"><span>Architecture</span> <span class="arrow right"></span></p> <!----></section></li><li><section class="sidebar-group collapsable depth-0"><p class="sidebar-heading"><span>Comparison with TSDBs</span> <span class="arrow right"></span></p> <!----></section></li></ul> </aside> <main class="page"> <div class="content content__default"><h1 id="dml-data-manipulation-language"><a href="#dml-data-manipulation-language" class="header-anchor">#</a> DML (Data Manipulation Language)</h1> <h2 id="insert"><a href="#insert" class="header-anchor">#</a> INSERT</h2> <h3 id="insert-real-time-data"><a href="#insert-real-time-data" class="header-anchor">#</a> Insert Real-time Data</h3> <p>IoTDB provides users with a variety of ways to insert real-time data, such as directly inputting <a href="/UserGuide/Master/Operation Manual/SQL Reference.html">INSERT SQL statement</a> in <a href="/UserGuide/Master/Client/Command Line Interface.html">Client/Shell tools</a>, or using <a href="/UserGuide/Master/Client/Programming - JDBC.html">Java JDBC</a> to perform single or batch execution of <a href="/UserGuide/Master/Operation Manual/SQL Reference.html">INSERT SQL statement</a>.</p> <p>This section mainly introduces the use of <a href="/UserGuide/Master/Operation Manual/SQL Reference.html">INSERT SQL statement</a> for real-time data import in the scenario.</p> <h4 id="use-of-insert-statements"><a href="#use-of-insert-statements" class="header-anchor">#</a> Use of INSERT Statements</h4> <p>The <a href="/UserGuide/Master/Operation Manual/SQL Reference.html">INSERT SQL statement</a> statement is used to insert data into one or more specified timeseries created. For each point of data inserted, it consists of a <a href="/UserGuide/Master/Concept/Data Model and Terminology.html">timestamp</a> and a sensor acquisition value (see <a href="/UserGuide/Master/Concept/Data Type.html">Data Type</a>).</p> <p>In the scenario of this section, take two timeseries <code>root.ln.wf02.wt02.status</code> and <code>root.ln.wf02.wt02.hardware</code> as an example, and their data types are BOOLEAN and TEXT, respectively.</p> <p>The sample code for single column data insertion is as follows:</p> <div class="language- line-numbers-mode"><pre class="language-text"><code>IoTDB > insert into root.ln.wf02.wt02(timestamp,status) values(1,true) |
| IoTDB > insert into root.ln.wf02.wt02(timestamp,hardware) values(1, "v1") |
| </code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br><span class="line-number">2</span><br></div></div><p>The above example code inserts the long integer timestamp and the value "true" into the timeseries <code>root.ln.wf02.wt02.status</code> and inserts the long integer timestamp and the value "v1" into the timeseries <code>root.ln.wf02.wt02.hardware</code>. When the execution is successful, cost time is shown to indicate that the data insertion has been completed.</p> <blockquote><p>Note: In IoTDB, TEXT type data can be represented by single and double quotation marks. The insertion statement above uses double quotation marks for TEXT type data. The following example will use single quotation marks for TEXT type data.</p></blockquote> <p>The INSERT statement can also support the insertion of multi-column data at the same time point. The sample code of inserting the values of the two timeseries at the same time point '2' is as follows:</p> <div class="language- line-numbers-mode"><pre class="language-text"><code>IoTDB > insert into root.ln.wf02.wt02(timestamp, status, hardware) VALUES (2, false, 'v2') |
| </code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br></div></div><p>After inserting the data, we can simply query the inserted data using the SELECT statement:</p> <div class="language- line-numbers-mode"><pre class="language-text"><code>IoTDB > select * from root.ln.wf02 where time < 3 |
| </code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br></div></div><p>The result is shown below. The query result shows that the insertion statements of single column and multi column data are performed correctly.</p> <div class="language- line-numbers-mode"><pre class="language-text"><code>+-----------------------------+--------------------------+------------------------+ |
| | Time|root.ln.wf02.wt02.hardware|root.ln.wf02.wt02.status| |
| +-----------------------------+--------------------------+------------------------+ |
| |1970-01-01T08:00:00.001+08:00| v1| true| |
| |1970-01-01T08:00:00.002+08:00| v2| false| |
| +-----------------------------+--------------------------+------------------------+ |
| Total line number = 2 |
| It costs 0.170s |
| </code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br><span class="line-number">2</span><br><span class="line-number">3</span><br><span class="line-number">4</span><br><span class="line-number">5</span><br><span class="line-number">6</span><br><span class="line-number">7</span><br><span class="line-number">8</span><br></div></div><h2 id="select"><a href="#select" class="header-anchor">#</a> SELECT</h2> <h3 id="time-slice-query"><a href="#time-slice-query" class="header-anchor">#</a> Time Slice Query</h3> <p>This chapter mainly introduces the relevant examples of time slice query using IoTDB SELECT statements. Detailed SQL syntax and usage specifications can be found in <a href="/UserGuide/Master/Operation Manual/SQL Reference.html">SQL Documentation</a>. You can also use the <a href="/UserGuide/Master/Client/Programming - JDBC.html">Java JDBC</a> standard interface to execute related queries.</p> <h4 id="select-a-column-of-data-based-on-a-time-interval"><a href="#select-a-column-of-data-based-on-a-time-interval" class="header-anchor">#</a> Select a Column of Data Based on a Time Interval</h4> <p>The SQL statement is:</p> <div class="language- line-numbers-mode"><pre class="language-text"><code>select temperature from root.ln.wf01.wt01 where time < 2017-11-01T00:08:00.000 |
| </code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br></div></div><p>which means:</p> <p>The selected device is ln group wf01 plant wt01 device; the selected timeseries is the temperature sensor (temperature). The SQL statement requires that all temperature sensor values before the time point of "2017-11-01T00:08:00.000" be selected.</p> <p>The execution result of this SQL statement is as follows:</p> <div class="language- line-numbers-mode"><pre class="language-text"><code>+-----------------------------+-----------------------------+ |
| | Time|root.ln.wf01.wt01.temperature| |
| +-----------------------------+-----------------------------+ |
| |2017-11-01T00:00:00.000+08:00| 25.96| |
| |2017-11-01T00:01:00.000+08:00| 24.36| |
| |2017-11-01T00:02:00.000+08:00| 20.09| |
| |2017-11-01T00:03:00.000+08:00| 20.18| |
| |2017-11-01T00:04:00.000+08:00| 21.13| |
| |2017-11-01T00:05:00.000+08:00| 22.72| |
| |2017-11-01T00:06:00.000+08:00| 20.71| |
| |2017-11-01T00:07:00.000+08:00| 21.45| |
| +-----------------------------+-----------------------------+ |
| Total line number = 8 |
| It costs 0.026s |
| </code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br><span class="line-number">2</span><br><span class="line-number">3</span><br><span class="line-number">4</span><br><span class="line-number">5</span><br><span class="line-number">6</span><br><span class="line-number">7</span><br><span class="line-number">8</span><br><span class="line-number">9</span><br><span class="line-number">10</span><br><span class="line-number">11</span><br><span class="line-number">12</span><br><span class="line-number">13</span><br><span class="line-number">14</span><br></div></div><h4 id="select-multiple-columns-of-data-based-on-a-time-interval"><a href="#select-multiple-columns-of-data-based-on-a-time-interval" class="header-anchor">#</a> Select Multiple Columns of Data Based on a Time Interval</h4> <p>The SQL statement is:</p> <div class="language- line-numbers-mode"><pre class="language-text"><code>select status, temperature from root.ln.wf01.wt01 where time > 2017-11-01T00:05:00.000 and time < 2017-11-01T00:12:00.000; |
| </code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br></div></div><p>which means:</p> <p>The selected device is ln group wf01 plant wt01 device; the selected timeseries is "status" and "temperature". The SQL statement requires that the status and temperature sensor values between the time point of "2017-11-01T00:05:00.000" and "2017-11-01T00:12:00.000" be selected.</p> <p>The execution result of this SQL statement is as follows:</p> <div class="language- line-numbers-mode"><pre class="language-text"><code>+-----------------------------+------------------------+-----------------------------+ |
| | Time|root.ln.wf01.wt01.status|root.ln.wf01.wt01.temperature| |
| +-----------------------------+------------------------+-----------------------------+ |
| |2017-11-01T00:06:00.000+08:00| false| 20.71| |
| |2017-11-01T00:07:00.000+08:00| false| 21.45| |
| |2017-11-01T00:08:00.000+08:00| false| 22.58| |
| |2017-11-01T00:09:00.000+08:00| false| 20.98| |
| |2017-11-01T00:10:00.000+08:00| true| 25.52| |
| |2017-11-01T00:11:00.000+08:00| false| 22.91| |
| +-----------------------------+------------------------+-----------------------------+ |
| Total line number = 6 |
| It costs 0.018s |
| </code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br><span class="line-number">2</span><br><span class="line-number">3</span><br><span class="line-number">4</span><br><span class="line-number">5</span><br><span class="line-number">6</span><br><span class="line-number">7</span><br><span class="line-number">8</span><br><span class="line-number">9</span><br><span class="line-number">10</span><br><span class="line-number">11</span><br><span class="line-number">12</span><br></div></div><h4 id="select-multiple-columns-of-data-for-the-same-device-according-to-multiple-time-intervals"><a href="#select-multiple-columns-of-data-for-the-same-device-according-to-multiple-time-intervals" class="header-anchor">#</a> Select Multiple Columns of Data for the Same Device According to Multiple Time Intervals</h4> <p>IoTDB supports specifying multiple time interval conditions in a query. Users can combine time interval conditions at will according to their needs. For example, the SQL statement is:</p> <div class="language- line-numbers-mode"><pre class="language-text"><code>select status,temperature from root.ln.wf01.wt01 where (time > 2017-11-01T00:05:00.000 and time < 2017-11-01T00:12:00.000) or (time >= 2017-11-01T16:35:00.000 and time <= 2017-11-01T16:37:00.000); |
| </code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br></div></div><p>which means:</p> <p>The selected device is ln group wf01 plant wt01 device; the selected timeseries is "status" and "temperature"; the statement specifies two different time intervals, namely "2017-11-01T00:05:00.000 to 2017-11-01T00:12:00.000" and "2017-11-01T16:35:00.000 to 2017-11-01T16:37:00.000". The SQL statement requires that the values of selected timeseries satisfying any time interval be selected.</p> <p>The execution result of this SQL statement is as follows:</p> <div class="language- line-numbers-mode"><pre class="language-text"><code>+-----------------------------+------------------------+-----------------------------+ |
| | Time|root.ln.wf01.wt01.status|root.ln.wf01.wt01.temperature| |
| +-----------------------------+------------------------+-----------------------------+ |
| |2017-11-01T00:06:00.000+08:00| false| 20.71| |
| |2017-11-01T00:07:00.000+08:00| false| 21.45| |
| |2017-11-01T00:08:00.000+08:00| false| 22.58| |
| |2017-11-01T00:09:00.000+08:00| false| 20.98| |
| |2017-11-01T00:10:00.000+08:00| true| 25.52| |
| |2017-11-01T00:11:00.000+08:00| false| 22.91| |
| |2017-11-01T16:35:00.000+08:00| true| 23.44| |
| |2017-11-01T16:36:00.000+08:00| false| 21.98| |
| |2017-11-01T16:37:00.000+08:00| false| 21.93| |
| +-----------------------------+------------------------+-----------------------------+ |
| Total line number = 9 |
| It costs 0.018s |
| </code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br><span class="line-number">2</span><br><span class="line-number">3</span><br><span class="line-number">4</span><br><span class="line-number">5</span><br><span class="line-number">6</span><br><span class="line-number">7</span><br><span class="line-number">8</span><br><span class="line-number">9</span><br><span class="line-number">10</span><br><span class="line-number">11</span><br><span class="line-number">12</span><br><span class="line-number">13</span><br><span class="line-number">14</span><br><span class="line-number">15</span><br></div></div><h4 id="choose-multiple-columns-of-data-for-different-devices-according-to-multiple-time-intervals"><a href="#choose-multiple-columns-of-data-for-different-devices-according-to-multiple-time-intervals" class="header-anchor">#</a> Choose Multiple Columns of Data for Different Devices According to Multiple Time Intervals</h4> <p>The system supports the selection of data in any column in a query, i.e., the selected columns can come from different devices. For example, the SQL statement is:</p> <div class="language- line-numbers-mode"><pre class="language-text"><code>select wf01.wt01.status,wf02.wt02.hardware from root.ln where (time > 2017-11-01T00:05:00.000 and time < 2017-11-01T00:12:00.000) or (time >= 2017-11-01T16:35:00.000 and time <= 2017-11-01T16:37:00.000); |
| </code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br></div></div><p>which means:</p> <p>The selected timeseries are "the power supply status of ln group wf01 plant wt01 device" and "the hardware version of ln group wf02 plant wt02 device"; the statement specifies two different time intervals, namely "2017-11-01T00:05:00.000 to 2017-11-01T00:12:00.000" and "2017-11-01T16:35:00.000 to 2017-11-01T16:37:00.000". The SQL statement requires that the values of selected timeseries satisfying any time interval be selected.</p> <p>The execution result of this SQL statement is as follows:</p> <div class="language- line-numbers-mode"><pre class="language-text"><code>+-----------------------------+------------------------+--------------------------+ |
| | Time|root.ln.wf01.wt01.status|root.ln.wf02.wt02.hardware| |
| +-----------------------------+------------------------+--------------------------+ |
| |2017-11-01T00:06:00.000+08:00| false| v1| |
| |2017-11-01T00:07:00.000+08:00| false| v1| |
| |2017-11-01T00:08:00.000+08:00| false| v1| |
| |2017-11-01T00:09:00.000+08:00| false| v1| |
| |2017-11-01T00:10:00.000+08:00| true| v2| |
| |2017-11-01T00:11:00.000+08:00| false| v1| |
| |2017-11-01T16:35:00.000+08:00| true| v2| |
| |2017-11-01T16:36:00.000+08:00| false| v1| |
| |2017-11-01T16:37:00.000+08:00| false| v1| |
| +-----------------------------+------------------------+--------------------------+ |
| Total line number = 9 |
| It costs 0.014s |
| </code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br><span class="line-number">2</span><br><span class="line-number">3</span><br><span class="line-number">4</span><br><span class="line-number">5</span><br><span class="line-number">6</span><br><span class="line-number">7</span><br><span class="line-number">8</span><br><span class="line-number">9</span><br><span class="line-number">10</span><br><span class="line-number">11</span><br><span class="line-number">12</span><br><span class="line-number">13</span><br><span class="line-number">14</span><br><span class="line-number">15</span><br></div></div><h4 id="order-by-time-query"><a href="#order-by-time-query" class="header-anchor">#</a> Order By Time Query</h4> <p>IoTDB supports the 'order by time' statement since 0.11, it's used to display results in descending order by time. |
| For example, the SQL statement is:</p> <div class="language-sql line-numbers-mode"><pre class="language-sql"><code><span class="token keyword">select</span> <span class="token operator">*</span> <span class="token keyword">from</span> root<span class="token punctuation">.</span>ln <span class="token keyword">where</span> <span class="token keyword">time</span> <span class="token operator">></span> <span class="token number">1</span> <span class="token keyword">order</span> <span class="token keyword">by</span> <span class="token keyword">time</span> <span class="token keyword">desc</span> <span class="token keyword">limit</span> <span class="token number">10</span><span class="token punctuation">;</span> |
| </code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br></div></div><p>The execution result of this SQL statement is as follows:</p> <div class="language- line-numbers-mode"><pre class="language-text"><code>+-----------------------------+--------------------------+------------------------+-----------------------------+------------------------+ |
| | Time|root.ln.wf02.wt02.hardware|root.ln.wf02.wt02.status|root.ln.wf01.wt01.temperature|root.ln.wf01.wt01.status| |
| +-----------------------------+--------------------------+------------------------+-----------------------------+------------------------+ |
| |2017-11-07T23:59:00.000+08:00| v1| false| 21.07| false| |
| |2017-11-07T23:58:00.000+08:00| v1| false| 22.93| false| |
| |2017-11-07T23:57:00.000+08:00| v2| true| 24.39| true| |
| |2017-11-07T23:56:00.000+08:00| v2| true| 24.44| true| |
| |2017-11-07T23:55:00.000+08:00| v2| true| 25.9| true| |
| |2017-11-07T23:54:00.000+08:00| v1| false| 22.52| false| |
| |2017-11-07T23:53:00.000+08:00| v2| true| 24.58| true| |
| |2017-11-07T23:52:00.000+08:00| v1| false| 20.18| false| |
| |2017-11-07T23:51:00.000+08:00| v1| false| 22.24| false| |
| |2017-11-07T23:50:00.000+08:00| v2| true| 23.7| true| |
| +-----------------------------+--------------------------+------------------------+-----------------------------+------------------------+ |
| Total line number = 10 |
| It costs 0.016s |
| </code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br><span class="line-number">2</span><br><span class="line-number">3</span><br><span class="line-number">4</span><br><span class="line-number">5</span><br><span class="line-number">6</span><br><span class="line-number">7</span><br><span class="line-number">8</span><br><span class="line-number">9</span><br><span class="line-number">10</span><br><span class="line-number">11</span><br><span class="line-number">12</span><br><span class="line-number">13</span><br><span class="line-number">14</span><br><span class="line-number">15</span><br><span class="line-number">16</span><br></div></div><h3 id="aggregate-query"><a href="#aggregate-query" class="header-anchor">#</a> Aggregate Query</h3> <p>This section mainly introduces the related examples of aggregate query.</p> <h4 id="count-points"><a href="#count-points" class="header-anchor">#</a> Count Points</h4> <div class="language- line-numbers-mode"><pre class="language-text"><code>select count(status) from root.ln.wf01.wt01; |
| </code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br></div></div><p>Result:</p> <div class="language- line-numbers-mode"><pre class="language-text"><code>+-------------------------------+ |
| |count(root.ln.wf01.wt01.status)| |
| +-------------------------------+ |
| | 10080| |
| +-------------------------------+ |
| Total line number = 1 |
| It costs 0.016s |
| </code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br><span class="line-number">2</span><br><span class="line-number">3</span><br><span class="line-number">4</span><br><span class="line-number">5</span><br><span class="line-number">6</span><br><span class="line-number">7</span><br></div></div><h5 id="aggregation-by-level"><a href="#aggregation-by-level" class="header-anchor">#</a> Aggregation By Level</h5> <p><strong>Aggregation by level statement</strong> is used for aggregating upon specific hierarchical level of timeseries path. |
| For all timeseries paths, by convention, "level=0" represents <em>root</em> level. |
| That is, to tally the points of any measurements under "root.ln", the level should be set to 1.</p> <p>For example, there are multiple series under "root.ln.wf01", such as "root.ln.wf01.wt01.status","root.ln.wf01.wt02.status","root.ln.wf01.wt03.status". |
| To count the number of "status" points of all these series, use query:</p> <div class="language- line-numbers-mode"><pre class="language-text"><code>select count(status) from root.ln.wf01.* group by level=2 |
| </code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br></div></div><p>Result:</p> <div class="language- line-numbers-mode"><pre class="language-text"><code>+----------------------------+ |
| |COUNT(root.ln.wf01.*.status)| |
| +----------------------------+ |
| | 10080| |
| +----------------------------+ |
| Total line number = 1 |
| It costs 0.003s |
| </code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br><span class="line-number">2</span><br><span class="line-number">3</span><br><span class="line-number">4</span><br><span class="line-number">5</span><br><span class="line-number">6</span><br><span class="line-number">7</span><br></div></div><p>Assuming another timeseries is added, called "root.ln.wf02.wt01.status". |
| To query the number of "status" points of both two paths "root.ln.wf01" and "root.ln.wf02".</p> <div class="language- line-numbers-mode"><pre class="language-text"><code>select count(status) from root.ln.*.* group by level=2 |
| </code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br></div></div><p>Result：</p> <div class="language- line-numbers-mode"><pre class="language-text"><code>+----------------------------+----------------------------+ |
| |COUNT(root.ln.wf01.*.status)|COUNT(root.ln.wf02.*.status)| |
| +----------------------------+----------------------------+ |
| | 10080| 10082| |
| +----------------------------+----------------------------+ |
| Total line number = 1 |
| It costs 0.003s |
| </code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br><span class="line-number">2</span><br><span class="line-number">3</span><br><span class="line-number">4</span><br><span class="line-number">5</span><br><span class="line-number">6</span><br><span class="line-number">7</span><br></div></div><p>All supported aggregation functions are: count, sum, avg, last_value, first_value, min_time, max_time, min_value, max_value. |
| When using four aggregations: sum, avg, min_value and max_value, please make sure all the aggregated series have exactly the same data type. |
| Otherwise, it will generate a syntax error.</p> <h3 id="down-frequency-aggregate-query"><a href="#down-frequency-aggregate-query" class="header-anchor">#</a> Down-Frequency Aggregate Query</h3> <p>This section mainly introduces the related examples of down-frequency aggregation query, |
| using the <a href="/UserGuide/Master/Operation Manual/SQL Reference.html">GROUP BY clause</a>, |
| which is used to partition the result set according to the user's given partitioning conditions and aggregate the partitioned result set. |
| IoTDB supports partitioning result sets according to time interval and customized sliding step which should not be smaller than the time interval and defaults to equal the time interval if not set. And by default results are sorted by time in ascending order. |
| You can also use the <a href="/UserGuide/Master/Client/Programming - Native API.html">Java JDBC</a> standard interface to execute related queries.</p> <p>The GROUP BY statement provides users with three types of specified parameters:</p> <ul><li>Parameter 1: The display window on the time axis</li> <li>Parameter 2: Time interval for dividing the time axis(should be positive)</li> <li>Parameter 3: Time sliding step (optional and should not be smaller than the time interval and defaults to equal the time interval if not set)</li></ul> <p>The actual meanings of the three types of parameters are shown in Figure 5.2 below. |
| Among them, the parameter 3 is optional. |
| There are three typical examples of frequency reduction aggregation: |
| parameter 3 not specified, |
| parameter 3 specified, |
| and value filtering conditions specified.</p> <center><img src="https://user-images.githubusercontent.com/16079446/69109512-f808bc80-0ab2-11ea-9e4d-b2b2f58fb474.png" style="width:100%;max-width:800px;max-height:600px;margin-left:auto;margin-right:auto;display:block;"></center> <p><strong>Figure 5.2 The actual meanings of the three types of parameters</strong></p> <h4 id="down-frequency-aggregate-query-without-specifying-the-sliding-step-length"><a href="#down-frequency-aggregate-query-without-specifying-the-sliding-step-length" class="header-anchor">#</a> Down-Frequency Aggregate Query without Specifying the Sliding Step Length</h4> <p>The SQL statement is:</p> <div class="language- line-numbers-mode"><pre class="language-text"><code>select count(status), max_value(temperature) from root.ln.wf01.wt01 group by ([2017-11-01T00:00:00, 2017-11-07T23:00:00),1d); |
| </code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br></div></div><p>which means:</p> <p>Since the sliding step length is not specified, the GROUP BY statement by default set the sliding step the same as the time interval which is <code>1d</code>.</p> <p>The fist parameter of the GROUP BY statement above is the display window parameter, which determines the final display range is [2017-11-01T00:00:00, 2017-11-07T23:00:00).</p> <p>The second parameter of the GROUP BY statement above is the time interval for dividing the time axis. Taking this parameter (1d) as time interval and startTime of the display window as the dividing origin, the time axis is divided into several continuous intervals, which are [0,1d), [1d, 2d), [2d, 3d), etc.</p> <p>Then the system will use the time and value filtering condition in the WHERE clause and the first parameter of the GROUP BY statement as the data filtering condition to obtain the data satisfying the filtering condition (which in this case is the data in the range of [2017-11-01T00:00:00, 2017-11-07 T23:00:00]), and map these data to the previously segmented time axis (in this case there are mapped data in every 1-day period from 2017-11-01T00:00:00 to 2017-11-07T23:00:00:00).</p> <p>Since there is data for each time period in the result range to be displayed, the execution result of the SQL statement is shown below:</p> <div class="language- line-numbers-mode"><pre class="language-text"><code>+-----------------------------+-------------------------------+----------------------------------------+ |
| | Time|count(root.ln.wf01.wt01.status)|max_value(root.ln.wf01.wt01.temperature)| |
| +-----------------------------+-------------------------------+----------------------------------------+ |
| |2017-11-01T00:00:00.000+08:00| 1440| 26.0| |
| |2017-11-02T00:00:00.000+08:00| 1440| 26.0| |
| |2017-11-03T00:00:00.000+08:00| 1440| 25.99| |
| |2017-11-04T00:00:00.000+08:00| 1440| 26.0| |
| |2017-11-05T00:00:00.000+08:00| 1440| 26.0| |
| |2017-11-06T00:00:00.000+08:00| 1440| 25.99| |
| |2017-11-07T00:00:00.000+08:00| 1380| 26.0| |
| +-----------------------------+-------------------------------+----------------------------------------+ |
| Total line number = 7 |
| It costs 0.024s |
| </code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br><span class="line-number">2</span><br><span class="line-number">3</span><br><span class="line-number">4</span><br><span class="line-number">5</span><br><span class="line-number">6</span><br><span class="line-number">7</span><br><span class="line-number">8</span><br><span class="line-number">9</span><br><span class="line-number">10</span><br><span class="line-number">11</span><br><span class="line-number">12</span><br><span class="line-number">13</span><br></div></div><h4 id="down-frequency-aggregate-query-specifying-the-sliding-step-length"><a href="#down-frequency-aggregate-query-specifying-the-sliding-step-length" class="header-anchor">#</a> Down-Frequency Aggregate Query Specifying the Sliding Step Length</h4> <p>The SQL statement is:</p> <div class="language- line-numbers-mode"><pre class="language-text"><code>select count(status), max_value(temperature) from root.ln.wf01.wt01 group by ([2017-11-01 00:00:00, 2017-11-07 23:00:00), 3h, 1d); |
| </code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br></div></div><p>which means:</p> <p>Since the user specifies the sliding step parameter as 1d, the GROUP BY statement will move the time interval <code>1 day</code> long instead of <code>3 hours</code> as default.</p> <p>That means we want to fetch all the data of 00:00:00 to 02:59:59 every day from 2017-11-01 to 2017-11-07.</p> <p>The first parameter of the GROUP BY statement above is the display window parameter, which determines the final display range is [2017-11-01T00:00:00, 2017-11-07T23:00:00).</p> <p>The second parameter of the GROUP BY statement above is the time interval for dividing the time axis. Taking this parameter (3h) as time interval and the startTime of the display window as the dividing origin, the time axis is divided into several continuous intervals, which are [2017-11-01T00:00:00, 2017-11-01T03:00:00), [2017-11-02T00:00:00, 2017-11-02T03:00:00), [2017-11-03T00:00:00, 2017-11-03T03:00:00), etc.</p> <p>The third parameter of the GROUP BY statement above is the sliding step for each time interval moving.</p> <p>Then the system will use the time and value filtering condition in the WHERE clause and the first parameter of the GROUP BY statement as the data filtering condition to obtain the data satisfying the filtering condition (which in this case is the data in the range of [2017-11-01T00:00:00, 2017-11-07T23:00:00]), and map these data to the previously segmented time axis (in this case there are mapped data in every 3-hour period for each day from 2017-11-01T00:00:00 to 2017-11-07T23:00:00:00).</p> <p>Since there is data for each time period in the result range to be displayed, the execution result of the SQL statement is shown below:</p> <div class="language- line-numbers-mode"><pre class="language-text"><code>+-----------------------------+-------------------------------+----------------------------------------+ |
| | Time|count(root.ln.wf01.wt01.status)|max_value(root.ln.wf01.wt01.temperature)| |
| +-----------------------------+-------------------------------+----------------------------------------+ |
| |2017-11-01T00:00:00.000+08:00| 180| 25.98| |
| |2017-11-02T00:00:00.000+08:00| 180| 25.98| |
| |2017-11-03T00:00:00.000+08:00| 180| 25.96| |
| |2017-11-04T00:00:00.000+08:00| 180| 25.96| |
| |2017-11-05T00:00:00.000+08:00| 180| 26.0| |
| |2017-11-06T00:00:00.000+08:00| 180| 25.85| |
| |2017-11-07T00:00:00.000+08:00| 180| 25.99| |
| +-----------------------------+-------------------------------+----------------------------------------+ |
| Total line number = 7 |
| It costs 0.006s |
| </code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br><span class="line-number">2</span><br><span class="line-number">3</span><br><span class="line-number">4</span><br><span class="line-number">5</span><br><span class="line-number">6</span><br><span class="line-number">7</span><br><span class="line-number">8</span><br><span class="line-number">9</span><br><span class="line-number">10</span><br><span class="line-number">11</span><br><span class="line-number">12</span><br><span class="line-number">13</span><br></div></div><h4 id="down-frequency-aggregate-query-specifying-the-value-filtering-conditions"><a href="#down-frequency-aggregate-query-specifying-the-value-filtering-conditions" class="header-anchor">#</a> Down-Frequency Aggregate Query Specifying the value Filtering Conditions</h4> <p>The SQL statement is:</p> <div class="language- line-numbers-mode"><pre class="language-text"><code>select count(status), max_value(temperature) from root.ln.wf01.wt01 where group by([2017-11-01T00:00:00, 2017-11-07T23:00:00), 3h, 1d); |
| </code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br></div></div><p>which means:</p> <p>Since the user specifies the sliding step parameter as 1d, the GROUP BY statement will move the time interval <code>1 day</code> long instead of <code>3 hours</code> as default.</p> <p>The first parameter of the GROUP BY statement above is the display window parameter, which determines the final display range is [2017-11-01T00:00:00, 2017-11-07T23:00:00).</p> <p>The second parameter of the GROUP BY statement above is the time interval for dividing the time axis. Taking this parameter (3h) as time interval and the startTime of the display window as the dividing origin, the time axis is divided into several continuous intervals, which are [2017-11-01T00:00:00, 2017-11-01T03:00:00), [2017-11-02T00:00:00, 2017-11-02T03:00:00), [2017-11-03T00:00:00, 2017-11-03T03:00:00), etc.</p> <p>The third parameter of the GROUP BY statement above is the sliding step for each time interval moving.</p> <p>Then the system will use the time and value filtering condition in the WHERE clause and the first parameter of the GROUP BY statement as the data filtering condition to obtain the data satisfying the filtering condition (which in this case is the data in the range of (2017-11-01T00:00:00, 2017-11-07T23:00:00]), and map these data to the previously segmented time axis (in this case there are mapped data in every 3-hour period for each day from 2017-11-01T00:00:00 to 2017-11-07T23:00:00).</p> <div class="language- line-numbers-mode"><pre class="language-text"><code>+-----------------------------+-------------------------------+----------------------------------------+ |
| | Time|count(root.ln.wf01.wt01.status)|max_value(root.ln.wf01.wt01.temperature)| |
| +-----------------------------+-------------------------------+----------------------------------------+ |
| |2017-11-01T00:00:00.000+08:00| 180| 25.98| |
| |2017-11-02T00:00:00.000+08:00| 179| 25.98| |
| |2017-11-03T00:00:00.000+08:00| 180| 25.96| |
| |2017-11-04T00:00:00.000+08:00| 180| 25.96| |
| |2017-11-05T00:00:00.000+08:00| 180| 26.0| |
| |2017-11-06T00:00:00.000+08:00| 180| 25.85| |
| |2017-11-07T00:00:00.000+08:00| 180| 25.99| |
| +-----------------------------+-------------------------------+----------------------------------------+ |
| Total line number = 7 |
| It costs 0.018s |
| </code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br><span class="line-number">2</span><br><span class="line-number">3</span><br><span class="line-number">4</span><br><span class="line-number">5</span><br><span class="line-number">6</span><br><span class="line-number">7</span><br><span class="line-number">8</span><br><span class="line-number">9</span><br><span class="line-number">10</span><br><span class="line-number">11</span><br><span class="line-number">12</span><br><span class="line-number">13</span><br></div></div><h4 id="down-frequency-aggregate-query-by-natural-month"><a href="#down-frequency-aggregate-query-by-natural-month" class="header-anchor">#</a> Down-Frequency Aggregate Query by Natural Month</h4> <p>The SQL statement is:</p> <div class="language- line-numbers-mode"><pre class="language-text"><code>select count(status) from root.ln.wf01.wt01 group by([2017-11-01T00:00:00, 2019-11-07T23:00:00), 1mo, 2mo); |
| </code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br></div></div><p>which means:</p> <p>Since the user specifies the sliding step parameter as <code>2mo</code>, the GROUP BY statement will move the time interval <code>2 months</code> long instead of <code>1 month</code> as default.</p> <p>The first parameter of the GROUP BY statement above is the display window parameter, which determines the final display range is [2017-11-01T00:00:00, 2019-11-07T23:00:00).</p> <p>The start time is 2017-11-01T00:00:00. The sliding step will increment monthly based on the start date, and the 1st day of the month will be used as the time interval's start time.</p> <p>The second parameter of the GROUP BY statement above is the time interval for dividing the time axis. Taking this parameter (1mo) as time interval and the startTime of the display window as the dividing origin, the time axis is divided into several continuous intervals, which are [2017-11-01T00:00:00, 2017-12-01T00:00:00), [2018-02-01T00:00:00, 2018-03-01T00:00:00), [2018-05-03T00:00:00, 2018-06-01T00:00:00)), etc.</p> <p>The third parameter of the GROUP BY statement above is the sliding step for each time interval moving.</p> <p>Then the system will use the time and value filtering condition in the WHERE clause and the first parameter of the GROUP BY statement as the data filtering condition to obtain the data satisfying the filtering condition (which in this case is the data in the range of (2017-11-01T00:00:00, 2019-11-07T23:00:00], and map these data to the previously segmented time axis (in this case there are mapped data of the first month in every two month period from 2017-11-01T00:00:00 to 2019-11-07T23:00:00).</p> <p>The SQL execution result is:</p> <div class="language- line-numbers-mode"><pre class="language-text"><code>+-----------------------------+-------------------------------+ |
| | Time|count(root.ln.wf01.wt01.status)| |
| +-----------------------------+-------------------------------+ |
| |2017-11-01T00:00:00.000+08:00| 259| |
| |2018-01-01T00:00:00.000+08:00| 250| |
| |2018-03-01T00:00:00.000+08:00| 259| |
| |2018-05-01T00:00:00.000+08:00| 251| |
| |2018-07-01T00:00:00.000+08:00| 242| |
| |2018-09-01T00:00:00.000+08:00| 225| |
| |2018-11-01T00:00:00.000+08:00| 216| |
| |2019-01-01T00:00:00.000+08:00| 207| |
| |2019-03-01T00:00:00.000+08:00| 216| |
| |2019-05-01T00:00:00.000+08:00| 207| |
| |2019-07-01T00:00:00.000+08:00| 199| |
| |2019-09-01T00:00:00.000+08:00| 181| |
| |2019-11-01T00:00:00.000+08:00| 60| |
| +-----------------------------+-------------------------------+ |
| </code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br><span class="line-number">2</span><br><span class="line-number">3</span><br><span class="line-number">4</span><br><span class="line-number">5</span><br><span class="line-number">6</span><br><span class="line-number">7</span><br><span class="line-number">8</span><br><span class="line-number">9</span><br><span class="line-number">10</span><br><span class="line-number">11</span><br><span class="line-number">12</span><br><span class="line-number">13</span><br><span class="line-number">14</span><br><span class="line-number">15</span><br><span class="line-number">16</span><br><span class="line-number">17</span><br></div></div><p>对应的SQL语句是:</p> <div class="language- line-numbers-mode"><pre class="language-text"><code>select count(status) from root.ln.wf01.wt01 group by([2017-10-31T00:00:00, 2019-11-07T23:00:00), 1mo, 2mo); |
| </code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br></div></div><p>which means:</p> <p>Since the user specifies the sliding step parameter as <code>2mo</code>, the GROUP BY statement will move the time interval <code>2 months</code> long instead of <code>1 month</code> as default.</p> <p>The first parameter of the GROUP BY statement above is the display window parameter, which determines the final display range is [2017-10-31T00:00:00, 2019-11-07T23:00:00).</p> <p>Different from the previous example, the start time is set to 2017-10-31T00:00:00. The sliding step will increment monthly based on the start date, and the 31st day of the month meaning the last day of the month will be used as the time interval's start time. If the start time is set to the 30th date, the sliding step will use the 30th or the last day of the month.</p> <p>The start time is 2017-10-31T00:00:00. The sliding step will increment monthly based on the start time, and the 1st day of the month will be used as the time interval's start time.</p> <p>The second parameter of the GROUP BY statement above is the time interval for dividing the time axis. Taking this parameter (1mo) as time interval and the startTime of the display window as the dividing origin, the time axis is divided into several continuous intervals, which are [2017-10-31T00:00:00, 2017-11-31T00:00:00), [2018-02-31T00:00:00, 2018-03-31T00:00:00), [2018-05-31T00:00:00, 2018-06-31T00:00:00), etc.</p> <p>The third parameter of the GROUP BY statement above is the sliding step for each time interval moving.</p> <p>Then the system will use the time and value filtering condition in the WHERE clause and the first parameter of the GROUP BY statement as the data filtering condition to obtain the data satisfying the filtering condition (which in this case is the data in the range of [2017-10-31T00:00:00, 2019-11-07T23:00:00) and map these data to the previously segmented time axis (in this case there are mapped data of the first month in every two month period from 2017-10-31T00:00:00 to 2019-11-07T23:00:00).</p> <p>The SQL execution result is:</p> <div class="language- line-numbers-mode"><pre class="language-text"><code>+-----------------------------+-------------------------------+ |
| | Time|count(root.ln.wf01.wt01.status)| |
| +-----------------------------+-------------------------------+ |
| |2017-10-31T00:00:00.000+08:00| 251| |
| |2017-12-31T00:00:00.000+08:00| 250| |
| |2018-02-28T00:00:00.000+08:00| 259| |
| |2018-04-30T00:00:00.000+08:00| 250| |
| |2018-06-30T00:00:00.000+08:00| 242| |
| |2018-08-31T00:00:00.000+08:00| 225| |
| |2018-10-31T00:00:00.000+08:00| 216| |
| |2018-12-31T00:00:00.000+08:00| 208| |
| |2019-02-28T00:00:00.000+08:00| 216| |
| |2019-04-30T00:00:00.000+08:00| 208| |
| |2019-06-30T00:00:00.000+08:00| 199| |
| |2019-08-31T00:00:00.000+08:00| 181| |
| |2019-10-31T00:00:00.000+08:00| 69| |
| +-----------------------------+-------------------------------+ |
| </code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br><span class="line-number">2</span><br><span class="line-number">3</span><br><span class="line-number">4</span><br><span class="line-number">5</span><br><span class="line-number">6</span><br><span class="line-number">7</span><br><span class="line-number">8</span><br><span class="line-number">9</span><br><span class="line-number">10</span><br><span class="line-number">11</span><br><span class="line-number">12</span><br><span class="line-number">13</span><br><span class="line-number">14</span><br><span class="line-number">15</span><br><span class="line-number">16</span><br><span class="line-number">17</span><br></div></div><h4 id="left-open-and-right-close-range"><a href="#left-open-and-right-close-range" class="header-anchor">#</a> Left Open And Right Close Range</h4> <p>The SQL statement is:</p> <div class="language- line-numbers-mode"><pre class="language-text"><code>select count(status) from root.ln.wf01.wt01 group by ((2017-11-01T00:00:00, 2017-11-07T23:00:00],1d); |
| </code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br></div></div><p>In this sql, the time interval is left open and right close, so we won't include the value of timestamp 2017-11-01T00:00:00 and instead we will include the value of timestamp 2017-11-07T23:00:00.</p> <p>We will get the result like following:</p> <div class="language- line-numbers-mode"><pre class="language-text"><code>+-----------------------------+-------------------------------+ |
| | Time|count(root.ln.wf01.wt01.status)| |
| +-----------------------------+-------------------------------+ |
| |2017-11-02T00:00:00.000+08:00| 1440| |
| |2017-11-03T00:00:00.000+08:00| 1440| |
| |2017-11-04T00:00:00.000+08:00| 1440| |
| |2017-11-05T00:00:00.000+08:00| 1440| |
| |2017-11-06T00:00:00.000+08:00| 1440| |
| |2017-11-07T00:00:00.000+08:00| 1440| |
| |2017-11-07T23:00:00.000+08:00| 1380| |
| +-----------------------------+-------------------------------+ |
| Total line number = 7 |
| It costs 0.004s |
| </code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br><span class="line-number">2</span><br><span class="line-number">3</span><br><span class="line-number">4</span><br><span class="line-number">5</span><br><span class="line-number">6</span><br><span class="line-number">7</span><br><span class="line-number">8</span><br><span class="line-number">9</span><br><span class="line-number">10</span><br><span class="line-number">11</span><br><span class="line-number">12</span><br><span class="line-number">13</span><br></div></div><h4 id="down-frequency-aggregate-query-with-level-clause"><a href="#down-frequency-aggregate-query-with-level-clause" class="header-anchor">#</a> Down-Frequency Aggregate Query with Level Clause</h4> <p>Level could be defined to show count the number of points of each node at the given level in current Metadata Tree.</p> <p>This could be used to query the number of points under each device.</p> <p>The SQL statement is:</p> <p>Get down-frequency aggregate query by level.</p> <div class="language- line-numbers-mode"><pre class="language-text"><code>select count(status) from root.ln.wf01.wt01 group by ((2017-11-01T00:00:00, 2017-11-07T23:00:00],1d), level=1; |
| </code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br></div></div><p>Result:</p> <div class="language- line-numbers-mode"><pre class="language-text"><code>+-----------------------------+-------------------------+ |
| | Time|COUNT(root.ln.*.*.status)| |
| +-----------------------------+-------------------------+ |
| |2017-11-02T00:00:00.000+08:00| 1440| |
| |2017-11-03T00:00:00.000+08:00| 1440| |
| |2017-11-04T00:00:00.000+08:00| 1440| |
| |2017-11-05T00:00:00.000+08:00| 1440| |
| |2017-11-06T00:00:00.000+08:00| 1440| |
| |2017-11-07T00:00:00.000+08:00| 1440| |
| |2017-11-07T23:00:00.000+08:00| 1380| |
| +-----------------------------+-------------------------+ |
| Total line number = 7 |
| It costs 0.006s |
| </code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br><span class="line-number">2</span><br><span class="line-number">3</span><br><span class="line-number">4</span><br><span class="line-number">5</span><br><span class="line-number">6</span><br><span class="line-number">7</span><br><span class="line-number">8</span><br><span class="line-number">9</span><br><span class="line-number">10</span><br><span class="line-number">11</span><br><span class="line-number">12</span><br><span class="line-number">13</span><br></div></div><p>Down-frequency aggregate query with sliding step and by level.</p> <div class="language- line-numbers-mode"><pre class="language-text"><code>select count(status) from root.ln.wf01.wt01 group by ([2017-11-01 00:00:00, 2017-11-07 23:00:00), 3h, 1d), level=1; |
| </code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br></div></div><p>Result:</p> <div class="language- line-numbers-mode"><pre class="language-text"><code>+-----------------------------+-------------------------+ |
| | Time|COUNT(root.ln.*.*.status)| |
| +-----------------------------+-------------------------+ |
| |2017-11-01T00:00:00.000+08:00| 180| |
| |2017-11-02T00:00:00.000+08:00| 180| |
| |2017-11-03T00:00:00.000+08:00| 180| |
| |2017-11-04T00:00:00.000+08:00| 180| |
| |2017-11-05T00:00:00.000+08:00| 180| |
| |2017-11-06T00:00:00.000+08:00| 180| |
| |2017-11-07T00:00:00.000+08:00| 180| |
| +-----------------------------+-------------------------+ |
| Total line number = 7 |
| It costs 0.004s |
| </code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br><span class="line-number">2</span><br><span class="line-number">3</span><br><span class="line-number">4</span><br><span class="line-number">5</span><br><span class="line-number">6</span><br><span class="line-number">7</span><br><span class="line-number">8</span><br><span class="line-number">9</span><br><span class="line-number">10</span><br><span class="line-number">11</span><br><span class="line-number">12</span><br><span class="line-number">13</span><br></div></div><h4 id="down-frequency-aggregate-query-with-fill-clause"><a href="#down-frequency-aggregate-query-with-fill-clause" class="header-anchor">#</a> Down-Frequency Aggregate Query with Fill Clause</h4> <p>In group by fill, sliding step is not supported in group by clause</p> <p>Now, only last_value aggregation function is supported in group by fill.</p> <p>Linear fill is not supported in group by fill.</p> <h5 id="difference-between-previousuntillast-and-previous"><a href="#difference-between-previousuntillast-and-previous" class="header-anchor">#</a> Difference Between PREVIOUSUNTILLAST And PREVIOUS</h5> <ul><li>PREVIOUS will fill any null value as long as there exist value is not null before it.</li> <li>PREVIOUSUNTILLAST won't fill the result whose time is after the last time of that time series.</li></ul> <p>first, we check value root.ln.wf01.wt01.temperature when time after 2017-11-07T23:50:00.</p> <div class="language- line-numbers-mode"><pre class="language-text"><code>IoTDB> SELECT temperature FROM root.ln.wf01.wt01 where time >= 2017-11-07T23:50:00 |
| +-----------------------------+-----------------------------+ |
| | Time|root.ln.wf01.wt01.temperature| |
| +-----------------------------+-----------------------------+ |
| |2017-11-07T23:50:00.000+08:00| 23.7| |
| |2017-11-07T23:51:00.000+08:00| 22.24| |
| |2017-11-07T23:52:00.000+08:00| 20.18| |
| |2017-11-07T23:53:00.000+08:00| 24.58| |
| |2017-11-07T23:54:00.000+08:00| 22.52| |
| |2017-11-07T23:55:00.000+08:00| 25.9| |
| |2017-11-07T23:56:00.000+08:00| 24.44| |
| |2017-11-07T23:57:00.000+08:00| 24.39| |
| |2017-11-07T23:58:00.000+08:00| 22.93| |
| |2017-11-07T23:59:00.000+08:00| 21.07| |
| +-----------------------------+-----------------------------+ |
| Total line number = 10 |
| It costs 0.002s |
| </code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br><span class="line-number">2</span><br><span class="line-number">3</span><br><span class="line-number">4</span><br><span class="line-number">5</span><br><span class="line-number">6</span><br><span class="line-number">7</span><br><span class="line-number">8</span><br><span class="line-number">9</span><br><span class="line-number">10</span><br><span class="line-number">11</span><br><span class="line-number">12</span><br><span class="line-number">13</span><br><span class="line-number">14</span><br><span class="line-number">15</span><br><span class="line-number">16</span><br><span class="line-number">17</span><br></div></div><p>we will find the last time and value of root.ln.wf01.wt01.temperature are 2017-11-07T23:59:00 and 21.07 respectively.</p> <p>Then execute SQL statements:</p> <div class="language- line-numbers-mode"><pre class="language-text"><code>SELECT last_value(temperature) FROM root.ln.wf01.wt01 GROUP BY([2017-11-07T23:50:00, 2017-11-08T00:01:00),1m) FILL (float[PREVIOUSUNTILLAST]); |
| SELECT last_value(temperature) FROM root.ln.wf01.wt01 GROUP BY([2017-11-07T23:50:00, 2017-11-08T00:01:00),1m) FILL (float[PREVIOUS]); |
| </code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br><span class="line-number">2</span><br></div></div><p>result:</p> <div class="language- line-numbers-mode"><pre class="language-text"><code>+-----------------------------+-----------------------------------------+ |
| | Time|last_value(root.ln.wf01.wt01.temperature)| |
| +-----------------------------+-----------------------------------------+ |
| |2017-11-07T23:50:00.000+08:00| 23.7| |
| |2017-11-07T23:51:00.000+08:00| 22.24| |
| |2017-11-07T23:52:00.000+08:00| 20.18| |
| |2017-11-07T23:53:00.000+08:00| 24.58| |
| |2017-11-07T23:54:00.000+08:00| 22.52| |
| |2017-11-07T23:55:00.000+08:00| 25.9| |
| |2017-11-07T23:56:00.000+08:00| 24.44| |
| |2017-11-07T23:57:00.000+08:00| 24.39| |
| |2017-11-07T23:58:00.000+08:00| 22.93| |
| |2017-11-07T23:59:00.000+08:00| 21.07| |
| |2017-11-08T00:00:00.000+08:00| null| |
| +-----------------------------+-----------------------------------------+ |
| Total line number = 11 |
| It costs 0.005s |
| |
| +-----------------------------+-----------------------------------------+ |
| | Time|last_value(root.ln.wf01.wt01.temperature)| |
| +-----------------------------+-----------------------------------------+ |
| |2017-11-07T23:50:00.000+08:00| 23.7| |
| |2017-11-07T23:51:00.000+08:00| 22.24| |
| |2017-11-07T23:52:00.000+08:00| 20.18| |
| |2017-11-07T23:53:00.000+08:00| 24.58| |
| |2017-11-07T23:54:00.000+08:00| 22.52| |
| |2017-11-07T23:55:00.000+08:00| 25.9| |
| |2017-11-07T23:56:00.000+08:00| 24.44| |
| |2017-11-07T23:57:00.000+08:00| 24.39| |
| |2017-11-07T23:58:00.000+08:00| 22.93| |
| |2017-11-07T23:59:00.000+08:00| 21.07| |
| |2017-11-08T00:00:00.000+08:00| 21.07| |
| +-----------------------------+-----------------------------------------+ |
| Total line number = 11 |
| It costs 0.006s |
| </code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br><span class="line-number">2</span><br><span class="line-number">3</span><br><span class="line-number">4</span><br><span class="line-number">5</span><br><span class="line-number">6</span><br><span class="line-number">7</span><br><span class="line-number">8</span><br><span class="line-number">9</span><br><span class="line-number">10</span><br><span class="line-number">11</span><br><span class="line-number">12</span><br><span class="line-number">13</span><br><span class="line-number">14</span><br><span class="line-number">15</span><br><span class="line-number">16</span><br><span class="line-number">17</span><br><span class="line-number">18</span><br><span class="line-number">19</span><br><span class="line-number">20</span><br><span class="line-number">21</span><br><span class="line-number">22</span><br><span class="line-number">23</span><br><span class="line-number">24</span><br><span class="line-number">25</span><br><span class="line-number">26</span><br><span class="line-number">27</span><br><span class="line-number">28</span><br><span class="line-number">29</span><br><span class="line-number">30</span><br><span class="line-number">31</span><br><span class="line-number">32</span><br><span class="line-number">33</span><br><span class="line-number">34</span><br><span class="line-number">35</span><br></div></div><p>which means:</p> <p>using PREVIOUSUNTILLAST won't fill time after 2017-11-07T23:59.</p> <h3 id="last-point-query"><a href="#last-point-query" class="header-anchor">#</a> Last point Query</h3> <p>In scenarios when IoT devices updates data in a fast manner, users are more interested in the most recent point of IoT devices.</p> <p>The Last point query is to return the most recent data point of the given timeseries in a three column format.</p> <p>The SQL statement is defined as:</p> <div class="language- line-numbers-mode"><pre class="language-text"><code>select last <Path> [COMMA <Path>]* from < PrefixPath > [COMMA < PrefixPath >]* <WhereClause> |
| </code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br></div></div><p>which means: Query and return the last data points of timeseries prefixPath.path.</p> <p>Only time filter with '>' or '>=' is supported in <WhereClause>. Any other filters given in the <WhereClause> will give an exception.</p> <p>The result will be returned in a three column table format.</p> <div class="language- line-numbers-mode"><pre class="language-text"><code>| Time | Path | Value | |
| </code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br></div></div><p>Example 1: get the last point of root.ln.wf01.wt01.status:</p> <div class="language- line-numbers-mode"><pre class="language-text"><code>IoTDB> select last status from root.ln.wf01.wt01 |
| +-----------------------------+------------------------+-----+ |
| | Time| timeseries|value| |
| +-----------------------------+------------------------+-----+ |
| |2017-11-07T23:59:00.000+08:00|root.ln.wf01.wt01.status|false| |
| +-----------------------------+------------------------+-----+ |
| Total line number = 1 |
| It costs 0.000s |
| </code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br><span class="line-number">2</span><br><span class="line-number">3</span><br><span class="line-number">4</span><br><span class="line-number">5</span><br><span class="line-number">6</span><br><span class="line-number">7</span><br><span class="line-number">8</span><br></div></div><p>Example 2: get the last status and temperature points of root.ln.wf01.wt01, |
| whose timestamp larger or equal to 2017-11-07T23:50:00。</p> <div class="language- line-numbers-mode"><pre class="language-text"><code>IoTDB> select last status, temperature from root.ln.wf01.wt01 where time >= 2017-11-07T23:50:00 |
| +-----------------------------+-----------------------------+---------+ |
| | Time| timeseries| value| |
| +-----------------------------+-----------------------------+---------+ |
| |2017-11-07T23:59:00.000+08:00| root.ln.wf01.wt01.status| false| |
| |2017-11-07T23:59:00.000+08:00|root.ln.wf01.wt01.temperature|21.067368| |
| +-----------------------------+-----------------------------+---------+ |
| Total line number = 2 |
| It costs 0.002s |
| </code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br><span class="line-number">2</span><br><span class="line-number">3</span><br><span class="line-number">4</span><br><span class="line-number">5</span><br><span class="line-number">6</span><br><span class="line-number">7</span><br><span class="line-number">8</span><br><span class="line-number">9</span><br></div></div><h3 id="automated-fill"><a href="#automated-fill" class="header-anchor">#</a> Automated Fill</h3> <p>In the actual use of IoTDB, when doing the query operation of timeseries, situations where the value is null at some time points may appear, which will obstruct the further analysis by users. In order to better reflect the degree of data change, users expect missing values to be automatically filled. Therefore, the IoTDB system introduces the function of Automated Fill.</p> <p>Automated fill function refers to filling empty values according to the user's specified method and effective time range when performing timeseries queries for single or multiple columns. If the queried point's value is not null, the fill function will not work.</p> <blockquote><p>Note: In the current version, IoTDB provides users with two methods: Previous and Linear. The previous method fills blanks with previous value. The linear method fills blanks through linear fitting. And the fill function can only be used when performing point-in-time queries.</p></blockquote> <h4 id="fill-function"><a href="#fill-function" class="header-anchor">#</a> Fill Function</h4> <ul><li>Previous Function</li></ul> <p>When the value of the queried timestamp is null, the value of the previous timestamp is used to fill the blank. The formalized previous method is as follows (see Section 7.1.3.6 for detailed syntax):</p> <div class="language- line-numbers-mode"><pre class="language-text"><code>select <path> from <prefixPath> where time = <T> fill(<data_type>[previous, <before_range>], …) |
| </code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br></div></div><p>Detailed descriptions of all parameters are given in Table 3-4.</p> <center>**Table 3-4 Previous fill paramter list** |
| <table><thead><tr><th style="text-align:left;">Parameter name (case insensitive)</th> <th style="text-align:left;">Interpretation</th></tr></thead> <tbody><tr><td style="text-align:left;">path, prefixPath</td> <td style="text-align:left;">query path; mandatory field</td></tr> <tr><td style="text-align:left;">T</td> <td style="text-align:left;">query timestamp (only one can be specified); mandatory field</td></tr> <tr><td style="text-align:left;">data_type</td> <td style="text-align:left;">the type of data used by the fill method. Optional values are int32, int64, float, double, boolean, text; optional field</td></tr> <tr><td style="text-align:left;">before_range</td> <td style="text-align:left;">represents the valid time range of the previous method. The previous method works when there are values in the [T-before_range, T] range. When before_range is not specified, before_range takes the default value default_fill_interval; -1 represents infinit; optional field</td></tr></tbody></table></center> <p>Here we give an example of filling null values using the previous method. The SQL statement is as follows:</p> <div class="language- line-numbers-mode"><pre class="language-text"><code>select temperature from root.sgcc.wf03.wt01 where time = 2017-11-01T16:37:50.000 fill(float[previous, 1s]) |
| </code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br></div></div><p>which means:</p> <p>Because the timeseries root.sgcc.wf03.wt01.temperature is null at 2017-11-01T16:37:50.000, the system uses the previous timestamp 2017-11-01T16:37:00.000 (and the timestamp is in the [2017-11-01T16:36:50.000, 2017-11-01T16:37:50.000] time range) for fill and display.</p> <p>On the <a href="https://github.com/thulab/iotdb/files/4438687/OtherMaterial-Sample.Data.txt" target="_blank" rel="noopener noreferrer">sample data<span><svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewBox="0 0 100 100" width="15" height="15" class="icon outbound"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path> <polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg> <span class="sr-only">(opens new window)</span></span></a>, the execution result of this statement is shown below:</p> <div class="language- line-numbers-mode"><pre class="language-text"><code>+-----------------------------+-------------------------------+ |
| | Time|root.sgcc.wf03.wt01.temperature| |
| +-----------------------------+-------------------------------+ |
| |2017-11-01T16:37:50.000+08:00| 21.93| |
| +-----------------------------+-------------------------------+ |
| Total line number = 1 |
| It costs 0.016s |
| </code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br><span class="line-number">2</span><br><span class="line-number">3</span><br><span class="line-number">4</span><br><span class="line-number">5</span><br><span class="line-number">6</span><br><span class="line-number">7</span><br></div></div><p>It is worth noting that if there is no value in the specified valid time range, the system will not fill the null value, as shown below:</p> <div class="language- line-numbers-mode"><pre class="language-text"><code>IoTDB> select temperature from root.sgcc.wf03.wt01 where time = 2017-11-01T16:37:50.000 fill(float[previous, 1s]) |
| +-----------------------------+-------------------------------+ |
| | Time|root.sgcc.wf03.wt01.temperature| |
| +-----------------------------+-------------------------------+ |
| |2017-11-01T16:37:50.000+08:00| null| |
| +-----------------------------+-------------------------------+ |
| Total line number = 1 |
| It costs 0.004s |
| </code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br><span class="line-number">2</span><br><span class="line-number">3</span><br><span class="line-number">4</span><br><span class="line-number">5</span><br><span class="line-number">6</span><br><span class="line-number">7</span><br><span class="line-number">8</span><br></div></div><ul><li>Linear Method</li></ul> <p>When the value of the queried timestamp is null, the value of the previous and the next timestamp is used to fill the blank. The formalized linear method is as follows:</p> <div class="language- line-numbers-mode"><pre class="language-text"><code>select <path> from <prefixPath> where time = <T> fill(<data_type>[linear, <before_range>, <after_range>]…) |
| </code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br></div></div><p>Detailed descriptions of all parameters are given in Table 3-5.</p> <center>**Table 3-5 Linear fill paramter list** |
| <table><thead><tr><th style="text-align:left;">Parameter name (case insensitive)</th> <th style="text-align:left;">Interpretation</th></tr></thead> <tbody><tr><td style="text-align:left;">path, prefixPath</td> <td style="text-align:left;">query path; mandatory field</td></tr> <tr><td style="text-align:left;">T</td> <td style="text-align:left;">query timestamp (only one can be specified); mandatory field</td></tr> <tr><td style="text-align:left;">data_type</td> <td style="text-align:left;">the type of data used by the fill method. Optional values are int32, int64, float, double, boolean, text; optional field</td></tr> <tr><td style="text-align:left;">before_range, after_range</td> <td style="text-align:left;">represents the valid time range of the linear method. The previous method works when there are values in the [T-before_range, T+after_range] range. When before_range and after_range are not explicitly specified, default_fill_interval is used. -1 represents infinity; optional field</td></tr></tbody></table></center> <p><strong>Note</strong> if the timeseries has a valid value at query timestamp T, this value will be used as the linear fill value. |
| Otherwise, if there is no valid fill value in either range [T-before_range，T] or [T, T + after_range], linear fill method will return null.</p> <p>Here we give an example of filling null values using the linear method. The SQL statement is as follows:</p> <div class="language- line-numbers-mode"><pre class="language-text"><code>select temperature from root.sgcc.wf03.wt01 where time = 2017-11-01T16:37:50.000 fill(float [linear, 1m, 1m]) |
| </code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br></div></div><p>which means:</p> <p>Because the timeseries root.sgcc.wf03.wt01.temperature is null at 2017-11-01T16:37:50.000, the system uses the previous timestamp 2017-11-01T16:37:00.000 (and the timestamp is in the [2017-11-01T16:36:50.000, 2017-11-01T16:37:50.000] time range) and its value 21.927326, the next timestamp 2017-11-01T16:38:00.000 (and the timestamp is in the [2017-11-01T16:37:50.000, 2017-11-01T16:38:50.000] time range) and its value 25.311783 to perform linear fitting calculation: 21.927326 + (25.311783-21.927326)/60s * 50s = 24.747707</p> <p>On the <a href="https://github.com/thulab/iotdb/files/4438687/OtherMaterial-Sample.Data.txt" target="_blank" rel="noopener noreferrer">sample data<span><svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewBox="0 0 100 100" width="15" height="15" class="icon outbound"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path> <polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg> <span class="sr-only">(opens new window)</span></span></a>, the execution result of this statement is shown below:</p> <div class="language- line-numbers-mode"><pre class="language-text"><code>+-----------------------------+-------------------------------+ |
| | Time|root.sgcc.wf03.wt01.temperature| |
| +-----------------------------+-------------------------------+ |
| |2017-11-01T16:37:50.000+08:00| 24.746666| |
| +-----------------------------+-------------------------------+ |
| Total line number = 1 |
| It costs 0.017s |
| </code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br><span class="line-number">2</span><br><span class="line-number">3</span><br><span class="line-number">4</span><br><span class="line-number">5</span><br><span class="line-number">6</span><br><span class="line-number">7</span><br></div></div><h4 id="correspondence-between-data-type-and-fill-method"><a href="#correspondence-between-data-type-and-fill-method" class="header-anchor">#</a> Correspondence between Data Type and Fill Method</h4> <p>Data types and the supported fill methods are shown in Table 3-6.</p> <center>**Table 3-6 Data types and the supported fill methods** |
| <table><thead><tr><th style="text-align:left;">Data Type</th> <th style="text-align:left;">Supported Fill Methods</th></tr></thead> <tbody><tr><td style="text-align:left;">boolean</td> <td style="text-align:left;">previous</td></tr> <tr><td style="text-align:left;">int32</td> <td style="text-align:left;">previous, linear</td></tr> <tr><td style="text-align:left;">int64</td> <td style="text-align:left;">previous, linear</td></tr> <tr><td style="text-align:left;">float</td> <td style="text-align:left;">previous, linear</td></tr> <tr><td style="text-align:left;">double</td> <td style="text-align:left;">previous, linear</td></tr> <tr><td style="text-align:left;">text</td> <td style="text-align:left;">previous</td></tr></tbody></table></center> <p>When the fill method is not specified, each data type bears its own default fill methods and parameters. The corresponding relationship is shown in Table 3-7.</p> <center>**Table 3-7 Default fill methods and parameters for various data types** |
| <table><thead><tr><th style="text-align:left;">Data Type</th> <th style="text-align:left;">Default Fill Methods and Parameters</th></tr></thead> <tbody><tr><td style="text-align:left;">boolean</td> <td style="text-align:left;">previous, 600000</td></tr> <tr><td style="text-align:left;">int32</td> <td style="text-align:left;">previous, 600000</td></tr> <tr><td style="text-align:left;">int64</td> <td style="text-align:left;">previous, 600000</td></tr> <tr><td style="text-align:left;">float</td> <td style="text-align:left;">previous, 600000</td></tr> <tr><td style="text-align:left;">double</td> <td style="text-align:left;">previous, 600000</td></tr> <tr><td style="text-align:left;">text</td> <td style="text-align:left;">previous, 600000</td></tr></tbody></table></center> <blockquote><p>Note: In version 0.7.0, at least one fill method should be specified in the Fill statement.</p></blockquote> <h3 id="row-and-column-control-over-query-results"><a href="#row-and-column-control-over-query-results" class="header-anchor">#</a> Row and Column Control over Query Results</h3> <p>IoTDB provides <a href="/UserGuide/Master/Operation Manual/SQL Reference.html">LIMIT/SLIMIT</a> clause and <a href="/UserGuide/Master/Operation Manual/SQL Reference.html">OFFSET/SOFFSET</a> |
| clause in order to make users have more control over query results. |
| The use of LIMIT and SLIMIT clauses allows users to control the number of rows and columns of query results, |
| and the use of OFFSET and SOFSET clauses allows users to set the starting position of the results for display.</p> <p>Note that the LIMIT and OFFSET are not supported in group by query.</p> <p>This chapter mainly introduces related examples of row and column control of query results. You can also use the <a href="/UserGuide/Master/Client/Programming - JDBC.html">Java JDBC</a> standard interface to execute queries.</p> <h4 id="row-control-over-query-results"><a href="#row-control-over-query-results" class="header-anchor">#</a> Row Control over Query Results</h4> <p>By using LIMIT and OFFSET clauses, users control the query results in a row-related manner. We demonstrate how to use LIMIT and OFFSET clauses through the following examples.</p> <ul><li>Example 1: basic LIMIT clause</li></ul> <p>The SQL statement is:</p> <div class="language- line-numbers-mode"><pre class="language-text"><code>select status, temperature from root.ln.wf01.wt01 limit 10 |
| </code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br></div></div><p>which means:</p> <p>The selected device is ln group wf01 plant wt01 device; the selected timeseries is "status" and "temperature". The SQL statement requires the first 10 rows of the query result.</p> <p>The result is shown below:</p> <div class="language- line-numbers-mode"><pre class="language-text"><code>+-----------------------------+------------------------+-----------------------------+ |
| | Time|root.ln.wf01.wt01.status|root.ln.wf01.wt01.temperature| |
| +-----------------------------+------------------------+-----------------------------+ |
| |2017-11-01T00:00:00.000+08:00| true| 25.96| |
| |2017-11-01T00:01:00.000+08:00| true| 24.36| |
| |2017-11-01T00:02:00.000+08:00| false| 20.09| |
| |2017-11-01T00:03:00.000+08:00| false| 20.18| |
| |2017-11-01T00:04:00.000+08:00| false| 21.13| |
| |2017-11-01T00:05:00.000+08:00| false| 22.72| |
| |2017-11-01T00:06:00.000+08:00| false| 20.71| |
| |2017-11-01T00:07:00.000+08:00| false| 21.45| |
| |2017-11-01T00:08:00.000+08:00| false| 22.58| |
| |2017-11-01T00:09:00.000+08:00| false| 20.98| |
| +-----------------------------+------------------------+-----------------------------+ |
| Total line number = 10 |
| It costs 0.000s |
| </code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br><span class="line-number">2</span><br><span class="line-number">3</span><br><span class="line-number">4</span><br><span class="line-number">5</span><br><span class="line-number">6</span><br><span class="line-number">7</span><br><span class="line-number">8</span><br><span class="line-number">9</span><br><span class="line-number">10</span><br><span class="line-number">11</span><br><span class="line-number">12</span><br><span class="line-number">13</span><br><span class="line-number">14</span><br><span class="line-number">15</span><br><span class="line-number">16</span><br></div></div><ul><li>Example 2: LIMIT clause with OFFSET</li></ul> <p>The SQL statement is:</p> <div class="language- line-numbers-mode"><pre class="language-text"><code>select status, temperature from root.ln.wf01.wt01 limit 5 offset 3 |
| </code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br></div></div><p>which means:</p> <p>The selected device is ln group wf01 plant wt01 device; the selected timeseries is "status" and "temperature". The SQL statement requires rows 3 to 7 of the query result be returned (with the first row numbered as row 0).</p> <p>The result is shown below:</p> <div class="language- line-numbers-mode"><pre class="language-text"><code>+-----------------------------+------------------------+-----------------------------+ |
| | Time|root.ln.wf01.wt01.status|root.ln.wf01.wt01.temperature| |
| +-----------------------------+------------------------+-----------------------------+ |
| |2017-11-01T00:03:00.000+08:00| false| 20.18| |
| |2017-11-01T00:04:00.000+08:00| false| 21.13| |
| |2017-11-01T00:05:00.000+08:00| false| 22.72| |
| |2017-11-01T00:06:00.000+08:00| false| 20.71| |
| |2017-11-01T00:07:00.000+08:00| false| 21.45| |
| +-----------------------------+------------------------+-----------------------------+ |
| Total line number = 5 |
| It costs 0.342s |
| </code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br><span class="line-number">2</span><br><span class="line-number">3</span><br><span class="line-number">4</span><br><span class="line-number">5</span><br><span class="line-number">6</span><br><span class="line-number">7</span><br><span class="line-number">8</span><br><span class="line-number">9</span><br><span class="line-number">10</span><br><span class="line-number">11</span><br></div></div><ul><li>Example 3: LIMIT clause combined with WHERE clause</li></ul> <p>The SQL statement is:</p> <div class="language- line-numbers-mode"><pre class="language-text"><code>select status,temperature from root.ln.wf01.wt01 where time > 2017-11-01T00:05:00.000 and time< 2017-11-01T00:12:00.000 limit 2 offset 3 |
| </code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br></div></div><p>which means:</p> <p>The selected device is ln group wf01 plant wt01 device; the selected timeseries is "status" and "temperature". The SQL statement requires rows 3 to 4 of the status and temperature sensor values between the time point of "2017-11-01T00:05:00.000" and "2017-11-01T00:12:00.000" (with the first row numbered as row 0).</p> <p>The result is shown below:</p> <div class="language- line-numbers-mode"><pre class="language-text"><code>+-----------------------------+------------------------+-----------------------------+ |
| | Time|root.ln.wf01.wt01.status|root.ln.wf01.wt01.temperature| |
| +-----------------------------+------------------------+-----------------------------+ |
| |2017-11-01T00:03:00.000+08:00| false| 20.18| |
| |2017-11-01T00:04:00.000+08:00| false| 21.13| |
| |2017-11-01T00:05:00.000+08:00| false| 22.72| |
| |2017-11-01T00:06:00.000+08:00| false| 20.71| |
| |2017-11-01T00:07:00.000+08:00| false| 21.45| |
| +-----------------------------+------------------------+-----------------------------+ |
| Total line number = 5 |
| It costs 0.000s |
| </code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br><span class="line-number">2</span><br><span class="line-number">3</span><br><span class="line-number">4</span><br><span class="line-number">5</span><br><span class="line-number">6</span><br><span class="line-number">7</span><br><span class="line-number">8</span><br><span class="line-number">9</span><br><span class="line-number">10</span><br><span class="line-number">11</span><br></div></div><ul><li>Example 4: LIMIT clause combined with GROUP BY clause</li></ul> <p>The SQL statement is:</p> <div class="language- line-numbers-mode"><pre class="language-text"><code>select count(status), max_value(temperature) from root.ln.wf01.wt01 group by ([2017-11-01T00:00:00, 2017-11-07T23:00:00),1d) limit 5 offset 3 |
| </code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br></div></div><p>which means:</p> <p>The SQL statement clause requires rows 3 to 7 of the query result be returned (with the first row numbered as row 0).</p> <p>The result is shown below:</p> <div class="language- line-numbers-mode"><pre class="language-text"><code>+-----------------------------+-------------------------------+----------------------------------------+ |
| | Time|count(root.ln.wf01.wt01.status)|max_value(root.ln.wf01.wt01.temperature)| |
| +-----------------------------+-------------------------------+----------------------------------------+ |
| |2017-11-04T00:00:00.000+08:00| 1440| 26.0| |
| |2017-11-05T00:00:00.000+08:00| 1440| 26.0| |
| |2017-11-06T00:00:00.000+08:00| 1440| 25.99| |
| |2017-11-07T00:00:00.000+08:00| 1380| 26.0| |
| +-----------------------------+-------------------------------+----------------------------------------+ |
| Total line number = 4 |
| It costs 0.016s |
| </code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br><span class="line-number">2</span><br><span class="line-number">3</span><br><span class="line-number">4</span><br><span class="line-number">5</span><br><span class="line-number">6</span><br><span class="line-number">7</span><br><span class="line-number">8</span><br><span class="line-number">9</span><br><span class="line-number">10</span><br></div></div><p>It is worth noting that because the current FILL clause can only fill in the missing value of timeseries at a certain time point, that is to say, the execution result of FILL clause is exactly one line, so LIMIT and OFFSET are not expected to be used in combination with FILL clause, otherwise errors will be prompted. For example, executing the following SQL statement:</p> <div class="language- line-numbers-mode"><pre class="language-text"><code>select temperature from root.sgcc.wf03.wt01 where time = 2017-11-01T16:37:50.000 fill(float[previous, 1m]) limit 10 |
| </code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br></div></div><p>The SQL statement will not be executed and the corresponding error prompt is given as follows:</p> <div class="language- line-numbers-mode"><pre class="language-text"><code>Msg: 401: line 1:107 mismatched input 'limit' expecting {<EOF>, SLIMIT, SOFFSET, GROUP, DISABLE, ALIGN} |
| </code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br></div></div><h4 id="column-control-over-query-results"><a href="#column-control-over-query-results" class="header-anchor">#</a> Column Control over Query Results</h4> <p>By using SLIMIT and SOFFSET clauses, users can control the query results in a column-related manner. We will demonstrate how to use SLIMIT and SOFFSET clauses through the following examples.</p> <ul><li>Example 1: basic SLIMIT clause</li></ul> <p>The SQL statement is:</p> <div class="language- line-numbers-mode"><pre class="language-text"><code>select * from root.ln.wf01.wt01 where time > 2017-11-01T00:05:00.000 and time < 2017-11-01T00:12:00.000 slimit 1 |
| </code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br></div></div><p>which means:</p> <p>The selected device is ln group wf01 plant wt01 device; the selected timeseries is the first column under this device, i.e., the power supply status. The SQL statement requires the status sensor values between the time point of "2017-11-01T00:05:00.000" and "2017-11-01T00:12:00.000" be selected.</p> <p>The result is shown below:</p> <div class="language- line-numbers-mode"><pre class="language-text"><code>+-----------------------------+-----------------------------+ |
| | Time|root.ln.wf01.wt01.temperature| |
| +-----------------------------+-----------------------------+ |
| |2017-11-01T00:06:00.000+08:00| 20.71| |
| |2017-11-01T00:07:00.000+08:00| 21.45| |
| |2017-11-01T00:08:00.000+08:00| 22.58| |
| |2017-11-01T00:09:00.000+08:00| 20.98| |
| |2017-11-01T00:10:00.000+08:00| 25.52| |
| |2017-11-01T00:11:00.000+08:00| 22.91| |
| +-----------------------------+-----------------------------+ |
| Total line number = 6 |
| It costs 0.000s |
| </code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br><span class="line-number">2</span><br><span class="line-number">3</span><br><span class="line-number">4</span><br><span class="line-number">5</span><br><span class="line-number">6</span><br><span class="line-number">7</span><br><span class="line-number">8</span><br><span class="line-number">9</span><br><span class="line-number">10</span><br><span class="line-number">11</span><br><span class="line-number">12</span><br></div></div><ul><li>Example 2: SLIMIT clause with SOFFSET</li></ul> <p>The SQL statement is:</p> <div class="language- line-numbers-mode"><pre class="language-text"><code>select * from root.ln.wf01.wt01 where time > 2017-11-01T00:05:00.000 and time < 2017-11-01T00:12:00.000 slimit 1 soffset 1 |
| </code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br></div></div><p>which means:</p> <p>The selected device is ln group wf01 plant wt01 device; the selected timeseries is the second column under this device, i.e., the temperature. The SQL statement requires the temperature sensor values between the time point of "2017-11-01T00:05:00.000" and "2017-11-01T00:12:00.000" be selected.</p> <p>The result is shown below:</p> <div class="language- line-numbers-mode"><pre class="language-text"><code>+-----------------------------+------------------------+ |
| | Time|root.ln.wf01.wt01.status| |
| +-----------------------------+------------------------+ |
| |2017-11-01T00:06:00.000+08:00| false| |
| |2017-11-01T00:07:00.000+08:00| false| |
| |2017-11-01T00:08:00.000+08:00| false| |
| |2017-11-01T00:09:00.000+08:00| false| |
| |2017-11-01T00:10:00.000+08:00| true| |
| |2017-11-01T00:11:00.000+08:00| false| |
| +-----------------------------+------------------------+ |
| Total line number = 6 |
| It costs 0.003s |
| </code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br><span class="line-number">2</span><br><span class="line-number">3</span><br><span class="line-number">4</span><br><span class="line-number">5</span><br><span class="line-number">6</span><br><span class="line-number">7</span><br><span class="line-number">8</span><br><span class="line-number">9</span><br><span class="line-number">10</span><br><span class="line-number">11</span><br><span class="line-number">12</span><br></div></div><ul><li>Example 3: SLIMIT clause combined with GROUP BY clause</li></ul> <p>The SQL statement is:</p> <div class="language- line-numbers-mode"><pre class="language-text"><code>select max_value(*) from root.ln.wf01.wt01 group by ([2017-11-01T00:00:00, 2017-11-07T23:00:00),1d) slimit 1 soffset 1 |
| </code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br></div></div><p>The result is shown below:</p> <div class="language- line-numbers-mode"><pre class="language-text"><code>+-----------------------------+-----------------------------------+ |
| | Time|max_value(root.ln.wf01.wt01.status)| |
| +-----------------------------+-----------------------------------+ |
| |2017-11-01T00:00:00.000+08:00| true| |
| |2017-11-02T00:00:00.000+08:00| true| |
| |2017-11-03T00:00:00.000+08:00| true| |
| |2017-11-04T00:00:00.000+08:00| true| |
| |2017-11-05T00:00:00.000+08:00| true| |
| |2017-11-06T00:00:00.000+08:00| true| |
| |2017-11-07T00:00:00.000+08:00| true| |
| +-----------------------------+-----------------------------------+ |
| Total line number = 7 |
| It costs 0.000s |
| </code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br><span class="line-number">2</span><br><span class="line-number">3</span><br><span class="line-number">4</span><br><span class="line-number">5</span><br><span class="line-number">6</span><br><span class="line-number">7</span><br><span class="line-number">8</span><br><span class="line-number">9</span><br><span class="line-number">10</span><br><span class="line-number">11</span><br><span class="line-number">12</span><br><span class="line-number">13</span><br></div></div><ul><li>Example 4: SLIMIT clause combined with FILL clause</li></ul> <p>The SQL statement is:</p> <div class="language- line-numbers-mode"><pre class="language-text"><code>select * from root.sgcc.wf03.wt01 where time = 2017-11-01T16:35:00 fill(float[previous, 1m]) slimit 1 soffset 1 |
| </code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br></div></div><p>which means:</p> <p>The selected device is ln group wf01 plant wt01 device; the selected timeseries is the second column under this device, i.e., the temperature.</p> <p>The result is shown below:</p> <div class="language- line-numbers-mode"><pre class="language-text"><code>+-----------------------------+--------------------------+ |
| | Time|root.sgcc.wf03.wt01.status| |
| +-----------------------------+--------------------------+ |
| |2017-11-01T16:35:00.000+08:00| true| |
| +-----------------------------+--------------------------+ |
| Total line number = 1 |
| It costs 0.007s |
| </code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br><span class="line-number">2</span><br><span class="line-number">3</span><br><span class="line-number">4</span><br><span class="line-number">5</span><br><span class="line-number">6</span><br><span class="line-number">7</span><br></div></div><h4 id="row-and-column-control-over-query-results-2"><a href="#row-and-column-control-over-query-results-2" class="header-anchor">#</a> Row and Column Control over Query Results</h4> <p>In addition to row or column control over query results, IoTDB allows users to control both rows and columns of query results. Here is a complete example with both LIMIT clauses and SLIMIT clauses.</p> <p>The SQL statement is:</p> <div class="language- line-numbers-mode"><pre class="language-text"><code>select * from root.ln.wf01.wt01 limit 10 offset 100 slimit 2 soffset 0 |
| </code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br></div></div><p>which means:</p> <p>The selected device is ln group wf01 plant wt01 device; the selected timeseries is columns 0 to 1 under this device (with the first column numbered as column 0). The SQL statement clause requires rows 100 to 109 of the query result be returned (with the first row numbered as row 0).</p> <p>The result is shown below:</p> <div class="language- line-numbers-mode"><pre class="language-text"><code>+-----------------------------+-----------------------------+------------------------+ |
| | Time|root.ln.wf01.wt01.temperature|root.ln.wf01.wt01.status| |
| +-----------------------------+-----------------------------+------------------------+ |
| |2017-11-01T01:40:00.000+08:00| 21.19| false| |
| |2017-11-01T01:41:00.000+08:00| 22.79| false| |
| |2017-11-01T01:42:00.000+08:00| 22.98| false| |
| |2017-11-01T01:43:00.000+08:00| 21.52| false| |
| |2017-11-01T01:44:00.000+08:00| 23.45| true| |
| |2017-11-01T01:45:00.000+08:00| 24.06| true| |
| |2017-11-01T01:46:00.000+08:00| 22.6| false| |
| |2017-11-01T01:47:00.000+08:00| 23.78| true| |
| |2017-11-01T01:48:00.000+08:00| 24.72| true| |
| |2017-11-01T01:49:00.000+08:00| 24.68| true| |
| +-----------------------------+-----------------------------+------------------------+ |
| Total line number = 10 |
| It costs 0.009s |
| </code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br><span class="line-number">2</span><br><span class="line-number">3</span><br><span class="line-number">4</span><br><span class="line-number">5</span><br><span class="line-number">6</span><br><span class="line-number">7</span><br><span class="line-number">8</span><br><span class="line-number">9</span><br><span class="line-number">10</span><br><span class="line-number">11</span><br><span class="line-number">12</span><br><span class="line-number">13</span><br><span class="line-number">14</span><br><span class="line-number">15</span><br><span class="line-number">16</span><br></div></div><h3 id="use-alias"><a href="#use-alias" class="header-anchor">#</a> Use Alias</h3> <p>Since the unique data model of IoTDB, lots of additional information like device will be carried before each sensor. Sometimes, we want to query just one specific device, then these prefix information show frequently will be redundant in this situation, influencing the analysis of result set. At this time, we can use <code>AS</code> function provided by IoTDB, assign an alias to time series selected in query.</p> <p>For example：</p> <div class="language- line-numbers-mode"><pre class="language-text"><code>select s1 as temperature, s2 as speed from root.ln.wf01.wt01; |
| </code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br></div></div><p>The result set is：</p> <table><thead><tr><th>Time</th> <th>temperature</th> <th>speed</th></tr></thead> <tbody><tr><td>...</td> <td>...</td> <td>...</td></tr></tbody></table> <h4 id="other-resultset-format"><a href="#other-resultset-format" class="header-anchor">#</a> Other ResultSet Format</h4> <p>In addition, IoTDB supports two other results set format: 'align by device' and 'disable align'.</p> <p>The 'align by device' indicates that the deviceId is considered as a column. Therefore, there are totally limited columns in the dataset.</p> <p>The SQL statement is:</p> <div class="language- line-numbers-mode"><pre class="language-text"><code>select * from root.ln.* where time <= 2017-11-01T00:01:00 align by device |
| </code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br></div></div><p>The result shows below:</p> <div class="language- line-numbers-mode"><pre class="language-text"><code>+-----------------------------+-----------------+-----------+------+--------+ |
| | Time| Device|temperature|status|hardware| |
| +-----------------------------+-----------------+-----------+------+--------+ |
| |2017-11-01T00:00:00.000+08:00|root.ln.wf01.wt01| 25.96| true| null| |
| |2017-11-01T00:01:00.000+08:00|root.ln.wf01.wt01| 24.36| true| null| |
| |1970-01-01T08:00:00.001+08:00|root.ln.wf02.wt02| null| true| v1| |
| |1970-01-01T08:00:00.002+08:00|root.ln.wf02.wt02| null| false| v2| |
| |2017-11-01T00:00:00.000+08:00|root.ln.wf02.wt02| null| true| v2| |
| |2017-11-01T00:01:00.000+08:00|root.ln.wf02.wt02| null| true| v2| |
| +-----------------------------+-----------------+-----------+------+--------+ |
| Total line number = 6 |
| It costs 0.012s |
| </code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br><span class="line-number">2</span><br><span class="line-number">3</span><br><span class="line-number">4</span><br><span class="line-number">5</span><br><span class="line-number">6</span><br><span class="line-number">7</span><br><span class="line-number">8</span><br><span class="line-number">9</span><br><span class="line-number">10</span><br><span class="line-number">11</span><br><span class="line-number">12</span><br></div></div><p>For more syntax description, please read <a href="/UserGuide/Master/Operation Manual/SQL Reference.html">SQL Reference</a>.</p> <p>The 'disable align' indicates that there are 2 columns for each time series in the result set. Disable Align Clause can only be used at the end of a query statement. Disable Align Clause cannot be used with Aggregation, Fill Statements, Group By or Group By Device Statements, but can with Limit Statements. The display principle of the result table is that only when the column (or row) has existing data will the column (or row) be shown, with nonexistent cells being empty.</p> <p>The SQL statement is:</p> <div class="language- line-numbers-mode"><pre class="language-text"><code>select * from root.ln.* where time <= 2017-11-01T00:01:00 disable align |
| </code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br></div></div><p>The result shows below:</p> <div class="language- line-numbers-mode"><pre class="language-text"><code>+-----------------------------+--------------------------+-----------------------------+------------------------+-----------------------------+-----------------------------+-----------------------------+------------------------+ |
| | Time|root.ln.wf02.wt02.hardware| Time|root.ln.wf02.wt02.status| Time|root.ln.wf01.wt01.temperature| Time|root.ln.wf01.wt01.status| |
| +-----------------------------+--------------------------+-----------------------------+------------------------+-----------------------------+-----------------------------+-----------------------------+------------------------+ |
| |1970-01-01T08:00:00.001+08:00| v1|1970-01-01T08:00:00.001+08:00| true|2017-11-01T00:00:00.000+08:00| 25.96|2017-11-01T00:00:00.000+08:00| true| |
| |1970-01-01T08:00:00.002+08:00| v2|1970-01-01T08:00:00.002+08:00| false|2017-11-01T00:01:00.000+08:00| 24.36|2017-11-01T00:01:00.000+08:00| true| |
| |2017-11-01T00:00:00.000+08:00| v2|2017-11-01T00:00:00.000+08:00| true| null| null| null| null| |
| |2017-11-01T00:01:00.000+08:00| v2|2017-11-01T00:01:00.000+08:00| true| null| null| null| null| |
| +-----------------------------+--------------------------+-----------------------------+------------------------+-----------------------------+-----------------------------+-----------------------------+------------------------+ |
| Total line number = 4 |
| It costs 0.018s |
| </code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br><span class="line-number">2</span><br><span class="line-number">3</span><br><span class="line-number">4</span><br><span class="line-number">5</span><br><span class="line-number">6</span><br><span class="line-number">7</span><br><span class="line-number">8</span><br><span class="line-number">9</span><br><span class="line-number">10</span><br></div></div><p>For more syntax description, please read <a href="/UserGuide/Master/Operation Manual/SQL Reference.html">SQL Reference</a>.</p> <h4 id="error-handling"><a href="#error-handling" class="header-anchor">#</a> Error Handling</h4> <p>If the parameter N/SN of LIMIT/SLIMIT exceeds the size of the result set, IoTDB returns all the results as expected. For example, the query result of the original SQL statement consists of six rows, and we select the first 100 rows through the LIMIT clause:</p> <div class="language- line-numbers-mode"><pre class="language-text"><code>select status,temperature from root.ln.wf01.wt01 where time > 2017-11-01T00:05:00.000 and time < 2017-11-01T00:12:00.000 limit 100 |
| </code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br></div></div><p>The result is shown below:</p> <div class="language- line-numbers-mode"><pre class="language-text"><code>+-----------------------------+------------------------+-----------------------------+ |
| | Time|root.ln.wf01.wt01.status|root.ln.wf01.wt01.temperature| |
| +-----------------------------+------------------------+-----------------------------+ |
| |2017-11-01T00:06:00.000+08:00| false| 20.71| |
| |2017-11-01T00:07:00.000+08:00| false| 21.45| |
| |2017-11-01T00:08:00.000+08:00| false| 22.58| |
| |2017-11-01T00:09:00.000+08:00| false| 20.98| |
| |2017-11-01T00:10:00.000+08:00| true| 25.52| |
| |2017-11-01T00:11:00.000+08:00| false| 22.91| |
| +-----------------------------+------------------------+-----------------------------+ |
| Total line number = 6 |
| It costs 0.005s |
| </code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br><span class="line-number">2</span><br><span class="line-number">3</span><br><span class="line-number">4</span><br><span class="line-number">5</span><br><span class="line-number">6</span><br><span class="line-number">7</span><br><span class="line-number">8</span><br><span class="line-number">9</span><br><span class="line-number">10</span><br><span class="line-number">11</span><br><span class="line-number">12</span><br></div></div><p>If the parameter N/SN of LIMIT/SLIMIT clause exceeds the allowable maximum value (N/SN is of type int32), the system prompts errors. For example, executing the following SQL statement:</p> <div class="language- line-numbers-mode"><pre class="language-text"><code>select status,temperature from root.ln.wf01.wt01 where time > 2017-11-01T00:05:00.000 and time < 2017-11-01T00:12:00.000 limit 1234567890123456789 |
| </code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br></div></div><p>The SQL statement will not be executed and the corresponding error prompt is given as follows:</p> <div class="language- line-numbers-mode"><pre class="language-text"><code>Msg: 303: check metadata error: Out of range. LIMIT <N>: N should be Int32. |
| </code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br></div></div><p>If the parameter N/SN of LIMIT/SLIMIT clause is not a positive intege, the system prompts errors. For example, executing the following SQL statement:</p> <div class="language- line-numbers-mode"><pre class="language-text"><code>select status,temperature from root.ln.wf01.wt01 where time > 2017-11-01T00:05:00.000 and time < 2017-11-01T00:12:00.000 limit 13.1 |
| </code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br></div></div><p>The SQL statement will not be executed and the corresponding error prompt is given as follows:</p> <div class="language- line-numbers-mode"><pre class="language-text"><code>Msg: 401: line 1:129 mismatched input '.' expecting {<EOF>, SLIMIT, OFFSET, SOFFSET, GROUP, DISABLE, ALIGN} |
| </code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br></div></div><p>If the parameter OFFSET of LIMIT clause exceeds the size of the result set, IoTDB will return an empty result set. For example, executing the following SQL statement:</p> <div class="language- line-numbers-mode"><pre class="language-text"><code>select status,temperature from root.ln.wf01.wt01 where time > 2017-11-01T00:05:00.000 and time < 2017-11-01T00:12:00.000 limit 2 offset 6 |
| </code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br></div></div><p>The result is shown below:</p> <div class="language- line-numbers-mode"><pre class="language-text"><code>+----+------------------------+-----------------------------+ |
| |Time|root.ln.wf01.wt01.status|root.ln.wf01.wt01.temperature| |
| +----+------------------------+-----------------------------+ |
| +----+------------------------+-----------------------------+ |
| Empty set. |
| It costs 0.005s |
| </code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br><span class="line-number">2</span><br><span class="line-number">3</span><br><span class="line-number">4</span><br><span class="line-number">5</span><br><span class="line-number">6</span><br></div></div><p>If the parameter SOFFSET of SLIMIT clause is not smaller than the number of available timeseries, the system prompts errors. For example, executing the following SQL statement:</p> <div class="language- line-numbers-mode"><pre class="language-text"><code>select * from root.ln.wf01.wt01 where time > 2017-11-01T00:05:00.000 and time < 2017-11-01T00:12:00.000 slimit 1 soffset 2 |
| </code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br></div></div><p>The SQL statement will not be executed and the corresponding error prompt is given as follows:</p> <div class="language- line-numbers-mode"><pre class="language-text"><code>Msg: 411: Meet error in query process: The value of SOFFSET (2) is equal to or exceeds the number of sequences (2) that can actually be returned. |
| </code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br></div></div><h2 id="delete"><a href="#delete" class="header-anchor">#</a> DELETE</h2> <p>Users can delete data that meet the deletion condition in the specified timeseries by using the <a href="/UserGuide/Master/Operation Manual/SQL Reference.html">DELETE statement</a>. When deleting data, users can select one or more timeseries paths, prefix paths, or paths with star to delete data within a certain time interval.</p> <p>In a JAVA programming environment, you can use the <a href="/UserGuide/Master/Client/Programming - JDBC.html">Java JDBC</a> to execute single or batch UPDATE statements.</p> <h3 id="delete-single-timeseries"><a href="#delete-single-timeseries" class="header-anchor">#</a> Delete Single Timeseries</h3> <p>Taking ln Group as an example, there exists such a usage scenario:</p> <p>The wf02 plant's wt02 device has many segments of errors in its power supply status before 2017-11-01 16:26:00, and the data cannot be analyzed correctly. The erroneous data affected the correlation analysis with other devices. At this point, the data before this time point needs to be deleted. The SQL statement for this operation is</p> <div class="language- line-numbers-mode"><pre class="language-text"><code>delete from root.ln.wf02.wt02.status where time<=2017-11-01T16:26:00; |
| </code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br></div></div><p>In case we hope to merely delete the data before 2017-11-01 16:26:00 in the year of 2017, The SQL statement is:</p> <div class="language- line-numbers-mode"><pre class="language-text"><code>delete from root.ln.wf02.wt02.status where time>=2017-01-01T00:00:00 and time<=2017-11-01T16:26:00; |
| </code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br></div></div><p>IoTDB supports to delete a range of timeseries points. Users can write SQL expressions as follows to specify the delete interval:</p> <div class="language- line-numbers-mode"><pre class="language-text"><code>delete from root.ln.wf02.wt02.status where time < 10 |
| delete from root.ln.wf02.wt02.status where time <= 10 |
| delete from root.ln.wf02.wt02.status where time < 20 and time > 10 |
| delete from root.ln.wf02.wt02.status where time <= 20 and time >= 10 |
| delete from root.ln.wf02.wt02.status where time > 20 |
| delete from root.ln.wf02.wt02.status where time >= 20 |
| delete from root.ln.wf02.wt02.status where time = 20 |
| </code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br><span class="line-number">2</span><br><span class="line-number">3</span><br><span class="line-number">4</span><br><span class="line-number">5</span><br><span class="line-number">6</span><br><span class="line-number">7</span><br></div></div><p>Please pay attention that multiple intervals connected by "OR" expression are not supported in delete statement:</p> <div class="language- line-numbers-mode"><pre class="language-text"><code>delete from root.ln.wf02.wt02.status where time > 4 or time < 0 |
| Msg: 303: Check metadata error: For delete statement, where clause can only contain atomic |
| expressions like : time > XXX, time <= XXX, or two atomic expressions connected by 'AND' |
| </code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br><span class="line-number">2</span><br><span class="line-number">3</span><br></div></div><p>If no "where" clause specified in a delete statement, all the data in a timeseries will be deleted.</p> <div class="language- line-numbers-mode"><pre class="language-text"><code>delete from root.ln.wf02.status |
| </code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br></div></div><h3 id="delete-multiple-timeseries"><a href="#delete-multiple-timeseries" class="header-anchor">#</a> Delete Multiple Timeseries</h3> <p>If both the power supply status and hardware version of the ln group wf02 plant wt02 device before 2017-11-01 16:26:00 need to be deleted, <a href="/UserGuide/Master/Concept/Data Model and Terminology.html">the prefix path with broader meaning or the path with star</a> can be used to delete the data. The SQL statement for this operation is:</p> <div class="language- line-numbers-mode"><pre class="language-text"><code>delete from root.ln.wf02.wt02 where time <= 2017-11-01T16:26:00; |
| </code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br></div></div><p>or</p> <div class="language- line-numbers-mode"><pre class="language-text"><code>delete from root.ln.wf02.wt02.* where time <= 2017-11-01T16:26:00; |
| </code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br></div></div><p>It should be noted that when the deleted path does not exist, IoTDB will give the corresponding error prompt as shown below:</p> <div class="language- line-numbers-mode"><pre class="language-text"><code>IoTDB> delete from root.ln.wf03.wt02.status where time < now() |
| Msg: TimeSeries does not exist and its data cannot be deleted |
| </code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br><span class="line-number">2</span><br></div></div><h2 id="delete-time-partition-experimental"><a href="#delete-time-partition-experimental" class="header-anchor">#</a> Delete Time Partition (experimental)</h2> <p>You may delete all data in a time partition of a storage group using the following grammar:</p> <div class="language- line-numbers-mode"><pre class="language-text"><code>DELETE PARTITION root.ln 0,1,2 |
| </code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br></div></div><p>The <code>0,1,2</code> above is the id of the partition that is to be deleted, you can find it from the IoTDB |
| data folders or convert a timestamp manually to an id using <code>timestamp / partitionInterval</code> (flooring), and the <code>partitionInterval</code> should be in your config (if time-partitioning is |
| supported in your version).</p> <p>Please notice that this function is experimental and mainly for development, please use it with care.</p></div> <div class="page-nav"><p class="inner"><span class="prev"> |
| ← |
| <a href="/UserGuide/Master/Operation Manual/DDL Data Definition Language.html" class="prev"> |
| DDL (Data Definition Language) |
| </a></span> <span class="next"><a href="/UserGuide/Master/Operation Manual/Administration.html"> |
| Administration |
| </a> |
| → |
| </span></p></div> <p style="text-align: center;">Copyright © 2020 The Apache Software Foundation.<br> |
| Apache and the Apache feather logo are trademarks of The Apache Software Foundation</p> <p style="text-align: center; margin-top: 10px; color: #444"> |
| Contact us: Join QQ Group 659990460 | Add friend <i>tietouqiao</i> and be invited to Wechat Group<br> |
| see <a href="https://github.com/apache/iotdb/issues/1995">Join the community</a> for more</p></main></div><div class="global-ui"></div></div> |
| <script src="/assets/js/app.ee472f44.js" defer></script><script src="/assets/js/3.49f0f20a.js" defer></script><script src="/assets/js/83.e5773686.js" defer></script> |
| </body> |
| </html> |
