ClickHouse v21.2 Documentation
首页
白天
夜间
下载
阅读记录
书签管理
我的书签
添加书签
移除书签
编辑文档
ORDER BY
来源 1
浏览
521
扫码
打印
2021-03-09 08:09:52
Manipulating Key Expressions
上一篇:
下一篇:
发布点评
Introduction
Adopters
Information support
Overview
Distinctive Features
Performance
History
F.A.Q.
General
Why ClickHouse is so fast?
What does “Не тормозит” mean?
What is OLAP?
Why not use something like MapReduce?
What does “ClickHouse” mean?
Who is using ClickHouse?
What is a columnar database?
Integration
How do I export data from ClickHouse to a file?
What if I have a problem with encodings when connecting to Oracle via ODBC?
How to import JSON into ClickHouse?
Use Cases
Can I use ClickHouse as a key-value storage?
Can I use ClickHouse as a time-series database?
Operations
Which ClickHouse version to use in production?
Is it possible to delete old records from a ClickHouse table?
What’s New
Security Changelog
What’s New in ClickHouse?
Roadmap
Changelog
2017
2018
2019
2020
2021
Getting Started
Playground
Tutorial
Installation
Example Datasets
Star Schema Benchmark
Yandex.Metrica Data
Terabyte Click Logs from Criteo
New York Taxi Data
Introduction
OnTime
Brown University Benchmark
AMPLab Big Data Benchmark
GitHub Events
WikiStat
Cell Towers
Recipes Dataset
Interfaces
Input and Output Formats
Command-Line Client
HTTP Interface
Introduction
C++ Client Library
Native Interface (TCP)
JDBC Driver
ODBC Driver
MySQL Interface
Third-Party
Client Libraries
Integrations
Visual Interfaces
Proxies
Third-Party Interfaces
Engines
Table Engines
Introduction
MergeTree Family
VersionedCollapsingMergeTree
Custom Partitioning Key
AggregatingMergeTree
Data Replication
SummingMergeTree
MergeTree
CollapsingMergeTree
GraphiteMergeTree
ReplacingMergeTree
Introduction
Log Family
TinyLog
StripeLog
Introduction
Log
Integrations
JDBC
MongoDB
HDFS
MySQL
RabbitMQ
S3
Kafka
EmbeddedRocksDB
ODBC
Table Engines for Integrations
Special
Merge
Dictionary
External Data
Special Table Engines
Buffer
Memory
MaterializedView
URL
View
Set
Join
File
Distributed
GenerateRandom
Null
Database Engines
Lazy
MySQL
Atomic
Introduction
MaterializeMySQL
SQL Reference
Operators
IN Operators
Operators
ANSI Compatibility
Window Functions
Window Functions
Statements
SELECT
WHERE
LIMIT
PREWHERE
GROUP BY
UNION
WITH
Overview
FROM
ALL
INTO OUTFILE
LIMIT BY
SAMPLE
JOIN
ORDER BY
INSERT INTO
FORMAT
DISTINCT
HAVING
ARRAY JOIN
CREATE
DATABASE
Overview
VIEW
USER
DICTIONARY
ROLE
TABLE
ROW POLICY
SETTINGS PROFILE
QUOTA
ALTER
INDEX
Syntax
SETTINGS PROFILE
TTL
Distributed DDL
CHECK
COLUMN
SHOW
USE
OPTIMIZE
WATCH
REVOKE
TRUNCATE
DETACH
ALTER
SAMPLE BY
QUOTA
ROW POLICY
ROLE
GRANT
SET ROLE
PARTITION
DELETE
UPDATE
EXPLAIN
DROP
USER
EXISTS
DESCRIBE
ATTACH
CONSTRAINT
SET
ORDER BY
RENAME
KILL
SYSTEM
Functions
Splitting and Merging Strings and Arrays
Encoding
URLs
Hash
arrayJoin
JSON
Arrays
Dates and Times
Type Conversion
Pseudo-Random Numbers
Bit
Array
Strings
For Searching in Strings
Comparison
Introduction
Logical
Bitmap
Working with maps
Mathematical
External Dictionaries
Conditional
UUID
Arithmetic
Yandex.Metrica Dictionaries
IP Addresses
For Replacing in Strings
Rounding
IN Operator
Geo
Nullable
Tuples
Encryption
Other
Machine Learning
H3 Indexes
Geohash
Introspection
Geographical Coordinates
Aggregate Functions
Introduction
Reference
categoricalInformationValue
any
kurtPop
argMax
count
groupArrayInsertAt
sumWithOverflow
uniqCombined64
quantileTDigestWeighted
sum
simpleLinearRegression
avgWeighted
groupArrayMovingAvg
groupBitAnd
argMin
groupArraySample
stochasticLogisticRegression
varPop(x)
uniq
corr
stddevSamp
groupBitXor
quantileDeterministic
studentTTest
groupArray
min
quantileExact
uniqHLL12
stochasticLinearRegression
Parametric
quantileExactWeighted
quantile
quantileTDigest
groupArrayMovingSum
kurtSamp
median
initializeAggregation
minMap
covarSamp
rankCorr
avg
groupBitmapOr
covarPop
uniqCombined
skewPop
groupUniqArray
Combinators
varSamp
maxMap
groupBitmap
sumMap
groupBitmapXor
groupBitOr
max
quantileTimingWeighted
stddevPop
quantileTiming
deltaSum
topK
anyHeavy
mannWhitneyUTest
topKWeighted
skewSamp
quantiles
groupBitmapAnd
anyLast
welchTTest
uniqExact
Table Functions
merge
Introduction
null function
numbers
remote
file
input
url
cluster
odbc
jdbc
mysql
generateRandom
s3
view
hdfs
Dictionaries
Introduction
External Dictionaries
Sources of External Dictionaries
Polygon Dictionaries With Grids
Internal Dictionaries
Configuring an External Dictionary
Hierarchical dictionaries
General Description
Dictionary Key and Fields
Dictionary Updates
Storing Dictionaries in Memory
Data Types
Decimal
Date
Boolean
Array(T)
FixedString(N)
AggregateFunction
Introduction
Enum
String
DateTime
UInt8, UInt16, UInt32, UInt64, UInt256, Int8, Int16, Int32, Int64, Int128, Int256
LowCardinality
Float32, Float64
DateTime64
UUID
Nested Data Structures
Tuple(T1, T2, …)
Nullable
Nested(Name1 Type1, Name2 Type2, …)
Special Data Types
Interval
Expression
Set
Nothing
Domains
Multiword Type Names
IPv4
Geo
Overview
SimpleAggregateFunction
IPv6
Map(key, value)
Guides
Overview
Applying CatBoost Models
Operations
Introduction
ClickHouse Upgrade
Requirements
Troubleshooting
Monitoring
Access Control and Account Management
Testing Hardware
Optimizing Performance
Query Profiling
System Tables
system.licenses
system.current_roles
system.roles
System Tables
system.detached_parts
system.numbers_mt
system.databases
system.role_grants
system.row_policies
system.enabled_roles
system.opentelemetry_span_log
system.settings_profiles
system.replicas
system.quota_usage
system.functions
system.settings_profile_elements
system.errors
system.grants
system.merge_tree_settings
system.quota_limits
system.trace_log
system.events
system.distributed_ddl_queue
system.storage_policies
system.metric_log
system.contributors
system.numbers
system.mutations
system.table_engines
system.one
system.graphite_retentions
system.quotas
system.time_zones
system.processes
system.settings
system.replication_queue
system.asynchronous_metric_log
system.distribution_queue
system.query_log
system.columns
system.quotas_usage
system.replicated_fetches
system.part_log
system.parts_columns
system.metrics
system.crash_log
system.asynchronous_metrics
system.text_log
system.disks
system.data_type_families
system.users
system.query_thread_log
system.stack_trace
system.tables
system.zookeeper
system.parts
system.merges
system.dictionaries
system.clusters
Server Configuration Parameters
Server Settings
Introduction
Settings
Constraints on Settings
Settings
Settings Profiles
Introduction
Restrictions on Query Complexity
MergeTree tables settings
User Settings
Permissions for Queries
Utilities
clickhouse-copier
Usage Recommendations
Caches
Overview
OpenTelemetry Support
clickhouse-local
clickhouse-odbc-bridge
clickhouse-benchmark
ClickHouse obfuscator
ClickHouse compressor
External User Authenticators and Directories
LDAP
Data Backup
Configuration Files
Introduction
Quotas
Development
Build on Linux for AARCH64 (ARM64)
Third-Party Libraries Used
Continuous Integration Checks
Build on Linux
Source Code Browser
Architecture Overview
C++ Guide
Build on Mac OS X
Testing
How to add test queries to ClickHouse CI
For Beginners
CMake in ClickHouse
Build on Linux for Mac OS X
Commercial
Cloud
Support
Introduction
暂无相关搜索结果！
本文档使用
全库网
构建
×
思维导图备注
×
文章二维码
手机扫一扫，轻松掌上读
×
文档下载
请下载您需要的格式的文档，随时随地，享受汲取知识的乐趣！
PDF
文档
EPUB
文档
MOBI
文档
×
书签列表
×
阅读记录
阅读进度:
0.00%
(
0/0
)
重置阅读进度
我的书签
添加书签
移除书签