| 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: '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', |
| ], |
| }, |
| { |
| 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/dbt-doris-adapter', |
| 'connection-integration/data-integration/doris-kafka-connector', |
| 'connection-integration/data-integration/doris-streamloader', |
| 'connection-integration/data-integration/finebi', |
| 'connection-integration/data-integration/flink-doris-connector', |
| '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/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: 'Use Doris', |
| 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/basic-concepts'}, |
| items: [ |
| 'table-design/data-partitioning/manual-partitioning', |
| 'table-design/data-partitioning/dynamic-partitioning', |
| 'table-design/data-partitioning/auto-partitioning', |
| 'table-design/data-partitioning/data-bucketing', |
| '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', |
| 'table-design/temporary-table', |
| ], |
| }, |
| { |
| 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/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/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/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', |
| ], |
| }, |
| ], |
| }, |
| 'data-operate/import/import-way/streaming-job/continuous-load-s3', |
| ], |
| }, |
| ], |
| }, |
| { |
| 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', |
| 'data-operate/import/file-format/native', |
| ], |
| }, |
| { |
| 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/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: '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: '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', |
| ], |
| }, |
| { |
| 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/use-guide', |
| 'query-acceleration/tuning/tuning-plan/transparent-rewriting-with-async-mv', |
| 'query-acceleration/materialized-view/async-materialized-view/faq', |
| ], |
| }, |
| ], |
| }, |
| { |
| 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-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: [ |
| 'lakehouse/catalogs/hive-catalog', |
| { |
| type: 'category', |
| label: 'Iceberg Catalog', |
| link: {type: 'doc', id: 'lakehouse/catalogs/iceberg-catalog'}, |
| items: [ |
| 'lakehouse/best-practices/doris-iceberg', |
| 'lakehouse/best-practices/doris-aws-s3tables', |
| '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/best-practices/doris-paimon', |
| 'lakehouse/best-practices/doris-dlf-paimon', |
| ], |
| }, |
| { |
| 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/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/compute-node', |
| 'lakehouse/statistics', |
| { |
| type: 'category', |
| label: 'Lakehouse Best Practices', |
| items: [ |
| 'lakehouse/best-practices/optimization', |
| 'lakehouse/best-practices/kerberos', |
| 'lakehouse/best-practices/tpch', |
| 'lakehouse/best-practices/tpcds', |
| ], |
| }, |
| ], |
| }, |
| ], |
| }, |
| { |
| 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', |
| 'observability/dogstack/deployment', |
| '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/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/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/data', |
| ], |
| }, |
| '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/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', |
| ], |
| }, |
| { |
| type: 'category', |
| label: 'Cross Cluster Replication', |
| link: {type: 'doc', id: 'admin-manual/data-admin/ccr/overview'}, |
| items: [ |
| 'admin-manual/data-admin/ccr/quickstart', |
| 'admin-manual/data-admin/ccr/manual', |
| 'admin-manual/data-admin/ccr/feature', |
| 'admin-manual/data-admin/ccr/config', |
| 'admin-manual/data-admin/ccr/performance', |
| ], |
| }, |
| '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_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/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/colocate-meta-action', |
| 'admin-manual/open-api/fe-http/meta-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/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: 'Reference', |
| collapsed: true, |
| 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/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-workload-guide', |
| }, |
| collapsed: true, |
| items: [ |
| { |
| type: 'doc', |
| id: 'sql-manual/basic-element/sql-data-types/semi-structured/VARIANT', |
| label: 'VARIANT Reference', |
| }, |
| ], |
| }, |
| ], |
| }, |
| { |
| 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', |
| ], |
| }, |
| { |
| 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/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', |
| ], |
| }, |
| ], |
| }, |
| { |
| 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/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: '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/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/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/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/printf', |
| '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-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/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-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-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-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', |
| ], |
| }, |
| { |
| 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-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-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', |
| ], |
| }, |
| { |
| 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/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-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-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/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/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/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', |
| 'sql-manual/sql-statements/session/queries/PLAN-REPLAYER-DUMP', |
| 'sql-manual/sql-statements/session/queries/PLAN-REPLAYER-PLAY', |
| ], |
| }, |
| { |
| 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: '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; |
