| <!doctype html> |
| <html lang="zh-CN" data-theme="light"> |
| <head> |
| <meta charset="utf-8" /> |
| <meta name="viewport" content="width=device-width,initial-scale=1" /> |
| <meta name="generator" content="VuePress 2.0.0-rc.9" /> |
| <meta name="theme" content="VuePress Theme Hope 2.0.0-rc.34" /> |
| <style> |
| html { |
| background: var(--bg-color, #fff); |
| } |
| |
| html[data-theme="dark"] { |
| background: var(--bg-color, #1d1e1f); |
| } |
| |
| body { |
| background: var(--bg-color); |
| } |
| </style> |
| <script> |
| const userMode = localStorage.getItem("vuepress-theme-hope-scheme"); |
| const systemDarkMode = |
| window.matchMedia && |
| window.matchMedia("(prefers-color-scheme: dark)").matches; |
| |
| if (userMode === "dark" || (userMode !== "light" && systemDarkMode)) { |
| document.documentElement.setAttribute("data-theme", "dark"); |
| } |
| </script> |
| <link rel="alternate" hreflang="en-us" href="https://iotdb.apache.org/UserGuide/V1.0.x/Operators-Functions/Data-Profiling.html"><meta property="og:url" content="https://iotdb.apache.org/zh/UserGuide/V1.0.x/Operators-Functions/Data-Profiling.html"><meta property="og:site_name" content="IoTDB Website"><meta property="og:title" content="数据画像"><meta property="og:description" content="数据画像 ACF 函数简介 本函数用于计算时间序列的自相关函数值,即序列与自身之间的互相关函数,详情参见函数文档。 函数名: ACF 输入序列: 仅支持单个输入序列,类型为 INT32 / INT64 / FLOAT / DOUBLE。 输出序列: 输出单个序列,类型为 DOUBLE。序列中共包含$2N-1$个数据点,每个值的具体含义参见函数文档。 提..."><meta property="og:type" content="article"><meta property="og:locale" content="zh-CN"><meta property="og:locale:alternate" content="en-US"><meta property="og:updated_time" content="2023-07-10T03:11:17.000Z"><meta property="article:modified_time" content="2023-07-10T03:11:17.000Z"><script type="application/ld+json">{"@context":"https://schema.org","@type":"Article","headline":"数据画像","image":[""],"dateModified":"2023-07-10T03:11:17.000Z","author":[]}</script><link rel="icon" href="/favicon.ico"><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"><script type="text/javascript"> |
| var _paq = window._paq = window._paq || []; |
| /* tracker methods like "setCustomDimension" should be called before "trackPageView" */ |
| _paq.push(["setDoNotTrack", true]); |
| _paq.push(["disableCookies"]); |
| _paq.push(['trackPageView']); |
| _paq.push(['enableLinkTracking']); |
| (function() { |
| var u="https://analytics.apache.org/"; |
| _paq.push(['setTrackerUrl', u+'matomo.php']); |
| _paq.push(['setSiteId', '56']); |
| var d=document, g=d.createElement('script'), s=d.getElementsByTagName('script')[0]; |
| g.async=true; g.src=u+'matomo.js'; s.parentNode.insertBefore(g,s); |
| })(); |
| </script><title>数据画像 | IoTDB Website</title><meta name="description" content="数据画像 ACF 函数简介 本函数用于计算时间序列的自相关函数值,即序列与自身之间的互相关函数,详情参见函数文档。 函数名: ACF 输入序列: 仅支持单个输入序列,类型为 INT32 / INT64 / FLOAT / DOUBLE。 输出序列: 输出单个序列,类型为 DOUBLE。序列中共包含$2N-1$个数据点,每个值的具体含义参见函数文档。 提..."> |
| <link rel="preload" href="/assets/style-DnEHAOmf.css" as="style"><link rel="stylesheet" href="/assets/style-DnEHAOmf.css"> |
| <link rel="modulepreload" href="/assets/app-DrPcRZG6.js"><link rel="modulepreload" href="/assets/Data-Profiling.html-DTiXErKm.js"> |
| |
| </head> |
| <body> |
| <div id="app"><!--[--><!--[--><!--[--><span tabindex="-1"></span><a href="#main-content" class="vp-skip-link sr-only">跳至主要內容</a><!--]--><!--[--><div class="theme-container has-toc"><!--[--><header id="navbar" class="vp-navbar hide-icon"><div class="vp-navbar-start"><button type="button" class="vp-toggle-sidebar-button" title="Toggle Sidebar"><span class="icon"></span></button><!--[--><!----><!--]--><!--[--><a class="route-link vp-brand" href="/zh/"><img class="vp-nav-logo" src="/logo.png" alt><!----><span class="vp-site-name hide-in-pad">IoTDB Website</span></a><!--]--><!--[--><!----><!--]--></div><div class="vp-navbar-center"><!--[--><!----><!--]--><!--[--><!--]--><!--[--><!----><!--]--></div><div class="vp-navbar-end"><!--[--><!----><!--]--><!--[--><!--[--><div id="docsearch-container" style="display:none;"></div><div><button type="button" class="DocSearch DocSearch-Button" aria-label="搜索文档"><span class="DocSearch-Button-Container"><svg width="20" height="20" class="DocSearch-Search-Icon" viewBox="0 0 20 20"><path d="M14.386 14.386l4.0877 4.0877-4.0877-4.0877c-2.9418 2.9419-7.7115 2.9419-10.6533 0-2.9419-2.9418-2.9419-7.7115 0-10.6533 2.9418-2.9419 7.7115-2.9419 10.6533 0 2.9419 2.9418 2.9419 7.7115 0 10.6533z" stroke="currentColor" fill="none" fill-rule="evenodd" stroke-linecap="round" stroke-linejoin="round"></path></svg><span class="DocSearch-Button-Placeholder">搜索文档</span></span><span class="DocSearch-Button-Keys"><kbd class="DocSearch-Button-Key"><svg width="15" height="15" class="DocSearch-Control-Key-Icon"><path d="M4.505 4.496h2M5.505 5.496v5M8.216 4.496l.055 5.993M10 7.5c.333.333.5.667.5 1v2M12.326 4.5v5.996M8.384 4.496c1.674 0 2.116 0 2.116 1.5s-.442 1.5-2.116 1.5M3.205 9.303c-.09.448-.277 1.21-1.241 1.203C1 10.5.5 9.513.5 8V7c0-1.57.5-2.5 1.464-2.494.964.006 1.134.598 1.24 1.342M12.553 10.5h1.953" stroke-width="1.2" stroke="currentColor" fill="none" stroke-linecap="square"></path></svg></kbd><kbd class="DocSearch-Button-Key">K</kbd></span></button></div><!--]--><nav class="vp-nav-links"><div class="vp-nav-item hide-in-mobile"><div class="dropdown-wrapper"><button type="button" class="dropdown-title" aria-label="文档"><span class="title"><!---->文档</span><span class="arrow"></span><ul class="nav-dropdown"><li class="dropdown-item"><a class="route-link nav-link" href="/zh/UserGuide/latest/QuickStart/QuickStart.html" aria-label="v1.3.x"><!---->v1.3.x<!----></a></li><li class="dropdown-item"><a class="route-link nav-link" href="/zh/UserGuide/V1.2.x/QuickStart/QuickStart.html" aria-label="v1.2.x"><!---->v1.2.x<!----></a></li><li class="dropdown-item"><a class="route-link nav-link" href="/zh/UserGuide/V1.1.x/QuickStart/QuickStart.html" aria-label="v1.1.x"><!---->v1.1.x<!----></a></li><li class="dropdown-item"><a class="route-link nav-link" href="/zh/UserGuide/V1.0.x/QuickStart/QuickStart.html" aria-label="v1.0.x"><!---->v1.0.x<!----></a></li><li class="dropdown-item"><a class="route-link nav-link" href="/zh/UserGuide/V0.13.x/QuickStart/QuickStart.html" aria-label="v0.13.x"><!---->v0.13.x<!----></a></li></ul></button></div></div><div class="vp-nav-item hide-in-mobile"><a href="https://cwiki.apache.org/confluence/pages/viewpage.action?pageId=177051872" rel="noopener noreferrer" target="_blank" aria-label="系统设计" class="nav-link"><!---->系统设计<span><svg class="external-link-icon" 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"><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="external-link-icon-sr-only">open in new window</span></span><!----></a></div><div class="vp-nav-item hide-in-mobile"><a class="route-link nav-link" href="/zh/Download/" aria-label="下载"><!---->下载<!----></a></div><div class="vp-nav-item hide-in-mobile"><div class="dropdown-wrapper"><button type="button" class="dropdown-title" aria-label="社区"><span class="title"><!---->社区</span><span class="arrow"></span><ul class="nav-dropdown"><li class="dropdown-item"><a class="route-link nav-link" href="/zh/Community/About.html" aria-label="关于社区"><!---->关于社区<!----></a></li><li class="dropdown-item"><a class="route-link nav-link" href="/zh/Community/Development-Guide.html" aria-label="贡献指南"><!---->贡献指南<!----></a></li><li class="dropdown-item"><a class="route-link nav-link" href="/zh/Community/Powered-By.html" aria-label="社区伙伴"><!---->社区伙伴<!----></a></li><li class="dropdown-item"><a class="route-link nav-link" href="/zh/Community/Feedback.html" aria-label="交流与反馈"><!---->交流与反馈<!----></a></li><li class="dropdown-item"><a class="route-link nav-link" href="/zh/Community/Materials.html" aria-label="活动与报告"><!---->活动与报告<!----></a></li><li class="dropdown-item"><a class="route-link nav-link" href="/zh/Community/Community-Project-Committers.html" aria-label="Commiters"><!---->Commiters<!----></a></li></ul></button></div></div><div class="vp-nav-item hide-in-mobile"><div class="dropdown-wrapper"><button type="button" class="dropdown-title" aria-label="ASF"><span class="title"><!---->ASF</span><span class="arrow"></span><ul class="nav-dropdown"><li class="dropdown-item"><a href="https://www.apache.org/" rel="noopener noreferrer" target="_blank" aria-label="基金会" class="nav-link"><!---->基金会<span><svg class="external-link-icon" 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"><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="external-link-icon-sr-only">open in new window</span></span><!----></a></li><li class="dropdown-item"><a href="https://www.apache.org/licenses/" rel="noopener noreferrer" target="_blank" aria-label="许可证" class="nav-link"><!---->许可证<span><svg class="external-link-icon" 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"><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="external-link-icon-sr-only">open in new window</span></span><!----></a></li><li class="dropdown-item"><a href="https://www.apache.org/security/" rel="noopener noreferrer" target="_blank" aria-label="安全" class="nav-link"><!---->安全<span><svg class="external-link-icon" 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"><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="external-link-icon-sr-only">open in new window</span></span><!----></a></li><li class="dropdown-item"><a href="https://www.apache.org/foundation/sponsorship.html" rel="noopener noreferrer" target="_blank" aria-label="赞助" class="nav-link"><!---->赞助<span><svg class="external-link-icon" 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"><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="external-link-icon-sr-only">open in new window</span></span><!----></a></li><li class="dropdown-item"><a href="https://www.apache.org/foundation/thanks.html" rel="noopener noreferrer" target="_blank" aria-label="致谢" class="nav-link"><!---->致谢<span><svg class="external-link-icon" 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"><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="external-link-icon-sr-only">open in new window</span></span><!----></a></li><li class="dropdown-item"><a href="https://www.apache.org/events/current-event" rel="noopener noreferrer" target="_blank" aria-label="活动" class="nav-link"><!---->活动<span><svg class="external-link-icon" 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"><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="external-link-icon-sr-only">open in new window</span></span><!----></a></li><li class="dropdown-item"><a href="https://privacy.apache.org/policies/privacy-policy-public.html" rel="noopener noreferrer" target="_blank" aria-label="隐私" class="nav-link"><!---->隐私<span><svg class="external-link-icon" 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"><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="external-link-icon-sr-only">open in new window</span></span><!----></a></li></ul></button></div></div></nav><div class="vp-nav-item"><div class="dropdown-wrapper"><button type="button" class="dropdown-title" aria-label="选择语言"><!--[--><svg xmlns="http://www.w3.org/2000/svg" class="icon i18n-icon" viewBox="0 0 1024 1024" fill="currentColor" aria-label="i18n icon" style="width:1rem;height:1rem;vertical-align:middle;"><path d="M379.392 460.8 494.08 575.488l-42.496 102.4L307.2 532.48 138.24 701.44l-71.68-72.704L234.496 460.8l-45.056-45.056c-27.136-27.136-51.2-66.56-66.56-108.544h112.64c7.68 14.336 16.896 27.136 26.112 35.84l45.568 46.08 45.056-45.056C382.976 312.32 409.6 247.808 409.6 204.8H0V102.4h256V0h102.4v102.4h256v102.4H512c0 70.144-37.888 161.28-87.04 210.944L378.88 460.8zM576 870.4 512 1024H409.6l256-614.4H768l256 614.4H921.6l-64-153.6H576zM618.496 768h196.608L716.8 532.48 618.496 768z"></path></svg><!--]--><span class="arrow"></span><ul class="nav-dropdown"><li class="dropdown-item"><a class="route-link nav-link" href="/UserGuide/V1.0.x/Operators-Functions/Data-Profiling.html" aria-label="English"><!---->English<!----></a></li><li class="dropdown-item"><a class="route-link nav-link active" href="/zh/UserGuide/V1.0.x/Operators-Functions/Data-Profiling.html" aria-label="简体中文"><!---->简体中文<!----></a></li></ul></button></div></div><div class="vp-nav-item hide-in-mobile"><button type="button" id="appearance-switch"><svg xmlns="http://www.w3.org/2000/svg" class="icon auto-icon" viewBox="0 0 1024 1024" fill="currentColor" aria-label="auto icon" style="display:none;"><path d="M512 992C246.92 992 32 777.08 32 512S246.92 32 512 32s480 214.92 480 480-214.92 480-480 480zm0-840c-198.78 0-360 161.22-360 360 0 198.84 161.22 360 360 360s360-161.16 360-360c0-198.78-161.22-360-360-360zm0 660V212c165.72 0 300 134.34 300 300 0 165.72-134.28 300-300 300z"></path></svg><svg xmlns="http://www.w3.org/2000/svg" class="icon dark-icon" viewBox="0 0 1024 1024" fill="currentColor" aria-label="dark icon" style="display:none;"><path d="M524.8 938.667h-4.267a439.893 439.893 0 0 1-313.173-134.4 446.293 446.293 0 0 1-11.093-597.334A432.213 432.213 0 0 1 366.933 90.027a42.667 42.667 0 0 1 45.227 9.386 42.667 42.667 0 0 1 10.24 42.667 358.4 358.4 0 0 0 82.773 375.893 361.387 361.387 0 0 0 376.747 82.774 42.667 42.667 0 0 1 54.187 55.04 433.493 433.493 0 0 1-99.84 154.88 438.613 438.613 0 0 1-311.467 128z"></path></svg><svg xmlns="http://www.w3.org/2000/svg" class="icon light-icon" viewBox="0 0 1024 1024" fill="currentColor" aria-label="light icon" style="display:block;"><path d="M952 552h-80a40 40 0 0 1 0-80h80a40 40 0 0 1 0 80zM801.88 280.08a41 41 0 0 1-57.96-57.96l57.96-58a41.04 41.04 0 0 1 58 58l-58 57.96zM512 752a240 240 0 1 1 0-480 240 240 0 0 1 0 480zm0-560a40 40 0 0 1-40-40V72a40 40 0 0 1 80 0v80a40 40 0 0 1-40 40zm-289.88 88.08-58-57.96a41.04 41.04 0 0 1 58-58l57.96 58a41 41 0 0 1-57.96 57.96zM192 512a40 40 0 0 1-40 40H72a40 40 0 0 1 0-80h80a40 40 0 0 1 40 40zm30.12 231.92a41 41 0 0 1 57.96 57.96l-57.96 58a41.04 41.04 0 0 1-58-58l58-57.96zM512 832a40 40 0 0 1 40 40v80a40 40 0 0 1-80 0v-80a40 40 0 0 1 40-40zm289.88-88.08 58 57.96a41.04 41.04 0 0 1-58 58l-57.96-58a41 41 0 0 1 57.96-57.96z"></path></svg></button></div><div class="vp-nav-item vp-action"><a class="vp-action-link" href="https://github.com/apache/iotdb" target="_blank" rel="noopener noreferrer" aria-label="GitHub"><svg xmlns="http://www.w3.org/2000/svg" class="icon github-icon" viewBox="0 0 1024 1024" fill="currentColor" aria-label="github icon" style="width:1.25rem;height:1.25rem;vertical-align:middle;"><path d="M511.957 21.333C241.024 21.333 21.333 240.981 21.333 512c0 216.832 140.544 400.725 335.574 465.664 24.49 4.395 32.256-10.07 32.256-23.083 0-11.69.256-44.245 0-85.205-136.448 29.61-164.736-64.64-164.736-64.64-22.315-56.704-54.4-71.765-54.4-71.765-44.587-30.464 3.285-29.824 3.285-29.824 49.195 3.413 75.179 50.517 75.179 50.517 43.776 75.008 114.816 53.333 142.762 40.79 4.523-31.66 17.152-53.377 31.19-65.537-108.971-12.458-223.488-54.485-223.488-242.602 0-53.547 19.114-97.323 50.517-131.67-5.035-12.33-21.93-62.293 4.779-129.834 0 0 41.258-13.184 134.912 50.346a469.803 469.803 0 0 1 122.88-16.554c41.642.213 83.626 5.632 122.88 16.554 93.653-63.488 134.784-50.346 134.784-50.346 26.752 67.541 9.898 117.504 4.864 129.834 31.402 34.347 50.474 78.123 50.474 131.67 0 188.586-114.73 230.016-224.042 242.09 17.578 15.232 33.578 44.672 33.578 90.454v135.85c0 13.142 7.936 27.606 32.854 22.87C862.25 912.597 1002.667 728.747 1002.667 512c0-271.019-219.648-490.667-490.71-490.667z"></path></svg></a></div><!--]--><!--[--><!----><!--]--><button type="button" class="vp-toggle-navbar-button" aria-label="Toggle Navbar" aria-expanded="false" aria-controls="nav-screen"><span><span class="vp-top"></span><span class="vp-middle"></span><span class="vp-bottom"></span></span></button></div></header><!----><!--]--><!----><div class="toggle-sidebar-wrapper"><span class="arrow start"></span></div><aside id="sidebar" class="vp-sidebar"><!--[--><!----><!--]--><ul class="vp-sidebar-links"><li><section class="vp-sidebar-group"><p class="vp-sidebar-header"><!----><span class="vp-sidebar-title">IoTDB用户手册 (V1.0.x)</span><!----></p><ul class="vp-sidebar-links"></ul></section></li><li><section class="vp-sidebar-group"><button class="vp-sidebar-header clickable" type="button"><!----><span class="vp-sidebar-title">关于IoTDB</span><span class="vp-arrow end"></span></button><!----></section></li><li><section class="vp-sidebar-group"><button class="vp-sidebar-header clickable" type="button"><!----><span class="vp-sidebar-title">快速上手</span><span class="vp-arrow end"></span></button><!----></section></li><li><section class="vp-sidebar-group"><button class="vp-sidebar-header clickable" type="button"><!----><span class="vp-sidebar-title">数据模式与概念</span><span class="vp-arrow end"></span></button><!----></section></li><li><section class="vp-sidebar-group"><button class="vp-sidebar-header clickable" type="button"><!----><span class="vp-sidebar-title">语法约定</span><span class="vp-arrow end"></span></button><!----></section></li><li><section class="vp-sidebar-group"><button class="vp-sidebar-header clickable" type="button"><!----><span class="vp-sidebar-title">应用编程接口</span><span class="vp-arrow end"></span></button><!----></section></li><li><section class="vp-sidebar-group"><button class="vp-sidebar-header clickable" type="button"><!----><span class="vp-sidebar-title">元数据操作</span><span class="vp-arrow end"></span></button><!----></section></li><li><section class="vp-sidebar-group"><button class="vp-sidebar-header clickable" type="button"><!----><span class="vp-sidebar-title">数据写入(数据更新)</span><span class="vp-arrow end"></span></button><!----></section></li><li><section class="vp-sidebar-group"><button class="vp-sidebar-header clickable" type="button"><!----><span class="vp-sidebar-title">数据删除</span><span class="vp-arrow end"></span></button><!----></section></li><li><section class="vp-sidebar-group"><button class="vp-sidebar-header clickable" type="button"><!----><span class="vp-sidebar-title">数据查询</span><span class="vp-arrow end"></span></button><!----></section></li><li><section class="vp-sidebar-group"><button class="vp-sidebar-header clickable active" type="button"><!----><span class="vp-sidebar-title">运算符和函数</span><span class="vp-arrow down"></span></button><ul class="vp-sidebar-links"><li><a class="route-link nav-link vp-sidebar-link vp-sidebar-page" href="/zh/UserGuide/V1.0.x/Operators-Functions/Overview.html" aria-label="概述"><!---->概述<!----></a></li><li><a class="route-link nav-link vp-sidebar-link vp-sidebar-page" href="/zh/UserGuide/V1.0.x/Operators-Functions/User-Defined-Function.html" aria-label="用户自定义函数"><!---->用户自定义函数<!----></a></li><li><a class="route-link nav-link vp-sidebar-link vp-sidebar-page" href="/zh/UserGuide/V1.0.x/Operators-Functions/Aggregation.html" aria-label="聚合函数"><!---->聚合函数<!----></a></li><li><a class="route-link nav-link vp-sidebar-link vp-sidebar-page" href="/zh/UserGuide/V1.0.x/Operators-Functions/Mathematical.html" aria-label="算数运算符和函数"><!---->算数运算符和函数<!----></a></li><li><a class="route-link nav-link vp-sidebar-link vp-sidebar-page" href="/zh/UserGuide/V1.0.x/Operators-Functions/Comparison.html" aria-label="比较运算符和函数"><!---->比较运算符和函数<!----></a></li><li><a class="route-link nav-link vp-sidebar-link vp-sidebar-page" href="/zh/UserGuide/V1.0.x/Operators-Functions/Logical.html" aria-label="逻辑运算符"><!---->逻辑运算符<!----></a></li><li><a class="route-link nav-link vp-sidebar-link vp-sidebar-page" href="/zh/UserGuide/V1.0.x/Operators-Functions/String.html" aria-label="字符串处理"><!---->字符串处理<!----></a></li><li><a class="route-link nav-link vp-sidebar-link vp-sidebar-page" href="/zh/UserGuide/V1.0.x/Operators-Functions/Conversion.html" aria-label="数据类型转换"><!---->数据类型转换<!----></a></li><li><a class="route-link nav-link vp-sidebar-link vp-sidebar-page" href="/zh/UserGuide/V1.0.x/Operators-Functions/Constant.html" aria-label="常序列生成"><!---->常序列生成<!----></a></li><li><a class="route-link nav-link vp-sidebar-link vp-sidebar-page" href="/zh/UserGuide/V1.0.x/Operators-Functions/Selection.html" aria-label="选择函数"><!---->选择函数<!----></a></li><li><a class="route-link nav-link vp-sidebar-link vp-sidebar-page" href="/zh/UserGuide/V1.0.x/Operators-Functions/Continuous-Interval.html" aria-label="区间查询"><!---->区间查询<!----></a></li><li><a class="route-link nav-link vp-sidebar-link vp-sidebar-page" href="/zh/UserGuide/V1.0.x/Operators-Functions/Variation-Trend.html" aria-label="趋势计算"><!---->趋势计算<!----></a></li><li><a class="route-link nav-link vp-sidebar-link vp-sidebar-page" href="/zh/UserGuide/V1.0.x/Operators-Functions/Sample.html" aria-label="采样函数"><!---->采样函数<!----></a></li><li><a class="route-link nav-link vp-sidebar-link vp-sidebar-page" href="/zh/UserGuide/V1.0.x/Operators-Functions/Time-Series.html" aria-label="时间序列处理"><!---->时间序列处理<!----></a></li><li><a class="route-link nav-link vp-sidebar-link vp-sidebar-page" href="/zh/UserGuide/V1.0.x/Operators-Functions/Lambda.html" aria-label="Lambda 表达式"><!---->Lambda 表达式<!----></a></li><li><a class="route-link nav-link active vp-sidebar-link vp-sidebar-page active" href="/zh/UserGuide/V1.0.x/Operators-Functions/Data-Profiling.html" aria-label="数据画像"><!---->数据画像<!----></a></li><li><a class="route-link nav-link vp-sidebar-link vp-sidebar-page" href="/zh/UserGuide/V1.0.x/Operators-Functions/Anomaly-Detection.html" aria-label="异常检测"><!---->异常检测<!----></a></li><li><a class="route-link nav-link vp-sidebar-link vp-sidebar-page" href="/zh/UserGuide/V1.0.x/Operators-Functions/Data-Matching.html" aria-label="数据匹配"><!---->数据匹配<!----></a></li><li><a class="route-link nav-link vp-sidebar-link vp-sidebar-page" href="/zh/UserGuide/V1.0.x/Operators-Functions/Frequency-Domain.html" aria-label="频域分析"><!---->频域分析<!----></a></li><li><a class="route-link nav-link vp-sidebar-link vp-sidebar-page" href="/zh/UserGuide/V1.0.x/Operators-Functions/Data-Quality.html" aria-label="数据质量"><!---->数据质量<!----></a></li><li><a class="route-link nav-link vp-sidebar-link vp-sidebar-page" href="/zh/UserGuide/V1.0.x/Operators-Functions/Data-Repairing.html" aria-label="数据修复"><!---->数据修复<!----></a></li><li><a class="route-link nav-link vp-sidebar-link vp-sidebar-page" href="/zh/UserGuide/V1.0.x/Operators-Functions/Series-Discovery.html" aria-label="序列发现"><!---->序列发现<!----></a></li></ul></section></li><li><section class="vp-sidebar-group"><button class="vp-sidebar-header clickable" type="button"><!----><span class="vp-sidebar-title">触发器</span><span class="vp-arrow end"></span></button><!----></section></li><li><section class="vp-sidebar-group"><button class="vp-sidebar-header clickable" type="button"><!----><span class="vp-sidebar-title">监控告警</span><span class="vp-arrow end"></span></button><!----></section></li><li><section class="vp-sidebar-group"><button class="vp-sidebar-header clickable" type="button"><!----><span class="vp-sidebar-title">权限管理</span><span class="vp-arrow end"></span></button><!----></section></li><li><section class="vp-sidebar-group"><button class="vp-sidebar-header clickable" type="button"><!----><span class="vp-sidebar-title">运维工具</span><span class="vp-arrow end"></span></button><!----></section></li><li><section class="vp-sidebar-group"><button class="vp-sidebar-header clickable" type="button"><!----><span class="vp-sidebar-title">端云协同</span><span class="vp-arrow end"></span></button><!----></section></li><li><section class="vp-sidebar-group"><button class="vp-sidebar-header clickable" type="button"><!----><span class="vp-sidebar-title">系统集成</span><span class="vp-arrow end"></span></button><!----></section></li><li><section class="vp-sidebar-group"><button class="vp-sidebar-header clickable" type="button"><!----><span class="vp-sidebar-title">分布式</span><span class="vp-arrow end"></span></button><!----></section></li><li><section class="vp-sidebar-group"><button class="vp-sidebar-header clickable" type="button"><!----><span class="vp-sidebar-title">FAQ</span><span class="vp-arrow end"></span></button><!----></section></li><li><section class="vp-sidebar-group"><button class="vp-sidebar-header clickable" type="button"><!----><span class="vp-sidebar-title">参考</span><span class="vp-arrow end"></span></button><!----></section></li></ul><!--[--><!----><!--]--></aside><!--[--><main id="main-content" class="vp-page"><!--[--><!--[--><!----><!--]--><!----><nav class="vp-breadcrumb disable"></nav><div class="vp-page-title"><h1><!---->数据画像</h1><div class="page-info"><!----><!----><span class="page-date-info" aria-label="写作日期"><svg xmlns="http://www.w3.org/2000/svg" class="icon calendar-icon" viewBox="0 0 1024 1024" fill="currentColor" aria-label="calendar icon"><path d="M716.4 110.137c0-18.753-14.72-33.473-33.472-33.473-18.753 0-33.473 14.72-33.473 33.473v33.473h66.993v-33.473zm-334.87 0c0-18.753-14.72-33.473-33.473-33.473s-33.52 14.72-33.52 33.473v33.473h66.993v-33.473zm468.81 33.52H716.4v100.465c0 18.753-14.72 33.473-33.472 33.473a33.145 33.145 0 01-33.473-33.473V143.657H381.53v100.465c0 18.753-14.72 33.473-33.473 33.473a33.145 33.145 0 01-33.473-33.473V143.657H180.6A134.314 134.314 0 0046.66 277.595v535.756A134.314 134.314 0 00180.6 947.289h669.74a134.36 134.36 0 00133.94-133.938V277.595a134.314 134.314 0 00-133.94-133.938zm33.473 267.877H147.126a33.145 33.145 0 01-33.473-33.473c0-18.752 14.72-33.473 33.473-33.473h736.687c18.752 0 33.472 14.72 33.472 33.473a33.145 33.145 0 01-33.472 33.473z"></path></svg><span><!----></span><meta property="datePublished" content="2023-07-10T03:11:17.000Z"></span><span class="page-pageview-info" aria-label="访问量"><svg xmlns="http://www.w3.org/2000/svg" class="icon eye-icon" viewBox="0 0 1024 1024" fill="currentColor" aria-label="eye icon"><path d="M992 512.096c0-5.76-.992-10.592-1.28-11.136-.192-2.88-1.152-8.064-2.08-10.816-.256-.672-.544-1.376-.832-2.08-.48-1.568-1.024-3.104-1.6-4.32C897.664 290.112 707.104 160 512 160c-195.072 0-385.632 130.016-473.76 322.592-1.056 2.112-1.792 4.096-2.272 5.856a55.512 55.512 0 00-.64 1.6c-1.76 5.088-1.792 8.64-1.632 7.744-.832 3.744-1.568 11.168-1.568 11.168-.224 2.272-.224 4.032.032 6.304 0 0 .736 6.464 1.088 7.808.128 1.824.576 4.512 1.12 6.976h-.032c.448 2.08 1.12 4.096 1.984 6.08.48 1.536.992 2.976 1.472 4.032C126.432 733.856 316.992 864 512 864c195.136 0 385.696-130.048 473.216-321.696 1.376-2.496 2.24-4.832 2.848-6.912.256-.608.48-1.184.672-1.728 1.536-4.48 1.856-8.32 1.728-8.32l-.032.032c.608-3.104 1.568-7.744 1.568-13.28zM512 672c-88.224 0-160-71.776-160-160s71.776-160 160-160 160 71.776 160 160-71.776 160-160 160z"></path></svg><span id="ArtalkPV" class="vp-pageview waline-pageview-count" data-path="/zh/UserGuide/V1.0.x/Operators-Functions/Data-Profiling.html" data-page-key="/zh/UserGuide/V1.0.x/Operators-Functions/Data-Profiling.html">...</span></span><span class="page-reading-time-info" aria-label="阅读时间"><svg xmlns="http://www.w3.org/2000/svg" class="icon timer-icon" viewBox="0 0 1024 1024" fill="currentColor" aria-label="timer icon"><path d="M799.387 122.15c4.402-2.978 7.38-7.897 7.38-13.463v-1.165c0-8.933-7.38-16.312-16.312-16.312H256.33c-8.933 0-16.311 7.38-16.311 16.312v1.165c0 5.825 2.977 10.874 7.637 13.592 4.143 194.44 97.22 354.963 220.201 392.763-122.204 37.542-214.893 196.511-220.2 389.397-4.661 5.049-7.638 11.651-7.638 19.03v5.825h566.49v-5.825c0-7.379-2.849-13.981-7.509-18.9-5.049-193.016-97.867-351.985-220.2-389.527 123.24-37.67 216.446-198.453 220.588-392.892zM531.16 450.445v352.632c117.674 1.553 211.787 40.778 211.787 88.676H304.097c0-48.286 95.149-87.382 213.728-88.676V450.445c-93.077-3.107-167.901-81.297-167.901-177.093 0-8.803 6.99-15.793 15.793-15.793 8.803 0 15.794 6.99 15.794 15.793 0 80.261 63.69 145.635 142.01 145.635s142.011-65.374 142.011-145.635c0-8.803 6.99-15.793 15.794-15.793s15.793 6.99 15.793 15.793c0 95.019-73.789 172.82-165.96 177.093z"></path></svg><span>大约 38 分钟</span><meta property="timeRequired" content="PT38M"></span><!----><!----></div><hr></div><div class="vp-toc-placeholder"><aside id="toc"><!--[--><!----><!--]--><div class="vp-toc-header">此页内容<button type="button" class="print-button" title="打印"><svg xmlns="http://www.w3.org/2000/svg" class="icon print-icon" viewBox="0 0 1024 1024" fill="currentColor" aria-label="print icon"><path d="M819.2 364.8h-44.8V128c0-17.067-14.933-32-32-32H281.6c-17.067 0-32 14.933-32 32v236.8h-44.8C145.067 364.8 96 413.867 96 473.6v192c0 59.733 49.067 108.8 108.8 108.8h44.8V896c0 17.067 14.933 32 32 32h460.8c17.067 0 32-14.933 32-32V774.4h44.8c59.733 0 108.8-49.067 108.8-108.8v-192c0-59.733-49.067-108.8-108.8-108.8zM313.6 160h396.8v204.8H313.6V160zm396.8 704H313.6V620.8h396.8V864zM864 665.6c0 25.6-19.2 44.8-44.8 44.8h-44.8V588.8c0-17.067-14.933-32-32-32H281.6c-17.067 0-32 14.933-32 32v121.6h-44.8c-25.6 0-44.8-19.2-44.8-44.8v-192c0-25.6 19.2-44.8 44.8-44.8h614.4c25.6 0 44.8 19.2 44.8 44.8v192z"></path></svg></button><div class="arrow end"></div></div><div class="vp-toc-wrapper"><ul class="vp-toc-list"><!--[--><li class="vp-toc-item"><a class="route-link vp-toc-link level2" href="#acf">ACF</a></li><li><ul class="vp-toc-list"><!--[--><li class="vp-toc-item"><a class="route-link vp-toc-link level3" href="#函数简介">函数简介</a></li><!----><!--]--><!--[--><li class="vp-toc-item"><a class="route-link vp-toc-link level3" href="#使用示例">使用示例</a></li><!----><!--]--></ul></li><!--]--><!--[--><li class="vp-toc-item"><a class="route-link vp-toc-link level2" href="#distinct">Distinct</a></li><li><ul class="vp-toc-list"><!--[--><li class="vp-toc-item"><a class="route-link vp-toc-link level3" href="#函数简介-1">函数简介</a></li><!----><!--]--><!--[--><li class="vp-toc-item"><a class="route-link vp-toc-link level3" href="#使用示例-1">使用示例</a></li><!----><!--]--></ul></li><!--]--><!--[--><li class="vp-toc-item"><a class="route-link vp-toc-link level2" href="#histogram">Histogram</a></li><li><ul class="vp-toc-list"><!--[--><li class="vp-toc-item"><a class="route-link vp-toc-link level3" href="#函数简介-2">函数简介</a></li><!----><!--]--><!--[--><li class="vp-toc-item"><a class="route-link vp-toc-link level3" href="#使用示例-2">使用示例</a></li><!----><!--]--></ul></li><!--]--><!--[--><li class="vp-toc-item"><a class="route-link vp-toc-link level2" href="#integral">Integral</a></li><li><ul class="vp-toc-list"><!--[--><li class="vp-toc-item"><a class="route-link vp-toc-link level3" href="#函数简介-3">函数简介</a></li><!----><!--]--><!--[--><li class="vp-toc-item"><a class="route-link vp-toc-link level3" href="#使用示例-3">使用示例</a></li><!----><!--]--><!--[--><li class="vp-toc-item"><a class="route-link vp-toc-link level3" href="#指定时间单位">指定时间单位</a></li><!----><!--]--></ul></li><!--]--><!--[--><li class="vp-toc-item"><a class="route-link vp-toc-link level2" href="#integralavg">IntegralAvg</a></li><li><ul class="vp-toc-list"><!--[--><li class="vp-toc-item"><a class="route-link vp-toc-link level3" href="#函数简介-4">函数简介</a></li><!----><!--]--><!--[--><li class="vp-toc-item"><a class="route-link vp-toc-link level3" href="#使用示例-4">使用示例</a></li><!----><!--]--></ul></li><!--]--><!--[--><li class="vp-toc-item"><a class="route-link vp-toc-link level2" href="#mad">Mad</a></li><li><ul class="vp-toc-list"><!--[--><li class="vp-toc-item"><a class="route-link vp-toc-link level3" href="#函数简介-5">函数简介</a></li><!----><!--]--><!--[--><li class="vp-toc-item"><a class="route-link vp-toc-link level3" href="#使用示例-5">使用示例</a></li><!----><!--]--></ul></li><!--]--><!--[--><li class="vp-toc-item"><a class="route-link vp-toc-link level2" href="#median">Median</a></li><li><ul class="vp-toc-list"><!--[--><li class="vp-toc-item"><a class="route-link vp-toc-link level3" href="#函数简介-6">函数简介</a></li><!----><!--]--><!--[--><li class="vp-toc-item"><a class="route-link vp-toc-link level3" href="#使用示例-6">使用示例</a></li><!----><!--]--></ul></li><!--]--><!--[--><li class="vp-toc-item"><a class="route-link vp-toc-link level2" href="#minmax">MinMax</a></li><li><ul class="vp-toc-list"><!--[--><li class="vp-toc-item"><a class="route-link vp-toc-link level3" href="#函数简介-7">函数简介</a></li><!----><!--]--><!--[--><li class="vp-toc-item"><a class="route-link vp-toc-link level3" href="#使用示例-7">使用示例</a></li><!----><!--]--></ul></li><!--]--><!--[--><li class="vp-toc-item"><a class="route-link vp-toc-link level2" href="#mode">Mode</a></li><li><ul class="vp-toc-list"><!--[--><li class="vp-toc-item"><a class="route-link vp-toc-link level3" href="#函数简介-8">函数简介</a></li><!----><!--]--><!--[--><li class="vp-toc-item"><a class="route-link vp-toc-link level3" href="#使用示例-8">使用示例</a></li><!----><!--]--></ul></li><!--]--><!--[--><li class="vp-toc-item"><a class="route-link vp-toc-link level2" href="#mvavg">MvAvg</a></li><li><ul class="vp-toc-list"><!--[--><li class="vp-toc-item"><a class="route-link vp-toc-link level3" href="#函数简介-9">函数简介</a></li><!----><!--]--><!--[--><li class="vp-toc-item"><a class="route-link vp-toc-link level3" href="#使用示例-9">使用示例</a></li><!----><!--]--></ul></li><!--]--><!--[--><li class="vp-toc-item"><a class="route-link vp-toc-link level2" href="#pacf">PACF</a></li><li><ul class="vp-toc-list"><!--[--><li class="vp-toc-item"><a class="route-link vp-toc-link level3" href="#函数简介-10">函数简介</a></li><!----><!--]--><!--[--><li class="vp-toc-item"><a class="route-link vp-toc-link level3" href="#使用示例-10">使用示例</a></li><!----><!--]--></ul></li><!--]--><!--[--><li class="vp-toc-item"><a class="route-link vp-toc-link level2" href="#percentile">Percentile</a></li><li><ul class="vp-toc-list"><!--[--><li class="vp-toc-item"><a class="route-link vp-toc-link level3" href="#函数简介-11">函数简介</a></li><!----><!--]--><!--[--><li class="vp-toc-item"><a class="route-link vp-toc-link level3" href="#使用示例-11">使用示例</a></li><!----><!--]--></ul></li><!--]--><!--[--><li class="vp-toc-item"><a class="route-link vp-toc-link level2" href="#quantile">Quantile</a></li><li><ul class="vp-toc-list"><!--[--><li class="vp-toc-item"><a class="route-link vp-toc-link level3" href="#函数简介-12">函数简介</a></li><!----><!--]--><!--[--><li class="vp-toc-item"><a class="route-link vp-toc-link level3" href="#使用示例-12">使用示例</a></li><!----><!--]--></ul></li><!--]--><!--[--><li class="vp-toc-item"><a class="route-link vp-toc-link level2" href="#period">Period</a></li><li><ul class="vp-toc-list"><!--[--><li class="vp-toc-item"><a class="route-link vp-toc-link level3" href="#函数简介-13">函数简介</a></li><!----><!--]--><!--[--><li class="vp-toc-item"><a class="route-link vp-toc-link level3" href="#使用示例-13">使用示例</a></li><!----><!--]--></ul></li><!--]--><!--[--><li class="vp-toc-item"><a class="route-link vp-toc-link level2" href="#qlb">QLB</a></li><li><ul class="vp-toc-list"><!--[--><li class="vp-toc-item"><a class="route-link vp-toc-link level3" href="#函数简介-14">函数简介</a></li><!----><!--]--><!--[--><li class="vp-toc-item"><a class="route-link vp-toc-link level3" href="#使用示例-14">使用示例</a></li><!----><!--]--></ul></li><!--]--><!--[--><li class="vp-toc-item"><a class="route-link vp-toc-link level2" href="#resample">Resample</a></li><li><ul class="vp-toc-list"><!--[--><li class="vp-toc-item"><a class="route-link vp-toc-link level3" href="#函数简介-15">函数简介</a></li><!----><!--]--><!--[--><li class="vp-toc-item"><a class="route-link vp-toc-link level3" href="#使用示例-15">使用示例</a></li><!----><!--]--></ul></li><!--]--><!--[--><li class="vp-toc-item"><a class="route-link vp-toc-link level2" href="#sample">Sample</a></li><li><ul class="vp-toc-list"><!--[--><li class="vp-toc-item"><a class="route-link vp-toc-link level3" href="#函数简介-16">函数简介</a></li><!----><!--]--><!--[--><li class="vp-toc-item"><a class="route-link vp-toc-link level3" href="#使用示例-16">使用示例</a></li><!----><!--]--></ul></li><!--]--><!--[--><li class="vp-toc-item"><a class="route-link vp-toc-link level2" href="#segment">Segment</a></li><li><ul class="vp-toc-list"><!--[--><li class="vp-toc-item"><a class="route-link vp-toc-link level3" href="#函数简介-17">函数简介</a></li><!----><!--]--><!--[--><li class="vp-toc-item"><a class="route-link vp-toc-link level3" href="#使用示例-17">使用示例</a></li><!----><!--]--></ul></li><!--]--><!--[--><li class="vp-toc-item"><a class="route-link vp-toc-link level2" href="#skew">Skew</a></li><li><ul class="vp-toc-list"><!--[--><li class="vp-toc-item"><a class="route-link vp-toc-link level3" href="#函数简介-18">函数简介</a></li><!----><!--]--><!--[--><li class="vp-toc-item"><a class="route-link vp-toc-link level3" href="#使用示例-18">使用示例</a></li><!----><!--]--></ul></li><!--]--><!--[--><li class="vp-toc-item"><a class="route-link vp-toc-link level2" href="#spline">Spline</a></li><li><ul class="vp-toc-list"><!--[--><li class="vp-toc-item"><a class="route-link vp-toc-link level3" href="#函数简介-19">函数简介</a></li><!----><!--]--><!--[--><li class="vp-toc-item"><a class="route-link vp-toc-link level3" href="#使用示例-19">使用示例</a></li><!----><!--]--></ul></li><!--]--><!--[--><li class="vp-toc-item"><a class="route-link vp-toc-link level2" href="#spread">Spread</a></li><li><ul class="vp-toc-list"><!--[--><li class="vp-toc-item"><a class="route-link vp-toc-link level3" href="#函数简介-20">函数简介</a></li><!----><!--]--><!--[--><li class="vp-toc-item"><a class="route-link vp-toc-link level3" href="#使用示例-20">使用示例</a></li><!----><!--]--></ul></li><!--]--><!--[--><li class="vp-toc-item"><a class="route-link vp-toc-link level2" href="#stddev">Stddev</a></li><li><ul class="vp-toc-list"><!--[--><li class="vp-toc-item"><a class="route-link vp-toc-link level3" href="#函数简介-21">函数简介</a></li><!----><!--]--><!--[--><li class="vp-toc-item"><a class="route-link vp-toc-link level3" href="#使用示例-21">使用示例</a></li><!----><!--]--></ul></li><!--]--><!--[--><li class="vp-toc-item"><a class="route-link vp-toc-link level2" href="#zscore">ZScore</a></li><li><ul class="vp-toc-list"><!--[--><li class="vp-toc-item"><a class="route-link vp-toc-link level3" href="#函数简介-22">函数简介</a></li><!----><!--]--><!--[--><li class="vp-toc-item"><a class="route-link vp-toc-link level3" href="#使用示例-22">使用示例</a></li><!----><!--]--></ul></li><!--]--></ul><div class="vp-toc-marker" style="top:-1.7rem;"></div></div><!--[--><!----><!--]--></aside></div><!--[--><!----><!--]--><div class="theme-hope-content"><h1 id="数据画像" tabindex="-1"><a class="header-anchor" href="#数据画像"><span>数据画像</span></a></h1><h2 id="acf" tabindex="-1"><a class="header-anchor" href="#acf"><span>ACF</span></a></h2><h3 id="函数简介" tabindex="-1"><a class="header-anchor" href="#函数简介"><span>函数简介</span></a></h3><p>本函数用于计算时间序列的自相关函数值,即序列与自身之间的互相关函数,详情参见<a class="route-link" href="/zh/UserGuide/V1.0.x/Operators-Functions/Data-Matching.html#XCorr">XCorr</a>函数文档。</p><p><strong>函数名:</strong> ACF</p><p><strong>输入序列:</strong> 仅支持单个输入序列,类型为 INT32 / INT64 / FLOAT / DOUBLE。</p><p><strong>输出序列:</strong> 输出单个序列,类型为 DOUBLE。序列中共包含$2N-1$个数据点,每个值的具体含义参见<a class="route-link" href="/zh/UserGuide/V1.0.x/Operators-Functions/Data-Matching.html#XCorr">XCorr</a>函数文档。</p><p><strong>提示:</strong></p><ul><li>序列中的<code>NaN</code>值会被忽略,在计算中表现为0。</li></ul><h3 id="使用示例" tabindex="-1"><a class="header-anchor" href="#使用示例"><span>使用示例</span></a></h3><p>输入序列:</p><div class="language-text line-numbers-mode" data-ext="text" data-title="text"><pre class="language-text"><code>+-----------------------------+---------------+ |
| | Time|root.test.d1.s1| |
| +-----------------------------+---------------+ |
| |2020-01-01T00:00:01.000+08:00| 1| |
| |2020-01-01T00:00:02.000+08:00| NaN| |
| |2020-01-01T00:00:03.000+08:00| 3| |
| |2020-01-01T00:00:04.000+08:00| NaN| |
| |2020-01-01T00:00:05.000+08:00| 5| |
| +-----------------------------+---------------+ |
| </code></pre><div class="line-numbers" aria-hidden="true"><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div></div></div><p>用于查询的 SQL 语句:</p><div class="language-sql line-numbers-mode" data-ext="sql" data-title="sql"><pre class="language-sql"><code><span class="token keyword">select</span> acf<span class="token punctuation">(</span>s1<span class="token punctuation">)</span> <span class="token keyword">from</span> root<span class="token punctuation">.</span>test<span class="token punctuation">.</span>d1 <span class="token keyword">where</span> <span class="token keyword">time</span> <span class="token operator"><=</span> <span class="token number">2020</span><span class="token operator">-</span><span class="token number">01</span><span class="token operator">-</span><span class="token number">01</span> <span class="token number">00</span>:<span class="token number">00</span>:<span class="token number">05</span> |
| </code></pre><div class="line-numbers" aria-hidden="true"><div class="line-number"></div></div></div><p>输出序列:</p><div class="language-text line-numbers-mode" data-ext="text" data-title="text"><pre class="language-text"><code>+-----------------------------+--------------------+ |
| | Time|acf(root.test.d1.s1)| |
| +-----------------------------+--------------------+ |
| |1970-01-01T08:00:00.001+08:00| 1.0| |
| |1970-01-01T08:00:00.002+08:00| 0.0| |
| |1970-01-01T08:00:00.003+08:00| 3.6| |
| |1970-01-01T08:00:00.004+08:00| 0.0| |
| |1970-01-01T08:00:00.005+08:00| 7.0| |
| |1970-01-01T08:00:00.006+08:00| 0.0| |
| |1970-01-01T08:00:00.007+08:00| 3.6| |
| |1970-01-01T08:00:00.008+08:00| 0.0| |
| |1970-01-01T08:00:00.009+08:00| 1.0| |
| +-----------------------------+--------------------+ |
| </code></pre><div class="line-numbers" aria-hidden="true"><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div></div></div><h2 id="distinct" tabindex="-1"><a class="header-anchor" href="#distinct"><span>Distinct</span></a></h2><h3 id="函数简介-1" tabindex="-1"><a class="header-anchor" href="#函数简介-1"><span>函数简介</span></a></h3><p>本函数可以返回输入序列中出现的所有不同的元素。</p><p><strong>函数名:</strong> DISTINCT</p><p><strong>输入序列:</strong> 仅支持单个输入序列,类型可以是任意的</p><p><strong>输出序列:</strong> 输出单个序列,类型与输入相同。</p><p><strong>提示:</strong></p><ul><li>输出序列的时间戳是无意义的。输出顺序是任意的。</li><li>缺失值和空值将被忽略,但<code>NaN</code>不会被忽略。</li><li>字符串区分大小写</li></ul><h3 id="使用示例-1" tabindex="-1"><a class="header-anchor" href="#使用示例-1"><span>使用示例</span></a></h3><p>输入序列:</p><div class="language-text line-numbers-mode" data-ext="text" data-title="text"><pre class="language-text"><code>+-----------------------------+---------------+ |
| | Time|root.test.d2.s2| |
| +-----------------------------+---------------+ |
| |2020-01-01T08:00:00.001+08:00| Hello| |
| |2020-01-01T08:00:00.002+08:00| hello| |
| |2020-01-01T08:00:00.003+08:00| Hello| |
| |2020-01-01T08:00:00.004+08:00| World| |
| |2020-01-01T08:00:00.005+08:00| World| |
| +-----------------------------+---------------+ |
| </code></pre><div class="line-numbers" aria-hidden="true"><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div></div></div><p>用于查询的 SQL 语句:</p><div class="language-sql line-numbers-mode" data-ext="sql" data-title="sql"><pre class="language-sql"><code><span class="token keyword">select</span> <span class="token keyword">distinct</span><span class="token punctuation">(</span>s2<span class="token punctuation">)</span> <span class="token keyword">from</span> root<span class="token punctuation">.</span>test<span class="token punctuation">.</span>d2 |
| </code></pre><div class="line-numbers" aria-hidden="true"><div class="line-number"></div></div></div><p>输出序列:</p><div class="language-text line-numbers-mode" data-ext="text" data-title="text"><pre class="language-text"><code>+-----------------------------+-------------------------+ |
| | Time|distinct(root.test.d2.s2)| |
| +-----------------------------+-------------------------+ |
| |1970-01-01T08:00:00.001+08:00| Hello| |
| |1970-01-01T08:00:00.002+08:00| hello| |
| |1970-01-01T08:00:00.003+08:00| World| |
| +-----------------------------+-------------------------+ |
| </code></pre><div class="line-numbers" aria-hidden="true"><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div></div></div><h2 id="histogram" tabindex="-1"><a class="header-anchor" href="#histogram"><span>Histogram</span></a></h2><h3 id="函数简介-2" tabindex="-1"><a class="header-anchor" href="#函数简介-2"><span>函数简介</span></a></h3><p>本函数用于计算单列数值型数据的分布直方图。</p><p><strong>函数名:</strong> HISTOGRAM</p><p><strong>输入序列:</strong> 仅支持单个输入序列,类型为 INT32 / INT64 / FLOAT / DOUBLE。</p><p><strong>参数:</strong></p><ul><li><code>min</code>:表示所求数据范围的下限,默认值为 -Double.MAX_VALUE。</li><li><code>max</code>:表示所求数据范围的上限,默认值为 Double.MAX_VALUE,<code>start</code>的值必须小于或等于<code>end</code>。</li><li><code>count</code>: 表示直方图分桶的数量,默认值为 1,其值必须为正整数。</li></ul><p><strong>输出序列:</strong> 直方图分桶的值,其中第 i 个桶(从 1 开始计数)表示的数据范围下界为$min+ (i-1)\cdot\frac{max-min}{count}$,数据范围上界为$min+ i \cdot \frac{max-min}{count}$。</p><p><strong>提示:</strong></p><ul><li>如果某个数据点的数值小于<code>min</code>,它会被放入第 1 个桶;如果某个数据点的数值大于<code>max</code>,它会被放入最后 1 个桶。</li><li>数据中的空值、缺失值和<code>NaN</code>将会被忽略。</li></ul><h3 id="使用示例-2" tabindex="-1"><a class="header-anchor" href="#使用示例-2"><span>使用示例</span></a></h3><p>输入序列:</p><div class="language-text line-numbers-mode" data-ext="text" data-title="text"><pre class="language-text"><code>+-----------------------------+---------------+ |
| | Time|root.test.d1.s1| |
| +-----------------------------+---------------+ |
| |2020-01-01T00:00:00.000+08:00| 1.0| |
| |2020-01-01T00:00:01.000+08:00| 2.0| |
| |2020-01-01T00:00:02.000+08:00| 3.0| |
| |2020-01-01T00:00:03.000+08:00| 4.0| |
| |2020-01-01T00:00:04.000+08:00| 5.0| |
| |2020-01-01T00:00:05.000+08:00| 6.0| |
| |2020-01-01T00:00:06.000+08:00| 7.0| |
| |2020-01-01T00:00:07.000+08:00| 8.0| |
| |2020-01-01T00:00:08.000+08:00| 9.0| |
| |2020-01-01T00:00:09.000+08:00| 10.0| |
| |2020-01-01T00:00:10.000+08:00| 11.0| |
| |2020-01-01T00:00:11.000+08:00| 12.0| |
| |2020-01-01T00:00:12.000+08:00| 13.0| |
| |2020-01-01T00:00:13.000+08:00| 14.0| |
| |2020-01-01T00:00:14.000+08:00| 15.0| |
| |2020-01-01T00:00:15.000+08:00| 16.0| |
| |2020-01-01T00:00:16.000+08:00| 17.0| |
| |2020-01-01T00:00:17.000+08:00| 18.0| |
| |2020-01-01T00:00:18.000+08:00| 19.0| |
| |2020-01-01T00:00:19.000+08:00| 20.0| |
| +-----------------------------+---------------+ |
| </code></pre><div class="line-numbers" aria-hidden="true"><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div></div></div><p>用于查询的SQL语句:</p><div class="language-sql line-numbers-mode" data-ext="sql" data-title="sql"><pre class="language-sql"><code><span class="token keyword">select</span> histogram<span class="token punctuation">(</span>s1<span class="token punctuation">,</span><span class="token string">"min"</span><span class="token operator">=</span><span class="token string">"1"</span><span class="token punctuation">,</span><span class="token string">"max"</span><span class="token operator">=</span><span class="token string">"20"</span><span class="token punctuation">,</span><span class="token string">"count"</span><span class="token operator">=</span><span class="token string">"10"</span><span class="token punctuation">)</span> <span class="token keyword">from</span> root<span class="token punctuation">.</span>test<span class="token punctuation">.</span>d1 |
| </code></pre><div class="line-numbers" aria-hidden="true"><div class="line-number"></div></div></div><p>输出序列:</p><div class="language-text line-numbers-mode" data-ext="text" data-title="text"><pre class="language-text"><code>+-----------------------------+---------------------------------------------------------------+ |
| | Time|histogram(root.test.d1.s1, "min"="1", "max"="20", "count"="10")| |
| +-----------------------------+---------------------------------------------------------------+ |
| |1970-01-01T08:00:00.000+08:00| 2| |
| |1970-01-01T08:00:00.001+08:00| 2| |
| |1970-01-01T08:00:00.002+08:00| 2| |
| |1970-01-01T08:00:00.003+08:00| 2| |
| |1970-01-01T08:00:00.004+08:00| 2| |
| |1970-01-01T08:00:00.005+08:00| 2| |
| |1970-01-01T08:00:00.006+08:00| 2| |
| |1970-01-01T08:00:00.007+08:00| 2| |
| |1970-01-01T08:00:00.008+08:00| 2| |
| |1970-01-01T08:00:00.009+08:00| 2| |
| +-----------------------------+---------------------------------------------------------------+ |
| </code></pre><div class="line-numbers" aria-hidden="true"><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div></div></div><h2 id="integral" tabindex="-1"><a class="header-anchor" href="#integral"><span>Integral</span></a></h2><h3 id="函数简介-3" tabindex="-1"><a class="header-anchor" href="#函数简介-3"><span>函数简介</span></a></h3><p>本函数用于计算时间序列的数值积分,即以时间为横坐标、数值为纵坐标绘制的折线图中折线以下的面积。</p><p><strong>函数名:</strong> INTEGRAL</p><p><strong>输入序列:</strong> 仅支持单个输入序列,类型为 INT32 / INT64 / FLOAT / DOUBLE。</p><p><strong>参数:</strong></p><ul><li><code>unit</code>:积分求解所用的时间轴单位,取值为 "1S", "1s", "1m", "1H", "1d"(区分大小写),分别表示以毫秒、秒、分钟、小时、天为单位计算积分。<br> 缺省情况下取 "1s",以秒为单位。</li></ul><p><strong>输出序列:</strong> 输出单个序列,类型为 DOUBLE,序列仅包含一个时间戳为 0、值为积分结果的数据点。</p><p><strong>提示:</strong></p><ul><li><p>积分值等于折线图中每相邻两个数据点和时间轴形成的直角梯形的面积之和,不同时间单位下相当于横轴进行不同倍数放缩,得到的积分值可直接按放缩倍数转换。</p></li><li><p>数据中<code>NaN</code>将会被忽略。折线将以临近两个有值数据点为准。</p></li></ul><h3 id="使用示例-3" tabindex="-1"><a class="header-anchor" href="#使用示例-3"><span>使用示例</span></a></h3><h4 id="参数缺省" tabindex="-1"><a class="header-anchor" href="#参数缺省"><span>参数缺省</span></a></h4><p>缺省情况下积分以1s为时间单位。</p><p>输入序列:</p><div class="language-text line-numbers-mode" data-ext="text" data-title="text"><pre class="language-text"><code>+-----------------------------+---------------+ |
| | Time|root.test.d1.s1| |
| +-----------------------------+---------------+ |
| |2020-01-01T00:00:01.000+08:00| 1| |
| |2020-01-01T00:00:02.000+08:00| 2| |
| |2020-01-01T00:00:03.000+08:00| 5| |
| |2020-01-01T00:00:04.000+08:00| 6| |
| |2020-01-01T00:00:05.000+08:00| 7| |
| |2020-01-01T00:00:08.000+08:00| 8| |
| |2020-01-01T00:00:09.000+08:00| NaN| |
| |2020-01-01T00:00:10.000+08:00| 10| |
| +-----------------------------+---------------+ |
| </code></pre><div class="line-numbers" aria-hidden="true"><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div></div></div><p>用于查询的 SQL 语句:</p><div class="language-sql line-numbers-mode" data-ext="sql" data-title="sql"><pre class="language-sql"><code><span class="token keyword">select</span> integral<span class="token punctuation">(</span>s1<span class="token punctuation">)</span> <span class="token keyword">from</span> root<span class="token punctuation">.</span>test<span class="token punctuation">.</span>d1 <span class="token keyword">where</span> <span class="token keyword">time</span> <span class="token operator"><=</span> <span class="token number">2020</span><span class="token operator">-</span><span class="token number">01</span><span class="token operator">-</span><span class="token number">01</span> <span class="token number">00</span>:<span class="token number">00</span>:<span class="token number">10</span> |
| </code></pre><div class="line-numbers" aria-hidden="true"><div class="line-number"></div></div></div><p>输出序列:</p><div class="language-text line-numbers-mode" data-ext="text" data-title="text"><pre class="language-text"><code>+-----------------------------+-------------------------+ |
| | Time|integral(root.test.d1.s1)| |
| +-----------------------------+-------------------------+ |
| |1970-01-01T08:00:00.000+08:00| 57.5| |
| +-----------------------------+-------------------------+ |
| </code></pre><div class="line-numbers" aria-hidden="true"><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div></div></div><p>其计算公式为:<br> $$\frac{1}{2}[(1+2)\times 1 + (2+5) \times 1 + (5+6) \times 1 + (6+7) \times 1 + (7+8) \times 3 + (8+10) \times 2] = 57.5$$</p><h3 id="指定时间单位" tabindex="-1"><a class="header-anchor" href="#指定时间单位"><span>指定时间单位</span></a></h3><p>指定以分钟为时间单位。</p><p>输入序列同上,用于查询的 SQL 语句如下:</p><div class="language-sql line-numbers-mode" data-ext="sql" data-title="sql"><pre class="language-sql"><code><span class="token keyword">select</span> integral<span class="token punctuation">(</span>s1<span class="token punctuation">,</span> <span class="token string">"unit"</span><span class="token operator">=</span><span class="token string">"1m"</span><span class="token punctuation">)</span> <span class="token keyword">from</span> root<span class="token punctuation">.</span>test<span class="token punctuation">.</span>d1 <span class="token keyword">where</span> <span class="token keyword">time</span> <span class="token operator"><=</span> <span class="token number">2020</span><span class="token operator">-</span><span class="token number">01</span><span class="token operator">-</span><span class="token number">01</span> <span class="token number">00</span>:<span class="token number">00</span>:<span class="token number">10</span> |
| </code></pre><div class="line-numbers" aria-hidden="true"><div class="line-number"></div></div></div><p>输出序列:</p><div class="language-text line-numbers-mode" data-ext="text" data-title="text"><pre class="language-text"><code>+-----------------------------+-------------------------+ |
| | Time|integral(root.test.d1.s1)| |
| +-----------------------------+-------------------------+ |
| |1970-01-01T08:00:00.000+08:00| 0.958| |
| +-----------------------------+-------------------------+ |
| </code></pre><div class="line-numbers" aria-hidden="true"><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div></div></div><p>其计算公式为:<br> $$\frac{1}{2\times 60}[(1+2) \times 1 + (2+3) \times 1 + (5+6) \times 1 + (6+7) \times 1 + (7+8) \times 3 + (8+10) \times 2] = 0.958$$</p><h2 id="integralavg" tabindex="-1"><a class="header-anchor" href="#integralavg"><span>IntegralAvg</span></a></h2><h3 id="函数简介-4" tabindex="-1"><a class="header-anchor" href="#函数简介-4"><span>函数简介</span></a></h3><p>本函数用于计算时间序列的函数均值,即在相同时间单位下的数值积分除以序列总的时间跨度。更多关于数值积分计算的信息请参考<code>Integral</code>函数。</p><p><strong>函数名:</strong> INTEGRALAVG</p><p><strong>输入序列:</strong> 仅支持单个输入序列,类型为 INT32 / INT64 / FLOAT / DOUBLE。</p><p><strong>输出序列:</strong> 输出单个序列,类型为 DOUBLE,序列仅包含一个时间戳为 0、值为时间加权平均结果的数据点。</p><p><strong>提示:</strong></p><ul><li><p>时间加权的平均值等于在任意时间单位<code>unit</code>下计算的数值积分(即折线图中每相邻两个数据点和时间轴形成的直角梯形的面积之和),<br> 除以相同时间单位下输入序列的时间跨度,其值与具体采用的时间单位无关,默认与 IoTDB 时间单位一致。</p></li><li><p>数据中的<code>NaN</code>将会被忽略。折线将以临近两个有值数据点为准。</p></li><li><p>输入序列为空时,函数输出结果为 0;仅有一个数据点时,输出结果为该点数值。</p></li></ul><h3 id="使用示例-4" tabindex="-1"><a class="header-anchor" href="#使用示例-4"><span>使用示例</span></a></h3><p>输入序列:</p><div class="language-text line-numbers-mode" data-ext="text" data-title="text"><pre class="language-text"><code>+-----------------------------+---------------+ |
| | Time|root.test.d1.s1| |
| +-----------------------------+---------------+ |
| |2020-01-01T00:00:01.000+08:00| 1| |
| |2020-01-01T00:00:02.000+08:00| 2| |
| |2020-01-01T00:00:03.000+08:00| 5| |
| |2020-01-01T00:00:04.000+08:00| 6| |
| |2020-01-01T00:00:05.000+08:00| 7| |
| |2020-01-01T00:00:08.000+08:00| 8| |
| |2020-01-01T00:00:09.000+08:00| NaN| |
| |2020-01-01T00:00:10.000+08:00| 10| |
| +-----------------------------+---------------+ |
| </code></pre><div class="line-numbers" aria-hidden="true"><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div></div></div><p>用于查询的 SQL 语句:</p><div class="language-sql line-numbers-mode" data-ext="sql" data-title="sql"><pre class="language-sql"><code><span class="token keyword">select</span> integralavg<span class="token punctuation">(</span>s1<span class="token punctuation">)</span> <span class="token keyword">from</span> root<span class="token punctuation">.</span>test<span class="token punctuation">.</span>d1 <span class="token keyword">where</span> <span class="token keyword">time</span> <span class="token operator"><=</span> <span class="token number">2020</span><span class="token operator">-</span><span class="token number">01</span><span class="token operator">-</span><span class="token number">01</span> <span class="token number">00</span>:<span class="token number">00</span>:<span class="token number">10</span> |
| </code></pre><div class="line-numbers" aria-hidden="true"><div class="line-number"></div></div></div><p>输出序列:</p><div class="language-text line-numbers-mode" data-ext="text" data-title="text"><pre class="language-text"><code>+-----------------------------+----------------------------+ |
| | Time|integralavg(root.test.d1.s1)| |
| +-----------------------------+----------------------------+ |
| |1970-01-01T08:00:00.000+08:00| 5.75| |
| +-----------------------------+----------------------------+ |
| </code></pre><div class="line-numbers" aria-hidden="true"><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div></div></div><p>其计算公式为:<br> $$\frac{1}{2}[(1+2)\times 1 + (2+5) \times 1 + (5+6) \times 1 + (6+7) \times 1 + (7+8) \times 3 + (8+10) \times 2] / 10 = 5.75$$</p><h2 id="mad" tabindex="-1"><a class="header-anchor" href="#mad"><span>Mad</span></a></h2><h3 id="函数简介-5" tabindex="-1"><a class="header-anchor" href="#函数简介-5"><span>函数简介</span></a></h3><p>本函数用于计算单列数值型数据的精确或近似绝对中位差,绝对中位差为所有数值与其中位数绝对偏移量的中位数。</p><p>如有数据集${1,3,3,5,5,6,7,8,9}$,其中位数为5,所有数值与中位数的偏移量的绝对值为${0,0,1,2,2,2,3,4,4}$,其中位数为2,故而原数据集的绝对中位差为2。</p><p><strong>函数名:</strong> MAD</p><p><strong>输入序列:</strong> 仅支持单个输入序列,类型为 INT32 / INT64 / FLOAT / DOUBLE。</p><p><strong>参数:</strong></p><ul><li><code>error</code>:近似绝对中位差的基于数值的误差百分比,取值范围为 [0,1),默认值为 0。如当<code>error</code>=0.01 时,记精确绝对中位差为a,近似绝对中位差为b,不等式 $0.99a \le b \le 1.01a$ 成立。当<code>error</code>=0 时,计算结果为精确绝对中位差。</li></ul><p><strong>输出序列:</strong> 输出单个序列,类型为DOUBLE,序列仅包含一个时间戳为 0、值为绝对中位差的数据点。</p><p><strong>提示:</strong> 数据中的空值、缺失值和<code>NaN</code>将会被忽略。</p><h3 id="使用示例-5" tabindex="-1"><a class="header-anchor" href="#使用示例-5"><span>使用示例</span></a></h3><h4 id="精确查询" tabindex="-1"><a class="header-anchor" href="#精确查询"><span>精确查询</span></a></h4><p>当<code>error</code>参数缺省或为0时,本函数计算精确绝对中位差。</p><p>输入序列:</p><div class="language-text line-numbers-mode" data-ext="text" data-title="text"><pre class="language-text"><code>+-----------------------------+------------+ |
| | Time|root.test.s0| |
| +-----------------------------+------------+ |
| |2021-03-17T10:32:17.054+08:00| 0.5319929| |
| |2021-03-17T10:32:18.054+08:00| 0.9304316| |
| |2021-03-17T10:32:19.054+08:00| -1.4800133| |
| |2021-03-17T10:32:20.054+08:00| 0.6114087| |
| |2021-03-17T10:32:21.054+08:00| 2.5163336| |
| |2021-03-17T10:32:22.054+08:00| -1.0845392| |
| |2021-03-17T10:32:23.054+08:00| 1.0562582| |
| |2021-03-17T10:32:24.054+08:00| 1.3867859| |
| |2021-03-17T10:32:25.054+08:00| -0.45429882| |
| |2021-03-17T10:32:26.054+08:00| 1.0353678| |
| |2021-03-17T10:32:27.054+08:00| 0.7307929| |
| |2021-03-17T10:32:28.054+08:00| 2.3167255| |
| |2021-03-17T10:32:29.054+08:00| 2.342443| |
| |2021-03-17T10:32:30.054+08:00| 1.5809103| |
| |2021-03-17T10:32:31.054+08:00| 1.4829416| |
| |2021-03-17T10:32:32.054+08:00| 1.5800357| |
| |2021-03-17T10:32:33.054+08:00| 0.7124368| |
| |2021-03-17T10:32:34.054+08:00| -0.78597564| |
| |2021-03-17T10:32:35.054+08:00| 1.2058644| |
| |2021-03-17T10:32:36.054+08:00| 1.4215064| |
| |2021-03-17T10:32:37.054+08:00| 1.2808295| |
| |2021-03-17T10:32:38.054+08:00| -0.6173715| |
| |2021-03-17T10:32:39.054+08:00| 0.06644377| |
| |2021-03-17T10:32:40.054+08:00| 2.349338| |
| |2021-03-17T10:32:41.054+08:00| 1.7335888| |
| |2021-03-17T10:32:42.054+08:00| 1.5872132| |
| ............ |
| Total line number = 10000 |
| </code></pre><div class="line-numbers" aria-hidden="true"><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div></div></div><p>用于查询的 SQL 语句:</p><div class="language-sql line-numbers-mode" data-ext="sql" data-title="sql"><pre class="language-sql"><code><span class="token keyword">select</span> mad<span class="token punctuation">(</span>s0<span class="token punctuation">)</span> <span class="token keyword">from</span> root<span class="token punctuation">.</span>test |
| </code></pre><div class="line-numbers" aria-hidden="true"><div class="line-number"></div></div></div><p>输出序列:</p><div class="language-text line-numbers-mode" data-ext="text" data-title="text"><pre class="language-text"><code>+-----------------------------+------------------+ |
| | Time| mad(root.test.s0)| |
| +-----------------------------+------------------+ |
| |1970-01-01T08:00:00.000+08:00|0.6806197166442871| |
| +-----------------------------+------------------+ |
| </code></pre><div class="line-numbers" aria-hidden="true"><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div></div></div><h4 id="近似查询" tabindex="-1"><a class="header-anchor" href="#近似查询"><span>近似查询</span></a></h4><p>当<code>error</code>参数取值不为 0 时,本函数计算近似绝对中位差。</p><p>输入序列同上,用于查询的 SQL 语句如下:</p><div class="language-sql line-numbers-mode" data-ext="sql" data-title="sql"><pre class="language-sql"><code><span class="token keyword">select</span> mad<span class="token punctuation">(</span>s0<span class="token punctuation">,</span> <span class="token string">"error"</span><span class="token operator">=</span><span class="token string">"0.01"</span><span class="token punctuation">)</span> <span class="token keyword">from</span> root<span class="token punctuation">.</span>test |
| </code></pre><div class="line-numbers" aria-hidden="true"><div class="line-number"></div></div></div><p>输出序列:</p><div class="language-text line-numbers-mode" data-ext="text" data-title="text"><pre class="language-text"><code>+-----------------------------+---------------------------------+ |
| | Time|mad(root.test.s0, "error"="0.01")| |
| +-----------------------------+---------------------------------+ |
| |1970-01-01T08:00:00.000+08:00| 0.6806616245859518| |
| +-----------------------------+---------------------------------+ |
| </code></pre><div class="line-numbers" aria-hidden="true"><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div></div></div><h2 id="median" tabindex="-1"><a class="header-anchor" href="#median"><span>Median</span></a></h2><h3 id="函数简介-6" tabindex="-1"><a class="header-anchor" href="#函数简介-6"><span>函数简介</span></a></h3><p>本函数用于计算单列数值型数据的精确或近似中位数。中位数是顺序排列的一组数据中居于中间位置的数;当序列有偶数个时,中位数为中间二者的平均数。</p><p><strong>函数名:</strong> MEDIAN</p><p><strong>输入序列:</strong> 仅支持单个输入序列,类型为 INT32 / INT64 / FLOAT / DOUBLE</p><p><strong>参数:</strong></p><ul><li><code>error</code>:近似中位数的基于排名的误差百分比,取值范围 [0,1),默认值为 0。如当<code>error</code>=0.01 时,计算出的中位数的真实排名百分比在 0.49~0.51 之间。当<code>error</code>=0 时,计算结果为精确中位数。</li></ul><p><strong>输出序列:</strong> 输出单个序列,类型为 DOUBLE,序列仅包含一个时间戳为 0、值为中位数的数据点。</p><h3 id="使用示例-6" tabindex="-1"><a class="header-anchor" href="#使用示例-6"><span>使用示例</span></a></h3><p>输入序列:</p><div class="language-text line-numbers-mode" data-ext="text" data-title="text"><pre class="language-text"><code>+-----------------------------+------------+ |
| | Time|root.test.s0| |
| +-----------------------------+------------+ |
| |2021-03-17T10:32:17.054+08:00| 0.5319929| |
| |2021-03-17T10:32:18.054+08:00| 0.9304316| |
| |2021-03-17T10:32:19.054+08:00| -1.4800133| |
| |2021-03-17T10:32:20.054+08:00| 0.6114087| |
| |2021-03-17T10:32:21.054+08:00| 2.5163336| |
| |2021-03-17T10:32:22.054+08:00| -1.0845392| |
| |2021-03-17T10:32:23.054+08:00| 1.0562582| |
| |2021-03-17T10:32:24.054+08:00| 1.3867859| |
| |2021-03-17T10:32:25.054+08:00| -0.45429882| |
| |2021-03-17T10:32:26.054+08:00| 1.0353678| |
| |2021-03-17T10:32:27.054+08:00| 0.7307929| |
| |2021-03-17T10:32:28.054+08:00| 2.3167255| |
| |2021-03-17T10:32:29.054+08:00| 2.342443| |
| |2021-03-17T10:32:30.054+08:00| 1.5809103| |
| |2021-03-17T10:32:31.054+08:00| 1.4829416| |
| |2021-03-17T10:32:32.054+08:00| 1.5800357| |
| |2021-03-17T10:32:33.054+08:00| 0.7124368| |
| |2021-03-17T10:32:34.054+08:00| -0.78597564| |
| |2021-03-17T10:32:35.054+08:00| 1.2058644| |
| |2021-03-17T10:32:36.054+08:00| 1.4215064| |
| |2021-03-17T10:32:37.054+08:00| 1.2808295| |
| |2021-03-17T10:32:38.054+08:00| -0.6173715| |
| |2021-03-17T10:32:39.054+08:00| 0.06644377| |
| |2021-03-17T10:32:40.054+08:00| 2.349338| |
| |2021-03-17T10:32:41.054+08:00| 1.7335888| |
| |2021-03-17T10:32:42.054+08:00| 1.5872132| |
| ............ |
| Total line number = 10000 |
| </code></pre><div class="line-numbers" aria-hidden="true"><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div></div></div><p>用于查询的 SQL 语句:</p><div class="language-sql line-numbers-mode" data-ext="sql" data-title="sql"><pre class="language-sql"><code><span class="token keyword">select</span> median<span class="token punctuation">(</span>s0<span class="token punctuation">,</span> <span class="token string">"error"</span><span class="token operator">=</span><span class="token string">"0.01"</span><span class="token punctuation">)</span> <span class="token keyword">from</span> root<span class="token punctuation">.</span>test |
| </code></pre><div class="line-numbers" aria-hidden="true"><div class="line-number"></div></div></div><p>输出序列:</p><div class="language-text line-numbers-mode" data-ext="text" data-title="text"><pre class="language-text"><code>+-----------------------------+------------------------------------+ |
| | Time|median(root.test.s0, "error"="0.01")| |
| +-----------------------------+------------------------------------+ |
| |1970-01-01T08:00:00.000+08:00| 1.021884560585022| |
| +-----------------------------+------------------------------------+ |
| </code></pre><div class="line-numbers" aria-hidden="true"><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div></div></div><h2 id="minmax" tabindex="-1"><a class="header-anchor" href="#minmax"><span>MinMax</span></a></h2><h3 id="函数简介-7" tabindex="-1"><a class="header-anchor" href="#函数简介-7"><span>函数简介</span></a></h3><p>本函数将输入序列使用 min-max 方法进行标准化。最小值归一至 0,最大值归一至 1.</p><p><strong>函数名:</strong> MINMAX</p><p><strong>输入序列:</strong> 仅支持单个输入序列,类型为 INT32 / INT64 / FLOAT / DOUBLE。</p><p><strong>参数:</strong></p><ul><li><code>compute</code>:若设置为"batch",则将数据全部读入后转换;若设置为 "stream",则需用户提供最大值及最小值进行流式计算转换。默认为 "batch"。</li><li><code>min</code>:使用流式计算时的最小值。</li><li><code>max</code>:使用流式计算时的最大值。</li></ul><p><strong>输出序列</strong>:输出单个序列,类型为 DOUBLE。</p><h3 id="使用示例-7" tabindex="-1"><a class="header-anchor" href="#使用示例-7"><span>使用示例</span></a></h3><h4 id="全数据计算" tabindex="-1"><a class="header-anchor" href="#全数据计算"><span>全数据计算</span></a></h4><p>输入序列:</p><div class="language-text line-numbers-mode" data-ext="text" data-title="text"><pre class="language-text"><code>+-----------------------------+------------+ |
| | Time|root.test.s1| |
| +-----------------------------+------------+ |
| |1970-01-01T08:00:00.100+08:00| 0.0| |
| |1970-01-01T08:00:00.200+08:00| 0.0| |
| |1970-01-01T08:00:00.300+08:00| 1.0| |
| |1970-01-01T08:00:00.400+08:00| -1.0| |
| |1970-01-01T08:00:00.500+08:00| 0.0| |
| |1970-01-01T08:00:00.600+08:00| 0.0| |
| |1970-01-01T08:00:00.700+08:00| -2.0| |
| |1970-01-01T08:00:00.800+08:00| 2.0| |
| |1970-01-01T08:00:00.900+08:00| 0.0| |
| |1970-01-01T08:00:01.000+08:00| 0.0| |
| |1970-01-01T08:00:01.100+08:00| 1.0| |
| |1970-01-01T08:00:01.200+08:00| -1.0| |
| |1970-01-01T08:00:01.300+08:00| -1.0| |
| |1970-01-01T08:00:01.400+08:00| 1.0| |
| |1970-01-01T08:00:01.500+08:00| 0.0| |
| |1970-01-01T08:00:01.600+08:00| 0.0| |
| |1970-01-01T08:00:01.700+08:00| 10.0| |
| |1970-01-01T08:00:01.800+08:00| 2.0| |
| |1970-01-01T08:00:01.900+08:00| -2.0| |
| |1970-01-01T08:00:02.000+08:00| 0.0| |
| +-----------------------------+------------+ |
| </code></pre><div class="line-numbers" aria-hidden="true"><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div></div></div><p>用于查询的 SQL 语句:</p><div class="language-sql line-numbers-mode" data-ext="sql" data-title="sql"><pre class="language-sql"><code><span class="token keyword">select</span> minmax<span class="token punctuation">(</span>s1<span class="token punctuation">)</span> <span class="token keyword">from</span> root<span class="token punctuation">.</span>test |
| </code></pre><div class="line-numbers" aria-hidden="true"><div class="line-number"></div></div></div><p>输出序列:</p><div class="language-text line-numbers-mode" data-ext="text" data-title="text"><pre class="language-text"><code>+-----------------------------+--------------------+ |
| | Time|minmax(root.test.s1)| |
| +-----------------------------+--------------------+ |
| |1970-01-01T08:00:00.100+08:00| 0.16666666666666666| |
| |1970-01-01T08:00:00.200+08:00| 0.16666666666666666| |
| |1970-01-01T08:00:00.300+08:00| 0.25| |
| |1970-01-01T08:00:00.400+08:00| 0.08333333333333333| |
| |1970-01-01T08:00:00.500+08:00| 0.16666666666666666| |
| |1970-01-01T08:00:00.600+08:00| 0.16666666666666666| |
| |1970-01-01T08:00:00.700+08:00| 0.0| |
| |1970-01-01T08:00:00.800+08:00| 0.3333333333333333| |
| |1970-01-01T08:00:00.900+08:00| 0.16666666666666666| |
| |1970-01-01T08:00:01.000+08:00| 0.16666666666666666| |
| |1970-01-01T08:00:01.100+08:00| 0.25| |
| |1970-01-01T08:00:01.200+08:00| 0.08333333333333333| |
| |1970-01-01T08:00:01.300+08:00| 0.08333333333333333| |
| |1970-01-01T08:00:01.400+08:00| 0.25| |
| |1970-01-01T08:00:01.500+08:00| 0.16666666666666666| |
| |1970-01-01T08:00:01.600+08:00| 0.16666666666666666| |
| |1970-01-01T08:00:01.700+08:00| 1.0| |
| |1970-01-01T08:00:01.800+08:00| 0.3333333333333333| |
| |1970-01-01T08:00:01.900+08:00| 0.0| |
| |1970-01-01T08:00:02.000+08:00| 0.16666666666666666| |
| +-----------------------------+--------------------+ |
| </code></pre><div class="line-numbers" aria-hidden="true"><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div></div></div><h2 id="mode" tabindex="-1"><a class="header-anchor" href="#mode"><span>Mode</span></a></h2><h3 id="函数简介-8" tabindex="-1"><a class="header-anchor" href="#函数简介-8"><span>函数简介</span></a></h3><p>本函数用于计算时间序列的众数,即出现次数最多的元素。</p><p><strong>函数名:</strong> MODE</p><p><strong>输入序列:</strong> 仅支持单个输入序列,类型可以是任意的。</p><p><strong>输出序列:</strong> 输出单个序列,类型与输入相同,序列仅包含一个时间戳为众数第一次出现的时间戳、值为众数的数据点。</p><p><strong>提示:</strong></p><ul><li>如果有多个出现次数最多的元素,将会输出任意一个。</li><li>数据中的空值和缺失值将会被忽略,但<code>NaN</code>不会被忽略。</li></ul><h3 id="使用示例-8" tabindex="-1"><a class="header-anchor" href="#使用示例-8"><span>使用示例</span></a></h3><p>输入序列:</p><div class="language-text line-numbers-mode" data-ext="text" data-title="text"><pre class="language-text"><code>+-----------------------------+---------------+ |
| | Time|root.test.d2.s2| |
| +-----------------------------+---------------+ |
| |1970-01-01T08:00:00.001+08:00| Hello| |
| |1970-01-01T08:00:00.002+08:00| hello| |
| |1970-01-01T08:00:00.003+08:00| Hello| |
| |1970-01-01T08:00:00.004+08:00| World| |
| |1970-01-01T08:00:00.005+08:00| World| |
| |1970-01-01T08:00:01.600+08:00| World| |
| |1970-01-15T09:37:34.451+08:00| Hello| |
| |1970-01-15T09:37:34.452+08:00| hello| |
| |1970-01-15T09:37:34.453+08:00| Hello| |
| |1970-01-15T09:37:34.454+08:00| World| |
| |1970-01-15T09:37:34.455+08:00| World| |
| +-----------------------------+---------------+ |
| </code></pre><div class="line-numbers" aria-hidden="true"><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div></div></div><p>用于查询的 SQL 语句:</p><div class="language-sql line-numbers-mode" data-ext="sql" data-title="sql"><pre class="language-sql"><code><span class="token keyword">select</span> <span class="token keyword">mode</span><span class="token punctuation">(</span>s2<span class="token punctuation">)</span> <span class="token keyword">from</span> root<span class="token punctuation">.</span>test<span class="token punctuation">.</span>d2 |
| </code></pre><div class="line-numbers" aria-hidden="true"><div class="line-number"></div></div></div><p>输出序列:</p><div class="language-text line-numbers-mode" data-ext="text" data-title="text"><pre class="language-text"><code>+-----------------------------+---------------------+ |
| | Time|mode(root.test.d2.s2)| |
| +-----------------------------+---------------------+ |
| |1970-01-01T08:00:00.004+08:00| World| |
| +-----------------------------+---------------------+ |
| </code></pre><div class="line-numbers" aria-hidden="true"><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div></div></div><h2 id="mvavg" tabindex="-1"><a class="header-anchor" href="#mvavg"><span>MvAvg</span></a></h2><h3 id="函数简介-9" tabindex="-1"><a class="header-anchor" href="#函数简介-9"><span>函数简介</span></a></h3><p>本函数计算序列的移动平均。</p><p><strong>函数名:</strong> MVAVG</p><p><strong>输入序列:</strong> 仅支持单个输入序列,类型为 INT32 / INT64 / FLOAT / DOUBLE。</p><p><strong>参数:</strong></p><ul><li><code>window</code>:移动窗口的长度。默认值为 10.</li></ul><p><strong>输出序列</strong>:输出单个序列,类型为 DOUBLE。</p><h3 id="使用示例-9" tabindex="-1"><a class="header-anchor" href="#使用示例-9"><span>使用示例</span></a></h3><h4 id="指定窗口长度" tabindex="-1"><a class="header-anchor" href="#指定窗口长度"><span>指定窗口长度</span></a></h4><p>输入序列:</p><div class="language-text line-numbers-mode" data-ext="text" data-title="text"><pre class="language-text"><code>+-----------------------------+------------+ |
| | Time|root.test.s1| |
| +-----------------------------+------------+ |
| |1970-01-01T08:00:00.100+08:00| 0.0| |
| |1970-01-01T08:00:00.200+08:00| 0.0| |
| |1970-01-01T08:00:00.300+08:00| 1.0| |
| |1970-01-01T08:00:00.400+08:00| -1.0| |
| |1970-01-01T08:00:00.500+08:00| 0.0| |
| |1970-01-01T08:00:00.600+08:00| 0.0| |
| |1970-01-01T08:00:00.700+08:00| -2.0| |
| |1970-01-01T08:00:00.800+08:00| 2.0| |
| |1970-01-01T08:00:00.900+08:00| 0.0| |
| |1970-01-01T08:00:01.000+08:00| 0.0| |
| |1970-01-01T08:00:01.100+08:00| 1.0| |
| |1970-01-01T08:00:01.200+08:00| -1.0| |
| |1970-01-01T08:00:01.300+08:00| -1.0| |
| |1970-01-01T08:00:01.400+08:00| 1.0| |
| |1970-01-01T08:00:01.500+08:00| 0.0| |
| |1970-01-01T08:00:01.600+08:00| 0.0| |
| |1970-01-01T08:00:01.700+08:00| 10.0| |
| |1970-01-01T08:00:01.800+08:00| 2.0| |
| |1970-01-01T08:00:01.900+08:00| -2.0| |
| |1970-01-01T08:00:02.000+08:00| 0.0| |
| +-----------------------------+------------+ |
| </code></pre><div class="line-numbers" aria-hidden="true"><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div></div></div><p>用于查询的 SQL 语句:</p><div class="language-sql line-numbers-mode" data-ext="sql" data-title="sql"><pre class="language-sql"><code><span class="token keyword">select</span> mvavg<span class="token punctuation">(</span>s1<span class="token punctuation">,</span> <span class="token string">"window"</span><span class="token operator">=</span><span class="token string">"3"</span><span class="token punctuation">)</span> <span class="token keyword">from</span> root<span class="token punctuation">.</span>test |
| </code></pre><div class="line-numbers" aria-hidden="true"><div class="line-number"></div></div></div><p>输出序列:</p><div class="language-text line-numbers-mode" data-ext="text" data-title="text"><pre class="language-text"><code>+-----------------------------+---------------------------------+ |
| | Time|mvavg(root.test.s1, "window"="3")| |
| +-----------------------------+---------------------------------+ |
| |1970-01-01T08:00:00.300+08:00| 0.3333333333333333| |
| |1970-01-01T08:00:00.400+08:00| 0.0| |
| |1970-01-01T08:00:00.500+08:00| -0.3333333333333333| |
| |1970-01-01T08:00:00.600+08:00| 0.0| |
| |1970-01-01T08:00:00.700+08:00| -0.6666666666666666| |
| |1970-01-01T08:00:00.800+08:00| 0.0| |
| |1970-01-01T08:00:00.900+08:00| 0.6666666666666666| |
| |1970-01-01T08:00:01.000+08:00| 0.0| |
| |1970-01-01T08:00:01.100+08:00| 0.3333333333333333| |
| |1970-01-01T08:00:01.200+08:00| 0.0| |
| |1970-01-01T08:00:01.300+08:00| -0.6666666666666666| |
| |1970-01-01T08:00:01.400+08:00| 0.0| |
| |1970-01-01T08:00:01.500+08:00| 0.3333333333333333| |
| |1970-01-01T08:00:01.600+08:00| 0.0| |
| |1970-01-01T08:00:01.700+08:00| 3.3333333333333335| |
| |1970-01-01T08:00:01.800+08:00| 4.0| |
| |1970-01-01T08:00:01.900+08:00| 0.0| |
| |1970-01-01T08:00:02.000+08:00| -0.6666666666666666| |
| +-----------------------------+---------------------------------+ |
| </code></pre><div class="line-numbers" aria-hidden="true"><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div></div></div><h2 id="pacf" tabindex="-1"><a class="header-anchor" href="#pacf"><span>PACF</span></a></h2><h3 id="函数简介-10" tabindex="-1"><a class="header-anchor" href="#函数简介-10"><span>函数简介</span></a></h3><p>本函数通过求解 Yule-Walker 方程,计算序列的偏自相关系数。对于特殊的输入序列,方程可能没有解,此时输出<code>NaN</code>。</p><p><strong>函数名:</strong> PACF</p><p><strong>输入序列:</strong> 仅支持单个输入序列,类型为 INT32 / INT64 / FLOAT / DOUBLE。</p><p><strong>参数:</strong></p><ul><li><code>lag</code>:最大滞后阶数。默认值为$\min(10\log_{10}n,n-1)$,$n$表示数据点个数。</li></ul><p><strong>输出序列</strong>:输出单个序列,类型为 DOUBLE。</p><h3 id="使用示例-10" tabindex="-1"><a class="header-anchor" href="#使用示例-10"><span>使用示例</span></a></h3><h4 id="指定滞后阶数" tabindex="-1"><a class="header-anchor" href="#指定滞后阶数"><span>指定滞后阶数</span></a></h4><p>输入序列:</p><div class="language-text line-numbers-mode" data-ext="text" data-title="text"><pre class="language-text"><code>+-----------------------------+------------+ |
| | Time|root.test.s1| |
| +-----------------------------+------------+ |
| |2019-12-27T00:00:00.000+08:00| 5.0| |
| |2019-12-27T00:05:00.000+08:00| 5.0| |
| |2019-12-27T00:10:00.000+08:00| 5.0| |
| |2019-12-27T00:15:00.000+08:00| 5.0| |
| |2019-12-27T00:20:00.000+08:00| 6.0| |
| |2019-12-27T00:25:00.000+08:00| 5.0| |
| |2019-12-27T00:30:00.000+08:00| 6.0| |
| |2019-12-27T00:35:00.000+08:00| 6.0| |
| |2019-12-27T00:40:00.000+08:00| 6.0| |
| |2019-12-27T00:45:00.000+08:00| 6.0| |
| |2019-12-27T00:50:00.000+08:00| 6.0| |
| |2019-12-27T00:55:00.000+08:00| 5.982609| |
| |2019-12-27T01:00:00.000+08:00| 5.9652176| |
| |2019-12-27T01:05:00.000+08:00| 5.947826| |
| |2019-12-27T01:10:00.000+08:00| 5.9304347| |
| |2019-12-27T01:15:00.000+08:00| 5.9130435| |
| |2019-12-27T01:20:00.000+08:00| 5.8956523| |
| |2019-12-27T01:25:00.000+08:00| 5.878261| |
| |2019-12-27T01:30:00.000+08:00| 5.8608694| |
| |2019-12-27T01:35:00.000+08:00| 5.843478| |
| ............ |
| Total line number = 18066 |
| </code></pre><div class="line-numbers" aria-hidden="true"><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div></div></div><p>用于查询的 SQL 语句:</p><div class="language-sql line-numbers-mode" data-ext="sql" data-title="sql"><pre class="language-sql"><code><span class="token keyword">select</span> pacf<span class="token punctuation">(</span>s1<span class="token punctuation">,</span> <span class="token string">"lag"</span><span class="token operator">=</span><span class="token string">"5"</span><span class="token punctuation">)</span> <span class="token keyword">from</span> root<span class="token punctuation">.</span>test |
| </code></pre><div class="line-numbers" aria-hidden="true"><div class="line-number"></div></div></div><p>输出序列:</p><div class="language-text line-numbers-mode" data-ext="text" data-title="text"><pre class="language-text"><code>+-----------------------------+-----------------------------+ |
| | Time|pacf(root.test.s1, "lag"="5")| |
| +-----------------------------+-----------------------------+ |
| |2019-12-27T00:00:00.000+08:00| 1.0| |
| |2019-12-27T00:05:00.000+08:00| 0.3528915091942786| |
| |2019-12-27T00:10:00.000+08:00| 0.1761346122516304| |
| |2019-12-27T00:15:00.000+08:00| 0.1492391973294682| |
| |2019-12-27T00:20:00.000+08:00| 0.03560059645868398| |
| |2019-12-27T00:25:00.000+08:00| 0.0366222998995286| |
| +-----------------------------+-----------------------------+ |
| </code></pre><div class="line-numbers" aria-hidden="true"><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div></div></div><h2 id="percentile" tabindex="-1"><a class="header-anchor" href="#percentile"><span>Percentile</span></a></h2><h3 id="函数简介-11" tabindex="-1"><a class="header-anchor" href="#函数简介-11"><span>函数简介</span></a></h3><p>本函数用于计算单列数值型数据的精确或近似分位数。</p><p><strong>函数名:</strong> PERCENTILE</p><p><strong>输入序列:</strong> 仅支持单个输入序列,类型为 INT32 / INT64 / FLOAT / DOUBLE。</p><p><strong>参数:</strong></p><ul><li><code>rank</code>:所求分位数在所有数据中的排名百分比,取值范围为 (0,1],默认值为 0.5。如当设为 0.5时则计算中位数。</li><li><code>error</code>:近似分位数的基于排名的误差百分比,取值范围为 [0,1),默认值为0。如<code>rank</code>=0.5 且<code>error</code>=0.01,则计算出的分位数的真实排名百分比在 0.49~0.51之间。当<code>error</code>=0 时,计算结果为精确分位数。</li></ul><p><strong>输出序列:</strong> 输出单个序列,类型与输入序列相同。当<code>error</code>=0时,序列仅包含一个时间戳为分位数第一次出现的时间戳、值为分位数的数据点;否则,输出值的时间戳为0。</p><p><strong>提示:</strong> 数据中的空值、缺失值和<code>NaN</code>将会被忽略。</p><h3 id="使用示例-11" tabindex="-1"><a class="header-anchor" href="#使用示例-11"><span>使用示例</span></a></h3><p>输入序列:</p><div class="language-text line-numbers-mode" data-ext="text" data-title="text"><pre class="language-text"><code>+-----------------------------+------------+ |
| | Time|root.test.s0| |
| +-----------------------------+------------+ |
| |2021-03-17T10:32:17.054+08:00| 0.5319929| |
| |2021-03-17T10:32:18.054+08:00| 0.9304316| |
| |2021-03-17T10:32:19.054+08:00| -1.4800133| |
| |2021-03-17T10:32:20.054+08:00| 0.6114087| |
| |2021-03-17T10:32:21.054+08:00| 2.5163336| |
| |2021-03-17T10:32:22.054+08:00| -1.0845392| |
| |2021-03-17T10:32:23.054+08:00| 1.0562582| |
| |2021-03-17T10:32:24.054+08:00| 1.3867859| |
| |2021-03-17T10:32:25.054+08:00| -0.45429882| |
| |2021-03-17T10:32:26.054+08:00| 1.0353678| |
| |2021-03-17T10:32:27.054+08:00| 0.7307929| |
| |2021-03-17T10:32:28.054+08:00| 2.3167255| |
| |2021-03-17T10:32:29.054+08:00| 2.342443| |
| |2021-03-17T10:32:30.054+08:00| 1.5809103| |
| |2021-03-17T10:32:31.054+08:00| 1.4829416| |
| |2021-03-17T10:32:32.054+08:00| 1.5800357| |
| |2021-03-17T10:32:33.054+08:00| 0.7124368| |
| |2021-03-17T10:32:34.054+08:00| -0.78597564| |
| |2021-03-17T10:32:35.054+08:00| 1.2058644| |
| |2021-03-17T10:32:36.054+08:00| 1.4215064| |
| |2021-03-17T10:32:37.054+08:00| 1.2808295| |
| |2021-03-17T10:32:38.054+08:00| -0.6173715| |
| |2021-03-17T10:32:39.054+08:00| 0.06644377| |
| |2021-03-17T10:32:40.054+08:00| 2.349338| |
| |2021-03-17T10:32:41.054+08:00| 1.7335888| |
| |2021-03-17T10:32:42.054+08:00| 1.5872132| |
| ............ |
| Total line number = 10000 |
| </code></pre><div class="line-numbers" aria-hidden="true"><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div></div></div><p>用于查询的 SQL 语句:</p><div class="language-sql line-numbers-mode" data-ext="sql" data-title="sql"><pre class="language-sql"><code><span class="token keyword">select</span> percentile<span class="token punctuation">(</span>s0<span class="token punctuation">,</span> <span class="token string">"rank"</span><span class="token operator">=</span><span class="token string">"0.2"</span><span class="token punctuation">,</span> <span class="token string">"error"</span><span class="token operator">=</span><span class="token string">"0.01"</span><span class="token punctuation">)</span> <span class="token keyword">from</span> root<span class="token punctuation">.</span>test |
| </code></pre><div class="line-numbers" aria-hidden="true"><div class="line-number"></div></div></div><p>输出序列:</p><div class="language-text line-numbers-mode" data-ext="text" data-title="text"><pre class="language-text"><code>+-----------------------------+------------------------------------------------------+ |
| | Time|percentile(root.test.s0, "rank"="0.2", "error"="0.01")| |
| +-----------------------------+------------------------------------------------------+ |
| |2021-03-17T10:35:02.054+08:00| 0.1801469624042511| |
| +-----------------------------+------------------------------------------------------+ |
| </code></pre><div class="line-numbers" aria-hidden="true"><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div></div></div><h2 id="quantile" tabindex="-1"><a class="header-anchor" href="#quantile"><span>Quantile</span></a></h2><h3 id="函数简介-12" tabindex="-1"><a class="header-anchor" href="#函数简介-12"><span>函数简介</span></a></h3><p>本函数用于计算单列数值型数据的近似分位数。本函数基于KLL sketch算法实现。</p><p><strong>函数名:</strong> QUANTILE</p><p><strong>输入序列:</strong> 仅支持单个输入序列,类型为 INT32 / INT64 / FLOAT / DOUBLE。</p><p><strong>参数:</strong></p><ul><li><code>rank</code>:所求分位数在所有数据中的排名比,取值范围为 (0,1],默认值为 0.5。如当设为 0.5时则计算近似中位数。</li><li><code>K</code>:允许维护的KLL sketch大小,最小值为100,默认值为800。如<code>rank</code>=0.5 且<code>K</code>=800,则计算出的分位数的真实排名比有至少99%的可能性在 0.49~0.51之间。</li></ul><p><strong>输出序列:</strong> 输出单个序列,类型与输入序列相同。输出值的时间戳为0。</p><p><strong>提示:</strong> 数据中的空值、缺失值和<code>NaN</code>将会被忽略。</p><h3 id="使用示例-12" tabindex="-1"><a class="header-anchor" href="#使用示例-12"><span>使用示例</span></a></h3><p>输入序列:</p><div class="language-text line-numbers-mode" data-ext="text" data-title="text"><pre class="language-text"><code>+-----------------------------+------------+ |
| | Time|root.test.s0| |
| +-----------------------------+------------+ |
| |2021-03-17T10:32:17.054+08:00| 0.5319929| |
| |2021-03-17T10:32:18.054+08:00| 0.9304316| |
| |2021-03-17T10:32:19.054+08:00| -1.4800133| |
| |2021-03-17T10:32:20.054+08:00| 0.6114087| |
| |2021-03-17T10:32:21.054+08:00| 2.5163336| |
| |2021-03-17T10:32:22.054+08:00| -1.0845392| |
| |2021-03-17T10:32:23.054+08:00| 1.0562582| |
| |2021-03-17T10:32:24.054+08:00| 1.3867859| |
| |2021-03-17T10:32:25.054+08:00| -0.45429882| |
| |2021-03-17T10:32:26.054+08:00| 1.0353678| |
| |2021-03-17T10:32:27.054+08:00| 0.7307929| |
| |2021-03-17T10:32:28.054+08:00| 2.3167255| |
| |2021-03-17T10:32:29.054+08:00| 2.342443| |
| |2021-03-17T10:32:30.054+08:00| 1.5809103| |
| |2021-03-17T10:32:31.054+08:00| 1.4829416| |
| |2021-03-17T10:32:32.054+08:00| 1.5800357| |
| |2021-03-17T10:32:33.054+08:00| 0.7124368| |
| |2021-03-17T10:32:34.054+08:00| -0.78597564| |
| |2021-03-17T10:32:35.054+08:00| 1.2058644| |
| |2021-03-17T10:32:36.054+08:00| 1.4215064| |
| |2021-03-17T10:32:37.054+08:00| 1.2808295| |
| |2021-03-17T10:32:38.054+08:00| -0.6173715| |
| |2021-03-17T10:32:39.054+08:00| 0.06644377| |
| |2021-03-17T10:32:40.054+08:00| 2.349338| |
| |2021-03-17T10:32:41.054+08:00| 1.7335888| |
| |2021-03-17T10:32:42.054+08:00| 1.5872132| |
| ............ |
| Total line number = 10000 |
| </code></pre><div class="line-numbers" aria-hidden="true"><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div></div></div><p>用于查询的 SQL 语句:</p><div class="language-sql line-numbers-mode" data-ext="sql" data-title="sql"><pre class="language-sql"><code><span class="token keyword">select</span> quantile<span class="token punctuation">(</span>s0<span class="token punctuation">,</span> <span class="token string">"rank"</span><span class="token operator">=</span><span class="token string">"0.2"</span><span class="token punctuation">,</span> <span class="token string">"K"</span><span class="token operator">=</span><span class="token string">"800"</span><span class="token punctuation">)</span> <span class="token keyword">from</span> root<span class="token punctuation">.</span>test |
| </code></pre><div class="line-numbers" aria-hidden="true"><div class="line-number"></div></div></div><p>输出序列:</p><div class="language-text line-numbers-mode" data-ext="text" data-title="text"><pre class="language-text"><code>+-----------------------------+------------------------------------------------------+ |
| | Time|quantile(root.test.s0, "rank"="0.2", "K"="800")| |
| +-----------------------------+------------------------------------------------------+ |
| |1970-01-01T08:00:00.000+08:00| 0.1801469624042511| |
| +-----------------------------+------------------------------------------------------+ |
| </code></pre><div class="line-numbers" aria-hidden="true"><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div></div></div><h2 id="period" tabindex="-1"><a class="header-anchor" href="#period"><span>Period</span></a></h2><h3 id="函数简介-13" tabindex="-1"><a class="header-anchor" href="#函数简介-13"><span>函数简介</span></a></h3><p>本函数用于计算单列数值型数据的周期。</p><p><strong>函数名:</strong> PERIOD</p><p><strong>输入序列:</strong> 仅支持单个输入序列,类型为 INT32 / INT64 / FLOAT / DOUBLE</p><p><strong>输出序列:</strong> 输出单个序列,类型为 INT32,序列仅包含一个时间戳为 0、值为周期的数据点。</p><h3 id="使用示例-13" tabindex="-1"><a class="header-anchor" href="#使用示例-13"><span>使用示例</span></a></h3><p>输入序列:</p><div class="language-text line-numbers-mode" data-ext="text" data-title="text"><pre class="language-text"><code>+-----------------------------+---------------+ |
| | Time|root.test.d3.s1| |
| +-----------------------------+---------------+ |
| |1970-01-01T08:00:00.001+08:00| 1.0| |
| |1970-01-01T08:00:00.002+08:00| 2.0| |
| |1970-01-01T08:00:00.003+08:00| 3.0| |
| |1970-01-01T08:00:00.004+08:00| 1.0| |
| |1970-01-01T08:00:00.005+08:00| 2.0| |
| |1970-01-01T08:00:00.006+08:00| 3.0| |
| |1970-01-01T08:00:00.007+08:00| 1.0| |
| |1970-01-01T08:00:00.008+08:00| 2.0| |
| |1970-01-01T08:00:00.009+08:00| 3.0| |
| +-----------------------------+---------------+ |
| </code></pre><div class="line-numbers" aria-hidden="true"><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div></div></div><p>用于查询的 SQL 语句:</p><div class="language-sql line-numbers-mode" data-ext="sql" data-title="sql"><pre class="language-sql"><code><span class="token keyword">select</span> period<span class="token punctuation">(</span>s1<span class="token punctuation">)</span> <span class="token keyword">from</span> root<span class="token punctuation">.</span>test<span class="token punctuation">.</span>d3 |
| </code></pre><div class="line-numbers" aria-hidden="true"><div class="line-number"></div></div></div><p>输出序列:</p><div class="language-text line-numbers-mode" data-ext="text" data-title="text"><pre class="language-text"><code>+-----------------------------+-----------------------+ |
| | Time|period(root.test.d3.s1)| |
| +-----------------------------+-----------------------+ |
| |1970-01-01T08:00:00.000+08:00| 3| |
| +-----------------------------+-----------------------+ |
| </code></pre><div class="line-numbers" aria-hidden="true"><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div></div></div><h2 id="qlb" tabindex="-1"><a class="header-anchor" href="#qlb"><span>QLB</span></a></h2><h3 id="函数简介-14" tabindex="-1"><a class="header-anchor" href="#函数简介-14"><span>函数简介</span></a></h3><p>本函数对输入序列计算$Q_{LB} $统计量,并计算对应的p值。p值越小表明序列越有可能为非平稳序列。</p><p><strong>函数名:</strong> QLB</p><p><strong>输入序列:</strong> 仅支持单个输入序列,类型为 INT32 / INT64 / FLOAT / DOUBLE。</p><p><strong>参数:</strong></p><ul><li><code>lag</code>:计算时用到的最大延迟阶数,取值应为 1 至 n-2 之间的整数,n 为序列采样总数。默认取 n-2。</li></ul><p><strong>输出序列:</strong> 输出单个序列,类型为 DOUBLE。该序列是$Q_{LB} $统计量对应的 p 值,时间标签代表偏移阶数。</p><p><strong>提示:</strong> $Q_{LB} $统计量由自相关系数求得,如需得到统计量而非 p 值,可以使用 ACF 函数。</p><h3 id="使用示例-14" tabindex="-1"><a class="header-anchor" href="#使用示例-14"><span>使用示例</span></a></h3><h4 id="使用默认参数" tabindex="-1"><a class="header-anchor" href="#使用默认参数"><span>使用默认参数</span></a></h4><p>输入序列:</p><div class="language-text line-numbers-mode" data-ext="text" data-title="text"><pre class="language-text"><code>+-----------------------------+---------------+ |
| | Time|root.test.d1.s1| |
| +-----------------------------+---------------+ |
| |1970-01-01T00:00:00.100+08:00| 1.22| |
| |1970-01-01T00:00:00.200+08:00| -2.78| |
| |1970-01-01T00:00:00.300+08:00| 1.53| |
| |1970-01-01T00:00:00.400+08:00| 0.70| |
| |1970-01-01T00:00:00.500+08:00| 0.75| |
| |1970-01-01T00:00:00.600+08:00| -0.72| |
| |1970-01-01T00:00:00.700+08:00| -0.22| |
| |1970-01-01T00:00:00.800+08:00| 0.28| |
| |1970-01-01T00:00:00.900+08:00| 0.57| |
| |1970-01-01T00:00:01.000+08:00| -0.22| |
| |1970-01-01T00:00:01.100+08:00| -0.72| |
| |1970-01-01T00:00:01.200+08:00| 1.34| |
| |1970-01-01T00:00:01.300+08:00| -0.25| |
| |1970-01-01T00:00:01.400+08:00| 0.17| |
| |1970-01-01T00:00:01.500+08:00| 2.51| |
| |1970-01-01T00:00:01.600+08:00| 1.42| |
| |1970-01-01T00:00:01.700+08:00| -1.34| |
| |1970-01-01T00:00:01.800+08:00| -0.01| |
| |1970-01-01T00:00:01.900+08:00| -0.49| |
| |1970-01-01T00:00:02.000+08:00| 1.63| |
| +-----------------------------+---------------+ |
| </code></pre><div class="line-numbers" aria-hidden="true"><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div></div></div><p>用于查询的 SQL 语句:</p><div class="language-sql line-numbers-mode" data-ext="sql" data-title="sql"><pre class="language-sql"><code><span class="token keyword">select</span> QLB<span class="token punctuation">(</span>s1<span class="token punctuation">)</span> <span class="token keyword">from</span> root<span class="token punctuation">.</span>test<span class="token punctuation">.</span>d1 |
| </code></pre><div class="line-numbers" aria-hidden="true"><div class="line-number"></div></div></div><p>输出序列:</p><div class="language-text line-numbers-mode" data-ext="text" data-title="text"><pre class="language-text"><code>+-----------------------------+--------------------+ |
| | Time|QLB(root.test.d1.s1)| |
| +-----------------------------+--------------------+ |
| |1970-01-01T00:00:00.001+08:00| 0.2168702295315677| |
| |1970-01-01T00:00:00.002+08:00| 0.3068948509261751| |
| |1970-01-01T00:00:00.003+08:00| 0.4217859150918444| |
| |1970-01-01T00:00:00.004+08:00| 0.5114539874276656| |
| |1970-01-01T00:00:00.005+08:00| 0.6560619525616759| |
| |1970-01-01T00:00:00.006+08:00| 0.7722398654053280| |
| |1970-01-01T00:00:00.007+08:00| 0.8532491661465290| |
| |1970-01-01T00:00:00.008+08:00| 0.9028575017542528| |
| |1970-01-01T00:00:00.009+08:00| 0.9434989988192729| |
| |1970-01-01T00:00:00.010+08:00| 0.8950280161464689| |
| |1970-01-01T00:00:00.011+08:00| 0.7701048398839656| |
| |1970-01-01T00:00:00.012+08:00| 0.7845536060001281| |
| |1970-01-01T00:00:00.013+08:00| 0.5943030981705825| |
| |1970-01-01T00:00:00.014+08:00| 0.4618413512531093| |
| |1970-01-01T00:00:00.015+08:00| 0.2645948244673964| |
| |1970-01-01T00:00:00.016+08:00| 0.3167530476666645| |
| |1970-01-01T00:00:00.017+08:00| 0.2330010780351453| |
| |1970-01-01T00:00:00.018+08:00| 0.0666611237622325| |
| +-----------------------------+--------------------+ |
| </code></pre><div class="line-numbers" aria-hidden="true"><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div></div></div><h2 id="resample" tabindex="-1"><a class="header-anchor" href="#resample"><span>Resample</span></a></h2><h3 id="函数简介-15" tabindex="-1"><a class="header-anchor" href="#函数简介-15"><span>函数简介</span></a></h3><p>本函数对输入序列按照指定的频率进行重采样,包括上采样和下采样。目前,本函数支持的上采样方法包括<code>NaN</code>填充法 (NaN)、前值填充法 (FFill)、后值填充法 (BFill) 以及线性插值法 (Linear);本函数支持的下采样方法为分组聚合,聚合方法包括最大值 (Max)、最小值 (Min)、首值 (First)、末值 (Last)、平均值 (Mean)和中位数 (Median)。</p><p><strong>函数名:</strong> RESAMPLE</p><p><strong>输入序列:</strong> 仅支持单个输入序列,类型为 INT32 / INT64 / FLOAT / DOUBLE。</p><p><strong>参数:</strong></p><ul><li><code>every</code>:重采样频率,是一个有单位的正数。目前支持五种单位,分别是 'ms'(毫秒)、's'(秒)、'm'(分钟)、'h'(小时)和'd'(天)。该参数不允许缺省。</li><li><code>interp</code>:上采样的插值方法,取值为 'NaN'、'FFill'、'BFill' 或 'Linear'。在缺省情况下,使用<code>NaN</code>填充法。</li><li><code>aggr</code>:下采样的聚合方法,取值为 'Max'、'Min'、'First'、'Last'、'Mean' 或 'Median'。在缺省情况下,使用平均数聚合。</li><li><code>start</code>:重采样的起始时间(包含),是一个格式为 'yyyy-MM-dd HH:mm:ss' 的时间字符串。在缺省情况下,使用第一个有效数据点的时间戳。</li><li><code>end</code>:重采样的结束时间(不包含),是一个格式为 'yyyy-MM-dd HH:mm:ss' 的时间字符串。在缺省情况下,使用最后一个有效数据点的时间戳。</li></ul><p><strong>输出序列:</strong> 输出单个序列,类型为 DOUBLE。该序列按照重采样频率严格等间隔分布。</p><p><strong>提示:</strong> 数据中的<code>NaN</code>将会被忽略。</p><h3 id="使用示例-15" tabindex="-1"><a class="header-anchor" href="#使用示例-15"><span>使用示例</span></a></h3><h4 id="上采样" tabindex="-1"><a class="header-anchor" href="#上采样"><span>上采样</span></a></h4><p>当重采样频率高于数据原始频率时,将会进行上采样。</p><p>输入序列:</p><div class="language-text line-numbers-mode" data-ext="text" data-title="text"><pre class="language-text"><code>+-----------------------------+---------------+ |
| | Time|root.test.d1.s1| |
| +-----------------------------+---------------+ |
| |2021-03-06T16:00:00.000+08:00| 3.09| |
| |2021-03-06T16:15:00.000+08:00| 3.53| |
| |2021-03-06T16:30:00.000+08:00| 3.5| |
| |2021-03-06T16:45:00.000+08:00| 3.51| |
| |2021-03-06T17:00:00.000+08:00| 3.41| |
| +-----------------------------+---------------+ |
| </code></pre><div class="line-numbers" aria-hidden="true"><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div></div></div><p>用于查询的 SQL 语句:</p><div class="language-sql line-numbers-mode" data-ext="sql" data-title="sql"><pre class="language-sql"><code><span class="token keyword">select</span> resample<span class="token punctuation">(</span>s1<span class="token punctuation">,</span><span class="token string">'every'</span><span class="token operator">=</span><span class="token string">'5m'</span><span class="token punctuation">,</span><span class="token string">'interp'</span><span class="token operator">=</span><span class="token string">'linear'</span><span class="token punctuation">)</span> <span class="token keyword">from</span> root<span class="token punctuation">.</span>test<span class="token punctuation">.</span>d1 |
| </code></pre><div class="line-numbers" aria-hidden="true"><div class="line-number"></div></div></div><p>输出序列:</p><div class="language-text line-numbers-mode" data-ext="text" data-title="text"><pre class="language-text"><code>+-----------------------------+----------------------------------------------------------+ |
| | Time|resample(root.test.d1.s1, "every"="5m", "interp"="linear")| |
| +-----------------------------+----------------------------------------------------------+ |
| |2021-03-06T16:00:00.000+08:00| 3.0899999141693115| |
| |2021-03-06T16:05:00.000+08:00| 3.2366665999094644| |
| |2021-03-06T16:10:00.000+08:00| 3.3833332856496177| |
| |2021-03-06T16:15:00.000+08:00| 3.5299999713897705| |
| |2021-03-06T16:20:00.000+08:00| 3.5199999809265137| |
| |2021-03-06T16:25:00.000+08:00| 3.509999990463257| |
| |2021-03-06T16:30:00.000+08:00| 3.5| |
| |2021-03-06T16:35:00.000+08:00| 3.503333330154419| |
| |2021-03-06T16:40:00.000+08:00| 3.506666660308838| |
| |2021-03-06T16:45:00.000+08:00| 3.509999990463257| |
| |2021-03-06T16:50:00.000+08:00| 3.4766666889190674| |
| |2021-03-06T16:55:00.000+08:00| 3.443333387374878| |
| |2021-03-06T17:00:00.000+08:00| 3.4100000858306885| |
| +-----------------------------+----------------------------------------------------------+ |
| </code></pre><div class="line-numbers" aria-hidden="true"><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div></div></div><h4 id="下采样" tabindex="-1"><a class="header-anchor" href="#下采样"><span>下采样</span></a></h4><p>当重采样频率低于数据原始频率时,将会进行下采样。</p><p>输入序列同上,用于查询的 SQL 语句如下:</p><div class="language-sql line-numbers-mode" data-ext="sql" data-title="sql"><pre class="language-sql"><code><span class="token keyword">select</span> resample<span class="token punctuation">(</span>s1<span class="token punctuation">,</span><span class="token string">'every'</span><span class="token operator">=</span><span class="token string">'30m'</span><span class="token punctuation">,</span><span class="token string">'aggr'</span><span class="token operator">=</span><span class="token string">'first'</span><span class="token punctuation">)</span> <span class="token keyword">from</span> root<span class="token punctuation">.</span>test<span class="token punctuation">.</span>d1 |
| </code></pre><div class="line-numbers" aria-hidden="true"><div class="line-number"></div></div></div><p>输出序列:</p><div class="language-text line-numbers-mode" data-ext="text" data-title="text"><pre class="language-text"><code>+-----------------------------+--------------------------------------------------------+ |
| | Time|resample(root.test.d1.s1, "every"="30m", "aggr"="first")| |
| +-----------------------------+--------------------------------------------------------+ |
| |2021-03-06T16:00:00.000+08:00| 3.0899999141693115| |
| |2021-03-06T16:30:00.000+08:00| 3.5| |
| |2021-03-06T17:00:00.000+08:00| 3.4100000858306885| |
| +-----------------------------+--------------------------------------------------------+ |
| </code></pre><div class="line-numbers" aria-hidden="true"><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div></div></div><h4 id="指定重采样时间段" tabindex="-1"><a class="header-anchor" href="#指定重采样时间段"><span>指定重采样时间段</span></a></h4><p>可以使用<code>start</code>和<code>end</code>两个参数指定重采样的时间段,超出实际时间范围的部分会被插值填补。</p><p>输入序列同上,用于查询的 SQL 语句如下:</p><div class="language-sql line-numbers-mode" data-ext="sql" data-title="sql"><pre class="language-sql"><code><span class="token keyword">select</span> resample<span class="token punctuation">(</span>s1<span class="token punctuation">,</span><span class="token string">'every'</span><span class="token operator">=</span><span class="token string">'30m'</span><span class="token punctuation">,</span><span class="token string">'start'</span><span class="token operator">=</span><span class="token string">'2021-03-06 15:00:00'</span><span class="token punctuation">)</span> <span class="token keyword">from</span> root<span class="token punctuation">.</span>test<span class="token punctuation">.</span>d1 |
| </code></pre><div class="line-numbers" aria-hidden="true"><div class="line-number"></div></div></div><p>输出序列:</p><div class="language-text line-numbers-mode" data-ext="text" data-title="text"><pre class="language-text"><code>+-----------------------------+-----------------------------------------------------------------------+ |
| | Time|resample(root.test.d1.s1, "every"="30m", "start"="2021-03-06 15:00:00")| |
| +-----------------------------+-----------------------------------------------------------------------+ |
| |2021-03-06T15:00:00.000+08:00| NaN| |
| |2021-03-06T15:30:00.000+08:00| NaN| |
| |2021-03-06T16:00:00.000+08:00| 3.309999942779541| |
| |2021-03-06T16:30:00.000+08:00| 3.5049999952316284| |
| |2021-03-06T17:00:00.000+08:00| 3.4100000858306885| |
| +-----------------------------+-----------------------------------------------------------------------+ |
| </code></pre><div class="line-numbers" aria-hidden="true"><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div></div></div><h2 id="sample" tabindex="-1"><a class="header-anchor" href="#sample"><span>Sample</span></a></h2><h3 id="函数简介-16" tabindex="-1"><a class="header-anchor" href="#函数简介-16"><span>函数简介</span></a></h3><p>本函数对输入序列进行采样,即从输入序列中选取指定数量的数据点并输出。目前,本函数支持三种采样方法:<strong>蓄水池采样法 (reservoir sampling)</strong> 对数据进行随机采样,所有数据点被采样的概率相同;<strong>等距采样法 (isometric sampling)</strong> 按照相等的索引间隔对数据进行采样,<strong>最大三角采样法 (triangle sampling)</strong> 对所有数据会按采样率分桶,每个桶内会计算数据点间三角形面积,并保留面积最大的点,该算法通常用于数据的可视化展示中,采用过程可以保证一些关键的突变点在采用中得到保留,更多抽样算法细节可以阅读论文 <a href="http://skemman.is/stream/get/1946/15343/37285/3/SS_MSthesis.pdf" target="_blank" rel="noopener noreferrer">here<span><svg class="external-link-icon" 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"><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="external-link-icon-sr-only">open in new window</span></span></a>。</p><p><strong>函数名:</strong> SAMPLE</p><p><strong>输入序列:</strong> 仅支持单个输入序列,类型可以是任意的。</p><p><strong>参数:</strong></p><ul><li><code>method</code>:采样方法,取值为 'reservoir','isometric' 或 'triangle' 。在缺省情况下,采用蓄水池采样法。</li><li><code>k</code>:采样数,它是一个正整数,在缺省情况下为 1。</li></ul><p><strong>输出序列:</strong> 输出单个序列,类型与输入序列相同。该序列的长度为采样数,序列中的每一个数据点都来自于输入序列。</p><p><strong>提示:</strong> 如果采样数大于序列长度,那么输入序列中所有的数据点都会被输出。</p><h3 id="使用示例-16" tabindex="-1"><a class="header-anchor" href="#使用示例-16"><span>使用示例</span></a></h3><h4 id="蓄水池采样" tabindex="-1"><a class="header-anchor" href="#蓄水池采样"><span>蓄水池采样</span></a></h4><p>当<code>method</code>参数为 'reservoir' 或缺省时,采用蓄水池采样法对输入序列进行采样。由于该采样方法具有随机性,下面展示的输出序列只是一种可能的结果。</p><p>输入序列:</p><div class="language-text line-numbers-mode" data-ext="text" data-title="text"><pre class="language-text"><code>+-----------------------------+---------------+ |
| | Time|root.test.d1.s1| |
| +-----------------------------+---------------+ |
| |2020-01-01T00:00:01.000+08:00| 1.0| |
| |2020-01-01T00:00:02.000+08:00| 2.0| |
| |2020-01-01T00:00:03.000+08:00| 3.0| |
| |2020-01-01T00:00:04.000+08:00| 4.0| |
| |2020-01-01T00:00:05.000+08:00| 5.0| |
| |2020-01-01T00:00:06.000+08:00| 6.0| |
| |2020-01-01T00:00:07.000+08:00| 7.0| |
| |2020-01-01T00:00:08.000+08:00| 8.0| |
| |2020-01-01T00:00:09.000+08:00| 9.0| |
| |2020-01-01T00:00:10.000+08:00| 10.0| |
| +-----------------------------+---------------+ |
| </code></pre><div class="line-numbers" aria-hidden="true"><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div></div></div><p>用于查询的 SQL 语句:</p><div class="language-sql line-numbers-mode" data-ext="sql" data-title="sql"><pre class="language-sql"><code><span class="token keyword">select</span> sample<span class="token punctuation">(</span>s1<span class="token punctuation">,</span><span class="token string">'method'</span><span class="token operator">=</span><span class="token string">'reservoir'</span><span class="token punctuation">,</span><span class="token string">'k'</span><span class="token operator">=</span><span class="token string">'5'</span><span class="token punctuation">)</span> <span class="token keyword">from</span> root<span class="token punctuation">.</span>test<span class="token punctuation">.</span>d1 |
| </code></pre><div class="line-numbers" aria-hidden="true"><div class="line-number"></div></div></div><p>输出序列:</p><div class="language-text line-numbers-mode" data-ext="text" data-title="text"><pre class="language-text"><code>+-----------------------------+------------------------------------------------------+ |
| | Time|sample(root.test.d1.s1, "method"="reservoir", "k"="5")| |
| +-----------------------------+------------------------------------------------------+ |
| |2020-01-01T00:00:02.000+08:00| 2.0| |
| |2020-01-01T00:00:03.000+08:00| 3.0| |
| |2020-01-01T00:00:05.000+08:00| 5.0| |
| |2020-01-01T00:00:08.000+08:00| 8.0| |
| |2020-01-01T00:00:10.000+08:00| 10.0| |
| +-----------------------------+------------------------------------------------------+ |
| </code></pre><div class="line-numbers" aria-hidden="true"><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div></div></div><h4 id="等距采样" tabindex="-1"><a class="header-anchor" href="#等距采样"><span>等距采样</span></a></h4><p>当<code>method</code>参数为 'isometric' 时,采用等距采样法对输入序列进行采样。</p><p>输入序列同上,用于查询的 SQL 语句如下:</p><div class="language-sql line-numbers-mode" data-ext="sql" data-title="sql"><pre class="language-sql"><code><span class="token keyword">select</span> sample<span class="token punctuation">(</span>s1<span class="token punctuation">,</span><span class="token string">'method'</span><span class="token operator">=</span><span class="token string">'isometric'</span><span class="token punctuation">,</span><span class="token string">'k'</span><span class="token operator">=</span><span class="token string">'5'</span><span class="token punctuation">)</span> <span class="token keyword">from</span> root<span class="token punctuation">.</span>test<span class="token punctuation">.</span>d1 |
| </code></pre><div class="line-numbers" aria-hidden="true"><div class="line-number"></div></div></div><p>输出序列:</p><div class="language-text line-numbers-mode" data-ext="text" data-title="text"><pre class="language-text"><code>+-----------------------------+------------------------------------------------------+ |
| | Time|sample(root.test.d1.s1, "method"="isometric", "k"="5")| |
| +-----------------------------+------------------------------------------------------+ |
| |2020-01-01T00:00:01.000+08:00| 1.0| |
| |2020-01-01T00:00:03.000+08:00| 3.0| |
| |2020-01-01T00:00:05.000+08:00| 5.0| |
| |2020-01-01T00:00:07.000+08:00| 7.0| |
| |2020-01-01T00:00:09.000+08:00| 9.0| |
| +-----------------------------+------------------------------------------------------+ |
| </code></pre><div class="line-numbers" aria-hidden="true"><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div></div></div><h2 id="segment" tabindex="-1"><a class="header-anchor" href="#segment"><span>Segment</span></a></h2><h3 id="函数简介-17" tabindex="-1"><a class="header-anchor" href="#函数简介-17"><span>函数简介</span></a></h3><p>本函数按照数据的线性变化趋势将数据划分为多个子序列,返回分段直线拟合后的子序列首值或所有拟合值。</p><p><strong>函数名:</strong> SEGMENT</p><p><strong>输入序列:</strong> 仅支持单个输入序列,类型为 INT32 / INT64 / FLOAT / DOUBLE</p><p><strong>参数:</strong></p><ul><li><p><code>output</code>:"all" 输出所有拟合值;"first" 输出子序列起点拟合值。默认为 "first"。</p></li><li><p><code>error</code>:判定存在线性趋势的误差允许阈值。误差的定义为子序列进行线性拟合的误差的绝对值的均值。默认为 0.1.</p></li></ul><p><strong>输出序列:</strong> 输出单个序列,类型为 DOUBLE。</p><p><strong>提示:</strong> 函数默认所有数据等时间间隔分布。函数读取所有数据,若原始数据过多,请先进行降采样处理。拟合采用自底向上方法,子序列的尾值可能会被认作子序列首值输出。</p><h3 id="使用示例-17" tabindex="-1"><a class="header-anchor" href="#使用示例-17"><span>使用示例</span></a></h3><p>输入序列:</p><div class="language-text line-numbers-mode" data-ext="text" data-title="text"><pre class="language-text"><code>+-----------------------------+------------+ |
| | Time|root.test.s1| |
| +-----------------------------+------------+ |
| |1970-01-01T08:00:00.000+08:00| 5.0| |
| |1970-01-01T08:00:00.100+08:00| 0.0| |
| |1970-01-01T08:00:00.200+08:00| 1.0| |
| |1970-01-01T08:00:00.300+08:00| 2.0| |
| |1970-01-01T08:00:00.400+08:00| 3.0| |
| |1970-01-01T08:00:00.500+08:00| 4.0| |
| |1970-01-01T08:00:00.600+08:00| 5.0| |
| |1970-01-01T08:00:00.700+08:00| 6.0| |
| |1970-01-01T08:00:00.800+08:00| 7.0| |
| |1970-01-01T08:00:00.900+08:00| 8.0| |
| |1970-01-01T08:00:01.000+08:00| 9.0| |
| |1970-01-01T08:00:01.100+08:00| 9.1| |
| |1970-01-01T08:00:01.200+08:00| 9.2| |
| |1970-01-01T08:00:01.300+08:00| 9.3| |
| |1970-01-01T08:00:01.400+08:00| 9.4| |
| |1970-01-01T08:00:01.500+08:00| 9.5| |
| |1970-01-01T08:00:01.600+08:00| 9.6| |
| |1970-01-01T08:00:01.700+08:00| 9.7| |
| |1970-01-01T08:00:01.800+08:00| 9.8| |
| |1970-01-01T08:00:01.900+08:00| 9.9| |
| |1970-01-01T08:00:02.000+08:00| 10.0| |
| |1970-01-01T08:00:02.100+08:00| 8.0| |
| |1970-01-01T08:00:02.200+08:00| 6.0| |
| |1970-01-01T08:00:02.300+08:00| 4.0| |
| |1970-01-01T08:00:02.400+08:00| 2.0| |
| |1970-01-01T08:00:02.500+08:00| 0.0| |
| |1970-01-01T08:00:02.600+08:00| -2.0| |
| |1970-01-01T08:00:02.700+08:00| -4.0| |
| |1970-01-01T08:00:02.800+08:00| -6.0| |
| |1970-01-01T08:00:02.900+08:00| -8.0| |
| |1970-01-01T08:00:03.000+08:00| -10.0| |
| |1970-01-01T08:00:03.100+08:00| 10.0| |
| |1970-01-01T08:00:03.200+08:00| 10.0| |
| |1970-01-01T08:00:03.300+08:00| 10.0| |
| |1970-01-01T08:00:03.400+08:00| 10.0| |
| |1970-01-01T08:00:03.500+08:00| 10.0| |
| |1970-01-01T08:00:03.600+08:00| 10.0| |
| |1970-01-01T08:00:03.700+08:00| 10.0| |
| |1970-01-01T08:00:03.800+08:00| 10.0| |
| |1970-01-01T08:00:03.900+08:00| 10.0| |
| +-----------------------------+------------+ |
| </code></pre><div class="line-numbers" aria-hidden="true"><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div></div></div><p>用于查询的 SQL 语句:</p><div class="language-sql line-numbers-mode" data-ext="sql" data-title="sql"><pre class="language-sql"><code><span class="token keyword">select</span> segment<span class="token punctuation">(</span>s1<span class="token punctuation">,</span><span class="token string">"error"</span><span class="token operator">=</span><span class="token string">"0.1"</span><span class="token punctuation">)</span> <span class="token keyword">from</span> root<span class="token punctuation">.</span>test |
| </code></pre><div class="line-numbers" aria-hidden="true"><div class="line-number"></div></div></div><p>输出序列:</p><div class="language-text line-numbers-mode" data-ext="text" data-title="text"><pre class="language-text"><code>+-----------------------------+------------------------------------+ |
| | Time|segment(root.test.s1, "error"="0.1")| |
| +-----------------------------+------------------------------------+ |
| |1970-01-01T08:00:00.000+08:00| 5.0| |
| |1970-01-01T08:00:00.200+08:00| 1.0| |
| |1970-01-01T08:00:01.000+08:00| 9.0| |
| |1970-01-01T08:00:02.000+08:00| 10.0| |
| |1970-01-01T08:00:03.000+08:00| -10.0| |
| |1970-01-01T08:00:03.200+08:00| 10.0| |
| +-----------------------------+------------------------------------+ |
| </code></pre><div class="line-numbers" aria-hidden="true"><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div></div></div><h2 id="skew" tabindex="-1"><a class="header-anchor" href="#skew"><span>Skew</span></a></h2><h3 id="函数简介-18" tabindex="-1"><a class="header-anchor" href="#函数简介-18"><span>函数简介</span></a></h3><p>本函数用于计算单列数值型数据的总体偏度</p><p><strong>函数名:</strong> SKEW</p><p><strong>输入序列:</strong> 仅支持单个输入序列,类型为 INT32 / INT64 / FLOAT / DOUBLE</p><p><strong>输出序列:</strong> 输出单个序列,类型为 DOUBLE,序列仅包含一个时间戳为 0、值为总体偏度的数据点。</p><p><strong>提示:</strong> 数据中的空值、缺失值和<code>NaN</code>将会被忽略。</p><h3 id="使用示例-18" tabindex="-1"><a class="header-anchor" href="#使用示例-18"><span>使用示例</span></a></h3><p>输入序列:</p><div class="language-text line-numbers-mode" data-ext="text" data-title="text"><pre class="language-text"><code>+-----------------------------+---------------+ |
| | Time|root.test.d1.s1| |
| +-----------------------------+---------------+ |
| |2020-01-01T00:00:00.000+08:00| 1.0| |
| |2020-01-01T00:00:01.000+08:00| 2.0| |
| |2020-01-01T00:00:02.000+08:00| 3.0| |
| |2020-01-01T00:00:03.000+08:00| 4.0| |
| |2020-01-01T00:00:04.000+08:00| 5.0| |
| |2020-01-01T00:00:05.000+08:00| 6.0| |
| |2020-01-01T00:00:06.000+08:00| 7.0| |
| |2020-01-01T00:00:07.000+08:00| 8.0| |
| |2020-01-01T00:00:08.000+08:00| 9.0| |
| |2020-01-01T00:00:09.000+08:00| 10.0| |
| |2020-01-01T00:00:10.000+08:00| 10.0| |
| |2020-01-01T00:00:11.000+08:00| 10.0| |
| |2020-01-01T00:00:12.000+08:00| 10.0| |
| |2020-01-01T00:00:13.000+08:00| 10.0| |
| |2020-01-01T00:00:14.000+08:00| 10.0| |
| |2020-01-01T00:00:15.000+08:00| 10.0| |
| |2020-01-01T00:00:16.000+08:00| 10.0| |
| |2020-01-01T00:00:17.000+08:00| 10.0| |
| |2020-01-01T00:00:18.000+08:00| 10.0| |
| |2020-01-01T00:00:19.000+08:00| 10.0| |
| +-----------------------------+---------------+ |
| </code></pre><div class="line-numbers" aria-hidden="true"><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div></div></div><p>用于查询的SQL语句:</p><div class="language-sql line-numbers-mode" data-ext="sql" data-title="sql"><pre class="language-sql"><code><span class="token keyword">select</span> skew<span class="token punctuation">(</span>s1<span class="token punctuation">)</span> <span class="token keyword">from</span> root<span class="token punctuation">.</span>test<span class="token punctuation">.</span>d1 |
| </code></pre><div class="line-numbers" aria-hidden="true"><div class="line-number"></div></div></div><p>输出序列:</p><div class="language-text line-numbers-mode" data-ext="text" data-title="text"><pre class="language-text"><code>+-----------------------------+-----------------------+ |
| | Time| skew(root.test.d1.s1)| |
| +-----------------------------+-----------------------+ |
| |1970-01-01T08:00:00.000+08:00| -0.9998427402292644| |
| +-----------------------------+-----------------------+ |
| </code></pre><div class="line-numbers" aria-hidden="true"><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div></div></div><h2 id="spline" tabindex="-1"><a class="header-anchor" href="#spline"><span>Spline</span></a></h2><h3 id="函数简介-19" tabindex="-1"><a class="header-anchor" href="#函数简介-19"><span>函数简介</span></a></h3><p>本函数提供对原始序列进行三次样条曲线拟合后的插值重采样。</p><p><strong>函数名:</strong> SPLINE</p><p><strong>输入序列:</strong> 仅支持单个输入序列,类型为 INT32 / INT64 / FLOAT / DOUBLE。</p><p><strong>参数:</strong></p><ul><li><code>points</code>:重采样个数。</li></ul><p><strong>输出序列</strong>:输出单个序列,类型为 DOUBLE。</p><p><strong>提示</strong>:输出序列保留输入序列的首尾值,等时间间隔采样。仅当输入点个数不少于 4 个时才计算插值。</p><h3 id="使用示例-19" tabindex="-1"><a class="header-anchor" href="#使用示例-19"><span>使用示例</span></a></h3><h4 id="指定插值个数" tabindex="-1"><a class="header-anchor" href="#指定插值个数"><span>指定插值个数</span></a></h4><p>输入序列:</p><div class="language-text line-numbers-mode" data-ext="text" data-title="text"><pre class="language-text"><code>+-----------------------------+------------+ |
| | Time|root.test.s1| |
| +-----------------------------+------------+ |
| |1970-01-01T08:00:00.000+08:00| 0.0| |
| |1970-01-01T08:00:00.300+08:00| 1.2| |
| |1970-01-01T08:00:00.500+08:00| 1.7| |
| |1970-01-01T08:00:00.700+08:00| 2.0| |
| |1970-01-01T08:00:00.900+08:00| 2.1| |
| |1970-01-01T08:00:01.100+08:00| 2.0| |
| |1970-01-01T08:00:01.200+08:00| 1.8| |
| |1970-01-01T08:00:01.300+08:00| 1.2| |
| |1970-01-01T08:00:01.400+08:00| 1.0| |
| |1970-01-01T08:00:01.500+08:00| 1.6| |
| +-----------------------------+------------+ |
| </code></pre><div class="line-numbers" aria-hidden="true"><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div></div></div><p>用于查询的 SQL 语句:</p><div class="language-sql line-numbers-mode" data-ext="sql" data-title="sql"><pre class="language-sql"><code><span class="token keyword">select</span> spline<span class="token punctuation">(</span>s1<span class="token punctuation">,</span> <span class="token string">"points"</span><span class="token operator">=</span><span class="token string">"151"</span><span class="token punctuation">)</span> <span class="token keyword">from</span> root<span class="token punctuation">.</span>test |
| </code></pre><div class="line-numbers" aria-hidden="true"><div class="line-number"></div></div></div><p>输出序列:</p><div class="language-text line-numbers-mode" data-ext="text" data-title="text"><pre class="language-text"><code>+-----------------------------+------------------------------------+ |
| | Time|spline(root.test.s1, "points"="151")| |
| +-----------------------------+------------------------------------+ |
| |1970-01-01T08:00:00.000+08:00| 0.0| |
| |1970-01-01T08:00:00.010+08:00| 0.04870000251134237| |
| |1970-01-01T08:00:00.020+08:00| 0.09680000495910646| |
| |1970-01-01T08:00:00.030+08:00| 0.14430000734329226| |
| |1970-01-01T08:00:00.040+08:00| 0.19120000966389972| |
| |1970-01-01T08:00:00.050+08:00| 0.23750001192092896| |
| |1970-01-01T08:00:00.060+08:00| 0.2832000141143799| |
| |1970-01-01T08:00:00.070+08:00| 0.32830001624425253| |
| |1970-01-01T08:00:00.080+08:00| 0.3728000183105469| |
| |1970-01-01T08:00:00.090+08:00| 0.416700020313263| |
| |1970-01-01T08:00:00.100+08:00| 0.4600000222524008| |
| |1970-01-01T08:00:00.110+08:00| 0.5027000241279602| |
| |1970-01-01T08:00:00.120+08:00| 0.5448000259399414| |
| |1970-01-01T08:00:00.130+08:00| 0.5863000276883443| |
| |1970-01-01T08:00:00.140+08:00| 0.627200029373169| |
| |1970-01-01T08:00:00.150+08:00| 0.6675000309944153| |
| |1970-01-01T08:00:00.160+08:00| 0.7072000325520833| |
| |1970-01-01T08:00:00.170+08:00| 0.7463000340461731| |
| |1970-01-01T08:00:00.180+08:00| 0.7848000354766846| |
| |1970-01-01T08:00:00.190+08:00| 0.8227000368436178| |
| |1970-01-01T08:00:00.200+08:00| 0.8600000381469728| |
| |1970-01-01T08:00:00.210+08:00| 0.8967000393867494| |
| |1970-01-01T08:00:00.220+08:00| 0.9328000405629477| |
| |1970-01-01T08:00:00.230+08:00| 0.9683000416755676| |
| |1970-01-01T08:00:00.240+08:00| 1.0032000427246095| |
| |1970-01-01T08:00:00.250+08:00| 1.037500043710073| |
| |1970-01-01T08:00:00.260+08:00| 1.071200044631958| |
| |1970-01-01T08:00:00.270+08:00| 1.1043000454902647| |
| |1970-01-01T08:00:00.280+08:00| 1.1368000462849934| |
| |1970-01-01T08:00:00.290+08:00| 1.1687000470161437| |
| |1970-01-01T08:00:00.300+08:00| 1.2000000476837158| |
| |1970-01-01T08:00:00.310+08:00| 1.2307000483103594| |
| |1970-01-01T08:00:00.320+08:00| 1.2608000489139557| |
| |1970-01-01T08:00:00.330+08:00| 1.2903000494873524| |
| |1970-01-01T08:00:00.340+08:00| 1.3192000500233967| |
| |1970-01-01T08:00:00.350+08:00| 1.3475000505149364| |
| |1970-01-01T08:00:00.360+08:00| 1.3752000509548186| |
| |1970-01-01T08:00:00.370+08:00| 1.402300051335891| |
| |1970-01-01T08:00:00.380+08:00| 1.4288000516510009| |
| |1970-01-01T08:00:00.390+08:00| 1.4547000518929958| |
| |1970-01-01T08:00:00.400+08:00| 1.480000052054723| |
| |1970-01-01T08:00:00.410+08:00| 1.5047000521290301| |
| |1970-01-01T08:00:00.420+08:00| 1.5288000521087646| |
| |1970-01-01T08:00:00.430+08:00| 1.5523000519867738| |
| |1970-01-01T08:00:00.440+08:00| 1.575200051755905| |
| |1970-01-01T08:00:00.450+08:00| 1.597500051409006| |
| |1970-01-01T08:00:00.460+08:00| 1.619200050938924| |
| |1970-01-01T08:00:00.470+08:00| 1.6403000503385066| |
| |1970-01-01T08:00:00.480+08:00| 1.660800049600601| |
| |1970-01-01T08:00:00.490+08:00| 1.680700048718055| |
| |1970-01-01T08:00:00.500+08:00| 1.7000000476837158| |
| |1970-01-01T08:00:00.510+08:00| 1.7188475466453037| |
| |1970-01-01T08:00:00.520+08:00| 1.7373800457262996| |
| |1970-01-01T08:00:00.530+08:00| 1.7555825448831923| |
| |1970-01-01T08:00:00.540+08:00| 1.7734400440724702| |
| |1970-01-01T08:00:00.550+08:00| 1.790937543250622| |
| |1970-01-01T08:00:00.560+08:00| 1.8080600423741364| |
| |1970-01-01T08:00:00.570+08:00| 1.8247925413995016| |
| |1970-01-01T08:00:00.580+08:00| 1.8411200402832066| |
| |1970-01-01T08:00:00.590+08:00| 1.8570275389817397| |
| |1970-01-01T08:00:00.600+08:00| 1.8725000374515897| |
| |1970-01-01T08:00:00.610+08:00| 1.8875225356492449| |
| |1970-01-01T08:00:00.620+08:00| 1.902080033531194| |
| |1970-01-01T08:00:00.630+08:00| 1.9161575310539258| |
| |1970-01-01T08:00:00.640+08:00| 1.9297400281739288| |
| |1970-01-01T08:00:00.650+08:00| 1.9428125248476913| |
| |1970-01-01T08:00:00.660+08:00| 1.9553600210317021| |
| |1970-01-01T08:00:00.670+08:00| 1.96736751668245| |
| |1970-01-01T08:00:00.680+08:00| 1.9788200117564232| |
| |1970-01-01T08:00:00.690+08:00| 1.9897025062101101| |
| |1970-01-01T08:00:00.700+08:00| 2.0| |
| |1970-01-01T08:00:00.710+08:00| 2.0097024933913334| |
| |1970-01-01T08:00:00.720+08:00| 2.0188199867081615| |
| |1970-01-01T08:00:00.730+08:00| 2.027367479995188| |
| |1970-01-01T08:00:00.740+08:00| 2.0353599732971155| |
| |1970-01-01T08:00:00.750+08:00| 2.0428124666586482| |
| |1970-01-01T08:00:00.760+08:00| 2.049739960124489| |
| |1970-01-01T08:00:00.770+08:00| 2.056157453739342| |
| |1970-01-01T08:00:00.780+08:00| 2.06207994754791| |
| |1970-01-01T08:00:00.790+08:00| 2.067522441594897| |
| |1970-01-01T08:00:00.800+08:00| 2.072499935925006| |
| |1970-01-01T08:00:00.810+08:00| 2.07702743058294| |
| |1970-01-01T08:00:00.820+08:00| 2.081119925613404| |
| |1970-01-01T08:00:00.830+08:00| 2.0847924210611| |
| |1970-01-01T08:00:00.840+08:00| 2.0880599169707317| |
| |1970-01-01T08:00:00.850+08:00| 2.0909374133870027| |
| |1970-01-01T08:00:00.860+08:00| 2.0934399103546166| |
| |1970-01-01T08:00:00.870+08:00| 2.0955824079182768| |
| |1970-01-01T08:00:00.880+08:00| 2.0973799061226863| |
| |1970-01-01T08:00:00.890+08:00| 2.098847405012549| |
| |1970-01-01T08:00:00.900+08:00| 2.0999999046325684| |
| |1970-01-01T08:00:00.910+08:00| 2.1005574051201332| |
| |1970-01-01T08:00:00.920+08:00| 2.1002599065303778| |
| |1970-01-01T08:00:00.930+08:00| 2.0991524087846245| |
| |1970-01-01T08:00:00.940+08:00| 2.0972799118041947| |
| |1970-01-01T08:00:00.950+08:00| 2.0946874155104105| |
| |1970-01-01T08:00:00.960+08:00| 2.0914199198245944| |
| |1970-01-01T08:00:00.970+08:00| 2.0875224246680673| |
| |1970-01-01T08:00:00.980+08:00| 2.083039929962151| |
| |1970-01-01T08:00:00.990+08:00| 2.0780174356281687| |
| |1970-01-01T08:00:01.000+08:00| 2.0724999415874406| |
| |1970-01-01T08:00:01.010+08:00| 2.06653244776129| |
| |1970-01-01T08:00:01.020+08:00| 2.060159954071038| |
| |1970-01-01T08:00:01.030+08:00| 2.053427460438006| |
| |1970-01-01T08:00:01.040+08:00| 2.046379966783517| |
| |1970-01-01T08:00:01.050+08:00| 2.0390624730288924| |
| |1970-01-01T08:00:01.060+08:00| 2.031519979095454| |
| |1970-01-01T08:00:01.070+08:00| 2.0237974849045237| |
| |1970-01-01T08:00:01.080+08:00| 2.015939990377423| |
| |1970-01-01T08:00:01.090+08:00| 2.0079924954354746| |
| |1970-01-01T08:00:01.100+08:00| 2.0| |
| |1970-01-01T08:00:01.110+08:00| 1.9907018211101906| |
| |1970-01-01T08:00:01.120+08:00| 1.9788509124245144| |
| |1970-01-01T08:00:01.130+08:00| 1.9645127287932083| |
| |1970-01-01T08:00:01.140+08:00| 1.9477527250665083| |
| |1970-01-01T08:00:01.150+08:00| 1.9286363560946513| |
| |1970-01-01T08:00:01.160+08:00| 1.9072290767278735| |
| |1970-01-01T08:00:01.170+08:00| 1.8835963418164114| |
| |1970-01-01T08:00:01.180+08:00| 1.8578036062105014| |
| |1970-01-01T08:00:01.190+08:00| 1.8299163247603802| |
| |1970-01-01T08:00:01.200+08:00| 1.7999999523162842| |
| |1970-01-01T08:00:01.210+08:00| 1.7623635841923329| |
| |1970-01-01T08:00:01.220+08:00| 1.7129696477516976| |
| |1970-01-01T08:00:01.230+08:00| 1.6543635959181928| |
| |1970-01-01T08:00:01.240+08:00| 1.5890908816156328| |
| |1970-01-01T08:00:01.250+08:00| 1.5196969577678319| |
| |1970-01-01T08:00:01.260+08:00| 1.4487272772986044| |
| |1970-01-01T08:00:01.270+08:00| 1.3787272931317647| |
| |1970-01-01T08:00:01.280+08:00| 1.3122424581911272| |
| |1970-01-01T08:00:01.290+08:00| 1.251818225400506| |
| |1970-01-01T08:00:01.300+08:00| 1.2000000476837158| |
| |1970-01-01T08:00:01.310+08:00| 1.1548000470995912| |
| |1970-01-01T08:00:01.320+08:00| 1.1130667107899999| |
| |1970-01-01T08:00:01.330+08:00| 1.0756000393033045| |
| |1970-01-01T08:00:01.340+08:00| 1.043200033187868| |
| |1970-01-01T08:00:01.350+08:00| 1.016666692992053| |
| |1970-01-01T08:00:01.360+08:00| 0.9968000192642223| |
| |1970-01-01T08:00:01.370+08:00| 0.9844000125527389| |
| |1970-01-01T08:00:01.380+08:00| 0.9802666734059655| |
| |1970-01-01T08:00:01.390+08:00| 0.9852000023722649| |
| |1970-01-01T08:00:01.400+08:00| 1.0| |
| |1970-01-01T08:00:01.410+08:00| 1.023999999165535| |
| |1970-01-01T08:00:01.420+08:00| 1.0559999990463256| |
| |1970-01-01T08:00:01.430+08:00| 1.0959999996423722| |
| |1970-01-01T08:00:01.440+08:00| 1.1440000009536744| |
| |1970-01-01T08:00:01.450+08:00| 1.2000000029802322| |
| |1970-01-01T08:00:01.460+08:00| 1.264000005722046| |
| |1970-01-01T08:00:01.470+08:00| 1.3360000091791153| |
| |1970-01-01T08:00:01.480+08:00| 1.4160000133514405| |
| |1970-01-01T08:00:01.490+08:00| 1.5040000182390214| |
| |1970-01-01T08:00:01.500+08:00| 1.600000023841858| |
| +-----------------------------+------------------------------------+ |
| </code></pre><div class="line-numbers" aria-hidden="true"><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div></div></div><h2 id="spread" tabindex="-1"><a class="header-anchor" href="#spread"><span>Spread</span></a></h2><h3 id="函数简介-20" tabindex="-1"><a class="header-anchor" href="#函数简介-20"><span>函数简介</span></a></h3><p>本函数用于计算时间序列的极差,即最大值减去最小值的结果。</p><p><strong>函数名:</strong> SPREAD</p><p><strong>输入序列:</strong> 仅支持单个输入序列,类型为 INT32 / INT64 / FLOAT / DOUBLE。</p><p><strong>输出序列:</strong> 输出单个序列,类型与输入相同,序列仅包含一个时间戳为 0 、值为极差的数据点。</p><p><strong>提示:</strong> 数据中的空值、缺失值和<code>NaN</code>将会被忽略。</p><h3 id="使用示例-20" tabindex="-1"><a class="header-anchor" href="#使用示例-20"><span>使用示例</span></a></h3><p>输入序列:</p><div class="language-text line-numbers-mode" data-ext="text" data-title="text"><pre class="language-text"><code>+-----------------------------+---------------+ |
| | Time|root.test.d1.s1| |
| +-----------------------------+---------------+ |
| |2020-01-01T00:00:02.000+08:00| 100.0| |
| |2020-01-01T00:00:03.000+08:00| 101.0| |
| |2020-01-01T00:00:04.000+08:00| 102.0| |
| |2020-01-01T00:00:06.000+08:00| 104.0| |
| |2020-01-01T00:00:08.000+08:00| 126.0| |
| |2020-01-01T00:00:10.000+08:00| 108.0| |
| |2020-01-01T00:00:14.000+08:00| 112.0| |
| |2020-01-01T00:00:15.000+08:00| 113.0| |
| |2020-01-01T00:00:16.000+08:00| 114.0| |
| |2020-01-01T00:00:18.000+08:00| 116.0| |
| |2020-01-01T00:00:20.000+08:00| 118.0| |
| |2020-01-01T00:00:22.000+08:00| 120.0| |
| |2020-01-01T00:00:26.000+08:00| 124.0| |
| |2020-01-01T00:00:28.000+08:00| 126.0| |
| |2020-01-01T00:00:30.000+08:00| NaN| |
| +-----------------------------+---------------+ |
| </code></pre><div class="line-numbers" aria-hidden="true"><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div></div></div><p>用于查询的 SQL 语句:</p><div class="language-sql line-numbers-mode" data-ext="sql" data-title="sql"><pre class="language-sql"><code><span class="token keyword">select</span> spread<span class="token punctuation">(</span>s1<span class="token punctuation">)</span> <span class="token keyword">from</span> root<span class="token punctuation">.</span>test<span class="token punctuation">.</span>d1 <span class="token keyword">where</span> <span class="token keyword">time</span> <span class="token operator"><=</span> <span class="token number">2020</span><span class="token operator">-</span><span class="token number">01</span><span class="token operator">-</span><span class="token number">01</span> <span class="token number">00</span>:<span class="token number">00</span>:<span class="token number">30</span> |
| </code></pre><div class="line-numbers" aria-hidden="true"><div class="line-number"></div></div></div><p>输出序列:</p><div class="language-text line-numbers-mode" data-ext="text" data-title="text"><pre class="language-text"><code>+-----------------------------+-----------------------+ |
| | Time|spread(root.test.d1.s1)| |
| +-----------------------------+-----------------------+ |
| |1970-01-01T08:00:00.000+08:00| 26.0| |
| +-----------------------------+-----------------------+ |
| </code></pre><div class="line-numbers" aria-hidden="true"><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div></div></div><h2 id="stddev" tabindex="-1"><a class="header-anchor" href="#stddev"><span>Stddev</span></a></h2><h3 id="函数简介-21" tabindex="-1"><a class="header-anchor" href="#函数简介-21"><span>函数简介</span></a></h3><p>本函数用于计算单列数值型数据的总体标准差。</p><p><strong>函数名:</strong> STDDEV</p><p><strong>输入序列:</strong> 仅支持单个输入序列,类型为 INT32 / INT64 / FLOAT / DOUBLE。</p><p><strong>输出序列:</strong> 输出单个序列,类型为 DOUBLE。序列仅包含一个时间戳为 0、值为总体标准差的数据点。</p><p><strong>提示:</strong> 数据中的空值、缺失值和<code>NaN</code>将会被忽略。</p><h3 id="使用示例-21" tabindex="-1"><a class="header-anchor" href="#使用示例-21"><span>使用示例</span></a></h3><p>输入序列:</p><div class="language-text line-numbers-mode" data-ext="text" data-title="text"><pre class="language-text"><code>+-----------------------------+---------------+ |
| | Time|root.test.d1.s1| |
| +-----------------------------+---------------+ |
| |2020-01-01T00:00:00.000+08:00| 1.0| |
| |2020-01-01T00:00:01.000+08:00| 2.0| |
| |2020-01-01T00:00:02.000+08:00| 3.0| |
| |2020-01-01T00:00:03.000+08:00| 4.0| |
| |2020-01-01T00:00:04.000+08:00| 5.0| |
| |2020-01-01T00:00:05.000+08:00| 6.0| |
| |2020-01-01T00:00:06.000+08:00| 7.0| |
| |2020-01-01T00:00:07.000+08:00| 8.0| |
| |2020-01-01T00:00:08.000+08:00| 9.0| |
| |2020-01-01T00:00:09.000+08:00| 10.0| |
| |2020-01-01T00:00:10.000+08:00| 11.0| |
| |2020-01-01T00:00:11.000+08:00| 12.0| |
| |2020-01-01T00:00:12.000+08:00| 13.0| |
| |2020-01-01T00:00:13.000+08:00| 14.0| |
| |2020-01-01T00:00:14.000+08:00| 15.0| |
| |2020-01-01T00:00:15.000+08:00| 16.0| |
| |2020-01-01T00:00:16.000+08:00| 17.0| |
| |2020-01-01T00:00:17.000+08:00| 18.0| |
| |2020-01-01T00:00:18.000+08:00| 19.0| |
| |2020-01-01T00:00:19.000+08:00| 20.0| |
| +-----------------------------+---------------+ |
| </code></pre><div class="line-numbers" aria-hidden="true"><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div></div></div><p>用于查询的 SQL 语句:</p><div class="language-sql line-numbers-mode" data-ext="sql" data-title="sql"><pre class="language-sql"><code><span class="token keyword">select</span> stddev<span class="token punctuation">(</span>s1<span class="token punctuation">)</span> <span class="token keyword">from</span> root<span class="token punctuation">.</span>test<span class="token punctuation">.</span>d1 |
| </code></pre><div class="line-numbers" aria-hidden="true"><div class="line-number"></div></div></div><p>输出序列:</p><div class="language-text line-numbers-mode" data-ext="text" data-title="text"><pre class="language-text"><code>+-----------------------------+-----------------------+ |
| | Time|stddev(root.test.d1.s1)| |
| +-----------------------------+-----------------------+ |
| |1970-01-01T08:00:00.000+08:00| 5.7662812973353965| |
| +-----------------------------+-----------------------+ |
| </code></pre><div class="line-numbers" aria-hidden="true"><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div></div></div><h2 id="zscore" tabindex="-1"><a class="header-anchor" href="#zscore"><span>ZScore</span></a></h2><h3 id="函数简介-22" tabindex="-1"><a class="header-anchor" href="#函数简介-22"><span>函数简介</span></a></h3><p>本函数将输入序列使用z-score方法进行归一化。</p><p><strong>函数名:</strong> ZSCORE</p><p><strong>输入序列:</strong> 仅支持单个输入序列,类型为 INT32 / INT64 / FLOAT / DOUBLE。</p><p><strong>参数:</strong></p><ul><li><code>compute</code>:若设置为 "batch",则将数据全部读入后转换;若设置为 "stream",则需用户提供均值及方差进行流式计算转换。默认为 "batch"。</li><li><code>avg</code>:使用流式计算时的均值。</li><li><code>sd</code>:使用流式计算时的标准差。</li></ul><p><strong>输出序列</strong>:输出单个序列,类型为 DOUBLE。</p><h3 id="使用示例-22" tabindex="-1"><a class="header-anchor" href="#使用示例-22"><span>使用示例</span></a></h3><h4 id="全数据计算-1" tabindex="-1"><a class="header-anchor" href="#全数据计算-1"><span>全数据计算</span></a></h4><p>输入序列:</p><div class="language-text line-numbers-mode" data-ext="text" data-title="text"><pre class="language-text"><code>+-----------------------------+------------+ |
| | Time|root.test.s1| |
| +-----------------------------+------------+ |
| |1970-01-01T08:00:00.100+08:00| 0.0| |
| |1970-01-01T08:00:00.200+08:00| 0.0| |
| |1970-01-01T08:00:00.300+08:00| 1.0| |
| |1970-01-01T08:00:00.400+08:00| -1.0| |
| |1970-01-01T08:00:00.500+08:00| 0.0| |
| |1970-01-01T08:00:00.600+08:00| 0.0| |
| |1970-01-01T08:00:00.700+08:00| -2.0| |
| |1970-01-01T08:00:00.800+08:00| 2.0| |
| |1970-01-01T08:00:00.900+08:00| 0.0| |
| |1970-01-01T08:00:01.000+08:00| 0.0| |
| |1970-01-01T08:00:01.100+08:00| 1.0| |
| |1970-01-01T08:00:01.200+08:00| -1.0| |
| |1970-01-01T08:00:01.300+08:00| -1.0| |
| |1970-01-01T08:00:01.400+08:00| 1.0| |
| |1970-01-01T08:00:01.500+08:00| 0.0| |
| |1970-01-01T08:00:01.600+08:00| 0.0| |
| |1970-01-01T08:00:01.700+08:00| 10.0| |
| |1970-01-01T08:00:01.800+08:00| 2.0| |
| |1970-01-01T08:00:01.900+08:00| -2.0| |
| |1970-01-01T08:00:02.000+08:00| 0.0| |
| +-----------------------------+------------+ |
| </code></pre><div class="line-numbers" aria-hidden="true"><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div></div></div><p>用于查询的 SQL 语句:</p><div class="language-sql line-numbers-mode" data-ext="sql" data-title="sql"><pre class="language-sql"><code><span class="token keyword">select</span> zscore<span class="token punctuation">(</span>s1<span class="token punctuation">)</span> <span class="token keyword">from</span> root<span class="token punctuation">.</span>test |
| </code></pre><div class="line-numbers" aria-hidden="true"><div class="line-number"></div></div></div><p>输出序列:</p><div class="language-text line-numbers-mode" data-ext="text" data-title="text"><pre class="language-text"><code>+-----------------------------+--------------------+ |
| | Time|zscore(root.test.s1)| |
| +-----------------------------+--------------------+ |
| |1970-01-01T08:00:00.100+08:00|-0.20672455764868078| |
| |1970-01-01T08:00:00.200+08:00|-0.20672455764868078| |
| |1970-01-01T08:00:00.300+08:00| 0.20672455764868078| |
| |1970-01-01T08:00:00.400+08:00| -0.6201736729460423| |
| |1970-01-01T08:00:00.500+08:00|-0.20672455764868078| |
| |1970-01-01T08:00:00.600+08:00|-0.20672455764868078| |
| |1970-01-01T08:00:00.700+08:00| -1.033622788243404| |
| |1970-01-01T08:00:00.800+08:00| 0.6201736729460423| |
| |1970-01-01T08:00:00.900+08:00|-0.20672455764868078| |
| |1970-01-01T08:00:01.000+08:00|-0.20672455764868078| |
| |1970-01-01T08:00:01.100+08:00| 0.20672455764868078| |
| |1970-01-01T08:00:01.200+08:00| -0.6201736729460423| |
| |1970-01-01T08:00:01.300+08:00| -0.6201736729460423| |
| |1970-01-01T08:00:01.400+08:00| 0.20672455764868078| |
| |1970-01-01T08:00:01.500+08:00|-0.20672455764868078| |
| |1970-01-01T08:00:01.600+08:00|-0.20672455764868078| |
| |1970-01-01T08:00:01.700+08:00| 3.9277665953249348| |
| |1970-01-01T08:00:01.800+08:00| 0.6201736729460423| |
| |1970-01-01T08:00:01.900+08:00| -1.033622788243404| |
| |1970-01-01T08:00:02.000+08:00|-0.20672455764868078| |
| +-----------------------------+--------------------+ |
| </code></pre><div class="line-numbers" aria-hidden="true"><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div></div></div></div><!--[--><!----><!--]--><footer class="vp-page-meta"><div class="vp-meta-item edit-link"><a href="https://github.com/apache/iotdb-docs/edit/main/src/zh/UserGuide/V1.0.x/Operators-Functions/Data-Profiling.md" rel="noopener noreferrer" target="_blank" aria-label="发现错误?在 GitHub 上编辑此页" class="nav-link vp-meta-label"><!--[--><svg xmlns="http://www.w3.org/2000/svg" class="icon edit-icon" viewBox="0 0 1024 1024" fill="currentColor" aria-label="edit icon"><path d="M430.818 653.65a60.46 60.46 0 0 1-50.96-93.281l71.69-114.012 7.773-10.365L816.038 80.138A60.46 60.46 0 0 1 859.225 62a60.46 60.46 0 0 1 43.186 18.138l43.186 43.186a60.46 60.46 0 0 1 0 86.373L588.879 565.55l-8.637 8.637-117.466 68.234a60.46 60.46 0 0 1-31.958 11.229z"></path><path d="M728.802 962H252.891A190.883 190.883 0 0 1 62.008 771.98V296.934a190.883 190.883 0 0 1 190.883-192.61h267.754a60.46 60.46 0 0 1 0 120.92H252.891a69.962 69.962 0 0 0-69.098 69.099V771.98a69.962 69.962 0 0 0 69.098 69.098h475.911A69.962 69.962 0 0 0 797.9 771.98V503.363a60.46 60.46 0 1 1 120.922 0V771.98A190.883 190.883 0 0 1 728.802 962z"></path></svg><!--]-->发现错误?在 GitHub 上编辑此页<span><svg class="external-link-icon" 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"><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="external-link-icon-sr-only">open in new window</span></span><!----></a></div><div class="vp-meta-item git-info"><div class="update-time"><span class="vp-meta-label">上次编辑于: </span><!----></div><!----></div></footer><nav class="vp-page-nav"><a class="route-link nav-link prev" href="/zh/UserGuide/V1.0.x/Operators-Functions/Lambda.html" aria-label="Lambda 表达式"><div class="hint"><span class="arrow start"></span>上一页</div><div class="link"><!---->Lambda 表达式</div></a><a class="route-link nav-link next" href="/zh/UserGuide/V1.0.x/Operators-Functions/Anomaly-Detection.html" aria-label="异常检测"><div class="hint">下一页<span class="arrow end"></span></div><div class="link">异常检测<!----></div></a></nav><!----><!--[--><!----><!--]--><!--]--></main><!--]--><footer style="padding-bottom:2rem;"><span id="doc-version" style="display:none;">rel/1.0</span><p style="text-align:center;color:#909399;font-size:12px;margin:0 30px;">Copyright © 2024 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:#909399;font-size:12px;margin:0 30px;"><strong>Have a question?</strong> Connect with us on QQ, WeChat, or Slack. <a href="https://github.com/apache/iotdb/issues/1995">Join the community</a> now.</p></footer></div><!--]--><!--]--><!--[--><!----><!--]--><!--]--></div> |
| <script type="module" src="/assets/app-DrPcRZG6.js" defer></script> |
| </body> |
| </html> |