| import type { SidebarsConfig } from '@docusaurus/plugin-content-docs'; | |
| const sidebars: SidebarsConfig = { | |
| docs: [ | |
| { | |
| type: 'category', | |
| label: 'Get Started', | |
| collapsible: false, | |
| collapsed: false, | |
| items: [ | |
| { | |
| type: 'category', | |
| label: 'Getting Started', | |
| link: {type: 'doc', id: 'getting-started/intro'}, | |
| collapsed: true, | |
| items: [ | |
| 'getting-started/what-is-apache-doris', | |
| 'getting-started/quick-start', | |
| 'getting-started/before-you-start-the-poc', | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'Migration', | |
| link: {type: 'doc', id: 'migration/overview'}, | |
| collapsed: true, | |
| items: [ | |
| 'migration/postgresql-to-doris', | |
| 'migration/mysql-to-doris', | |
| 'migration/elasticsearch-to-doris', | |
| 'migration/other-olap-to-doris', | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'Features & Architecture', | |
| link: {type: 'doc', id: 'features-architecture/intro'}, | |
| collapsed: true, | |
| items: [ | |
| 'features-architecture/system-architecture', | |
| 'features-architecture/product-concepts', | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'Installation & Deployment', | |
| link: {type: 'doc', id: 'install/intro'}, | |
| collapsed: true, | |
| items: [ | |
| 'install/choosing-deployment-mode', | |
| { | |
| type: 'category', | |
| label: 'Installation Preparation', | |
| items: [ | |
| 'install/preparation/env-checking', | |
| 'install/preparation/cluster-planning', | |
| 'install/preparation/os-checking', | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'Deploying Manually', | |
| link: {type: 'doc', id: 'install/deploy-manually/intro'}, | |
| items: [ | |
| 'install/deploy-manually/integrated-storage-compute-deploy-manually', | |
| 'install/deploy-manually/separating-storage-compute-deploy-manually', | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'Deploying on Kubernetes', | |
| link: {type: 'doc', id: 'install/deploy-on-kubernetes/intro'}, | |
| items: [ | |
| { | |
| type: 'category', | |
| label: 'Doris Operator Concepts and Capabilities', | |
| link: {type: 'doc', id: 'install/deploy-on-kubernetes/doris-operator/intro'}, | |
| items: [ | |
| 'install/deploy-on-kubernetes/doris-operator/doris-operator-overview', | |
| 'install/deploy-on-kubernetes/doris-operator/architecture', | |
| 'install/deploy-on-kubernetes/doris-operator/resource-model', | |
| 'install/deploy-on-kubernetes/doris-operator/lifecycle', | |
| 'install/deploy-on-kubernetes/doris-operator/status-and-troubleshooting', | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'Preparation', | |
| link: {type: 'doc', id: 'install/deploy-on-kubernetes/doris-operator/preparation'}, | |
| items: [ | |
| 'install/deploy-on-kubernetes/doris-operator/on-alibaba', | |
| 'install/deploy-on-kubernetes/doris-operator/on-aws', | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'Integrated Storage Compute', | |
| link: {type: 'doc', id: 'install/deploy-on-kubernetes/integrated-storage-compute/intro'}, | |
| collapsed: true, | |
| items: [ | |
| 'install/deploy-on-kubernetes/integrated-storage-compute/install-doris-operator', | |
| 'install/deploy-on-kubernetes/integrated-storage-compute/install-config-cluster', | |
| 'install/deploy-on-kubernetes/integrated-storage-compute/install-doris-cluster', | |
| 'install/deploy-on-kubernetes/integrated-storage-compute/access-cluster', | |
| 'install/deploy-on-kubernetes/integrated-storage-compute/cluster-operation', | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'Separating Storage Compute', | |
| link: {type: 'doc', id: 'install/deploy-on-kubernetes/separating-storage-compute/install-doris-cluster'}, | |
| collapsed: true, | |
| items: [ | |
| 'install/deploy-on-kubernetes/separating-storage-compute/install-fdb', | |
| 'install/deploy-on-kubernetes/separating-storage-compute/config-ms', | |
| 'install/deploy-on-kubernetes/separating-storage-compute/config-fe', | |
| 'install/deploy-on-kubernetes/separating-storage-compute/config-cg', | |
| 'install/deploy-on-kubernetes/separating-storage-compute/config-cluster', | |
| 'install/deploy-on-kubernetes/separating-storage-compute/install-prometheus-and-grafana', | |
| ], | |
| }, | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'Deploying on Cloud', | |
| items: ['install/deploy-on-cloud/doris-on-aws'], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'Compute-Storage Decoupled Guide', | |
| collapsed: true, | |
| link: {type: 'doc', id: 'compute-storage-decoupled/intro'}, | |
| items: [ | |
| 'compute-storage-decoupled/managing-compute-cluster', | |
| 'compute-storage-decoupled/managing-storage-vault', | |
| 'compute-storage-decoupled/recycler', | |
| 'compute-storage-decoupled/upgrade', | |
| { | |
| type: 'category', | |
| label: 'File Cache', | |
| items: [ | |
| 'compute-storage-decoupled/file-cache/file-cache', | |
| 'compute-storage-decoupled/file-cache/file-cache-internals', | |
| 'compute-storage-decoupled/file-cache/file-cache-peer-read', | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'Read/Write Separation', | |
| items: [ | |
| 'compute-storage-decoupled/rw/read-write-separation', | |
| 'compute-storage-decoupled/rw/file-cache-rw-compute-group-best-practice', | |
| ], | |
| }, | |
| ], | |
| }, | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'Connection & Integration', | |
| collapsed: true, | |
| items: [ | |
| 'connection-integration/mysql-proto', | |
| 'connection-integration/arrow-flight-sql', | |
| { | |
| type: 'category', | |
| label: 'Data Integration', | |
| link: {type: 'doc', id: 'connection-integration/data-integration/intro'}, | |
| items: [ | |
| 'connection-integration/data-integration/automq', | |
| 'connection-integration/data-integration/beats', | |
| 'connection-integration/data-integration/cloudcanal', | |
| 'connection-integration/data-integration/clouddm', | |
| 'connection-integration/data-integration/datagrip', | |
| 'connection-integration/data-integration/datax', | |
| 'connection-integration/data-integration/dbeaver', | |
| 'connection-integration/data-integration/dbine', | |
| 'connection-integration/data-integration/dbt-doris-adapter', | |
| 'connection-integration/data-integration/doris-kafka-connector', | |
| 'connection-integration/data-integration/doris-streamloader', | |
| 'connection-integration/data-integration/finebi', | |
| { | |
| type: 'category', | |
| label: 'Flink Doris Connector', | |
| link: {type: 'doc', id: 'connection-integration/data-integration/flink-doris-connector/overview'}, | |
| items: [ | |
| 'connection-integration/data-integration/flink-doris-connector/quick-start', | |
| 'connection-integration/data-integration/flink-doris-connector/read', | |
| 'connection-integration/data-integration/flink-doris-connector/incremental-read', | |
| 'connection-integration/data-integration/flink-doris-connector/write', | |
| 'connection-integration/data-integration/flink-doris-connector/lookup-join', | |
| 'connection-integration/data-integration/flink-doris-connector/cdc-sync', | |
| 'connection-integration/data-integration/flink-doris-connector/datastream-api', | |
| 'connection-integration/data-integration/flink-doris-connector/connection', | |
| 'connection-integration/data-integration/flink-doris-connector/data-type-mapping', | |
| 'connection-integration/data-integration/flink-doris-connector/faq', | |
| ], | |
| }, | |
| 'connection-integration/data-integration/fluentbit', | |
| 'connection-integration/data-integration/hive-udf', | |
| 'connection-integration/data-integration/kettle', | |
| 'connection-integration/data-integration/kyuubi', | |
| 'connection-integration/data-integration/langfuse', | |
| 'connection-integration/data-integration/libredb-studio', | |
| 'connection-integration/data-integration/logstash', | |
| 'connection-integration/data-integration/loongcollector', | |
| 'connection-integration/data-integration/metabase', | |
| 'connection-integration/data-integration/opentelemetry', | |
| 'connection-integration/data-integration/powerbi', | |
| 'connection-integration/data-integration/quickbi', | |
| 'connection-integration/data-integration/quicksight', | |
| 'connection-integration/data-integration/seatunnel', | |
| 'connection-integration/data-integration/smartbi', | |
| 'connection-integration/data-integration/spark-doris-connector', | |
| 'connection-integration/data-integration/superset', | |
| 'connection-integration/data-integration/tableau', | |
| 'connection-integration/data-integration/vector' | |
| ], | |
| }, | |
| ], | |
| }, | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'Guides', | |
| collapsible: false, | |
| collapsed: false, | |
| items: [ | |
| { | |
| type: 'category', | |
| label: 'Table Design', | |
| collapsed: true, | |
| link: {type: 'doc', id: 'table-design/overview'}, | |
| items: [ | |
| { | |
| type: 'category', | |
| label: 'Table Models', | |
| link: {type: 'doc', id: 'table-design/data-model/intro'}, | |
| items: [ | |
| 'table-design/data-model/duplicate', | |
| { | |
| type: 'category', | |
| label: 'Unique Key Model', | |
| link: {type: 'doc', id: 'table-design/data-model/unique'}, | |
| items: [ | |
| 'table-design/data-model/merge-on-write', | |
| ], | |
| }, | |
| 'table-design/data-model/aggregate', | |
| 'table-design/data-model/tips', | |
| ], | |
| }, | |
| 'table-design/data-type', | |
| { | |
| type: 'category', | |
| label: 'Partitioning & Bucketing', | |
| link: {type: 'doc', id: 'table-design/data-partitioning/overview'}, | |
| items: [ | |
| 'table-design/data-partitioning/auto-partitioning', | |
| 'table-design/data-partitioning/manual-partitioning', | |
| 'table-design/data-partitioning/dynamic-partitioning', | |
| 'table-design/data-partitioning/data-bucketing', | |
| 'table-design/data-partitioning/basic-concepts', | |
| 'table-design/data-partitioning/common-issues', | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'Indexes', | |
| link: {type: 'doc', id: 'table-design/index/index-overview'}, | |
| items: [ | |
| 'table-design/index/prefix-index', | |
| 'table-design/index/bloomfilter', | |
| 'table-design/index/ngram-bloomfilter-index', | |
| { | |
| type: 'category', | |
| label: 'Inverted Index (Fulltext)', | |
| link: {type: 'doc', id: 'table-design/index/inverted-index/overview'}, | |
| items: [ | |
| 'table-design/index/inverted-index/custom-analyzer', | |
| 'table-design/index/inverted-index/custom-normalizer', | |
| 'table-design/index/inverted-index/search-operators', | |
| 'table-design/index/inverted-index/search-function', | |
| 'table-design/index/inverted-index/scoring', | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'Vector Index', | |
| link: {type: 'doc', id: 'table-design/index/vector-index/overview'}, | |
| items: [ | |
| 'table-design/index/vector-index/practical-guide', | |
| 'table-design/index/vector-index/hnsw', | |
| 'table-design/index/vector-index/ivf', | |
| 'table-design/index/vector-index/ivf-on-disk', | |
| 'table-design/index/vector-index/index-management', | |
| 'table-design/index/vector-index/resource-estimation', | |
| 'table-design/index/vector-index/quantization-survey', | |
| 'table-design/index/vector-index/performance', | |
| 'table-design/index/vector-index/performance-large-scale', | |
| 'table-design/index/vector-index/behind-index', | |
| ], | |
| }, | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'Storage Layout', | |
| link: { | |
| type: 'doc', | |
| id: 'table-design/storage-layout-overview', | |
| }, | |
| items: [ | |
| 'table-design/column-compression', | |
| 'table-design/row-store', | |
| { | |
| type: 'category', | |
| label: 'Tiered Storage', | |
| link: { | |
| type: 'doc', | |
| id: 'table-design/tiered-storage/overview', | |
| }, | |
| items: [ | |
| 'table-design/tiered-storage/tiered-ssd-hdd', | |
| 'table-design/tiered-storage/remote-storage', | |
| ], | |
| }, | |
| 'table-design/storage-format', | |
| ], | |
| }, | |
| 'table-design/schema-change', | |
| 'table-design/auto-increment', | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'Data Loading', | |
| collapsed: true, | |
| link: { | |
| type: 'doc', | |
| id: 'data-operate/import/load-manual', | |
| }, | |
| items: [ | |
| { | |
| type: 'category', | |
| label: 'Data Source', | |
| items: [ | |
| 'data-operate/import/data-source/local-file', | |
| 'data-operate/import/data-source/kafka', | |
| 'data-operate/import/data-source/aws-msk', | |
| 'data-operate/import/data-source/aws-kinesis', | |
| 'data-operate/import/data-source/flink', | |
| 'data-operate/import/data-source/hdfs', | |
| 'data-operate/import/data-source/amazon-s3', | |
| 'data-operate/import/data-source/google-cloud-storage', | |
| 'data-operate/import/data-source/azure-storage', | |
| 'data-operate/import/data-source/aliyun-oss', | |
| 'data-operate/import/data-source/huawei-obs', | |
| 'data-operate/import/data-source/tencent-cos', | |
| 'data-operate/import/data-source/minio', | |
| 'data-operate/import/data-source/s3-compatible', | |
| 'data-operate/import/data-source/snowflake', | |
| 'data-operate/import/data-source/bigquery', | |
| 'data-operate/import/data-source/redshift', | |
| 'data-operate/import/data-source/mysql', | |
| 'data-operate/import/data-source/postgresql', | |
| 'data-operate/import/data-source/migrate-data-from-other-olap', | |
| 'data-operate/import/data-source/migrate-data-from-other-oltp', | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'Loading Methods', | |
| items: [ | |
| 'data-operate/import/import-way/stream-load-manual', | |
| 'data-operate/import/import-way/broker-load-manual', | |
| 'data-operate/import/import-way/routine-load-manual', | |
| 'data-operate/import/import-way/insert-into-manual', | |
| 'data-operate/import/import-way/insert-into-values-manual', | |
| 'data-operate/import/import-way/mysql-load-manual', | |
| 'data-operate/import/import-way/spark-load', | |
| { | |
| type: 'category', | |
| label: 'Continuous Load', | |
| link: {type: 'doc', id: 'data-operate/import/import-way/streaming-job/continuous-load-overview'}, | |
| items: [ | |
| { | |
| type: 'category', | |
| label: 'MySQL', | |
| items: [ | |
| 'data-operate/import/import-way/streaming-job/continuous-load-mysql-table', | |
| 'data-operate/import/import-way/streaming-job/continuous-load-mysql-database', | |
| 'data-operate/import/import-way/streaming-job/schema-change-mysql', | |
| 'data-operate/import/import-way/streaming-job/data-type-mapping-mysql', | |
| { | |
| type: 'category', | |
| label: 'Prerequisites', | |
| items: [ | |
| 'data-operate/import/import-way/streaming-job/prerequisites/amazon-rds-mysql', | |
| 'data-operate/import/import-way/streaming-job/prerequisites/amazon-aurora-mysql', | |
| ], | |
| }, | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'PostgreSQL', | |
| items: [ | |
| 'data-operate/import/import-way/streaming-job/continuous-load-postgresql-table', | |
| 'data-operate/import/import-way/streaming-job/continuous-load-postgresql-database', | |
| 'data-operate/import/import-way/streaming-job/schema-change-postgresql', | |
| 'data-operate/import/import-way/streaming-job/data-type-mapping-postgresql', | |
| { | |
| type: 'category', | |
| label: 'Prerequisites', | |
| items: [ | |
| 'data-operate/import/import-way/streaming-job/prerequisites/amazon-rds-postgresql', | |
| 'data-operate/import/import-way/streaming-job/prerequisites/amazon-aurora-postgresql', | |
| ], | |
| }, | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'OceanBase', | |
| items: [ | |
| 'data-operate/import/import-way/streaming-job/continuous-load-oceanbase-database', | |
| 'data-operate/import/import-way/streaming-job/schema-change-oceanbase', | |
| 'data-operate/import/import-way/streaming-job/data-type-mapping-oceanbase', | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'S3', | |
| link: {type: 'doc', id: 'data-operate/import/import-way/streaming-job/continuous-load-s3'}, | |
| items: [ | |
| 'data-operate/import/import-way/streaming-job/continuous-load-s3', | |
| 'data-operate/import/import-way/streaming-job/continuous-load-s3-ordered', | |
| 'data-operate/import/import-way/streaming-job/continuous-load-s3-notification', | |
| 'data-operate/import/import-way/streaming-job/continuous-load-s3-one-time', | |
| ], | |
| }, | |
| ], | |
| }, | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'File Formats', | |
| items: [ | |
| 'data-operate/import/file-format/csv', | |
| 'data-operate/import/file-format/json', | |
| 'data-operate/import/file-format/parquet', | |
| 'data-operate/import/file-format/orc', | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'Complex Data Types Import', | |
| items: [ | |
| 'data-operate/import/complex-types/array', | |
| 'data-operate/import/complex-types/map', | |
| 'data-operate/import/complex-types/struct', | |
| 'data-operate/import/complex-types/json', | |
| 'data-operate/import/complex-types/bitmap', | |
| 'data-operate/import/complex-types/hll', | |
| 'data-operate/import/complex-types/variant', | |
| ], | |
| }, | |
| 'data-operate/import/handling-messy-data', | |
| 'data-operate/import/load-data-convert', | |
| { | |
| type: 'category', | |
| label: 'Load Best Practices', | |
| link: {type: 'doc', id: 'data-operate/import/load-best-practices/load-best-practices'}, | |
| items: [ | |
| 'data-operate/import/load-best-practices/load-high-availability', | |
| 'data-operate/import/load-best-practices/group-commit-manual', | |
| 'data-operate/import/load-best-practices/routine-load-best-practices', | |
| 'data-operate/import/load-best-practices/stream-load-in-complex-network', | |
| ], | |
| }, | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'Data Update & Delete', | |
| collapsed: true, | |
| link: {type: 'doc', id: 'data-operate/update-and-delete'}, | |
| items: [ | |
| { | |
| type: 'category', | |
| label: 'Updating Data', | |
| link: {type: 'doc', id: 'data-operate/update/update-overview'}, | |
| items: [ | |
| 'data-operate/update/unique-update-sql', | |
| 'data-operate/update/update-of-unique-model', | |
| 'data-operate/update/update-of-aggregate-model', | |
| 'data-operate/update/partial-column-update', | |
| 'data-operate/update/unique-update-concurrent-control', | |
| 'data-operate/update/multi-stream-update-for-unique-model', | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'Deleting Data', | |
| link: {type: 'doc', id: 'data-operate/delete/delete-overview'}, | |
| items: [ | |
| 'data-operate/delete/delete-manual', | |
| 'data-operate/delete/row-ttl', | |
| 'data-operate/delete/batch-delete-manual', | |
| 'data-operate/delete/truncate-manual', | |
| 'data-operate/delete/atomicity-replace', | |
| 'data-operate/delete/table-temp-partition', | |
| ], | |
| }, | |
| 'data-operate/transaction', | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'Change Data & Table Stream', | |
| collapsed: true, | |
| link: {type: 'doc', id: 'data-operate/incremental/overview'}, | |
| items: [ | |
| 'data-operate/incremental/quick-start', | |
| 'data-operate/incremental/changelog', | |
| 'data-operate/incremental/incremental-query', | |
| 'data-operate/incremental/table-stream', | |
| 'data-operate/incremental/table-stream-advanced', | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'Data Export', | |
| collapsed: true, | |
| link: {type: 'doc', id: 'data-operate/export/export-overview'}, | |
| items: [ | |
| 'data-operate/export/export-manual', | |
| 'data-operate/export/outfile', | |
| 'data-operate/export/export-with-mysql-dump', | |
| 'data-operate/export/export-best-practice', | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'Querying', | |
| collapsed: true, | |
| link: {type: 'doc', id: 'query-data/querying-overview'}, | |
| items: [ | |
| 'query-data/mysql-compatibility', | |
| 'query-data/join', | |
| 'query-data/asof-join', | |
| 'query-data/subquery', | |
| 'query-data/multi-dimensional-analytics', | |
| 'query-data/window-function', | |
| 'query-data/cte', | |
| { | |
| type: 'category', | |
| label: 'User Defined Functions', | |
| items: [ | |
| 'query-data/udf/alias-function', | |
| 'query-data/udf/java-user-defined-function', | |
| 'query-data/udf/python-user-defined-function', | |
| ], | |
| }, | |
| 'query-data/complex-type', | |
| 'query-data/lateral-view', | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'Materialized View', | |
| link: {type: 'doc', id: 'query-acceleration/materialized-view/intro'}, | |
| items: [ | |
| 'query-acceleration/materialized-view/overview', | |
| 'query-acceleration/materialized-view/sync-materialized-view', | |
| 'query-acceleration/tuning/tuning-plan/transparent-rewriting-with-sync-mv', | |
| { | |
| type: 'category', | |
| label: 'Async Materialized View', | |
| link: {type: 'doc', id: 'query-acceleration/materialized-view/async-materialized-view/overview'}, | |
| items: [ | |
| 'query-acceleration/materialized-view/async-materialized-view/functions-and-demands', | |
| 'query-acceleration/materialized-view/async-materialized-view/incremental-materialized-view', | |
| 'query-acceleration/materialized-view/async-materialized-view/use-guide', | |
| 'query-acceleration/tuning/tuning-plan/transparent-rewriting-with-async-mv', | |
| 'query-acceleration/materialized-view/async-materialized-view/faq', | |
| ], | |
| }, | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'Performance & Tuning', | |
| collapsed: true, | |
| link: {type: 'doc', id: 'query-acceleration/performance-tuning-intro'}, | |
| items: [ | |
| { | |
| type: 'category', | |
| label: 'Performance Tuning Overview', | |
| link: {type: 'doc', id: 'query-acceleration/performance-tuning-overview/tuning-overview'}, | |
| items: [ | |
| 'query-acceleration/performance-tuning-overview/diagnostic-tools', | |
| 'query-acceleration/performance-tuning-overview/analysis-tools', | |
| 'query-acceleration/performance-tuning-overview/tuning-process', | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'Query Performance', | |
| items: [ | |
| { | |
| type: 'category', | |
| label: 'Schema & Index Optimization', | |
| link: {type: 'doc', id: 'query-acceleration/tuning/tuning-plan/schema-and-index-optimization'}, | |
| items: [ | |
| 'query-acceleration/tuning/tuning-plan/optimizing-table-schema', | |
| 'query-acceleration/tuning/tuning-plan/optimizing-table-index', | |
| 'query-acceleration/tuning/tuning-plan/optimizing-table-scanning', | |
| ], | |
| }, | |
| 'query-acceleration/materialized-view/intro-link', | |
| { | |
| type: 'category', | |
| label: 'Join Optimization', | |
| link: {type: 'doc', id: 'query-acceleration/join-optimization-intro'}, | |
| items: [ | |
| 'query-acceleration/colocation-join', | |
| 'query-acceleration/tuning/tuning-plan/adjusting-join-shuffle', | |
| 'query-acceleration/tuning/tuning-plan/reordering-join-with-leading-hint', | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'Caching', | |
| link: {type: 'doc', id: 'query-acceleration/caching-intro'}, | |
| items: [ | |
| 'query-acceleration/sql-cache-manual', | |
| 'query-acceleration/condition-cache', | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'Execution Tuning', | |
| link: {type: 'doc', id: 'query-acceleration/tuning/tuning-execution/intro'}, | |
| items: [ | |
| 'query-acceleration/tuning/tuning-execution/parallelism-tuning', | |
| 'query-acceleration/tuning/tuning-execution/adjustment-of-runtimefilter-wait-time', | |
| 'query-acceleration/tuning/tuning-execution/data-skew-handling', | |
| 'query-acceleration/tuning/tuning-execution/skew-hint', | |
| 'query-acceleration/tuning/tuning-plan/controlling-hints-with-cbo-rule', | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'High Concurrency & Point Queries', | |
| link: {type: 'doc', id: 'query-acceleration/high-concurrency-intro'}, | |
| items: [ | |
| 'query-acceleration/high-concurrent-point-query', | |
| 'query-acceleration/dictionary', | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'Distinct Counts', | |
| link: {type: 'doc', id: 'query-acceleration/distinct-counts/intro'}, | |
| items: [ | |
| 'query-acceleration/distinct-counts/bitmap-precise-deduplication', | |
| 'query-acceleration/distinct-counts/hll-approximate-deduplication', | |
| ], | |
| }, | |
| 'query-acceleration/query-profile', | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'Load Performance', | |
| items: [ | |
| 'query-acceleration/tuning/tuning-plan/dml-tuning-plan', | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'Optimization Technology Principles', | |
| items: [ | |
| 'query-acceleration/optimization-technology-principle/query-optimizer', | |
| 'query-acceleration/optimization-technology-principle/pipeline-execution-engine', | |
| 'query-acceleration/optimization-technology-principle/runtime-filter', | |
| 'query-acceleration/optimization-technology-principle/topn-optimization', | |
| 'query-acceleration/optimization-technology-principle/statistics', | |
| ], | |
| }, | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'Lakehouse', | |
| link: {type: 'doc', id: 'lakehouse/lakehouse-overview'}, | |
| collapsed: true, | |
| items: [ | |
| { | |
| type: 'category', | |
| label: 'Data Catalogs', | |
| link: {type: 'doc', id: 'lakehouse/catalog-overview'}, | |
| items: [ | |
| { | |
| type: 'category', | |
| label: 'Hive Catalog', | |
| link: {type: 'doc', id: 'lakehouse/catalogs/hive-catalog'}, | |
| items: ['lakehouse/catalogs/hive-catalog/doris-type-mapping'], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'Iceberg Catalog', | |
| link: {type: 'doc', id: 'lakehouse/catalogs/iceberg-catalog'}, | |
| items: [ | |
| 'lakehouse/catalogs/iceberg-catalog/doris-type-mapping', | |
| 'lakehouse/best-practices/doris-iceberg-capability-matrix', | |
| 'lakehouse/best-practices/doris-iceberg', | |
| 'lakehouse/best-practices/doris-aws-s3tables', | |
| 'lakehouse/best-practices/doris-aliyun-oss-tables', | |
| 'lakehouse/best-practices/doris-polaris', | |
| 'lakehouse/best-practices/doris-gravitino', | |
| 'lakehouse/best-practices/doris-onelake', | |
| 'lakehouse/best-practices/doris-unity-catalog', | |
| 'lakehouse/best-practices/doris-snowflake-catalog', | |
| 'lakehouse/best-practices/doris-lakekeeper', | |
| 'lakehouse/best-practices/doris-seaweedfs', | |
| 'lakehouse/best-practices/doris-nessie', | |
| 'lakehouse/best-practices/doris-dlf-iceberg', | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'Paimon Catalog', | |
| link: {type: 'doc', id: 'lakehouse/catalogs/paimon-catalog'}, | |
| items: [ | |
| 'lakehouse/catalogs/paimon-catalog/doris-type-mapping', | |
| 'lakehouse/best-practices/doris-paimon-capability-matrix', | |
| 'lakehouse/best-practices/doris-paimon', | |
| 'lakehouse/best-practices/doris-dlf-paimon', | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'Lance Catalog', | |
| link: {type: 'doc', id: 'lakehouse/catalogs/lance-catalog'}, | |
| items: ['lakehouse/catalogs/lance-catalog/doris-type-mapping'], | |
| }, | |
| 'lakehouse/catalogs/fluss-catalog', | |
| { | |
| type: 'category', | |
| label: 'Hudi Catalog', | |
| link: {type: 'doc', id: 'lakehouse/catalogs/hudi-catalog'}, | |
| items: ['lakehouse/best-practices/doris-hudi'], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'MaxCompute Catalog', | |
| link: {type: 'doc', id: 'lakehouse/catalogs/maxcompute-catalog'}, | |
| items: ['lakehouse/best-practices/doris-maxcompute'], | |
| }, | |
| 'lakehouse/catalogs/delta-lake-catalog', | |
| 'lakehouse/catalogs/bigquery-catalog', | |
| 'lakehouse/catalogs/kudu-catalog', | |
| 'lakehouse/catalogs/kafka-catalog', | |
| 'lakehouse/catalogs/es-catalog', | |
| 'lakehouse/catalogs/doris-catalog', | |
| 'lakehouse/catalogs/adbc-catalog', | |
| 'lakehouse/catalogs/jdbc-catalog-overview', | |
| 'lakehouse/catalogs/jdbc-mysql-catalog', | |
| 'lakehouse/catalogs/jdbc-pg-catalog', | |
| 'lakehouse/catalogs/jdbc-oracle-catalog', | |
| 'lakehouse/catalogs/jdbc-sqlserver-catalog', | |
| 'lakehouse/catalogs/jdbc-ibmdb2-catalog', | |
| 'lakehouse/catalogs/jdbc-clickhouse-catalog', | |
| 'lakehouse/catalogs/jdbc-saphana-catalog', | |
| 'lakehouse/catalogs/jdbc-oceanbase-catalog', | |
| ], | |
| }, | |
| 'lakehouse/file-analysis', | |
| 'lakehouse/huggingface', | |
| { | |
| type: 'category', | |
| label: 'Metastores', | |
| items: [ | |
| 'lakehouse/metastores/hive-metastore', | |
| 'lakehouse/metastores/aws-glue', | |
| 'lakehouse/metastores/google-dataproc-metastore', | |
| 'lakehouse/metastores/aliyun-dlf', | |
| 'lakehouse/metastores/iceberg-rest', | |
| 'lakehouse/metastores/iceberg-jdbc', | |
| 'lakehouse/metastores/paimon-jdbc', | |
| 'lakehouse/metastores/filesystem', | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'Storages', | |
| items: [ | |
| 'lakehouse/storages/hdfs', | |
| 'lakehouse/storages/s3', | |
| 'lakehouse/storages/azure-blob', | |
| 'lakehouse/storages/gcs', | |
| 'lakehouse/storages/aliyun-oss', | |
| 'lakehouse/storages/tencent-cos', | |
| 'lakehouse/storages/huawei-obs', | |
| 'lakehouse/storages/baidu-bos', | |
| 'lakehouse/storages/seaweedfs', | |
| 'lakehouse/storages/minio', | |
| 'lakehouse/storages/juicefs', | |
| 'lakehouse/storages/ozone', | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'File Format', | |
| items: [ | |
| 'lakehouse/file-formats/parquet', | |
| 'lakehouse/file-formats/orc', | |
| 'lakehouse/file-formats/text', | |
| 'lakehouse/file-formats/lance', | |
| ], | |
| }, | |
| 'lakehouse/data-cache', | |
| 'lakehouse/meta-cache', | |
| 'lakehouse/external-meta-cache-memory-management', | |
| 'lakehouse/compute-node', | |
| 'lakehouse/statistics', | |
| { | |
| type: 'category', | |
| label: 'Lakehouse Best Practices', | |
| items: [ | |
| 'lakehouse/best-practices/optimization', | |
| 'lakehouse/best-practices/doris-lance', | |
| 'lakehouse/best-practices/lance-hybrid-search', | |
| 'lakehouse/best-practices/lance-query-profile', | |
| 'lakehouse/best-practices/kerberos', | |
| 'lakehouse/best-practices/tpch', | |
| 'lakehouse/best-practices/tpcds', | |
| ], | |
| }, | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'Data Governance', | |
| items: [ | |
| 'data-governance/data-lineage', | |
| ], | |
| }, | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'Solutions', | |
| collapsible: false, | |
| collapsed: false, | |
| items: [ | |
| { | |
| type: 'category', | |
| label: 'Doris for AI', | |
| link: {type: 'doc', id: 'ai/ai-overview'}, | |
| collapsed: true, | |
| items: [ | |
| 'ai/ai-function-overview', | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'Observability with Doris', | |
| link: {type: 'doc', id: 'observability/intro'}, | |
| collapsed: true, | |
| items: [ | |
| { | |
| type: 'category', | |
| label: 'DOG Stack', | |
| collapsed: true, | |
| link: {type: 'doc', id: 'observability/dogstack/overview'}, | |
| items: [ | |
| 'observability/dogstack/quickstart', | |
| { | |
| type: 'category', | |
| label: 'Deployment', | |
| items: [ | |
| 'observability/dogstack/docker', | |
| 'observability/dogstack/kubernetes', | |
| ], | |
| }, | |
| 'observability/dogstack/search', | |
| 'observability/dogstack/trace', | |
| 'observability/dogstack/dashboard', | |
| 'observability/dogstack/alert', | |
| ] | |
| }, | |
| { | |
| type: 'category', | |
| label: 'Custom Build', | |
| collapsed: true, | |
| link: {type: 'doc', id: 'observability/overview'}, | |
| items: [ | |
| 'observability/log', | |
| 'observability/trace', | |
| ] | |
| }, | |
| ], | |
| }, | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'Operate & Maintain', | |
| collapsible: false, | |
| collapsed: false, | |
| items: [ | |
| { | |
| type: 'category', | |
| label: 'Administration', | |
| collapsed: true, | |
| items: [ | |
| { | |
| type: 'category', | |
| label: 'Cluster Management', | |
| link: {type: 'doc', id: 'admin-manual/cluster-management/intro'}, | |
| items: [ | |
| 'admin-manual/cluster-management/upgrade', | |
| 'admin-manual/cluster-management/elastic-expansion', | |
| 'admin-manual/cluster-management/load-balancing', | |
| 'admin-manual/cluster-management/fqdn', | |
| 'admin-manual/cluster-management/tso', | |
| 'admin-manual/maint-monitor/automatic-service-start', | |
| 'admin-manual/maint-monitor/tablet-repair-and-balance', | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'Configuration', | |
| items: [ | |
| 'admin-manual/config/config-dir', | |
| 'admin-manual/config/fe-config', | |
| 'admin-manual/config/be-config', | |
| 'admin-manual/config/ms-config', | |
| 'admin-manual/config/user-property', | |
| 'admin-manual/cluster-management/time-zone', | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'Security & Authentication', | |
| link: {type: 'doc', id: 'admin-manual/auth/security-overview'}, | |
| items: [ | |
| { | |
| type: 'category', | |
| label: 'Authentication', | |
| items: [ | |
| 'admin-manual/auth/authentication/internal', | |
| 'admin-manual/auth/authentication/ldap', | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'Authorization', | |
| items: [ | |
| 'admin-manual/auth/authorization/internal', | |
| 'admin-manual/auth/authorization/ranger', | |
| 'admin-manual/auth/authorization/ranger-hive', | |
| 'admin-manual/auth/authorization/data', | |
| 'admin-manual/auth/authorization/custom', | |
| ], | |
| }, | |
| 'admin-manual/audit-plugin', | |
| { | |
| type: 'category', | |
| label: 'Data Encryption', | |
| items: [ | |
| { | |
| type: 'category', | |
| label: 'Encryption in Transit', | |
| items: [ | |
| 'admin-manual/auth/certificate', | |
| 'admin-manual/auth/fe-certificate', | |
| 'admin-manual/auth/tls-framework', | |
| ], | |
| }, | |
| 'admin-manual/auth/encryption-function', | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'Integrations', | |
| items: [ | |
| 'admin-manual/auth/integrations/aws-authentication-and-authorization', | |
| 'admin-manual/auth/integrations/aws-iam-role', | |
| ], | |
| }, | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'Workload Management', | |
| link: {type: 'doc', id: 'admin-manual/workload-management/workload-management-summary'}, | |
| items: [ | |
| { | |
| type: 'category', | |
| label: 'Resource Isolation', | |
| link: {type: 'doc', id: 'admin-manual/workload-management/resource-isolation-intro'}, | |
| items: [ | |
| 'admin-manual/workload-management/resource-group', | |
| 'admin-manual/workload-management/compute-group', | |
| 'admin-manual/workload-management/workload-group', | |
| 'admin-manual/workload-management/workload-group-bind-compute-group', | |
| ], | |
| }, | |
| 'admin-manual/workload-management/concurrency-control-and-queuing', | |
| 'admin-manual/workload-management/spill-disk', | |
| 'admin-manual/workload-management/sql-blocking', | |
| 'admin-manual/workload-management/kill-query', | |
| 'admin-manual/workload-management/query-progress-monitor', | |
| 'admin-manual/workload-management/analysis-diagnosis', | |
| 'admin-manual/workload-management/job-scheduler', | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'Disaster Recovery', | |
| link: {type: 'doc', id: 'admin-manual/data-admin/overview'}, | |
| items: [ | |
| { | |
| type: 'category', | |
| label: 'Backup & Restore', | |
| link: {type: 'doc', id: 'admin-manual/data-admin/backup-restore/overview'}, | |
| items: [ | |
| 'admin-manual/data-admin/backup-restore/backup', | |
| 'admin-manual/data-admin/backup-restore/restore', | |
| ], | |
| }, | |
| 'admin-manual/data-admin/recyclebin', | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'Monitoring & Alerting', | |
| link: {type: 'doc', id: 'admin-manual/maint-monitor/monitor-alert'}, | |
| items: [ | |
| 'admin-manual/maint-monitor/metrics', | |
| 'admin-manual/maint-monitor/disk-capacity', | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'Log Management', | |
| link: {type: 'doc', id: 'admin-manual/log-management/intro'}, | |
| items: ['admin-manual/log-management/fe-log', 'admin-manual/log-management/be-log'], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'System Tables', | |
| link: {type: 'doc', id: 'admin-manual/system-tables/overview'}, | |
| items: [ | |
| { | |
| type: 'category', | |
| label: 'information_schema', | |
| items: [ | |
| 'admin-manual/system-tables/information_schema/active_queries', | |
| 'admin-manual/system-tables/information_schema/backend_active_tasks', | |
| 'admin-manual/system-tables/information_schema/backend_configuration', | |
| 'admin-manual/system-tables/information_schema/backend_tablets', | |
| 'admin-manual/system-tables/information_schema/catalog_meta_cache_statistics', | |
| 'admin-manual/system-tables/information_schema/character_sets', | |
| 'admin-manual/system-tables/information_schema/collations', | |
| 'admin-manual/system-tables/information_schema/column_privileges', | |
| 'admin-manual/system-tables/information_schema/column_statistics', | |
| 'admin-manual/system-tables/information_schema/columns', | |
| 'admin-manual/system-tables/information_schema/engines', | |
| 'admin-manual/system-tables/information_schema/events', | |
| 'admin-manual/system-tables/information_schema/file_cache_info', | |
| 'admin-manual/system-tables/information_schema/file_cache_statistics', | |
| 'admin-manual/system-tables/information_schema/files', | |
| 'admin-manual/system-tables/information_schema/global_variables', | |
| 'admin-manual/system-tables/information_schema/key_column_usage', | |
| 'admin-manual/system-tables/information_schema/metadata_name_ids', | |
| 'admin-manual/system-tables/information_schema/parameters', | |
| 'admin-manual/system-tables/information_schema/partitions', | |
| 'admin-manual/system-tables/information_schema/processlist', | |
| 'admin-manual/system-tables/information_schema/profiling', | |
| 'admin-manual/system-tables/information_schema/referential_constraints', | |
| 'admin-manual/system-tables/information_schema/routines', | |
| 'admin-manual/system-tables/information_schema/routine_load_job', | |
| 'admin-manual/system-tables/information_schema/rowsets', | |
| 'admin-manual/system-tables/information_schema/schema_privileges', | |
| 'admin-manual/system-tables/information_schema/schemata', | |
| 'admin-manual/system-tables/information_schema/session_variables', | |
| 'admin-manual/system-tables/information_schema/statistics', | |
| 'admin-manual/system-tables/information_schema/table_constraints', | |
| 'admin-manual/system-tables/information_schema/table_options', | |
| 'admin-manual/system-tables/information_schema/table_privileges', | |
| 'admin-manual/system-tables/information_schema/table_properties', | |
| 'admin-manual/system-tables/information_schema/table_stream_consumption', | |
| 'admin-manual/system-tables/information_schema/table_streams', | |
| 'admin-manual/system-tables/information_schema/tables', | |
| 'admin-manual/system-tables/information_schema/triggers', | |
| 'admin-manual/system-tables/information_schema/user_privileges', | |
| 'admin-manual/system-tables/information_schema/views', | |
| 'admin-manual/system-tables/information_schema/workload_group_privileges', | |
| 'admin-manual/system-tables/information_schema/workload_group_resource_usage', | |
| 'admin-manual/system-tables/information_schema/workload_groups', | |
| 'admin-manual/system-tables/information_schema/workload_policy', | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'mysql', | |
| items: [ | |
| 'admin-manual/system-tables/mysql/procs_priv', | |
| 'admin-manual/system-tables/mysql/user', | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: '__internal_schema', | |
| items: [ | |
| 'admin-manual/system-tables/internal_schema/audit_log', | |
| 'admin-manual/system-tables/internal_schema/column_statistics', | |
| 'admin-manual/system-tables/internal_schema/partition_statistics', | |
| ], | |
| }, | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'HTTP API', | |
| items: [ | |
| 'admin-manual/open-api/overview', | |
| { | |
| type: 'category', | |
| label: 'FE HTTP API', | |
| items: [ | |
| 'admin-manual/open-api/fe-http/config-action', | |
| 'admin-manual/open-api/fe-http/ha-action', | |
| 'admin-manual/open-api/fe-http/hardware-info-action', | |
| 'admin-manual/open-api/fe-http/help-action', | |
| 'admin-manual/open-api/fe-http/log-action', | |
| 'admin-manual/open-api/fe-http/login-action', | |
| 'admin-manual/open-api/fe-http/logout-action', | |
| 'admin-manual/open-api/fe-http/query-profile-action-controller', | |
| 'admin-manual/open-api/fe-http/session-action', | |
| 'admin-manual/open-api/fe-http/system-action', | |
| 'admin-manual/open-api/fe-http/tso-action', | |
| 'admin-manual/open-api/fe-http/colocate-meta-action', | |
| 'admin-manual/open-api/fe-http/meta-action', | |
| 'admin-manual/open-api/fe-http/meta-backup-action', | |
| 'admin-manual/open-api/fe-http/cluster-action', | |
| 'admin-manual/open-api/fe-http/node-action', | |
| 'admin-manual/open-api/fe-http/query-profile-action', | |
| 'admin-manual/open-api/fe-http/backends-action', | |
| 'admin-manual/open-api/fe-http/bootstrap-action', | |
| 'admin-manual/open-api/fe-http/cancel-load-action', | |
| 'admin-manual/open-api/fe-http/check-decommission-action', | |
| 'admin-manual/open-api/fe-http/check-storage-type-action', | |
| 'admin-manual/open-api/fe-http/connection-action', | |
| 'admin-manual/open-api/fe-http/extra-basepath-action', | |
| 'admin-manual/open-api/fe-http/fe-version-info-action', | |
| 'admin-manual/open-api/fe-http/get-ddl-stmt-action', | |
| 'admin-manual/open-api/fe-http/get-load-info-action', | |
| 'admin-manual/open-api/fe-http/get-load-state', | |
| 'admin-manual/open-api/fe-http/get-log-file-action', | |
| 'admin-manual/open-api/fe-http/get-small-file', | |
| 'admin-manual/open-api/fe-http/get-wal-size-action', | |
| 'admin-manual/open-api/fe-http/health-action', | |
| 'admin-manual/open-api/fe-http/meta-info-action', | |
| 'admin-manual/open-api/fe-http/meta-replay-state-action', | |
| 'admin-manual/open-api/fe-http/metrics-action', | |
| 'admin-manual/open-api/fe-http/profile-action', | |
| 'admin-manual/open-api/fe-http/query-schema-action', | |
| 'admin-manual/open-api/fe-http/query-stats-action', | |
| 'admin-manual/open-api/fe-http/row-count-action', | |
| 'admin-manual/open-api/fe-http/set-config-action', | |
| 'admin-manual/open-api/fe-http/show-data-action', | |
| 'admin-manual/open-api/fe-http/show-meta-info-action', | |
| 'admin-manual/open-api/fe-http/show-proc-action', | |
| 'admin-manual/open-api/fe-http/show-runtime-info-action', | |
| 'admin-manual/open-api/fe-http/show-table-data-action', | |
| 'admin-manual/open-api/fe-http/statement-execution-action', | |
| 'admin-manual/open-api/fe-http/table-query-plan-action', | |
| 'admin-manual/open-api/fe-http/table-row-count-action', | |
| 'admin-manual/open-api/fe-http/table-schema-action', | |
| 'admin-manual/open-api/fe-http/upload-action', | |
| 'admin-manual/open-api/fe-http/import-action', | |
| 'admin-manual/open-api/fe-http/meta-info-action-V2', | |
| 'admin-manual/open-api/fe-http/debug-point-action', | |
| 'admin-manual/open-api/fe-http/statistic-action', | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'BE HTTP API', | |
| items: [ | |
| 'admin-manual/open-api/be-http/check-rpc-channel', | |
| 'admin-manual/open-api/be-http/reset-rpc-channel', | |
| 'admin-manual/open-api/be-http/compaction-status', | |
| 'admin-manual/open-api/be-http/compaction-run', | |
| 'admin-manual/open-api/be-http/compaction-score', | |
| 'admin-manual/open-api/be-http/meta', | |
| 'admin-manual/open-api/be-http/snapshot', | |
| 'admin-manual/open-api/be-http/check-tablet-segment', | |
| 'admin-manual/open-api/be-http/config', | |
| 'admin-manual/open-api/be-http/metrics', | |
| 'admin-manual/open-api/be-http/tablet-distribution', | |
| 'admin-manual/open-api/be-http/tablet-migration', | |
| 'admin-manual/open-api/be-http/tablet-info', | |
| 'admin-manual/open-api/be-http/checksum', | |
| 'admin-manual/open-api/be-http/download', | |
| 'admin-manual/open-api/be-http/pad-rowset', | |
| 'admin-manual/open-api/be-http/version-info', | |
| 'admin-manual/open-api/be-http/health', | |
| 'admin-manual/open-api/be-http/tablet-reload', | |
| 'admin-manual/open-api/be-http/tablet-restore', | |
| 'admin-manual/open-api/be-http/be-vlog', | |
| ], | |
| }, | |
| ], | |
| }, | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'Troubleshooting & FAQ', | |
| collapsed: true, | |
| items: [ | |
| { | |
| type: 'category', | |
| label: 'Troubleshooting', | |
| items: [ | |
| { | |
| type: 'category', | |
| label: 'Memory Management', | |
| items: [ | |
| 'admin-manual/trouble-shooting/memory-management/overview', | |
| 'admin-manual/trouble-shooting/memory-management/memory-issue-faq', | |
| { | |
| type: 'category', | |
| label: 'Memory Analysis', | |
| items: [ | |
| 'admin-manual/trouble-shooting/memory-management/memory-analysis/jemalloc-memory-analysis', | |
| 'admin-manual/trouble-shooting/memory-management/memory-analysis/global-memory-analysis', | |
| 'admin-manual/trouble-shooting/memory-management/memory-analysis/doris-cache-memory-analysis', | |
| 'admin-manual/trouble-shooting/memory-management/memory-analysis/metadata-memory-analysis', | |
| 'admin-manual/trouble-shooting/memory-management/memory-analysis/query-memory-analysis', | |
| 'admin-manual/trouble-shooting/memory-management/memory-analysis/load-memory-analysis', | |
| 'admin-manual/trouble-shooting/memory-management/memory-analysis/query-cancelled-after-process-memory-exceeded', | |
| 'admin-manual/trouble-shooting/memory-management/memory-analysis/query-cancelled-after-query-memory-exceeded', | |
| 'admin-manual/trouble-shooting/memory-management/memory-analysis/oom-crash-analysis', | |
| 'admin-manual/trouble-shooting/memory-management/memory-analysis/memory-log-analysis', | |
| 'admin-manual/trouble-shooting/memory-management/memory-analysis/heap-profile-memory-analysis', | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'Memory Feature', | |
| items: [ | |
| 'admin-manual/trouble-shooting/memory-management/memory-feature/memory-tracker', | |
| 'admin-manual/trouble-shooting/memory-management/memory-feature/memory-control-strategy', | |
| ], | |
| }, | |
| ], | |
| }, | |
| 'admin-manual/trouble-shooting/compaction', | |
| 'admin-manual/trouble-shooting/compaction-principles', | |
| 'admin-manual/trouble-shooting/metadata-operation', | |
| 'admin-manual/trouble-shooting/frontend-lock-manager', | |
| 'admin-manual/trouble-shooting/tablet-local-debug', | |
| 'admin-manual/trouble-shooting/tablet-meta-tool', | |
| 'admin-manual/trouble-shooting/repairing-data', | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'FAQ', | |
| items: [ | |
| 'faq/install-faq', | |
| 'faq/data-faq', | |
| 'faq/sql-faq', | |
| 'faq/lakehouse-faq', | |
| 'faq/bi-faq', | |
| 'faq/correctness-faq', | |
| 'faq/load-faq', | |
| ], | |
| }, | |
| ], | |
| }, | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'SQL References', | |
| collapsible: false, | |
| collapsed: false, | |
| items: [ | |
| { | |
| type: 'category', | |
| label: 'Basic Elements', | |
| items: [ | |
| { | |
| type: 'category', | |
| label: 'SQL Data Types', | |
| items: [ | |
| 'sql-manual/basic-element/sql-data-types/data-type-overview', | |
| { | |
| type: 'category', | |
| label: 'Numeric Data Type', | |
| items: [ | |
| 'sql-manual/basic-element/sql-data-types/numeric/BOOLEAN', | |
| 'sql-manual/basic-element/sql-data-types/numeric/TINYINT', | |
| 'sql-manual/basic-element/sql-data-types/numeric/SMALLINT', | |
| 'sql-manual/basic-element/sql-data-types/numeric/INT', | |
| 'sql-manual/basic-element/sql-data-types/numeric/BIGINT', | |
| 'sql-manual/basic-element/sql-data-types/numeric/LARGEINT', | |
| 'sql-manual/basic-element/sql-data-types/numeric/DECIMAL', | |
| 'sql-manual/basic-element/sql-data-types/numeric/FLOATING-POINT', | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'Datetime Data Type', | |
| items: [ | |
| 'sql-manual/basic-element/sql-data-types/date-time/DATE', | |
| 'sql-manual/basic-element/sql-data-types/date-time/TIME', | |
| 'sql-manual/basic-element/sql-data-types/date-time/DATETIME', | |
| 'sql-manual/basic-element/sql-data-types/date-time/TIMESTAMP-NS', | |
| 'sql-manual/basic-element/sql-data-types/date-time/TIMESTAMPTZ', | |
| 'admin-manual/cluster-management/time-zone', | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'String Data Type', | |
| items: [ | |
| 'sql-manual/basic-element/sql-data-types/string-type/CHAR', | |
| 'sql-manual/basic-element/sql-data-types/string-type/VARCHAR', | |
| 'sql-manual/basic-element/sql-data-types/string-type/STRING', | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'Binary Data Type', | |
| items: ['sql-manual/basic-element/sql-data-types/binary-type/VARBINARY'], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'Semi-Structured Data Type', | |
| items: [ | |
| 'sql-manual/basic-element/sql-data-types/semi-structured/ARRAY', | |
| 'sql-manual/basic-element/sql-data-types/semi-structured/GEO', | |
| 'sql-manual/basic-element/sql-data-types/semi-structured/MAP', | |
| 'sql-manual/basic-element/sql-data-types/semi-structured/STRUCT', | |
| 'sql-manual/basic-element/sql-data-types/semi-structured/JSON', | |
| { | |
| type: 'category', | |
| label: 'VARIANT', | |
| link: { | |
| type: 'doc', | |
| id: 'sql-manual/basic-element/sql-data-types/semi-structured/VARIANT', | |
| }, | |
| collapsed: true, | |
| items: [ | |
| { | |
| type: 'doc', | |
| id: 'sql-manual/basic-element/sql-data-types/semi-structured/variant-workload-guide', | |
| label: 'VARIANT Internal', | |
| }, | |
| ], | |
| }, | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'Aggregation Data Type', | |
| items: [ | |
| 'sql-manual/basic-element/sql-data-types/aggregate/HLL', | |
| 'sql-manual/basic-element/sql-data-types/aggregate/BITMAP', | |
| 'sql-manual/basic-element/sql-data-types/aggregate/QUANTILE-STATE', | |
| 'sql-manual/basic-element/sql-data-types/aggregate/AGG-STATE', | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'IP Data Type', | |
| items: [ | |
| 'sql-manual/basic-element/sql-data-types/ip/IPV4', | |
| 'sql-manual/basic-element/sql-data-types/ip/IPV6', | |
| ], | |
| }, | |
| 'sql-manual/basic-element/sql-data-types/uuid', | |
| { | |
| type: 'category', | |
| label: 'Conversion', | |
| items: [ | |
| 'sql-manual/basic-element/sql-data-types/conversion/overview', | |
| 'sql-manual/basic-element/sql-data-types/conversion/cast-expr', | |
| 'sql-manual/basic-element/sql-data-types/conversion/cast-to-string', | |
| 'sql-manual/basic-element/sql-data-types/conversion/array-conversion', | |
| 'sql-manual/basic-element/sql-data-types/conversion/boolean-conversion', | |
| 'sql-manual/basic-element/sql-data-types/conversion/date-conversion', | |
| 'sql-manual/basic-element/sql-data-types/conversion/datetime-conversion', | |
| 'sql-manual/basic-element/sql-data-types/conversion/timestamp-ns-conversion', | |
| 'sql-manual/basic-element/sql-data-types/conversion/timestamptz-conversion', | |
| 'sql-manual/basic-element/sql-data-types/conversion/decimal-conversion', | |
| 'sql-manual/basic-element/sql-data-types/conversion/float-double-conversion', | |
| 'sql-manual/basic-element/sql-data-types/conversion/int-conversion', | |
| 'sql-manual/basic-element/sql-data-types/conversion/ip-conversion', | |
| 'sql-manual/basic-element/sql-data-types/conversion/json-conversion', | |
| 'sql-manual/basic-element/sql-data-types/conversion/map-conversion', | |
| 'sql-manual/basic-element/sql-data-types/conversion/struct-conversion', | |
| 'sql-manual/basic-element/sql-data-types/conversion/time-conversion', | |
| 'sql-manual/basic-element/sql-data-types/conversion/uuid-conversion', | |
| ], | |
| }, | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'Literal', | |
| items: [ | |
| 'sql-manual/basic-element/literal/numeric-literal', | |
| 'sql-manual/basic-element/literal/string-literal', | |
| 'sql-manual/basic-element/literal/date-literal', | |
| ], | |
| }, | |
| 'sql-manual/basic-element/nulls', | |
| 'sql-manual/basic-element/object-identifiers', | |
| 'sql-manual/basic-element/reserved-keywords', | |
| 'sql-manual/basic-element/variables', | |
| 'sql-manual/basic-element/session-variables', | |
| 'sql-manual/basic-element/comments', | |
| 'sql-manual/basic-element/file-path-pattern', | |
| { | |
| type: 'category', | |
| label: 'Operators', | |
| items: [ | |
| 'sql-manual/basic-element/operators/arithmetic-operators', | |
| { | |
| type: 'category', | |
| label: 'Conditional Operators', | |
| items: [ | |
| 'sql-manual/basic-element/operators/conditional-operators/logical-operators', | |
| 'sql-manual/basic-element/operators/conditional-operators/comparison-operators', | |
| 'sql-manual/basic-element/operators/conditional-operators/boolean-testing-operators', | |
| 'sql-manual/basic-element/operators/conditional-operators/pattern-matching-operators', | |
| 'sql-manual/basic-element/operators/conditional-operators/full-text-search-operators', | |
| 'sql-manual/basic-element/operators/conditional-operators/in-operators', | |
| 'sql-manual/basic-element/operators/conditional-operators/exists-operators', | |
| ], | |
| }, | |
| 'sql-manual/basic-element/operators/bitwise-operators', | |
| 'sql-manual/basic-element/operators/assignment-operators', | |
| 'sql-manual/basic-element/operators/operator-precedence', | |
| ], | |
| }, | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'SQL Functions', | |
| items: [ | |
| { | |
| type: 'category', | |
| label: 'AI Functions', | |
| items: [ | |
| { | |
| type: 'category', | |
| label: 'Vector Distance Functions', | |
| items: [ | |
| 'sql-manual/sql-functions/ai-functions/distance-functions/cosine-distance', | |
| 'sql-manual/sql-functions/ai-functions/distance-functions/cosine-similarity', | |
| 'sql-manual/sql-functions/ai-functions/distance-functions/inner-product', | |
| 'sql-manual/sql-functions/ai-functions/distance-functions/l1-distance', | |
| 'sql-manual/sql-functions/ai-functions/distance-functions/l2-distance', | |
| 'sql-manual/sql-functions/ai-functions/distance-functions/embed', | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'AI Functions', | |
| items: [ | |
| 'sql-manual/sql-functions/ai-functions/overview', | |
| 'sql-manual/sql-functions/ai-functions/ai-classify', | |
| 'sql-manual/sql-functions/ai-functions/ai-extract', | |
| 'sql-manual/sql-functions/ai-functions/ai-filter', | |
| 'sql-manual/sql-functions/ai-functions/ai-fixgrammar', | |
| 'sql-manual/sql-functions/ai-functions/ai-generate', | |
| 'sql-manual/sql-functions/ai-functions/ai-mask', | |
| 'sql-manual/sql-functions/ai-functions/ai-sentiment', | |
| 'sql-manual/sql-functions/ai-functions/ai-similarity', | |
| 'sql-manual/sql-functions/ai-functions/ai-summarize', | |
| 'sql-manual/sql-functions/ai-functions/ai-translate', | |
| ], | |
| }, | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'Scalar Functions', | |
| items: [ | |
| { | |
| type: 'category', | |
| label: 'UUID Functions', | |
| items: [ | |
| 'sql-manual/sql-functions/scalar-functions/uuid-functions/uuid-v4', | |
| 'sql-manual/sql-functions/scalar-functions/uuid-functions/uuid-v7', | |
| 'sql-manual/sql-functions/scalar-functions/uuid-functions/uuid-version', | |
| 'sql-manual/sql-functions/scalar-functions/uuid-functions/to-uuid-or-null', | |
| 'sql-manual/sql-functions/scalar-functions/uuid-functions/to-uuid-or-zero', | |
| 'sql-manual/sql-functions/scalar-functions/uuid-functions/to-uuid-or-default', | |
| 'sql-manual/sql-functions/scalar-functions/uuid-functions/uuid-v7-to-datetime', | |
| 'sql-manual/sql-functions/scalar-functions/uuid-functions/datetime-to-uuid-v7', | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'Numeric Functions', | |
| items: [ | |
| 'sql-manual/sql-functions/scalar-functions/numeric-functions/abs', | |
| 'sql-manual/sql-functions/scalar-functions/numeric-functions/acos', | |
| 'sql-manual/sql-functions/scalar-functions/numeric-functions/acosh', | |
| 'sql-manual/sql-functions/scalar-functions/numeric-functions/asin', | |
| 'sql-manual/sql-functions/scalar-functions/numeric-functions/asinh', | |
| 'sql-manual/sql-functions/scalar-functions/numeric-functions/atan', | |
| 'sql-manual/sql-functions/scalar-functions/numeric-functions/atan2', | |
| 'sql-manual/sql-functions/scalar-functions/numeric-functions/atanh', | |
| 'sql-manual/sql-functions/scalar-functions/numeric-functions/bin', | |
| 'sql-manual/sql-functions/scalar-functions/numeric-functions/cbrt', | |
| 'sql-manual/sql-functions/scalar-functions/numeric-functions/ceil', | |
| 'sql-manual/sql-functions/scalar-functions/numeric-functions/conv', | |
| 'sql-manual/sql-functions/scalar-functions/numeric-functions/cos', | |
| 'sql-manual/sql-functions/scalar-functions/numeric-functions/cosh', | |
| 'sql-manual/sql-functions/scalar-functions/numeric-functions/cot', | |
| 'sql-manual/sql-functions/scalar-functions/numeric-functions/csc', | |
| 'sql-manual/sql-functions/scalar-functions/numeric-functions/degrees', | |
| 'sql-manual/sql-functions/scalar-functions/numeric-functions/e', | |
| 'sql-manual/sql-functions/scalar-functions/numeric-functions/exp', | |
| 'sql-manual/sql-functions/scalar-functions/numeric-functions/factorial', | |
| 'sql-manual/sql-functions/scalar-functions/numeric-functions/floor', | |
| 'sql-manual/sql-functions/scalar-functions/numeric-functions/fmod', | |
| 'sql-manual/sql-functions/scalar-functions/numeric-functions/format-round', | |
| "sql-manual/sql-functions/scalar-functions/numeric-functions/interval", | |
| 'sql-manual/sql-functions/scalar-functions/numeric-functions/isinf', | |
| 'sql-manual/sql-functions/scalar-functions/numeric-functions/isnan', | |
| 'sql-manual/sql-functions/scalar-functions/numeric-functions/ln', | |
| 'sql-manual/sql-functions/scalar-functions/numeric-functions/log', | |
| 'sql-manual/sql-functions/scalar-functions/numeric-functions/log10', | |
| 'sql-manual/sql-functions/scalar-functions/numeric-functions/log2', | |
| 'sql-manual/sql-functions/scalar-functions/numeric-functions/mod', | |
| 'sql-manual/sql-functions/scalar-functions/numeric-functions/money-format', | |
| 'sql-manual/sql-functions/scalar-functions/numeric-functions/negative', | |
| 'sql-manual/sql-functions/scalar-functions/numeric-functions/normal-cdf', | |
| 'sql-manual/sql-functions/scalar-functions/numeric-functions/pi', | |
| 'sql-manual/sql-functions/scalar-functions/numeric-functions/pmod', | |
| 'sql-manual/sql-functions/scalar-functions/numeric-functions/positive', | |
| 'sql-manual/sql-functions/scalar-functions/numeric-functions/pow', | |
| 'sql-manual/sql-functions/scalar-functions/numeric-functions/radians', | |
| 'sql-manual/sql-functions/scalar-functions/numeric-functions/random', | |
| 'sql-manual/sql-functions/scalar-functions/numeric-functions/round', | |
| 'sql-manual/sql-functions/scalar-functions/numeric-functions/round-bankers', | |
| 'sql-manual/sql-functions/scalar-functions/numeric-functions/sec', | |
| 'sql-manual/sql-functions/scalar-functions/numeric-functions/sign', | |
| 'sql-manual/sql-functions/scalar-functions/numeric-functions/sin', | |
| 'sql-manual/sql-functions/scalar-functions/numeric-functions/sinh', | |
| 'sql-manual/sql-functions/scalar-functions/numeric-functions/sqrt', | |
| 'sql-manual/sql-functions/scalar-functions/numeric-functions/tan', | |
| 'sql-manual/sql-functions/scalar-functions/numeric-functions/tanh', | |
| 'sql-manual/sql-functions/scalar-functions/numeric-functions/truncate', | |
| 'sql-manual/sql-functions/scalar-functions/numeric-functions/uniform', | |
| 'sql-manual/sql-functions/scalar-functions/numeric-functions/uuid_numeric', | |
| 'sql-manual/sql-functions/scalar-functions/numeric-functions/width-bucket', | |
| 'sql-manual/sql-functions/scalar-functions/numeric-functions/even', | |
| 'sql-manual/sql-functions/scalar-functions/numeric-functions/signbit', | |
| 'sql-manual/sql-functions/scalar-functions/numeric-functions/gcd', | |
| 'sql-manual/sql-functions/scalar-functions/numeric-functions/lcm', | |
| 'sql-manual/sql-functions/scalar-functions/numeric-functions/xor', | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'String Functions', | |
| items: [ | |
| 'sql-manual/sql-functions/scalar-functions/string-functions/overview', | |
| 'sql-manual/sql-functions/scalar-functions/string-functions/append-trailing-char-if-absent', | |
| 'sql-manual/sql-functions/scalar-functions/string-functions/ascii', | |
| 'sql-manual/sql-functions/scalar-functions/string-functions/auto-partition-name', | |
| 'sql-manual/sql-functions/scalar-functions/string-functions/char', | |
| 'sql-manual/sql-functions/scalar-functions/string-functions/char-length', | |
| 'sql-manual/sql-functions/scalar-functions/string-functions/concat', | |
| 'sql-manual/sql-functions/scalar-functions/string-functions/concat-ws', | |
| 'sql-manual/sql-functions/scalar-functions/string-functions/compress', | |
| 'sql-manual/sql-functions/scalar-functions/string-functions/count_substrings', | |
| 'sql-manual/sql-functions/scalar-functions/string-functions/cut-to-first-significant-subdomain', | |
| 'sql-manual/sql-functions/scalar-functions/string-functions/damerau_levenshtein_distance', | |
| 'sql-manual/sql-functions/scalar-functions/string-functions/decode', | |
| 'sql-manual/sql-functions/scalar-functions/string-functions/digital-masking', | |
| 'sql-manual/sql-functions/scalar-functions/string-functions/domain', | |
| 'sql-manual/sql-functions/scalar-functions/string-functions/domain-without-www', | |
| 'sql-manual/sql-functions/scalar-functions/string-functions/encode', | |
| 'sql-manual/sql-functions/scalar-functions/string-functions/ends-with', | |
| 'sql-manual/sql-functions/scalar-functions/string-functions/export-set', | |
| 'sql-manual/sql-functions/scalar-functions/string-functions/elt', | |
| 'sql-manual/sql-functions/scalar-functions/string-functions/extract-url-parameter', | |
| 'sql-manual/sql-functions/scalar-functions/string-functions/from-base64', | |
| 'sql-manual/sql-functions/scalar-functions/string-functions/find-in-set', | |
| 'sql-manual/sql-functions/scalar-functions/string-functions/first-significant-subdomain', | |
| 'sql-manual/sql-functions/scalar-functions/string-functions/format', | |
| 'sql-manual/sql-functions/scalar-functions/string-functions/format-number', | |
| 'sql-manual/sql-functions/scalar-functions/string-functions/hex', | |
| 'sql-manual/sql-functions/scalar-functions/string-functions/initcap', | |
| 'sql-manual/sql-functions/scalar-functions/string-functions/instr', | |
| 'sql-manual/sql-functions/scalar-functions/string-functions/int-to-uuid', | |
| 'sql-manual/sql-functions/scalar-functions/string-functions/is-uuid', | |
| 'sql-manual/sql-functions/scalar-functions/string-functions/is-valid-utf8', | |
| 'sql-manual/sql-functions/scalar-functions/string-functions/lcase', | |
| 'sql-manual/sql-functions/scalar-functions/string-functions/length', | |
| 'sql-manual/sql-functions/scalar-functions/string-functions/levenshtein', | |
| 'sql-manual/sql-functions/scalar-functions/string-functions/locate', | |
| 'sql-manual/sql-functions/scalar-functions/string-functions/lpad', | |
| 'sql-manual/sql-functions/scalar-functions/string-functions/ltrim', | |
| 'sql-manual/sql-functions/scalar-functions/string-functions/ltrim-in', | |
| 'sql-manual/sql-functions/scalar-functions/string-functions/make-set', | |
| 'sql-manual/sql-functions/scalar-functions/string-functions/mask', | |
| 'sql-manual/sql-functions/scalar-functions/string-functions/mask-first-n', | |
| 'sql-manual/sql-functions/scalar-functions/string-functions/mask-last-n', | |
| 'sql-manual/sql-functions/scalar-functions/string-functions/multi-match-any', | |
| 'sql-manual/sql-functions/scalar-functions/string-functions/multi-search-all-positions', | |
| 'sql-manual/sql-functions/scalar-functions/string-functions/ngram-search', | |
| 'sql-manual/sql-functions/scalar-functions/string-functions/overlay', | |
| 'sql-manual/sql-functions/scalar-functions/string-functions/parse-data-size', | |
| 'sql-manual/sql-functions/scalar-functions/string-functions/parse-url', | |
| 'sql-manual/sql-functions/scalar-functions/string-functions/position', | |
| 'sql-manual/sql-functions/scalar-functions/string-functions/protocol', | |
| 'sql-manual/sql-functions/scalar-functions/string-functions/quote', | |
| 'sql-manual/sql-functions/scalar-functions/string-functions/random_bytes', | |
| 'sql-manual/sql-functions/scalar-functions/string-functions/regexp', | |
| 'sql-manual/sql-functions/scalar-functions/string-functions/regexp-count', | |
| 'sql-manual/sql-functions/scalar-functions/string-functions/regexp-extract', | |
| 'sql-manual/sql-functions/scalar-functions/string-functions/regexp-extract-all', | |
| 'sql-manual/sql-functions/scalar-functions/string-functions/regexp-extract-all-array', | |
| 'sql-manual/sql-functions/scalar-functions/string-functions/regexp-extract-or-null', | |
| 'sql-manual/sql-functions/scalar-functions/string-functions/regexp-replace', | |
| 'sql-manual/sql-functions/scalar-functions/string-functions/regexp-replace-one', | |
| 'sql-manual/sql-functions/scalar-functions/string-functions/replace', | |
| 'sql-manual/sql-functions/scalar-functions/string-functions/replace-empty', | |
| 'sql-manual/sql-functions/scalar-functions/string-functions/repeat', | |
| 'sql-manual/sql-functions/scalar-functions/string-functions/reverse', | |
| 'sql-manual/sql-functions/scalar-functions/string-functions/rpad', | |
| 'sql-manual/sql-functions/scalar-functions/string-functions/rtrim', | |
| 'sql-manual/sql-functions/scalar-functions/string-functions/rtrim-in', | |
| 'sql-manual/sql-functions/scalar-functions/string-functions/soundex', | |
| 'sql-manual/sql-functions/scalar-functions/string-functions/strleft', | |
| 'sql-manual/sql-functions/scalar-functions/string-functions/strright', | |
| 'sql-manual/sql-functions/scalar-functions/string-functions/split-by-regexp', | |
| 'sql-manual/sql-functions/scalar-functions/string-functions/split-by-string', | |
| 'sql-manual/sql-functions/scalar-functions/string-functions/split-part', | |
| 'sql-manual/sql-functions/scalar-functions/string-functions/space', | |
| 'sql-manual/sql-functions/scalar-functions/string-functions/strcmp', | |
| 'sql-manual/sql-functions/scalar-functions/string-functions/starts-with', | |
| 'sql-manual/sql-functions/scalar-functions/string-functions/sub-replace', | |
| 'sql-manual/sql-functions/scalar-functions/string-functions/substring', | |
| 'sql-manual/sql-functions/scalar-functions/string-functions/substring-index', | |
| 'sql-manual/sql-functions/scalar-functions/string-functions/tokenize', | |
| 'sql-manual/sql-functions/scalar-functions/string-functions/trim', | |
| 'sql-manual/sql-functions/scalar-functions/string-functions/trim-in', | |
| 'sql-manual/sql-functions/scalar-functions/string-functions/top-level-domain', | |
| 'sql-manual/sql-functions/scalar-functions/string-functions/to-base64', | |
| 'sql-manual/sql-functions/scalar-functions/string-functions/translate', | |
| 'sql-manual/sql-functions/scalar-functions/string-functions/uncompress', | |
| 'sql-manual/sql-functions/scalar-functions/string-functions/unhex', | |
| 'sql-manual/sql-functions/scalar-functions/string-functions/ucase', | |
| 'sql-manual/sql-functions/scalar-functions/string-functions/unicode_normalize', | |
| 'sql-manual/sql-functions/scalar-functions/string-functions/url-decode', | |
| 'sql-manual/sql-functions/scalar-functions/string-functions/url-encode', | |
| 'sql-manual/sql-functions/scalar-functions/string-functions/uuid', | |
| 'sql-manual/sql-functions/scalar-functions/string-functions/xpath-string', | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'Date Functions', | |
| items: [ | |
| 'sql-manual/sql-functions/scalar-functions/date-time-functions/add-time', | |
| 'sql-manual/sql-functions/scalar-functions/date-time-functions/century', | |
| 'sql-manual/sql-functions/scalar-functions/date-time-functions/convert-tz', | |
| 'sql-manual/sql-functions/scalar-functions/date-time-functions/curdate', | |
| 'sql-manual/sql-functions/scalar-functions/date-time-functions/curtime', | |
| 'sql-manual/sql-functions/scalar-functions/date-time-functions/date', | |
| 'sql-manual/sql-functions/scalar-functions/date-time-functions/date-add', | |
| 'sql-manual/sql-functions/scalar-functions/date-time-functions/date-ceil', | |
| 'sql-manual/sql-functions/scalar-functions/date-time-functions/date-floor', | |
| 'sql-manual/sql-functions/scalar-functions/date-time-functions/date-format', | |
| 'sql-manual/sql-functions/scalar-functions/date-time-functions/date-sub', | |
| 'sql-manual/sql-functions/scalar-functions/date-time-functions/date-trunc', | |
| 'sql-manual/sql-functions/scalar-functions/date-time-functions/datediff', | |
| 'sql-manual/sql-functions/scalar-functions/date-time-functions/day', | |
| 'sql-manual/sql-functions/scalar-functions/date-time-functions/day-ceil', | |
| 'sql-manual/sql-functions/scalar-functions/date-time-functions/day-floor', | |
| 'sql-manual/sql-functions/scalar-functions/date-time-functions/dayname', | |
| 'sql-manual/sql-functions/scalar-functions/date-time-functions/dayofweek', | |
| 'sql-manual/sql-functions/scalar-functions/date-time-functions/dayofyear', | |
| 'sql-manual/sql-functions/scalar-functions/date-time-functions/extract', | |
| 'sql-manual/sql-functions/scalar-functions/date-time-functions/from-days', | |
| 'sql-manual/sql-functions/scalar-functions/date-time-functions/from-iso8601-date', | |
| 'sql-manual/sql-functions/scalar-functions/date-time-functions/from-microsecond', | |
| 'sql-manual/sql-functions/scalar-functions/date-time-functions/from-millisecond', | |
| 'sql-manual/sql-functions/scalar-functions/date-time-functions/from-second', | |
| 'sql-manual/sql-functions/scalar-functions/date-time-functions/from-unixtime', | |
| 'sql-manual/sql-functions/scalar-functions/date-time-functions/get-format', | |
| 'sql-manual/sql-functions/scalar-functions/date-time-functions/hour', | |
| 'sql-manual/sql-functions/scalar-functions/date-time-functions/hour-ceil', | |
| 'sql-manual/sql-functions/scalar-functions/date-time-functions/hour-floor', | |
| 'sql-manual/sql-functions/scalar-functions/date-time-functions/hours-add', | |
| 'sql-manual/sql-functions/scalar-functions/date-time-functions/hours-diff', | |
| 'sql-manual/sql-functions/scalar-functions/date-time-functions/hours-sub', | |
| 'sql-manual/sql-functions/scalar-functions/date-time-functions/last-day', | |
| 'sql-manual/sql-functions/scalar-functions/date-time-functions/makedate', | |
| 'sql-manual/sql-functions/scalar-functions/date-time-functions/maketime', | |
| 'sql-manual/sql-functions/scalar-functions/date-time-functions/microsecond', | |
| 'sql-manual/sql-functions/scalar-functions/date-time-functions/microsecond-timestamp', | |
| 'sql-manual/sql-functions/scalar-functions/date-time-functions/microseconds-add', | |
| 'sql-manual/sql-functions/scalar-functions/date-time-functions/microseconds-diff', | |
| 'sql-manual/sql-functions/scalar-functions/date-time-functions/microseconds-sub', | |
| 'sql-manual/sql-functions/scalar-functions/date-time-functions/millisecond-timestamp', | |
| 'sql-manual/sql-functions/scalar-functions/date-time-functions/milliseconds-add', | |
| 'sql-manual/sql-functions/scalar-functions/date-time-functions/milliseconds-diff', | |
| 'sql-manual/sql-functions/scalar-functions/date-time-functions/milliseconds-sub', | |
| 'sql-manual/sql-functions/scalar-functions/date-time-functions/minute', | |
| 'sql-manual/sql-functions/scalar-functions/date-time-functions/minute-ceil', | |
| 'sql-manual/sql-functions/scalar-functions/date-time-functions/minute-floor', | |
| 'sql-manual/sql-functions/scalar-functions/date-time-functions/minutes-add', | |
| 'sql-manual/sql-functions/scalar-functions/date-time-functions/minutes-diff', | |
| 'sql-manual/sql-functions/scalar-functions/date-time-functions/minutes-sub', | |
| 'sql-manual/sql-functions/scalar-functions/date-time-functions/month', | |
| 'sql-manual/sql-functions/scalar-functions/date-time-functions/month-ceil', | |
| 'sql-manual/sql-functions/scalar-functions/date-time-functions/month-floor', | |
| 'sql-manual/sql-functions/scalar-functions/date-time-functions/monthname', | |
| 'sql-manual/sql-functions/scalar-functions/date-time-functions/months-add', | |
| 'sql-manual/sql-functions/scalar-functions/date-time-functions/months-between', | |
| 'sql-manual/sql-functions/scalar-functions/date-time-functions/months-diff', | |
| 'sql-manual/sql-functions/scalar-functions/date-time-functions/months-sub', | |
| 'sql-manual/sql-functions/scalar-functions/date-time-functions/nanosecond', | |
| 'sql-manual/sql-functions/scalar-functions/date-time-functions/nanoseconds-add', | |
| 'sql-manual/sql-functions/scalar-functions/date-time-functions/nanoseconds-diff', | |
| 'sql-manual/sql-functions/scalar-functions/date-time-functions/nanoseconds-sub', | |
| 'sql-manual/sql-functions/scalar-functions/date-time-functions/now', | |
| 'sql-manual/sql-functions/scalar-functions/date-time-functions/next-day', | |
| 'sql-manual/sql-functions/scalar-functions/date-time-functions/period-add', | |
| 'sql-manual/sql-functions/scalar-functions/date-time-functions/period-diff', | |
| 'sql-manual/sql-functions/scalar-functions/date-time-functions/previous-day', | |
| 'sql-manual/sql-functions/scalar-functions/date-time-functions/quarter', | |
| 'sql-manual/sql-functions/scalar-functions/date-time-functions/quarters-add', | |
| 'sql-manual/sql-functions/scalar-functions/date-time-functions/quarters-sub', | |
| 'sql-manual/sql-functions/scalar-functions/date-time-functions/sec-to-time', | |
| 'sql-manual/sql-functions/scalar-functions/date-time-functions/second', | |
| 'sql-manual/sql-functions/scalar-functions/date-time-functions/second-ceil', | |
| 'sql-manual/sql-functions/scalar-functions/date-time-functions/second-floor', | |
| 'sql-manual/sql-functions/scalar-functions/date-time-functions/seconds-add', | |
| 'sql-manual/sql-functions/scalar-functions/date-time-functions/seconds-diff', | |
| 'sql-manual/sql-functions/scalar-functions/date-time-functions/seconds-sub', | |
| 'sql-manual/sql-functions/scalar-functions/date-time-functions/str-to-date', | |
| "sql-manual/sql-functions/scalar-functions/date-time-functions/sub-time", | |
| 'sql-manual/sql-functions/scalar-functions/date-time-functions/timestamp', | |
| 'sql-manual/sql-functions/scalar-functions/date-time-functions/timestampadd', | |
| 'sql-manual/sql-functions/scalar-functions/date-time-functions/timestampdiff', | |
| 'sql-manual/sql-functions/scalar-functions/date-time-functions/time', | |
| 'sql-manual/sql-functions/scalar-functions/date-time-functions/timediff', | |
| "sql-manual/sql-functions/scalar-functions/date-time-functions/time-format", | |
| 'sql-manual/sql-functions/scalar-functions/date-time-functions/time-to-sec', | |
| 'sql-manual/sql-functions/scalar-functions/date-time-functions/to-date', | |
| 'sql-manual/sql-functions/scalar-functions/date-time-functions/to-days', | |
| 'sql-manual/sql-functions/scalar-functions/date-time-functions/to-iso8601', | |
| 'sql-manual/sql-functions/scalar-functions/date-time-functions/to-monday', | |
| "sql-manual/sql-functions/scalar-functions/date-time-functions/to-seconds", | |
| 'sql-manual/sql-functions/scalar-functions/date-time-functions/utc-date', | |
| 'sql-manual/sql-functions/scalar-functions/date-time-functions/utc-time', | |
| 'sql-manual/sql-functions/scalar-functions/date-time-functions/utc-timestamp', | |
| 'sql-manual/sql-functions/scalar-functions/date-time-functions/unix-timestamp', | |
| 'sql-manual/sql-functions/scalar-functions/date-time-functions/week', | |
| 'sql-manual/sql-functions/scalar-functions/date-time-functions/week-ceil', | |
| 'sql-manual/sql-functions/scalar-functions/date-time-functions/week-floor', | |
| 'sql-manual/sql-functions/scalar-functions/date-time-functions/weekday', | |
| 'sql-manual/sql-functions/scalar-functions/date-time-functions/weekofyear', | |
| 'sql-manual/sql-functions/scalar-functions/date-time-functions/weeks-add', | |
| 'sql-manual/sql-functions/scalar-functions/date-time-functions/weeks-diff', | |
| 'sql-manual/sql-functions/scalar-functions/date-time-functions/weeks-sub', | |
| 'sql-manual/sql-functions/scalar-functions/date-time-functions/year', | |
| 'sql-manual/sql-functions/scalar-functions/date-time-functions/year-ceil', | |
| 'sql-manual/sql-functions/scalar-functions/date-time-functions/year-floor', | |
| 'sql-manual/sql-functions/scalar-functions/date-time-functions/year-of-week', | |
| 'sql-manual/sql-functions/scalar-functions/date-time-functions/yearweek', | |
| 'sql-manual/sql-functions/scalar-functions/date-time-functions/years-add', | |
| 'sql-manual/sql-functions/scalar-functions/date-time-functions/years-diff', | |
| 'sql-manual/sql-functions/scalar-functions/date-time-functions/years-sub', | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'GIS Functions', | |
| items: [ | |
| 'sql-manual/sql-functions/scalar-functions/spatial-functions/st-angle', | |
| 'sql-manual/sql-functions/scalar-functions/spatial-functions/st-angle-sphere', | |
| 'sql-manual/sql-functions/scalar-functions/spatial-functions/st-area-square-km', | |
| 'sql-manual/sql-functions/scalar-functions/spatial-functions/st-area-square-meters', | |
| 'sql-manual/sql-functions/scalar-functions/spatial-functions/st-asbinary', | |
| 'sql-manual/sql-functions/scalar-functions/spatial-functions/st-astext', | |
| 'sql-manual/sql-functions/scalar-functions/spatial-functions/st-azimuth', | |
| 'sql-manual/sql-functions/scalar-functions/spatial-functions/st-circle', | |
| 'sql-manual/sql-functions/scalar-functions/spatial-functions/st-contains', | |
| 'sql-manual/sql-functions/scalar-functions/spatial-functions/st-disjoint', | |
| 'sql-manual/sql-functions/scalar-functions/spatial-functions/st-distance', | |
| 'sql-manual/sql-functions/scalar-functions/spatial-functions/st-distance-sphere', | |
| 'sql-manual/sql-functions/scalar-functions/spatial-functions/st-geometryfromtext', | |
| 'sql-manual/sql-functions/scalar-functions/spatial-functions/st-geometryfromwkb', | |
| 'sql-manual/sql-functions/scalar-functions/spatial-functions/st-geometrytype', | |
| 'sql-manual/sql-functions/scalar-functions/spatial-functions/st-intersects', | |
| 'sql-manual/sql-functions/scalar-functions/spatial-functions/st-isclosed', | |
| 'sql-manual/sql-functions/scalar-functions/spatial-functions/st-length', | |
| 'sql-manual/sql-functions/scalar-functions/spatial-functions/st-linefromtext', | |
| 'sql-manual/sql-functions/scalar-functions/spatial-functions/st-point', | |
| 'sql-manual/sql-functions/scalar-functions/spatial-functions/st-polygon', | |
| 'sql-manual/sql-functions/scalar-functions/spatial-functions/st-touches', | |
| 'sql-manual/sql-functions/scalar-functions/spatial-functions/st-within', | |
| 'sql-manual/sql-functions/scalar-functions/spatial-functions/st-x', | |
| 'sql-manual/sql-functions/scalar-functions/spatial-functions/st-y', | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'Encryption Functions', | |
| items: [ | |
| 'sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/aes-decrypt', | |
| 'sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/aes-encrypt', | |
| 'sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/crc32', | |
| 'sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/md5', | |
| 'sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/md5sum', | |
| 'sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/murmur-hash3-32', | |
| 'sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/murmur-hash3-64', | |
| 'sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/murmur-hash3-64-v2', | |
| "sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/murmur-hash3-u64-v2", | |
| 'sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/sha', | |
| 'sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/sha2', | |
| 'sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/sm3', | |
| 'sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/sm3sum', | |
| 'sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/sm4-decrypt', | |
| 'sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/sm4-encrypt', | |
| 'sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/xxhash-32', | |
| 'sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/xxhash-64', | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'Bitwise Functions', | |
| items: [ | |
| 'sql-manual/sql-functions/scalar-functions/bitwise-functions/bit-length', | |
| 'sql-manual/sql-functions/scalar-functions/bitwise-functions/bit-test', | |
| 'sql-manual/sql-functions/scalar-functions/bitwise-functions/bitand', | |
| 'sql-manual/sql-functions/scalar-functions/bitwise-functions/bitcount', | |
| 'sql-manual/sql-functions/scalar-functions/bitwise-functions/bitnot', | |
| 'sql-manual/sql-functions/scalar-functions/bitwise-functions/bitor', | |
| 'sql-manual/sql-functions/scalar-functions/bitwise-functions/bitshiftleft', | |
| 'sql-manual/sql-functions/scalar-functions/bitwise-functions/bitshiftright', | |
| 'sql-manual/sql-functions/scalar-functions/bitwise-functions/xor', | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'Array Functions', | |
| items: [ | |
| 'sql-manual/sql-functions/scalar-functions/array-functions/array', | |
| 'sql-manual/sql-functions/scalar-functions/array-functions/array-apply', | |
| 'sql-manual/sql-functions/scalar-functions/array-functions/array-avg', | |
| 'sql-manual/sql-functions/scalar-functions/array-functions/array-compact', | |
| 'sql-manual/sql-functions/scalar-functions/array-functions/array-concat', | |
| 'sql-manual/sql-functions/scalar-functions/array-functions/array-contains', | |
| 'sql-manual/sql-functions/scalar-functions/array-functions/array-contains_all', | |
| 'sql-manual/sql-functions/scalar-functions/array-functions/array-count', | |
| 'sql-manual/sql-functions/scalar-functions/array-functions/array-cross-product', | |
| 'sql-manual/sql-functions/scalar-functions/array-functions/array-cum-sum', | |
| 'sql-manual/sql-functions/scalar-functions/array-functions/array-difference', | |
| 'sql-manual/sql-functions/scalar-functions/array-functions/array-distinct', | |
| 'sql-manual/sql-functions/scalar-functions/array-functions/array-enumerate', | |
| 'sql-manual/sql-functions/scalar-functions/array-functions/array-enumerate-uniq', | |
| 'sql-manual/sql-functions/scalar-functions/array-functions/array-except', | |
| 'sql-manual/sql-functions/scalar-functions/array-functions/array-except-all', | |
| 'sql-manual/sql-functions/scalar-functions/array-functions/array-exists', | |
| 'sql-manual/sql-functions/scalar-functions/array-functions/array-filter', | |
| 'sql-manual/sql-functions/scalar-functions/array-functions/array-first', | |
| 'sql-manual/sql-functions/scalar-functions/array-functions/array-first-index', | |
| 'sql-manual/sql-functions/scalar-functions/array-functions/array-flatten', | |
| 'sql-manual/sql-functions/scalar-functions/array-functions/array-intersect', | |
| 'sql-manual/sql-functions/scalar-functions/array-functions/array-join', | |
| 'sql-manual/sql-functions/scalar-functions/array-functions/array-last', | |
| 'sql-manual/sql-functions/scalar-functions/array-functions/array-last-index', | |
| 'sql-manual/sql-functions/scalar-functions/array-functions/array-map', | |
| 'sql-manual/sql-functions/scalar-functions/array-functions/array-match-all', | |
| 'sql-manual/sql-functions/scalar-functions/array-functions/array-match-any', | |
| 'sql-manual/sql-functions/scalar-functions/array-functions/array-max', | |
| 'sql-manual/sql-functions/scalar-functions/array-functions/array-min', | |
| 'sql-manual/sql-functions/scalar-functions/array-functions/array-popback', | |
| 'sql-manual/sql-functions/scalar-functions/array-functions/array-popfront', | |
| 'sql-manual/sql-functions/scalar-functions/array-functions/array-position', | |
| 'sql-manual/sql-functions/scalar-functions/array-functions/array-product', | |
| 'sql-manual/sql-functions/scalar-functions/array-functions/array-pushback', | |
| 'sql-manual/sql-functions/scalar-functions/array-functions/array-pushfront', | |
| 'sql-manual/sql-functions/scalar-functions/array-functions/array-range', | |
| 'sql-manual/sql-functions/scalar-functions/array-functions/array-remove', | |
| 'sql-manual/sql-functions/scalar-functions/array-functions/array-repeat', | |
| 'sql-manual/sql-functions/scalar-functions/array-functions/array-reverse-sort', | |
| 'sql-manual/sql-functions/scalar-functions/array-functions/array-reverse-split', | |
| 'sql-manual/sql-functions/scalar-functions/array-functions/array-shuffle', | |
| 'sql-manual/sql-functions/scalar-functions/array-functions/array-size', | |
| 'sql-manual/sql-functions/scalar-functions/array-functions/array-slice', | |
| 'sql-manual/sql-functions/scalar-functions/array-functions/array-sort', | |
| 'sql-manual/sql-functions/scalar-functions/array-functions/array-sortby', | |
| 'sql-manual/sql-functions/scalar-functions/array-functions/array-split', | |
| 'sql-manual/sql-functions/scalar-functions/array-functions/array-sum', | |
| 'sql-manual/sql-functions/scalar-functions/array-functions/array-union', | |
| 'sql-manual/sql-functions/scalar-functions/array-functions/array-with-constant', | |
| 'sql-manual/sql-functions/scalar-functions/array-functions/array-zip', | |
| 'sql-manual/sql-functions/scalar-functions/array-functions/arrays-overlap', | |
| 'sql-manual/sql-functions/scalar-functions/array-functions/countequal', | |
| 'sql-manual/sql-functions/scalar-functions/array-functions/trim-array', | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'MAP Functions', | |
| items: [ | |
| 'sql-manual/sql-functions/scalar-functions/map-functions/deduplicate-map', | |
| 'sql-manual/sql-functions/scalar-functions/map-functions/map', | |
| 'sql-manual/sql-functions/scalar-functions/map-functions/map-all', | |
| 'sql-manual/sql-functions/scalar-functions/map-functions/map-apply', | |
| 'sql-manual/sql-functions/scalar-functions/map-functions/map-contains-entry', | |
| 'sql-manual/sql-functions/scalar-functions/map-functions/map-contains-key', | |
| 'sql-manual/sql-functions/scalar-functions/map-functions/map-contains-value', | |
| 'sql-manual/sql-functions/scalar-functions/map-functions/map-entries', | |
| "sql-manual/sql-functions/scalar-functions/map-functions/map-exists", | |
| 'sql-manual/sql-functions/scalar-functions/map-functions/map-filter', | |
| 'sql-manual/sql-functions/scalar-functions/map-functions/map-from-arrays', | |
| 'sql-manual/sql-functions/scalar-functions/map-functions/map-from-entries', | |
| 'sql-manual/sql-functions/scalar-functions/map-functions/map-keys', | |
| 'sql-manual/sql-functions/scalar-functions/map-functions/map-size', | |
| 'sql-manual/sql-functions/scalar-functions/map-functions/map-values', | |
| 'sql-manual/sql-functions/scalar-functions/map-functions/str-to-map', | |
| 'sql-manual/sql-functions/scalar-functions/map-functions/transform-keys', | |
| 'sql-manual/sql-functions/scalar-functions/map-functions/transform-values', | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'Struct Functions', | |
| items: [ | |
| 'sql-manual/sql-functions/scalar-functions/struct-functions/named-struct', | |
| 'sql-manual/sql-functions/scalar-functions/struct-functions/struct', | |
| 'sql-manual/sql-functions/scalar-functions/struct-functions/struct-element', | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'JSON Functions', | |
| items: [ | |
| 'sql-manual/sql-functions/scalar-functions/json-functions/get-json-bigint', | |
| 'sql-manual/sql-functions/scalar-functions/json-functions/get-json-double', | |
| 'sql-manual/sql-functions/scalar-functions/json-functions/get-json-int', | |
| 'sql-manual/sql-functions/scalar-functions/json-functions/get-json-string', | |
| 'sql-manual/sql-functions/scalar-functions/json-functions/json-array', | |
| 'sql-manual/sql-functions/scalar-functions/json-functions/json-array-ignore-null', | |
| 'sql-manual/sql-functions/scalar-functions/json-functions/json-contains', | |
| 'sql-manual/sql-functions/scalar-functions/json-functions/json-exists-path', | |
| 'sql-manual/sql-functions/scalar-functions/json-functions/json-extract', | |
| 'sql-manual/sql-functions/scalar-functions/json-functions/json-extract-bigint', | |
| 'sql-manual/sql-functions/scalar-functions/json-functions/json-extract-bool', | |
| 'sql-manual/sql-functions/scalar-functions/json-functions/json-extract-double', | |
| 'sql-manual/sql-functions/scalar-functions/json-functions/json-extract-int', | |
| 'sql-manual/sql-functions/scalar-functions/json-functions/json-extract-isnull', | |
| 'sql-manual/sql-functions/scalar-functions/json-functions/json-extract-largeint', | |
| 'sql-manual/sql-functions/scalar-functions/json-functions/json-extract-string', | |
| 'sql-manual/sql-functions/scalar-functions/json-functions/json-hash', | |
| 'sql-manual/sql-functions/scalar-functions/json-functions/json-insert', | |
| 'sql-manual/sql-functions/scalar-functions/json-functions/json-keys', | |
| 'sql-manual/sql-functions/scalar-functions/json-functions/json-length', | |
| 'sql-manual/sql-functions/scalar-functions/json-functions/json-object', | |
| 'sql-manual/sql-functions/scalar-functions/json-functions/json-object-flatten', | |
| 'sql-manual/sql-functions/scalar-functions/json-functions/json-parse', | |
| 'sql-manual/sql-functions/scalar-functions/json-functions/json-parse-error-to-null', | |
| 'sql-manual/sql-functions/scalar-functions/json-functions/json-parse-error-to-value', | |
| 'sql-manual/sql-functions/scalar-functions/json-functions/json-quote', | |
| 'sql-manual/sql-functions/scalar-functions/json-functions/json-replace', | |
| 'sql-manual/sql-functions/scalar-functions/json-functions/json-remove', | |
| 'sql-manual/sql-functions/scalar-functions/json-functions/json-search', | |
| 'sql-manual/sql-functions/scalar-functions/json-functions/json-set', | |
| 'sql-manual/sql-functions/scalar-functions/json-functions/json-type', | |
| 'sql-manual/sql-functions/scalar-functions/json-functions/json-unquote', | |
| 'sql-manual/sql-functions/scalar-functions/json-functions/json-valid', | |
| 'sql-manual/sql-functions/scalar-functions/json-functions/normalize-json-numbers-to-double', | |
| 'sql-manual/sql-functions/scalar-functions/json-functions/sort-json-object-keys', | |
| 'sql-manual/sql-functions/scalar-functions/json-functions/strip-null-value', | |
| 'sql-manual/sql-functions/scalar-functions/json-functions/to-json', | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'Variant Functions', | |
| items: [ | |
| 'sql-manual/sql-functions/scalar-functions/variant-functions/element-at', | |
| 'sql-manual/sql-functions/scalar-functions/variant-functions/parse-to-variant', | |
| 'sql-manual/sql-functions/scalar-functions/variant-functions/try-parse-to-variant', | |
| 'sql-manual/sql-functions/scalar-functions/variant-functions/variant-type', | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'IP Functions', | |
| items: [ | |
| 'sql-manual/sql-functions/scalar-functions/ip-functions/cut-ipv6', | |
| 'sql-manual/sql-functions/scalar-functions/ip-functions/ipv4-cidr-to-range', | |
| 'sql-manual/sql-functions/scalar-functions/ip-functions/ipv4-num-to-string', | |
| 'sql-manual/sql-functions/scalar-functions/ip-functions/ipv4-string-to-num', | |
| 'sql-manual/sql-functions/scalar-functions/ip-functions/ipv4-string-to-num-or-default', | |
| 'sql-manual/sql-functions/scalar-functions/ip-functions/ipv4-string-to-num-or-null', | |
| 'sql-manual/sql-functions/scalar-functions/ip-functions/ipv4-to-ipv6', | |
| 'sql-manual/sql-functions/scalar-functions/ip-functions/ipv6-cidr-to-range', | |
| 'sql-manual/sql-functions/scalar-functions/ip-functions/ipv6-num-to-string', | |
| 'sql-manual/sql-functions/scalar-functions/ip-functions/ipv6-string-to-num', | |
| 'sql-manual/sql-functions/scalar-functions/ip-functions/ipv6-string-to-num-or-default', | |
| 'sql-manual/sql-functions/scalar-functions/ip-functions/ipv6-string-to-num-or-null', | |
| 'sql-manual/sql-functions/scalar-functions/ip-functions/is-ip-address-in-range', | |
| 'sql-manual/sql-functions/scalar-functions/ip-functions/is-ipv4-compat', | |
| 'sql-manual/sql-functions/scalar-functions/ip-functions/is-ipv4-mapped', | |
| 'sql-manual/sql-functions/scalar-functions/ip-functions/is-ipv4-string', | |
| 'sql-manual/sql-functions/scalar-functions/ip-functions/is-ipv6-string', | |
| 'sql-manual/sql-functions/scalar-functions/ip-functions/to-ipv4', | |
| 'sql-manual/sql-functions/scalar-functions/ip-functions/to-ipv4-or-default', | |
| 'sql-manual/sql-functions/scalar-functions/ip-functions/to-ipv4-or-null', | |
| 'sql-manual/sql-functions/scalar-functions/ip-functions/to-ipv6', | |
| 'sql-manual/sql-functions/scalar-functions/ip-functions/to-ipv6-or-default', | |
| 'sql-manual/sql-functions/scalar-functions/ip-functions/to-ipv6-or-null', | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'Bitmap Functions', | |
| items: [ | |
| 'sql-manual/sql-functions/scalar-functions/bitmap-functions/bitmap-and', | |
| 'sql-manual/sql-functions/scalar-functions/bitmap-functions/bitmap-and-count', | |
| 'sql-manual/sql-functions/scalar-functions/bitmap-functions/bitmap-and-not', | |
| 'sql-manual/sql-functions/scalar-functions/bitmap-functions/bitmap-and-not-count', | |
| 'sql-manual/sql-functions/scalar-functions/bitmap-functions/bitmap-contains', | |
| 'sql-manual/sql-functions/scalar-functions/bitmap-functions/bitmap-count', | |
| 'sql-manual/sql-functions/scalar-functions/bitmap-functions/bitmap-empty', | |
| 'sql-manual/sql-functions/scalar-functions/bitmap-functions/bitmap-from-array', | |
| 'sql-manual/sql-functions/scalar-functions/bitmap-functions/bitmap-from-base64', | |
| 'sql-manual/sql-functions/scalar-functions/bitmap-functions/bitmap-from-string', | |
| 'sql-manual/sql-functions/scalar-functions/bitmap-functions/bitmap-has-all', | |
| 'sql-manual/sql-functions/scalar-functions/bitmap-functions/bitmap-has-any', | |
| 'sql-manual/sql-functions/scalar-functions/bitmap-functions/bitmap-hash', | |
| 'sql-manual/sql-functions/scalar-functions/bitmap-functions/bitmap-hash64', | |
| 'sql-manual/sql-functions/scalar-functions/bitmap-functions/bitmap-max', | |
| 'sql-manual/sql-functions/scalar-functions/bitmap-functions/bitmap-min', | |
| 'sql-manual/sql-functions/scalar-functions/bitmap-functions/bitmap-not', | |
| 'sql-manual/sql-functions/scalar-functions/bitmap-functions/bitmap-or', | |
| 'sql-manual/sql-functions/scalar-functions/bitmap-functions/bitmap-or-count', | |
| 'sql-manual/sql-functions/scalar-functions/bitmap-functions/bitmap-remove', | |
| 'sql-manual/sql-functions/scalar-functions/bitmap-functions/bitmap-subset-in-range', | |
| 'sql-manual/sql-functions/scalar-functions/bitmap-functions/bitmap-subset-limit', | |
| 'sql-manual/sql-functions/scalar-functions/bitmap-functions/bitmap-to-array', | |
| 'sql-manual/sql-functions/scalar-functions/bitmap-functions/bitmap-to-base64', | |
| 'sql-manual/sql-functions/scalar-functions/bitmap-functions/bitmap-to-string', | |
| 'sql-manual/sql-functions/scalar-functions/bitmap-functions/bitmap-xor', | |
| 'sql-manual/sql-functions/scalar-functions/bitmap-functions/bitmap-xor-count', | |
| 'sql-manual/sql-functions/scalar-functions/bitmap-functions/sub-bitmap', | |
| 'sql-manual/sql-functions/scalar-functions/bitmap-functions/to-bitmap', | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'HLL Functions', | |
| items: [ | |
| 'sql-manual/sql-functions/scalar-functions/hll-functions/hll-cardinality', | |
| 'sql-manual/sql-functions/scalar-functions/hll-functions/hll-empty', | |
| 'sql-manual/sql-functions/scalar-functions/hll-functions/hll-from-base64', | |
| 'sql-manual/sql-functions/scalar-functions/hll-functions/hll-hash', | |
| 'sql-manual/sql-functions/scalar-functions/hll-functions/hll-to-base64', | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'Binary Functions', | |
| items: [ | |
| 'sql-manual/sql-functions/scalar-functions/binary-functions/from-base64-binary', | |
| 'sql-manual/sql-functions/scalar-functions/binary-functions/from_hex', | |
| 'sql-manual/sql-functions/scalar-functions/binary-functions/sub-binary', | |
| 'sql-manual/sql-functions/scalar-functions/binary-functions/to-base64-binary', | |
| 'sql-manual/sql-functions/scalar-functions/binary-functions/to_hex', | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'System Functions', | |
| items: [ | |
| 'sql-manual/sql-functions/scalar-functions/system-functions/connection-id', | |
| 'sql-manual/sql-functions/scalar-functions/system-functions/current-catalog', | |
| 'sql-manual/sql-functions/scalar-functions/system-functions/current-user', | |
| 'sql-manual/sql-functions/scalar-functions/system-functions/database', | |
| 'sql-manual/sql-functions/scalar-functions/system-functions/session-user', | |
| 'sql-manual/sql-functions/scalar-functions/system-functions/user', | |
| 'sql-manual/sql-functions/scalar-functions/system-functions/version-function', | |
| 'sql-manual/sql-functions/scalar-functions/system-functions/last-query-id', | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'Other Functions', | |
| items: [ | |
| 'sql-manual/sql-functions/scalar-functions/other-functions/convert-to', | |
| 'sql-manual/sql-functions/scalar-functions/other-functions/esquery', | |
| 'sql-manual/sql-functions/scalar-functions/other-functions/default', | |
| 'sql-manual/sql-functions/scalar-functions/other-functions/field', | |
| 'sql-manual/sql-functions/scalar-functions/other-functions/g', | |
| 'sql-manual/sql-functions/scalar-functions/other-functions/grouping', | |
| 'sql-manual/sql-functions/scalar-functions/other-functions/grouping-id', | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'Quantile Functions', | |
| items: [ | |
| 'sql-manual/sql-functions/scalar-functions/quantile-functions/quantile-percent', | |
| 'sql-manual/sql-functions/scalar-functions/quantile-functions/quantile-state-empty', | |
| 'sql-manual/sql-functions/scalar-functions/quantile-functions/to-quantile-state', | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'Conditional Functions', | |
| items: [ | |
| 'sql-manual/sql-functions/scalar-functions/conditional-functions/overview', | |
| 'sql-manual/sql-functions/scalar-functions/conditional-functions/coalesce', | |
| 'sql-manual/sql-functions/scalar-functions/conditional-functions/greatest', | |
| 'sql-manual/sql-functions/scalar-functions/conditional-functions/if', | |
| 'sql-manual/sql-functions/scalar-functions/conditional-functions/ifnull', | |
| 'sql-manual/sql-functions/scalar-functions/conditional-functions/least', | |
| 'sql-manual/sql-functions/scalar-functions/conditional-functions/not-null-or-empty', | |
| 'sql-manual/sql-functions/scalar-functions/conditional-functions/null-or-empty', | |
| 'sql-manual/sql-functions/scalar-functions/conditional-functions/nullif', | |
| ], | |
| }, | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'Aggregate Functions', | |
| items: [ | |
| 'sql-manual/sql-functions/aggregate-functions/ai-agg', | |
| 'sql-manual/sql-functions/aggregate-functions/any-value', | |
| 'sql-manual/sql-functions/aggregate-functions/approx-count-distinct', | |
| 'sql-manual/sql-functions/aggregate-functions/array-agg', | |
| 'sql-manual/sql-functions/aggregate-functions/avg', | |
| 'sql-manual/sql-functions/aggregate-functions/avg-map', | |
| 'sql-manual/sql-functions/aggregate-functions/avg-weighted', | |
| 'sql-manual/sql-functions/aggregate-functions/bitmap-agg', | |
| 'sql-manual/sql-functions/aggregate-functions/bitmap-intersect', | |
| 'sql-manual/sql-functions/aggregate-functions/bitmap-union', | |
| 'sql-manual/sql-functions/aggregate-functions/bitmap-union-count', | |
| 'sql-manual/sql-functions/aggregate-functions/bitmap-union-int', | |
| 'sql-manual/sql-functions/aggregate-functions/bool-and', | |
| 'sql-manual/sql-functions/aggregate-functions/bool-or', | |
| 'sql-manual/sql-functions/aggregate-functions/bool-xor', | |
| 'sql-manual/sql-functions/aggregate-functions/collect-list', | |
| 'sql-manual/sql-functions/aggregate-functions/collect-set', | |
| 'sql-manual/sql-functions/aggregate-functions/corr-welford', | |
| 'sql-manual/sql-functions/aggregate-functions/corr', | |
| 'sql-manual/sql-functions/aggregate-functions/count', | |
| 'sql-manual/sql-functions/aggregate-functions/count-by-enum', | |
| 'sql-manual/sql-functions/aggregate-functions/count-map', | |
| 'sql-manual/sql-functions/aggregate-functions/covar', | |
| 'sql-manual/sql-functions/aggregate-functions/covar-samp', | |
| 'sql-manual/sql-functions/aggregate-functions/datasketches_hll_union_agg', | |
| 'sql-manual/sql-functions/aggregate-functions/exponential-moving-average', | |
| 'sql-manual/sql-functions/aggregate-functions/group-array-intersect', | |
| 'sql-manual/sql-functions/aggregate-functions/group-array-union', | |
| 'sql-manual/sql-functions/aggregate-functions/group-bit-and', | |
| 'sql-manual/sql-functions/aggregate-functions/group-bit-or', | |
| 'sql-manual/sql-functions/aggregate-functions/group-bit-xor', | |
| 'sql-manual/sql-functions/aggregate-functions/group-bitmap-xor', | |
| 'sql-manual/sql-functions/aggregate-functions/group-concat', | |
| 'sql-manual/sql-functions/aggregate-functions/histogram', | |
| 'sql-manual/sql-functions/aggregate-functions/hll-raw-agg', | |
| 'sql-manual/sql-functions/aggregate-functions/hll-union-agg', | |
| 'sql-manual/sql-functions/aggregate-functions/intersect-count', | |
| 'sql-manual/sql-functions/aggregate-functions/kurt', | |
| 'sql-manual/sql-functions/aggregate-functions/linear-histogram', | |
| 'sql-manual/sql-functions/aggregate-functions/map-agg', | |
| 'sql-manual/sql-functions/aggregate-functions/max', | |
| 'sql-manual/sql-functions/aggregate-functions/max-by', | |
| 'sql-manual/sql-functions/aggregate-functions/max-map', | |
| 'sql-manual/sql-functions/aggregate-functions/median', | |
| 'sql-manual/sql-functions/aggregate-functions/min', | |
| 'sql-manual/sql-functions/aggregate-functions/min-by', | |
| 'sql-manual/sql-functions/aggregate-functions/min-map', | |
| 'sql-manual/sql-functions/aggregate-functions/percentile', | |
| 'sql-manual/sql-functions/aggregate-functions/percentile-approx', | |
| 'sql-manual/sql-functions/aggregate-functions/percentile-approx-array', | |
| 'sql-manual/sql-functions/aggregate-functions/percentile-array', | |
| 'sql-manual/sql-functions/aggregate-functions/percentile-approx-weighted', | |
| 'sql-manual/sql-functions/aggregate-functions/percentile_reservoir', | |
| 'sql-manual/sql-functions/aggregate-functions/quantile-union', | |
| 'sql-manual/sql-functions/aggregate-functions/regr-avgx', | |
| 'sql-manual/sql-functions/aggregate-functions/regr-avgy', | |
| 'sql-manual/sql-functions/aggregate-functions/regr-count', | |
| 'sql-manual/sql-functions/aggregate-functions/regr-intercept', | |
| 'sql-manual/sql-functions/aggregate-functions/regr-r2', | |
| 'sql-manual/sql-functions/aggregate-functions/regr-slope', | |
| 'sql-manual/sql-functions/aggregate-functions/regr-sxx', | |
| 'sql-manual/sql-functions/aggregate-functions/regr-sxy', | |
| 'sql-manual/sql-functions/aggregate-functions/regr-syy', | |
| 'sql-manual/sql-functions/aggregate-functions/retention', | |
| 'sql-manual/sql-functions/aggregate-functions/sem', | |
| 'sql-manual/sql-functions/aggregate-functions/sequence-count', | |
| 'sql-manual/sql-functions/aggregate-functions/sequence-match', | |
| 'sql-manual/sql-functions/aggregate-functions/skew', | |
| 'sql-manual/sql-functions/aggregate-functions/stddev', | |
| 'sql-manual/sql-functions/aggregate-functions/stddev-samp', | |
| 'sql-manual/sql-functions/aggregate-functions/sum', | |
| 'sql-manual/sql-functions/aggregate-functions/sum0', | |
| 'sql-manual/sql-functions/aggregate-functions/sum-map', | |
| 'sql-manual/sql-functions/aggregate-functions/topn', | |
| 'sql-manual/sql-functions/aggregate-functions/topn-array', | |
| 'sql-manual/sql-functions/aggregate-functions/topn-weighted', | |
| 'sql-manual/sql-functions/aggregate-functions/var-samp', | |
| 'sql-manual/sql-functions/aggregate-functions/variance', | |
| 'sql-manual/sql-functions/aggregate-functions/window-funnel', | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'Combinators', | |
| items: [ | |
| 'sql-manual/sql-functions/combinators/foreach', | |
| 'sql-manual/sql-functions/combinators/merge', | |
| 'sql-manual/sql-functions/combinators/state', | |
| 'sql-manual/sql-functions/combinators/union', | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'Analytic (Window) Functions', | |
| items: [ | |
| 'sql-manual/sql-functions/window-functions/overview', | |
| 'sql-manual/sql-functions/window-functions/cume-dist', | |
| 'sql-manual/sql-functions/window-functions/dense-rank', | |
| 'sql-manual/sql-functions/window-functions/first-value', | |
| 'sql-manual/sql-functions/window-functions/lag', | |
| 'sql-manual/sql-functions/window-functions/last-value', | |
| 'sql-manual/sql-functions/window-functions/lead', | |
| 'sql-manual/sql-functions/window-functions/ntile', | |
| 'sql-manual/sql-functions/window-functions/percent-rank', | |
| 'sql-manual/sql-functions/window-functions/rank', | |
| 'sql-manual/sql-functions/window-functions/row-number', | |
| 'sql-manual/sql-functions/aggregate-functions/any-value', | |
| 'sql-manual/sql-functions/aggregate-functions/approx-count-distinct', | |
| 'sql-manual/sql-functions/aggregate-functions/array-agg', | |
| 'sql-manual/sql-functions/aggregate-functions/avg', | |
| 'sql-manual/sql-functions/aggregate-functions/avg-weighted', | |
| 'sql-manual/sql-functions/aggregate-functions/bitmap-agg', | |
| 'sql-manual/sql-functions/aggregate-functions/bitmap-intersect', | |
| 'sql-manual/sql-functions/aggregate-functions/bitmap-union', | |
| 'sql-manual/sql-functions/aggregate-functions/bitmap-union-count', | |
| 'sql-manual/sql-functions/aggregate-functions/bitmap-union-int', | |
| 'sql-manual/sql-functions/aggregate-functions/bool-and', | |
| 'sql-manual/sql-functions/aggregate-functions/bool-or', | |
| 'sql-manual/sql-functions/aggregate-functions/bool-xor', | |
| 'sql-manual/sql-functions/aggregate-functions/collect-list', | |
| 'sql-manual/sql-functions/aggregate-functions/collect-set', | |
| 'sql-manual/sql-functions/aggregate-functions/corr-welford', | |
| 'sql-manual/sql-functions/aggregate-functions/corr', | |
| 'sql-manual/sql-functions/aggregate-functions/count', | |
| 'sql-manual/sql-functions/aggregate-functions/count-by-enum', | |
| 'sql-manual/sql-functions/aggregate-functions/covar', | |
| 'sql-manual/sql-functions/aggregate-functions/covar-samp', | |
| 'sql-manual/sql-functions/aggregate-functions/exponential-moving-average', | |
| 'sql-manual/sql-functions/aggregate-functions/group-array-intersect', | |
| 'sql-manual/sql-functions/aggregate-functions/group-array-union', | |
| 'sql-manual/sql-functions/aggregate-functions/group-bit-and', | |
| 'sql-manual/sql-functions/aggregate-functions/group-bit-or', | |
| 'sql-manual/sql-functions/aggregate-functions/group-bit-xor', | |
| 'sql-manual/sql-functions/aggregate-functions/group-bitmap-xor', | |
| 'sql-manual/sql-functions/aggregate-functions/group-concat', | |
| 'sql-manual/sql-functions/aggregate-functions/histogram', | |
| 'sql-manual/sql-functions/aggregate-functions/hll-raw-agg', | |
| 'sql-manual/sql-functions/aggregate-functions/hll-union-agg', | |
| 'sql-manual/sql-functions/aggregate-functions/intersect-count', | |
| 'sql-manual/sql-functions/aggregate-functions/kurt', | |
| 'sql-manual/sql-functions/aggregate-functions/linear-histogram', | |
| 'sql-manual/sql-functions/aggregate-functions/map-agg', | |
| 'sql-manual/sql-functions/aggregate-functions/max', | |
| 'sql-manual/sql-functions/aggregate-functions/max-by', | |
| 'sql-manual/sql-functions/aggregate-functions/median', | |
| 'sql-manual/sql-functions/aggregate-functions/min', | |
| 'sql-manual/sql-functions/aggregate-functions/min-by', | |
| 'sql-manual/sql-functions/aggregate-functions/percentile', | |
| 'sql-manual/sql-functions/aggregate-functions/percentile-approx', | |
| 'sql-manual/sql-functions/aggregate-functions/percentile-approx-array', | |
| 'sql-manual/sql-functions/aggregate-functions/percentile-array', | |
| 'sql-manual/sql-functions/aggregate-functions/percentile-approx-weighted', | |
| 'sql-manual/sql-functions/aggregate-functions/quantile-union', | |
| 'sql-manual/sql-functions/aggregate-functions/regr-avgx', | |
| 'sql-manual/sql-functions/aggregate-functions/regr-avgy', | |
| 'sql-manual/sql-functions/aggregate-functions/regr-count', | |
| 'sql-manual/sql-functions/aggregate-functions/regr-intercept', | |
| 'sql-manual/sql-functions/aggregate-functions/regr-r2', | |
| 'sql-manual/sql-functions/aggregate-functions/regr-slope', | |
| 'sql-manual/sql-functions/aggregate-functions/regr-sxx', | |
| 'sql-manual/sql-functions/aggregate-functions/regr-sxy', | |
| 'sql-manual/sql-functions/aggregate-functions/regr-syy', | |
| 'sql-manual/sql-functions/aggregate-functions/retention', | |
| 'sql-manual/sql-functions/aggregate-functions/sequence-count', | |
| 'sql-manual/sql-functions/aggregate-functions/sequence-match', | |
| 'sql-manual/sql-functions/aggregate-functions/skew', | |
| 'sql-manual/sql-functions/aggregate-functions/stddev', | |
| 'sql-manual/sql-functions/aggregate-functions/stddev-samp', | |
| 'sql-manual/sql-functions/aggregate-functions/sum', | |
| 'sql-manual/sql-functions/aggregate-functions/sum0', | |
| 'sql-manual/sql-functions/aggregate-functions/topn', | |
| 'sql-manual/sql-functions/aggregate-functions/topn-array', | |
| 'sql-manual/sql-functions/aggregate-functions/topn-weighted', | |
| 'sql-manual/sql-functions/aggregate-functions/var-samp', | |
| 'sql-manual/sql-functions/aggregate-functions/variance', | |
| 'sql-manual/sql-functions/aggregate-functions/window-funnel', | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'Table Functions', | |
| items: [ | |
| 'sql-manual/sql-functions/table-functions/explode', | |
| 'sql-manual/sql-functions/table-functions/explode-outer', | |
| 'sql-manual/sql-functions/table-functions/explode-bitmap', | |
| 'sql-manual/sql-functions/table-functions/explode-bitmap-outer', | |
| 'sql-manual/sql-functions/table-functions/explode-json-array-double', | |
| 'sql-manual/sql-functions/table-functions/explode-json-array-double-outer', | |
| 'sql-manual/sql-functions/table-functions/explode-json-array-int', | |
| 'sql-manual/sql-functions/table-functions/explode-json-array-int-outer', | |
| 'sql-manual/sql-functions/table-functions/explode-json-array-json', | |
| 'sql-manual/sql-functions/table-functions/explode-json-array-json-outer', | |
| 'sql-manual/sql-functions/table-functions/explode-json-array-string', | |
| 'sql-manual/sql-functions/table-functions/explode-json-array-string-outer', | |
| 'sql-manual/sql-functions/table-functions/explode-json-object', | |
| 'sql-manual/sql-functions/table-functions/explode-map', | |
| 'sql-manual/sql-functions/table-functions/explode-map-outer', | |
| 'sql-manual/sql-functions/table-functions/explode-numbers', | |
| 'sql-manual/sql-functions/table-functions/explode-numbers-outer', | |
| 'sql-manual/sql-functions/table-functions/explode-split', | |
| 'sql-manual/sql-functions/table-functions/explode-split-outer', | |
| 'sql-manual/sql-functions/table-functions/json-each', | |
| 'sql-manual/sql-functions/table-functions/json-each-outer', | |
| 'sql-manual/sql-functions/table-functions/json-each-text', | |
| 'sql-manual/sql-functions/table-functions/json-each-text-outer', | |
| 'sql-manual/sql-functions/table-functions/posexplode', | |
| 'sql-manual/sql-functions/table-functions/posexplode-outer', | |
| 'sql-manual/sql-functions/table-functions/stack', | |
| 'sql-manual/sql-functions/table-functions/unnest', | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'Table Valued Functions', | |
| items: [ | |
| 'sql-manual/sql-functions/table-valued-functions/backends', | |
| 'sql-manual/sql-functions/table-valued-functions/cdc-stream', | |
| 'sql-manual/sql-functions/table-valued-functions/catalogs', | |
| 'sql-manual/sql-functions/table-valued-functions/changelog', | |
| 'sql-manual/sql-functions/table-valued-functions/file', | |
| 'sql-manual/sql-functions/table-valued-functions/frontends', | |
| 'sql-manual/sql-functions/table-valued-functions/frontends_disks', | |
| 'sql-manual/sql-functions/table-valued-functions/hdfs', | |
| 'sql-manual/sql-functions/table-valued-functions/http', | |
| 'sql-manual/sql-functions/table-valued-functions/hudi-meta', | |
| 'sql-manual/sql-functions/table-valued-functions/iceberg-meta', | |
| 'sql-manual/sql-functions/table-valued-functions/jobs', | |
| 'sql-manual/sql-functions/table-valued-functions/lance-index-entries', | |
| 'sql-manual/sql-functions/table-valued-functions/local', | |
| 'sql-manual/sql-functions/table-valued-functions/mv_infos', | |
| 'sql-manual/sql-functions/table-valued-functions/numbers', | |
| 'sql-manual/sql-functions/table-valued-functions/parquet-meta', | |
| 'sql-manual/sql-functions/table-valued-functions/partition-values', | |
| 'sql-manual/sql-functions/table-valued-functions/partitions', | |
| 'sql-manual/sql-functions/table-valued-functions/query', | |
| 'sql-manual/sql-functions/table-valued-functions/s3', | |
| 'sql-manual/sql-functions/table-valued-functions/tasks', | |
| ], | |
| }, | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'SQL Statements', | |
| items: [ | |
| { | |
| type: 'category', | |
| label: 'Data Queries', | |
| items: [ | |
| 'sql-manual/sql-statements/data-query/SELECT', | |
| 'sql-manual/sql-statements/data-query/EXPLAIN', | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'Data Modification', | |
| items: [ | |
| { | |
| type: 'category', | |
| label: 'DML', | |
| items: [ | |
| 'sql-manual/sql-statements/data-modification/DML/INSERT', | |
| 'sql-manual/sql-statements/data-modification/DML/INSERT-OVERWRITE', | |
| 'sql-manual/sql-statements/data-modification/DML/SHOW-LAST-INSERT', | |
| 'sql-manual/sql-statements/data-modification/DML/UPDATE', | |
| 'sql-manual/sql-statements/data-modification/DML/MERGE-INTO', | |
| 'sql-manual/sql-statements/data-modification/DML/DELETE', | |
| 'sql-manual/sql-statements/data-modification/DML/SHOW-DELETE', | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'Load and Export', | |
| items: [ | |
| 'sql-manual/sql-statements/data-modification/load-and-export/BROKER-LOAD', | |
| 'sql-manual/sql-statements/data-modification/load-and-export/MYSQL-LOAD', | |
| 'sql-manual/sql-statements/data-modification/load-and-export/SHOW-LOAD', | |
| 'sql-manual/sql-statements/data-modification/load-and-export/SHOW-STREAM-LOAD', | |
| 'sql-manual/sql-statements/data-modification/load-and-export/SHOW-CREATE-LOAD', | |
| 'sql-manual/sql-statements/data-modification/load-and-export/CANCEL-LOAD', | |
| 'sql-manual/sql-statements/data-modification/load-and-export/SHOW-LOAD-WARNINGS', | |
| 'sql-manual/sql-statements/data-modification/load-and-export/CREATE-ROUTINE-LOAD', | |
| 'sql-manual/sql-statements/data-modification/load-and-export/ALTER-ROUTINE-LOAD', | |
| 'sql-manual/sql-statements/data-modification/load-and-export/PAUSE-ROUTINE-LOAD', | |
| 'sql-manual/sql-statements/data-modification/load-and-export/RESUME-ROUTINE-LOAD', | |
| 'sql-manual/sql-statements/data-modification/load-and-export/STOP-ROUTINE-LOAD', | |
| 'sql-manual/sql-statements/data-modification/load-and-export/SHOW-ROUTINE-LOAD', | |
| 'sql-manual/sql-statements/data-modification/load-and-export/SHOW-ROUTINE-LOAD-TASK', | |
| 'sql-manual/sql-statements/data-modification/load-and-export/SHOW-CREATE-ROUTINE-LOAD', | |
| 'sql-manual/sql-statements/data-modification/load-and-export/SYNC', | |
| 'sql-manual/sql-statements/data-modification/load-and-export/EXPORT', | |
| 'sql-manual/sql-statements/data-modification/load-and-export/CANCEL-EXPORT', | |
| 'sql-manual/sql-statements/data-modification/load-and-export/SHOW-EXPORT', | |
| 'sql-manual/sql-statements/data-modification/load-and-export/OUTFILE', | |
| 'sql-manual/sql-statements/data-modification/load-and-export/CLEAN-LABEL', | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'Backup and Restore', | |
| items: [ | |
| 'sql-manual/sql-statements/data-modification/backup-and-restore/CREATE-REPOSITORY', | |
| 'sql-manual/sql-statements/data-modification/backup-and-restore/DROP-REPOSITORY', | |
| 'sql-manual/sql-statements/data-modification/backup-and-restore/SHOW-CREATE-REPOSITORY', | |
| 'sql-manual/sql-statements/data-modification/backup-and-restore/SHOW-REPOSITORIES', | |
| 'sql-manual/sql-statements/data-modification/backup-and-restore/BACKUP', | |
| 'sql-manual/sql-statements/data-modification/backup-and-restore/CANCEL-BACKUP', | |
| 'sql-manual/sql-statements/data-modification/backup-and-restore/RESTORE', | |
| 'sql-manual/sql-statements/data-modification/backup-and-restore/SHOW-RESTORE', | |
| 'sql-manual/sql-statements/data-modification/backup-and-restore/CANCEL-RESTORE', | |
| 'sql-manual/sql-statements/data-modification/backup-and-restore/SHOW-SNAPSHOT', | |
| ], | |
| }, | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'Account Management', | |
| items: [ | |
| 'sql-manual/sql-statements/account-management/CREATE-USER', | |
| 'sql-manual/sql-statements/account-management/ALTER-USER', | |
| 'sql-manual/sql-statements/account-management/DROP-USER', | |
| 'sql-manual/sql-statements/account-management/SET-PASSWORD', | |
| 'sql-manual/sql-statements/account-management/CREATE-ROLE', | |
| 'sql-manual/sql-statements/account-management/ALTER-ROLE', | |
| 'sql-manual/sql-statements/account-management/DROP-ROLE', | |
| 'sql-manual/sql-statements/account-management/SHOW-ROLES', | |
| 'sql-manual/sql-statements/account-management/GRANT-TO', | |
| 'sql-manual/sql-statements/account-management/REVOKE-FROM', | |
| 'sql-manual/sql-statements/account-management/SHOW-CREATE-USER', | |
| 'sql-manual/sql-statements/account-management/SHOW-PRIVILEGES', | |
| 'sql-manual/sql-statements/account-management/SHOW-GRANTS', | |
| 'sql-manual/sql-statements/account-management/REFRESH-LDAP', | |
| 'sql-manual/sql-statements/account-management/SET-LDAP_ADMIN_PASSWORD', | |
| 'sql-manual/sql-statements/account-management/SET-PROPERTY', | |
| 'sql-manual/sql-statements/account-management/SHOW-PROPERTY', | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'Session', | |
| items: [ | |
| { | |
| type: 'category', | |
| label: 'Context', | |
| items: [ | |
| 'sql-manual/sql-statements/session/context/USE-COMPUTE-GROUP', | |
| 'sql-manual/sql-statements/session/context/SWITCH-CATALOG', | |
| 'sql-manual/sql-statements/session/context/USE-DATABASE', | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'Variable', | |
| items: [ | |
| 'sql-manual/sql-statements/session/variable/SET-VARIABLE', | |
| 'sql-manual/sql-statements/session/variable/UNSET-VARIABLE', | |
| 'sql-manual/sql-statements/session/variable/SHOW-VARIABLES', | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'Query', | |
| items: [ | |
| 'sql-manual/sql-statements/session/queries/SHOW-PROCESSLIST', | |
| 'sql-manual/sql-statements/session/queries/KILL-QUERY', | |
| 'sql-manual/sql-statements/session/queries/CLEAN-ALL-PROFILE', | |
| 'sql-manual/sql-statements/session/queries/SHOW-QUERY-STATS', | |
| 'sql-manual/sql-statements/session/queries/CLEAN-ALL-QUERY-STATS', | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'Connection', | |
| items: ['sql-manual/sql-statements/session/connection/KILL-CONNECTION'], | |
| }, | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'Transaction', | |
| items: [ | |
| 'sql-manual/sql-statements/transaction/BEGIN', | |
| 'sql-manual/sql-statements/transaction/COMMIT', | |
| 'sql-manual/sql-statements/transaction/ROLLBACK', | |
| 'sql-manual/sql-statements/transaction/SHOW-TRANSACTION', | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'Data Catalog', | |
| items: [ | |
| 'sql-manual/sql-statements/catalog/CREATE-CATALOG', | |
| 'sql-manual/sql-statements/catalog/ALTER-CATALOG', | |
| 'sql-manual/sql-statements/catalog/DROP-CATALOG', | |
| 'sql-manual/sql-statements/catalog/SHOW-CREATE-CATALOG', | |
| 'sql-manual/sql-statements/catalog/SHOW-CATALOG', | |
| 'sql-manual/sql-statements/catalog/SHOW-CATALOGS', | |
| 'sql-manual/sql-statements/catalog/REFRESH', | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'Database', | |
| items: [ | |
| 'sql-manual/sql-statements/database/CREATE-DATABASE', | |
| 'sql-manual/sql-statements/database/ALTER-DATABASE', | |
| 'sql-manual/sql-statements/database/DROP-DATABASE', | |
| 'sql-manual/sql-statements/database/SHOW-CREATE-DATABASE', | |
| 'sql-manual/sql-statements/database/SHOW-DATABASES', | |
| 'sql-manual/sql-statements/database/SHOW-DATABASE-ID', | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'Table and Views', | |
| items: [ | |
| { | |
| type: 'category', | |
| label: 'Table', | |
| items: [ | |
| 'sql-manual/sql-statements/table-and-view/table/CREATE-TABLE', | |
| 'sql-manual/sql-statements/table-and-view/table/DESC-TABLE', | |
| 'sql-manual/sql-statements/table-and-view/table/ALTER-TABLE-COLUMN', | |
| 'sql-manual/sql-statements/table-and-view/table/ALTER-TABLE-PARTITION', | |
| 'sql-manual/sql-statements/table-and-view/table/ALTER-TABLE-ROLLUP', | |
| 'sql-manual/sql-statements/table-and-view/table/ALTER-TABLE-RENAME', | |
| 'sql-manual/sql-statements/table-and-view/table/ALTER-TABLE-REPLACE', | |
| 'sql-manual/sql-statements/table-and-view/table/ALTER-TABLE-PROPERTY', | |
| 'sql-manual/sql-statements/table-and-view/table/ALTER-TABLE-COMMENT', | |
| 'sql-manual/sql-statements/table-and-view/table/ALTER-TABLE-DISTRIBUTION', | |
| 'sql-manual/sql-statements/table-and-view/table/ALTER-TABLE-ADD-GENERATED-COLUMN', | |
| 'sql-manual/sql-statements/table-and-view/table/CANCEL-ALTER-TABLE', | |
| 'sql-manual/sql-statements/table-and-view/table/SHOW-ALTER-TABLE', | |
| 'sql-manual/sql-statements/table-and-view/table/TRUNCATE-TABLE', | |
| 'sql-manual/sql-statements/table-and-view/table/DROP-TABLE', | |
| 'sql-manual/sql-statements/table-and-view/table/SHOW-CREATE-TABLE', | |
| 'sql-manual/sql-statements/table-and-view/table/SHOW-TABLES', | |
| 'sql-manual/sql-statements/table-and-view/table/SHOW-TABLE-ID', | |
| 'sql-manual/sql-statements/table-and-view/table/SHOW-TABLE-STATUS', | |
| 'sql-manual/sql-statements/table-and-view/table/SHOW-CONVERT-LIGHT-SCHEMA-CHANGE-PROCESS', | |
| 'sql-manual/sql-statements/table-and-view/table/SHOW-PARTITION', | |
| 'sql-manual/sql-statements/table-and-view/table/SHOW-PARTITION-ID', | |
| 'sql-manual/sql-statements/table-and-view/table/SHOW-PARTITIONS', | |
| 'sql-manual/sql-statements/table-and-view/table/SHOW-DYNAMIC-PARTITION-TABLES', | |
| 'sql-manual/sql-statements/table-and-view/table/SHOW-COLUMNS', | |
| 'sql-manual/sql-statements/table-and-view/table/ALTER-COLOCATE-GROUP', | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'Index', | |
| items: [ | |
| 'sql-manual/sql-statements/table-and-view/index/CREATE-INDEX', | |
| 'sql-manual/sql-statements/table-and-view/index/DROP-INDEX', | |
| 'sql-manual/sql-statements/table-and-view/index/SHOW-INDEX', | |
| 'sql-manual/sql-statements/table-and-view/index/BUILD-INDEX', | |
| 'sql-manual/sql-statements/table-and-view/index/CANCEL-BUILD-INDEX', | |
| 'sql-manual/sql-statements/table-and-view/index/SHOW-BUILD-INDEX', | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'View', | |
| items: [ | |
| 'sql-manual/sql-statements/table-and-view/view/CREATE-VIEW', | |
| 'sql-manual/sql-statements/table-and-view/view/ALTER-VIEW', | |
| 'sql-manual/sql-statements/table-and-view/view/DROP-VIEW', | |
| 'sql-manual/sql-statements/table-and-view/view/SHOW-CREATE-VIEW', | |
| 'sql-manual/sql-statements/table-and-view/view/SHOW-VIEW', | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'Table Stream', | |
| items: [ | |
| 'sql-manual/sql-statements/table-and-view/stream/CREATE-STREAM', | |
| 'sql-manual/sql-statements/table-and-view/stream/ALTER-STREAM', | |
| 'sql-manual/sql-statements/table-and-view/stream/DROP-STREAM', | |
| 'sql-manual/sql-statements/table-and-view/stream/SHOW-CREATE-STREAM', | |
| 'sql-manual/sql-statements/table-and-view/stream/SHOW-STREAMS', | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'Synchronous Materialized View', | |
| items: [ | |
| 'sql-manual/sql-statements/table-and-view/sync-materialized-view/CREATE-MATERIALIZED-VIEW', | |
| 'sql-manual/sql-statements/table-and-view/sync-materialized-view/DROP-MATERIALIZED-VIEW', | |
| 'sql-manual/sql-statements/table-and-view/sync-materialized-view/SHOW-ALTER-TABLE-MATERIALIZED-VIEW', | |
| 'sql-manual/sql-statements/table-and-view/sync-materialized-view/SHOW-CREATE-MATERIALIZED-VIEW', | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'Asynchronous Materialized View', | |
| items: [ | |
| 'sql-manual/sql-statements/table-and-view/async-materialized-view/ALTER-ASYNC-MATERIALIZED-VIEW', | |
| 'sql-manual/sql-statements/table-and-view/async-materialized-view/CANCEL-MATERIALIZED-VIEW-TASK', | |
| 'sql-manual/sql-statements/table-and-view/async-materialized-view/CREATE-ASYNC-MATERIALIZED-VIEW', | |
| 'sql-manual/sql-statements/table-and-view/async-materialized-view/PAUSE-MATERIALIZED-VIEW-JOB', | |
| 'sql-manual/sql-statements/table-and-view/async-materialized-view/DROP-ASYNC-MATERIALIZED-VIEW', | |
| 'sql-manual/sql-statements/table-and-view/async-materialized-view/REFRESH-MATERIALIZED-VIEW', | |
| 'sql-manual/sql-statements/table-and-view/async-materialized-view/RESUME-MATERIALIZED-VIEW-JOB', | |
| 'sql-manual/sql-statements/table-and-view/async-materialized-view/SHOW-CREATE-ASYNC-MATERIALIZED-VIEW', | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'Data and Status Management', | |
| items: [ | |
| 'sql-manual/sql-statements/table-and-view/data-and-status-management/REBALANCE-DISK', | |
| 'sql-manual/sql-statements/table-and-view/data-and-status-management/CANCEL-REBALANCE-DISK', | |
| 'sql-manual/sql-statements/table-and-view/data-and-status-management/SHOW-DATA', | |
| 'sql-manual/sql-statements/table-and-view/data-and-status-management/SHOW-DATA-SKEW', | |
| 'sql-manual/sql-statements/table-and-view/data-and-status-management/COMPACT-TABLE', | |
| 'sql-manual/sql-statements/table-and-view/data-and-status-management/REPAIR-TABLE', | |
| 'sql-manual/sql-statements/table-and-view/data-and-status-management/CANCEL-REPAIR-TABLE', | |
| 'sql-manual/sql-statements/table-and-view/data-and-status-management/SET-TABLE-STATUS', | |
| 'sql-manual/sql-statements/table-and-view/data-and-status-management/SET-TABLE-PARTITION-VERSION', | |
| 'sql-manual/sql-statements/table-and-view/data-and-status-management/DIAGNOSE-TABLET', | |
| 'sql-manual/sql-statements/table-and-view/data-and-status-management/ADMIN-COPY-TABLET', | |
| 'sql-manual/sql-statements/table-and-view/data-and-status-management/ADMIN-CHECK-TABLET', | |
| 'sql-manual/sql-statements/table-and-view/data-and-status-management/SHOW-TABLET', | |
| 'sql-manual/sql-statements/table-and-view/data-and-status-management/SHOW-TABLETS-BELONG', | |
| 'sql-manual/sql-statements/table-and-view/data-and-status-management/SHOW-TABLET-STORAGE-FORMAT', | |
| 'sql-manual/sql-statements/table-and-view/data-and-status-management/SHOW-TABLET-DIAGNOSIS', | |
| 'sql-manual/sql-statements/table-and-view/data-and-status-management/ADMIN-SET-REPLICA-STATUS', | |
| 'sql-manual/sql-statements/table-and-view/data-and-status-management/ADMIN-SET-REPLICA-VERSION', | |
| 'sql-manual/sql-statements/table-and-view/data-and-status-management/SHOW-REPLICA-STATUS', | |
| 'sql-manual/sql-statements/table-and-view/data-and-status-management/SHOW-REPLICA-DISTRIBUTION', | |
| 'sql-manual/sql-statements/table-and-view/data-and-status-management/CLEAN-TRASH', | |
| 'sql-manual/sql-statements/table-and-view/data-and-status-management/SHOW-TRASH', | |
| ], | |
| }, | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'Recycle', | |
| items: [ | |
| 'sql-manual/sql-statements/recycle/SHOW-CATALOG-RECYCLE-BIN', | |
| 'sql-manual/sql-statements/recycle/DROP-CATALOG-RECYCLE-BIN', | |
| 'sql-manual/sql-statements/recycle/RECOVER', | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'Function', | |
| items: [ | |
| 'sql-manual/sql-statements/function/CREATE-FUNCTION', | |
| 'sql-manual/sql-statements/function/DROP-FUNCTION', | |
| 'sql-manual/sql-statements/function/SHOW-CREATE-FUNCTION', | |
| 'sql-manual/sql-statements/function/DESC-FUNCTION', | |
| 'sql-manual/sql-statements/function/SHOW-FUNCTIONS', | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'Statistics', | |
| items: [ | |
| 'sql-manual/sql-statements/statistics/ANALYZE', | |
| 'sql-manual/sql-statements/statistics/ALTER-STATS', | |
| 'sql-manual/sql-statements/statistics/DROP-STATS', | |
| 'sql-manual/sql-statements/statistics/SHOW-TABLE-STATS', | |
| 'sql-manual/sql-statements/statistics/SHOW-STATS', | |
| 'sql-manual/sql-statements/statistics/DROP-ANALYZE-JOB', | |
| 'sql-manual/sql-statements/statistics/KILL-ANALYZE-JOB', | |
| 'sql-manual/sql-statements/statistics/SHOW-ANALYZE', | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'Cluster Management', | |
| items: [ | |
| { | |
| type: 'category', | |
| label: 'Instance Management', | |
| items: [ | |
| 'sql-manual/sql-statements/cluster-management/instance-management/ADD-FOLLOWER', | |
| 'sql-manual/sql-statements/cluster-management/instance-management/DROP-FOLLOWER', | |
| 'sql-manual/sql-statements/cluster-management/instance-management/ADD-OBSERVER', | |
| 'sql-manual/sql-statements/cluster-management/instance-management/DROP-OBSERVER', | |
| 'sql-manual/sql-statements/cluster-management/instance-management/SET-FRONTEND-CONFIG', | |
| 'sql-manual/sql-statements/cluster-management/instance-management/SHOW-FRONTEND-CONFIG', | |
| 'sql-manual/sql-statements/cluster-management/instance-management/MODIFY-FRONTEND-HOSTNAME', | |
| 'sql-manual/sql-statements/cluster-management/instance-management/SHOW-FRONTENDS', | |
| 'sql-manual/sql-statements/cluster-management/instance-management/SHOW-FRONTENDS-DISKS', | |
| 'sql-manual/sql-statements/cluster-management/instance-management/ADD-BACKEND', | |
| 'sql-manual/sql-statements/cluster-management/instance-management/DROP-BACKEND', | |
| 'sql-manual/sql-statements/cluster-management/instance-management/MODIFY-BACKEND', | |
| 'sql-manual/sql-statements/cluster-management/instance-management/SHOW-BACKENDS', | |
| 'sql-manual/sql-statements/cluster-management/instance-management/SHOW-BACKEND-CONFIG', | |
| 'sql-manual/sql-statements/cluster-management/instance-management/DECOMMISSION-BACKEND', | |
| 'sql-manual/sql-statements/cluster-management/instance-management/CANCEL-DECOMMISSION-BACKEND', | |
| 'sql-manual/sql-statements/cluster-management/instance-management/ADD-BROKER', | |
| 'sql-manual/sql-statements/cluster-management/instance-management/DROP-BROKER', | |
| 'sql-manual/sql-statements/cluster-management/instance-management/SHOW-BROKER', | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'Compute Management', | |
| items: [ | |
| 'sql-manual/sql-statements/cluster-management/compute-management/CREATE-RESOURCE', | |
| 'sql-manual/sql-statements/cluster-management/compute-management/ALTER-RESOURCE', | |
| 'sql-manual/sql-statements/cluster-management/compute-management/DROP-RESOURCE', | |
| 'sql-manual/sql-statements/cluster-management/compute-management/SHOW-RESOURCES', | |
| 'sql-manual/sql-statements/cluster-management/compute-management/CREATE-WORKLOAD-GROUP', | |
| 'sql-manual/sql-statements/cluster-management/compute-management/ALTER-WORKLOAD-GROUP', | |
| 'sql-manual/sql-statements/cluster-management/compute-management/DROP-WORKLOAD-GROUP', | |
| 'sql-manual/sql-statements/cluster-management/compute-management/SHOW-WORKLOAD-GROUPS', | |
| 'sql-manual/sql-statements/cluster-management/compute-management/CREATE-WORKLOAD-POLICY', | |
| 'sql-manual/sql-statements/cluster-management/compute-management/ALTER-WORKLOAD-POLICY', | |
| 'sql-manual/sql-statements/cluster-management/compute-management/DROP-WORKLOAD-POLICY', | |
| 'sql-manual/sql-statements/cluster-management/compute-management/SHOW-COMPUTE-GROUPS', | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'Storage Management', | |
| items: [ | |
| 'sql-manual/sql-statements/cluster-management/storage-management/CREATE-STORAGE-VAULT', | |
| 'sql-manual/sql-statements/cluster-management/storage-management/ALTER-STORAGE-VAULT', | |
| 'sql-manual/sql-statements/cluster-management/storage-management/SET-DEFAULT-STORAGE-VAULT', | |
| 'sql-manual/sql-statements/cluster-management/storage-management/UNSET-DEFAULT-STORAGE-VAULT', | |
| 'sql-manual/sql-statements/cluster-management/storage-management/SHOW-STORAGE-VAULTS', | |
| 'sql-manual/sql-statements/cluster-management/storage-management/CREATE-STORAGE-POLICY', | |
| 'sql-manual/sql-statements/cluster-management/storage-management/ALTER-STORAGE-POLICY', | |
| 'sql-manual/sql-statements/cluster-management/storage-management/DROP-STORAGE-POLICY', | |
| 'sql-manual/sql-statements/cluster-management/storage-management/SHOW-STORAGE-POLICY', | |
| 'sql-manual/sql-statements/cluster-management/storage-management/WARM-UP', | |
| 'sql-manual/sql-statements/cluster-management/storage-management/CANCEL-WARM-UP', | |
| 'sql-manual/sql-statements/cluster-management/storage-management/SHOW-WARM-UP-JOB', | |
| 'sql-manual/sql-statements/cluster-management/storage-management/SHOW-CACHE-HOTSPOT', | |
| ], | |
| }, | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'Security', | |
| items: [ | |
| 'sql-manual/sql-statements/security/CREATE-FILE', | |
| 'sql-manual/sql-statements/security/DROP-FILE', | |
| 'sql-manual/sql-statements/security/SHOW-FILE', | |
| 'sql-manual/sql-statements/security/CREATE-ENCRYPTKEY', | |
| 'sql-manual/sql-statements/security/DROP-ENCRYPTKEY', | |
| 'sql-manual/sql-statements/security/SHOW-ENCRYPTKEY', | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'Data Governance', | |
| items: [ | |
| 'sql-manual/sql-statements/data-governance/CREATE-SQL_BLOCK_RULE', | |
| 'sql-manual/sql-statements/data-governance/ALTER-SQL_BLOCK_RULE', | |
| 'sql-manual/sql-statements/data-governance/DROP-SQL_BLOCK_RULE', | |
| 'sql-manual/sql-statements/data-governance/SHOW-SQL_BLOCK_RULE', | |
| 'sql-manual/sql-statements/data-governance/CREATE-ROW-POLICY', | |
| 'sql-manual/sql-statements/data-governance/DROP-ROW-POLICY', | |
| 'sql-manual/sql-statements/data-governance/SHOW-ROW-POLICY', | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'Job', | |
| items: [ | |
| 'sql-manual/sql-statements/job/CREATE-JOB', | |
| 'sql-manual/sql-statements/job/CREATE-STREAMING-JOB', | |
| 'sql-manual/sql-statements/job/ALTER-JOB', | |
| 'sql-manual/sql-statements/job/PAUSE-JOB', | |
| 'sql-manual/sql-statements/job/DROP-JOB', | |
| 'sql-manual/sql-statements/job/RESUME-JOB', | |
| 'sql-manual/sql-statements/job/CANCEL-TASK', | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'Plugin', | |
| items: [ | |
| 'sql-manual/sql-statements/plugin/INSTALL-PLUGIN', | |
| 'sql-manual/sql-statements/plugin/UNINSTALL-PLUGIN', | |
| 'sql-manual/sql-statements/plugin/SHOW-PLUGINS', | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'Character Set', | |
| items: [ | |
| 'sql-manual/sql-statements/character-set/SHOW-COLLATION', | |
| 'sql-manual/sql-statements/character-set/SHOW-CHARSET', | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'Types', | |
| items: [ | |
| 'sql-manual/sql-statements/types/SHOW-DATA-TYPES', | |
| 'sql-manual/sql-statements/types/SHOW-TYPECAST', | |
| ], | |
| }, | |
| { | |
| type: 'category', | |
| label: 'Info System and Help', | |
| items: ['sql-manual/sql-statements/system-info-and-help/SHOW-PROC'], | |
| }, | |
| ], | |
| }, | |
| ], | |
| }, | |
| ], | |
| }; | |
| export default sidebars; |