ClickHouse v21.2 Documentation
首页 白天 夜间 下载 阅读记录
  • 书签 我的书签
  • 添加书签 添加书签 移除书签 移除书签
编辑文档

ALTER

来源 1 浏览 275 扫码 打印 2021-03-09 00:08:08
  • PARTITION
  • UPDATE
  • SAMPLE BY
  • CONSTRAINT
  • USER
  • ROW POLICY
  • SYSTEM
  • GRANT
  • REVOKE
  • CHECK
  • DETACH
  • KILL
  • RENAME
  • SET ROLE
  • USE
  • Syntax
上一篇:
下一篇:
  • 书签
  • 添加书签 移除书签
  • 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 ) 重置阅读进度