思维导图备注

Apache Doris v3.0 Documentation
首页 白天 夜间 BookChat 小程序 小程序 阅读
  • 书签 我的书签
  • 添加书签 添加书签 移除书签 移除书签

Data Table Design

 Github  来源:Doris 浏览 84 扫码 分享 2024-09-22 12:17:25
  • Data Types
  • Data Models
  • Hybrid Storage
  • Data Partitioning
  • Schema Evolution
  • Tiered Storage
  • Table Indexes
  • Using AUTO_INCREMENT
  • Best Practices
当前内容版权归 Doris 或其关联方所有，如需对内容或内容相关联开源项目进行关注与资助，请访问 Doris .
上一篇:
下一篇:
  • 书签
  • 添加书签 移除书签
  • Apache Doris v3.0 中文文档
  • Apache Doris v3.0 Documentation
  • Apache Doris v2.1 Documentation
  • Apache Doris v2.1 中文文档
  • Apache Doris v2.0 Documentation
  • Apache Doris v2.0 中文文档
  • Apache Doris v1.2 Documentation
  • Apache Doris v1.2 中文文档
  • Apache Doris v1.1 Documentation
  • Apache Doris v1.1 中文文档
  • Apache Doris v1.0 中文文档
  • Apache Doris v1.0 Documentation
  • Apache Doris v0.15 Documentation
  • Apache Doris v0.15 中文文档
  • Apache Doris v0.14 Documentation
  • Apache Doris v0.14 中文文档
  • Apache Doris v0.13 Document
  • Apache Doris v0.13 中文文档
  • Apache Doris 0.12 Documentation
  • Apache Doris 0.12 中文文档
  • Apache Doris v0.11 Documentation
  • Apache Doris v0.11 中文文档
  • Apache Doris 文档(201812)
  • Getting Started
    • What’s New
    • What’s Apache Doris
    • Quick Start
    • Tutorials
      • Building lakehouse
        • Using Doris and Hudi
        • Using Doris and Paimon
        • Using Doris and Iceberg
      • Building log analysis platform
  • Guides
    • Installation and Deployment
      • Source Code Compilation
        • Compiling with Docker (Recommended)
        • Compiling with LDB Toolchain (Recommended)
        • Compiling on Linux
        • Compiling with Arm
        • Compiling on Windows
        • Compiling on MacOS
      • Cluster Deployment
        • Manual Deployment
        • Deploying with Docker
        • Deploying on Kubernetes
          • Cluster Environment Requirements
          • Compute-storage coupled
            • Deploying Doris Operator
            • Quick Start
            • Configuring Doris Cluster
            • Deploying Doris Cluster
            • Accessing Doris Cluster
            • Upgrading Apache Doris cluster deployed by Doris Operator
            • Used by Root users
            • Service expansion and contraction
            • How to enter the container when the service crashes
          • Compute-storage decoupled
            • Compute-storage decoupled quick start
            • Install Metaservice
              • Config and install FDB
              • Config and install MS
              • Config and install Recycler
            • Install Cluster
              • Cluster dependency association configuration
              • Config and install FE
              • Config and install Compute Clusters
        • Deploying on AWS
    • Database Connection
      • Connecting to Database
      • High-speed data transmission link based on Arrow Flight SQL
    • Data Table Design
      • Data Types
      • Data Models
        • Model Overview
        • Duplicate Key Model
        • Unique Key Model
        • Aggregate Key Model
        • Usage Notes
      • Hybrid Storage
      • Data Partitioning
      • Schema Evolution
      • Tiered Storage
      • Table Indexes
        • Index Overview
        • Sort Key and Prefix Index
        • Inverted Index
        • BloomFilter Index
        • N-Gram BloomFilter Index
      • Using AUTO_INCREMENT
      • Best Practices
    • Data Manipulation
      • Loading Data
        • Loading Overview
        • Stream Load
        • Broker Load
        • Routine Load
        • Insert Into
        • MySQL Load
        • Loading Data in JSON Format
        • Migrating Data from Other OLAP
        • Group Commit
        • Loading Transaction and Atomicity
        • Converting Source Data
        • Minimum Number of Replicas Loading
        • Loading Strict Mode
      • Updating Data
        • Updating Overview
        • Updating Data with UPDATE Command
        • Updating Data on Unique Key Model
        • Updating Data on Aggregate Key Model
        • Updating Transaction
      • Deleting Data
        • Deleting Data with DELETE Command
        • Batch Deletion
        • Deleting Data with TRUNCATE Command
        • Replacing Atomic Table
        • Temporary Partition
      • Exporting Data
        • Export Overview
        • Export
        • Select Into Outfile
        • MySQL Dump
      • Job Scheduler
        • Job Scheduler
      • Transaction
    • Data Queries
      • Quering Data
        • MySQL Compatibility
        • Select Manual
        • Complex Type
        • Subquery
        • Common Table Expression
        • Column to Row (Lateral View)
        • Window Function
        • Encrption and Masking Function
      • Quering Variables
        • Variable
        • SQL Mode
        • User Defined Variables
      • Cost-Based Optimizer
        • Nereids-the Brand New Planner
        • Statistics
      • Pipeline Execution Engine
        • Pipeline Execution Engine
        • PipelineX Execution Engine
      • Caches
        • Query Caches Overview
        • SQL Cache
      • View and Materialize View
        • View
        • Materialized View
        • Asynchronous materialized view
        • Querying Async Materialized View
      • Join Optimization
        • Doris Join Optimization Principle
        • Bucket Shuffle Join
        • Colocation Join
        • Runtime Filter
        • Join Hint using Document
      • Distincting Counts
        • Orthogonal BITMAP Calculation
        • Approximate Deduplication Using HLL
      • High-Concurrency Point Query
      • TOPN Query Optimization
      • Analyzing Query
        • Get Profile
        • Statistics of query execution
        • Query Analysis
        • Import Analysis
      • User Defined Functions
        • Java UDF
    • Data Lakehouse
      • Data Lakehouse Overview
      • Querying Data Lakes
        • Hive Catalog
        • Hudi Catalog
        • Iceberg Catalog
        • Paimon Catalog
        • LakeSoul Catalog
        • BigQuery Catalog
        • Delta Lake Catalog
        • Kudu Catalog
        • Alibaba Cloud DLF
        • TPCH
        • TPCDS
      • Building Data Lakes
        • Hive
        • Iceberg
      • Querying Databases
        • JDBC Catalog
        • MySQL
        • PostgreSQL
        • Oracle
        • SQL Server
        • IBM Db2
        • ClickHouse
        • SAP HANA
        • OceanBase
        • Elasticsearch
        • Alibaba Cloud Max Compute
      • Querying Files on S3/HDFS
      • Data Cache
      • Metadata Cache
      • Elastic Compute Node
      • External Table Statistics
      • Cloud Service Authentication
      • SQL Dialect Convertor
    • Compute-Storage Decoupled
      • Overview
      • Before Deployment
      • Compilation and Deployment
      • Creating Cluster
      • Managing Compute Cluster
      • File Cache
      • Meta Service API
    • Managing Doris
      • Managing Cluster
        • Upgrading Cluster
        • Elastic Scaling
        • Loading Balance
        • Time Zone
        • FQDN
      • Managing Data
        • Data Backup
        • Data Restore
        • CCR (Cross Cluster Replication)
        • Recover from Recycle Bin
        • Repairing Data
      • Managing Resource
        • Workload Group
        • Workload Policy
        • Workload Analysis
        • Resource Group
        • Workload Fusing
        • Use Workload Group limit memory
        • Use Workload Group limit CPU
        • Use Workload Group limit local IO
        • Use Workload Group limit remote IO
      • Managing Query
        • SQL Interception
        • Kill Query
      • Managing User Privilege
        • Authentication and Authorization
        • LDAP
        • Integration with Apache Ranger
        • MySQL Client Certificate
        • FE SSL Certificate
      • Managing Memory
        • Overview
        • Memory Issue FAQ
        • Managing Memory Analysis
          • Jemalloc Memory Analysis
          • Global Memory Analysis
          • Cache Memory Analysis
          • Metadata Memory Analysis
          • Query Memory Analysis
          • Load Memory Analysis
          • Query error Process Memory Not Enough
          • Query error Memory Tracker Limit Exceeded
          • OOM Killer Crash Analysis
          • Memory Log Analysis
          • Heap Profile Memory Analysis
        • Managing Memory Feature
          • Memory Tracker
          • Memory Control Strategy
      • Log Management
        • FE Log Management
        • BE Log Management
      • Maintenance
        • Monitor Metrics
          • Monitor Metrics
        • Disk Capacity Management
        • Data replica management
        • Description of the return value of the OLAP function on the BE side
        • Doris Error Table
        • Tablet metadata management tool
        • Monitoring and alarming
        • Tablet Local Debug
        • Metadata Operations and Maintenance
        • Automated Service Startup
        • FE Lock Management
      • Managing Configuration
        • Config Dir
        • FE Configuration
        • BE Configuration
        • User Property
      • System Tables
        • file_cache_statistics
        • tables
        • table_properties
      • Using Audit Log Plugin
      • OPEN API
        • Overview
        • FE HTTP API
          • Config Action
          • HA Action
          • Hardware Info Action
          • Help Action
          • Log Action
          • Login Action
          • Logout Action
          • Query Profile Action
          • Session Action
          • System Action
          • Colocate Meta Action
          • Meta Action
          • Cluster Action
          • Node Action
          • Query Profile Action
          • Backends Action
          • Bootstrap Action
          • Cancel Load Action
          • Check Decommission Action
          • Check Storage Type Action
          • Connection Action
          • Extra Basepath Action
          • Fe Version Info Action
          • Get DDL Statement Action
          • Get Load Info Action
          • Get Load State
          • Get FE log file
          • Get Small File Action
          • Health Action
          • Meta Info Action
          • Meta Replay State Action
          • Metrics Action
          • Profile Action
          • Query Detail Action
          • Query Schema Action
          • Query Stats Action
          • Row Count Action
          • Set Config Action
          • Show Data Action
          • Show Meta Info Action
          • Show Proc Action
          • Show Runtime Info Action
          • Show Table Data Action
          • Statement Execution Action
          • Table Query Plan Action
          • Table Row Count Action
          • Table Schema Action
          • Upload Action
          • Import Action
          • Meta Info Action
          • Debug Point
          • Statistic Action
        • BE HTTP API
          • Check Stub Cache
          • Reset Stub Cache
          • View Compaction Status
          • Manually Trigger Compaction
          • View Meta
          • Make Snapshot
          • Check All Tablet Segment Lost
          • Config of BE
          • Metrics
          • View Tablet Distribution
          • Migration Tablet
          • View Tablet Info
          • Checksum
          • Download Log about Load Error
          • Pad Rowset
          • Be Version Info
          • Check Alive
          • Reload Tablet
          • Restore Tablet
      • Developing Plugins
      • Small File Manager
      • Compaction
      • Using rowsets
    • SQL Reference
      • SQL Types
        • Overview
        • Numeric Data Type
          • BOOLEAN
          • TINYINT
          • SMALLINT
          • INT
          • BIGINT
          • LARGEINT
          • FLOAT
          • DOUBLE
          • DECIMAL
        • Datetime Data Type
          • DATE
          • TIME
          • DATETIME
        • String Data Type
          • CHAR
          • VARCHAR
          • STRING
        • Semi-Structured Data Type
          • ARRAY
          • MAP
          • STRUCT
          • JSON
          • VARIANT
        • Aggregation Data Type
          • HLL (HyperLogLog)
          • BITMAP
          • QUANTILE_STATE
          • AGG_STATE
        • IP Data Type
          • IPV4
          • IPV6
      • SQL Functions
        • Array Functions
          • ARRAY
          • ARRAY_MAX
          • ARRAY_MIN
          • ARRAY_MAP
          • ARRAY_FILTER
          • ARRAY_AVG
          • ARRAY_SUM
          • ARRAY_SIZE
          • ARRAY_REMOVE
          • ARRAY_SLICE
          • ARRAY_SORT
          • ARRAY_REVERSE_SORT
          • ARRAY_SORTBY
          • ARRAY_SPLIT
          • ARRAY_REVERSE_SPLIT
          • ARRAY_POSITION
          • ARRAY_CONTAINS
          • ARRAY_EXCEPT
          • ARRAY_PRODUCT
          • ARRAY_INTERSECT
          • ARRAY_RANGE
          • ARRAY_DISTINCT
          • ARRAY_DIFFERENCE
          • ARRAY_UNION
          • ARRAY_JOIN
          • ARRAY_WITH_CONSTANT
          • ARRAY_ENUMERATE
          • ARRAY_ENUMERATE_UNIQ
          • ARRAY_POPBACK
          • ARRAY_POPFRONT
          • ARRAY_PUSHFRONT
          • ARRAY_PUSHBACK
          • ARRAY_COMPACT
          • ARRAY_CONCAT
          • ARRAY_ZIP
          • ARRAY_SHUFFLE
          • ARRAY_CUM_SUM
          • ARRAY_EXISTS
          • ARRAY_FIRST_INDEX
          • ARRAY_LAST_INDEX
          • ARRAY_FIRST
          • ARRAY_LAST
          • ARRAYS_OVERLAP
          • ARRAY_COUNT
          • ARRAY_APPLY
          • COUNTEQUAL
          • ELEMENT_AT
          • SEQUENCE
        • Date Functions
          • CONVERT_TZ
          • CURDATE,CURRENT_DATE
          • CURTIME,CURRENT_TIME
          • CURRENT_TIMESTAMP
          • LOCALTIME,LOCALTIMESTAMP
          • NOW
          • YEAR
          • QUARTER
          • MONTH
          • DAY
          • DAYOFYEAR
          • DAYOFMONTH
          • DAYOFWEEK
          • WEEK
          • WEEKDAY
          • WEEKOFYEAR
          • YEARWEEK
          • DAYNAME
          • MONTHNAME
          • HOUR
          • MINUTE
          • SECOND
          • FROM_DAYS
          • LAST_DAY
          • TO_MONDAY
          • FROM_SECOND
          • FROM_UNIXTIME
          • UNIX_TIMESTAMP
          • UTC_TIMESTAMP
          • TO_DATE
          • TO_DAYS
          • TIME_TO_SEC
          • SEC_TO_TIME
          • EXTRACT
          • MAKEDATE
          • STR_TO_DATE
          • TIME_ROUND
          • TIMEDIFF
          • TIMESTAMPADD
          • TIMESTAMPDIFF
          • DATE_ADD
          • DATE_SUB
          • DATE_TRUNC
          • DATE_FORMAT
          • DATEDIFF
          • date_floor
          • second_floor
          • minute_floor
          • hour_floor
          • day_floor
          • month_floor
          • year_floor
          • date_ceil
          • second_ceil
          • minute_ceil
          • hour_ceil
          • day_ceil
          • month_ceil
          • year_ceil
          • MICROSECOND
          • MICROSECONDS_ADD
          • MICROSECONDS_DIFF
          • MICROSECONDS_SUB
          • MILLISECONDS_ADD
          • MILLISECONDS_DIFF
          • MILLISECONDS_SUB
          • MINUTES_ADD
          • MINUTES_DIFF
          • MINUTES_SUB
          • SECONDS_ADD
          • SECONDS_DIFF
          • SECONDS_SUB
          • HOURS_ADD
          • HOURS_DIFF
          • HOURS_SUB
          • DAYS_ADD
          • DAYS_DIFF
          • DAYS_SUB
          • WEEKS_ADD
          • WEEKS_DIFF
          • WEEKS_SUB
          • MONTHS_ADD
          • MONTHS_DIFF
          • MONTHS_SUB
          • YEARS_ADD
          • YEARS_DIFF
          • YEARS_SUB
        • GIS Functions
          • ST_X
          • ST_Y
          • ST_CIRCLE
          • ST_DISTANCE_SPHERE
          • ST_ANGLE
          • ST_AZIMUTH
          • ST_ANGLE_SPHERE
          • ST_AREA
          • ST_POINT
          • ST_POLYGON,ST_POLYFROMTEXT,ST_POLYGONFROMTEXT
          • ST_ASTEXT,ST_ASWKT
          • ST_CONTAINS
          • ST_GEOMETRYFROMTEXT,ST_GEOMFROMTEXT
          • ST_LINEFROMTEXT,ST_LINESTRINGFROMTEXT
          • ST_ASBINARY
          • ST_GEOMETRYFROMWKB,ST_GEOMFROMWKB
        • String Functions
          • TO_BASE64
          • FROM_BASE64
          • ASCII
          • AUTO_PARTITION_NAME
          • LENGTH
          • BIT_LENGTH
          • CHAR_LENGTH
          • LPAD
          • RPAD
          • LOWER
          • LCASE
          • UPPER
          • UCASE
          • INITCAP
          • REPEAT
          • REVERSE
          • CHAR
          • CONCAT
          • CONCAT_WS
          • SUBSTRING
          • SUB_REPLACE
          • APPEND_TRAILING_CHAR_IF_ABSENT
          • ENDS_WITH
          • STARTS_WITH
          • TRIM
          • LTRIM
          • RTRIM
          • NULL_OR_EMPTY
          • NOT_NULL_OR_EMPTY
          • HEX
          • UNHEX
          • ELT
          • INSTR
          • LOCATE
          • OVERLAY
          • FIELD
          • FIND_IN_SET
          • REPLACE
          • REPLACE_EMPTY
          • STRLEFT
          • STRRIGHT
          • SPLIT_PART
          • SPLIT_BY_STRING
          • SUBSTRING_INDEX
          • MONEY_FORMAT
          • PARSE_URL
          • QUOTE
          • url_decode
          • CONVERT_TO
          • EXTRACT_URL_PARAMETER
          • UUID
          • SPACE
          • ESQUERY
          • random_bytes
          • Search in String
          • Mask in String
          • Fuzzy Match
          • Regular Match
        • Struct Functions
          • STRUCT
          • NAMED_STRUCT
          • STRUCT_ELEMENT
        • Combinators
          • STATE
          • MERGE
          • UNION
        • Aggregate Functions
          • MIN
          • MIN_BY
          • MAX
          • MAX_BY
          • AVG
          • AVG_WEIGHTED
          • SUM
          • STDDEV,STDDEV_POP
          • STDDEV_SAMP
          • VARIANCE,VAR_POP,VARIANCE_POP
          • VARIANCE_SAMP,VARIANCE_SAMP
          • COVAR,COVAR_POP
          • COVAR_SAMP
          • CORR
          • TOPN
          • TOPN_ARRAY
          • TOPN_WEIGHTED
          • COUNT
          • COUNT_BY_ENUM
          • APPROX_COUNT_DISTINCT
          • PERCENTILE
          • PERCENTILE_ARRAY
          • PERCENTILE_APPROX
          • PERCENTILE_APPROX_WEIGHTED
          • HISTOGRAM
          • GROUP_ARRAY_INTERSECT
          • GROUP_BITMAP_XOR
          • GROUP_BIT_AND
          • GROUP_BIT_OR
          • GROUP_BIT_XOR
          • GROUP_CONCAT
          • BITMAP_UNION
          • HLL_UNION_AGG
          • GROUPING
          • GROUPING_ID
          • ANY_VALUE
          • ARRAY_AGG
          • FOREACH
          • MAP_AGG
          • BITMAP_AGG
          • COLLECT_SET
          • COLLECT_LIST
          • RETENTION
          • REGR_SXX
          • REGR_SXY
          • REGR_SYY
          • SEQUENCE_MATCH
          • SEQUENCE-COUNT
        • Bitmap Functions
          • TO_BITMAP
          • BITMAP_HASH
          • BITMAP_FROM_STRING
          • BITMAP_TO_STRING
          • BITMAP_TO_ARRAY
          • BITMAP_FROM_ARRAY
          • BITMAP_EMPTY
          • BITMAP_OR
          • BITMAP_AND
          • BITMAP_UNION
          • BITMAP_XOR
          • BITMAP_NOT
          • BITMAP_AND_NOT,BITMAP_ANDNOT
          • BITMAP_SUBSET_LIMIT
          • BITMAP_SUBSET_IN_RANGE
          • SUB_BITMAP
          • BITMAP_COUNT
          • BITMAP_AND_COUNT
          • BITMAP_AND_NOT_COUNT,BITMAP_ANDNOT_COUNT
          • BITMAP_XOR_COUNT
          • BITMAP_OR_COUNT
          • BITMAP_CONTAINS
          • BITMAP_HAS_ALL
          • BITMAP_HAS_ANY
          • BITMAP_MAX
          • BITMAP_MIN
          • INTERSECT_COUNT
          • BITMAP_INTERSECT
          • BITMAP_HASH64
          • BITMAP_FROM_BASE64
          • BITMAP_TO_BASE64
          • BITMAP_REMOVE
        • Bitwise Functions
          • BITAND
          • BITOR
          • BITXOR
          • BITNOT
          • BIT_COUNT
          • BIT_SHIFT_LEFT
          • BIT_SHIFT_RIGHT
        • Conditional Functions
          • ASSERT_TRUE
          • CASE
          • COALESCE
          • IF
          • IFNULL
          • NVL
          • NULLIF
        • JSON Functions
          • JSON_PARSE
          • JSON_EXTRACT
          • JSON_EXISTS_PATH
          • JSON_TYPE
          • JSON_ARRAY
          • JSON_OBJECT
          • JSON_QUOTE
          • JSON_UNQUOTE
          • JSON_VALID
          • JSON_CONTAINS
          • JSON_LENGTH
          • GET_JSON_DOUBLE
          • GET_JSON_INT
          • GET_JSON_BIGINT
          • GET_JSON_STRING
          • JSON_INSERT
          • JSON_REPLACE
          • JSON_SET
          • JSON_KEYS
        • Hash Functions
          • MURMUR_HASH3_32
          • MURMUR_HASH3_64
          • XXHASH_32
          • XXHASH_64
        • HLL Functions
          • HLL_CARDINALITY
          • HLL_EMPTY
          • HLL_FROM_BASE64
          • HLL_HASH
          • HLL_TO_BASE64
        • Numeric Functions
          • CONV
          • BIN
          • SIN
          • COS
          • COSH
          • TAN
          • TANH
          • ASIN
          • ACOS
          • ATAN
          • ATAN2
          • E
          • PI
          • EXP
          • LOG
          • LOG2
          • LOG10
          • LN
          • CEIL
          • FLOOR
          • PMOD
          • ROUND
          • ROUND_BANKERS
          • XOR
          • TRUNCATE
          • ABS
          • SQRT
          • CBRT
          • POW
          • DEGREES
          • RADIANS
          • SIGN
          • POSITIVE
          • NEGATIVE
          • GREATEST
          • LEAST
          • RANDOM
          • MOD
          • RUNNING_DIFFERENCE
          • uuid_numeric
        • Encryption Functions
          • AES_ENCRYPT
          • AES_DECRYPT
          • MD5
          • MD5SUM
          • SM4_ENCRYPT
          • SM4_DECRYPT
          • SM3
          • SM3SUM
          • SHA
          • SHA2
        • Table Functions
          • EXPLODE_JSON_ARRAY
          • EXPLODE
          • EXPLODE_SPLIT
          • EXPLODE_MAP
          • EXPLODE_BITMAP
          • NUMBERS
          • EXPLODE_NUMBERS
          • EXPLODE_NUMBERS_OUTER
        • Table Valued Functions
          • S3
          • HDFS
          • LOCAL
          • QUERY
          • ICEBERG_META
          • BACKENDS
          • FRONTENDS
          • FRONTENDS_DISKS
          • CATALOGS
          • JOBS
          • MV_INFOS
          • PARTITIONS
          • TASKS
        • Analytic(Window) Functions
          • Window Functions Overview
          • WINDOW_FUNCTION_SUM
          • WINDOW_FUNCTION_AVG
          • WINDOW_FUNCTION_MAX
          • WINDOW_FUNCTION_MIN
          • WINDOW_FUNCTION_COUNT
          • WINDOW_FUNCTION_RANK
          • WINDOW_FUNCTION_DENSE_RANK
          • WINDOW_FUNCTION_PERCENT_RANK
          • WINDOW_FUNCTION_CUME_DIST
          • WINDOW_FUNCTION_FIRST_VALUE
          • WINDOW_FUNCTION_LAST_VALUE
          • WINDOW_FUNCTION_LEAD
          • WINDOW_FUNCTION_LAG
          • WINDOW_FUNCTION_ROW_NUMBER
          • WINDOW_FUNCTION_NTILE
          • WINDOW_FUNCTION_WINDOW_FUNNEL
        • IP Functions
          • IPV4_NUM_TO_STRING
          • IPV4_TO_IPV6
          • IPV4_STRING_TO_NUM
          • IPV4_STRING_TO_NUM_OR_DEFAULT
          • IPV4_STRING_TO_NUM_OR_NULL
          • IPV6_NUM_TO_STRING
          • IPV6_STRING_TO_NUM
          • IPV6_STRING_TO_NUM_OR_DEFAULT
          • IPV6_STRING_TO_NUM_OR_NULL
          • IS_IPV4_COMPAT
          • IS_IPV4_MAPPED
          • IPV4_CIDR_TO_RANGE
          • IPV6_CIDR_TO_RANGE
          • IS_IP_ADDRESS_IN_RANGE
          • CUT_IPV6
          • IS_IPV4_STRING
          • IS_IPV6_STRING
          • TO_IPV4
          • TO_IPV4_OR_DEFAULT
          • TO_IPV4_OR_NULL
          • TO_IPV6
          • TO_IPV6_OR_DEFAULT
          • TO_IPV6_OR_NULL
        • Vector Distance Functions
          • cosine_distance
          • inner_product
          • l1_distance
          • l2_distance
        • CAST
        • DIGITAL_MASKING
        • WIDTH_BUCKET
      • SQL Statements
        • Cluster management
          • ALTER-SYSTEM-ADD-FOLLOWER
          • ALTER-SYSTEM-ADD-OBSERVER
          • ALTER-SYSTEM-ADD-BACKEND
          • ALTER-SYSTEM-ADD-BROKER
          • ALTER-SYSTEM-MODIFY-BACKEND
          • ALTER-SYSTEM-DECOMMISSION-BACKEND
          • ALTER-SYSTEM-DROP-FOLLOWER
          • ALTER-SYSTEM-DROP-OBSERVER
          • ALTER-SYSTEM-DROP-BACKEND
          • ALTER-SYSTEM-DROP-BROKER
          • CANCEL-ALTER-SYSTEM
        • Account Management
          • CREATE-ROLE
          • CREATE-USER
          • ALTER-ROLE
          • ALTER-USER
          • SET-PASSWORD
          • SET-PROPERTY
          • LDAP
          • GRANT
          • REVOKE
          • DROP-ROLE
          • DROP-USER
        • Database Administration
          • SHOW-CONFIG
          • ADMIN-SET-CONFIG
          • SET-VARIABLE
          • INSTALL-PLUGIN
          • UNINSTALL-PLUGIN
          • ADMIN-SET-REPLICA-STATUS
          • ADMIN-SET-REPLICA-VERSION
          • ADMIN-SET-PARTITION-VERSION
          • ADMIN-SET-TABLE-STATUS
          • SHOW-REPLICA-DISTRIBUTION
          • SHOW-REPLICA-STATUS
          • ADMIN-REPAIR-TABLE
          • ADMIN-CANCEL-REPAIR
          • ADMIN-CHECK-TABLET
          • SHOW TABLET DIAGNOSIS
          • ADMIN-COPY-TABLET
          • SHOW TABLET STORAGE FORMAT
          • ADMIN-CLEAN-TRASH
          • RECOVER
          • KILL
          • ADMIN-REBALANCE-DISK
          • ADMIN-CANCEL-REBALANCE-DISK
          • UNSET-VARIABLE
        • DDL
          • Create
          • Alter
          • Drop
          • Backup and Restore
        • DML
          • Load
          • Manipulation
          • OUTFILE
        • Show
          • SHOW ALTER TABLE MATERIALIZED VIEW
          • SHOW-ALTER
          • SHOW-ANALYZE
          • SHOW-BACKUP
          • SHOW-BACKENDS
          • SHOW-BROKER
          • SHOW-CATALOGS
          • SHOW-CREATE-TABLE
          • SHOW-CREATE-MATERIALIZED-VIEW
          • SHOW-CREATE-ASYNC-MATERIALIZED-VIEW
          • SHOW-CHARSET
          • SHOW-CREATE-CATALOG
          • SHOW-CREATE-DATABASE
          • SHOW-CREATE-LOAD
          • SHOW-CREATE-REPOSITORY
          • SHOW-CREATE-ROUTINE-LOAD
          • SHOW-CREATE-FUNCTION
          • SHOW-COLUMNS
          • SHOW-COLUMN-STATS
          • SHOW-COLLATION
          • SHOW-CONVERT-LIGHT-SCHEMA-CHANGE-PROCESS
          • SHOW-DATABASES
          • SHOW DATA SKEW
          • SHOW-DATABASE-ID
          • SHOW-DYNAMIC-PARTITION
          • SHOW-DELETE
          • SHOW-DATA
          • SHOW-DATA-TYPES
          • SHOW-ENGINES
          • SHOW-EVENTS
          • SHOW-EXPORT
          • SHOW-ENCRYPT-KEY
          • SHOW-FUNCTIONS
          • SHOW-TYPECAST
          • SHOW-FILE
          • SHOW-GRANTS
          • SHOW-LAST-INSERT
          • SHOW-LOAD-PROFILE
          • SHOW-LOAD-WARNINGS
          • SHOW-INDEX
          • SHOW-PARTITION-ID
          • SHOW-SNAPSHOT
          • SHOW-SQL-BLOCK-RULE
          • SHOW-ROUTINE-LOAD
          • SHOW-SYNC-JOB
          • SHOW-WHITE-LIST
          • SHOW-WARNING
          • SHOW-TABLET
          • SHOW-TABLETS-BELONG
          • SHOW-VARIABLES
          • SHOW-PLUGINS
          • SHOW-ROLES
          • SHOW-PROCEDURE
          • SHOW-ROUTINE-LOAD-TASK
          • SHOW-PROC
          • SHOW-TABLE-STATS
          • SHOW-TABLE-STATUS
          • SHOW-REPOSITORIES
          • SHOW-QUERY-PROFILE
          • SHOW-OPEN-TABLES
          • SHOW-TABLETS
          • SHOW-LOAD
          • SHOW-TABLES
          • SHOW-RESOURCES
          • SHOW-workload-GROUPS
          • SHOW-PARTITIONS
          • SHOW-FRONTENDS
          • SHOW-FRONTENDS-DISKS
          • SHOW-RESTORE
          • SHOW-PROPERTY
          • SHOW-TRIGGERS
          • SHOW-PROCESSLIST
          • Show Privileges
          • SHOW-TRASH
          • SHOW-VIEW
          • SHOW-TRANSACTION
          • SHOW-STREAM-LOAD
          • SHOW-STATUS
          • SHOW-TABLE-ID
          • SHOW-SMALL-FILES
          • SHOW-POLICY
          • SHOW-STORAGE-POLICY-USING
          • SHOW-CATALOG-RECYCLE-BIN
          • SHOW-QUERY-STATS
        • Operators
          • IN
        • Utility
          • HELP
          • USE
          • DESCRIBE
          • SWITCH
          • REFRESH
          • SYNC
          • CLEAN-QUERY-STATS
          • CANCEL-MATERIALIZED-VIEW-TASK
          • PAUSE-MATERIALIZED-VIEW
          • REFRESH-MATERIALIZED-VIEW
          • RESUME-MATERIALIZED-VIEW
          • REFRESH-LDAP
  • Benchmark
    • Star Schema Benchmark
    • TPC-H Benchmark
    • TPC-DS Benchmark
  • Ecosystem
    • Spark Doris Connector
    • Flink Doris Connector
    • Doris Kafka Connector
    • DataX Doriswriter
    • DBT Doris Adapter
    • Seatunnel Doris Sink
    • Kyuubi
    • Logstash Doris Output Plugin
    • Beats Doris Output Plugin
    • CloudCanal Data Import
    • AutoMQ Load
    • Doris Streamloader
    • Hive Bitmap UDF
    • Hive HLL UDF
    • BI and Database IDE
      • Apache Superset
      • DBeaver
      • DataGrip
      • FineBI
      • Power BI
      • Tableau
      • QuickSight
      • Quick BI
  • FAQ
    • Install Error
    • Data Operation Error
    • SQL Error
    • Data Lakehouse FAQ
  • Release
    • What’s New
    • v3.0
      • Release 3.0.1
    • v2.1
      • Release 2.1.6
      • Release 2.1.5
      • Release 2.1.4
      • Release 2.1.3
      • Release 2.1.2
      • Release 2.1.1
      • Release 2.1.0
    • v2.0
      • Release 2.0.14
      • Release 2.0.13
      • Release 2.0.12
      • Release 2.0.11
      • Release 2.0.10
      • Release 2.0.9
      • Release 2.0.8
      • Release 2.0.7
      • Release 2.0.6
      • Release 2.0.5
      • Release 2.0.4
      • Release 2.0.3
      • Release 2.0.2
      • Release 2.0.1
      • Release 2.0.0
    • v1.2
      • Release 1.2.8
      • Release 1.2.7
      • Release 1.2.6
      • Release 1.2.5
      • Release 1.2.4
      • Release 1.2.3
      • Release 1.2.2
      • Release 1.2.1
      • Release 1.2.0
    • v1.1
      • Release 1.1.5
      • Release 1.1.4
      • Release 1.1.3
      • Release 1.1.2
      • Release 1.1.1
      • Release 1.1.0
暂无相关搜索结果！

    本文档使用 BookStack 构建

    展开/收起文章目录

    分享，让知识传承更久远

    文章二维码

    手机扫一扫，轻松掌上读

    文档下载

    • 普通下载
    • 下载码下载(免登录无限下载)
    你与大神的距离，只差一个APP
    APP下载
    请下载您需要的格式的文档，随时随地，享受汲取知识的乐趣！
    PDF文档 EPUB文档 MOBI文档
    温馨提示 每天每在网站阅读学习一分钟时长可下载一本电子书，每天连续签到可增加阅读时长
    下载码方式下载：免费、免登录、无限制。 免费获取下载码

    微信小程序阅读

    BookChat 微信小程序阅读
    您与他人的薪资差距，只差一个随时随地学习的小程序

    书签列表

      阅读记录

      阅读进度: 0.00% ( 0/0 ) 重置阅读进度