zh/UserGuide/dev-1.3/AI-capability/AINode_apache.html - iotdb-website - Git at Google

 <!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.26" />
     <meta name="theme" content="VuePress Theme Hope 2.0.0-rc.99" />
     <style>
       :root {
         --vp-c-bg: #fff;
       }

       [data-theme="dark"] {
         --vp-c-bg: #1b1b1f;
       }

       html,
       body {
         background: var(--vp-c-bg);
       }
     </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>
     <script type="application/ld+json">{"@context":"https://schema.org","@type":"Article","headline":"AINode","image":["https://iotdb.apache.org/img/h1.png","https://iotdb.apache.org/img/AINode-call1.png","https://iotdb.apache.org/img/AINode-call2.png","https://iotdb.apache.org/img/AINode-call3.png","https://iotdb.apache.org/img/AINode-analysis1.png","https://iotdb.apache.org/img/AINode-analysis2.png","https://iotdb.apache.org/img/s6.png"],"dateModified":"2025-07-24T02:05:38.000Z","author":[]}</script><meta property="og:url" content="https://iotdb.apache.org/zh/UserGuide/dev-1.3/AI-capability/AINode_apache.html"><meta property="og:site_name" content="IoTDB Website"><meta property="og:title" content="AINode"><meta property="og:description" content="AINode AINode 是支持时序相关模型注册、管理、调用的 IoTDB 原生节点，内置业界领先的自研时序大模型，如清华自研时序模型 Timer 系列，可通过标准 SQL 语句进行调用，实现时序数据的毫秒级实时推理，可支持时序趋势预测、缺失值填补、异常值检测等应用场景。 系统架构如下图所示： 三种节点的职责如下： ConfigNode：负责保存和管..."><meta property="og:type" content="article"><meta property="og:image" content="https://iotdb.apache.org/img/h1.png"><meta property="og:locale" content="zh-CN"><meta property="og:locale:alternate" content="en-US"><meta property="og:updated_time" content="2025-07-24T02:05:38.000Z"><meta property="article:modified_time" content="2025-07-24T02:05:38.000Z"><link rel="alternate" hreflang="en-us" href="https://iotdb.apache.org/UserGuide/dev-1.3/AI-capability/AINode_apache.html"><script async src="https://widget.kapa.ai/kapa-widget.bundle.js" data-website-id="2d37bfdd-8d98-40ba-9223-9d4f81bfb327" data-project-name="Apache IoTDB" data-project-color="#FFFFFF" data-button-z-index="1999" data-button-padding="4px" data-button-border-radius="4px" data-button-image-height="24px" data-button-image-width="20px" data-button-text-color="#9E2878" data-project-logo="https://iotdb.apache.org/img/logo.svg" data-button-position-right="16px" data-button-position-bottom="8px" data-button-height="56px" data-button-width="48px" data-button-text="Ask" data-modal-override-open-selector="#custom-ask-ai-button" data-modal-image-width="150px" data-modal-title="AI Docs" data-modal-title-color="#9E2878" data-deep-thinking-button-active-bg-color="#F6F7F8" data-deep-thinking-button-active-text-color="#9E2878" data-deep-thinking-button-active-hover-text-color="#9E2878" data-modal-disclaimer="这是一个针对 Apache IoTDB 的定制化大型语言模型，能够访问所有[文档](iotdb.apache.org/docs/)、[GitHub 公开问题、PR 和自述文件](github.com/apache/iotdb)。&#10;&#10;

 如果您遇到 <Error in verifying browser for feedback submission. Captcha token could not be obtained.> 请确保您能够顺畅访问 Google 服务。" data-user-analytics-fingerprint-enabled="true" data-consent-required="true" data-consent-screen-disclaimer="点击<I agree, let's chat>即表示您同意按照 kapa.ai 的[隐私政策](https://www.kapa.ai/content/privacy-policy)使用 AI 助手。本服务使用 reCAPTCHA，您需要同意 Google 的[隐私政策](https://policies.google.com/privacy)和[服务条款](https://policies.google.com/terms)。继续操作即表示您明确同意 kapa.ai 和 Google 的隐私政策。" data-language="zh"></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>AINode | IoTDB Website</title><meta name="description" content="AINode AINode 是支持时序相关模型注册、管理、调用的 IoTDB 原生节点，内置业界领先的自研时序大模型，如清华自研时序模型 Timer 系列，可通过标准 SQL 语句进行调用，实现时序数据的毫秒级实时推理，可支持时序趋势预测、缺失值填补、异常值检测等应用场景。 系统架构如下图所示： 三种节点的职责如下： ConfigNode：负责保存和管...">
     <link rel="preload" href="/assets/style-JraSdRX4.css" as="style"><link rel="stylesheet" href="/assets/style-JraSdRX4.css">
     <link rel="modulepreload" href="/assets/app-pmkzp6TS.js"><link rel="modulepreload" href="/assets/AINode_apache.html-Bdb27PY7.js"><link rel="modulepreload" href="/assets/h4-DhwlZhdJ.js"><link rel="modulepreload" href="/assets/h1--kWlCRPe.js"><link rel="modulepreload" href="/assets/h3-Cm68n1gp.js"><link rel="modulepreload" href="/assets/s6-CiE-58wv.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 external-link-icon has-toc" vp-container><!--[--><header id="navbar" class="vp-navbar" vp-navbar><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/" aria-label="带我回家"><img class="vp-nav-logo" src="/logo.png" alt><!----><!----></a><!--]--></div><div class="vp-navbar-center"><!--[--><!--]--></div><div class="vp-navbar-end"><!--[--><!--[--><div id="docsearch-container" style="display:none;"></div><div class="docsearch-placeholder"><button type="button" aria-label="搜索文档" aria-keyshortcuts="Control+k" class="DocSearch DocSearch-Button"><span class="DocSearch-Button-Container"><svg width="20" height="20" viewBox="0 0 24 24" aria-hidden="true" class="DocSearch-Search-Icon"><circle cx="11" cy="11" r="8" stroke="currentColor" fill="none" stroke-width="1.4"></circle><path d="m21 21-4.3-4.3" stroke="currentColor" fill="none" 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 DocSearch-Button-Key--ctrl">Ctrl</kbd><kbd class="DocSearch-Button-Key">K</kbd></span></button></div><!--]--><div><button id="custom-ask-ai-button"> ✨ Ask AI </button></div><nav class="vp-nav-links"><div class="vp-nav-item hide-in-mobile"><div class="vp-dropdown-wrapper"><button type="button" class="vp-dropdown-title" aria-label="文档"><!--[--><!---->文档<!--]--><span class="arrow"></span><ul class="vp-dropdown"><li class="vp-dropdown-item"><a class="route-link auto-link" href="/zh/UserGuide/latest/QuickStart/QuickStart_apache.html" aria-label="v2.0.x"><!---->v2.0.x<!----></a></li><li class="vp-dropdown-item"><a class="route-link auto-link" href="/zh/UserGuide/V1.3.x/QuickStart/QuickStart_apache.html" aria-label="v1.3.x"><!---->v1.3.x<!----></a></li><li class="vp-dropdown-item"><a class="route-link auto-link" href="/zh/UserGuide/V1.2.x/QuickStart/QuickStart.html" aria-label="v1.2.x"><!---->v1.2.x<!----></a></li><li class="vp-dropdown-item"><a class="route-link auto-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 class="auto-link external-link" href="https://cwiki.apache.org/confluence/pages/viewpage.action?pageId=177051872" aria-label="系统设计" rel="noopener noreferrer" target="_blank"><!---->系统设计<!----></a></div><div class="vp-nav-item hide-in-mobile"><a class="route-link auto-link" href="/zh/Download/" aria-label="下载"><!---->下载<!----></a></div><div class="vp-nav-item hide-in-mobile"><div class="vp-dropdown-wrapper"><button type="button" class="vp-dropdown-title" aria-label="社区"><!--[--><!---->社区<!--]--><span class="arrow"></span><ul class="vp-dropdown"><li class="vp-dropdown-item"><a class="route-link auto-link" href="/zh/Community/About.html" aria-label="关于社区"><!---->关于社区<!----></a></li><li class="vp-dropdown-item"><a class="route-link auto-link" href="/zh/Community/Development-Guide.html" aria-label="贡献指南"><!---->贡献指南<!----></a></li><li class="vp-dropdown-item"><a class="route-link auto-link" href="/zh/Community/Community-Partners.html" aria-label="社区伙伴"><!---->社区伙伴<!----></a></li><li class="vp-dropdown-item"><a class="route-link auto-link" href="/zh/Community/Feedback.html" aria-label="交流与反馈"><!---->交流与反馈<!----></a></li><li class="vp-dropdown-item"><a class="route-link auto-link" href="/zh/Community/Events-and-Reports.html" aria-label="活动与报告"><!---->活动与报告<!----></a></li><li class="vp-dropdown-item"><a class="route-link auto-link" href="/zh/Community/Committers.html" aria-label="Committers"><!---->Committers<!----></a></li></ul></button></div></div><div class="vp-nav-item hide-in-mobile"><div class="vp-dropdown-wrapper"><button type="button" class="vp-dropdown-title" aria-label="ASF"><!--[--><!---->ASF<!--]--><span class="arrow"></span><ul class="vp-dropdown"><li class="vp-dropdown-item"><a class="auto-link external-link" href="https://www.apache.org/" aria-label="基金会" rel="noopener noreferrer" target="_blank"><!---->基金会<!----></a></li><li class="vp-dropdown-item"><a class="auto-link external-link" href="https://www.apache.org/licenses/" aria-label="许可证" rel="noopener noreferrer" target="_blank"><!---->许可证<!----></a></li><li class="vp-dropdown-item"><a class="auto-link external-link" href="https://www.apache.org/security/" aria-label="安全" rel="noopener noreferrer" target="_blank"><!---->安全<!----></a></li><li class="vp-dropdown-item"><a class="auto-link external-link" href="https://www.apache.org/foundation/sponsorship.html" aria-label="赞助" rel="noopener noreferrer" target="_blank"><!---->赞助<!----></a></li><li class="vp-dropdown-item"><a class="auto-link external-link" href="https://www.apache.org/foundation/thanks.html" aria-label="致谢" rel="noopener noreferrer" target="_blank"><!---->致谢<!----></a></li><li class="vp-dropdown-item"><a class="auto-link external-link" href="https://www.apache.org/events/current-event" aria-label="活动" rel="noopener noreferrer" target="_blank"><!---->活动<!----></a></li><li class="vp-dropdown-item"><a class="auto-link external-link" href="https://privacy.apache.org/policies/privacy-policy-public.html" aria-label="隐私" rel="noopener noreferrer" target="_blank"><!---->隐私<!----></a></li></ul></button></div></div></nav><div class="vp-nav-item"><div class="vp-dropdown-wrapper"><button type="button" class="vp-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" name="i18n" 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="vp-dropdown"><li class="vp-dropdown-item"><a class="route-link auto-link" href="/UserGuide/dev-1.3/AI-capability/AINode_apache.html" aria-label="English"><!---->English<!----></a></li><li class="vp-dropdown-item"><a class="route-link route-link-active auto-link" href="/zh/UserGuide/dev-1.3/AI-capability/AINode_apache.html" aria-label="简体中文"><!---->简体中文<!----></a></li></ul></button></div></div><div class="vp-nav-item hide-in-mobile"><button type="button" class="vp-color-mode-switch" id="color-mode-switch"><svg xmlns="http://www.w3.org/2000/svg" class="icon auto-icon" viewBox="0 0 1024 1024" fill="currentColor" aria-label="auto icon" name="auto" 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" name="dark" 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" name="light" 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" name="github" 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" vp-sidebar><!--[--><p class="vp-sidebar-header iotdb-sidebar-header"><span class="vp-sidebar-title"></span></p><!----><!--]--><ul class="vp-sidebar-links"></ul><!----></aside><!--[--><main id="main-content" class="vp-page"><!--[--><!----><!----><nav class="vp-breadcrumb disable"></nav><div class="vp-page-title"><h1><!---->AINode</h1><div class="page-info"><!----><!----><span class="page-date-info" aria-label="写作日期📅" data-balloon-pos="up"><svg xmlns="http://www.w3.org/2000/svg" class="icon calendar-icon" viewBox="0 0 1024 1024" fill="currentColor" aria-label="calendar icon" name="calendar"><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 data-allow-mismatch="text">2023/12/14</span><meta property="datePublished" content="2023-12-14T10:50:46.000Z"></span><!----><span class="page-reading-time-info" aria-label="阅读时间⌛" data-balloon-pos="up"><svg xmlns="http://www.w3.org/2000/svg" class="icon timer-icon" viewBox="0 0 1024 1024" fill="currentColor" aria-label="timer icon" name="timer"><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>大约 20 分钟</span><meta property="timeRequired" content="PT20M"></span><!----><!----></div><hr></div><!----><div class="" vp-content><!----><div id="markdown-content"><h1 id="ainode" tabindex="-1"><a class="header-anchor" href="#ainode"><span>AINode</span></a></h1><p>AINode 是支持时序相关模型注册、管理、调用的 IoTDB 原生节点，内置业界领先的自研时序大模型，如清华自研时序模型 Timer 系列，可通过标准 SQL 语句进行调用，实现时序数据的毫秒级实时推理，可支持时序趋势预测、缺失值填补、异常值检测等应用场景。</p><p>系统架构如下图所示：</p><div style="text-align:center;"><img src="/img/h4.png" style="zoom:50%;"></div><p>三种节点的职责如下：</p><ul><li><strong>ConfigNode</strong>：负责保存和管理模型的元信息；负责分布式节点管理。</li><li><strong>DataNode</strong>：负责接收并解析用户的 SQL请求；负责存储时间序列数据；负责数据的预处理计算。</li><li><strong>AINode</strong>：负责模型文件的导入创建以及模型推理。</li></ul><h2 id="_1-优势特点" tabindex="-1"><a class="header-anchor" href="#_1-优势特点"><span>1. 优势特点</span></a></h2><p>与单独构建机器学习服务相比，具有以下优势：</p><ul><li><p><strong>简单易用</strong>：无需使用 Python 或 Java 编程，使用 SQL 语句即可完成机器学习模型管理与推理的完整流程。如创建模型可使用CREATE MODEL语句、使用模型进行推理可使用CALL INFERENCE(...)语句等，使用更加简单便捷。</p></li><li><p><strong>避免数据迁移</strong>：使用 IoTDB 原生机器学习可以将存储在 IoTDB 中的数据直接应用于机器学习模型的推理，无需将数据移动到单独的机器学习服务平台，从而加速数据处理、提高安全性并降低成本。</p></li></ul><figure><img src="/img/h1.png" alt="" tabindex="0" loading="lazy"><figcaption></figcaption></figure><ul><li><strong>内置先进算法</strong>：支持业内领先机器学习分析算法，覆盖典型时序分析任务，为时序数据库赋能原生数据分析能力。如： <ul><li><strong>时间序列预测（Time Series Forecasting）</strong>：从过去时间序列中学习变化模式；从而根据给定过去时间的观测值，输出未来序列最可能的预测。</li><li><strong>时序异常检测（Anomaly Detection for Time Series）</strong>：在给定的时间序列数据中检测和识别异常值，帮助发现时间序列中的异常行为。</li><li><strong>时间序列标注（Time Series Annotation）</strong>：为每个数据点或特定时间段添加额外的信息或标记，例如事件发生、异常点、趋势变化等，以便更好地理解和分析数据。</li></ul></li></ul><h2 id="_2-基本概念" tabindex="-1"><a class="header-anchor" href="#_2-基本概念"><span>2. 基本概念</span></a></h2><ul><li><strong>模型（Model）</strong>：机器学习模型，以时序数据作为输入，输出分析任务的结果或决策。模型是AINode 的基本管理单元，支持模型的增（注册）、删、查、用（推理）。</li><li><strong>创建（Create）</strong>: 将外部设计或训练好的模型文件或算法加载到MLNode中，由IoTDB统一管理与使用。</li><li><strong>推理（Inference）</strong>：使用创建的模型在指定时序数据上完成该模型适用的时序分析任务的过程。</li><li><strong>内置能力（Built-in）</strong>：AINode 自带常见时序分析场景（例如预测与异常检测）的机器学习算法或自研模型。</li></ul><div style="text-align:center;"><img src="/img/h3.png" style="zoom:50%;"></div><h2 id="_3-安装部署" tabindex="-1"><a class="header-anchor" href="#_3-安装部署"><span>3. 安装部署</span></a></h2><p>AINode 的部署可参考文档 <a class="route-link" href="/zh/UserGuide/dev-1.3/Deployment-and-Maintenance/AINode_Deployment_apache.html#ainode-%E9%83%A8%E7%BD%B2">部署指导</a> 章节。</p><h2 id="_4-使用指导" tabindex="-1"><a class="header-anchor" href="#_4-使用指导"><span>4. 使用指导</span></a></h2><p>AINode 对时序数据相关的深度学习模型提供了模型创建及删除的流程，内置模型无需创建及删除，可直接使用，并且在完成推理后创建的内置模型实例将自动销毁。</p><h3 id="_4-1-注册模型" tabindex="-1"><a class="header-anchor" href="#_4-1-注册模型"><span>4.1 注册模型</span></a></h3><p>通过指定模型输入输出的向量维度，可以注册训练好的深度学习模型，从而用于模型推理。</p><p>符合以下内容的模型可以注册到AINode中：</p><ol><li>AINode 支持的PyTorch 2.1.0、 2.2.0版本训练的模型，需避免使用2.2.0版本以上的特性。</li><li>AINode支持使用PyTorch JIT存储的模型，模型文件需要包含模型的参数和结构。</li><li>模型输入序列可以包含一列或多列，若有多列，需要和模型能力、模型配置文件对应。</li><li>模型的输入输出维度必须在<code>config.yaml</code>配置文件中明确定义。使用模型时，必须严格按照<code>config.yaml</code>配置文件中定义的输入输出维度。如果输入输出列数不匹配配置文件，将会导致错误。</li></ol><p>下方为模型注册的SQL语法定义。</p><div class="language-sql line-numbers-mode" data-highlighter="shiki" data-ext="sql" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-sql"><span class="line"><span style="color:#C678DD;">create</span><span style="color:#ABB2BF;"> model </span><span style="color:#56B6C2;">&lt;</span><span style="color:#ABB2BF;">model_name</span><span style="color:#56B6C2;">&gt;</span><span style="color:#C678DD;"> using</span><span style="color:#ABB2BF;"> uri </span><span style="color:#56B6C2;">&lt;</span><span style="color:#ABB2BF;">uri</span><span style="color:#56B6C2;">&gt;</span></span></code></pre><div class="line-numbers" aria-hidden="true" style="counter-reset:line-number 0;"><div class="line-number"></div></div></div><p>SQL中参数的具体含义如下：</p><ul><li><p>model_name：模型的全局唯一标识，不可重复。模型名称具备以下约束：</p><ul><li>允许出现标识符 [ 0-9 a-z A-Z _ ] （字母，数字，下划线）</li><li>长度限制为2-64字符</li><li>大小写敏感</li></ul></li><li><p>uri：模型注册文件的资源路径，路径下应包含<strong>模型权重model.pt文件和模型的元数据描述文件config.yaml</strong></p><ul><li><p>模型权重文件：深度学习模型训练完成后得到的权重文件，目前支持pytorch训练得到的.pt文件</p></li><li><p>yaml元数据描述文件：模型注册时需要提供的与模型结构有关的参数，其中必须包含模型的输入输出维度用于模型推理：</p><ul><li><table><thead><tr><th><strong>参数名</strong></th><th><strong>参数描述</strong></th><th><strong>示例</strong></th></tr></thead><tbody><tr><td>input_shape</td><td>模型输入的行列，用于模型推理</td><td>[96,2]</td></tr><tr><td>output_shape</td><td>模型输出的行列，用于模型推理</td><td>[48,2]</td></tr></tbody></table></li><li><p> 除了模型推理外，还可以指定模型输入输出的数据类型：</p></li><li><table><thead><tr><th><strong>参数名</strong></th><th><strong>参数描述</strong></th><th><strong>示例</strong></th></tr></thead><tbody><tr><td>input_type</td><td>模型输入的数据类型</td><td>[&#39;float32&#39;,&#39;float32&#39;]</td></tr><tr><td>output_type</td><td>模型输出的数据类型</td><td>[&#39;float32&#39;,&#39;float32&#39;]</td></tr></tbody></table></li><li><p> 除此之外，可以额外指定备注信息用于在模型管理时进行展示</p></li><li><table><thead><tr><th><strong>参数名</strong></th><th><strong>参数描述</strong></th><th><strong>示例</strong></th></tr></thead><tbody><tr><td>attributes</td><td>可选，用户自行设定的模型备注信息，用于模型展示</td><td>&#39;model_type&#39;: &#39;dlinear&#39;,&#39;kernel_size&#39;: &#39;25&#39;</td></tr></tbody></table></li></ul></li></ul></li></ul><p>除了本地模型文件的注册，还可以通过URI来指定远程资源路径来进行注册，使用开源的模型仓库（例如HuggingFace）。</p><h4 id="示例" tabindex="-1"><a class="header-anchor" href="#示例"><span>示例</span></a></h4><p>在当前的example文件夹下，包含model.pt和config.yaml文件，model.pt为训练得到，config.yaml的内容如下：</p><div class="language-yaml line-numbers-mode" data-highlighter="shiki" data-ext="yaml" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-yaml"><span class="line"><span style="color:#E06C75;">configs</span><span style="color:#ABB2BF;">:                </span></span>
 <span class="line"><span style="color:#7F848E;font-style:italic;">    # 必选项</span></span>
 <span class="line"><span style="color:#E06C75;">    input_shape</span><span style="color:#ABB2BF;">: [</span><span style="color:#D19A66;">96</span><span style="color:#ABB2BF;">, </span><span style="color:#D19A66;">2</span><span style="color:#ABB2BF;">]      </span><span style="color:#7F848E;font-style:italic;"># 表示模型接收的数据为96行x2列</span></span>
 <span class="line"><span style="color:#E06C75;">    output_shape</span><span style="color:#ABB2BF;">: [</span><span style="color:#D19A66;">48</span><span style="color:#ABB2BF;">, </span><span style="color:#D19A66;">2</span><span style="color:#ABB2BF;">]     </span><span style="color:#7F848E;font-style:italic;"># 表示模型输出的数据为48行x2列</span></span>
 <span class="line"><span style="color:#ABB2BF;">    </span></span>
 <span class="line"><span style="color:#7F848E;font-style:italic;">    # 可选项 默认为全部float32，列数为shape对应的列数</span></span>
 <span class="line"><span style="color:#E06C75;">    input_type</span><span style="color:#ABB2BF;">: [</span><span style="color:#98C379;">&quot;int64&quot;</span><span style="color:#ABB2BF;">,</span><span style="color:#98C379;">&quot;int64&quot;</span><span style="color:#ABB2BF;">] </span><span style="color:#7F848E;font-style:italic;">#输入对应的数据类型，需要与输入列数匹配</span></span>
 <span class="line"><span style="color:#E06C75;">    output_type</span><span style="color:#ABB2BF;">: [</span><span style="color:#98C379;">&quot;text&quot;</span><span style="color:#ABB2BF;">,</span><span style="color:#98C379;">&quot;int64&quot;</span><span style="color:#ABB2BF;">] </span><span style="color:#7F848E;font-style:italic;">#输出对应的数据类型，需要与输出列数匹配</span></span>
 <span class="line"></span>
 <span class="line"><span style="color:#E06C75;">attributes</span><span style="color:#ABB2BF;">:           </span><span style="color:#7F848E;font-style:italic;"># 可选项 为用户自定义的备注信息</span></span>
 <span class="line"><span style="color:#98C379;">   &#39;model_type&#39;</span><span style="color:#ABB2BF;">: </span><span style="color:#98C379;">&#39;dlinear&#39;</span></span>
 <span class="line"><span style="color:#98C379;">   &#39;kernel_size&#39;</span><span style="color:#ABB2BF;">: </span><span style="color:#98C379;">&#39;25&#39;</span></span></code></pre><div class="line-numbers" aria-hidden="true" style="counter-reset:line-number 0;"><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="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>指定该文件夹作为加载路径就可以注册该模型</p><div class="language-sql line-numbers-mode" data-highlighter="shiki" data-ext="sql" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-sql"><span class="line"><span style="color:#ABB2BF;">IoTDB</span><span style="color:#56B6C2;">&gt;</span><span style="color:#C678DD;"> create</span><span style="color:#ABB2BF;"> model dlinear_example </span><span style="color:#C678DD;">using</span><span style="color:#ABB2BF;"> uri </span><span style="color:#98C379;">&quot;file://./example&quot;</span></span></code></pre><div class="line-numbers" aria-hidden="true" style="counter-reset:line-number 0;"><div class="line-number"></div></div></div><p>也可以从huggingFace上下载对应的模型文件进行注册</p><div class="language-sql line-numbers-mode" data-highlighter="shiki" data-ext="sql" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-sql"><span class="line"><span style="color:#ABB2BF;">IoTDB</span><span style="color:#56B6C2;">&gt;</span><span style="color:#C678DD;"> create</span><span style="color:#ABB2BF;"> model dlinear_example </span><span style="color:#C678DD;">using</span><span style="color:#ABB2BF;"> uri </span><span style="color:#98C379;">&quot;https://huggingface.com/IoTDBML/dlinear/&quot;</span></span></code></pre><div class="line-numbers" aria-hidden="true" style="counter-reset:line-number 0;"><div class="line-number"></div></div></div><p>SQL执行后会异步进行注册的流程，可以通过模型展示查看模型的注册状态（见模型展示章节），注册成功的耗时主要受到模型文件大小的影响。</p><p>模型注册完成后，就可以通过使用正常查询的方式调用具体函数，进行模型推理。</p><h3 id="_4-2-查看模型" tabindex="-1"><a class="header-anchor" href="#_4-2-查看模型"><span>4.2 查看模型</span></a></h3><p>注册成功的模型可以通过show models指令查询模型的具体信息。其SQL定义如下：</p><div class="language-sql line-numbers-mode" data-highlighter="shiki" data-ext="sql" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-sql"><span class="line"><span style="color:#ABB2BF;">show models</span></span>
 <span class="line"></span>
 <span class="line"><span style="color:#ABB2BF;">show models </span><span style="color:#56B6C2;">&lt;</span><span style="color:#ABB2BF;">model_name</span><span style="color:#56B6C2;">&gt;</span></span></code></pre><div class="line-numbers" aria-hidden="true" style="counter-reset:line-number 0;"><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div></div></div><p>除了直接展示所有模型的信息外，可以指定model id来查看某一具体模型的信息。模型展示的结果中包含如下信息：</p><table><thead><tr><th><strong>ModelId</strong></th><th><strong>State</strong></th><th><strong>Configs</strong></th><th><strong>Attributes</strong></th></tr></thead><tbody><tr><td>模型唯一标识</td><td>模型注册状态(LOADING,ACTIVE,DROPPING)</td><td>InputShape, outputShapeInputTypes, outputTypes</td><td>模型备注信息</td></tr></tbody></table><p>其中，State用于展示当前模型注册的状态，包含以下三个阶段</p><ul><li><strong>LOADING</strong>：已经在configNode中添加对应的模型元信息，正将模型文件传输到AINode节点上</li><li><strong>ACTIVE:</strong> 模型已经设置完成，模型处于可用状态</li><li><strong>DROPPING</strong>：模型删除中，正在从configNode以及AINode处删除模型相关信息</li><li><strong>UNAVAILABLE</strong>: 模型创建失败，可以通过drop model删除创建失败的model_name。</li></ul><h4 id="示例-1" tabindex="-1"><a class="header-anchor" href="#示例-1"><span>示例</span></a></h4><div class="language-sql line-numbers-mode" data-highlighter="shiki" data-ext="sql" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-sql"><span class="line"><span style="color:#ABB2BF;">IoTDB</span><span style="color:#56B6C2;">&gt;</span><span style="color:#ABB2BF;"> show models</span></span>
 <span class="line"></span>
 <span class="line"></span>
 <span class="line"><span style="color:#ABB2BF;">+</span><span style="color:#7F848E;font-style:italic;">---------------------+--------------------------+-----------+----------------------------+-----------------------+</span></span>
 <span class="line"><span style="color:#ABB2BF;">|              ModelId|                 ModelType|      </span><span style="color:#C678DD;">State</span><span style="color:#ABB2BF;">|                     Configs|                  Notes|</span></span>
 <span class="line"><span style="color:#ABB2BF;">+</span><span style="color:#7F848E;font-style:italic;">---------------------+--------------------------+-----------+----------------------------+-----------------------+</span></span>
 <span class="line"><span style="color:#ABB2BF;">|      dlinear_example|              USER_DEFINED|     ACTIVE|           inputShape:</span><span style="color:#E06C75;">[96,2]</span><span style="color:#ABB2BF;">|                       |</span></span>
 <span class="line"><span style="color:#ABB2BF;">|                     |                          |           |          outputShape:</span><span style="color:#E06C75;">[48,2]</span><span style="color:#ABB2BF;">|                       |</span></span>
 <span class="line"><span style="color:#ABB2BF;">|                     |                          |           | inputDataType:</span><span style="color:#E06C75;">[float,float]</span><span style="color:#ABB2BF;">|                       |</span></span>
 <span class="line"><span style="color:#ABB2BF;">|                     |                          |           |outputDataType:</span><span style="color:#E06C75;">[float,float]</span><span style="color:#ABB2BF;">|                       | </span></span>
 <span class="line"><span style="color:#ABB2BF;">|       _STLForecaster|         BUILT_IN_FORECAST|     ACTIVE|                            |Built-</span><span style="color:#C678DD;">in</span><span style="color:#ABB2BF;"> model </span><span style="color:#C678DD;">in</span><span style="color:#ABB2BF;"> IoTDB|</span></span>
 <span class="line"><span style="color:#ABB2BF;">|     _NaiveForecaster|         BUILT_IN_FORECAST|     ACTIVE|                            |Built-</span><span style="color:#C678DD;">in</span><span style="color:#ABB2BF;"> model </span><span style="color:#C678DD;">in</span><span style="color:#ABB2BF;"> IoTDB|</span></span>
 <span class="line"><span style="color:#ABB2BF;">|               _ARIMA|         BUILT_IN_FORECAST|     ACTIVE|                            |Built-</span><span style="color:#C678DD;">in</span><span style="color:#ABB2BF;"> model </span><span style="color:#C678DD;">in</span><span style="color:#ABB2BF;"> IoTDB|</span></span>
 <span class="line"><span style="color:#ABB2BF;">|_ExponentialSmoothing|         BUILT_IN_FORECAST|     ACTIVE|                            |Built-</span><span style="color:#C678DD;">in</span><span style="color:#ABB2BF;"> model </span><span style="color:#C678DD;">in</span><span style="color:#ABB2BF;"> IoTDB|</span></span>
 <span class="line"><span style="color:#ABB2BF;">|         _GaussianHMM|BUILT_IN_ANOMALY_DETECTION|     ACTIVE|                            |Built-</span><span style="color:#C678DD;">in</span><span style="color:#ABB2BF;"> model </span><span style="color:#C678DD;">in</span><span style="color:#ABB2BF;"> IoTDB|</span></span>
 <span class="line"><span style="color:#ABB2BF;">|              _GMMHMM|BUILT_IN_ANOMALY_DETECTION|     ACTIVE|                            |Built-</span><span style="color:#C678DD;">in</span><span style="color:#ABB2BF;"> model </span><span style="color:#C678DD;">in</span><span style="color:#ABB2BF;"> IoTDB|</span></span>
 <span class="line"><span style="color:#ABB2BF;">|               _Stray|BUILT_IN_ANOMALY_DETECTION|     ACTIVE|                            |Built-</span><span style="color:#C678DD;">in</span><span style="color:#ABB2BF;"> model </span><span style="color:#C678DD;">in</span><span style="color:#ABB2BF;"> IoTDB|</span></span>
 <span class="line"><span style="color:#ABB2BF;">+</span><span style="color:#7F848E;font-style:italic;">---------------------+--------------------------+-----------+------------------------------------------------------------+-----------------------+</span></span></code></pre><div class="line-numbers" aria-hidden="true" style="counter-reset:line-number 0;"><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="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>我们前面已经注册了对应的模型，可以通过对应的指定查看模型状态，active表明模型注册成功，可用于推理。</p><h3 id="_4-3-删除模型" tabindex="-1"><a class="header-anchor" href="#_4-3-删除模型"><span>4.3 删除模型</span></a></h3><p>对于注册成功的模型，用户可以通过SQL进行删除。该操作除了删除configNode上的元信息外，还会删除所有AINode下的相关模型文件。其SQL如下：</p><div class="language-sql line-numbers-mode" data-highlighter="shiki" data-ext="sql" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-sql"><span class="line"><span style="color:#C678DD;">drop</span><span style="color:#ABB2BF;"> model </span><span style="color:#56B6C2;">&lt;</span><span style="color:#ABB2BF;">model_name</span><span style="color:#56B6C2;">&gt;</span></span></code></pre><div class="line-numbers" aria-hidden="true" style="counter-reset:line-number 0;"><div class="line-number"></div></div></div><p>需要指定已经成功注册的模型model_name来删除对应的模型。由于模型删除涉及多个节点上的数据删除，操作不会立即完成，此时模型的状态为DROPPING，该状态的模型不能用于模型推理。</p><h3 id="_4-4-使用内置模型推理" tabindex="-1"><a class="header-anchor" href="#_4-4-使用内置模型推理"><span>4.4 使用内置模型推理</span></a></h3><p>SQL语法如下：</p><div class="language-sql line-numbers-mode" data-highlighter="shiki" data-ext="sql" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-sql"><span class="line"><span style="color:#C678DD;">call</span><span style="color:#ABB2BF;"> inference(</span><span style="color:#56B6C2;">&lt;</span><span style="color:#ABB2BF;">built_in_model_name</span><span style="color:#56B6C2;">&gt;</span><span style="color:#ABB2BF;">,</span><span style="color:#C678DD;">sql</span><span style="color:#E06C75;">[,&lt;parameterName&gt;=&lt;parameterValue&gt;]</span><span style="color:#ABB2BF;">)</span></span></code></pre><div class="line-numbers" aria-hidden="true" style="counter-reset:line-number 0;"><div class="line-number"></div></div></div><p>内置模型推理无需注册流程，通过call关键字，调用inference函数就可以使用模型的推理功能，其对应的参数介绍如下：</p><ul><li><strong>built_in_model_name:</strong> 内置模型名称</li><li><strong>parameterName</strong>：参数名</li><li><strong>parameterValue</strong>：参数值</li></ul><h4 id="内置模型及参数说明" tabindex="-1"><a class="header-anchor" href="#内置模型及参数说明"><span>内置模型及参数说明</span></a></h4><p>目前已内置如下机器学习模型，具体参数说明请参考以下链接。</p><table><thead><tr><th>模型</th><th>built_in_model_name</th><th>任务类型</th><th>参数说明</th></tr></thead><tbody><tr><td>Arima</td><td>_Arima</td><td>预测</td><td><a href="https://www.sktime.net/en/latest/api_reference/auto_generated/sktime.forecasting.arima.ARIMA.html?highlight=Arima" target="_blank" rel="noopener noreferrer">Arima参数说明</a></td></tr><tr><td>STLForecaster</td><td>_STLForecaster</td><td>预测</td><td><a href="https://www.sktime.net/en/latest/api_reference/auto_generated/sktime.forecasting.trend.STLForecaster.html#sktime.forecasting.trend.STLForecaster" target="_blank" rel="noopener noreferrer">STLForecaster参数说明</a></td></tr><tr><td>NaiveForecaster</td><td>_NaiveForecaster</td><td>预测</td><td><a href="https://www.sktime.net/en/latest/api_reference/auto_generated/sktime.forecasting.naive.NaiveForecaster.html#naiveforecaster" target="_blank" rel="noopener noreferrer">NaiveForecaster参数说明</a></td></tr><tr><td>ExponentialSmoothing</td><td>_ExponentialSmoothing</td><td>预测</td><td><a href="https://www.sktime.net/en/latest/api_reference/auto_generated/sktime.forecasting.exp_smoothing.ExponentialSmoothing.html" target="_blank" rel="noopener noreferrer">ExponentialSmoothing参数说明</a></td></tr><tr><td>GaussianHMM</td><td>_GaussianHMM</td><td>标注</td><td><a href="https://www.sktime.net/en/latest/api_reference/auto_generated/sktime.annotation.hmm_learn.gaussian.GaussianHMM.html" target="_blank" rel="noopener noreferrer">GaussianHMM参数说明</a></td></tr><tr><td>GMMHMM</td><td>_GMMHMM</td><td>标注</td><td><a href="https://www.sktime.net/en/latest/api_reference/auto_generated/sktime.annotation.hmm_learn.gmm.GMMHMM.html" target="_blank" rel="noopener noreferrer">GMMHMM参数说明</a></td></tr><tr><td>Stray</td><td>_Stray</td><td>异常检测</td><td><a href="https://www.sktime.net/en/latest/api_reference/auto_generated/sktime.annotation.stray.STRAY.html" target="_blank" rel="noopener noreferrer">Stray参数说明</a></td></tr></tbody></table><h4 id="示例-2" tabindex="-1"><a class="header-anchor" href="#示例-2"><span>示例</span></a></h4><p>下面是使用内置模型推理的一个操作示例，使用内置的Stray模型进行异常检测算法，输入为<code>[144,1]</code>，输出为<code>[144,1]</code>，我们通过SQL使用其进行推理。</p><div class="language-sql line-numbers-mode" data-highlighter="shiki" data-ext="sql" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-sql"><span class="line"><span style="color:#ABB2BF;">IoTDB</span><span style="color:#56B6C2;">&gt;</span><span style="color:#C678DD;"> select</span><span style="color:#ABB2BF;"> * </span><span style="color:#C678DD;">from</span><span style="color:#D19A66;"> root</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">eg</span><span style="color:#ABB2BF;">.airline</span></span>
 <span class="line"><span style="color:#ABB2BF;">+</span><span style="color:#7F848E;font-style:italic;">-----------------------------+------------------+</span></span>
 <span class="line"><span style="color:#ABB2BF;">|                         </span><span style="color:#C678DD;">Time</span><span style="color:#ABB2BF;">|</span><span style="color:#D19A66;">root</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">eg</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">airline</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">s0</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#ABB2BF;">+</span><span style="color:#7F848E;font-style:italic;">-----------------------------+------------------+</span></span>
 <span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#D19A66;">1949</span><span style="color:#ABB2BF;">-</span><span style="color:#D19A66;">01</span><span style="color:#ABB2BF;">-31T00:</span><span style="color:#D19A66;">00</span><span style="color:#ABB2BF;">:</span><span style="color:#D19A66;">00</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">000</span><span style="color:#ABB2BF;">+</span><span style="color:#D19A66;">08</span><span style="color:#ABB2BF;">:</span><span style="color:#D19A66;">00</span><span style="color:#ABB2BF;">|             </span><span style="color:#D19A66;">224</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">0</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#D19A66;">1949</span><span style="color:#ABB2BF;">-</span><span style="color:#D19A66;">02</span><span style="color:#ABB2BF;">-28T00:</span><span style="color:#D19A66;">00</span><span style="color:#ABB2BF;">:</span><span style="color:#D19A66;">00</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">000</span><span style="color:#ABB2BF;">+</span><span style="color:#D19A66;">08</span><span style="color:#ABB2BF;">:</span><span style="color:#D19A66;">00</span><span style="color:#ABB2BF;">|             </span><span style="color:#D19A66;">118</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">0</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#D19A66;">1949</span><span style="color:#ABB2BF;">-</span><span style="color:#D19A66;">03</span><span style="color:#ABB2BF;">-31T00:</span><span style="color:#D19A66;">00</span><span style="color:#ABB2BF;">:</span><span style="color:#D19A66;">00</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">000</span><span style="color:#ABB2BF;">+</span><span style="color:#D19A66;">08</span><span style="color:#ABB2BF;">:</span><span style="color:#D19A66;">00</span><span style="color:#ABB2BF;">|             </span><span style="color:#D19A66;">132</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">0</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#D19A66;">1949</span><span style="color:#ABB2BF;">-</span><span style="color:#D19A66;">04</span><span style="color:#ABB2BF;">-30T00:</span><span style="color:#D19A66;">00</span><span style="color:#ABB2BF;">:</span><span style="color:#D19A66;">00</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">000</span><span style="color:#ABB2BF;">+</span><span style="color:#D19A66;">08</span><span style="color:#ABB2BF;">:</span><span style="color:#D19A66;">00</span><span style="color:#ABB2BF;">|             </span><span style="color:#D19A66;">129</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">0</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#ABB2BF;">......</span></span>
 <span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#D19A66;">1960</span><span style="color:#ABB2BF;">-</span><span style="color:#D19A66;">09</span><span style="color:#ABB2BF;">-30T00:</span><span style="color:#D19A66;">00</span><span style="color:#ABB2BF;">:</span><span style="color:#D19A66;">00</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">000</span><span style="color:#ABB2BF;">+</span><span style="color:#D19A66;">08</span><span style="color:#ABB2BF;">:</span><span style="color:#D19A66;">00</span><span style="color:#ABB2BF;">|             </span><span style="color:#D19A66;">508</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">0</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#D19A66;">1960</span><span style="color:#ABB2BF;">-</span><span style="color:#D19A66;">10</span><span style="color:#ABB2BF;">-31T00:</span><span style="color:#D19A66;">00</span><span style="color:#ABB2BF;">:</span><span style="color:#D19A66;">00</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">000</span><span style="color:#ABB2BF;">+</span><span style="color:#D19A66;">08</span><span style="color:#ABB2BF;">:</span><span style="color:#D19A66;">00</span><span style="color:#ABB2BF;">|             </span><span style="color:#D19A66;">461</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">0</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#D19A66;">1960</span><span style="color:#ABB2BF;">-</span><span style="color:#D19A66;">11</span><span style="color:#ABB2BF;">-30T00:</span><span style="color:#D19A66;">00</span><span style="color:#ABB2BF;">:</span><span style="color:#D19A66;">00</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">000</span><span style="color:#ABB2BF;">+</span><span style="color:#D19A66;">08</span><span style="color:#ABB2BF;">:</span><span style="color:#D19A66;">00</span><span style="color:#ABB2BF;">|             </span><span style="color:#D19A66;">390</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">0</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#D19A66;">1960</span><span style="color:#ABB2BF;">-</span><span style="color:#D19A66;">12</span><span style="color:#ABB2BF;">-31T00:</span><span style="color:#D19A66;">00</span><span style="color:#ABB2BF;">:</span><span style="color:#D19A66;">00</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">000</span><span style="color:#ABB2BF;">+</span><span style="color:#D19A66;">08</span><span style="color:#ABB2BF;">:</span><span style="color:#D19A66;">00</span><span style="color:#ABB2BF;">|             </span><span style="color:#D19A66;">432</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">0</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#ABB2BF;">+</span><span style="color:#7F848E;font-style:italic;">-----------------------------+------------------+</span></span>
 <span class="line"><span style="color:#ABB2BF;">Total </span><span style="color:#C678DD;">line</span><span style="color:#C678DD;"> number</span><span style="color:#56B6C2;"> =</span><span style="color:#D19A66;"> 144</span></span>
 <span class="line"></span>
 <span class="line"><span style="color:#ABB2BF;">IoTDB</span><span style="color:#56B6C2;">&gt;</span><span style="color:#C678DD;"> call</span><span style="color:#ABB2BF;"> inference(_Stray, </span><span style="color:#98C379;">&quot;select s0 from root.eg.airline&quot;</span><span style="color:#ABB2BF;">, k</span><span style="color:#56B6C2;">=</span><span style="color:#D19A66;">2</span><span style="color:#ABB2BF;">)</span></span>
 <span class="line"><span style="color:#ABB2BF;">+</span><span style="color:#7F848E;font-style:italic;">-------+</span></span>
 <span class="line"><span style="color:#ABB2BF;">|output0|</span></span>
 <span class="line"><span style="color:#ABB2BF;">+</span><span style="color:#7F848E;font-style:italic;">-------+</span></span>
 <span class="line"><span style="color:#ABB2BF;">|      </span><span style="color:#D19A66;">0</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#ABB2BF;">|      </span><span style="color:#D19A66;">0</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#ABB2BF;">|      </span><span style="color:#D19A66;">0</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#ABB2BF;">|      </span><span style="color:#D19A66;">0</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#ABB2BF;">......</span></span>
 <span class="line"><span style="color:#ABB2BF;">|      </span><span style="color:#D19A66;">1</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#ABB2BF;">|      </span><span style="color:#D19A66;">1</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#ABB2BF;">|      </span><span style="color:#D19A66;">0</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#ABB2BF;">|      </span><span style="color:#D19A66;">0</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#ABB2BF;">|      </span><span style="color:#D19A66;">0</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#ABB2BF;">|      </span><span style="color:#D19A66;">0</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#ABB2BF;">+</span><span style="color:#7F848E;font-style:italic;">-------+</span></span>
 <span class="line"><span style="color:#ABB2BF;">Total </span><span style="color:#C678DD;">line</span><span style="color:#C678DD;"> number</span><span style="color:#56B6C2;"> =</span><span style="color:#D19A66;"> 144</span></span></code></pre><div class="line-numbers" aria-hidden="true" style="counter-reset:line-number 0;"><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="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><h3 id="_4-5-使用深度学习模型推理" tabindex="-1"><a class="header-anchor" href="#_4-5-使用深度学习模型推理"><span>4.5 使用深度学习模型推理</span></a></h3><p>SQL语法如下：</p><div class="language-sql line-numbers-mode" data-highlighter="shiki" data-ext="sql" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-sql"><span class="line"><span style="color:#C678DD;">call</span><span style="color:#ABB2BF;"> inference(</span><span style="color:#56B6C2;">&lt;</span><span style="color:#ABB2BF;">model_name</span><span style="color:#56B6C2;">&gt;</span><span style="color:#ABB2BF;">,</span><span style="color:#C678DD;">sql</span><span style="color:#E06C75;">[,window=&lt;window_function&gt;]</span><span style="color:#ABB2BF;">)</span></span>
 <span class="line"></span>
 <span class="line"></span>
 <span class="line"><span style="color:#ABB2BF;">window_function:</span></span>
 <span class="line"><span style="color:#ABB2BF;">    head(window_size)</span></span>
 <span class="line"><span style="color:#ABB2BF;">    tail(window_size)</span></span>
 <span class="line"><span style="color:#56B6C2;">    count</span><span style="color:#ABB2BF;">(window_size,sliding_step)</span></span></code></pre><div class="line-numbers" aria-hidden="true" style="counter-reset:line-number 0;"><div class="line-number"></div><div class="line-number"></div><div class="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>在完成模型的注册后，通过call关键字，调用inference函数就可以使用模型的推理功能，其对应的参数介绍如下：</p><ul><li><strong>model_name</strong>: 对应一个已经注册的模型</li><li><strong>sql</strong>：sql查询语句，查询的结果作为模型的输入进行模型推理。查询的结果中行列的维度需要与具体模型config中指定的大小相匹配。(这里的sql不建议使用<code>SELECT *</code>子句，因为在IoTDB中，<code>*</code>并不会对列进行排序，因此列的顺序是未定义的，可以使用<code>SELECT s0,s1</code>的方式确保列的顺序符合模型输入的预期)</li><li><strong>window_function</strong>: 推理过程中可以使用的窗口函数，目前提供三种类型的窗口函数用于辅助模型推理： <ul><li><p><strong>head(window_size)</strong>: 获取数据中最前的window_size个点用于模型推理，该窗口可用于数据裁剪<br><img src="/img/AINode-call1.png" alt="" loading="lazy"></p></li><li><p><strong>tail(window_size)</strong>：获取数据中最后的window_size个点用于模型推，该窗口可用于数据裁剪<br><img src="/img/AINode-call2.png" alt="" loading="lazy"></p></li><li><p><strong>count(window_size, sliding_step)</strong>：基于点数的滑动窗口，每个窗口的数据会分别通过模型进行推理，如下图示例所示，window_size为2的窗口函数将输入数据集分为三个窗口，每个窗口分别进行推理运算生成结果。该窗口可用于连续推理<br><img src="/img/AINode-call3.png" alt="" loading="lazy"></p></li></ul></li></ul><p><strong>说明1: window可以用来解决sql查询结果和模型的输入行数要求不一致时的问题，对行进行裁剪。需要注意的是，当列数不匹配或是行数直接少于模型需求时，推理无法进行，会返回错误信息。</strong></p><p><strong>说明2: 在深度学习应用中，经常将时间戳衍生特征（数据中的时间列）作为生成式任务的协变量，一同输入到模型中以提升模型的效果，但是在模型的输出结果中一般不包含时间列。为了保证实现的通用性，模型推理结果只对应模型的真实输出，如果模型不输出时间列，则结果中不会包含。</strong></p><h4 id="示例-3" tabindex="-1"><a class="header-anchor" href="#示例-3"><span>示例</span></a></h4><p>下面是使用深度学习模型推理的一个操作示例，针对上面提到的输入为<code>[96,2]</code>，输出为<code>[48,2]</code>的<code>dlinear</code>预测模型，我们通过SQL使用其进行推理。</p><div class="language-shell line-numbers-mode" data-highlighter="shiki" data-ext="shell" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-shell"><span class="line"><span style="color:#61AFEF;">IoTDB</span><span style="color:#ABB2BF;">&gt; </span><span style="color:#98C379;">select</span><span style="color:#98C379;"> s1,s2</span><span style="color:#98C379;"> from</span><span style="color:#98C379;"> root.</span><span style="color:#E5C07B;">**</span></span>
 <span class="line"><span style="color:#61AFEF;">+-----------------------------+-------------------+-------------------+</span></span>
 <span class="line"><span style="color:#ABB2BF;">|                         </span><span style="color:#61AFEF;">Time</span><span style="color:#ABB2BF;">|    </span><span style="color:#61AFEF;">root.eg.etth.s0</span><span style="color:#ABB2BF;">|    </span><span style="color:#61AFEF;">root.eg.etth.s1</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#61AFEF;">+-----------------------------+-------------------+-------------------+</span></span>
 <span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">1990-01-01T00:00:00.000+08:00</span><span style="color:#ABB2BF;">|             </span><span style="color:#61AFEF;">0.7855</span><span style="color:#ABB2BF;">|              </span><span style="color:#61AFEF;">1.611</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">1990-01-02T00:00:00.000+08:00</span><span style="color:#ABB2BF;">|             </span><span style="color:#61AFEF;">0.7818</span><span style="color:#ABB2BF;">|               </span><span style="color:#61AFEF;">1.61</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">1990-01-03T00:00:00.000+08:00</span><span style="color:#ABB2BF;">|             </span><span style="color:#61AFEF;">0.7867</span><span style="color:#ABB2BF;">|             </span><span style="color:#61AFEF;">1.6293</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">1990-01-04T00:00:00.000+08:00</span><span style="color:#ABB2BF;">|              </span><span style="color:#61AFEF;">0.786</span><span style="color:#ABB2BF;">|              </span><span style="color:#61AFEF;">1.637</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">1990-01-05T00:00:00.000+08:00</span><span style="color:#ABB2BF;">|             </span><span style="color:#61AFEF;">0.7849</span><span style="color:#ABB2BF;">|              </span><span style="color:#61AFEF;">1.653</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">1990-01-06T00:00:00.000+08:00</span><span style="color:#ABB2BF;">|             </span><span style="color:#61AFEF;">0.7866</span><span style="color:#ABB2BF;">|             </span><span style="color:#61AFEF;">1.6537</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">1990-01-07T00:00:00.000+08:00</span><span style="color:#ABB2BF;">|             </span><span style="color:#61AFEF;">0.7886</span><span style="color:#ABB2BF;">|              </span><span style="color:#61AFEF;">1.662</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#56B6C2;">......</span></span>
 <span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">1990-03-31T00:00:00.000+08:00</span><span style="color:#ABB2BF;">|             </span><span style="color:#61AFEF;">0.7585</span><span style="color:#ABB2BF;">|              </span><span style="color:#61AFEF;">1.678</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">1990-04-01T00:00:00.000+08:00</span><span style="color:#ABB2BF;">|             </span><span style="color:#61AFEF;">0.7587</span><span style="color:#ABB2BF;">|             </span><span style="color:#61AFEF;">1.6763</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">1990-04-02T00:00:00.000+08:00</span><span style="color:#ABB2BF;">|               </span><span style="color:#61AFEF;">0.76</span><span style="color:#ABB2BF;">|             </span><span style="color:#61AFEF;">1.6813</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">1990-04-03T00:00:00.000+08:00</span><span style="color:#ABB2BF;">|             </span><span style="color:#61AFEF;">0.7669</span><span style="color:#ABB2BF;">|              </span><span style="color:#61AFEF;">1.684</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">1990-04-04T00:00:00.000+08:00</span><span style="color:#ABB2BF;">|             </span><span style="color:#61AFEF;">0.7645</span><span style="color:#ABB2BF;">|              </span><span style="color:#61AFEF;">1.677</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">1990-04-05T00:00:00.000+08:00</span><span style="color:#ABB2BF;">|             </span><span style="color:#61AFEF;">0.7625</span><span style="color:#ABB2BF;">|               </span><span style="color:#61AFEF;">1.68</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">1990-04-06T00:00:00.000+08:00</span><span style="color:#ABB2BF;">|             </span><span style="color:#61AFEF;">0.7617</span><span style="color:#ABB2BF;">|             </span><span style="color:#61AFEF;">1.6917</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#61AFEF;">+-----------------------------+-------------------+-------------------+</span></span>
 <span class="line"><span style="color:#61AFEF;">Total</span><span style="color:#98C379;"> line</span><span style="color:#98C379;"> number</span><span style="color:#98C379;"> =</span><span style="color:#D19A66;"> 96</span></span>
 <span class="line"></span>
 <span class="line"><span style="color:#61AFEF;">IoTDB</span><span style="color:#ABB2BF;">&gt; </span><span style="color:#98C379;">call</span><span style="color:#98C379;"> inference</span><span style="color:#ABB2BF;">(</span><span style="color:#61AFEF;">dlinear_example,</span><span style="color:#61AFEF;">&quot;select s0,s1 from root.**&quot;</span><span style="color:#ABB2BF;">)</span></span>
 <span class="line"><span style="color:#61AFEF;">+--------------------------------------------+-----------------------------+</span></span>
 <span class="line"><span style="color:#ABB2BF;">|                                   </span><span style="color:#61AFEF;">_result_0</span><span style="color:#ABB2BF;">|                    </span><span style="color:#61AFEF;">_result_1</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#61AFEF;">+--------------------------------------------+-----------------------------+</span></span>
 <span class="line"><span style="color:#ABB2BF;">|                           </span><span style="color:#61AFEF;">0.726302981376648</span><span style="color:#ABB2BF;">|           </span><span style="color:#61AFEF;">1.6549958229064941</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#ABB2BF;">|                          </span><span style="color:#61AFEF;">0.7354921698570251</span><span style="color:#ABB2BF;">|           </span><span style="color:#61AFEF;">1.6482787370681763</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#ABB2BF;">|                          </span><span style="color:#61AFEF;">0.7238251566886902</span><span style="color:#ABB2BF;">|           </span><span style="color:#61AFEF;">1.6278168201446533</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#56B6C2;">......</span></span>
 <span class="line"><span style="color:#ABB2BF;">|                          </span><span style="color:#61AFEF;">0.7692174911499023</span><span style="color:#ABB2BF;">|            </span><span style="color:#61AFEF;">1.654654049873352</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#ABB2BF;">|                          </span><span style="color:#61AFEF;">0.7685555815696716</span><span style="color:#ABB2BF;">|           </span><span style="color:#61AFEF;">1.6625318765640259</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#ABB2BF;">|                          </span><span style="color:#61AFEF;">0.7856493592262268</span><span style="color:#ABB2BF;">|           </span><span style="color:#61AFEF;">1.6508299350738525</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#61AFEF;">+--------------------------------------------+-----------------------------+</span></span>
 <span class="line"><span style="color:#61AFEF;">Total</span><span style="color:#98C379;"> line</span><span style="color:#98C379;"> number</span><span style="color:#98C379;"> =</span><span style="color:#D19A66;"> 48</span></span></code></pre><div class="line-numbers" aria-hidden="true" style="counter-reset:line-number 0;"><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="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="使用tail-head窗口函数的示例" tabindex="-1"><a class="header-anchor" href="#使用tail-head窗口函数的示例"><span>使用tail/head窗口函数的示例</span></a></h4><p>当数据量不定且想要取96行最新数据用于推理时，可以使用对应的窗口函数tail。head函数的用法与其类似，不同点在于其取的是最早的96个点。</p><div class="language-shell line-numbers-mode" data-highlighter="shiki" data-ext="shell" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-shell"><span class="line"><span style="color:#61AFEF;">IoTDB</span><span style="color:#ABB2BF;">&gt; </span><span style="color:#98C379;">select</span><span style="color:#98C379;"> s1,s2</span><span style="color:#98C379;"> from</span><span style="color:#98C379;"> root.</span><span style="color:#E5C07B;">**</span></span>
 <span class="line"><span style="color:#61AFEF;">+-----------------------------+-------------------+-------------------+</span></span>
 <span class="line"><span style="color:#ABB2BF;">|                         </span><span style="color:#61AFEF;">Time</span><span style="color:#ABB2BF;">|    </span><span style="color:#61AFEF;">root.eg.etth.s0</span><span style="color:#ABB2BF;">|    </span><span style="color:#61AFEF;">root.eg.etth.s1</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#61AFEF;">+-----------------------------+-------------------+-------------------+</span></span>
 <span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">1988-01-01T00:00:00.000+08:00</span><span style="color:#ABB2BF;">|             </span><span style="color:#61AFEF;">0.7355</span><span style="color:#ABB2BF;">|              </span><span style="color:#61AFEF;">1.211</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#56B6C2;">......</span></span>
 <span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">1990-01-01T00:00:00.000+08:00</span><span style="color:#ABB2BF;">|             </span><span style="color:#61AFEF;">0.7855</span><span style="color:#ABB2BF;">|              </span><span style="color:#61AFEF;">1.611</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">1990-01-02T00:00:00.000+08:00</span><span style="color:#ABB2BF;">|             </span><span style="color:#61AFEF;">0.7818</span><span style="color:#ABB2BF;">|               </span><span style="color:#61AFEF;">1.61</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">1990-01-03T00:00:00.000+08:00</span><span style="color:#ABB2BF;">|             </span><span style="color:#61AFEF;">0.7867</span><span style="color:#ABB2BF;">|             </span><span style="color:#61AFEF;">1.6293</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">1990-01-04T00:00:00.000+08:00</span><span style="color:#ABB2BF;">|              </span><span style="color:#61AFEF;">0.786</span><span style="color:#ABB2BF;">|              </span><span style="color:#61AFEF;">1.637</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">1990-01-05T00:00:00.000+08:00</span><span style="color:#ABB2BF;">|             </span><span style="color:#61AFEF;">0.7849</span><span style="color:#ABB2BF;">|              </span><span style="color:#61AFEF;">1.653</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">1990-01-06T00:00:00.000+08:00</span><span style="color:#ABB2BF;">|             </span><span style="color:#61AFEF;">0.7866</span><span style="color:#ABB2BF;">|             </span><span style="color:#61AFEF;">1.6537</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">1990-01-07T00:00:00.000+08:00</span><span style="color:#ABB2BF;">|             </span><span style="color:#61AFEF;">0.7886</span><span style="color:#ABB2BF;">|              </span><span style="color:#61AFEF;">1.662</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#56B6C2;">......</span></span>
 <span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">1990-03-31T00:00:00.000+08:00</span><span style="color:#ABB2BF;">|             </span><span style="color:#61AFEF;">0.7585</span><span style="color:#ABB2BF;">|              </span><span style="color:#61AFEF;">1.678</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">1990-04-01T00:00:00.000+08:00</span><span style="color:#ABB2BF;">|             </span><span style="color:#61AFEF;">0.7587</span><span style="color:#ABB2BF;">|             </span><span style="color:#61AFEF;">1.6763</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">1990-04-02T00:00:00.000+08:00</span><span style="color:#ABB2BF;">|               </span><span style="color:#61AFEF;">0.76</span><span style="color:#ABB2BF;">|             </span><span style="color:#61AFEF;">1.6813</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">1990-04-03T00:00:00.000+08:00</span><span style="color:#ABB2BF;">|             </span><span style="color:#61AFEF;">0.7669</span><span style="color:#ABB2BF;">|              </span><span style="color:#61AFEF;">1.684</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">1990-04-04T00:00:00.000+08:00</span><span style="color:#ABB2BF;">|             </span><span style="color:#61AFEF;">0.7645</span><span style="color:#ABB2BF;">|              </span><span style="color:#61AFEF;">1.677</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">1990-04-05T00:00:00.000+08:00</span><span style="color:#ABB2BF;">|             </span><span style="color:#61AFEF;">0.7625</span><span style="color:#ABB2BF;">|               </span><span style="color:#61AFEF;">1.68</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">1990-04-06T00:00:00.000+08:00</span><span style="color:#ABB2BF;">|             </span><span style="color:#61AFEF;">0.7617</span><span style="color:#ABB2BF;">|             </span><span style="color:#61AFEF;">1.6917</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#61AFEF;">+-----------------------------+-------------------+-------------------+</span></span>
 <span class="line"><span style="color:#61AFEF;">Total</span><span style="color:#98C379;"> line</span><span style="color:#98C379;"> number</span><span style="color:#98C379;"> =</span><span style="color:#D19A66;"> 996</span></span>
 <span class="line"></span>
 <span class="line"><span style="color:#61AFEF;">IoTDB</span><span style="color:#ABB2BF;">&gt; </span><span style="color:#98C379;">call</span><span style="color:#98C379;"> inference</span><span style="color:#ABB2BF;">(</span><span style="color:#61AFEF;">dlinear_example,</span><span style="color:#61AFEF;">&quot;select s0,s1 from root.**&quot;</span><span style="color:#61AFEF;">,window</span><span style="color:#98C379;">=tail</span><span style="color:#ABB2BF;">(</span><span style="color:#98C379;">96</span><span style="color:#ABB2BF;">))</span></span>
 <span class="line"><span style="color:#61AFEF;">+--------------------------------------------+-----------------------------+</span></span>
 <span class="line"><span style="color:#ABB2BF;">|                                   </span><span style="color:#61AFEF;">_result_0</span><span style="color:#ABB2BF;">|                    </span><span style="color:#61AFEF;">_result_1</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#61AFEF;">+--------------------------------------------+-----------------------------+</span></span>
 <span class="line"><span style="color:#ABB2BF;">|                           </span><span style="color:#61AFEF;">0.726302981376648</span><span style="color:#ABB2BF;">|           </span><span style="color:#61AFEF;">1.6549958229064941</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#ABB2BF;">|                          </span><span style="color:#61AFEF;">0.7354921698570251</span><span style="color:#ABB2BF;">|           </span><span style="color:#61AFEF;">1.6482787370681763</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#ABB2BF;">|                          </span><span style="color:#61AFEF;">0.7238251566886902</span><span style="color:#ABB2BF;">|           </span><span style="color:#61AFEF;">1.6278168201446533</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#56B6C2;">......</span></span>
 <span class="line"><span style="color:#ABB2BF;">|                          </span><span style="color:#61AFEF;">0.7692174911499023</span><span style="color:#ABB2BF;">|            </span><span style="color:#61AFEF;">1.654654049873352</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#ABB2BF;">|                          </span><span style="color:#61AFEF;">0.7685555815696716</span><span style="color:#ABB2BF;">|           </span><span style="color:#61AFEF;">1.6625318765640259</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#ABB2BF;">|                          </span><span style="color:#61AFEF;">0.7856493592262268</span><span style="color:#ABB2BF;">|           </span><span style="color:#61AFEF;">1.6508299350738525</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#61AFEF;">+--------------------------------------------+-----------------------------+</span></span>
 <span class="line"><span style="color:#61AFEF;">Total</span><span style="color:#98C379;"> line</span><span style="color:#98C379;"> number</span><span style="color:#98C379;"> =</span><span style="color:#D19A66;"> 48</span></span></code></pre><div class="line-numbers" aria-hidden="true" style="counter-reset:line-number 0;"><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="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="使用count窗口函数的示例" tabindex="-1"><a class="header-anchor" href="#使用count窗口函数的示例"><span>使用count窗口函数的示例</span></a></h4><p>该窗口主要用于计算式任务，当任务对应的模型一次只能处理固定行数据而最终想要的确实多组预测结果时，使用该窗口函数可以使用点数滑动窗口进行连续推理。假设我们现在有一个异常检测模型anomaly_example(input: [24,2], output[1,1])，对每24行数据会生成一个0/1的标签，其使用示例如下：</p><div class="language-shell line-numbers-mode" data-highlighter="shiki" data-ext="shell" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-shell"><span class="line"><span style="color:#61AFEF;">IoTDB</span><span style="color:#ABB2BF;">&gt; </span><span style="color:#98C379;">select</span><span style="color:#98C379;"> s1,s2</span><span style="color:#98C379;"> from</span><span style="color:#98C379;"> root.</span><span style="color:#E5C07B;">**</span></span>
 <span class="line"><span style="color:#61AFEF;">+-----------------------------+-------------------+-------------------+</span></span>
 <span class="line"><span style="color:#ABB2BF;">|                         </span><span style="color:#61AFEF;">Time</span><span style="color:#ABB2BF;">|    </span><span style="color:#61AFEF;">root.eg.etth.s0</span><span style="color:#ABB2BF;">|    </span><span style="color:#61AFEF;">root.eg.etth.s1</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#61AFEF;">+-----------------------------+-------------------+-------------------+</span></span>
 <span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">1990-01-01T00:00:00.000+08:00</span><span style="color:#ABB2BF;">|             </span><span style="color:#61AFEF;">0.7855</span><span style="color:#ABB2BF;">|              </span><span style="color:#61AFEF;">1.611</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">1990-01-02T00:00:00.000+08:00</span><span style="color:#ABB2BF;">|             </span><span style="color:#61AFEF;">0.7818</span><span style="color:#ABB2BF;">|               </span><span style="color:#61AFEF;">1.61</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">1990-01-03T00:00:00.000+08:00</span><span style="color:#ABB2BF;">|             </span><span style="color:#61AFEF;">0.7867</span><span style="color:#ABB2BF;">|             </span><span style="color:#61AFEF;">1.6293</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">1990-01-04T00:00:00.000+08:00</span><span style="color:#ABB2BF;">|              </span><span style="color:#61AFEF;">0.786</span><span style="color:#ABB2BF;">|              </span><span style="color:#61AFEF;">1.637</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">1990-01-05T00:00:00.000+08:00</span><span style="color:#ABB2BF;">|             </span><span style="color:#61AFEF;">0.7849</span><span style="color:#ABB2BF;">|              </span><span style="color:#61AFEF;">1.653</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">1990-01-06T00:00:00.000+08:00</span><span style="color:#ABB2BF;">|             </span><span style="color:#61AFEF;">0.7866</span><span style="color:#ABB2BF;">|             </span><span style="color:#61AFEF;">1.6537</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">1990-01-07T00:00:00.000+08:00</span><span style="color:#ABB2BF;">|             </span><span style="color:#61AFEF;">0.7886</span><span style="color:#ABB2BF;">|              </span><span style="color:#61AFEF;">1.662</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#56B6C2;">......</span></span>
 <span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">1990-03-31T00:00:00.000+08:00</span><span style="color:#ABB2BF;">|             </span><span style="color:#61AFEF;">0.7585</span><span style="color:#ABB2BF;">|              </span><span style="color:#61AFEF;">1.678</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">1990-04-01T00:00:00.000+08:00</span><span style="color:#ABB2BF;">|             </span><span style="color:#61AFEF;">0.7587</span><span style="color:#ABB2BF;">|             </span><span style="color:#61AFEF;">1.6763</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">1990-04-02T00:00:00.000+08:00</span><span style="color:#ABB2BF;">|               </span><span style="color:#61AFEF;">0.76</span><span style="color:#ABB2BF;">|             </span><span style="color:#61AFEF;">1.6813</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">1990-04-03T00:00:00.000+08:00</span><span style="color:#ABB2BF;">|             </span><span style="color:#61AFEF;">0.7669</span><span style="color:#ABB2BF;">|              </span><span style="color:#61AFEF;">1.684</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">1990-04-04T00:00:00.000+08:00</span><span style="color:#ABB2BF;">|             </span><span style="color:#61AFEF;">0.7645</span><span style="color:#ABB2BF;">|              </span><span style="color:#61AFEF;">1.677</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">1990-04-05T00:00:00.000+08:00</span><span style="color:#ABB2BF;">|             </span><span style="color:#61AFEF;">0.7625</span><span style="color:#ABB2BF;">|               </span><span style="color:#61AFEF;">1.68</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">1990-04-06T00:00:00.000+08:00</span><span style="color:#ABB2BF;">|             </span><span style="color:#61AFEF;">0.7617</span><span style="color:#ABB2BF;">|             </span><span style="color:#61AFEF;">1.6917</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#61AFEF;">+-----------------------------+-------------------+-------------------+</span></span>
 <span class="line"><span style="color:#61AFEF;">Total</span><span style="color:#98C379;"> line</span><span style="color:#98C379;"> number</span><span style="color:#98C379;"> =</span><span style="color:#D19A66;"> 96</span></span>
 <span class="line"></span>
 <span class="line"><span style="color:#61AFEF;">IoTDB</span><span style="color:#ABB2BF;">&gt; </span><span style="color:#98C379;">call</span><span style="color:#98C379;"> inference</span><span style="color:#ABB2BF;">(</span><span style="color:#61AFEF;">anomaly_example,</span><span style="color:#61AFEF;">&quot;select s0,s1 from root.**&quot;</span><span style="color:#61AFEF;">,window</span><span style="color:#98C379;">=count</span><span style="color:#ABB2BF;">(</span><span style="color:#98C379;">24,24</span><span style="color:#ABB2BF;">))</span></span>
 <span class="line"><span style="color:#61AFEF;">+-------------------------+</span></span>
 <span class="line"><span style="color:#ABB2BF;">|                </span><span style="color:#61AFEF;">_result_0</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#61AFEF;">+-------------------------+</span></span>
 <span class="line"><span style="color:#ABB2BF;">|                        </span><span style="color:#61AFEF;">0</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#ABB2BF;">|                        </span><span style="color:#61AFEF;">1</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#ABB2BF;">|                        </span><span style="color:#61AFEF;">1</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#ABB2BF;">|                        </span><span style="color:#61AFEF;">0</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#61AFEF;">+-------------------------+</span></span>
 <span class="line"><span style="color:#61AFEF;">Total</span><span style="color:#98C379;"> line</span><span style="color:#98C379;"> number</span><span style="color:#98C379;"> =</span><span style="color:#D19A66;"> 4</span></span></code></pre><div class="line-numbers" aria-hidden="true" style="counter-reset:line-number 0;"><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="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>其中结果集中每行的标签对应每24行数据为一组，输入该异常检测模型后的输出。</p><h2 id="_5-权限管理" tabindex="-1"><a class="header-anchor" href="#_5-权限管理"><span>5. 权限管理</span></a></h2><p>使用AINode相关的功能时，可以使用IoTDB本身的鉴权去做一个权限管理，用户只有在具备 USE_MODEL 权限时，才可以使用模型管理的相关功能。当使用推理功能时，用户需要有访问输入模型的SQL对应的源序列的权限。</p><table><thead><tr><th>权限名称</th><th>权限范围</th><th>管理员用户（默认ROOT）</th><th>普通用户</th><th>路径相关</th></tr></thead><tbody><tr><td>USE_MODEL</td><td>create model / show models / drop model</td><td>√</td><td>√</td><td>x</td></tr><tr><td>READ_DATA</td><td>call inference</td><td>√</td><td>√</td><td>√</td></tr></tbody></table><h2 id="_6-实际案例" tabindex="-1"><a class="header-anchor" href="#_6-实际案例"><span>6. 实际案例</span></a></h2><h3 id="_6-1-电力负载预测" tabindex="-1"><a class="header-anchor" href="#_6-1-电力负载预测"><span>6.1 电力负载预测</span></a></h3><p>在部分工业场景下，会存在预测电力负载的需求，预测结果可用于优化电力供应、节约能源和资源、支持规划和扩展以及增强电力系统的可靠性。</p><p>我们所使用的 ETTh1 的测试集的数据为<a href="/img/ETTh1.csv">ETTh1</a>。</p><p>包含间隔1h采集一次的电力数据，每条数据由负载和油温构成，分别为：High UseFul Load, High UseLess Load, Middle UseLess Load, Low UseFul Load, Low UseLess Load, Oil Temperature。</p><p>在该数据集上，IoTDB-ML的模型推理功能可以通过以往高中低三种负载的数值和对应时间戳油温的关系，预测未来一段时间内的油温，赋能电网变压器的自动调控和监视。</p><h4 id="步骤一-数据导入" tabindex="-1"><a class="header-anchor" href="#步骤一-数据导入"><span>步骤一：数据导入</span></a></h4><p>用户可以使用tools文件夹中的<code>import-csv.sh</code> 向 IoTDB 中导入 ETT 数据集</p><div class="language-bash line-numbers-mode" data-highlighter="shiki" data-ext="bash" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-bash"><span class="line"><span style="color:#61AFEF;">bash</span><span style="color:#98C379;"> ./import-csv.sh</span><span style="color:#D19A66;"> -h</span><span style="color:#D19A66;"> 127.0.0.1</span><span style="color:#D19A66;"> -p</span><span style="color:#D19A66;"> 6667</span><span style="color:#D19A66;"> -u</span><span style="color:#98C379;"> root</span><span style="color:#D19A66;"> -pw</span><span style="color:#98C379;"> root</span><span style="color:#D19A66;"> -f</span><span style="color:#98C379;"> ../../ETTh1.csv</span></span></code></pre><div class="line-numbers" aria-hidden="true" style="counter-reset:line-number 0;"><div class="line-number"></div></div></div><h4 id="步骤二-模型导入" tabindex="-1"><a class="header-anchor" href="#步骤二-模型导入"><span>步骤二：模型导入</span></a></h4><p>我们可以在iotdb-cli 中输入以下SQL从 huggingface 上拉取一个已经训练好的模型进行注册，用于后续的推理。</p><div class="language-sql line-numbers-mode" data-highlighter="shiki" data-ext="sql" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-sql"><span class="line"><span style="color:#C678DD;">create</span><span style="color:#ABB2BF;"> model dlinear </span><span style="color:#C678DD;">using</span><span style="color:#ABB2BF;"> uri </span><span style="color:#98C379;">&#39;https://huggingface.co/hvlgo/dlinear/tree/main&#39;</span></span></code></pre><div class="line-numbers" aria-hidden="true" style="counter-reset:line-number 0;"><div class="line-number"></div></div></div><p>该模型基于较为轻量化的深度模型DLinear训练而得，能够以相对快的推理速度尽可能多地捕捉到序列内部的变化趋势和变量间的数据变化关系，相较于其他更深的模型更适用于快速实时预测。</p><h4 id="步骤三-模型推理" tabindex="-1"><a class="header-anchor" href="#步骤三-模型推理"><span>步骤三：模型推理</span></a></h4><div class="language-shell line-numbers-mode" data-highlighter="shiki" data-ext="shell" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-shell"><span class="line"><span style="color:#61AFEF;">IoTDB</span><span style="color:#ABB2BF;">&gt; </span><span style="color:#98C379;">select</span><span style="color:#98C379;"> s0,s1,s2,s3,s4,s5,s6</span><span style="color:#98C379;"> from</span><span style="color:#98C379;"> root.eg.etth</span><span style="color:#98C379;"> LIMIT</span><span style="color:#D19A66;"> 96</span></span>
 <span class="line"><span style="color:#61AFEF;">+-----------------------------+---------------+---------------+---------------+---------------+---------------+---------------+---------------+</span></span>
 <span class="line"><span style="color:#ABB2BF;">|                         </span><span style="color:#61AFEF;">Time</span><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">root.eg.etth.s0</span><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">root.eg.etth.s1</span><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">root.eg.etth.s2</span><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">root.eg.etth.s3</span><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">root.eg.etth.s4</span><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">root.eg.etth.s5</span><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">root.eg.etth.s6</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#61AFEF;">+-----------------------------+---------------+---------------+---------------+---------------+---------------+---------------+---------------+</span></span>
 <span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">2017-10-20T00:00:00.000+08:00</span><span style="color:#ABB2BF;">|         </span><span style="color:#61AFEF;">10.449</span><span style="color:#ABB2BF;">|          </span><span style="color:#61AFEF;">3.885</span><span style="color:#ABB2BF;">|          </span><span style="color:#61AFEF;">8.706</span><span style="color:#ABB2BF;">|          </span><span style="color:#61AFEF;">2.025</span><span style="color:#ABB2BF;">|          </span><span style="color:#61AFEF;">2.041</span><span style="color:#ABB2BF;">|          </span><span style="color:#61AFEF;">0.944</span><span style="color:#ABB2BF;">|          </span><span style="color:#61AFEF;">8.864</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">2017-10-20T01:00:00.000+08:00</span><span style="color:#ABB2BF;">|         </span><span style="color:#61AFEF;">11.119</span><span style="color:#ABB2BF;">|          </span><span style="color:#61AFEF;">3.952</span><span style="color:#ABB2BF;">|          </span><span style="color:#61AFEF;">8.813</span><span style="color:#ABB2BF;">|           </span><span style="color:#61AFEF;">2.31</span><span style="color:#ABB2BF;">|          </span><span style="color:#61AFEF;">2.071</span><span style="color:#ABB2BF;">|          </span><span style="color:#61AFEF;">1.005</span><span style="color:#ABB2BF;">|          </span><span style="color:#61AFEF;">8.442</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">2017-10-20T02:00:00.000+08:00</span><span style="color:#ABB2BF;">|          </span><span style="color:#61AFEF;">9.511</span><span style="color:#ABB2BF;">|           </span><span style="color:#61AFEF;">2.88</span><span style="color:#ABB2BF;">|          </span><span style="color:#61AFEF;">7.533</span><span style="color:#ABB2BF;">|          </span><span style="color:#61AFEF;">1.564</span><span style="color:#ABB2BF;">|          </span><span style="color:#61AFEF;">1.949</span><span style="color:#ABB2BF;">|          </span><span style="color:#61AFEF;">0.883</span><span style="color:#ABB2BF;">|           </span><span style="color:#61AFEF;">8.16</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">2017-10-20T03:00:00.000+08:00</span><span style="color:#ABB2BF;">|          </span><span style="color:#61AFEF;">9.645</span><span style="color:#ABB2BF;">|           </span><span style="color:#61AFEF;">2.21</span><span style="color:#ABB2BF;">|          </span><span style="color:#61AFEF;">7.249</span><span style="color:#ABB2BF;">|          </span><span style="color:#61AFEF;">1.066</span><span style="color:#ABB2BF;">|          </span><span style="color:#61AFEF;">1.828</span><span style="color:#ABB2BF;">|          </span><span style="color:#61AFEF;">0.914</span><span style="color:#ABB2BF;">|          </span><span style="color:#61AFEF;">7.949</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#56B6C2;">......</span></span>
 <span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">2017-10-23T20:00:00.000+08:00</span><span style="color:#ABB2BF;">|          </span><span style="color:#61AFEF;">8.105</span><span style="color:#ABB2BF;">|          </span><span style="color:#61AFEF;">0.938</span><span style="color:#ABB2BF;">|          </span><span style="color:#61AFEF;">4.371</span><span style="color:#ABB2BF;">|         </span><span style="color:#61AFEF;">-0.569</span><span style="color:#ABB2BF;">|          </span><span style="color:#61AFEF;">3.533</span><span style="color:#ABB2BF;">|          </span><span style="color:#61AFEF;">1.279</span><span style="color:#ABB2BF;">|          </span><span style="color:#61AFEF;">9.708</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">2017-10-23T21:00:00.000+08:00</span><span style="color:#ABB2BF;">|          </span><span style="color:#61AFEF;">7.167</span><span style="color:#ABB2BF;">|          </span><span style="color:#61AFEF;">1.206</span><span style="color:#ABB2BF;">|          </span><span style="color:#61AFEF;">4.087</span><span style="color:#ABB2BF;">|         </span><span style="color:#61AFEF;">-0.462</span><span style="color:#ABB2BF;">|          </span><span style="color:#61AFEF;">3.107</span><span style="color:#ABB2BF;">|          </span><span style="color:#61AFEF;">1.432</span><span style="color:#ABB2BF;">|          </span><span style="color:#61AFEF;">8.723</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">2017-10-23T22:00:00.000+08:00</span><span style="color:#ABB2BF;">|            </span><span style="color:#61AFEF;">7.1</span><span style="color:#ABB2BF;">|           </span><span style="color:#61AFEF;">1.34</span><span style="color:#ABB2BF;">|          </span><span style="color:#61AFEF;">4.015</span><span style="color:#ABB2BF;">|          </span><span style="color:#61AFEF;">-0.32</span><span style="color:#ABB2BF;">|          </span><span style="color:#61AFEF;">2.772</span><span style="color:#ABB2BF;">|           </span><span style="color:#61AFEF;">1.31</span><span style="color:#ABB2BF;">|          </span><span style="color:#61AFEF;">8.864</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">2017-10-23T23:00:00.000+08:00</span><span style="color:#ABB2BF;">|          </span><span style="color:#61AFEF;">9.176</span><span style="color:#ABB2BF;">|          </span><span style="color:#61AFEF;">2.746</span><span style="color:#ABB2BF;">|          </span><span style="color:#61AFEF;">7.107</span><span style="color:#ABB2BF;">|          </span><span style="color:#61AFEF;">1.635</span><span style="color:#ABB2BF;">|           </span><span style="color:#61AFEF;">2.65</span><span style="color:#ABB2BF;">|          </span><span style="color:#61AFEF;">1.097</span><span style="color:#ABB2BF;">|          </span><span style="color:#61AFEF;">9.004</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#61AFEF;">+-----------------------------+---------------+---------------+---------------+---------------+---------------+---------------+---------------+</span></span>
 <span class="line"><span style="color:#61AFEF;">Total</span><span style="color:#98C379;"> line</span><span style="color:#98C379;"> number</span><span style="color:#98C379;"> =</span><span style="color:#D19A66;"> 96</span></span>
 <span class="line"></span>
 <span class="line"><span style="color:#61AFEF;">IoTDB</span><span style="color:#ABB2BF;">&gt; </span><span style="color:#98C379;">call</span><span style="color:#98C379;"> inference</span><span style="color:#ABB2BF;">(</span><span style="color:#61AFEF;">dlinear_example,</span><span style="color:#98C379;"> &quot;select s0,s1,s2,s3,s4,s5,s6 from root.eg.etth&quot;,</span><span style="color:#98C379;"> window=head</span><span style="color:#ABB2BF;">(</span><span style="color:#61AFEF;">96</span><span style="color:#ABB2BF;">))</span></span>
 <span class="line"><span style="color:#61AFEF;">+-----------+----------+----------+------------+---------+----------+----------+</span></span>
 <span class="line"><span style="color:#ABB2BF;">|    </span><span style="color:#61AFEF;">output0</span><span style="color:#ABB2BF;">|   </span><span style="color:#61AFEF;">output1</span><span style="color:#ABB2BF;">|   </span><span style="color:#61AFEF;">output2</span><span style="color:#ABB2BF;">|     </span><span style="color:#61AFEF;">output3</span><span style="color:#ABB2BF;">|  </span><span style="color:#61AFEF;">output4</span><span style="color:#ABB2BF;">|   </span><span style="color:#61AFEF;">output5</span><span style="color:#ABB2BF;">|   </span><span style="color:#61AFEF;">output6</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#61AFEF;">+-----------+----------+----------+------------+---------+----------+----------+</span></span>
 <span class="line"><span style="color:#ABB2BF;">|  </span><span style="color:#61AFEF;">10.319546</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">3.1450553</span><span style="color:#ABB2BF;">|  </span><span style="color:#61AFEF;">7.877341</span><span style="color:#ABB2BF;">|   </span><span style="color:#61AFEF;">1.5723765</span><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">2.7303758</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">1.1362307</span><span style="color:#ABB2BF;">|  </span><span style="color:#61AFEF;">8.867775</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#ABB2BF;">|  </span><span style="color:#61AFEF;">10.443649</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">3.3286757</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">7.8593454</span><span style="color:#ABB2BF;">|   </span><span style="color:#61AFEF;">1.7675098</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">2.560634</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">1.1177158</span><span style="color:#ABB2BF;">|  </span><span style="color:#61AFEF;">8.920919</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#ABB2BF;">|  </span><span style="color:#61AFEF;">10.883752</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">3.2341104</span><span style="color:#ABB2BF;">|   </span><span style="color:#61AFEF;">8.47036</span><span style="color:#ABB2BF;">|   </span><span style="color:#61AFEF;">1.6116762</span><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">2.4874182</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">1.1760603</span><span style="color:#ABB2BF;">|  </span><span style="color:#61AFEF;">8.798939</span><span style="color:#ABB2BF;">| </span></span>
 <span class="line"><span style="color:#56B6C2;">......</span></span>
 <span class="line"><span style="color:#ABB2BF;">|  </span><span style="color:#61AFEF;">8.0115595</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">1.2995274</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">6.9900327</span><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">-0.098746896</span><span style="color:#ABB2BF;">|  </span><span style="color:#61AFEF;">3.04923</span><span style="color:#ABB2BF;">|  </span><span style="color:#61AFEF;">1.176214</span><span style="color:#ABB2BF;">|  </span><span style="color:#61AFEF;">9.548782</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#ABB2BF;">|   </span><span style="color:#61AFEF;">8.612427</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">2.5036244</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">5.6790237</span><span style="color:#ABB2BF;">|  </span><span style="color:#61AFEF;">0.66474205</span><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">2.8870275</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">1.2051733</span><span style="color:#ABB2BF;">|  </span><span style="color:#61AFEF;">9.330128</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#ABB2BF;">|  </span><span style="color:#61AFEF;">10.096699</span><span style="color:#ABB2BF;">|  </span><span style="color:#61AFEF;">3.399722</span><span style="color:#ABB2BF;">|    </span><span style="color:#61AFEF;">6.9909</span><span style="color:#ABB2BF;">|   </span><span style="color:#61AFEF;">1.7478468</span><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">2.7642853</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">1.1119363</span><span style="color:#ABB2BF;">|  </span><span style="color:#61AFEF;">9.541455</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#61AFEF;">+-----------+----------+----------+------------+---------+----------+----------+</span></span>
 <span class="line"><span style="color:#61AFEF;">Total</span><span style="color:#98C379;"> line</span><span style="color:#98C379;"> number</span><span style="color:#98C379;"> =</span><span style="color:#D19A66;"> 48</span></span></code></pre><div class="line-numbers" aria-hidden="true" style="counter-reset:line-number 0;"><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="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>我们将对油温的预测的结果和真实结果进行对比，可以得到以下的图像。</p><p>图中10/24 00:00之前的数据为输入模型的过去数据，10/24 00:00后的蓝色线条为模型给出的油温预测结果，而红色为数据集中实际的油温数据（用于进行对比）。</p><figure><img src="/img/AINode-analysis1.png" alt="" tabindex="0" loading="lazy"><figcaption></figcaption></figure><p>可以看到，我们使用了过去96个小时（4天）的六个负载信息和对应时间油温的关系，基于之前学习到的序列间相互关系对未来48个小时（2天）的油温这一数据的可能变化进行了建模，可以看到可视化后预测曲线与实际结果在趋势上保持了较高程度的一致性。</p><h3 id="_6-2-功率预测" tabindex="-1"><a class="header-anchor" href="#_6-2-功率预测"><span>6.2 功率预测</span></a></h3><p>变电站需要对电流、电压、功率等数据进行电力监控，用于检测潜在的电网问题、识别电力系统中的故障、有效管理电网负载以及分析电力系统的性能和趋势等。</p><p>我们利用某变电站中的电流、电压和功率等数据构成了真实场景下的数据集。该数据集包括变电站近四个月时间跨度，每5 - 6s 采集一次的 A相电压、B相电压、C相电压等数据。</p><p>测试集数据内容为<a href="/img/data.csv">data</a>。</p><p>在该数据集上，IoTDB-ML的模型推理功能可以通过以往A相电压，B相电压和C相电压的数值和对应时间戳，预测未来一段时间内的C相电压，赋能变电站的监视管理。</p><h4 id="步骤一-数据导入-1" tabindex="-1"><a class="header-anchor" href="#步骤一-数据导入-1"><span>步骤一：数据导入</span></a></h4><p>用户可以使用tools文件夹中的<code>import-csv.sh</code> 导入数据集</p><div class="language-bash line-numbers-mode" data-highlighter="shiki" data-ext="bash" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-bash"><span class="line"><span style="color:#61AFEF;">bash</span><span style="color:#98C379;"> ./import-csv.sh</span><span style="color:#D19A66;"> -h</span><span style="color:#D19A66;"> 127.0.0.1</span><span style="color:#D19A66;"> -p</span><span style="color:#D19A66;"> 6667</span><span style="color:#D19A66;"> -u</span><span style="color:#98C379;"> root</span><span style="color:#D19A66;"> -pw</span><span style="color:#98C379;"> root</span><span style="color:#D19A66;"> -f</span><span style="color:#98C379;"> ../../data.csv</span></span></code></pre><div class="line-numbers" aria-hidden="true" style="counter-reset:line-number 0;"><div class="line-number"></div></div></div><h4 id="步骤二-模型导入-1" tabindex="-1"><a class="header-anchor" href="#步骤二-模型导入-1"><span>步骤二：模型导入</span></a></h4><p>我们可以在iotdb-cli 中选择内置模型或已经注册好的模型用于后续的推理。</p><p>我们采用内置模型STLForecaster进行预测，STLForecaster 是一个基于 statsmodels 库中 STL 实现的时间序列预测方法。</p><h4 id="步骤三-模型推理-1" tabindex="-1"><a class="header-anchor" href="#步骤三-模型推理-1"><span>步骤三：模型推理</span></a></h4><div class="language-shell line-numbers-mode" data-highlighter="shiki" data-ext="shell" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-shell"><span class="line"><span style="color:#61AFEF;">IoTDB</span><span style="color:#ABB2BF;">&gt; </span><span style="color:#98C379;">select</span><span style="color:#E5C07B;"> *</span><span style="color:#98C379;"> from</span><span style="color:#98C379;"> root.eg.voltage</span><span style="color:#98C379;"> limit</span><span style="color:#D19A66;"> 96</span></span>
 <span class="line"><span style="color:#61AFEF;">+-----------------------------+------------------+------------------+------------------+</span></span>
 <span class="line"><span style="color:#ABB2BF;">|                         </span><span style="color:#61AFEF;">Time</span><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">root.eg.voltage.s0</span><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">root.eg.voltage.s1</span><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">root.eg.voltage.s2</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#61AFEF;">+-----------------------------+------------------+------------------+------------------+</span></span>
 <span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">2023-02-14T20:38:32.000+08:00</span><span style="color:#ABB2BF;">|            </span><span style="color:#61AFEF;">2038.0</span><span style="color:#ABB2BF;">|            </span><span style="color:#61AFEF;">2028.0</span><span style="color:#ABB2BF;">|            </span><span style="color:#61AFEF;">2041.0</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">2023-02-14T20:38:38.000+08:00</span><span style="color:#ABB2BF;">|            </span><span style="color:#61AFEF;">2014.0</span><span style="color:#ABB2BF;">|            </span><span style="color:#61AFEF;">2005.0</span><span style="color:#ABB2BF;">|            </span><span style="color:#61AFEF;">2018.0</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">2023-02-14T20:38:44.000+08:00</span><span style="color:#ABB2BF;">|            </span><span style="color:#61AFEF;">2014.0</span><span style="color:#ABB2BF;">|            </span><span style="color:#61AFEF;">2005.0</span><span style="color:#ABB2BF;">|            </span><span style="color:#61AFEF;">2018.0</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#56B6C2;">......</span></span>
 <span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">2023-02-14T20:47:52.000+08:00</span><span style="color:#ABB2BF;">|            </span><span style="color:#61AFEF;">2024.0</span><span style="color:#ABB2BF;">|            </span><span style="color:#61AFEF;">2016.0</span><span style="color:#ABB2BF;">|            </span><span style="color:#61AFEF;">2027.0</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">2023-02-14T20:47:57.000+08:00</span><span style="color:#ABB2BF;">|            </span><span style="color:#61AFEF;">2024.0</span><span style="color:#ABB2BF;">|            </span><span style="color:#61AFEF;">2016.0</span><span style="color:#ABB2BF;">|            </span><span style="color:#61AFEF;">2027.0</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">2023-02-14T20:48:03.000+08:00</span><span style="color:#ABB2BF;">|            </span><span style="color:#61AFEF;">2024.0</span><span style="color:#ABB2BF;">|            </span><span style="color:#61AFEF;">2016.0</span><span style="color:#ABB2BF;">|            </span><span style="color:#61AFEF;">2027.0</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#61AFEF;">+-----------------------------+------------------+------------------+------------------+</span></span>
 <span class="line"><span style="color:#61AFEF;">Total</span><span style="color:#98C379;"> line</span><span style="color:#98C379;"> number</span><span style="color:#98C379;"> =</span><span style="color:#D19A66;"> 96</span></span>
 <span class="line"></span>
 <span class="line"><span style="color:#61AFEF;">IoTDB</span><span style="color:#ABB2BF;">&gt; </span><span style="color:#98C379;">call</span><span style="color:#98C379;"> inference</span><span style="color:#ABB2BF;">(</span><span style="color:#61AFEF;">_STLForecaster,</span><span style="color:#98C379;"> &quot;select s0,s1,s2 from root.eg.voltage&quot;,</span><span style="color:#98C379;"> window=head</span><span style="color:#ABB2BF;">(</span><span style="color:#61AFEF;">96</span><span style="color:#ABB2BF;">)</span><span style="color:#98C379;">,predict_length=</span><span style="color:#D19A66;">48</span><span style="color:#ABB2BF;">)</span></span>
 <span class="line"><span style="color:#61AFEF;">+---------+---------+---------+</span></span>
 <span class="line"><span style="color:#ABB2BF;">|  </span><span style="color:#61AFEF;">output0</span><span style="color:#ABB2BF;">|  </span><span style="color:#61AFEF;">output1</span><span style="color:#ABB2BF;">|  </span><span style="color:#61AFEF;">output2</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#61AFEF;">+---------+---------+---------+</span></span>
 <span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">2026.3601</span><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">2018.2953</span><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">2029.4257</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">2019.1538</span><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">2011.4361</span><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">2022.0888</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">2025.5074</span><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">2017.4522</span><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">2028.5199</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#56B6C2;">......</span></span>
 <span class="line"></span>
 <span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">2022.2336</span><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">2015.0290</span><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">2025.1023</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">2015.7241</span><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">2008.8975</span><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">2018.5085</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">2022.0777</span><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">2014.9136</span><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">2024.9396</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">2015.5682</span><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">2008.7821</span><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">2018.3458</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#61AFEF;">+---------+---------+---------+</span></span>
 <span class="line"><span style="color:#61AFEF;">Total</span><span style="color:#98C379;"> line</span><span style="color:#98C379;"> number</span><span style="color:#98C379;"> =</span><span style="color:#D19A66;"> 48</span></span></code></pre><div class="line-numbers" aria-hidden="true" style="counter-reset:line-number 0;"><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="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>我们将对C相电压的预测的结果和真实结果进行对比，可以得到以下的图像。</p><p>图中 02/14 20:48 之前的数据为输入模型的过去数据， 02/14 20:48 后的蓝色线条为模型给出的C相电压预测结果，而红色为数据集中实际的C相电压数据（用于进行对比）。</p><figure><img src="/img/AINode-analysis2.png" alt="" tabindex="0" loading="lazy"><figcaption></figcaption></figure><p>可以看到，我们使用了过去10分钟的电压的数据，基于之前学习到的序列间相互关系对未来5分钟的C相电压这一数据的可能变化进行了建模，可以看到可视化后预测曲线与实际结果在趋势上保持了一定的同步性。</p><h3 id="_6-3-异常检测" tabindex="-1"><a class="header-anchor" href="#_6-3-异常检测"><span>6.3 异常检测</span></a></h3><p>在民航交通运输业，存在着对乘机旅客数量进行异常检测的需求。异常检测的结果可用于指导调整航班的调度，以使得企业获得更大效益。</p><p>Airline Passengers一个时间序列数据集，该数据集记录了1949年至1960年期间国际航空乘客数量，间隔一个月进行一次采样。该数据集共含一条时间序列。数据集为<a href="/img/airline.csv">airline</a>。<br> 在该数据集上，IoTDB-ML的模型推理功能可以通过捕捉序列的变化规律以对序列时间点进行异常检测，赋能交通运输业。</p><h4 id="步骤一-数据导入-2" tabindex="-1"><a class="header-anchor" href="#步骤一-数据导入-2"><span>步骤一：数据导入</span></a></h4><p>用户可以使用tools文件夹中的<code>import-csv.sh</code> 导入数据集</p><div class="language-bash line-numbers-mode" data-highlighter="shiki" data-ext="bash" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-bash"><span class="line"><span style="color:#61AFEF;">bash</span><span style="color:#98C379;"> ./import-csv.sh</span><span style="color:#D19A66;"> -h</span><span style="color:#D19A66;"> 127.0.0.1</span><span style="color:#D19A66;"> -p</span><span style="color:#D19A66;"> 6667</span><span style="color:#D19A66;"> -u</span><span style="color:#98C379;"> root</span><span style="color:#D19A66;"> -pw</span><span style="color:#98C379;"> root</span><span style="color:#D19A66;"> -f</span><span style="color:#98C379;"> ../../data.csv</span></span></code></pre><div class="line-numbers" aria-hidden="true" style="counter-reset:line-number 0;"><div class="line-number"></div></div></div><h4 id="步骤二-模型推理" tabindex="-1"><a class="header-anchor" href="#步骤二-模型推理"><span>步骤二：模型推理</span></a></h4><p>IoTDB内置有部分可以直接使用的机器学习算法，使用其中的异常检测算法进行预测的样例如下：</p><div class="language-shell line-numbers-mode" data-highlighter="shiki" data-ext="shell" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-shell"><span class="line"><span style="color:#61AFEF;">IoTDB</span><span style="color:#ABB2BF;">&gt; </span><span style="color:#98C379;">select</span><span style="color:#E5C07B;"> *</span><span style="color:#98C379;"> from</span><span style="color:#98C379;"> root.eg.airline</span></span>
 <span class="line"><span style="color:#61AFEF;">+-----------------------------+------------------+</span></span>
 <span class="line"><span style="color:#ABB2BF;">|                         </span><span style="color:#61AFEF;">Time</span><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">root.eg.airline.s0</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#61AFEF;">+-----------------------------+------------------+</span></span>
 <span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">1949-01-31T00:00:00.000+08:00</span><span style="color:#ABB2BF;">|             </span><span style="color:#61AFEF;">224.0</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">1949-02-28T00:00:00.000+08:00</span><span style="color:#ABB2BF;">|             </span><span style="color:#61AFEF;">118.0</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">1949-03-31T00:00:00.000+08:00</span><span style="color:#ABB2BF;">|             </span><span style="color:#61AFEF;">132.0</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">1949-04-30T00:00:00.000+08:00</span><span style="color:#ABB2BF;">|             </span><span style="color:#61AFEF;">129.0</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#56B6C2;">......</span></span>
 <span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">1960-09-30T00:00:00.000+08:00</span><span style="color:#ABB2BF;">|             </span><span style="color:#61AFEF;">508.0</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">1960-10-31T00:00:00.000+08:00</span><span style="color:#ABB2BF;">|             </span><span style="color:#61AFEF;">461.0</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">1960-11-30T00:00:00.000+08:00</span><span style="color:#ABB2BF;">|             </span><span style="color:#61AFEF;">390.0</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">1960-12-31T00:00:00.000+08:00</span><span style="color:#ABB2BF;">|             </span><span style="color:#61AFEF;">432.0</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#61AFEF;">+-----------------------------+------------------+</span></span>
 <span class="line"><span style="color:#61AFEF;">Total</span><span style="color:#98C379;"> line</span><span style="color:#98C379;"> number</span><span style="color:#98C379;"> =</span><span style="color:#D19A66;"> 144</span></span>
 <span class="line"></span>
 <span class="line"><span style="color:#61AFEF;">IoTDB</span><span style="color:#ABB2BF;">&gt; </span><span style="color:#98C379;">call</span><span style="color:#98C379;"> inference</span><span style="color:#ABB2BF;">(</span><span style="color:#61AFEF;">_Stray,</span><span style="color:#98C379;"> &quot;select s0 from root.eg.airline&quot;,</span><span style="color:#98C379;"> k=</span><span style="color:#D19A66;">2</span><span style="color:#ABB2BF;">)</span></span>
 <span class="line"><span style="color:#61AFEF;">+-------+</span></span>
 <span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">output0</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#61AFEF;">+-------+</span></span>
 <span class="line"><span style="color:#ABB2BF;">|      </span><span style="color:#61AFEF;">0</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#ABB2BF;">|      </span><span style="color:#61AFEF;">0</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#ABB2BF;">|      </span><span style="color:#61AFEF;">0</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#ABB2BF;">|      </span><span style="color:#61AFEF;">0</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#56B6C2;">......</span></span>
 <span class="line"><span style="color:#ABB2BF;">|      </span><span style="color:#61AFEF;">1</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#ABB2BF;">|      </span><span style="color:#61AFEF;">1</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#ABB2BF;">|      </span><span style="color:#61AFEF;">0</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#ABB2BF;">|      </span><span style="color:#61AFEF;">0</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#ABB2BF;">|      </span><span style="color:#61AFEF;">0</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#ABB2BF;">|      </span><span style="color:#61AFEF;">0</span><span style="color:#ABB2BF;">|</span></span>
 <span class="line"><span style="color:#61AFEF;">+-------+</span></span>
 <span class="line"><span style="color:#61AFEF;">Total</span><span style="color:#98C379;"> line</span><span style="color:#98C379;"> number</span><span style="color:#98C379;"> =</span><span style="color:#D19A66;"> 144</span></span></code></pre><div class="line-numbers" aria-hidden="true" style="counter-reset:line-number 0;"><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="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>我们将检测为异常的结果进行绘制，可以得到以下图像。其中蓝色曲线为原时间序列，用红色点特殊标注的时间点为算法检测为异常的时间点。</p><figure><img src="/img/s6.png" alt="" tabindex="0" loading="lazy"><figcaption></figcaption></figure><p>可以看到，Stray模型对输入序列变化进行了建模，成功检测出出现异常的时间点。</p></div><!----><!----><!----></div><footer class="vp-page-meta"><div class="vp-meta-item edit-link"><a class="auto-link external-link vp-meta-label" href="https://github.com/apache/iotdb-docs/edit/main/src/zh/UserGuide/dev-1.3/AI-capability/AINode_apache.md" aria-label="发现错误？在 GitHub 上编辑此页" rel="noopener noreferrer" target="_blank"><!--[--><svg xmlns="http://www.w3.org/2000/svg" class="icon edit-icon" viewBox="0 0 1024 1024" fill="currentColor" aria-label="edit icon" name="edit"><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 上编辑此页<!----></a></div><div class="vp-meta-item git-info"><div class="update-time"><span class="vp-meta-label">最近更新: </span><time class="vp-meta-info" datetime="2025-07-24T02:05:38.000Z" data-allow-mismatch>2025/7/24 02:05</time></div><!----></div></footer><!----><!----><!----><!--]--></main><!--]--><footer class="site-footer"><span id="doc-version" style="display:none;">dev-1.3</span><p class="copyright-text">版权所有 © 2026 Apache软件基金会。
 Apache IoTDB，IoTDB，Apache，Apache 羽毛标志和 Apache IoTDB 项目标志是 Apache 软件基金会在所有国家的注册商标或商标</p><p style="text-align:center;margin-top:10px;color:#909399;font-size:12px;margin:0 30px;"><strong>有问题吗？</strong> 在 QQ、微信或 Slack 上联系我们。 <a href="https://github.com/apache/iotdb/issues/1995">立即加入社区</a></p></footer></div><!--]--><!--]--><!--[--><!----><!--]--><!--]--></div>
     <script type="module" src="/assets/app-pmkzp6TS.js" defer></script>
   </body>
 </html>