# GreptimeDB Documentation

> GreptimeDB is an open-source observability database for metrics, logs, traces, and wide events. Drop-in replacement for Prometheus, Loki & Elasticsearch, or the single backend for OpenTelemetry.

This file contains links to documentation sections following the llmstxt.org standard.

## Table of Contents

- [Introduction](https://docs.greptime.com/index.md): Introduction to GreptimeDB, an open-source observability database for metrics, logs, and traces, with links to getting started, user guide, contrib...
- [GreptimeDB Cluster](https://docs.greptime.com/getting-started/installation/greptimedb-cluster.md): Instructions to deploy GreptimeDB in cluster mode using Kubernetes or Docker Compose, including steps for setup and cleanup.
- [GreptimeDB Dashboard](https://docs.greptime.com/getting-started/installation/greptimedb-dashboard.md): Information on accessing and using the GreptimeDB Dashboard for visualizing time series data.
- [GreptimeDB Standalone](https://docs.greptime.com/getting-started/installation/greptimedb-standalone.md): Guide to install and run GreptimeDB in standalone mode using binary or Docker, including binding address configuration.
- [Installation](https://docs.greptime.com/getting-started/installation/overview.md): Instructions to install GreptimeDB, check its health status, and proceed to the quick start guide.
- [Getting Started](https://docs.greptime.com/getting-started/overview.md): Get started with GreptimeDB quickly.
- [Quick Start](https://docs.greptime.com/getting-started/quick-start.md): A 10-minute guide to GreptimeDB's core capabilities — from ingestion to cross-signal correlation across metrics, logs, and traces.
- [Architecture](https://docs.greptime.com/user-guide/concepts/architecture.md): Overview of GreptimeDB architecture, including core components, optional Flownode for flow computation, and request/data paths in distributed deplo...
- [Data Model](https://docs.greptime.com/user-guide/concepts/data-model.md): Describes the data model of GreptimeDB, focusing on time-series tables. It explains the organization of data into tables with tags, timestamps, and...
- [Common Questions](https://docs.greptime.com/user-guide/concepts/features-that-you-concern.md): Answers common questions about GreptimeDB's features, including how it handles metrics, logs, and traces; updates, deletions, TTL policies, compres...
- [Key Concepts](https://docs.greptime.com/user-guide/concepts/key-concepts.md): Introduces the key concepts of GreptimeDB, including databases, time-series tables, table regions, data types, indexes, views, and flows. It explai...
- [Observability 2.0](https://docs.greptime.com/user-guide/concepts/observability-2.md): Explains the Observability 2.0 paradigm and how GreptimeDB is designed as the native database for wide events.
- [Concepts](https://docs.greptime.com/user-guide/concepts/overview.md): Provides an overview of GreptimeDB, including its features, data model, architecture, storage locations, key concepts, and notable features.
- [Storage Location](https://docs.greptime.com/user-guide/concepts/storage-location.md): Describes the storage options for GreptimeDB, including local file systems, cloud storage services like AWS S3, Azure Blob Storage, and more. It ex...
- [Why GreptimeDB](https://docs.greptime.com/user-guide/concepts/why-greptimedb.md): Explains the motivations and benefits of using GreptimeDB, including its unified design for metrics, logs, and traces, cloud-native architecture, c...
- [Authentication](https://docs.greptime.com/user-guide/deployments-administration/authentication/overview.md): Overview of authentication in GreptimeDB, including static user provider and LDAP user provider for authenticating users.
- [Static User Provider](https://docs.greptime.com/user-guide/deployments-administration/authentication/static.md): Instructions for setting up static user authentication in GreptimeDB using a configuration file with user credentials.
- [Capacity Plan](https://docs.greptime.com/user-guide/deployments-administration/capacity-plan.md): Provides guidelines for CPU, memory, and storage requirements for GreptimeDB based on data points processed per second, query requests per second, ...
- [Configuration](https://docs.greptime.com/user-guide/deployments-administration/configuration.md): Detailed guide on configuring GreptimeDB, including command line options, configuration file options, environment variables, and default values for...
- [Common Helm Chart Configurations](https://docs.greptime.com/user-guide/deployments-administration/deploy-on-kubernetes/common-helm-chart-configurations.md): Common Helm Chart Configurations
- [Deploying a GreptimeDB Cluster with Frontend Groups](https://docs.greptime.com/user-guide/deployments-administration/deploy-on-kubernetes/configure-frontend-groups.md): Step-by-step guide to deploying a GreptimeDB cluster with frontend groups on Kubernetes, including prerequisites, configuration, installation, and ...
- [Deploying GreptimeDB Cluster with Remote WAL](https://docs.greptime.com/user-guide/deployments-administration/deploy-on-kubernetes/configure-remote-wal.md): Step-by-step guide to deploying GreptimeDB with Remote WAL on Kubernetes, including prerequisites, configuration, installation, and verification.
- [Deploy GreptimeDB Cluster](https://docs.greptime.com/user-guide/deployments-administration/deploy-on-kubernetes/deploy-greptimedb-cluster.md): Step-by-step guide to deploying a GreptimeDB cluster on Kubernetes using the GreptimeDB Operator, including prerequisites, cluster creation, instal...
- [Deploy GreptimeDB Standalone](https://docs.greptime.com/user-guide/deployments-administration/deploy-on-kubernetes/deploy-greptimedb-standalone.md): Step-by-step guide to deploying a GreptimeDB standalone on Kubernetes.
- [GreptimeDB Operator Management](https://docs.greptime.com/user-guide/deployments-administration/deploy-on-kubernetes/greptimedb-operator-management.md): Guide to managing the GreptimeDB Operator on Kubernetes, including installation, upgrade, configuration, and uninstallation using Helm.
- [Deploy GreptimeDB on Kubernetes](https://docs.greptime.com/user-guide/deployments-administration/deploy-on-kubernetes/overview.md): Overview of deploying GreptimeDB on Kubernetes using the GreptimeDB Operator, including setup, provisioning, and management of clusters and standal...
- [Data Export & Import](https://docs.greptime.com/user-guide/deployments-administration/disaster-recovery/back-up-&-restore-data.md): Describes how to use GreptimeDB's Export and Import tools for database backup and restoration, including command syntax, options, usage scenarios, ...
- [Metadata Export & Import](https://docs.greptime.com/user-guide/deployments-administration/disaster-recovery/back-up-&-restore-meta-data.md): Learn how to use GreptimeDB's metadata export and import tools for backing up and restoring database metadata, including comprehensive examples and...
- [DR Solution Based on Cross-Region Deployment in a Single Cluster](https://docs.greptime.com/user-guide/deployments-administration/disaster-recovery/dr-solution-based-on-cross-region-deployment-in-single-cluster.md): Explains the disaster recovery (DR) solution based on cross-region deployment in a single GreptimeDB cluster, detailing various configurations for ...
- [DR solution for GreptimeDB Standalone](https://docs.greptime.com/user-guide/deployments-administration/disaster-recovery/dr-solution-for-standalone.md): DR solution for GreptimeDB Standalone.
- [Disaster Recovery](https://docs.greptime.com/user-guide/deployments-administration/disaster-recovery/overview.md): Overview of disaster recovery (DR) solutions in GreptimeDB, including basic concepts, component architecture, and various DR solutions such as stan...
- [Cluster Maintenance Mode](https://docs.greptime.com/user-guide/deployments-administration/maintenance/maintenance-mode.md): Guide for managing GreptimeDB cluster maintenance mode to safely perform operations like upgrades and maintenance while preventing automatic region...
- [Prevent Metadata Changes](https://docs.greptime.com/user-guide/deployments-administration/maintenance/prevent-metadata-changes.md): Guide for managing GreptimeDB pause metadata changes to safely perform operations like metadata backup.
- [Cluster Recovery Mode](https://docs.greptime.com/user-guide/deployments-administration/maintenance/recovery-mode.md): Guide for using GreptimeDB cluster recovery mode to address datanode startup failures and recover from region data loss or corruption.
- [Resource ID Management](https://docs.greptime.com/user-guide/deployments-administration/maintenance/sequence-management.md): Guide for maintaining and updating resource IDs in GreptimeDB clusters, including resetting next table ID after metadata restoration.
- [Table Reconciliation](https://docs.greptime.com/user-guide/deployments-administration/maintenance/table-reconciliation.md): Guide for understanding GreptimeDB's table reconciliation mechanism that detects and repairs metadata inconsistencies between Metasrv and Datanode.
- [Basic Table Operations](https://docs.greptime.com/user-guide/deployments-administration/manage-data/basic-table-operations.md): Covers basic table operations in GreptimeDB, including creating, describing, showing, altering, and dropping tables, as well as executing SQL state...
- [Compaction](https://docs.greptime.com/user-guide/deployments-administration/manage-data/compaction.md): Explanation of the compaction process in GreptimeDB, including concepts like SST files, time windows, sorted runs, and levels, as well as the Time ...
- [Garbage Collection (GC)](https://docs.greptime.com/user-guide/deployments-administration/manage-data/gc.md): GC keeps SST/index files until all references are released, protecting long queries and repartition workflows.
- [Manage Data](https://docs.greptime.com/user-guide/deployments-administration/manage-data/overview.md): Overview of managing data in GreptimeDB, including storage location, basic SQL table operations, data updates, TTL policies, table sharding, region...
- [Region Failover](https://docs.greptime.com/user-guide/deployments-administration/manage-data/region-failover.md): Covers enabling and understanding region failover in GreptimeDB, which allows for the recovery of regions from failures without data loss, and disc...
- [Region Migration](https://docs.greptime.com/user-guide/deployments-administration/manage-data/region-migration.md): Explanation of how to perform region migration in GreptimeDB, including querying region distribution, selecting a migration destination, executing ...
- [Repartition](https://docs.greptime.com/user-guide/deployments-administration/manage-data/repartition.md): Explains GreptimeDB repartitioning, including prerequisites, hot partition detection, partition rules, and common Helm Chart configurations.
- [Table Sharding](https://docs.greptime.com/user-guide/deployments-administration/manage-data/table-sharding.md): Explains table sharding in GreptimeDB, including when to shard a table, partitioning methods, creating distributed tables, inserting data, querying...
- [Metadata Storage Configuration](https://docs.greptime.com/user-guide/deployments-administration/manage-metadata/configuration.md): Comprehensive guide for configuring metadata storage backends (etcd, MySQL, PostgreSQL) in GreptimeDB's metasrv component, including setup instruct...
- [Manage etcd](https://docs.greptime.com/user-guide/deployments-administration/manage-metadata/manage-etcd.md): A comprehensive guide for managing an etcd cluster including installation, backup, and restoration processes using Kubernetes and Helm.
- [Overview](https://docs.greptime.com/user-guide/deployments-administration/manage-metadata/overview.md): Overview of metadata storage options in GreptimeDB, including etcd, MySQL, and PostgreSQL, with recommendations for production deployments.
- [Backup and Restore, Migrate](https://docs.greptime.com/user-guide/deployments-administration/manage-metadata/restore-backup.md): Guide for backing up, restoring, and migrating GreptimeDB metadata across different storage backends (etcd, MySQL, PostgreSQL) with best practices ...
- [Check GreptimeDB Status](https://docs.greptime.com/user-guide/deployments-administration/monitoring/check-db-status.md): Check GreptimeDB health status, deployment status, and runtime metrics through HTTP endpoints.
- [Self-Monitoring GreptimeDB Clusters](https://docs.greptime.com/user-guide/deployments-administration/monitoring/cluster-monitoring-deployment.md): Complete guide to deploying self-monitoring for GreptimeDB clusters on Kubernetes, including Grafana dashboard setup and configuration options
- [Key Logs](https://docs.greptime.com/user-guide/deployments-administration/monitoring/key-logs.md): Understand GreptimeDB's operational status and troubleshoot errors through key logs.
- [Prometheus-Monitoring GreptimeDB Cluster](https://docs.greptime.com/user-guide/deployments-administration/monitoring/monitor-cluster-with-prometheus.md): Learn how to monitor a GreptimeDB cluster using an existing Prometheus instance in Kubernetes, including configuration steps and Grafana dashboard ...
- [Monitoring](https://docs.greptime.com/user-guide/deployments-administration/monitoring/overview.md): Overview of monitoring methods for GreptimeDB, including exporting metrics and tracing.
- [Runtime Information](https://docs.greptime.com/user-guide/deployments-administration/monitoring/runtime-info.md): Provides access to system metadata through the INFORMATION_SCHEMA database, including cluster topology and table regions distribution. Examples of ...
- [Slow Query (Experimental)](https://docs.greptime.com/user-guide/deployments-administration/monitoring/slow-query.md): Guide on configuring and using slow query logging in GreptimeDB for monitoring.
- [Standalone Monitoring](https://docs.greptime.com/user-guide/deployments-administration/monitoring/standalone-monitoring.md): Guide to monitor GreptimeDB standalone instance using Prometheus metrics and Grafana.
- [Tracing](https://docs.greptime.com/user-guide/deployments-administration/monitoring/tracing.md): Guide on using distributed tracing in GreptimeDB with Jaeger. Includes steps for deploying Jaeger, configuring GreptimeDB for tracing, obtaining tr...
- [Deployments & Administration](https://docs.greptime.com/user-guide/deployments-administration/overview.md): Overview of deploying GreptimeDB, including configuration, authentication, Kubernetes deployment, running on Android, capacity planning, and using ...
- [Design Your Table Schema](https://docs.greptime.com/user-guide/deployments-administration/performance-tuning/design-table.md): Learn how to design your table schema in GreptimeDB for optimal performance and query efficiency
- [Performance Tuning Tips](https://docs.greptime.com/user-guide/deployments-administration/performance-tuning/performance-tuning-tips.md): Tips for tuning GreptimeDB performance, including query optimization, caching, enlarging cache size, primary keys, and using append-only tables. Al...
- [Run on Android Platforms](https://docs.greptime.com/user-guide/deployments-administration/run-on-android.md): Instructions for running GreptimeDB on Android platforms, including installation of Termux, downloading the GreptimeDB binary, creating a configura...
- [Troubleshooting](https://docs.greptime.com/user-guide/deployments-administration/troubleshooting.md): GreptimeDB troubleshooting guide, including methods and metrics for diagnosing common issues.
- [Upgrade](https://docs.greptime.com/user-guide/deployments-administration/upgrade.md): Introduce how to upgrade GreptimeDB to the latest version, including some incompatible changes and specific upgrade steps.
- [Local WAL](https://docs.greptime.com/user-guide/deployments-administration/wal/local-wal.md): This section describes how to configure the Local WAL for GreptimeDB Datanode component.
- [Noop WAL](https://docs.greptime.com/user-guide/deployments-administration/wal/noop-wal.md): This section describes how to configure the Noop WAL for GreptimeDB Datanode component in cluster mode.
- [Overview](https://docs.greptime.com/user-guide/deployments-administration/wal/overview.md): This section describes the WAL (Write-Ahead Logging) in GreptimeDB, including the advantages and disadvantages of Local WAL and Remote WAL.
- [Configuration](https://docs.greptime.com/user-guide/deployments-administration/wal/remote-wal/configuration.md): This section describes how to configure the Remote WAL for GreptimeDB Cluster.
- [Manage Kafka](https://docs.greptime.com/user-guide/deployments-administration/wal/remote-wal/manage-kafka.md): This guide describes how to install and manage Kafka cluster.
- [Continuous Aggregation](https://docs.greptime.com/user-guide/flow-computation/continuous-aggregation.md): Learn how to use GreptimeDB's continuous aggregation for real-time analytics. Master Flow engine basics, time-window calculations, and SQL queries ...
- [Expressions](https://docs.greptime.com/user-guide/flow-computation/expressions.md): Lists supported aggregate and scalar functions in GreptimeDB's flow, including count, sum, avg, min, max, and various scalar functions. It provides...
- [Manage Flows](https://docs.greptime.com/user-guide/flow-computation/manage-flow.md): Describes how to manage flows in GreptimeDB, including creating, updating, and deleting flows. It explains the syntax for creating flows, the impor...
- [Flow Computation](https://docs.greptime.com/user-guide/flow-computation/overview.md): Discover how GreptimeDB's Flow engine enables real-time computation of data streams for ETL processes and on-the-fly calculations. Learn about its ...
- [EMQX](https://docs.greptime.com/user-guide/ingest-data/for-iot/emqx.md): Overview of integrating GreptimeDB with EMQX, an open-source MQTT broker for IoT and real-time messaging applications.
- [Go](https://docs.greptime.com/user-guide/ingest-data/for-iot/grpc-sdks/go.md): Guide on using the Go ingester SDK for GreptimeDB, including installation, connection, data model, and examples of low-level and high-level APIs.
- [Java Ingester for GreptimeDB](https://docs.greptime.com/user-guide/ingest-data/for-iot/grpc-sdks/java.md): Guide on using the Java ingester SDK for GreptimeDB, including installation, connection, data model, and examples of low-level and high-level APIs.
- [gRPC SDKs](https://docs.greptime.com/user-guide/ingest-data/for-iot/grpc-sdks/overview.md): Demonstrates how to use client libraries to write data in GreptimeDB, with links to guides for Go, Java, Rust, Erlang, and .NET.
- [InfluxDB Line Protocol](https://docs.greptime.com/user-guide/ingest-data/for-iot/influxdb-line-protocol.md): Guide on using InfluxDB Line Protocol to ingest data into GreptimeDB, including examples, authentication, Telegraf integration, and data model diff...
- [Kafka](https://docs.greptime.com/user-guide/ingest-data/for-iot/kafka.md): Write data from Kafka to GreptimeDB.
- [OpenTSDB](https://docs.greptime.com/user-guide/ingest-data/for-iot/opentsdb.md): Instructions on ingesting OpenTSDB metrics into GreptimeDB via HTTP API, including examples of inserting single and multiple metric points.
- [Ingest Data for IoT](https://docs.greptime.com/user-guide/ingest-data/for-iot/overview.md): Overview of data ingestion methods in GreptimeDB for IoT, including SQL INSERT, gRPC SDK, InfluxDB Line Protocol, EMQX, and OpenTSDB.
- [SQL](https://docs.greptime.com/user-guide/ingest-data/for-iot/sql.md): Guide on executing SQL statements to create tables and insert data into GreptimeDB, with examples using the `monitor` table.
- [Grafana Alloy](https://docs.greptime.com/user-guide/ingest-data/for-observability/alloy.md): Instructions on integrating GreptimeDB with Grafana Alloy for Prometheus Remote Write and OpenTelemetry.
- [Elasticsearch](https://docs.greptime.com/user-guide/ingest-data/for-observability/elasticsearch.md): Use Elasticsearch protocol to ingest log data.
- [Fluent Bit](https://docs.greptime.com/user-guide/ingest-data/for-observability/fluent-bit.md): Instructions on integrating GreptimeDB with Fluent bit for Prometheus Remote Write and OpenTelemetry.
- [InfluxDB Line Protocol](https://docs.greptime.com/user-guide/ingest-data/for-observability/influxdb-line-protocol.md): Write data to GreptimeDB using the InfluxDB Line Protocol
- [Kafka](https://docs.greptime.com/user-guide/ingest-data/for-observability/kafka.md): Learn how to ingest observability data from Kafka into GreptimeDB using Vector. This guide covers metrics and logs ingestion, including JSON and te...
- [Loki](https://docs.greptime.com/user-guide/ingest-data/for-observability/loki.md): Guide to integrating Loki with GreptimeDB for log storage, including API usage, example configurations, and data model mapping.
- [OpenTelemetry Protocol (OTLP)](https://docs.greptime.com/user-guide/ingest-data/for-observability/opentelemetry.md): Instructions for integrating OpenTelemetry with GreptimeDB, including metrics, logs, and traces data model mapping, example configurations, and sup...
- [OTel Collector](https://docs.greptime.com/user-guide/ingest-data/for-observability/otel-collector.md): Instructions for integrating OpenTelemetry Collector with GreptimeDB.
- [Ingest Data for Observability](https://docs.greptime.com/user-guide/ingest-data/for-observability/overview.md): Overview of integrating GreptimeDB with observability tools like Prometheus, Vector, OpenTelemetry, InfluxDB, and Loki for real-time monitoring and...
- [Prometheus](https://docs.greptime.com/user-guide/ingest-data/for-observability/prometheus.md): Guide to integrating Prometheus with GreptimeDB for long-term storage, including configuration, data model mapping, and efficiency improvements.
- [Vector](https://docs.greptime.com/user-guide/ingest-data/for-observability/vector.md): Instructions for integrating Vector with GreptimeDB, including configuration, data model mapping, and example configurations.
- [Ingest Data](https://docs.greptime.com/user-guide/ingest-data/overview.md): Overview of data ingestion methods in GreptimeDB, including automatic schema generation and recommended methods for different scenarios.
- [Grafana Alloy](https://docs.greptime.com/user-guide/integrations/alloy.md): Integrate GreptimeDB with Grafana Alloy.
- [Coroot](https://docs.greptime.com/user-guide/integrations/coroot.md): Integrate GreptimeDB with Coroot.
- [DBeaver](https://docs.greptime.com/user-guide/integrations/dbeaver.md): Guide to connecting GreptimeDB to DBeaver using MySQL database drivers, including connection settings and verification steps.
- [EMQX](https://docs.greptime.com/user-guide/integrations/emqx.md): GreptimeDB can be used as a data system for EMQX.
- [Fluent Bit](https://docs.greptime.com/user-guide/integrations/fluent-bit.md): Integrate GreptimeDB with Fluent Bit.
- [Grafana](https://docs.greptime.com/user-guide/integrations/grafana.md): Steps to configure GreptimeDB as a data source in Grafana using different plugins and data sources, including installation and connection settings.
- [Kafka](https://docs.greptime.com/user-guide/integrations/kafka.md): Learn how to ingest observability data from Kafka into GreptimeDB using Vector.
- [Model Context Protocol (MCP)](https://docs.greptime.com/user-guide/integrations/mcp.md): Learn how to integrate GreptimeDB with Model Context Protocol (MCP) for AI assistants to explore and analyze your time-series data.
- [Metabase](https://docs.greptime.com/user-guide/integrations/metabase.md): Instructions for configuring GreptimeDB as a data source in Metabase, including installation of the driver plugin and connection settings.
- [MindsDB](https://docs.greptime.com/user-guide/integrations/mindsdb.md): Guide on configuring GreptimeCloud as a data source in MindsDB for machine learning capabilities.
- [Integrations](https://docs.greptime.com/user-guide/integrations/overview.md): Provides an overview of integrating GreptimeDB with popular tools for data ingestion, querying, and visualization, including Prometheus, Vector, Gr...
- [Prometheus](https://docs.greptime.com/user-guide/integrations/prometheus.md): Describes how to use GreptimeDB as a remote storage backend for Prometheus and how to query metrics using Prometheus Query Language (PromQL).
- [Streamlit](https://docs.greptime.com/user-guide/integrations/streamlit.md): Instructions for using GreptimeCloud with Streamlit to build data apps, including creating a SQL connection and running SQL queries.
- [Superset](https://docs.greptime.com/user-guide/integrations/superset.md): Guide to configuring GreptimeDB as a database in Apache Superset, including installation steps and connection settings.
- [Telegraf](https://docs.greptime.com/user-guide/integrations/telegraf.md): Guide on using Telegraf to send data to GreptimeDB
- [Vector](https://docs.greptime.com/user-guide/integrations/vector.md): Guide on using Vector to sink data to GreptimeDB.
- [Full-Text Search](https://docs.greptime.com/user-guide/logs/fulltext-search.md): Provides a guide on using GreptimeDB's query language for effective searching and analysis of log data, including pattern matching and query statem...
- [Manage Pipelines](https://docs.greptime.com/user-guide/logs/manage-pipelines.md): Guides on creating, deleting, and managing pipelines in GreptimeDB for parsing and transforming log data, including built-in pipelines and debugging.
- [Logs](https://docs.greptime.com/user-guide/logs/overview.md): Comprehensive guide to GreptimeDB's log management capabilities, covering log collection architecture, pipeline processing, integration with popula...
- [Quick Start](https://docs.greptime.com/user-guide/logs/quick-start.md): Quick start guide for GreptimeDB log service, including basic log ingestion using the built-in greptime_identity pipeline and integration with log ...
- [Using Custom Pipelines](https://docs.greptime.com/user-guide/logs/use-custom-pipelines.md): A comprehensive guide to quickly writing and querying logs in GreptimeDB, including direct log writing and using pipelines for structured data.
- [Data Index](https://docs.greptime.com/user-guide/manage-data/data-index.md): Learn about different types of indexes in GreptimeDB, including inverted index, skipping index, and full-text index, and how to use them effectivel...
- [Manage Data](https://docs.greptime.com/user-guide/manage-data/overview.md): Provides an overview of managing data in GreptimeDB, including updating, deleting, truncating tables, and managing data retention with TTL policies.
- [Migrate from ClickHouse](https://docs.greptime.com/user-guide/migrate-to-greptimedb/migrate-from-clickhouse.md): Step-by-step guide on migrating from ClickHouse to GreptimeDB, including data model adjustments, table structure reconstruction,, exporting and imp...
- [Migrate from InfluxDB](https://docs.greptime.com/user-guide/migrate-to-greptimedb/migrate-from-influxdb.md): Instructions on migrating from InfluxDB to GreptimeDB, including writing data using HTTP API, Telegraf, and client libraries.
- [Migrate from MySQL](https://docs.greptime.com/user-guide/migrate-to-greptimedb/migrate-from-mysql.md): Step-by-step guide on migrating from MySQL to GreptimeDB, including creating databases, writing data, exporting and importing data.
- [Migrate from PostgreSQL](https://docs.greptime.com/user-guide/migrate-to-greptimedb/migrate-from-postgresql.md): Step-by-step guide on migrating from PostgreSQL to GreptimeDB, including creating databases, writing data, exporting and importing data.
- [Migrate from Prometheus](https://docs.greptime.com/user-guide/migrate-to-greptimedb/migrate-from-prometheus.md): Instructions on migrating from Prometheus to GreptimeDB, including remote write configuration, PromQL queries, and Grafana integration.
- [Migrate to GreptimeDB](https://docs.greptime.com/user-guide/migrate-to-greptimedb/overview.md): The overview of migrating data to GreptimeDB from various databases, including InfluxDB, MySQL, PostgreSQL, Prometheus, and more.
- [User Guide](https://docs.greptime.com/user-guide/overview.md): Learn how to use GreptimeDB according to your use case, including data ingestion, querying, and administration.
- [Elasticsearch](https://docs.greptime.com/user-guide/protocols/elasticsearch.md): Use Elasticsearch protocol to ingest log data.
- [gRPC](https://docs.greptime.com/user-guide/protocols/grpc.md): Overview of using gRPC SDKs for efficient and high-performance data ingestion in GreptimeDB.
- [HTTP API](https://docs.greptime.com/user-guide/protocols/http.md): Guide on using HTTP APIs to interact with GreptimeDB, including authentication, timeout settings, health checks, configuration, and SQL queries.
- [InfluxDB Line Protocol](https://docs.greptime.com/user-guide/protocols/influxdb-line-protocol.md): Instructions on ingesting data to GreptimeDB using InfluxDB Line Protocol and using ping and health APIs.
- [Loki](https://docs.greptime.com/user-guide/protocols/loki.md): Learn how to ingest data with Loki.
- [MySQL](https://docs.greptime.com/user-guide/protocols/mysql.md): Guide on connecting to GreptimeDB using MySQL, managing tables, ingesting and querying data, and handling time zones.
- [OpenTelemetry (OTLP)](https://docs.greptime.com/user-guide/protocols/opentelemetry.md): Consume OpenTelemetry Metrics natively via OTLP/HTTP protocol
- [OpenTSDB](https://docs.greptime.com/user-guide/protocols/opentsdb.md): Please refer to [Ingest Data with OpenTSDB](/user-guide/ingest-data/for-iot/opentsdb.md) for detailed information.
- [Protocols](https://docs.greptime.com/user-guide/protocols/overview.md): Overview of supported protocols for data ingestion.
- [PostgreSQL](https://docs.greptime.com/user-guide/protocols/postgresql.md): Guide on connecting to GreptimeDB using PostgreSQL, managing tables, ingesting and querying data, and handling time zones.
- [Common Table Expression (CTE)](https://docs.greptime.com/user-guide/query-data/cte.md): Explanation of Common Table Expressions (CTEs) in GreptimeDB, including syntax, examples, and how to use CTEs to simplify complex queries.
- [Jaeger (Experimental)](https://docs.greptime.com/user-guide/query-data/jaeger.md): Documentation for how to query traces data in GreptimeDB using Jaeger.
- [Log Query (Experimental)](https://docs.greptime.com/user-guide/query-data/log-query.md): Documentation for GreptimeDB's experimental log query endpoint, which provides a dedicated HTTP interface for searching and processing log data.
- [Query Data](https://docs.greptime.com/user-guide/query-data/overview.md): Overview of query languages and features supported by GreptimeDB, including PromQL, SQL, and log query capabilities.
- [Prometheus Query Language](https://docs.greptime.com/user-guide/query-data/promql.md): Guide on using Prometheus Query Language (PromQL) in GreptimeDB, including HTTP API compatibility, SQL extensions, and supported features and limit...
- [Query External Data](https://docs.greptime.com/user-guide/query-data/query-external-data.md): Instructions on querying external data files in GreptimeDB, including creating external tables and running queries on various file formats like CSV...
- [SQL](https://docs.greptime.com/user-guide/query-data/sql.md): Comprehensive guide on querying data in GreptimeDB using SQL, covering basic queries, filtering, time zone handling, functions, and advanced featur...
- [View](https://docs.greptime.com/user-guide/query-data/view.md): Explanation of SQL views in GreptimeDB, including how to create, query, update, and manage views for simplifying complex queries and ensuring data ...
- [Time Zone](https://docs.greptime.com/user-guide/timezone.md): Guide on specifying and managing time zones in GreptimeDB client sessions, including impacts on data ingestion and querying.
- [Trace Data Modeling](https://docs.greptime.com/user-guide/traces/data-model.md): Covers internals of how trace data is stored in GreptimeDB.
- [Extending Trace Data](https://docs.greptime.com/user-guide/traces/extend-trace.md): Introduces additional features to generate more data insights from trace data
- [Trace](https://docs.greptime.com/user-guide/traces/overview.md): Introducing GreptimeDB's built-in support for managing tracing data at scale
- [Ingestion and Query](https://docs.greptime.com/user-guide/traces/read-write.md): Covers basics of trace data ingestion and query in GreptimeDB.
- [Vector Data Type](https://docs.greptime.com/user-guide/vectors/vector-type.md): Overview of vector data type in GreptimeDB, including how to define, insert, and perform calculations with vector type columns in SQL.
- [Region Balancer](https://docs.greptime.com/enterprise/autopilot/region-balancer.md): Configuration guide for the region balancer plugin in GreptimeDB Enterprise, which balances write loads across datanodes to prevent frequent region...
- [Management Console](https://docs.greptime.com/enterprise/console-ui.md): The GreptimeDB Enterprise Management Console provides an enhanced dashboard interface with advanced cluster management, monitoring, and operational...
- [LDAP Authentication](https://docs.greptime.com/enterprise/deployments-administration/authentication.md): Configuration guide for LDAP authentication in GreptimeDB Enterprise, detailing both simple bind and search bind modes.
- [Backup](https://docs.greptime.com/enterprise/deployments-administration/backup.md): GreptimeDB backup guide, including steps for backing up metadata and databases.
- [Deploy a GreptimeDB Cluster with Datanode Groups](https://docs.greptime.com/enterprise/deployments-administration/deploy-on-kubernetes/configure-datanode-groups.md): Step-by-step guide to deploying a GreptimeDB cluster with datanode groups on Kubernetes, including prerequisites, configuration, installation, and ...
- [Deploy GreptimeDB Cluster](https://docs.greptime.com/enterprise/deployments-administration/deploy-on-kubernetes/installation.md): Steps to install GreptimeDB Enterprise on Kubernetes, including obtaining images and starting GreptimeDB.
- [Deploy GreptimeDB on Kubernetes](https://docs.greptime.com/enterprise/deployments-administration/deploy-on-kubernetes/overview.md): Overview of deploying GreptimeDB on Kubernetes, including cluster installation, upgrades, and monitoring.
- [Upgrade](https://docs.greptime.com/enterprise/deployments-administration/deploy-on-kubernetes/upgrade.md): Steps to upgrade GreptimeDB on Kubernetes, including direct upgrade and upgrading clusters without using GreptimeDB Operator.
- [DR Solution Based on Active-Active Failover](https://docs.greptime.com/enterprise/deployments-administration/disaster-recovery/dr-solution-based-on-active-active-failover.md): Introduces the DR solution in GreptimeDB active-active failover architecture, focusing on bidirectional replicated writes, local query execution, a...
- [Disaster Recovery](https://docs.greptime.com/enterprise/deployments-administration/disaster-recovery/overview.md): Provides an overview of disaster recovery solutions in GreptimeDB Enterprise, especially the DR solution based on active-active failover, with link...
- [Audit Logging](https://docs.greptime.com/enterprise/deployments-administration/monitoring/audit-logging.md): Guide to configuring audit logging in GreptimeDB Enterprise, including examples and configuration options to monitor and record database activities.
- [Check GreptimeDB Status](https://docs.greptime.com/enterprise/deployments-administration/monitoring/check-db-status.md): Check GreptimeDB health status, deployment status, and runtime metrics through HTTP endpoints.
- [Key Logs](https://docs.greptime.com/enterprise/deployments-administration/monitoring/key-logs.md): Understand GreptimeDB's operational status and troubleshoot errors through key logs.
- [Key Metrics](https://docs.greptime.com/enterprise/deployments-administration/monitoring/key-metrics.md): Monitor key metrics of GreptimeDB clusters, including CPU, memory, disk I/O, and network bandwidth usage.
- [Monitoring](https://docs.greptime.com/enterprise/deployments-administration/monitoring/overview.md): GreptimeDB monitoring overview, introducing GreptimeDB monitoring metrics, configuration, and logs.
- [Self-Monitoring GreptimeDB Clusters](https://docs.greptime.com/enterprise/deployments-administration/monitoring/self-monitor-cluster.md): Complete guide to deploying self-monitoring for GreptimeDB enterprise clusters on Kubernetes, including GreptimeDB Enterprise Management Console se...
- [Deployments & Administration](https://docs.greptime.com/enterprise/deployments-administration/overview.md): Comprehensive deployment guide for GreptimeDB Enterprise, covering authentication options, Kubernetes deployment procedures, and operational monito...
- [Aggregation Queries](https://docs.greptime.com/enterprise/elasticsearch-compatible/aggregate.md): QueryDSL syntax supported by GreptimeDB Enterprise Edition
- [Overview](https://docs.greptime.com/enterprise/elasticsearch-compatible/overview.md): Overview of GreptimeDB Enterprise Edition's compatibility with Elasticsearch, including comparisons of data models, query syntax, and API interfaces.
- [Query](https://docs.greptime.com/enterprise/elasticsearch-compatible/query.md): QueryDSL syntax supported by GreptimeDB Enterprise Edition
- [Enterprise](https://docs.greptime.com/enterprise/overview.md): Overview of GreptimeDB Enterprise, detailing its advanced features, solutions, and enhancements over the open-source version to optimize data effic...
- [Manage Read Replicas](https://docs.greptime.com/enterprise/read-replicas/manage-read-replicas.md): An overview, key concepts, and step-by-step guides for managing read replicas in GreptimeDB Enterprise.
- [Overview](https://docs.greptime.com/enterprise/read-replicas/overview.md): Overview, principles, and how-tos of read replica feature in GreptimeDB Enterprise.
- [Query Read Replicas](https://docs.greptime.com/enterprise/read-replicas/query-read-replicas.md): Overview, key concepts, and step-by-step instructions for managing and querying read replicas in GreptimeDB Enterprise.
- [Release 24.11](https://docs.greptime.com/enterprise/release-notes/release-24_11.md): Release notes for GreptimeDB Enterprise version 24.11, highlighting new features like region rebalancing, management console, LDAP user provider, a...
- [GreptimeDB Enterprise 25.05](https://docs.greptime.com/enterprise/release-notes/release-25_05.md): Release notes for GreptimeDB Enterprise version 25.05, highlighting new features like elasticsearch compatibility, read replicas and triggers.
- [GreptimeDB Enterprise 25.11](https://docs.greptime.com/enterprise/release-notes/release-25_11.md): Release notes for GreptimeDB Enterprise version 25.05, highlighting new features like elasticsearch compatibility, read replicas and triggers.
- [Trigger](https://docs.greptime.com/enterprise/trigger.md): The overview of GreptimeDB Trigger.
- [GreptimeDB Table Engines](https://docs.greptime.com/reference/about-greptimedb-engines.md): Overview of all the table engines in GreptimeDB.
- [About GreptimeDB Version Number](https://docs.greptime.com/reference/about-greptimedb-version.md): Explanation of GreptimeDB's version numbering scheme, including the significance of major, minor, and revision numbers.
- [Datanode](https://docs.greptime.com/reference/command-lines/datanode.md): Comprehensive guide to GreptimeDB datanode command-line interface, including configuration options, startup commands, and practical examples for de...
- [Flownode](https://docs.greptime.com/reference/command-lines/flownode.md): Comprehensive guide to GreptimeDB flownode command-line interface, including configuration options, startup commands, and practical examples for de...
- [Frontend](https://docs.greptime.com/reference/command-lines/frontend.md): Comprehensive guide to GreptimeDB frontend command-line interface, including configuration options, startup commands, and practical examples for de...
- [Metasrv](https://docs.greptime.com/reference/command-lines/metasrv.md): Comprehensive guide to GreptimeDB metasrv command-line interface, including configuration options, startup commands, and practical examples for dep...
- [Overview](https://docs.greptime.com/reference/command-lines/overview.md): Comprehensive overview of the GreptimeDB command-line interface, including installation instructions, available commands, global options, and pract...
- [Standalone](https://docs.greptime.com/reference/command-lines/standalone.md): Comprehensive guide to GreptimeDB standalone command-line interface, including configuration options, startup commands, and practical examples for ...
- [Data Export & Import](https://docs.greptime.com/reference/command-lines/utilities/data.md): Introduction to GreptimeDB's data export and import tools for backing up and restoring database data, including command syntax, options.
- [Metadata Interaction](https://docs.greptime.com/reference/command-lines/utilities/metadata-interaction.md): Guide for interacting with GreptimeDB metadata using the CLI, including key-value, table metadata retrieval, and deletion.
- [Metadata Export & Import](https://docs.greptime.com/reference/command-lines/utilities/metadata.md): Comprehensive guide to GreptimeDB's metadata export and import tools for backing up and restoring database metadata, including command syntax, opti...
- [Repair logical tables](https://docs.greptime.com/reference/command-lines/utilities/repair-logical-tables.md): Guide for using CLI to repair logical tables in GreptimeDB cluster, including metadata consistency repair.
- [Repair partition columns](https://docs.greptime.com/reference/command-lines/utilities/repair-partition-columns.md): Guide for using CLI to repair partition columns in GreptimeDB cluster, including table metadata consistency repair.
- [GreptimeDB Glossary](https://docs.greptime.com/reference/glossary.md): The GreptimeDB Glossary provides clear definitions and explanations of core terms and concepts related to GreptimeDB, the cloud-native open source ...
- [gtctl](https://docs.greptime.com/reference/gtctl.md): Instructions for installing and using gtctl, a command-line tool for managing GreptimeDB clusters, including installation methods, autocompletion s...
- [HTTP API Endpoint List](https://docs.greptime.com/reference/http-endpoints.md): Provides a full list of HTTP paths and their usage in GreptimeDB, including admin APIs, query endpoints, and protocol endpoints.
- [Built-in Pipelines](https://docs.greptime.com/reference/pipeline/built-in-pipelines.md): Learn about GreptimeDB's built-in pipelines, including the greptime_identity pipeline for processing JSON logs with automatic schema creation, type...
- [Pipeline Configuration](https://docs.greptime.com/reference/pipeline/pipeline-config.md): Explains the configuration of pipelines in GreptimeDB for parsing and transforming log data, including processors and transform rules.
- [APIs for Writing Logs](https://docs.greptime.com/reference/pipeline/write-log-api.md): Describes how to write logs to GreptimeDB using a pipeline via the HTTP interface, including supported formats and request parameters.
- [ADMIN](https://docs.greptime.com/reference/sql/admin.md): Describes the `ADMIN` statement used to run administration functions, including examples for flushing tables, scheduling compactions, migrating reg...
- [ALTER](https://docs.greptime.com/reference/sql/alter.md): Describes the `ALTER` statement used to modify database options, table options, or metadata, including syntax and examples for altering databases a...
- [CASE](https://docs.greptime.com/reference/sql/case.md): Describes the `CASE` statement used for conditional logic within queries, including syntax and examples for usage in `SELECT`, `WHERE`, `GROUP BY`,...
- [CAST](https://docs.greptime.com/reference/sql/cast.md): Describes the `CAST` function used to convert an expression of one data type to another, including syntax and examples.
- [COMMENT](https://docs.greptime.com/reference/sql/comment.md): Covers the SQL COMMENT statement for adding or removing comments on tables, columns, and flows in GreptimeDB, including syntax and examples.
- [ANSI Compatibility](https://docs.greptime.com/reference/sql/compatibility.md): Describes the subset of ANSI SQL supported by GreptimeDB and its unique extensions, including major incompatibilities and extensions for table crea...
- [COPY](https://docs.greptime.com/reference/sql/copy.md): Describes the `COPY` statement used to export and import table or database data to and from files, including options for file format, time range, a...
- [CREATE](https://docs.greptime.com/reference/sql/create.md): Explains the SQL CREATE statement for creating databases, tables, external tables, flows, and views in GreptimeDB, including syntax, table constrai...
- [Data Types](https://docs.greptime.com/reference/sql/data-types.md): Provides an overview of SQL data types supported by GreptimeDB, including string, binary, numeric, decimal, date and time, interval, JSON, and bool...
- [DELETE](https://docs.greptime.com/reference/sql/delete.md): Details the SQL DELETE statement for removing rows from a table based on a specified condition, including syntax and examples.
- [DESCRIBE TABLE](https://docs.greptime.com/reference/sql/describe_table.md): Describes the SQL DESCRIBE TABLE statement to display the structure of a table, including column names, data types, keys, nullability, default valu...
- [DISTINCT](https://docs.greptime.com/reference/sql/distinct.md): Explains the SQL SELECT DISTINCT statement used to retrieve unique values from a dataset, with examples of using DISTINCT with and without filters.
- [DROP](https://docs.greptime.com/reference/sql/drop.md): Covers the SQL DROP statement for removing databases, tables, flows, and views in GreptimeDB, including syntax, examples.
- [EXPLAIN](https://docs.greptime.com/reference/sql/explain.md): Provides information on the SQL EXPLAIN statement to obtain the execution plan of a query, including the optional ANALYZE clause to measure executi...
- [Anomaly Detection Functions](https://docs.greptime.com/reference/sql/functions/anomaly.md): Lists and describes the anomaly detection window functions available in GreptimeDB, including Z-Score, MAD, and IQR-based scoring.
- [Approximate Functions](https://docs.greptime.com/reference/sql/functions/approximate.md): Lists and describes approximate functions available in GreptimeDB, including their usage and examples.
- [DataFusion Functions](https://docs.greptime.com/reference/sql/functions/df-functions.md): Generated from the Apache DataFusion project's documents, this page lists and describes DataFusion functions, including scalar, window, and array f...
- [Geospatial Functions](https://docs.greptime.com/reference/sql/functions/geo.md): Lists all geospatial related functions in GreptimeDB, including their usage, examples, and details on geospatial types, geohash, H3, S2, and encodi...
- [GreptimeDB Functions](https://docs.greptime.com/reference/sql/functions/greptimedb.md): GreptimeDB-specific SQL functions and extensions beyond DataFusion.
- [IP Functions](https://docs.greptime.com/reference/sql/functions/ip.md): Documentation for SQL functions related to IP address manipulation, conversion between string/numeric formats, CIDR notation, and range checking fo...
- [JSON Functions (Experimental)](https://docs.greptime.com/reference/sql/functions/json.md): Lists and describes JSON functions available in GreptimeDB, including their usage and examples.
- [Functions](https://docs.greptime.com/reference/sql/functions/overview.md): Provides an overview of the SQL functions available in GreptimeDB, including categories and examples of their usage.
- [Vector Functions](https://docs.greptime.com/reference/sql/functions/vector.md): Lists and describes vector functions available in GreptimeDB, including their usage and examples.
- [Greptime Private](https://docs.greptime.com/reference/sql/greptime-private/overview.md): The overview of system tables in the `greptime_private` database.
- [pipelines](https://docs.greptime.com/reference/sql/greptime-private/pipelines.md): The pipelines table in the `greptime_private` database.
- [slow_queries](https://docs.greptime.com/reference/sql/greptime-private/slow_queries.md): The slow queries table in the `greptime_private` database.
- [GROUP BY](https://docs.greptime.com/reference/sql/group_by.md): Details the SQL GROUP BY clause used to group rows with the same values in specified columns, typically used with aggregate functions like COUNT, S...
- [HAVING](https://docs.greptime.com/reference/sql/having.md): Describes the HAVING clause in SQL, which is used to filter rows for aggregate functions.
- [Alerts](https://docs.greptime.com/reference/sql/information-schema/alerts.md): Provides the information about alert instances generated by triggers, including labels, timestamps, status, and other details.
- [BUILD_INFO](https://docs.greptime.com/reference/sql/information-schema/build-info.md): Contains build information for the SQL information schema, including version details, build date, and other relevant metadata.
- [CHARACTER_SETS](https://docs.greptime.com/reference/sql/information-schema/character-sets.md): Provides details on the character sets available in the SQL information schema, including how to use and manage different character sets.
- [CLUSTER_INFO](https://docs.greptime.com/reference/sql/information-schema/cluster-info.md): Contains information about the cluster configuration and status within the SQL information schema, including nodes, roles, and other cluster-relate...
- [COLLATION_CHARACTER_SET_APPLICABILITY](https://docs.greptime.com/reference/sql/information-schema/collation-character-set-applicability.md): Describes the applicability of collation character sets within the SQL information schema, detailing how they can be applied and managed.
- [COLLATIONS](https://docs.greptime.com/reference/sql/information-schema/collations.md): Provides information about the collations available in the SQL information schema, including details on how to use and manage them.
- [COLUMNS](https://docs.greptime.com/reference/sql/information-schema/columns.md): Provides detailed information about columns in tables, including column names, data types, default values, and other attributes.
- [ENGINES](https://docs.greptime.com/reference/sql/information-schema/engines.md): Provides information about storage engines, including their support level, comments, and whether they support transactions, XA transactions, and sa...
- [FLOWS](https://docs.greptime.com/reference/sql/information-schema/flows.md): Provides the flow task information, including flow name, ID, definition, source table IDs, sink table name, and other details.
- [KEY_COLUMN_USAGE](https://docs.greptime.com/reference/sql/information-schema/key-column-usage.md): Describes the key constraints of the columns, such as the time index key constraint.
- [INFORMATION_SCHEMA](https://docs.greptime.com/reference/sql/information-schema/overview.md): Provides access to system metadata, such as database or table names, column data types, and INFORMATION_SCHEMA tables for querying GreptimeDB syste...
- [PARTITIONS](https://docs.greptime.com/reference/sql/information-schema/partitions.md): Provides information about partitioned tables, including partition names, methods, expressions, and other details.
- [PROCEDURE_INFO](https://docs.greptime.com/reference/sql/information-schema/procedure-info.md): Provides detailed information about various procedures, including procedure ID, type, start and end time, status, and locked keys.
- [PROCESS_LIST](https://docs.greptime.com/reference/sql/information-schema/process-list.md): Provides a view of running queries in cluster.
- [REGION_PEERS](https://docs.greptime.com/reference/sql/information-schema/region-peers.md): Shows detailed information of a single Region node in GreptimeDB, such as whether it is a learner or leader.
- [REGION_STATISTICS](https://docs.greptime.com/reference/sql/information-schema/region-statistics.md): Provides detailed information about a region's statistics, including the total number of rows, disk size, and more. These statistics are approximat...
- [RUNTIME_METRICS](https://docs.greptime.com/reference/sql/information-schema/runtime-metrics.md): Provides information about the `RUNTIME_METRICS` table, which includes system runtime metrics from the `/metrics` HTTP endpoint output in the cluster.
- [SCHEMATA](https://docs.greptime.com/reference/sql/information-schema/schemata.md): Provides information about databases, including details about each database's catalog, schema name, default character set, collation, and options.
- [SSTS_INDEX_META](https://docs.greptime.com/reference/sql/information-schema/ssts-index-meta.md): Provides access to SST (Sorted String Table) index metadata, including information about inverted indexes, fulltext indexes, and bloom filters stor...
- [SSTS_MANIFEST](https://docs.greptime.com/reference/sql/information-schema/ssts-manifest.md): Provides access to SST (Sorted String Table) file information from the manifest, including file paths, sizes, time ranges, and row counts.
- [SSTS_STORAGE](https://docs.greptime.com/reference/sql/information-schema/ssts-storage.md): Provides access to SST (Sorted String Table) file information from the storage layer, including file paths, sizes, and last modified timestamps.
- [TABLE_CONSTRAINTS](https://docs.greptime.com/reference/sql/information-schema/table-constraints.md): Describes which tables have constraints, including details about each constraint's catalog, schema, name, type, and enforcement status.
- [TABLES](https://docs.greptime.com/reference/sql/information-schema/tables.md): Provides information about tables in databases, including details about each table's catalog, schema, name, type, and other properties.
- [Triggers](https://docs.greptime.com/reference/sql/information-schema/triggers.md): Provides metadata about triggers, including name, ID, SQL definition, interval, labels, annotations, and related configurations.
- [VIEWS](https://docs.greptime.com/reference/sql/information-schema/views.md): Provides a list of views that the current user has visibility of, including details about each view's catalog, schema, name, definition, and other ...
- [INSERT](https://docs.greptime.com/reference/sql/insert.md): Describes the SQL INSERT statement for adding records to a table in GreptimeDB, including syntax, examples for inserting single and multiple record...
- [JOIN](https://docs.greptime.com/reference/sql/join.md): Explains the usage of SQL JOIN clauses to combine rows from multiple tables based on related columns, including INNER JOIN, LEFT JOIN, RIGHT JOIN, ...
- [LIMIT](https://docs.greptime.com/reference/sql/limit.md): Describes the LIMIT clause in SQL for restricting the number of rows returned by a query, including syntax and examples.
- [OFFSET](https://docs.greptime.com/reference/sql/offset.md): Describes the OFFSET clause in SQL, which specifies how many rows to skip before starting to return rows from a query.
- [ORDER BY](https://docs.greptime.com/reference/sql/order_by.md): Details the ORDER BY clause in SQL for sorting data in ascending or descending order based on one or more columns, with syntax and examples.
- [SQL](https://docs.greptime.com/reference/sql/overview.md): GreptimeDB SQL statements.
- [RANGE QUERY](https://docs.greptime.com/reference/sql/range.md): Explains range queries in SQL for time series data, including syntax, FILL options, TO options, BY options, ORDER BY in aggregate functions, and ne...
- [REPLACE](https://docs.greptime.com/reference/sql/replace.md): Describes the SQL REPLACE statement for adding records to a table in GreptimeDB, including syntax, examples for inserting single and multiple records.
- [SELECT](https://docs.greptime.com/reference/sql/select.md): Describes the SELECT statement in SQL for retrieving data from tables, including syntax, filtering with WHERE, limiting results with LIMIT, joining...
- [SHOW](https://docs.greptime.com/reference/sql/show.md): Provides information on the SHOW keyword in SQL for displaying database and table details, including various SHOW commands with syntax and examples.
- [TQL](https://docs.greptime.com/reference/sql/tql.md): Covers the TQL keyword for executing Time-Series Query Language in SQL, including EVAL, EXPLAIN, and ANALYZE commands with syntax and examples.
- [Trigger Syntax](https://docs.greptime.com/reference/sql/trigger-syntax.md): This document provides more details about the GreptimeDB Trigger.
- [TRUNCATE](https://docs.greptime.com/reference/sql/truncate.md): Details the TRUNCATE TABLE statement in SQL, used for efficiently deleting all data from a table, with syntax and example.
- [WHERE](https://docs.greptime.com/reference/sql/where.md): Explains the WHERE clause in SQL for filtering data based on conditions, including syntax, examples with logical and comparison operators, and list...
- [WITH](https://docs.greptime.com/reference/sql/with.md): Describes the usage of the WITH clause to define Common Table Expressions (CTEs) in SQL, including syntax, examples of non-recursive CTEs, and note...
- [SQL Tools](https://docs.greptime.com/reference/sql-tools.md): Guide on using SQL tools with GreptimeDB, including recommended libraries, installation, connection setup, and usage examples for Java and Go.
- [Telemetry](https://docs.greptime.com/reference/telemetry.md): Details on telemetry data collection in GreptimeDB, including what data is collected, how often, and how to enable or disable telemetry.
- [Time Durations](https://docs.greptime.com/reference/time-durations.md): Learn how GreptimeDB utilizes time durations to represent time spans in SQL queries, configuration files, and API requests with supported suffixes ...
- [Frequently Asked Questions](https://docs.greptime.com/faq-and-others/faq.md): Frequently Asked Questions about GreptimeDB — covering data model, integration, deployment, operations, and versioning.
- [FAQ and Others](https://docs.greptime.com/faq-and-others/overview.md): In this section, we present the most frequently asked questions and some additional information.
- [Vibe Coding](https://docs.greptime.com/faq-and-others/vibecoding.md): GreptimeDB 的 Coding Agent 资源
- [Data Persistence and Indexing](https://docs.greptime.com/contributor-guide/datanode/data-persistence-indexing.md): Explanation of data persistence and indexing in GreptimeDB, including SST file format, indexing methods, and the use of OpenDAL.
- [Metric Engine](https://docs.greptime.com/contributor-guide/datanode/metric-engine.md): Overview of the Metric engine in GreptimeDB, its concepts, architecture, and design for handling small tables.
- [Datanode](https://docs.greptime.com/contributor-guide/datanode/overview.md): Overview of Datanode in GreptimeDB, its responsibilities, components, and interaction with other parts of the system.
- [Query Engine](https://docs.greptime.com/contributor-guide/datanode/query-engine.md): Overview of GreptimeDB's query engine, its architecture, data representation, indexing, and extensibility.
- [Storage Engine](https://docs.greptime.com/contributor-guide/datanode/storage-engine.md): Overview of the storage engine in GreptimeDB, its architecture, components, and data model.
- [Write-Ahead Logging](https://docs.greptime.com/contributor-guide/datanode/wal.md): Introduction to Write-Ahead Logging (WAL) in GreptimeDB, its purpose, architecture, and operational modes.
- [Arrangement](https://docs.greptime.com/contributor-guide/flownode/arrangement.md): Details on the arrangement component in Flownode, which stores state and update streams for querying and updating.
- [Flownode Batching Mode Developer Guide](https://docs.greptime.com/contributor-guide/flownode/batching_mode.md): Overview of Flownode's batching mode, a component providing continuous data aggregation capabilities to the database, including its architecture an...
- [Dataflow](https://docs.greptime.com/contributor-guide/flownode/dataflow.md): Explanation of the dataflow module in Flownode, its operations, internal data handling, and future enhancements.
- [Flownode](https://docs.greptime.com/contributor-guide/flownode/overview.md): Overview of Flownode, a component providing streaming process capabilities to the database, including its components and current limitations.
- [Distributed Querying](https://docs.greptime.com/contributor-guide/frontend/distributed-querying.md): Describes the process of distributed querying in GreptimeDB, focusing on the dist planner and dist plan.
- [Frontend](https://docs.greptime.com/contributor-guide/frontend/overview.md): Overview of GreptimeDB's Frontend component - a stateless proxy service for client requests.
- [Table Sharding](https://docs.greptime.com/contributor-guide/frontend/table-sharding.md): Explains how table data in GreptimeDB is sharded and distributed, including the concepts of partition and region.
- [Getting started](https://docs.greptime.com/contributor-guide/getting-started.md): Instructions for setting up and running GreptimeDB from source, including prerequisites, build dependencies, and running unit tests.
- [How to trace GreptimeDB](https://docs.greptime.com/contributor-guide/how-to/how-to-trace-greptimedb.md): Describes how to use Rust's tracing framework in GreptimeDB for distributed tracing, including defining tracing context in RPC, passing it, and ins...
- [How to use tokio-console in GreptimeDB](https://docs.greptime.com/contributor-guide/how-to/how-to-use-tokio-console.md): Guides on using tokio-console in GreptimeDB, including building with specific features and connecting to the tokio console subscriber.
- [How to write a gRPC SDK for GreptimeDB](https://docs.greptime.com/contributor-guide/how-to/how-to-write-sdk.md): Explains how to write a gRPC SDK for GreptimeDB, focusing on the GreptimeDatabase service, its methods, and the structure of requests and responses.
- [Admin API](https://docs.greptime.com/contributor-guide/metasrv/admin-api.md): Details the Admin API for Metasrv, including endpoints for health checks, leader queries, heartbeat data, and maintenance mode.
- [Metasrv](https://docs.greptime.com/contributor-guide/metasrv/overview.md): Provides an overview of the Metasrv service, its components, interactions with the Frontend, architecture, and key functionalities like distributed...
- [Selector](https://docs.greptime.com/contributor-guide/metasrv/selector.md): Describes the different types of selectors in the Metasrv service, their characteristics, and how to configure them.
- [Contributor Guide](https://docs.greptime.com/contributor-guide/overview.md): Overview of GreptimeDB's architecture, key components, and how they interact to process user requests.
- [Integration Test](https://docs.greptime.com/contributor-guide/tests/integration-test.md): Guide on writing and running integration tests in GreptimeDB, covering scenarios involving multiple components.
- [Tests](https://docs.greptime.com/contributor-guide/tests/overview.md): Overview of the testing methods used in GreptimeDB to ensure its behavior and performance.
- [Sqlness Test](https://docs.greptime.com/contributor-guide/tests/sqlness-test.md): Instructions for running SQL tests in GreptimeDB using the `sqlness` test suite, including file types, case organization, and running tests.
- [Unit Test](https://docs.greptime.com/contributor-guide/tests/unit-test.md): Guide on writing and running unit tests in GreptimeDB using Rust's `#[test]` attribute and `cargo nextest`.
- [Create Service](https://docs.greptime.com/greptimecloud/getting-started/create-service.md): To experience the full power of GreptimeCloud, you need to create a service which contains a database with authentication. Open the [GreptimeCloud ...
- [Go](https://docs.greptime.com/greptimecloud/getting-started/go.md): Instructions on creating a service, writing data using Go, and visualizing data in GreptimeDB.
- [InfluxDB Line Protocol](https://docs.greptime.com/greptimecloud/getting-started/influxdb.md): Instructions on creating a service, writing data using InfluxDB Line Protocol, and visualizing data in GreptimeDB.
- [Java](https://docs.greptime.com/greptimecloud/getting-started/java.md): Instructions on creating a service, writing data using Java, and visualizing data in GreptimeDB.
- [MySQL](https://docs.greptime.com/greptimecloud/getting-started/mysql.md): Instructions on creating a service, writing data using MySQL, and visualizing data in GreptimeDB.
- [Node.js](https://docs.greptime.com/greptimecloud/getting-started/node.md): Instructions on creating a service, writing data using Node.js, and visualizing data in GreptimeDB.
- [Getting Started](https://docs.greptime.com/greptimecloud/getting-started/overview.md): Overview of getting started with GreptimeCloud.
- [Prometheus](https://docs.greptime.com/greptimecloud/getting-started/prometheus.md): Instructions on creating a service, writing data using Prometheus, and visualizing data in GreptimeDB.
- [Python](https://docs.greptime.com/greptimecloud/getting-started/python.md): Instructions on creating a service, writing data using Python, and visualizing data in GreptimeDB.
- [Vector](https://docs.greptime.com/greptimecloud/getting-started/vector.md): Instructions on creating a service, writing data using Vector, and visualizing data in GreptimeDB.
- [Visualize Data](https://docs.greptime.com/greptimecloud/getting-started/visualize-data.md): After successfully writing data to the service, you can view the data on the GreptimeCloud dashboard. The dashboard provides a variety of visualiza...
- [Langchain](https://docs.greptime.com/greptimecloud/greptimeai/langchain.md): ```python
- [Openai](https://docs.greptime.com/greptimecloud/greptimeai/openai.md): ```python
- [Alloy](https://docs.greptime.com/greptimecloud/integrations/alloy.md): Instructions on integrating GreptimeCloud with Grafana Alloy for Prometheus Remote Write and OpenTelemetry.
- [DBeaver](https://docs.greptime.com/greptimecloud/integrations/dbeaver.md): Guide on using DBeaver to connect to GreptimeCloud via MySQL database drivers.
- [EMQX Platform](https://docs.greptime.com/greptimecloud/integrations/emqx.md): Instructions on configuring GreptimeCloud as a data sink in EMQX Platform for IoT data ingestion.
- [Fluent Bit](https://docs.greptime.com/greptimecloud/integrations/fluent-bit.md): Guide for using Fluent Bit with GreptimeCloud, including configuration for metrics and logs ingestion, and running Fluent Bit with a sample configu...
- [Grafana](https://docs.greptime.com/greptimecloud/integrations/grafana.md): Guide on configuring GreptimeCloud as a data source in Grafana using GreptimeDB, Prometheus, or MySQL data sources.
- [InfluxDB and Telegraf](https://docs.greptime.com/greptimecloud/integrations/influxdb.md): Instructions on using InfluxDB line protocol and Telegraf to ingest data into GreptimeCloud.
- [Kafka](https://docs.greptime.com/greptimecloud/integrations/kafka.md): Guide on using Kafka with Vector to ingest logs and metrics data into GreptimeCloud.
- [Metabase](https://docs.greptime.com/greptimecloud/integrations/metabase.md): Instructions on configuring GreptimeCloud as a data source in Metabase using a community driver plugin.
- [MindsDB](https://docs.greptime.com/greptimecloud/integrations/mindsdb.md): Guide on configuring GreptimeCloud as a data source in MindsDB for machine learning capabilities.
- [MySQL](https://docs.greptime.com/greptimecloud/integrations/mysql.md): Instructions for connecting to GreptimeCloud using MySQL protocol, including connection details, MySQL CLI, MariaDB CLI, and JDBC URL.
- [OpenTelemetry](https://docs.greptime.com/greptimecloud/integrations/otlp.md): Guide for using GreptimeDB as an observability backend with OpenTelemetry, including API/SDK configuration and OpenTelemetry Collector setup.
- [PostgreSQL](https://docs.greptime.com/greptimecloud/integrations/postgresql.md): Instructions for connecting to GreptimeCloud using PostgreSQL protocol, including connection details, psql CLI, connection strings, and JDBC URL.
- [Prometheus](https://docs.greptime.com/greptimecloud/integrations/prometheus.md): Guide for integrating Prometheus with GreptimeCloud, including remote write configuration, HTTP API access, and using PromQL.
- [Go SDK](https://docs.greptime.com/greptimecloud/integrations/sdk-libraries/go.md): Instructions on how to use the GreptimeDB Go SDK to connect to GreptimeCloud using gRPC.
- [Java SDK](https://docs.greptime.com/greptimecloud/integrations/sdk-libraries/java.md): Instructions on how to use the GreptimeDB Java SDK to connect to GreptimeCloud using gRPC.
- [Streamlit](https://docs.greptime.com/greptimecloud/integrations/streamlit.md): Instructions for using GreptimeCloud with Streamlit to build data apps, including creating a SQL connection and running SQL queries.
- [Superset](https://docs.greptime.com/greptimecloud/integrations/superset.md): Guide for configuring GreptimeCloud as a data source in Superset, including connection information and SQLAlchemy URL format.
- [Vector](https://docs.greptime.com/greptimecloud/integrations/vector.md): Guide for using Vector with GreptimeCloud, including configuration for metrics and logs ingestion, and running Vector with a sample configuration.
- [Migrate from InfluxDB](https://docs.greptime.com/greptimecloud/migrate-to-greptimecloud/migrate-from-influxdb.md): Instructions for migrating from InfluxDB to GreptimeCloud, including database connection, writing data using HTTP API, Telegraf, client libraries, ...
- [Migrate from Prometheus](https://docs.greptime.com/greptimecloud/migrate-to-greptimecloud/migrate-from-prometheus.md): Instructions for migrating from Prometheus to GreptimeCloud, including configuring remote write, querying with PromQL, and integrating with Grafana.
- [GreptimeCloud](https://docs.greptime.com/greptimecloud/overview.md): Provides an overview of GreptimeCloud, a fully-managed serverless GreptimeDB service for scalable and efficient time-series data management.
- [Billing](https://docs.greptime.com/greptimecloud/usage-&-billing/billing.md): Explains the billing process, invoice generation, usage tracking, and cost calculation for different plans in GreptimeCloud.
- [Dedicated Plan](https://docs.greptime.com/greptimecloud/usage-&-billing/dedicated.md): Details the Dedicated Plan, including dedicated CPUs, storage, resource isolation, and cost calculation for GreptimeCloud.
- [Hobby Plan](https://docs.greptime.com/greptimecloud/usage-&-billing/hobby.md): Describes the free tier Hobby Plan, its limitations, and the data retention policy for GreptimeCloud users.
- [Usage and Billing](https://docs.greptime.com/greptimecloud/usage-&-billing/overview.md): Provides an overview of the usage and billing documents for Greptime Cloud, including links to detailed guides on various plans and capacity units.
- [Request Capacity Unit](https://docs.greptime.com/greptimecloud/usage-&-billing/request-capacity-unit.md): Introduces the calculation algorithms for request capacity units (WCU and RCU) and provides tips for optimizing CU usage.
- [Serverless Plan](https://docs.greptime.com/greptimecloud/usage-&-billing/serverless.md): Details the Serverless Plan, including request capacities, support, cost calculation, and billing information.
- [Shared Storage Capacity](https://docs.greptime.com/greptimecloud/usage-&-billing/shared-storage-capacity.md): GreptimeCloud stores your data in object storage, such as S3, and calculates storage costs based on your total data size in the database. You'll be...
- [Monitor Kubernetes Metrics with Prometheus and GreptimeDB](https://docs.greptime.com/tutorials/k8s-metrics-monitor.md): Guide to monitoring Kubernetes metrics using Prometheus with GreptimeDB as the storage backend, including architecture overview, installation, and ...