The Cluster menu selection comprises several tabs that contain
information about all the machines in your cluster as well as configuration and
log file access. Summary data about your Kinetica cluster is pinned to the top
right of each tab within Cluster; it includes:
The Dashboard page is also the GAdmin homepage. It
highlights the most important information about all the machines in your
cluster, including CPU, Memory, and Disk usage.
The Cluster —> Admin section is only available to users
with the System Admin permission.
The Admin page allows you to stop or start the database, rebuild the
database, rebalance the database, or review operation history (add, remove, or
rebalance node operations) information.Click Rebuild DB to rebuild the database should you experience
database errors or some tables and/or schemas are unable to be queried.
All tables can be rebuilt or just tables with disk optimized columns and/or
tables with text search columns can be rebuilt. For more information on
rebuilding individual tables or schemas, see
Rebuilding. To check the database for inconsistencies
across the cluster, see VERIFY DATABASE.Click Rebalance DB to optionally shuffle around sharded and
unsharded data across your cluster so all nodes could have roughly the same
amount of sharded and unsharded data. If choosing to rebalance unsharded data,
optionally provide a whitelist or blacklist of unsharded tables’ names.
The Cluster —> License section is only available to users
with the System Admin permission.
The License page provides management capability for the Kinetica
license used by the cluster. The page will list the type, status, and
expiration date of the active license.
The license can only be modified when Kinetica is not running.
The Cluster —> Config section is only available to users
with the System Admin permission.
The Config page allows you to edit the core Kinetica configuration
file and save the changes directly in GAdmin; this file maps
to the /opt/gpudb/core/etc/gpudb.conf file. Detailed
information about configuration file settings can be found on
Configuration Reference.
This tab can only be edited when Kinetica is not running.
The Logging page displays the running system log file, updating
every two seconds. This file is Kinetica’s main diagnostic tool and it is
located at
/opt/gpudb/core/logs/host-manager-<hostname>-<date-time>.log.
If the cluster uses a shared persist directory, each nodes’ database log will
be located in this directory as well.
Select the Pause Log checkbox to pause the file updates. The number
of displayed lines can be selected from Lines, and the displayed
lines can be filtered using Filter (select the Exclude
checkbox to instead exclude the filtered word or phrase).
Click Manage Logging Level to open the
Manage System Logging Level window, where the per-rank logging level
for any system logger can be modified.To view the active loggers and corresponding levels for each rank, select the
rank from the Rank drop-down menu above the
Current Log Levels list. Use the Filter below the list
to find a particular logger in the list.To update a logger:
At the top of the window, select a rank or ALL from the Rank
drop-down window.
Provide a logger name for the Logger field.
Select a logger level from the Level drop-down menu.
Click Set Logger.
Instructions for manually changing the logging level via the
/opt/gpudb/core/etc/gpudb_logger.conf file are located on the
Custom Logging documentation.
Any change will take effect immediately and be in effect until a subsequent
change is made to the same logger or the database is restarted. A database
restart will reset all loggers to their default levels, system-wide.
The Debug page displays debugging and metric information about your
cluster. Note that each section has nested information, so it’s possible
to drill in for more details. From this page, you can also generate system
reports and access previous reports. A system report includes important logs
and files that can be sent to support (support@kinetica.com) to help diagnose
any issues at hand.
The Cluster —> Demo section is only available to users
with the System Admin permission.
The Demo page contains various data that you can load into
Kinetica. This data will help get you started using Kinetica as well as
demonstrate some key capabilities of the system. Each demo dataset contains
500,000 records; after loading the data into Kinetica, you have the option of
loading the same data again. The datasets with a
Reveal Dashboard button have a corresponding
Reveal dashboard that will be automatically setup in Reveal after ingesting the
data.
The Visualize page contains an overview of
Reveal as well as a quick link to Reveal.
{"docsConfig":{"theme":"mint","$schema":"https://mintlify.com/docs.json","name":"Kinetica Docs","colors":{"primary":"#6366f1","light":"#818cf8","dark":"#4f46e5"},"logo":{"light":"https://mintcdn.com/kinetica/1Hn5MNMQp397m0Vp/images/logo-light.svg?fit=max\u0026auto=format\u0026n=1Hn5MNMQp397m0Vp\u0026q=85\u0026s=b9dbe33a7cd8b6a24d26de6d5a527049","dark":"https://mintcdn.com/kinetica/1Hn5MNMQp397m0Vp/images/logo-dark.svg?fit=max\u0026auto=format\u0026n=1Hn5MNMQp397m0Vp\u0026q=85\u0026s=1c81948d7d1d7650f89788f9edf24969"},"favicon":"https://mintcdn.com/kinetica/1Hn5MNMQp397m0Vp/images/favicon.png?fit=max\u0026auto=format\u0026n=1Hn5MNMQp397m0Vp\u0026q=85\u0026s=cd3ca3d54299cee25fc40ae1d69802f6","search":{"prompt":"Search Kinetica docs..."},"seo":{"indexing":"all"},"styling":{"latex":true},"navigation":{"pages":[]}},"deployment":{"deploymentMetadataValue":{"subdomain":"kinetica","hasAudioNarration":false,"actualSubdomain":"kinetica","customDomains":["docs.kinetica.com"],"gitSource":{"type":"github","owner":"kineticadb","repo":"kinetica-docs","deployBranch":"master","contentDirectory":"","isPrivate":false,"mountPath":"","label":""},"chroma":{"liveDeploymentHistoryId":"6ae0c63d6c1a15a18d9e4adc","collectionId":"791b39af-cc4e-432d-a134-fb9a39eb2961","schemaVersion":"v3","latestBuiltDeploymentHistoryId":"6ae0c63d6c1a15a18d9e4adc"},"entitlements":{"AI_CHAT":{"status":"ENABLED"},"WEB_MCP":{"status":"ENABLED"},"NARRATION":{"status":"ENABLED"}},"buildId":"6ae0c63d6c1a15a18d9e4adc","clientVersion":"0.0.4043","searchFilterCounts":[{"language":"default","tag":"API Reference","count":6701},{"language":"default","tag":"API","count":6701},{"language":"default","tag":"Rust API","count":1325},{"language":"default","tag":"Java API","count":1072},{"language":"default","tag":"GPUdb","count":1000},{"language":"default","tag":"C# API","count":963},{"language":"default","tag":"Documentation","count":878},{"language":"default","tag":"Classes","count":793},{"language":"default","tag":"com.gpudb.protocol","count":756},{"language":"default","tag":"Node.js API","count":722}],"searchSettings":{"maxResults":40}},"assistantConfig":{},"basePath":"","hasChatPermissions":true,"hasWebMcpPermissions":true,"toggles":[{"name":"kill-isr","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"agent-mintlify-slack","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"agent-integrations-settings","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automations-pr-grouping","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"custom-prefix","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"analytics-v7","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"user-flows-analytics","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"no-publish-flow","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-onboarding","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"llms-txt-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"snapshot-serving-live","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"stripTemperatureMiddleware","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"support-platform-pylon-zendesk","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"snapshot-serving","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"instant-rollback","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"granular-notifications-server","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"granular-notifications","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automations-fable","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"fixed-ai-action-pricing","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automation-resolve-merge-conflict","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"scoped-publishing","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"mintql","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"page-level-analytics","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"editor-version-history-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"billing-page-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"full-page-search","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workspace-projects","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"assistant-v5","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"byok-sep-25","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"fork-pr-previews","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"revalidation-jwt","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"vite-origin","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"billing-updated-9-15","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-sso-scim","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"hobby-abuse-scan","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"dashboard-inbox","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-signup","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"turbopuffer-dual-write","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-enabled","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"approve-review-flow","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false}],"googleFontsInlined":false},"customCss":[{"filePath":"style.css","content":".kinetica-doxygen,.kinetica-javadoc,.kinetica-jsdoc,.kinetica-pydoc,.kinetica-rustdoc,.kinetica-typedoc{line-height:1.5}.kinetica-doxygen .memname,.kinetica-doxygen .memproto,.kinetica-javadoc .member-signature,.kinetica-javadoc .type-signature,.kinetica-jsdoc .signature,.kinetica-jsdoc .type-signature,.kinetica-pydoc .sig,.kinetica-typedoc .tsd-signature{font-family:ui-monospace,SFMono-Regular,Menlo,Consolas,monospace;font-size:.9em;white-space:pre-wrap;word-break:break-word}.kinetica-doxygen table.fieldtable,.kinetica-doxygen table.params,.kinetica-javadoc table,.kinetica-jsdoc table,.kinetica-pydoc table.docutils{width:100%;border-collapse:collapse;margin:.75rem 0}.kinetica-doxygen table.fieldtable td,.kinetica-doxygen table.fieldtable th,.kinetica-doxygen table.params td,.kinetica-javadoc td,.kinetica-javadoc th,.kinetica-jsdoc td,.kinetica-jsdoc th,.kinetica-pydoc table.docutils td,.kinetica-pydoc table.docutils th{border:1px solid var(--border-color, #e5e7eb);padding:.4rem .6rem;text-align:left;vertical-align:top}.kinetica-javadoc .summary-table{display:grid;border:1px solid var(--border-color, #e5e7eb)}.kinetica-javadoc .two-column-summary{grid-template-columns:minmax(8rem,.3fr) minmax(0,.7fr)}.kinetica-javadoc .three-column-summary{grid-template-columns:minmax(6rem,.2fr) minmax(9rem,.35fr) minmax(0,.45fr)}.kinetica-javadoc .summary-table>div{padding:.4rem .6rem;border-top:1px solid var(--border-color, #e5e7eb)}.kinetica-javadoc .table-header{font-weight:600}.kinetica-javadoc .table-tabs,.kinetica-javadoc button[role=tab]{display:none}.kinetica-doxygen .dl,.kinetica-javadoc .dl,.kinetica-jsdoc .dl,.kinetica-pydoc .dl{margin:.5rem 0}.kinetica-doxygen .dt,.kinetica-javadoc .dt,.kinetica-jsdoc .dt,.kinetica-pydoc .dt{font-weight:600;margin-top:.6rem}.kinetica-doxygen .blockquote,.kinetica-doxygen .dd,.kinetica-javadoc .blockquote,.kinetica-javadoc .dd,.kinetica-jsdoc .blockquote,.kinetica-jsdoc .dd,.kinetica-pydoc .blockquote,.kinetica-pydoc .dd{margin-left:1.25rem}.kinetica-jsdoc .dummy{list-style:none;margin:0;padding:0}.kinetica-doxygen .cite,.kinetica-doxygen .em,.kinetica-doxygen .i,.kinetica-javadoc .cite,.kinetica-javadoc .em,.kinetica-javadoc .i,.kinetica-jsdoc .cite,.kinetica-jsdoc .em,.kinetica-jsdoc .i,.kinetica-pydoc .cite,.kinetica-pydoc .em,.kinetica-pydoc .i{font-style:italic}.kinetica-doxygen .b,.kinetica-javadoc .b,.kinetica-jsdoc .b,.kinetica-pydoc .b{font-weight:600}.kinetica-javadoc .inheritance,.kinetica-javadoc .inheritance .inheritance{margin-left:1rem}.kinetica-javadoc .deprecation-block,.kinetica-pydoc .deprecated{border-left:3px solid #f59e0b;padding:.25rem .75rem;margin:.5rem 0}.kinetica-doxygen table.memberdecls{width:100%;border-collapse:collapse;margin:.5rem 0}.kinetica-doxygen table.memberdecls td{padding:.2rem .4rem;vertical-align:top}.kinetica-doxygen .memitem{border:1px solid var(--border-color, #e5e7eb);border-radius:6px;margin:.75rem 0}.kinetica-doxygen .memproto{padding:.4rem .6rem;border-bottom:1px solid var(--border-color, #e5e7eb);font-weight:600}.kinetica-doxygen .memdoc{padding:.4rem .6rem}.kinetica-doxygen h2.groupheader{margin-top:1.25rem;padding-bottom:.2rem;border-bottom:1px solid var(--border-color, #e5e7eb)}.kinetica-doxygen .memtitle{font-weight:600}.kinetica-doxygen div.fragment{font-size:.9em;white-space:pre-wrap;overflow-x:auto}.kbd,.small{font-size:.85em}.kbd,.kinetica-doxygen div.fragment{font-family:ui-monospace,SFMono-Regular,Menlo,Consolas,monospace}.kbd{padding:.1em .4em;border:1px solid var(--border-color, #e5e7eb);border-bottom-width:2px;border-radius:4px;white-space:nowrap}.kinetica-typedoc .tsd-panel.tsd-member{border-top:1px solid var(--border-color, #e5e7eb);padding-top:.75rem;margin-top:1rem}.kinetica-typedoc .tsd-index-list{display:flex;flex-wrap:wrap;gap:.25rem 1rem}.kinetica-typedoc .tsd-parameter-list{list-style:none;padding-left:.5rem}.kinetica-rustdoc .code-header,.kinetica-rustdoc .item-decl,.kinetica-rustdoc .item-table>.dt{font-family:ui-monospace,SFMono-Regular,Menlo,Consolas,monospace;font-size:.9em;word-break:break-word}.kinetica-rustdoc .code-header,.kinetica-rustdoc .item-decl{font-weight:500;white-space:pre-wrap}.kinetica-rustdoc pre.item-decl a{color:inherit;text-decoration:underline;text-decoration-color:rgba(245,245,250,.4);text-underline-offset:3px}.kinetica-rustdoc .item-table>.dt{margin-top:.6rem}.kinetica-rustdoc .item-table>.dd{margin-left:1.5rem}.kinetica-rustdoc .method-toggle{border-top:1px solid var(--border-color, #e5e7eb);padding-top:.5rem;margin-top:.75rem}.kinetica-rustdoc .stab{display:inline-block;font-size:.85em;padding:.1em .5em;border-radius:4px;background:var(--border-color, #e5e7eb)}.kinetica-rustdoc .rustdoc-breadcrumbs{font-size:.85em;opacity:.8}"}],"page":{"pagePath":"content/admin/gadmin/cluster","slug":"/content/admin/gadmin/cluster","pageMetadata":{"title":"Cluster","sidebarTitle":"Cluster","description":null,"href":"/content/admin/gadmin/cluster"},"pageType":"default","mdx":{"mdxSource":{"compiledSource":"\"use strict\";const{Fragment:_Fragment,jsx:_jsx,jsxs:_jsxs}=arguments[0];const{useMDXComponents:_provideComponents}=arguments[0];function _createMdxContent(props){const _components={a:`a`,code:`code`,em:`em`,li:`li`,ol:`ol`,p:`p`,strong:`strong`,ul:`ul`,..._provideComponents(),...props.components},{Badge,Heading,Info,Note,OptimizedImage,Tip}=_components;if(!Badge)_missingMdxReference(`Badge`,true);if(!Heading)_missingMdxReference(`Heading`,true);if(!Info)_missingMdxReference(`Info`,true);if(!Note)_missingMdxReference(`Note`,true);if(!OptimizedImage)_missingMdxReference(`OptimizedImage`,true);if(!Tip)_missingMdxReference(`Tip`,true);return _jsxs(_Fragment,{children:[_jsx(`a`,{id:`gadmin-cluster`}),`\n`,_jsxs(_components.p,{children:[`The `,_jsx(_components.strong,{children:`Cluster`}),` menu selection comprises several tabs that contain\ninformation about all the machines in your cluster as well as configuration and\nlog file access. Summary data about your `,_jsx(_components.em,{children:`Kinetica`}),` cluster is pinned to the top\nright of each tab within `,_jsx(_components.strong,{children:`Cluster`}),`; it includes:`]}),`\n`,_jsxs(_components.ul,{children:[`\n`,_jsxs(_components.li,{children:[`The `,_jsx(_components.a,{href:`/content/admin/services#statuses`,children:`status`}),` of `,_jsx(_components.em,{children:`Kinetica`})]}),`\n`,_jsxs(_components.li,{children:[`How many users are connected to `,_jsx(_components.em,{children:`Kinetica`})]}),`\n`,_jsxs(_components.li,{children:[`How many requests per second are being made to `,_jsx(_components.em,{children:`Kinetica`})]}),`\n`,_jsxs(_components.li,{children:[`How many tables are present in this `,_jsx(_components.em,{children:`Kinetica`}),` cluster`]}),`\n`,_jsxs(_components.li,{children:[`How many rows are present in this `,_jsx(_components.em,{children:`Kinetica`}),` cluster`]}),`\n`,_jsxs(_components.li,{children:[`The uptime of this `,_jsx(_components.em,{children:`Kinetica`}),` cluster`]}),`\n`,_jsx(_components.li,{children:`A refresh button to refresh the cluster information`}),`\n`]}),`\n`,_jsx(OptimizedImage,{src:`https://mintcdn.com/kinetica/PHQlULcgtUSM8bYf/content/admin/images/cluster_summary_bar.png?fit=max\u0026auto=format\u0026n=PHQlULcgtUSM8bYf\u0026q=85\u0026s=b9d55a10a229ee6863be310c06d6c17b`,alt:`../../images/cluster_summary_bar.png`,\"data-og-width\":`561`,width:`561`,\"data-og-height\":`35`,height:`35`,\"data-path\":`content/admin/images/cluster_summary_bar.png`,\"data-optimize\":`true`,\"data-opv\":`3`,srcset:`https://mintcdn.com/kinetica/PHQlULcgtUSM8bYf/content/admin/images/cluster_summary_bar.png?w=280\u0026fit=max\u0026auto=format\u0026n=PHQlULcgtUSM8bYf\u0026q=85\u0026s=94e7be17b405351247c7545d2858005a 280w, https://mintcdn.com/kinetica/PHQlULcgtUSM8bYf/content/admin/images/cluster_summary_bar.png?w=560\u0026fit=max\u0026auto=format\u0026n=PHQlULcgtUSM8bYf\u0026q=85\u0026s=c00db8c594a0cc826d3f033ee323ca02 560w, https://mintcdn.com/kinetica/PHQlULcgtUSM8bYf/content/admin/images/cluster_summary_bar.png?w=840\u0026fit=max\u0026auto=format\u0026n=PHQlULcgtUSM8bYf\u0026q=85\u0026s=2d7947990887477f20ab2aa4f6f13d0e 840w, https://mintcdn.com/kinetica/PHQlULcgtUSM8bYf/content/admin/images/cluster_summary_bar.png?w=1100\u0026fit=max\u0026auto=format\u0026n=PHQlULcgtUSM8bYf\u0026q=85\u0026s=00a640463d85df0595b91483382cf3b7 1100w, https://mintcdn.com/kinetica/PHQlULcgtUSM8bYf/content/admin/images/cluster_summary_bar.png?w=1650\u0026fit=max\u0026auto=format\u0026n=PHQlULcgtUSM8bYf\u0026q=85\u0026s=18d45b4ba408ffa178b943e2958c45b1 1650w, https://mintcdn.com/kinetica/PHQlULcgtUSM8bYf/content/admin/images/cluster_summary_bar.png?w=2500\u0026fit=max\u0026auto=format\u0026n=PHQlULcgtUSM8bYf\u0026q=85\u0026s=de61e21ab63b2bcdc48151b7a5e998b4 2500w`}),`\n`,_jsx(`a`,{id:`gadmin-cluster-dashboard`}),`\n`,_jsx(Heading,{level:`2`,id:`dashboard`,children:`Dashboard`}),`\n`,_jsxs(_components.p,{children:[`The `,_jsx(_components.strong,{children:`Dashboard`}),` page is also the `,_jsx(_components.a,{href:`/content/admin/gadmin`,children:`GAdmin`}),` homepage. It\nhighlights the most important information about all the machines in your\ncluster, including CPU, Memory, and Disk usage.`]}),`\n`,_jsx(OptimizedImage,{src:`https://mintcdn.com/kinetica/PHQlULcgtUSM8bYf/content/admin/images/cluster_dashboard.png?fit=max\u0026auto=format\u0026n=PHQlULcgtUSM8bYf\u0026q=85\u0026s=194032dd71013d6a4112050f3d6327b2`,alt:`../../images/cluster_dashboard.png`,\"data-og-width\":`1000`,width:`1000`,\"data-og-height\":`428`,height:`428`,\"data-path\":`content/admin/images/cluster_dashboard.png`,\"data-optimize\":`true`,\"data-opv\":`3`,srcset:`https://mintcdn.com/kinetica/PHQlULcgtUSM8bYf/content/admin/images/cluster_dashboard.png?w=280\u0026fit=max\u0026auto=format\u0026n=PHQlULcgtUSM8bYf\u0026q=85\u0026s=6914b93d9a32866865c9eed7a35ab0af 280w, https://mintcdn.com/kinetica/PHQlULcgtUSM8bYf/content/admin/images/cluster_dashboard.png?w=560\u0026fit=max\u0026auto=format\u0026n=PHQlULcgtUSM8bYf\u0026q=85\u0026s=efc3b5d332c0805c2dcac859882dc047 560w, https://mintcdn.com/kinetica/PHQlULcgtUSM8bYf/content/admin/images/cluster_dashboard.png?w=840\u0026fit=max\u0026auto=format\u0026n=PHQlULcgtUSM8bYf\u0026q=85\u0026s=5550329e738278783b1b16976e7e2bad 840w, https://mintcdn.com/kinetica/PHQlULcgtUSM8bYf/content/admin/images/cluster_dashboard.png?w=1100\u0026fit=max\u0026auto=format\u0026n=PHQlULcgtUSM8bYf\u0026q=85\u0026s=ff20cfbd9a3ec94d8236d80a97903c33 1100w, https://mintcdn.com/kinetica/PHQlULcgtUSM8bYf/content/admin/images/cluster_dashboard.png?w=1650\u0026fit=max\u0026auto=format\u0026n=PHQlULcgtUSM8bYf\u0026q=85\u0026s=1279c345d90fb5513f1b0a277c53d0d8 1650w, https://mintcdn.com/kinetica/PHQlULcgtUSM8bYf/content/admin/images/cluster_dashboard.png?w=2500\u0026fit=max\u0026auto=format\u0026n=PHQlULcgtUSM8bYf\u0026q=85\u0026s=f28d517ee5095f35f55b46ddda699d74 2500w`}),`\n`,_jsx(Heading,{level:`2`,id:`ranks`,children:`Ranks`}),`\n`,_jsxs(_components.p,{children:[`The `,_jsx(_components.strong,{children:`Ranks`}),` page displays important information about all the GPU\nranks being used in your cluster.`]}),`\n`,_jsx(OptimizedImage,{src:`https://mintcdn.com/kinetica/PHQlULcgtUSM8bYf/content/admin/images/cluster_ranks.png?fit=max\u0026auto=format\u0026n=PHQlULcgtUSM8bYf\u0026q=85\u0026s=0854d70bfe5094199077718ffc3f147f`,alt:`../../images/cluster_ranks.png`,\"data-og-width\":`1000`,width:`1000`,\"data-og-height\":`350`,height:`350`,\"data-path\":`content/admin/images/cluster_ranks.png`,\"data-optimize\":`true`,\"data-opv\":`3`,srcset:`https://mintcdn.com/kinetica/PHQlULcgtUSM8bYf/content/admin/images/cluster_ranks.png?w=280\u0026fit=max\u0026auto=format\u0026n=PHQlULcgtUSM8bYf\u0026q=85\u0026s=b9c98a90bdc3edaf01a9dc5166246e91 280w, https://mintcdn.com/kinetica/PHQlULcgtUSM8bYf/content/admin/images/cluster_ranks.png?w=560\u0026fit=max\u0026auto=format\u0026n=PHQlULcgtUSM8bYf\u0026q=85\u0026s=9211829bfc8ef191d48e8bc369af3a2c 560w, https://mintcdn.com/kinetica/PHQlULcgtUSM8bYf/content/admin/images/cluster_ranks.png?w=840\u0026fit=max\u0026auto=format\u0026n=PHQlULcgtUSM8bYf\u0026q=85\u0026s=f7d516503504cd3d3335d1862ba5d656 840w, https://mintcdn.com/kinetica/PHQlULcgtUSM8bYf/content/admin/images/cluster_ranks.png?w=1100\u0026fit=max\u0026auto=format\u0026n=PHQlULcgtUSM8bYf\u0026q=85\u0026s=8c04246e75948b5b7875b4f539d2e473 1100w, https://mintcdn.com/kinetica/PHQlULcgtUSM8bYf/content/admin/images/cluster_ranks.png?w=1650\u0026fit=max\u0026auto=format\u0026n=PHQlULcgtUSM8bYf\u0026q=85\u0026s=5e33bd5b26d50fa4f92d0de758586c14 1650w, https://mintcdn.com/kinetica/PHQlULcgtUSM8bYf/content/admin/images/cluster_ranks.png?w=2500\u0026fit=max\u0026auto=format\u0026n=PHQlULcgtUSM8bYf\u0026q=85\u0026s=41c8b192869f00c49372242d697b80a8 2500w`}),`\n`,_jsx(`a`,{id:`gadmin-db-rebuild`}),`\n`,_jsx(Heading,{level:`2`,id:`admin`,children:`Admin`}),`\n`,_jsx(Note,{children:_jsxs(_components.p,{children:[`The `,_jsx(_components.strong,{children:`Cluster —> Admin`}),` section is only available to users\nwith the `,_jsx(_components.em,{children:`System Admin`}),` permission.`]})}),`\n`,_jsxs(_components.p,{children:[`The `,_jsx(_components.strong,{children:`Admin`}),` page allows you to stop or start the database, rebuild the\ndatabase, rebalance the database, or review operation history (add, remove, or\nrebalance node operations) information.`]}),`\n`,_jsxs(_components.p,{children:[`Click `,_jsx(_components.strong,{children:`Rebuild DB`}),` to rebuild the database should you experience\ndatabase errors or some `,_jsx(_components.em,{children:`tables`}),` and/or `,_jsx(_components.em,{children:`schemas`}),` are unable to be queried.\nAll tables can be rebuilt `,_jsx(_components.strong,{children:`or`}),` just tables with disk optimized columns and/or\ntables with text search columns can be rebuilt. For more information on\nrebuilding individual `,_jsx(_components.em,{children:`tables`}),` or `,_jsx(_components.em,{children:`schemas`}),`, see\n`,_jsx(_components.a,{href:`/content/admin/gadmin/data#gadmin-table-rebuild`,children:`Rebuilding`}),`. To check the database for inconsistencies\nacross the cluster, see `,_jsx(_components.a,{href:`/content/sql/system_properties/verify-database#sql-verify-database`,children:`VERIFY DATABASE`}),`.`]}),`\n`,_jsxs(_components.p,{children:[`Click `,_jsx(_components.strong,{children:`Rebalance DB`}),` to optionally shuffle around sharded and\nunsharded data across your cluster so all nodes could have roughly the same\namount of sharded and unsharded data. If choosing to rebalance unsharded data,\noptionally provide a whitelist `,_jsx(_components.strong,{children:`or`}),` blacklist of unsharded tables’ names.`]}),`\n`,_jsx(OptimizedImage,{src:`https://mintcdn.com/kinetica/PHQlULcgtUSM8bYf/content/admin/images/cluster_admin.png?fit=max\u0026auto=format\u0026n=PHQlULcgtUSM8bYf\u0026q=85\u0026s=07daaf4b10a3425263f261782fbe2aeb`,alt:`../../images/cluster_admin.png`,\"data-og-width\":`1000`,width:`1000`,\"data-og-height\":`358`,height:`358`,\"data-path\":`content/admin/images/cluster_admin.png`,\"data-optimize\":`true`,\"data-opv\":`3`,srcset:`https://mintcdn.com/kinetica/PHQlULcgtUSM8bYf/content/admin/images/cluster_admin.png?w=280\u0026fit=max\u0026auto=format\u0026n=PHQlULcgtUSM8bYf\u0026q=85\u0026s=9640dffc35593f72502a6bf0923ffeae 280w, https://mintcdn.com/kinetica/PHQlULcgtUSM8bYf/content/admin/images/cluster_admin.png?w=560\u0026fit=max\u0026auto=format\u0026n=PHQlULcgtUSM8bYf\u0026q=85\u0026s=c15619c03d70eb8cfce5b78775a2b1a8 560w, https://mintcdn.com/kinetica/PHQlULcgtUSM8bYf/content/admin/images/cluster_admin.png?w=840\u0026fit=max\u0026auto=format\u0026n=PHQlULcgtUSM8bYf\u0026q=85\u0026s=adfbbb18579a31272c1b4aa0198a4f52 840w, https://mintcdn.com/kinetica/PHQlULcgtUSM8bYf/content/admin/images/cluster_admin.png?w=1100\u0026fit=max\u0026auto=format\u0026n=PHQlULcgtUSM8bYf\u0026q=85\u0026s=cb244d75aa1b3f0c34eda7b4f6bcc759 1100w, https://mintcdn.com/kinetica/PHQlULcgtUSM8bYf/content/admin/images/cluster_admin.png?w=1650\u0026fit=max\u0026auto=format\u0026n=PHQlULcgtUSM8bYf\u0026q=85\u0026s=15bf692e68133bbe4bdcf5efdc0bf0d1 1650w, https://mintcdn.com/kinetica/PHQlULcgtUSM8bYf/content/admin/images/cluster_admin.png?w=2500\u0026fit=max\u0026auto=format\u0026n=PHQlULcgtUSM8bYf\u0026q=85\u0026s=caee122f90e1216a2786246b236e9ec9 2500w`}),`\n`,_jsx(Heading,{level:`2`,id:`license`,children:`License`}),`\n`,_jsx(Note,{children:_jsxs(_components.p,{children:[`The `,_jsx(_components.strong,{children:`Cluster —> License`}),` section is only available to users\nwith the `,_jsx(_components.em,{children:`System Admin`}),` permission.`]})}),`\n`,_jsxs(_components.p,{children:[`The `,_jsx(_components.strong,{children:`License`}),` page provides management capability for the `,_jsx(_components.em,{children:`Kinetica`}),`\nlicense used by the cluster. The page will list the type, status, and\nexpiration date of the active license.`]}),`\n`,_jsx(Info,{children:_jsxs(_components.p,{children:[`The license can only be modified when `,_jsx(_components.em,{children:`Kinetica`}),` is not running.`]})}),`\n`,_jsx(OptimizedImage,{src:`https://mintcdn.com/kinetica/PHQlULcgtUSM8bYf/content/admin/images/cluster_setup.png?fit=max\u0026auto=format\u0026n=PHQlULcgtUSM8bYf\u0026q=85\u0026s=17b433c1f1e402f682cc1160cfe7d651`,alt:`../../images/cluster_setup.png`,\"data-og-width\":`1000`,width:`1000`,\"data-og-height\":`349`,height:`349`,\"data-path\":`content/admin/images/cluster_setup.png`,\"data-optimize\":`true`,\"data-opv\":`3`,srcset:`https://mintcdn.com/kinetica/PHQlULcgtUSM8bYf/content/admin/images/cluster_setup.png?w=280\u0026fit=max\u0026auto=format\u0026n=PHQlULcgtUSM8bYf\u0026q=85\u0026s=b3c4a8a3bb18f29123ba2ea477ffe5cd 280w, https://mintcdn.com/kinetica/PHQlULcgtUSM8bYf/content/admin/images/cluster_setup.png?w=560\u0026fit=max\u0026auto=format\u0026n=PHQlULcgtUSM8bYf\u0026q=85\u0026s=ac6e1fc48d49e4ba9af2bbd5742d004a 560w, https://mintcdn.com/kinetica/PHQlULcgtUSM8bYf/content/admin/images/cluster_setup.png?w=840\u0026fit=max\u0026auto=format\u0026n=PHQlULcgtUSM8bYf\u0026q=85\u0026s=c6879b80a25e2d3be9244ee16505bc94 840w, https://mintcdn.com/kinetica/PHQlULcgtUSM8bYf/content/admin/images/cluster_setup.png?w=1100\u0026fit=max\u0026auto=format\u0026n=PHQlULcgtUSM8bYf\u0026q=85\u0026s=3617844bfd2069067e98e356f7e416a5 1100w, https://mintcdn.com/kinetica/PHQlULcgtUSM8bYf/content/admin/images/cluster_setup.png?w=1650\u0026fit=max\u0026auto=format\u0026n=PHQlULcgtUSM8bYf\u0026q=85\u0026s=387cef5d2479ba7efea0c911dd3af8ad 1650w, https://mintcdn.com/kinetica/PHQlULcgtUSM8bYf/content/admin/images/cluster_setup.png?w=2500\u0026fit=max\u0026auto=format\u0026n=PHQlULcgtUSM8bYf\u0026q=85\u0026s=3926c264b6f80fad950046300711d884 2500w`}),`\n`,_jsx(Heading,{level:`2`,id:`config`,children:`Config`}),`\n`,_jsx(Note,{children:_jsxs(_components.p,{children:[`The `,_jsx(_components.strong,{children:`Cluster —> Config`}),` section is only available to users\nwith the `,_jsx(_components.em,{children:`System Admin`}),` permission.`]})}),`\n`,_jsxs(_components.p,{children:[`The `,_jsx(_components.strong,{children:`Config`}),` page allows you to edit the core `,_jsx(_components.em,{children:`Kinetica`}),` configuration\nfile and save the changes directly in `,_jsx(_components.a,{href:`/content/admin/gadmin`,children:`GAdmin`}),`; this file maps\nto the `,_jsx(Badge,{color:`gray`,children:`/opt/gpudb/core/etc/gpudb.conf`}),` file. Detailed\ninformation about configuration file settings can be found on\n`,_jsx(_components.a,{href:`/content/config`,children:`Configuration Reference`}),`.`]}),`\n`,_jsx(Info,{children:_jsxs(_components.p,{children:[`This tab can only be edited when `,_jsx(_components.em,{children:`Kinetica`}),` is not running.`]})}),`\n`,_jsx(OptimizedImage,{src:`https://mintcdn.com/kinetica/PHQlULcgtUSM8bYf/content/admin/images/cluster_config.png?fit=max\u0026auto=format\u0026n=PHQlULcgtUSM8bYf\u0026q=85\u0026s=828df8ce702fe6f5f46d2a5ca613241a`,alt:`../../images/cluster_config.png`,\"data-og-width\":`1000`,width:`1000`,\"data-og-height\":`739`,height:`739`,\"data-path\":`content/admin/images/cluster_config.png`,\"data-optimize\":`true`,\"data-opv\":`3`,srcset:`https://mintcdn.com/kinetica/PHQlULcgtUSM8bYf/content/admin/images/cluster_config.png?w=280\u0026fit=max\u0026auto=format\u0026n=PHQlULcgtUSM8bYf\u0026q=85\u0026s=4ffa11c18f2db7526c5cdc5c4ba978a5 280w, https://mintcdn.com/kinetica/PHQlULcgtUSM8bYf/content/admin/images/cluster_config.png?w=560\u0026fit=max\u0026auto=format\u0026n=PHQlULcgtUSM8bYf\u0026q=85\u0026s=111acd251a6b59090239fa21df04ad94 560w, https://mintcdn.com/kinetica/PHQlULcgtUSM8bYf/content/admin/images/cluster_config.png?w=840\u0026fit=max\u0026auto=format\u0026n=PHQlULcgtUSM8bYf\u0026q=85\u0026s=9faf491dfc11eb9814d8711516ed4dad 840w, https://mintcdn.com/kinetica/PHQlULcgtUSM8bYf/content/admin/images/cluster_config.png?w=1100\u0026fit=max\u0026auto=format\u0026n=PHQlULcgtUSM8bYf\u0026q=85\u0026s=33f9775f6a6b5938b0af3b19df5c4615 1100w, https://mintcdn.com/kinetica/PHQlULcgtUSM8bYf/content/admin/images/cluster_config.png?w=1650\u0026fit=max\u0026auto=format\u0026n=PHQlULcgtUSM8bYf\u0026q=85\u0026s=d3f7698d51a7f2e6a49528352135252e 1650w, https://mintcdn.com/kinetica/PHQlULcgtUSM8bYf/content/admin/images/cluster_config.png?w=2500\u0026fit=max\u0026auto=format\u0026n=PHQlULcgtUSM8bYf\u0026q=85\u0026s=93f768619572cca5bae4256c32b094a9 2500w`}),`\n`,_jsx(`a`,{id:`cluster-alerts`}),`\n`,_jsx(Heading,{level:`2`,id:`alerts`,children:`Alerts`}),`\n`,_jsxs(_components.p,{children:[`The `,_jsx(_components.strong,{children:`Alerts`}),` displays the most recent triggered alerts. Detailed\ninformation about alerts and how to set them can be found on\n`,_jsx(_components.a,{href:`/content/admin/alerting`,children:`Alerting`}),`.`]}),`\n`,_jsx(OptimizedImage,{src:`https://mintcdn.com/kinetica/PHQlULcgtUSM8bYf/content/admin/images/cluster_alerts.png?fit=max\u0026auto=format\u0026n=PHQlULcgtUSM8bYf\u0026q=85\u0026s=00110871f4a702976f18b270d21834a9`,alt:`../../images/cluster_alerts.png`,\"data-og-width\":`1000`,width:`1000`,\"data-og-height\":`489`,height:`489`,\"data-path\":`content/admin/images/cluster_alerts.png`,\"data-optimize\":`true`,\"data-opv\":`3`,srcset:`https://mintcdn.com/kinetica/PHQlULcgtUSM8bYf/content/admin/images/cluster_alerts.png?w=280\u0026fit=max\u0026auto=format\u0026n=PHQlULcgtUSM8bYf\u0026q=85\u0026s=75c037115c4fb6565b681a7eb223daad 280w, https://mintcdn.com/kinetica/PHQlULcgtUSM8bYf/content/admin/images/cluster_alerts.png?w=560\u0026fit=max\u0026auto=format\u0026n=PHQlULcgtUSM8bYf\u0026q=85\u0026s=36d84dbba4defff8bf15e1e74880b7a8 560w, https://mintcdn.com/kinetica/PHQlULcgtUSM8bYf/content/admin/images/cluster_alerts.png?w=840\u0026fit=max\u0026auto=format\u0026n=PHQlULcgtUSM8bYf\u0026q=85\u0026s=f8a25fdc4fbea9a6f081cc35b05d8473 840w, https://mintcdn.com/kinetica/PHQlULcgtUSM8bYf/content/admin/images/cluster_alerts.png?w=1100\u0026fit=max\u0026auto=format\u0026n=PHQlULcgtUSM8bYf\u0026q=85\u0026s=cc8d1da7c3926d3cd08a979d7dfcb830 1100w, https://mintcdn.com/kinetica/PHQlULcgtUSM8bYf/content/admin/images/cluster_alerts.png?w=1650\u0026fit=max\u0026auto=format\u0026n=PHQlULcgtUSM8bYf\u0026q=85\u0026s=7d3fffb4e74a4d699d0a2fa8db1ca5db 1650w, https://mintcdn.com/kinetica/PHQlULcgtUSM8bYf/content/admin/images/cluster_alerts.png?w=2500\u0026fit=max\u0026auto=format\u0026n=PHQlULcgtUSM8bYf\u0026q=85\u0026s=0e50bb065d951cfbd5f59f8ff6523b3c 2500w`}),`\n`,_jsx(`a`,{id:`cluster-logging`}),`\n`,_jsx(Heading,{level:`2`,id:`logging`,children:`Logging`}),`\n`,_jsxs(_components.p,{children:[`The `,_jsx(_components.strong,{children:`Logging`}),` page displays the running system log file, updating\nevery two seconds. This file is `,_jsx(_components.em,{children:`Kinetica’s`}),` main diagnostic tool and it is\nlocated at\n`,_jsx(Badge,{color:`gray`,children:`/opt/gpudb/core/logs/host-manager-\u003chostname>-\u003cdate-time>.log`}),`.`]}),`\n`,_jsx(Info,{children:_jsx(_components.p,{children:`If the cluster uses a shared persist directory, each nodes’ database log will\nbe located in this directory as well.`})}),`\n`,_jsxs(_components.p,{children:[`Select the `,_jsx(_components.strong,{children:`Pause Log`}),` checkbox to pause the file updates. The number\nof displayed lines can be selected from `,_jsx(_components.strong,{children:`Lines`}),`, and the displayed\nlines can be filtered using `,_jsx(_components.strong,{children:`Filter`}),` (select the `,_jsx(_components.strong,{children:`Exclude`}),`\ncheckbox to instead exclude the filtered word or phrase).`]}),`\n`,_jsx(OptimizedImage,{src:`https://mintcdn.com/kinetica/PHQlULcgtUSM8bYf/content/admin/images/cluster_logging.png?fit=max\u0026auto=format\u0026n=PHQlULcgtUSM8bYf\u0026q=85\u0026s=ea29b339edfc1f97ffce6cb55eda3575`,alt:`../../images/cluster_logging.png`,\"data-og-width\":`1000`,width:`1000`,\"data-og-height\":`375`,height:`375`,\"data-path\":`content/admin/images/cluster_logging.png`,\"data-optimize\":`true`,\"data-opv\":`3`,srcset:`https://mintcdn.com/kinetica/PHQlULcgtUSM8bYf/content/admin/images/cluster_logging.png?w=280\u0026fit=max\u0026auto=format\u0026n=PHQlULcgtUSM8bYf\u0026q=85\u0026s=17d1032b60fc43af2d80051979382a54 280w, https://mintcdn.com/kinetica/PHQlULcgtUSM8bYf/content/admin/images/cluster_logging.png?w=560\u0026fit=max\u0026auto=format\u0026n=PHQlULcgtUSM8bYf\u0026q=85\u0026s=1e6a02a260d90abe5b03c1139405c616 560w, https://mintcdn.com/kinetica/PHQlULcgtUSM8bYf/content/admin/images/cluster_logging.png?w=840\u0026fit=max\u0026auto=format\u0026n=PHQlULcgtUSM8bYf\u0026q=85\u0026s=1ad76754c9638fad39394d7639da8e6d 840w, https://mintcdn.com/kinetica/PHQlULcgtUSM8bYf/content/admin/images/cluster_logging.png?w=1100\u0026fit=max\u0026auto=format\u0026n=PHQlULcgtUSM8bYf\u0026q=85\u0026s=6aaf2f82d82874887bdbf95aa509d283 1100w, https://mintcdn.com/kinetica/PHQlULcgtUSM8bYf/content/admin/images/cluster_logging.png?w=1650\u0026fit=max\u0026auto=format\u0026n=PHQlULcgtUSM8bYf\u0026q=85\u0026s=f956b6e4d16e0d61318cc4dda2b86ce4 1650w, https://mintcdn.com/kinetica/PHQlULcgtUSM8bYf/content/admin/images/cluster_logging.png?w=2500\u0026fit=max\u0026auto=format\u0026n=PHQlULcgtUSM8bYf\u0026q=85\u0026s=e0d8ca3eccdd4d5562fd6614982e6dad 2500w`}),`\n`,_jsx(Heading,{level:`3`,id:`setting-loggers`,children:`Setting Loggers`}),`\n`,_jsxs(_components.p,{children:[`Click `,_jsx(_components.strong,{children:`Manage Logging Level`}),` to open the\n`,_jsx(_components.strong,{children:`Manage System Logging Level`}),` window, where the per-rank logging level\nfor any system logger can be modified.`]}),`\n`,_jsxs(_components.p,{children:[`To view the active loggers and corresponding levels for each rank, select the\nrank from the `,_jsx(_components.strong,{children:`Rank`}),` drop-down menu above the\n`,_jsx(_components.strong,{children:`Current Log Levels`}),` list. Use the `,_jsx(_components.strong,{children:`Filter`}),` below the list\nto find a particular logger in the list.`]}),`\n`,_jsx(_components.p,{children:`To update a logger:`}),`\n`,_jsxs(_components.ol,{children:[`\n`,_jsxs(_components.li,{children:[`At the top of the window, select a rank or `,_jsx(_components.em,{children:`ALL`}),` from the `,_jsx(_components.strong,{children:`Rank`}),`\ndrop-down window.`]}),`\n`,_jsxs(_components.li,{children:[`Provide a logger name for the `,_jsx(_components.strong,{children:`Logger`}),` field.`]}),`\n`,_jsxs(_components.li,{children:[`Select a logger level from the `,_jsx(_components.strong,{children:`Level`}),` drop-down menu.`]}),`\n`,_jsxs(_components.li,{children:[`Click `,_jsx(_components.strong,{children:`Set Logger`}),`.`]}),`\n`]}),`\n`,_jsx(Tip,{children:_jsxs(_components.p,{children:[`Instructions for manually changing the logging level via the\n`,_jsx(_components.code,{children:`/opt/gpudb/core/etc/gpudb_logger.conf`}),` file are located on the\n`,_jsx(_components.a,{href:`/content/admin/logging`,children:`Custom Logging`}),` documentation.`]})}),`\n`,_jsx(_components.p,{children:`Any change will take effect immediately and be in effect until a subsequent\nchange is made to the same logger or the database is restarted. A database\nrestart will reset all loggers to their default levels, system-wide.`}),`\n`,_jsx(OptimizedImage,{src:`https://mintcdn.com/kinetica/PHQlULcgtUSM8bYf/content/admin/images/cluster_sys_logging_level.png?fit=max\u0026auto=format\u0026n=PHQlULcgtUSM8bYf\u0026q=85\u0026s=76ec7457059ec6cc1d244c99f461f510`,alt:`../../images/cluster_sys_logging_level.png`,\"data-og-width\":`602`,width:`602`,\"data-og-height\":`659`,height:`659`,\"data-path\":`content/admin/images/cluster_sys_logging_level.png`,\"data-optimize\":`true`,\"data-opv\":`3`,srcset:`https://mintcdn.com/kinetica/PHQlULcgtUSM8bYf/content/admin/images/cluster_sys_logging_level.png?w=280\u0026fit=max\u0026auto=format\u0026n=PHQlULcgtUSM8bYf\u0026q=85\u0026s=a8af3592fde676631ff46332837b5b34 280w, https://mintcdn.com/kinetica/PHQlULcgtUSM8bYf/content/admin/images/cluster_sys_logging_level.png?w=560\u0026fit=max\u0026auto=format\u0026n=PHQlULcgtUSM8bYf\u0026q=85\u0026s=833e5be817f41ef4197eb082c6794741 560w, https://mintcdn.com/kinetica/PHQlULcgtUSM8bYf/content/admin/images/cluster_sys_logging_level.png?w=840\u0026fit=max\u0026auto=format\u0026n=PHQlULcgtUSM8bYf\u0026q=85\u0026s=e6dea1dd0022c786e200ce8497500db7 840w, https://mintcdn.com/kinetica/PHQlULcgtUSM8bYf/content/admin/images/cluster_sys_logging_level.png?w=1100\u0026fit=max\u0026auto=format\u0026n=PHQlULcgtUSM8bYf\u0026q=85\u0026s=8852bb7a625efb25bef3b661197f4e22 1100w, https://mintcdn.com/kinetica/PHQlULcgtUSM8bYf/content/admin/images/cluster_sys_logging_level.png?w=1650\u0026fit=max\u0026auto=format\u0026n=PHQlULcgtUSM8bYf\u0026q=85\u0026s=0f505355a4755a880271df4d1a811602 1650w, https://mintcdn.com/kinetica/PHQlULcgtUSM8bYf/content/admin/images/cluster_sys_logging_level.png?w=2500\u0026fit=max\u0026auto=format\u0026n=PHQlULcgtUSM8bYf\u0026q=85\u0026s=80d9d088d94199cf49ca78a28b410183 2500w`}),`\n`,_jsx(Heading,{level:`2`,id:`debug`,children:`Debug`}),`\n`,_jsxs(_components.p,{children:[`The `,_jsx(_components.strong,{children:`Debug`}),` page displays debugging and metric information about your\ncluster. Note that each section has nested information, so it’s possible\nto drill in for more details. From this page, you can also generate system\nreports and access previous reports. A system report includes important logs\nand files that can be sent to support (`,_jsx(_components.a,{href:`mailto:support@kinetica.com`,children:`support@kinetica.com`}),`) to help diagnose\nany issues at hand.`]}),`\n`,_jsx(OptimizedImage,{src:`https://mintcdn.com/kinetica/PHQlULcgtUSM8bYf/content/admin/images/cluster_debug.png?fit=max\u0026auto=format\u0026n=PHQlULcgtUSM8bYf\u0026q=85\u0026s=8ff5b07c1f1c238ae27c6f19130964b1`,alt:`../../images/cluster_debug.png`,\"data-og-width\":`1000`,width:`1000`,\"data-og-height\":`557`,height:`557`,\"data-path\":`content/admin/images/cluster_debug.png`,\"data-optimize\":`true`,\"data-opv\":`3`,srcset:`https://mintcdn.com/kinetica/PHQlULcgtUSM8bYf/content/admin/images/cluster_debug.png?w=280\u0026fit=max\u0026auto=format\u0026n=PHQlULcgtUSM8bYf\u0026q=85\u0026s=907e2fdfefc93cfa506ae648e5c7a1ee 280w, https://mintcdn.com/kinetica/PHQlULcgtUSM8bYf/content/admin/images/cluster_debug.png?w=560\u0026fit=max\u0026auto=format\u0026n=PHQlULcgtUSM8bYf\u0026q=85\u0026s=f90640965e6b8d35dfa847b6b81b0308 560w, https://mintcdn.com/kinetica/PHQlULcgtUSM8bYf/content/admin/images/cluster_debug.png?w=840\u0026fit=max\u0026auto=format\u0026n=PHQlULcgtUSM8bYf\u0026q=85\u0026s=3b25e1da8f47326632e79d58ad92c247 840w, https://mintcdn.com/kinetica/PHQlULcgtUSM8bYf/content/admin/images/cluster_debug.png?w=1100\u0026fit=max\u0026auto=format\u0026n=PHQlULcgtUSM8bYf\u0026q=85\u0026s=8e97f9a166f2dd6a7ea5b1a44198a1e5 1100w, https://mintcdn.com/kinetica/PHQlULcgtUSM8bYf/content/admin/images/cluster_debug.png?w=1650\u0026fit=max\u0026auto=format\u0026n=PHQlULcgtUSM8bYf\u0026q=85\u0026s=dc68011ee0a34372dd759e7079bbd149 1650w, https://mintcdn.com/kinetica/PHQlULcgtUSM8bYf/content/admin/images/cluster_debug.png?w=2500\u0026fit=max\u0026auto=format\u0026n=PHQlULcgtUSM8bYf\u0026q=85\u0026s=57678e27653ea6fd6ec6cb9e0d1efdda 2500w`}),`\n`,_jsx(`a`,{id:`cluster-demo`}),`\n`,_jsx(Heading,{level:`2`,id:`demo`,children:`Demo`}),`\n`,_jsx(Note,{children:_jsxs(_components.p,{children:[`The `,_jsx(_components.strong,{children:`Cluster —> Demo`}),` section is only available to users\nwith the `,_jsx(_components.em,{children:`System Admin`}),` permission.`]})}),`\n`,_jsxs(_components.p,{children:[`The `,_jsx(_components.strong,{children:`Demo`}),` page contains various data that you can load into\n`,_jsx(_components.em,{children:`Kinetica`}),`. This data will help get you started using `,_jsx(_components.em,{children:`Kinetica`}),` as well as\ndemonstrate some key capabilities of the system. Each demo dataset contains\n500,000 records; after loading the data into `,_jsx(_components.em,{children:`Kinetica`}),`, you have the option of\nloading the same data again. The datasets with a\n`,_jsx(_components.a,{href:`/content/bi/reveal`,children:`Reveal Dashboard`}),` button have a corresponding\nReveal dashboard that will be automatically setup in Reveal after ingesting the\ndata.`]}),`\n`,_jsx(OptimizedImage,{src:`https://mintcdn.com/kinetica/PHQlULcgtUSM8bYf/content/admin/images/cluster_demo.png?fit=max\u0026auto=format\u0026n=PHQlULcgtUSM8bYf\u0026q=85\u0026s=b873da5a6bbbb0e0a4b53b3b5067c300`,alt:`../../images/cluster_demo.png`,\"data-og-width\":`1000`,width:`1000`,\"data-og-height\":`585`,height:`585`,\"data-path\":`content/admin/images/cluster_demo.png`,\"data-optimize\":`true`,\"data-opv\":`3`,srcset:`https://mintcdn.com/kinetica/PHQlULcgtUSM8bYf/content/admin/images/cluster_demo.png?w=280\u0026fit=max\u0026auto=format\u0026n=PHQlULcgtUSM8bYf\u0026q=85\u0026s=6bd4967768ead07763eb24016851de3a 280w, https://mintcdn.com/kinetica/PHQlULcgtUSM8bYf/content/admin/images/cluster_demo.png?w=560\u0026fit=max\u0026auto=format\u0026n=PHQlULcgtUSM8bYf\u0026q=85\u0026s=f2624ff469527f2f166b2ed932893630 560w, https://mintcdn.com/kinetica/PHQlULcgtUSM8bYf/content/admin/images/cluster_demo.png?w=840\u0026fit=max\u0026auto=format\u0026n=PHQlULcgtUSM8bYf\u0026q=85\u0026s=5cd548480ac72ca17b8a672a5b1d3a63 840w, https://mintcdn.com/kinetica/PHQlULcgtUSM8bYf/content/admin/images/cluster_demo.png?w=1100\u0026fit=max\u0026auto=format\u0026n=PHQlULcgtUSM8bYf\u0026q=85\u0026s=7caa82fc2abe1c4fd4bb540835404d29 1100w, https://mintcdn.com/kinetica/PHQlULcgtUSM8bYf/content/admin/images/cluster_demo.png?w=1650\u0026fit=max\u0026auto=format\u0026n=PHQlULcgtUSM8bYf\u0026q=85\u0026s=6da2c22fa00fc9ffbc3b758e5e9be0e5 1650w, https://mintcdn.com/kinetica/PHQlULcgtUSM8bYf/content/admin/images/cluster_demo.png?w=2500\u0026fit=max\u0026auto=format\u0026n=PHQlULcgtUSM8bYf\u0026q=85\u0026s=e6bad260785e74351e37e6958bd6d36f 2500w`}),`\n`,_jsx(Heading,{level:`2`,id:`visualize`,children:`Visualize`}),`\n`,_jsxs(_components.p,{children:[`The `,_jsx(_components.strong,{children:`Visualize`}),` page contains an overview of\n`,_jsx(_components.a,{href:`/content/bi/reveal`,children:`Reveal`}),` as well as a quick link to Reveal.`]}),`\n`,_jsx(OptimizedImage,{src:`https://mintcdn.com/kinetica/PHQlULcgtUSM8bYf/content/admin/images/cluster_visualize.png?fit=max\u0026auto=format\u0026n=PHQlULcgtUSM8bYf\u0026q=85\u0026s=0a1b5c170c366e030270bea70824dbad`,alt:`../../images/cluster_visualize.png`,\"data-og-width\":`1000`,width:`1000`,\"data-og-height\":`479`,height:`479`,\"data-path\":`content/admin/images/cluster_visualize.png`,\"data-optimize\":`true`,\"data-opv\":`3`,srcset:`https://mintcdn.com/kinetica/PHQlULcgtUSM8bYf/content/admin/images/cluster_visualize.png?w=280\u0026fit=max\u0026auto=format\u0026n=PHQlULcgtUSM8bYf\u0026q=85\u0026s=b0895510b1ad0081b7bbd27237f49e2f 280w, https://mintcdn.com/kinetica/PHQlULcgtUSM8bYf/content/admin/images/cluster_visualize.png?w=560\u0026fit=max\u0026auto=format\u0026n=PHQlULcgtUSM8bYf\u0026q=85\u0026s=df346c0a13e128118005734a6e895d97 560w, https://mintcdn.com/kinetica/PHQlULcgtUSM8bYf/content/admin/images/cluster_visualize.png?w=840\u0026fit=max\u0026auto=format\u0026n=PHQlULcgtUSM8bYf\u0026q=85\u0026s=b99b50a8d723792835d4141eb36a2a1c 840w, https://mintcdn.com/kinetica/PHQlULcgtUSM8bYf/content/admin/images/cluster_visualize.png?w=1100\u0026fit=max\u0026auto=format\u0026n=PHQlULcgtUSM8bYf\u0026q=85\u0026s=35cffae998f907ca887dc36f79686e1d 1100w, https://mintcdn.com/kinetica/PHQlULcgtUSM8bYf/content/admin/images/cluster_visualize.png?w=1650\u0026fit=max\u0026auto=format\u0026n=PHQlULcgtUSM8bYf\u0026q=85\u0026s=35d61e7d6542035ef1282573dd221f4e 1650w, https://mintcdn.com/kinetica/PHQlULcgtUSM8bYf/content/admin/images/cluster_visualize.png?w=2500\u0026fit=max\u0026auto=format\u0026n=PHQlULcgtUSM8bYf\u0026q=85\u0026s=db7bc0d74d037738d428919161ae227b 2500w`})]})}function MDXContent(props={}){const{wrapper:MDXLayout}={..._provideComponents(),...props.components};return MDXLayout?_jsx(MDXLayout,{...props,children:_jsx(_createMdxContent,{...props})}):_createMdxContent(props)}return{default:MDXContent};function _missingMdxReference(id,component){throw new Error(`Expected `+(component?`component`:`object`)+\" `\"+id+\"` to be defined: you likely forgot to import, pass, or provide it.\")}","frontmatter":{},"scope":{"config":{},"pageMetadata":{"title":"Cluster","sidebarTitle":"Cluster","description":null,"href":"/content/admin/gadmin/cluster"}}},"mdxSourceWithNoJs":null},"mdxExtracts":{"tableOfContents":[{"title":"Dashboard","slug":"dashboard","depth":2,"children":[]},{"title":"Ranks","slug":"ranks","depth":2,"children":[]},{"title":"Admin","slug":"admin","depth":2,"children":[]},{"title":"License","slug":"license","depth":2,"children":[]},{"title":"Config","slug":"config","depth":2,"children":[]},{"title":"Alerts","slug":"alerts","depth":2,"children":[]},{"title":"Logging","slug":"logging","depth":2,"children":[{"title":"Setting Loggers","slug":"setting-loggers","depth":3,"children":[]}]},{"title":"Debug","slug":"debug","depth":2,"children":[]},{"title":"Demo","slug":"demo","depth":2,"children":[]},{"title":"Visualize","slug":"visualize","depth":2,"children":[]}],"codeExamples":{}},"jsLinks":[],"subdomain":"kinetica","siteName":"Kinetica Docs","title":"Cluster - Kinetica Docs","navMaps":{"firstHrefInVersion":{},"firstHrefInLanguage":{}},"lastModified":"2026-10-27T15:48:48.457Z","originalFileLocation":"content/admin/gadmin/cluster.mdx"},"headHtml":"\u003cscript data-mint-head>(function(){var d=document.documentElement,p=null;if(!p){try{p=localStorage.getItem(\"isDarkMode\")}catch(e){}if(p==='true')p='dark';else if(p==='false')p='light';if(p!=='light'\u0026\u0026p!=='dark'\u0026\u0026p!=='system')p=\"system\"}var r=p==='system'?(matchMedia(\"(prefers-color-scheme: dark)\").matches?'dark':'light'):p;d.classList.remove(r==='dark'?'light':'dark');d.classList.add(r);d.setAttribute(\"data-theme-preference\",p)})();\u003c/script>\u003cmeta data-mint-head name=\"application-name\" content=\"Kinetica Docs\">\u003cmeta data-mint-head name=\"generator\" content=\"Mintlify\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/mintlify-assets/_mintlify/favicons/kinetica/rE4Dy6pEskB3eaKU/_generated/favicon/android-chrome-192x192.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"apple-touch-icon\" type=\"image/png\" sizes=\"180x180\" href=\"/mintlify-assets/_mintlify/favicons/kinetica/rE4Dy6pEskB3eaKU/_generated/favicon/apple-touch-icon.png\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/mintlify-assets/_mintlify/favicons/kinetica/rE4Dy6pEskB3eaKU/_generated/favicon/favicon-16x16.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"32x32\" href=\"/mintlify-assets/_mintlify/favicons/kinetica/rE4Dy6pEskB3eaKU/_generated/favicon/favicon-32x32.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"shortcut icon\" type=\"image/x-icon\" href=\"/mintlify-assets/_mintlify/favicons/kinetica/rE4Dy6pEskB3eaKU/_generated/favicon/favicon.ico\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/mintlify-assets/_mintlify/favicons/kinetica/rE4Dy6pEskB3eaKU/_generated/favicon-dark/android-chrome-192x192.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/mintlify-assets/_mintlify/favicons/kinetica/rE4Dy6pEskB3eaKU/_generated/favicon-dark/favicon-16x16.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"32x32\" href=\"/mintlify-assets/_mintlify/favicons/kinetica/rE4Dy6pEskB3eaKU/_generated/favicon-dark/favicon-32x32.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"shortcut icon\" type=\"image/x-icon\" href=\"/mintlify-assets/_mintlify/favicons/kinetica/rE4Dy6pEskB3eaKU/_generated/favicon-dark/favicon.ico\" media=\"(prefers-color-scheme: dark)\">\u003cmeta data-mint-head property=\"og:title\" content=\"Cluster - Kinetica Docs\">\u003cmeta data-mint-head property=\"og:site_name\" content=\"Kinetica Docs\">\u003cmeta data-mint-head property=\"og:url\" content=\"https://docs.kinetica.com/content/admin/gadmin/cluster\">\u003cmeta data-mint-head property=\"og:type\" content=\"website\">\u003cmeta data-mint-head property=\"og:image\" content=\"https://kinetica.mintlify.app/_mintlify/api/og/v2?division=GAdmin\u0026amp;title=Cluster\u0026amp;theme=b95185999a2d24ec64ae9616\u0026amp;signature=d187c5f7ba2a1a09ebfa8aeaed6fd923bce81543c410e9add1214eed982076f2\">\u003cmeta data-mint-head property=\"og:image:width\" content=\"1200\">\u003cmeta data-mint-head property=\"og:image:height\" content=\"630\">\u003cmeta data-mint-head name=\"twitter:card\" content=\"summary_large_image\">\u003cmeta data-mint-head name=\"twitter:title\" content=\"Cluster - Kinetica Docs\">\u003cmeta data-mint-head name=\"twitter:image\" content=\"https://kinetica.mintlify.app/_mintlify/api/og/v2?division=GAdmin\u0026amp;title=Cluster\u0026amp;theme=b95185999a2d24ec64ae9616\u0026amp;signature=d187c5f7ba2a1a09ebfa8aeaed6fd923bce81543c410e9add1214eed982076f2\">\u003cmeta data-mint-head name=\"twitter:image:width\" content=\"1200\">\u003cmeta data-mint-head name=\"twitter:image:height\" content=\"630\">\u003cmeta data-mint-head name=\"msapplication-config\" content=\"/mintlify-assets/_mintlify/favicons/kinetica/rE4Dy6pEskB3eaKU/_generated/favicon/browserconfig.xml\">\u003cmeta data-mint-head name=\"apple-mobile-web-app-title\" content=\"Kinetica Docs\">\u003cmeta data-mint-head name=\"msapplication-TileColor\" content=\"#6366f1\">\u003clink data-mint-head rel=\"canonical\" href=\"https://docs.kinetica.com/content/admin/gadmin/cluster\">\u003clink data-mint-head rel=\"alternate\" type=\"application/xml\" href=\"/sitemap.xml\">\u003clink data-mint-head rel=\"alternate\" type=\"text/markdown\" href=\"/content/admin/gadmin/cluster.md\">\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https://docs.kinetica.com/#organization\",\"name\":\"Kinetica Docs\",\"url\":\"https://docs.kinetica.com\",\"logo\":{\"@type\":\"ImageObject\",\"url\":\"https://mintcdn.com/kinetica/1Hn5MNMQp397m0Vp/images/logo-light.svg?fit=max\u0026auto=format\u0026n=1Hn5MNMQp397m0Vp\u0026q=85\u0026s=b9dbe33a7cd8b6a24d26de6d5a527049\"}},{\"@type\":\"WebSite\",\"@id\":\"https://docs.kinetica.com#website\",\"name\":\"Kinetica Docs\",\"url\":\"https://docs.kinetica.com\",\"publisher\":{\"@id\":\"https://docs.kinetica.com/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https://docs.kinetica.com/content/admin/gadmin/cluster#webpage\",\"url\":\"https://docs.kinetica.com/content/admin/gadmin/cluster\",\"name\":\"Cluster\",\"dateModified\":\"2026-10-27T15:48:48.457Z\",\"isPartOf\":{\"@id\":\"https://docs.kinetica.com#website\"},\"breadcrumb\":{\"@id\":\"https://docs.kinetica.com/content/admin/gadmin/cluster#breadcrumb\"}},{\"@type\":\"BreadcrumbList\",\"@id\":\"https://docs.kinetica.com/content/admin/gadmin/cluster#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Documentation\",\"item\":\"https://docs.kinetica.com/index\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Administration\",\"item\":\"https://docs.kinetica.com/content/admin/index\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"GAdmin\",\"item\":\"https://docs.kinetica.com/content/admin/gadmin/index\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"Cluster\",\"item\":\"https://docs.kinetica.com/content/admin/gadmin/cluster\"}]},{\"@type\":[\"Article\",\"TechArticle\"],\"@id\":\"https://docs.kinetica.com/content/admin/gadmin/cluster#article\",\"headline\":\"Cluster\",\"name\":\"Cluster\",\"url\":\"https://docs.kinetica.com/content/admin/gadmin/cluster\",\"mainEntityOfPage\":{\"@id\":\"https://docs.kinetica.com/content/admin/gadmin/cluster#webpage\"},\"dateModified\":\"2026-10-27T15:48:48.457Z\",\"publisher\":{\"@id\":\"https://docs.kinetica.com/#organization\"},\"isPartOf\":{\"@id\":\"https://docs.kinetica.com#website\"}}]}\u003c/script>\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@type\":\"WebSite\",\"name\":\"Kinetica Docs\",\"creator\":{\"@type\":\"Organization\",\"name\":\"Mintlify\",\"url\":\"https://mintlify.com\"}}\u003c/script>","siteName":"Kinetica Docs","nav":{"global":null,"tabs":[{"tab":"Documentation","groups":[{"group":"Documentation","pages":[{"group":"Home","pages":[{"title":"Kinetica Enterprise Documentation","href":""}]},{"group":"Kinetica Overview","pages":[{"title":"Overview","sidebarTitle":"What is Kinetica?","href":"/content/overview/index"},{"title":" Distributed Ingest","href":"/_redirect/tuning/multihead/multihead_ingest/_Distributed Ingest"},{"title":" Distributed Key Lookup","href":"/_redirect/tuning/multihead/multihead_egress/_Distributed Key Lookup"},{"title":"User-Defined Functions Overview","sidebarTitle":"User-Defined Functions Overview","href":"/content/udf_overview"},{"title":"Cloud-Ready","sidebarTitle":"Cloud-Ready","href":"/content/cloud/index"}]},{"group":"Concepts","pages":[{"title":"Concepts","sidebarTitle":"Overview","href":"/content/concepts/index"},{"group":"Entities","pages":[{"title":"Entities","sidebarTitle":"Overview","href":"/content/concepts/entities"},{"title":"Schemas","sidebarTitle":"Schemas","href":"/content/concepts/schemas"},{"group":"Types","pages":[{"title":"Types","href":"/content/concepts/types"},{"title":"Arrays","sidebarTitle":"Array","href":"/content/concepts/array"},{"title":"JSON","sidebarTitle":"JSON","href":"/content/concepts/json"},{"title":"Nulls","sidebarTitle":"Nulls","href":"/content/concepts/nulls"}]},{"title":"Tables","sidebarTitle":"Tables","href":"/content/concepts/tables"},{"group":"Views","pages":[{"title":"Views","sidebarTitle":"Overview","href":"/content/concepts/views"},{"title":"Filtered Views","sidebarTitle":"Filtered","href":"/content/concepts/filtered_views"},{"title":"Joins","sidebarTitle":"Joins","href":"/content/concepts/joins"},{"title":"Materialized Views","sidebarTitle":"Materialized","href":"/content/concepts/materialized_views"}]},{"title":"Indexes","sidebarTitle":"Indexes","href":"/content/concepts/indexes"},{"title":"Credentials","sidebarTitle":"Credentials","href":"/content/concepts/credentials"},{"title":"Data Sources","sidebarTitle":"Data Sources","href":"/content/concepts/data_sources"},{"title":"Data Sinks","sidebarTitle":"Data Sinks","href":"/content/concepts/data_sinks"},{"group":"External Tables","pages":[{"title":"External Tables","href":"/content/concepts/external_tables"},{"group":"Data Lake Catalogs","pages":[{"title":"Data Lake Catalogs","href":"/content/concepts/datalake"},{"title":"Apache Iceberg","sidebarTitle":"Apache Iceberg","href":"/content/concepts/iceberg"},{"title":"Delta Lake","sidebarTitle":"Delta Lake","href":"/content/concepts/delta"}]}]},{"title":" Graphs","href":"/_redirect/graph_solver/network_graph_solver/_Graphs"},{"title":"Table Monitors","sidebarTitle":"Table Monitors","href":"/content/concepts/table_monitors"}]},{"group":"Features","pages":[{"title":"Features","sidebarTitle":"Overview","href":"/content/concepts/features"},{"title":"Column Compression","sidebarTitle":"Column Compression","href":"/content/concepts/column_compression"},{"title":"Dictionary Encoding","sidebarTitle":"Dictionary Encoding","href":"/content/concepts/dictionary_encoding"},{"title":"Full Text Search","sidebarTitle":"Full Text Search","href":"/content/concepts/full_text_search"},{"title":"TTL","sidebarTitle":"TTL","href":"/content/concepts/ttl"}]},{"group":"Operations","pages":[{"title":"Operations","sidebarTitle":"Overview","href":"/content/concepts/operations"},{"title":"Expressions","sidebarTitle":"Expressions","href":"/content/concepts/expressions"},{"title":"Aggregation","sidebarTitle":"Aggregation","href":"/content/concepts/aggregation"},{"title":"Iteration","sidebarTitle":"Iteration","href":"/content/concepts/iteration"},{"title":"Memory-Only Tables","sidebarTitle":"Memory-Only Tables","href":"/content/concepts/tables_memory_only"},{"title":"Projections","sidebarTitle":"Projections","href":"/content/concepts/projections"},{"title":" Joins","href":"/_redirect/concepts/joins/_Joins"},{"title":"Union","sidebarTitle":"Set Unions","href":"/content/concepts/unions"},{"title":"Intersect","sidebarTitle":"Set Intersections","href":"/content/concepts/intersect"},{"title":"Except","sidebarTitle":"Set Subtractions","href":"/content/concepts/except"},{"title":"Window","sidebarTitle":"Window","href":"/content/concepts/window"},{"title":"Rollup","sidebarTitle":"Rollup","href":"/content/concepts/rollup"},{"title":"Cube","sidebarTitle":"Cube","href":"/content/concepts/cube"},{"title":"Grouping Sets","sidebarTitle":"Grouping Sets","href":"/content/concepts/grouping_sets"},{"title":"Pivot","sidebarTitle":"Pivot","href":"/content/concepts/pivot"},{"title":"Unpivot","sidebarTitle":"Unpivot","href":"/content/concepts/unpivot"}]}]},{"group":"Install \u0026 Configure","pages":[{"title":"Installation \u0026 Configuration","sidebarTitle":"Overview","href":"/content/install/index"},{"title":" Quick Start","href":"/_redirect/guides/quickstart-guide/_Quick Start"},{"group":"Installation Options","pages":[{"title":"Installation Options","sidebarTitle":"Overview","href":"/content/install/installation"},{"group":"Install with KAgent","pages":[{"title":"Kinetica Installation with KAgent","href":"/content/install/kagent_install"},{"title":"KAgent","sidebarTitle":"KAgent Installation","href":"/content/install/kagent"}]},{"title":"Kinetica Installation with Kubernetes","sidebarTitle":"Install with Kubernetes","href":"/content/install/kubernetes"},{"group":"Manual Installation","pages":[{"title":"Manual Kinetica Installation","href":"/content/install/package"},{"title":"GPU Driver","sidebarTitle":"GPU Driver","href":"/content/install/shared/gpu_driver"},{"title":"Ports","sidebarTitle":"Ports","href":"/content/install/shared/ports"},{"title":"Adjust Firewall","sidebarTitle":"Adjust Firewall","href":"/content/install/shared/adjust_firewall"},{"title":"Install Nvidia Drivers on RHEL","sidebarTitle":"Nvidia Drivers on RHEL","href":"/content/install/nvidia_rhel"},{"title":"Install Nvidia Drivers on Debian/Ubuntu","sidebarTitle":"Nvidia Drivers on Debian/Ubuntu","href":"/content/install/nvidia_deb"}]}]},{"group":"Resource Management","pages":[{"title":"Resource Management","sidebarTitle":"Overview","href":"/content/rm/index"},{"title":"Resource Management Concepts","sidebarTitle":"Concepts","href":"/content/rm/concepts"},{"title":"Resource Management Usage","sidebarTitle":"Usage","href":"/content/rm/usage"},{"title":"Resource Management Configuration","sidebarTitle":"Configuration","href":"/content/rm/configuration"}]},{"group":"High Availability","pages":[{"title":"High Availability","sidebarTitle":"Overview","href":"/content/ha/index"},{"title":"High Availability Architecture","sidebarTitle":"Architecture","href":"/content/ha/ha_architecture"},{"title":"High Availability Configuration \u0026 Management","sidebarTitle":"Configuration \u0026 Management","href":"/content/ha/ha_configuration"}]},{"title":"Configuration Reference","sidebarTitle":"Configuration Reference","href":"/content/config/index"}]},{"group":"Administration","pages":[{"title":"Administration","sidebarTitle":"Overview","href":"/content/admin/index"},{"group":"Kinetica Workbench","pages":[{"title":"Kinetica Workbench","href":"/content/admin/workbench/index"},{"group":"Workbench UI","pages":[{"title":"Workbench UI","href":"/content/admin/workbench/ui/index"},{"title":"Home","sidebarTitle":"Home","href":"/content/admin/workbench/ui/home"},{"group":"Workbench Explorer","pages":[{"title":"Workbench Explorer","href":"/content/admin/workbench/ui/explorer/index"},{"title":"Data Explorer","sidebarTitle":"Data Explorer","href":"/content/admin/workbench/ui/explorer/data"},{"title":"File Explorer","sidebarTitle":"File Explorer","href":"/content/admin/workbench/ui/explorer/files"},{"title":"Workbook Explorer","sidebarTitle":"Workbook Explorer","href":"/content/admin/workbench/ui/explorer/workbooks"}]},{"title":"Explore","sidebarTitle":"Explore","href":"/content/admin/workbench/ui/explore/index"},{"group":"Import","pages":[{"title":"Import","href":"/content/admin/workbench/ui/import/index"},{"title":"Kinetica Import","sidebarTitle":"Kinetica Import","href":"/content/admin/workbench/ui/import/kinetica"},{"title":"File Upload Import","sidebarTitle":"File Upload Import","href":"/content/admin/workbench/ui/import/upload"},{"title":"Kinetica FileSystem Import","sidebarTitle":"Kinetica FileSystem Import","href":"/content/admin/workbench/ui/import/kifs"},{"title":"Amazon S3 Import","sidebarTitle":"Amazon S3 Import","href":"/content/admin/workbench/ui/import/s3"},{"title":"Azure Blob Storage Import","sidebarTitle":"Azure Blob Storage Import","href":"/content/admin/workbench/ui/import/azure"},{"title":"HDFS Import","sidebarTitle":"HDFS Import","href":"/content/admin/workbench/ui/import/hdfs"},{"title":"JDBC Import","sidebarTitle":"JDBC Import","href":"/content/admin/workbench/ui/import/jdbc"},{"title":"JDBC Data Source Import","sidebarTitle":"JDBC Data Source Import","href":"/content/admin/workbench/ui/import/jdbc_prov"},{"title":"Kafka Stream Import","sidebarTitle":"Kafka Stream Import","href":"/content/admin/workbench/ui/import/kafka"}]},{"title":"Jobs","sidebarTitle":"Jobs","href":"/content/admin/workbench/ui/jobs"}]}]},{"group":"GAdmin","pages":[{"title":"Kinetica Administration Application (GAdmin)","sidebarTitle":"Overview","description":null,"href":"/content/admin/gadmin/index"},{"title":"Cluster","sidebarTitle":"Cluster","href":"/content/admin/gadmin/cluster"},{"title":"Data","sidebarTitle":"Data","description":null,"href":"/content/admin/gadmin/data"},{"title":"Query","sidebarTitle":"Query","href":"/content/admin/gadmin/query"},{"title":"UDF","sidebarTitle":"UDF","href":"/content/admin/gadmin/udf"},{"title":"Jobs","sidebarTitle":"Jobs","href":"/content/admin/gadmin/jobs"},{"title":"Resource","sidebarTitle":"Resource","href":"/content/admin/gadmin/resource"},{"title":"Security (User/Role Management)","sidebarTitle":"Security (User/Role Management)","href":"/content/admin/gadmin/security"},{"title":"User","sidebarTitle":"User","href":"/content/admin/gadmin/user"},{"title":"Info (Instance Information)","sidebarTitle":"Info (Instance Information)","href":"/content/admin/gadmin/info"},{"title":"Stats","sidebarTitle":"Stats","href":"/content/admin/gadmin/stats"},{"title":"Support","sidebarTitle":"Support","href":"/content/admin/gadmin/support"}]},{"group":"KAgent","pages":[{"title":"KAgent","href":"/content/admin/kagent/kagent"},{"title":"Dashboard","sidebarTitle":"Dashboard","href":"/content/admin/kagent/dashboard"},{"title":"Alerts","sidebarTitle":"Alerts","href":"/content/admin/kagent/alerts"},{"title":"Events","sidebarTitle":"Events","href":"/content/admin/kagent/events"},{"title":"Queries","sidebarTitle":"Queries","href":"/content/admin/kagent/queries"},{"title":"Usage","sidebarTitle":"Usage","href":"/content/admin/kagent/usage"},{"title":"Manage","sidebarTitle":"Manage","href":"/content/admin/kagent/manage"},{"title":"Adding a Cluster to KAgent","sidebarTitle":"Adding a Cluster to KAgent","href":"/content/admin/adding_cluster_kagent"}]},{"group":"Managing Services","pages":[{"title":"Managing Kinetica Services","href":"/content/admin/services"},{"title":"Host Manager","sidebarTitle":"Host Manager","href":"/content/admin/host_manager"},{"title":"Job Manager","sidebarTitle":"Job Manager","href":"/content/admin/job_manager"},{"title":"Custom Logging","sidebarTitle":"Custom Logging","href":"/content/admin/logging"}]},{"group":"Monitoring \u0026 Alerting (KAgent)","pages":[{"title":"Monitoring and Alerting","href":"/content/admin/monitoring_alerting"},{"title":"Alerting","sidebarTitle":"Alerting","href":"/content/admin/alerting"},{"title":"Event Codes","sidebarTitle":"Event Codes","href":"/content/admin/event_codes"}]},{"title":"Upgrade","sidebarTitle":"Upgrading","href":"/content/admin/upgrade"},{"title":"Backing Up/Restoring Kinetica","sidebarTitle":"Back Up \u0026 Restoring","href":"/content/admin/backup_restore"},{"title":"Changing the Administrator Password","sidebarTitle":"Changing the Admin Password","href":"/content/admin/changing_password"}]},{"group":"Load Data","pages":[{"title":"Load Data","sidebarTitle":"Overview","href":"/content/load_data/index"},{"title":"Data Loading Concepts","sidebarTitle":"Data Loading Concepts","href":"/content/load_data/concepts"},{"title":" Data Loading via REST","href":"/_redirect/api/rest/insert_records_json_rest/_Data Loading via REST"},{"title":" Data Loading in SQL","href":"/_redirect/sql/load/_Data Loading in SQL"},{"group":"By Source","pages":[{"title":"Load Data by Source","href":"/content/load_data/by_source/index"},{"title":"Load Data from Azure Blob","sidebarTitle":"Azure Blob","href":"/content/load_data/by_source/azure_blob"},{"title":"Load Data from GCS","sidebarTitle":"GCS","href":"/content/load_data/by_source/gcs"},{"title":"Load Data from HDFS","sidebarTitle":"HDFS","href":"/content/load_data/by_source/hdfs"},{"title":"Load Data from JDBC","sidebarTitle":"JDBC","href":"/content/load_data/by_source/jdbc"},{"title":"Load Data from Apache Kafka","sidebarTitle":"Kafka (Apache)","href":"/content/load_data/by_source/kafka"},{"title":"Load Data from Confluent Kafka","sidebarTitle":"Kafka (Confluent)","href":"/content/load_data/by_source/confluent"},{"title":"Load Data from KiFS","sidebarTitle":"KiFS","href":"/content/load_data/by_source/kifs"},{"title":"Load Data from Local File","sidebarTitle":"Local","href":"/content/load_data/by_source/local"},{"title":"Load Data from S3","sidebarTitle":"S3","href":"/content/load_data/by_source/s3"}]}]},{"group":"SQL","pages":[{"title":"SQL","sidebarTitle":"Overview","href":"/content/sql/index"},{"group":"Naming","pages":[{"title":"Naming","href":"/content/sql/naming"},{"title":"SQL Reserved Word List","sidebarTitle":"Reserved Words","href":"/content/sql/sql_reserved_words"}]},{"group":"Queries","pages":[{"title":"Queries (SQL)","sidebarTitle":"Overview","href":"/content/sql/query"},{"group":"Query Features","pages":[{"title":"SELECT Statement","href":"/content/sql/query/select-statement"},{"title":"Tableless Query","href":"/content/sql/query/tableless-query"},{"title":"Join","href":"/content/sql/query/join"},{"title":"Aggregation","href":"/content/sql/query/aggregation"},{"title":"Grouping","href":"/content/sql/query/grouping"},{"title":"Window","href":"/content/sql/query/window"},{"title":"PIVOT","href":"/content/sql/query/pivot"},{"title":"UNPIVOT","href":"/content/sql/query/unpivot"},{"title":"Set Operations","href":"/content/sql/query/set-operations"},{"title":"WITH (Common Table Expressions)","href":"/content/sql/query/with-common-table-expressions"},{"title":"Iteration","href":"/content/sql/query/iteration"},{"title":"Constants","href":"/content/sql/query/constants"},{"title":"Expressions","href":"/content/sql/query/expressions"},{"title":"Predicates","href":"/content/sql/query/predicates"},{"title":"Subqueries","href":"/content/sql/query/subqueries"},{"title":"Remote Queries","href":"/content/sql/query/remote-queries"},{"title":"Hints","href":"/content/sql/query/hints"},{"title":"EXPLAIN","href":"/content/sql/query/explain"}]},{"group":"Functions","pages":[{"title":"Array Functions","href":"/content/sql/query/array-functions"},{"title":"Conditional Functions","href":"/content/sql/query/conditional-functions"},{"title":"Conversion Functions","href":"/content/sql/query/conversion-functions"},{"title":"Date/Time Functions","href":"/content/sql/query/date-time-functions"},{"title":"Geospatial/Geometry Functions","href":"/content/sql/query/geospatial-geometry-functions"},{"title":"JSON Functions","href":"/content/sql/query/json-functions"},{"title":"Math Functions","href":"/content/sql/query/math-functions"},{"title":"Null Functions","href":"/content/sql/query/null-functions"},{"title":"String Functions","href":"/content/sql/query/string-functions"},{"title":"User/Security Functions","href":"/content/sql/query/user-security-functions"},{"title":"Aggregation Functions","href":"/content/sql/query/aggregation-functions"},{"title":"Grouping Functions","href":"/content/sql/query/grouping-functions"},{"title":"ML Functions","href":"/content/sql/query/ml-functions"},{"title":"Distribution Functions","href":"/content/sql/query/distribution-functions"}]}]},{"group":"DML","pages":[{"title":"Data Manipulation (DML)","href":"/content/sql/dml"},{"title":"INSERT","href":"/content/sql/dml/insert"},{"title":"UPDATE","href":"/content/sql/dml/update"},{"title":"MERGE INTO","href":"/content/sql/dml/merge-into"},{"title":"DELETE","href":"/content/sql/dml/delete"}]},{"group":"DDL","pages":[{"title":"Data Definition (DDL)","href":"/content/sql/ddl"},{"group":"Columns","pages":[{"title":"Column Concepts","href":"/content/sql/ddl/column-concepts"},{"title":"Column Types","href":"/content/sql/ddl/column-types"},{"title":"Column Properties","href":"/content/sql/ddl/column-properties"}]},{"group":"Schema","pages":[{"title":"CREATE SCHEMA","href":"/content/sql/ddl/create-schema"},{"title":"ALTER SCHEMA","href":"/content/sql/ddl/alter-schema"},{"title":"DROP SCHEMA","href":"/content/sql/ddl/drop-schema"},{"title":"SHOW SCHEMA","href":"/content/sql/ddl/show-schema"},{"title":"DESCRIBE SCHEMA","href":"/content/sql/ddl/describe-schema"},{"title":"SET CURRENT SCHEMA","href":"/content/sql/ddl/set-current-schema"}]},{"group":"Table","pages":[{"title":"CREATE TABLE","href":"/content/sql/ddl/create-table"},{"title":"CREATE EXTERNAL TABLE","href":"/content/sql/ddl/create-external-table"},{"title":"CREATE TABLE ... AS","href":"/content/sql/ddl/create-table-as"},{"title":"ALTER TABLE","href":"/content/sql/ddl/alter-table"},{"title":"REFRESH EXTERNAL TABLE","href":"/content/sql/ddl/refresh-external-table"},{"title":"CHECK TABLE","href":"/content/sql/ddl/check-table"},{"title":"REPAIR TABLE","href":"/content/sql/ddl/repair-table"},{"title":"TRUNCATE TABLE","href":"/content/sql/ddl/truncate-table"},{"title":"DROP TABLE","href":"/content/sql/ddl/drop-table"},{"title":"SHOW TABLE","href":"/content/sql/ddl/show-table"},{"title":"DESCRIBE TABLE","href":"/content/sql/ddl/describe-table"},{"title":"COLLECT STATISTICS","href":"/content/sql/ddl/collect-statistics"},{"title":"DROP STATISTICS","href":"/content/sql/ddl/drop-statistics"},{"title":"DESCRIBE WAL","href":"/content/sql/ddl/describe-wal"},{"title":"Session Temp Tables","href":"/content/sql/ddl/session-temp-tables"}]},{"group":"View","pages":[{"title":"CREATE VIEW","href":"/content/sql/ddl/create-view"},{"title":"CREATE MATERIALIZED VIEW","href":"/content/sql/ddl/create-materialized-view"},{"title":"ALTER VIEW","href":"/content/sql/ddl/alter-view"},{"title":"ALTER MATERIALIZED VIEW","href":"/content/sql/ddl/alter-materialized-view"},{"title":"REFRESH VIEW","href":"/content/sql/ddl/refresh-view"},{"title":"DROP VIEW","href":"/content/sql/ddl/drop-view"},{"title":"SHOW VIEW","href":"/content/sql/ddl/show-view"},{"title":"DESCRIBE VIEW","href":"/content/sql/ddl/describe-view"}]},{"group":"Credential","pages":[{"title":"CREATE CREDENTIAL","href":"/content/sql/ddl/create-credential"},{"title":"ALTER CREDENTIAL","href":"/content/sql/ddl/alter-credential"},{"title":"DROP CREDENTIAL","href":"/content/sql/ddl/drop-credential"},{"title":"SHOW CREDENTIAL","href":"/content/sql/ddl/show-credential"},{"title":"DESCRIBE CREDENTIAL","href":"/content/sql/ddl/describe-credential"}]},{"group":"Data Source","pages":[{"title":"CREATE DATA SOURCE","href":"/content/sql/ddl/create-data-source"},{"title":"ALTER DATA SOURCE","href":"/content/sql/ddl/alter-data-source"},{"title":"LIST DATA SOURCE","href":"/content/sql/ddl/list-data-source"},{"title":"DROP DATA SOURCE","href":"/content/sql/ddl/drop-data-source"},{"title":"SHOW DATA SOURCE","href":"/content/sql/ddl/show-data-source"},{"title":"DESCRIBE DATA SOURCE","href":"/content/sql/ddl/describe-data-source"}]},{"group":"Data Sink","pages":[{"title":"CREATE DATA SINK","href":"/content/sql/ddl/create-data-sink"},{"title":"ALTER DATA SINK","href":"/content/sql/ddl/alter-data-sink"},{"title":"DROP DATA SINK","href":"/content/sql/ddl/drop-data-sink"},{"title":"SHOW DATA SINK","href":"/content/sql/ddl/show-data-sink"},{"title":"DESCRIBE DATA SINK","href":"/content/sql/ddl/describe-data-sink"}]},{"group":"Data Lake Catalog","pages":[{"title":"CREATE CATALOG","href":"/content/sql/ddl/create-catalog"},{"title":"DROP CATALOG","href":"/content/sql/ddl/drop-catalog"},{"title":"SHOW CATALOG","href":"/content/sql/ddl/show-catalog"},{"title":"DESCRIBE CATALOG","href":"/content/sql/ddl/describe-catalog"}]},{"group":"Stream","pages":[{"title":"CREATE STREAM","href":"/content/sql/ddl/create-stream"},{"title":"DROP STREAM","href":"/content/sql/ddl/drop-stream"},{"title":"SHOW STREAM","href":"/content/sql/ddl/show-stream"},{"title":"DESCRIBE STREAM","href":"/content/sql/ddl/describe-stream"}]},{"group":"Other","pages":[{"title":"DESCRIBE","href":"/content/sql/ddl/describe"},{"title":"Comments","href":"/content/sql/ddl/comments"}]}]},{"group":"Loading Data","pages":[{"title":"Loading Data","sidebarTitle":"Overview","href":"/content/sql/load"},{"title":"LOAD INTO","href":"/content/sql/load/load-into"},{"title":"INSERT INTO ... SELECT ... FROM FILE","href":"/content/sql/load/insert-into-select-from-file"}]},{"group":"Exporting Data","pages":[{"title":"Exporting Data","sidebarTitle":"Overview","href":"/content/sql/export"},{"title":"EXPORT ... INTO","href":"/content/sql/export/export-into"}]},{"group":"Files \u0026 Directories","pages":[{"title":"Files \u0026 Directories (KiFS)","sidebarTitle":"Overview","href":"/content/sql/kifs"},{"group":"Directories","pages":[{"title":"CREATE DIRECTORY","href":"/content/sql/kifs/create-directory"},{"title":"ALTER DIRECTORY","href":"/content/sql/kifs/alter-directory"},{"title":"LIST DIRECTORY","href":"/content/sql/kifs/list-directory"},{"title":"SHOW DIRECTORY","href":"/content/sql/kifs/show-directory"},{"title":"DOWNLOAD DIRECTORY","href":"/content/sql/kifs/download-directory"},{"title":"DROP DIRECTORY","href":"/content/sql/kifs/drop-directory"}]},{"group":"Files","pages":[{"title":"UPLOAD FILE","href":"/content/sql/kifs/upload-file"},{"title":"UPLOAD URL","href":"/content/sql/kifs/upload-url"},{"title":"LIST FILE","href":"/content/sql/kifs/list-file"},{"title":"DOWNLOAD FILE","href":"/content/sql/kifs/download-file"},{"title":"DROP FILE","href":"/content/sql/kifs/drop-file"}]}]},{"title":"Reveal","sidebarTitle":"Reveal","href":"/content/sql/reveal"},{"group":"SQL Procedures","pages":[{"title":"SQL Procedures","sidebarTitle":"Overview","href":"/content/sql/procedure"},{"title":"Supported Statements","href":"/content/sql/procedure/supported-statements"},{"title":"CREATE PROCEDURE","href":"/content/sql/procedure/create-procedure"},{"title":"ALTER PROCEDURE","href":"/content/sql/procedure/alter-procedure"},{"title":"EXECUTE PROCEDURE","href":"/content/sql/procedure/execute-procedure"},{"title":"DROP PROCEDURE","href":"/content/sql/procedure/drop-procedure"},{"title":"SHOW PROCEDURE","href":"/content/sql/procedure/show-procedure"},{"title":"Security","href":"/content/sql/procedure/security"}]},{"group":"SQL-GPT","pages":[{"title":"SQL-GPT Syntax","sidebarTitle":"Overview","href":"/content/sql/sqlgpt"},{"group":"Contexts","pages":[{"title":"CREATE CONTEXT","href":"/content/sql/sqlgpt/create-context"},{"title":"ALTER CONTEXT","href":"/content/sql/sqlgpt/alter-context"},{"title":"DROP CONTEXT","href":"/content/sql/sqlgpt/drop-context"},{"title":"SHOW CONTEXT","href":"/content/sql/sqlgpt/show-context"},{"title":"DESCRIBE CONTEXT","href":"/content/sql/sqlgpt/describe-context"}]},{"group":"Generation","pages":[{"title":"GENERATE SQL","href":"/content/sql/sqlgpt/generate-sql"},{"title":"GENERATE TOKENS","href":"/content/sql/sqlgpt/generate-tokens"},{"title":"EXECUTE_AI_QUERY","href":"/content/sql/sqlgpt/execute-ai-query"}]}]},{"group":"UDFs","pages":[{"title":"User Defined Functions (UDFs)","sidebarTitle":"Overview","href":"/content/sql/udf"},{"group":"Functions","pages":[{"title":"CREATE FUNCTION","href":"/content/sql/udf/create-function"},{"title":"Executing Functions","href":"/content/sql/udf/executing-functions"},{"title":"DROP FUNCTION","href":"/content/sql/udf/drop-function"},{"title":"SHOW FUNCTION","href":"/content/sql/udf/show-function"},{"title":"SHOW FUNCTION STATUS","href":"/content/sql/udf/show-function-status"},{"title":"DESCRIBE FUNCTION","href":"/content/sql/udf/describe-function"}]},{"group":"Environments","pages":[{"title":"CREATE FUNCTION ENVIRONMENT","href":"/content/sql/udf/create-function-environment"},{"title":"ALTER FUNCTION ENVIRONMENT","href":"/content/sql/udf/alter-function-environment"},{"title":"DROP FUNCTION ENVIRONMENT","href":"/content/sql/udf/drop-function-environment"},{"title":"SHOW FUNCTION ENVIRONMENT","href":"/content/sql/udf/show-function-environment"},{"title":"DESCRIBE FUNCTION ENVIRONMENT","href":"/content/sql/udf/describe-function-environment"}]}]},{"group":"Graphs","pages":[{"title":"Graphs","sidebarTitle":"Overview","href":"/content/sql/graph"},{"group":"Querying","pages":[{"title":"SQL/PGQ","href":"/content/sql/graph/sql-pgq"},{"title":"QUERY_GRAPH","href":"/content/sql/graph/query-graph"},{"title":"MATCH_GRAPH","href":"/content/sql/graph/match-graph"},{"title":"SOLVE_GRAPH","href":"/content/sql/graph/solve-graph"}]},{"group":"Management","pages":[{"title":"CREATE GRAPH","href":"/content/sql/graph/create-graph"},{"title":"ALTER GRAPH","href":"/content/sql/graph/alter-graph"},{"title":"DROP GRAPH","href":"/content/sql/graph/drop-graph"},{"title":"SHOW GRAPH","href":"/content/sql/graph/show-graph"},{"title":"DESCRIBE GRAPH","href":"/content/sql/graph/describe-graph"}]}]},{"group":"Machine Learning","pages":[{"title":"Machine Learning (ML)","sidebarTitle":"Overview","href":"/content/sql/ml"},{"group":"Container Registries","pages":[{"title":"CREATE CONTAINER REGISTRY","href":"/content/sql/ml/create-container-registry"},{"title":"DROP CONTAINER REGISTRY","href":"/content/sql/ml/drop-container-registry"},{"title":"SHOW CONTAINER REGISTRY","href":"/content/sql/ml/show-container-registry"}]},{"group":"Models","pages":[{"title":"IMPORT MODEL","href":"/content/sql/ml/import-model"},{"title":"EVALUATE_MODEL","href":"/content/sql/ml/evaluate-model"},{"title":"ALTER MODEL","href":"/content/sql/ml/alter-model"},{"title":"REFRESH MODEL","href":"/content/sql/ml/refresh-model"},{"title":"DROP MODEL","href":"/content/sql/ml/drop-model"},{"title":"SHOW MODEL","href":"/content/sql/ml/show-model"},{"title":"DESCRIBE MODEL","href":"/content/sql/ml/describe-model"}]}]},{"group":"Security","pages":[{"title":"Security","sidebarTitle":"Overview","href":"/content/sql/security"},{"group":"User Management","pages":[{"title":"CREATE USER","href":"/content/sql/security/create-user"},{"title":"ALTER USER","href":"/content/sql/security/alter-user"},{"title":"DROP USER","href":"/content/sql/security/drop-user"},{"title":"SHOW SECURITY FOR User","href":"/content/sql/security/show-security-for-user"}]},{"group":"Role Management","pages":[{"title":"CREATE ROLE","href":"/content/sql/security/create-role"},{"title":"ALTER ROLE","href":"/content/sql/security/alter-role"},{"title":"DROP ROLE","href":"/content/sql/security/drop-role"},{"title":"SHOW SECURITY FOR Role","href":"/content/sql/security/show-security-for-role"}]},{"group":"Privilege Management","pages":[{"title":"GRANT Role","href":"/content/sql/security/grant-role"},{"title":"GRANT SYSTEM Permission","href":"/content/sql/security/grant-system-permission"},{"title":"GRANT Table Permission","href":"/content/sql/security/grant-table-permission"},{"title":"GRANT Credential Permission","href":"/content/sql/security/grant-credential-permission"},{"title":"GRANT Data Source Permission","href":"/content/sql/security/grant-data-source-permission"},{"title":"GRANT Data Sink Permission","href":"/content/sql/security/grant-data-sink-permission"},{"title":"GRANT Directory Permission","href":"/content/sql/security/grant-directory-permission"},{"title":"GRANT Function (UDF/UDTF) Permission","href":"/content/sql/security/grant-function-udf-udtf-permission"},{"title":"GRANT Graph Permission","href":"/content/sql/security/grant-graph-permission"},{"title":"GRANT Procedure Permission","href":"/content/sql/security/grant-procedure-permission"},{"title":"GRANT SQL-GPT Context Permission","href":"/content/sql/security/grant-sql-gpt-context-permission"},{"title":"GRANT Stream Permission","href":"/content/sql/security/grant-stream-permission"},{"title":"REVOKE Role","href":"/content/sql/security/revoke-role"},{"title":"REVOKE SYSTEM Permission","href":"/content/sql/security/revoke-system-permission"},{"title":"REVOKE Table Permission","href":"/content/sql/security/revoke-table-permission"},{"title":"REVOKE Credential Permission","href":"/content/sql/security/revoke-credential-permission"},{"title":"REVOKE Data Source Permission","href":"/content/sql/security/revoke-data-source-permission"},{"title":"REVOKE Data Sink Permission","href":"/content/sql/security/revoke-data-sink-permission"},{"title":"REVOKE Directory Permission","href":"/content/sql/security/revoke-directory-permission"},{"title":"REVOKE Function (UDF/UDTF) Permission","href":"/content/sql/security/revoke-function-udf-udtf-permission"},{"title":"REVOKE Graph Permission","href":"/content/sql/security/revoke-graph-permission"},{"title":"REVOKE Procedure Permission","href":"/content/sql/security/revoke-procedure-permission"},{"title":"REVOKE SQL-GPT Context Permission","href":"/content/sql/security/revoke-sql-gpt-context-permission"},{"title":"REVOKE Stream Permission","href":"/content/sql/security/revoke-stream-permission"},{"title":"SHOW SECURITY","href":"/content/sql/security/show-security"},{"title":"CHECK","href":"/content/sql/security/check"}]},{"group":"Impersonation (Execute As...)","pages":[{"title":"EXECUTE AS","href":"/content/sql/security/execute-as"},{"title":"REVERT","href":"/content/sql/security/revert"},{"title":"SET USER","href":"/content/sql/security/set-user"}]}]},{"group":"Resource Management","pages":[{"title":"Resource Management","sidebarTitle":"Overview","href":"/content/sql/resource_group"},{"title":"CREATE RESOURCE GROUP","href":"/content/sql/resource_group/create-resource-group"},{"title":"ALTER RESOURCE GROUP","href":"/content/sql/resource_group/alter-resource-group"},{"title":"DROP RESOURCE GROUP","href":"/content/sql/resource_group/drop-resource-group"},{"title":"SHOW RESOURCE GROUP","href":"/content/sql/resource_group/show-resource-group"},{"title":"DESCRIBE RESOURCE GROUP","href":"/content/sql/resource_group/describe-resource-group"},{"title":"ALTER TIER","href":"/content/sql/resource_group/alter-tier"}]},{"group":"System Administration","pages":[{"title":"System Administration","sidebarTitle":"Overview","href":"/content/sql/system_properties"},{"title":"ALTER SYSTEM SET PROPERTIES","href":"/content/sql/system_properties/alter-system-set-properties"},{"title":"SHOW SYSTEM PROPERTIES","href":"/content/sql/system_properties/show-system-properties"},{"title":"VERIFY DATABASE","href":"/content/sql/system_properties/verify-database"},{"title":"CLEAR FILE CACHE","href":"/content/sql/system_properties/clear-file-cache"},{"title":"SHOW FILE CACHE","href":"/content/sql/system_properties/show-file-cache"},{"title":"DESCRIBE FILE CACHE","href":"/content/sql/system_properties/describe-file-cache"}]},{"group":"Backup \u0026 Restore","pages":[{"title":"Database Backup/Restore","sidebarTitle":"Overview","href":"/content/sql/backup_restore"},{"title":"CREATE BACKUP","href":"/content/sql/backup_restore/create-backup"},{"title":"ALTER BACKUP","href":"/content/sql/backup_restore/alter-backup"},{"title":"RESTORE BACKUP","href":"/content/sql/backup_restore/restore-backup"},{"title":"DROP BACKUP","href":"/content/sql/backup_restore/drop-backup"},{"title":"SHOW BACKUP","href":"/content/sql/backup_restore/show-backup"},{"title":"DESCRIBE BACKUP","href":"/content/sql/backup_restore/describe-backup"},{"title":"VERIFY BACKUP","href":"/content/sql/backup_restore/verify-backup"}]},{"title":"Limitations","sidebarTitle":"Limitations","href":"/content/sql/limit"}]},{"group":"SQL-GPT","pages":[{"title":"SQL-GPT","sidebarTitle":"Overview","href":"/content/sql-gpt/index"},{"title":"SQL-GPT Concepts","sidebarTitle":"Concepts","href":"/content/sql-gpt/concepts"},{"title":" SQL Syntax","href":"/_redirect/sql/sqlgpt/_SQL Syntax"},{"title":" Workbench","href":"/_redirect/admin/workbench/ui/explore/_Workbench"}]},{"group":"Vector Search","pages":[{"title":"Vector Search","sidebarTitle":"Vector Search","href":"/content/vector_search/index"}]},{"group":"Location Intelligence","pages":[{"title":"Location Intelligence","sidebarTitle":"Overview","href":"/content/location_intelligence/index"},{"title":"Geospatial Objects","sidebarTitle":"Geospatial Objects","href":"/content/location_intelligence/geo_objects"},{"title":" Geospatial Indexes","href":"/_redirect/concepts/indexes/_Geospatial Indexes"},{"title":"Geospatial/Geometry Functions","sidebarTitle":"Geospatial Functions","href":"/content/location_intelligence/geo_functions"},{"title":"Geospatial Examples","sidebarTitle":"Geospatial Examples","href":"/content/location_intelligence/geospatial_examples"},{"title":" Geospatial Performance Optimization","href":"/_redirect/tuning/cs/geo/_Geospatial Performance Optimization"},{"title":"Web Map Service","href":"/content/location_intelligence/wms_feature_overview"},{"title":"Vector Tile Service","href":"/content/location_intelligence/vts_feature_overview"}]},{"group":"Time Series","pages":[{"title":"Time Series","sidebarTitle":"Overview","href":"/content/time_series/index"},{"title":"Date/Time Types","sidebarTitle":"Data Types","href":"/content/time_series/types"},{"title":"Date Bucketing","sidebarTitle":"Date Bucketing","href":"/content/time_series/date_bucket"},{"title":"Time Bucketing","sidebarTitle":"Time Bucketing","href":"/content/time_series/time_bucket"},{"title":" Window Functions","href":"/_redirect/sql/query/_Window Functions"},{"title":" Trend Analysis","href":"/_redirect/sql/query/_Trend Analysis"},{"title":" ASOF Join","href":"/_redirect/sql/query/_ASOF Join"}]},{"group":"Graph","pages":[{"title":"Graph","sidebarTitle":"Overview","href":"/content/graph_solver/index"},{"title":"Graphs \u0026 Solvers Concepts","sidebarTitle":"Graph Concepts","href":"/content/graph_solver/network_graph_solver"},{"title":"Distributed Graph Servers","sidebarTitle":"Distributed Graph Server","href":"/content/graph_solver/distributed_graph_server"},{"title":" Graph Query","href":"/_redirect/sql/graph/_Graph Query"},{"title":" Management in SQL","href":"/_redirect/sql/graph/_Management in SQL"},{"title":" Matching in SQL","href":"/_redirect/sql/graph/_Matching in SQL"},{"title":" Solving in SQL","href":"/_redirect/sql/graph/_Solving in SQL"}]},{"group":"Machine Learning","pages":[{"title":"Machine Learning","sidebarTitle":"Overview","href":"/content/ml/index"},{"title":"Machine Learning Concepts","sidebarTitle":"ML Concepts","href":"/content/ml/concepts"},{"title":" SQL ML","href":"/_redirect/sql/ml/_SQL ML"}]},{"group":"Security","pages":[{"title":"Security","sidebarTitle":"Overview","href":"/content/security/index"},{"title":"Security Concepts","sidebarTitle":"Users \u0026 Roles","href":"/content/security/sec_concepts"},{"title":"Security Usage","sidebarTitle":"Security Usage","href":"/content/security/sec_usage"},{"group":"Security Configuration","pages":[{"title":"Security Configuration","href":"/content/security/sec_configuration"},{"title":"Obfuscating Plain-Text Passwords","sidebarTitle":"Obfuscating Passwords","href":"/content/security/sec_hardening"}]},{"title":"Auditing","sidebarTitle":"Auditing","href":"/content/security/auditing"},{"title":" SQL Security","href":"/_redirect/sql/security/_SQL Security"},{"title":"Reveal User/Role Management","sidebarTitle":"Reveal Security","href":"/content/security/reveal"}]},{"group":"Visualization","pages":[{"title":"Visualization","sidebarTitle":"Overview","href":"/content/bi/index"},{"group":"Reveal","pages":[{"title":"Reveal: An Overview","href":"/content/bi/reveal/index"},{"title":"Reveal SDK","sidebarTitle":"Reveal SDK","href":"/content/bi/reveal/sdk"}]},{"group":"Tableau","pages":[{"title":"Using Tableau with Kinetica","href":"/content/bi/tableau/index"},{"title":"Kinetica Geospatial Visualization for Tableau","sidebarTitle":"Geospatial Extension","href":"/content/bi/tableau/kin_geo_viz_tableau"}]},{"title":"Using Workbooks in Workbench","sidebarTitle":"Workbooks","href":"/content/admin/workbench/workbooks"},{"title":"Web Map Service","href":"/content/bi/wms_feature_overview"},{"title":"Vector Tile Service","href":"/content/bi/vts_feature_overview"}]},{"group":"Integration","pages":[{"title":"Integrate","sidebarTitle":"Overview","href":"/content/integrate"},{"group":"Performance Optimization","pages":[{"title":"Performance Optimization","sidebarTitle":"Overview","href":"/content/tuning/index"},{"title":"Distributed Ingest","sidebarTitle":"Distributed Ingest","href":"/content/tuning/multihead/multihead_ingest"},{"title":"Distributed Key Lookup","sidebarTitle":"Distributed Key Lookup","href":"/content/tuning/multihead/multihead_egress"},{"title":"Distributed Ingest \u0026 Key Lookup Use Case","sidebarTitle":"Distributed I/O Use Case","href":"/content/tuning/multihead/multihead_use_case"},{"title":"Geospatial Queries","sidebarTitle":"Geospatial Queries","href":"/content/tuning/cs/geo"}]},{"group":"Connectors","pages":[{"title":"Connectors","sidebarTitle":"Overview","href":"/content/connectors/index"},{"title":"JDBC Connector Guide","sidebarTitle":"JDBC Connector","href":"/content/connectors/sql_guide"},{"title":"PostgreSQL Wire Protocol","sidebarTitle":"PostgreSQL Wire Protocol","href":"/content/connectors/psql_wire_protocol"},{"title":"Kinetica Dialect for SQLAlchemy","sidebarTitle":"Kinetica Dialect for SQLAlchemy","href":"/content/connectors/sqlalchemy"},{"group":"Kickbox | Mapbox Connector","pages":[{"title":"Kinetica Kickbox.js Mapbox GL","href":"/content/connectors/kickbox"},{"title":"API Documentation","sidebarTitle":"API Documentation","href":"/content/connectors/kickbox_api"},{"title":"WMS Layers","sidebarTitle":"WMS Layers","href":"/content/connectors/kickbox_wms"},{"title":"Point Clustering","sidebarTitle":"Point Clustering","href":"/content/connectors/kickbox_clustering"}]},{"title":"Beam Developer Manual","sidebarTitle":"Beam Connector","href":"/content/connectors/beam_guide"},{"title":"Kinetica Adapter for dbt","sidebarTitle":"dbt Adapter","href":"/content/connectors/dbt"},{"title":"NiFi Connector Developer Manual","sidebarTitle":"NiFi Connector","href":"/content/connectors/nifi_guide"},{"title":"Kinetica Spark Guide","sidebarTitle":"Spark Connector","href":"/content/connectors/spark_guide"}]},{"group":"User-Defined Function Implementation","pages":[{"title":"User-Defined Function Implementation","sidebarTitle":"Overview","href":"/content/udf/index"},{"group":"C++","pages":[{"title":"C++ UDF API","sidebarTitle":"API","href":"/content/udf/cpp/writing"},{"title":"Running C++ UDFs","sidebarTitle":"Running","href":"/content/udf/cpp/running"},{"group":"Examples","pages":[{"title":"UDF C++ Examples","sidebarTitle":"Overview","href":"/content/udf/cpp/examples/index"},{"title":"Example UDF (CUDA) - Sum of Squares","sidebarTitle":"Sum of Squares (CUDA)","href":"/content/udf/cpp/examples/dist_cuda_sum_of_squares/index"}]}]},{"group":"Python","pages":[{"title":"Python UDF API","sidebarTitle":"API","href":"/content/udf/python/writing"},{"title":"Running Python UDFs","sidebarTitle":"Running","href":"/content/udf/python/running"},{"group":"Examples","pages":[{"title":"UDF Python Examples","sidebarTitle":"Overview","href":"/content/udf/python/examples/index"},{"title":"Prepare Environment","sidebarTitle":"Prepare Environment","href":"/content/udf/python/examples/github_examples/prep_env"},{"title":"UDF API Download","sidebarTitle":"Download API","href":"/content/udf/python/examples/github_examples/udf_api_download"},{"title":"Example UDF (CUDA) - cuBLAS","sidebarTitle":"cuBLAS (CUDA)","href":"/content/udf/python/examples/dist_cuda_cublas/index"},{"title":"Example UDF (Non-CUDA) - Sum of Squares","sidebarTitle":"Sum of Squares (Non-CUDA)","href":"/content/udf/python/examples/dist_noncuda_sum_of_squares/index"},{"title":"Example UDF (Non-CUDA) - Distributed Model","sidebarTitle":"Distributed Model (Non-CUDA)","href":"/content/udf/python/examples/github_examples/dist_model/index"},{"title":"Example UDF (Non-CUDA) - Pandas","sidebarTitle":"Pandas (Non-CUDA)","href":"/content/udf/python/examples/github_examples/pandas/index"}]}]},{"title":"UDF Simulator","sidebarTitle":"Simulator","href":"/content/udf/simulating_udfs"},{"title":"Concurrency Limits","sidebarTitle":"Concurrency Limits","href":"/content/udf/concurrency_limits"}]},{"group":"Kinetica Tools","pages":[{"title":"Kinetica Tools","sidebarTitle":"Overview","href":"/content/tools/index"},{"group":"KiFS","pages":[{"title":"Kinetica File System (KiFS)","href":"/content/tools/kifs"},{"title":"KiFS API Support","sidebarTitle":"KiFS API Support","href":"/content/tools/kifs_api"}]},{"title":"Kinetica SQL (KiSQL)","sidebarTitle":"KiSQL","href":"/content/tools/kisql"}]},{"title":"Downloads","sidebarTitle":"Downloads","href":"/content/downloads"}]},{"group":"Virtual Catalogs","pages":[{"title":"Virtual Catalogs","sidebarTitle":"Overview","href":"/content/catalogs/index"},{"title":"Kinetica Virtual Catalog","sidebarTitle":"Kinetica Virtual Catalog","href":"/content/catalogs/kinetica"},{"title":"ANSI Virtual Catalog","sidebarTitle":"ANSI Virtual Catalog","href":"/content/catalogs/ansi"},{"title":"PostgreSQL Virtual Catalog","sidebarTitle":"PostgreSQL Virtual Catalog","href":"/content/catalogs/postgresql"},{"title":" Useful Catalog Queries","href":"/_redirect/snippets/virtual-catalog-queries/_Useful Catalog Queries"}]},{"group":"Release Notes","pages":[{"title":"Release Notes","sidebarTitle":"Overview","href":"/content/release/index"},{"title":"7.2 Release Notes","sidebarTitle":"7.2 Release Notes","href":"/content/release/7_2"},{"title":"7.1 Release Notes","sidebarTitle":"7.1 Release Notes","href":"/content/release/7_1"},{"title":"7.0 Release Notes","sidebarTitle":"7.0 Release Notes","href":"/content/release/7_0"},{"title":"6.2 Release Notes","sidebarTitle":"6.2 Release Notes","href":"/content/release/6_2"},{"title":"6.1 Release Notes","sidebarTitle":"6.1 Release Notes","href":"/content/release/6_1"},{"title":"6.0 Release Notes","sidebarTitle":"6.0 Release Notes","href":"/content/release/6_0"},{"title":"5.2 Release Notes","sidebarTitle":"5.2 Release Notes","href":"/content/release/5_2"}]}]}]},{"tab":"API Reference","icon":"square-terminal","pages":[{"title":"API Reference","href":"/content/api"}]},{"tab":"Guides","icon":"book-open","pages":[{"title":"Guides","href":"/content/guides"}]},{"tab":"Snippets","icon":"code","pages":[{"title":"Snippets","href":"/content/snippets"}]},{"tab":"Examples (Github)","icon":"github","align":"end","href":"https://github.com/kineticadb/examples"}]},"basePath":"","title":"Cluster - Kinetica Docs","buildId":"dpl_G9nrg4qeJSZtah1Ziwbc2n6WkLch","deploymentId":"dpl_G9nrg4qeJSZtah1Ziwbc2n6WkLch","dynamics":["a74be98ba7"],"chunks":["zoom-image-lightbox-DL4wrF0w.js","lightbox-handle-r17bVUz3.js"]}