CrateDB 4.6 Documentation

CrateDB 4.6 参考手册：分布式 SQL 数据库的安装部署、SQL 语法与内置函数、表结构与分片/副本、集群复制与管理、数据导入导出、查询性能调优、安全认证与运维，以及各版本变更说明与术语表。

全书结构

• SUMMARY.md
• Tutorials
• Installation
• First use
• Create user
• Create sharded table
• Generate time series data
• Normalize time series data intervals
• How-To Guides
• CrateDB and Linux
• Run CrateDB on Debian GNU/Linux
• Run CrateDB on Red Hat Linux
• Run CrateDB on Ubuntu
• CrateDB and containers
• Run CrateDB on Docker
• Run CrateDB on Kubernetes
• CrateDB and cloud hosting
• Run CrateDB on Amazon Web Services (AWS)
• Run CrateDB on Microsoft Azure
• Rolling upgrade
• Full restart upgrade
• Bootstrap checks
• CrateDB multi-node setup
• CrateDB multi-zone setup
• Scaling CrateDB on Kubernetes
• Memory configuration
• Sharding guide
• Insert performance
• Insert methods
• Bulk inserts
• Parallel inserts
• Configuration tuning for inserts
• Testing inserts performance
• Select performance
• Migrating from MySQL
• Migrating from MongoDB
• Troubleshooting with sys-tables
• Troubleshooting with the crate-node command
• CrateDB on Azure IoT
• Distributed Machine Learning At The Edge
• Data Ingestion using Kafka and Kafka Connect
• Data Stream Pipelines with CrateDB and StreamSets Data Collector
• Data Enrichment using IoT Hubs, Azure Functions and CrateDB
• CrateDB with R
• Reports with CrateDB and Power BI Desktop
• Real Time Reports with CrateDB and Power BI
• Distributed Deep-Learning with CrateDB and TensorFlow
• Troubleshooting CrateDB on Docker with jcmd
• Reference
• Concepts
• Joins
• Clustering
• Storage and consistency
• Resiliency
• CLI tools
• Configuration
• Node-specific settings
• Cluster-wide settings
• Session settings
• Logging
• Environment variables
• General use
• Data definition
• Creating tables
• Data types
• System columns
• Generated columns
• Constraints
• Storage
• Partitioned tables
• Sharding
• Replication
• Shard allocation filtering
• Column policy
• Fulltext indices
• Fulltext analyzers
• Show Create Table
• Views
• Altering tables
• Data manipulation
• Querying
• Selecting data
• Joins
• Union All
• Refresh
• Fulltext search
• Geo search
• Built-in functions and operators
• Scalar functions
• Aggregation
• Arithmetic operators
• Table functions
• Comparison operators
• Array comparisons
• Subquery expressions
• Window functions
• User-defined functions
• Blobs
• Optimistic Concurrency Control
• Information schema
• Administration
• System information
• Runtime configuration
• User management
• Privileges
• Authentication
• Authentication Methods
• Host-Based Authentication (HBA)
• Secured communications (SSL/TLS)
• Optimization
• Jobs management
• JMX monitoring
• Snapshots
• Cloud discovery
• Usage Data Collector
• SQL syntax
• General SQL
• Constraints
• Value expressions
• Lexical structure
• SQL Statements
• ALTER CLUSTER
• ALTER TABLE
• ALTER USER
• ANALYZE
• BEGIN
• START TRANSACTION
• COMMIT
• COPY FROM
• COPY TO
• CREATE ANALYZER
• CREATE BLOB TABLE
• CREATE FUNCTION
• CREATE REPOSITORY
• CREATE SNAPSHOT
• CREATE TABLE
• CREATE TABLE AS
• CREATE USER
• CREATE VIEW
• DEALLOCATE
• DELETE
• DENY
• DISCARD
• DROP ANALYZER
• DROP FUNCTION
• DROP REPOSITORY
• DROP SNAPSHOT
• DROP TABLE
• DROP USER
• DROP VIEW
• EXPLAIN
• GRANT
• INSERT
• KILL
• OPTIMIZE
• REFRESH
• RESTORE SNAPSHOT
• REVOKE
• SELECT
• SET and RESET
• SET LICENSE
• SET AND RESET SESSION AUTHORIZATION
• SET TRANSACTION
• SHOW COLUMNS
• SHOW CREATE TABLE
• SHOW SCHEMAS
• SHOW TABLES
• SHOW (session settings)
• UPDATE
• VALUES
• Client interfaces
• HTTP endpoint
• PostgreSQL wire protocol
• Appendices
• Release Notes
• Unreleased Changes
• Version 4.6.1
• Version 4.6.0
• Version 4.5.4
• Version 4.5.3
• Version 4.5.2
• Version 4.5.1
• Version 4.5.0
• Version 4.4.3
• Version 4.4.2
• Version 4.4.1
• Version 4.4.0
• Version 4.3.4
• Version 4.3.3
• Version 4.3.2
• Version 4.3.1
• Version 4.3.0
• Version 4.2.7
• Version 4.2.6
• Version 4.2.5
• Version 4.2.4
• Version 4.2.3
• Version 4.2.2
• Version 4.2.1
• Version 4.2.0
• Version 4.1.8
• Version 4.1.7
• Version 4.1.6
• Version 4.1.5
• Version 4.1.4
• Version 4.1.3
• Version 4.1.2
• Version 4.1.1
• Version 4.1.0
• Version 4.0.12
• Version 4.0.11
• Version 4.0.10
• Version 4.0.9
• Version 4.0.8
• Version 4.0.7
• Version 4.0.6
• Version 4.0.5
• Version 4.0.4
• Version 4.0.3
• Version 4.0.2
• Version 4.0.1
• Version 4.0.0
• Version 3.3.6
• Version 3.3.5
• Version 3.3.4
• Version 3.3.3
• Version 3.3.2
• Version 3.3.1
• Version 3.3.0
• Version 3.2.8
• Version 3.2.7
• Version 3.2.6
• Version 3.2.5
• Version 3.2.4
• Version 3.2.3
• Version 3.2.2
• Version 3.2.1
• Version 3.2.0
• Version 3.1.6
• Version 3.1.5
• Version 3.1.4
• Version 3.1.3
• Version 3.1.2
• Version 3.1.1
• Version 3.1.0
• Version 3.0.7
• Version 3.0.6
• Version 3.0.5
• Version 3.0.4
• Version 3.0.3
• Version 3.0.2
• Version 3.0.1
• Version 3.0.0
• Version 2.3.11
• Version 2.3.10
• Version 2.3.9
• Version 2.3.8
• Version 2.3.7
• Version 2.3.6
• Version 2.3.5
• Version 2.3.4
• Version 2.3.3
• Version 2.3.2
• Version 2.3.1
• Version 2.3.0
• Version 2.2.7
• Version 2.2.6
• Version 2.2.5
• Version 2.2.4
• Version 2.2.3
• Version 2.2.2
• Version 2.2.1
• Version 2.2.0
• Version 2.1.10
• Version 2.1.9
• Version 2.1.8
• Version 2.1.7
• Version 2.1.6
• Version 2.1.5
• Version 2.1.4
• Version 2.1.3
• Version 2.1.2
• Version 2.1.1
• Version 2.1.0
• Version 2.0.7
• Version 2.0.6
• Version 2.0.5
• Version 2.0.4
• Version 2.0.3
• Version 2.0.2
• Version 2.0.1
• Version 2.0.0
• Version 1.2.0
• Version 1.1.6
• Version 1.1.5
• Version 1.1.4
• Version 1.1.3
• Version 1.1.2
• Version 1.1.1
• Version 1.1.0
• Version 1.0.6
• Version 1.0.5
• Version 1.0.4
• Version 1.0.3
• Version 1.0.2
• Version 1.0.1
• Version 1.0.0
• SQL compatibility
• SQL standard compliance
• Resiliency Issues
• Glossary

开篇导读

整理人:豆包AI助手