Documentation
velodb.io ↗velodb.io ↗ (opens in a new tab)
    • VeloDB Cloud Introduction
    • Quick Start

    • Overview
    • Warehouse Management
      • Create SaaS Warehouse
      • Create BYOC Warehouse
        • AWS
          • AWS Preparation
        • GCP
          • GCP Preparation
        • Azure
          • Azure Preparation
      • Use Warehouse
      • Disaster Recovery on Multi Avaliable Zone
    • Cluster Management
    • Connections
    • Studio
    • Monitoring Overview
    • Billing Center
    • User and Organization

      • Connecting by Arrow Flight SQL Protocol
      • Connecting by MySQL Protocol
      • Overview
        • Table Model Overview
        • Duplicate Key Model
        • Aggregate Model
        • Usage Notes
        • Unique Key Model
        • Data Distribution Concept
        • Manual Partitioning
        • Dynamic Partitioning
        • Auto Partition
        • Data Bucketing
        • Common Issues
      • Data Types
      • Column Compression
        • Bitmap Index
        • Index Overview
        • Prefix Index
        • Inverted Index
        • Bloomfilter Index
        • N-Gram Bloomfilter Index
      • Schema Change
      • Auto Increment Column
        • Tiered Storage Overview
        • Tiered Storage of SSD and HDD
        • Remote Storage
      • Hybrid Row-Columnar Storage
      • Best Practices
      • Loading Overview
        • Local File
        • Kafka
        • Flink
        • HDFS
        • Amazon S3
        • Google Cloud Storage
        • Azure Storage
        • Alibaba Cloud OSS
        • Huawei Cloud OBS
        • Tencent Cloud COS
        • MinIO
        • S3 Compatible Storage
        • Snowflake
        • BigQuery
        • Redshift
        • Migrate Data from Other OLAP
        • Migrate Data from Other OLTP
        • Stream Load
        • Broker Load
        • Routine Load
        • Insert Into Values
        • Insert Into Values
        • MySQL Load
        • CSV
        • JSON
        • Parquet
        • ORC
        • ARRAY
        • MAP
        • STRUCT
        • JSON
        • Bitmap
        • HLL
        • Variant
      • Handling Data Issues
      • Transforming Data During Load
      • Load High Availability
      • High Concurrency LOAD Optimization(Group Commit)
      • Load Best Practices
        • Update Overview
        • Updating Data with UPDATE Command
        • Updating Data on Unique Key Model
        • Updating Data on Aggregate Key Model
        • Concurrency Control for Updates in the Primary Key Model
        • Delete Overview
        • Deleting Data with DELETE Command
        • Batch Deletion Based on Load
        • Truncate
        • Replacing Atomic Table
        • Temporary Partition
      • Transaction
      • Export Overview
      • EXPORT
      • SELECT INTO OUTFILE
      • Using MySQL Dump
      • Best Practices of Export
      • MySQL Compatibility
      • Join
      • Subquery
      • Multi-dimensional Analytics
      • Window Function
      • Common Table Expression
        • Alias Function
        • Java UDF, UDAF, UDTF
      • Complex Type
      • Column to Row (Lateral View)
        • Tuning Overview
        • Analysis Tools
        • Diagnostic Tools
        • Tuning Process
        • Materialized View Overview
        • Sync-Materialized View
          • Overview of Asynchronous Materialized Views
          • Creating, Querying, and Maintaining Asynchronous Materialized Views
          • Best Practices
          • Use Advice
          • FAQ
      • SQL Cache
      • High-Concurrency Point Query
        • BITMAP Precise Deduplication
        • HLL Approximate Deduplication
      • Colocation Join
        • Overview of Hints
        • Leading Hint
        • Distribute Hint
          • Optimizing Table Schema Design
          • Optimizing Table Index
          • Optimizing Table Scanning
          • Transparent Rewriting with Sync-Materialized View
          • Transparent Rewriting by Async-Materialized View
          • Optimizing Join with Colocate Group
          • Adjusting Join Shuffle Mode with Hint
          • Control CBO Rules With Hint
          • Reordering Join With Leading Hint
          • Accelerating Queries with SQL Cache
          • DML Tuning Plan
          • Adjustment of RuntimeFilter Wait Time
          • Data Skew Handling
          • Parallelism Tuning
        • Common Tuning Parameters
        • Query Optimizers
        • Parallel Execution
        • Runtime Filter
        • TOPN Query Optimization
        • Statistics
      • Lakehouse Overview
      • Data Catalog Overview
        • Hive Catalog
        • Iceberg Catalog
        • Hudi Catalog
        • Paimon Catalog
        • MaxCompute Catalog
        • Delta Lake Catalog
        • BigQuery Catalog
        • Kudu Catalog
        • LakeSoul Catalog
        • JDBC Catalog
        • MySQL JDBC Catalog
        • PostgreSQL JDBC Catalog
        • Oracle JDBC Catalog
        • SQL Server JDBC Catalog
        • IMB Db2 JDBC Catalog
        • ClickHouse JDBC Catalog
        • SAP HANA JDBC Catalog
        • Oceanbase JDBC Catalog
      • Analyze Files on S3/HDFS
        • Hive Metastore
        • AWS Glue
        • Google Dataproc
        • Aliyun DLF
        • Iceberg Rest Catalog API
        • File System
        • HDFS
        • S3
        • Azure Blob
        • Google Cloud Storage
        • Aliyun OSS
        • Tencent COS
        • Huawei OBS
        • MINIO
        • Baidu Bos
        • Parquet
        • ORC
        • Text/CSV/JSON
      • Data Cache
      • Metadata Cache
      • Elastic Compute Node
      • Statistics
        • SQL Dialect Conversion
        • Presto/Trino SQL Convertor Guide
        • ClickHouse SQL Convertor Guide
        • Hive SQL Convertor Guide
        • PostgreSQL SQL Convertor Guide
        • Integration with AWS S3 Tables
        • Using Doris and Hudi
        • Using Doris and Iceberg
        • Using Doris and LakeSoul
        • From MaxCompute to Doris
        • Using Doris and Paimon
        • Generating TPC-DS on Hive/Iceberg
        • Generating TPC-H on Hive/Iceberg
      • Overview
      • Doris Compute-Storage Decoupled Deployment Preparation
      • Compilation and Deployment
      • File Cache
      • Managing Compute Groups
      • Managing Storage Vault
      • Upgrade
        • Overview
          • active_queries
          • backend_active_tasks
          • backend_configuration
          • catalog_meta_cache_statistics
          • character_sets
          • collations
          • column_privileges
          • column_statistics
          • columns
          • engines
          • events
          • file_cache_statistics
          • files
          • global_variables
          • key_column_usage
          • metadata_name_ids
          • parameters
          • partitions
          • processlist
          • profiling
          • referential_constraints
          • routine_load_job
          • routines
          • rowsets
          • schema_privileges
          • schemata
          • session_variables
          • statistics
          • table_constraints
          • table_options
          • table_privileges
          • table_properties
          • tables
          • triggers
          • user_privileges
          • views
          • workload_group_privileges
          • workload_group_resource_usage
          • workload_groups
          • workload_policy
          • audit_log
          • column_statistics
          • partition_statistics
          • procs_priv
          • user
        • Overview
          • Resource Group
          • Compute Group
          • Workload Group
        • Workload Analysis Diagnosis
        • Concurrency Control and Queuing
        • Query Circuit Breaker
        • Kill Query
        • Job Scheduler
      • Introduce VeloDB Studio
      • Release Notes
        • Server Version
          • Connection Management
          • Create Connection
        • SQL Console
        • Log Analytics
        • Session Management
        • Audit Log
        • Workload Group
      • Data
        • Authorization
        • Role
        • User
      • Load Task
        • Application Menu
        • Server Version
        • Desktop Version
      • Security & Trust

    • Star Schema Benchmark
    • TPC-DS Benchmark
    • TPC-H Benchmark

    • Spark Doris Connector
    • Flink Doris Connector
    • Doris Kafka Connector
      • Doris Kubernetes Operator
      • Recommendations on Alibaba Cloud
      • Recommendations on AWS
      • DBeaver
      • DataGrip
      • Power BI
      • Tableau
      • QuickSight
      • Quick BI
      • Smartbi
      • DBeaver
      • DataGrip
      • BladePipe
      • DataX Doriswriter
      • DBT Doris Adapter
      • Seatunnel Doris Sink
      • Kettle Doris Plugin
      • Kyuubi
      • Logstash Doris Output Plugin
      • Beats Doris Output Plugin
      • AutoMQ Load
      • Hive Bitmap UDF
      • Hive HLL UDF
      • Fluentbit
    • Doris Streamloader

      • Comments
        • Date Type Literal
        • Numeric Type Literal
        • String Type Literal
      • NULL
      • Object Identifier
        • Assignment Operators
        • Arithmetic Operators
        • Bitwise Operators
          • Boolean Testing Operators
          • Comparison Operators
          • Exists Operators
          • Full Text Search Operators
          • In Operators
          • Logic Operators
          • Pattern Matching Operators
        • Operator Precedence
      • Reserved Keywords
        • Overview
          • BIGINT
          • BOOLEAN
          • DECIMAL
          • DOUBLE
          • FLOAT
          • INT
          • LARGEINT
          • SMALLINT
          • TINYINT
          • DATE
          • DATETIME
          • TIME
          • CHAR
          • STRING
          • VARCHAR
          • ARRAY
          • JSON
          • MAP
          • STRUCT
          • VARIANT
          • AGG_STATE
          • BITMAP
          • HLL (HyperLogLog)
          • QUANTILE_STATE
          • IPV4
          • IPV6
      • Variables
          • ARRAY_APPLY
          • ARRAY_AVG
          • ARRAY_COMPACT
          • ARRAY_CONCAT
          • ARRAY_CONTAINS
          • ARRAY_COUNT
          • ARRAY_CUM_SUM
          • ARRAY_DIFFERENCE
          • ARRAY_DISTINCT
          • ARRAY_ENUMERATE_UNIQ
          • ARRAY_ENUMERATE
          • ARRAY_EXCEPT
          • ARRAY_EXISTS
          • ARRAY_FILTER
          • ARRAY_FIRST_INDEX
          • ARRAY_FIRST
          • ARRAY_INTERSECT
          • ARRAY_JOIN
          • ARRAY_LAST_INDEX
          • ARRAY_LAST
          • ARRAY_MAP
          • ARRAY_MATCH_ALL
          • array_match_any
          • ARRAY_MAX
          • ARRAY_MIN
          • ARRAY_POPBACK
          • ARRAY_POPFRONT
          • ARRAY_POSITION
          • ARRAY_PRODUCT
          • ARRAY_PUSHBACK
          • ARRAY_PUSHFRONT
          • ARRAY_RANGE
          • ARRAY_REMOVE
          • ARRAY_REPEAT
          • ARRAY_REVERSE_SORT
          • ARRAY_REVERSE_SPLIT
          • ARRAY_SHUFFLE
          • ARRAY_SIZE
          • ARRAY_SLICE
          • ARRAY_SORT
          • ARRAY_SORTBY
          • ARRAY_SPLIT
          • ARRAY_SUM
          • ARRAY_UNION
          • ARRAY_WITH_CONSTANT
          • ARRAY_ZIP
          • ARRAY
          • ARRAYS_OVERLAP
          • COUNTEQUAL
          • BITMAP_AND_COUNT
          • BITMAP_AND_NOT_COUNT,BITMAP_ANDNOT_COUNT
          • BITMAP_AND_NOT,BITMAP_ANDNOT
          • BITMAP_AND
          • BITMAP_CONTAINS
          • BITMAP_COUNT
          • BITMAP_EMPTY
          • BITMAP_FROM_ARRAY
          • BITMAP_FROM_BASE64
          • BITMAP_FROM_STRING
          • BITMAP_HAS_ALL
          • BITMAP_HAS_ANY
          • BITMAP_HASH
          • BITMAP_HASH64
          • BITMAP_MAX
          • BITMAP_MIN
          • BITMAP_NOT
          • BITMAP_OR_COUNT
          • BITMAP_OR
          • BITMAP_REMOVE
          • BITMAP_SUBSET_IN_RANGE
          • BITMAP_SUBSET_LIMIT
          • BITMAP_TO_ARRAY
          • BITMAP_TO_BASE64
          • BITMAP_TO_STRING
          • BITMAP_XOR_COUNT
          • BITMAP_XOR
          • SUB_BITMAP
          • TO_BITMAP
          • BIT_LENGTH
          • BITAND
          • BIT_COUNT
          • BITNOT
          • BITOR
          • BIT_SHIFT_LEFT
          • BIT_SHIFT_RIGHT
          • XOR
          • COALESCE
          • GREATEST
          • IF
          • IFNULL
          • LEAST
          • NOT_NULL_OR_EMPTY
          • NULL_OR_EMPTY
          • NULLIF
          • CONVERT_TZ
          • CURDATE,CURRENT_DATE
          • CURRENT_TIMESTAMP
          • CURTIME,CURRENT_TIME
          • DAYS_ADD
          • DATE_CEIL
          • DATE_FLOOR
          • DATE_FORMAT
          • DAYS_SUB
          • DATE_TRUNC
          • DATE
          • DATEDIFF
          • DAY_CEIL
          • DAY_FLOOR
          • DAY
          • DAYNAME
          • DAYOFWEEK
          • DAYOFYEAR
          • EXTRACT
          • FROM_DAYS
          • FROM_ISO8601_DATE
          • FROM_MICROSECOND
          • FROM_MILLISECOND
          • FROM_SECOND
          • FROM_UNIXTIME
          • HOUR_CEIL
          • HOUR_FLOOR
          • HOUR
          • HOURS_ADD
          • HOURS_DIFF
          • HOURS_SUB
          • LAST_DAY
          • LOCALTIME,LOCALTIMESTAMP
          • MAKEDATE
          • MICROSECOND_TIMESTAMP
          • MICROSECOND
          • MICROSECONDS_ADD
          • MICROSECONDS_DIFF
          • MICROSECONDS_SUB
          • MILLISECOND_TIMESTAMP
          • MILLISECONDS_ADD
          • MILLISECONDS_DIFF
          • MILLISECONDS_SUB
          • MINUTE_CEIL
          • MINUTE_FLOOR
          • MINUTE
          • MINUTES_ADD
          • MINUTES_DIFF
          • MINUTES_SUB
          • MONTH_CEIL
          • MONTH_FLOOR
          • MONTH
          • MONTHNAME
          • MONTHS_ADD
          • MONTHS_BETWEEN
          • MONTHS_DIFF
          • MONTHS_SUB
          • NEXT_DAY
          • NOW
          • QUARTER
          • QUARTERS_ADD
          • QUARTERS_SUB
          • SEC_TO_TIME
          • SECOND_CEIL
          • SECOND_FLOOR
          • SECOND_TIMESTAMP
          • SECOND
          • SECONDS_ADD
          • SECONDS_DIFF
          • SECONDS_SUB
          • STR_TO_DATE
          • TIME_TO_SEC
          • TIMEDIFF
          • TIMESTAMP
          • TIMESTAMPADD
          • TIMESTAMPDIFF
          • TO_DATE
          • TO_DAYS
          • TO_ISO8601
          • TO_MONDAY
          • UNIX_TIMESTAMP
          • UTC_TIMESTAMP
          • WEEK_CEIL
          • WEEK_FLOOR
          • WEEK
          • WEEKDAY
          • WEEKOFYEAR
          • WEEKS_ADD
          • WEEKS_DIFF
          • WEEKS_SUB
          • YEAR_CEIL
          • YEAR_FLOOR
          • YEAR
          • YEARS_ADD
          • YEARS_DIFF
          • YEARS_SUB
          • YEARWEEK
          • COSINE_DISTANCE
          • INNER_PRODUCT
          • L1_DISTANCE
          • L2_DISTANCE
          • AES_DECRYPT
          • AES_ENCRYPT
          • CRC32
          • MD5
          • MD5SUM
          • MURMUR_HASH3_32
          • MURMUR_HASH3_64
          • SHA1
          • SHA2
          • SM3
          • SM3SUM
          • SM4_DECRYPT
          • SM4_ENCRYPT
          • XXHASH_32
          • XXHASH_64
          • HLL_CARDINALITY
          • HLL_EMPTY
          • HLL_FROM_BASE64
          • HLL_HASH
          • HLL_TO_BASE64
          • CUT_IPV6
          • IPV4_CIDR_TO_RANGE
          • IPV4_NUM_TO_STRING
          • IPV4_STRING_TO_NUM_OR_DEFAULT
          • IPV4_STRING_TO_NUM_OR_NULL
          • IPV4_STRING_TO_NUM
          • IPV4_TO_IPV6
          • IPV6_CIDR_TO_RANGE
          • IPV6_NUM_TO_STRING
          • IPV6_STRING_TO_NUM_OR_DEFAULT
          • IPV6_STRING_TO_NUM_OR_NULL
          • IPV6_STRING_TO_NUM
          • IS_IP_ADDRESS_IN_RANGE
          • IS_IPV4_COMPAT
          • IS_IPV4_MAPPED
          • IS_IPV4_STRING
          • IS_IPV6_STRING
          • TO_IPV4_OR_DEFAULT
          • TO_IPV4_OR_NULL
          • TO_IPV4
          • TO_IPV6_OR_DEFAULT
          • TO_IPV6_OR_NULL
          • TO_IPV6
          • GET_JSON_BIGINT
          • GET_JSON_DOUBLE
          • GET_JSON_INT
          • GET_JSON_STRING
          • JSON_ARRAY
          • JSON_CONTAINS
          • JSON_EXISTS_PATH
          • JSON_EXTRACT_BIGINT
          • JSON_EXTRACT_BOOL
          • JSON_EXTRACT_DOUBLE
          • JSON_EXTRACT_INT
          • JSON_EXTRACT_ISNULL
          • JSON_EXTRACT_LARGEINT
          • JSON_EXTRACT_STRING
          • JSON_EXTRACT
          • JSON_INSERT
          • JSON_KEYS
          • JSON_LENGTH
          • JSON_OBJECT
          • JSON_PARSE_ERROR_TO_INVALID
          • JSON_PARSE_ERROR_TO_NULL
          • JSON_PARSE_ERROR_TO_VALUE
          • JSON_PARSE_NOTNULL_ERROR_TO_INVALID
          • JSON_PARSE_NOTNULL_ERROR_TO_VALUE
          • JSON_PARSE_NOTNULL
          • JSON_PARSE_NULLABLE_ERROR_TO_INVALID
          • JSON_PARSE_NULLABLE_ERROR_TO_NULL
          • JSON_PARSE_NULLABLE_ERROR_TO_VALUE
          • JSON_PARSE_NULLABLE
          • JSON_PARSE
          • JSON_QUOTE
          • JSON_REPLACE
          • JSON_SEARCH
          • JSON_SET
          • JSON_TYPE
          • JSON_UNQUOTE
          • JSON_VALID
          • MAP_CONTAINS_KEY
          • MAP_CONTAINS_VALUE
          • MAP_KEYS
          • MAP_SIZE
          • MAP_VALUES
          • MAP
          • STR_TO_MAP
          • ABS
          • ACOS
          • ASIN
          • ATAN
          • ATAN2
          • BIN
          • CBRT
          • CEIL
          • CONV
          • COS
          • COSH
          • DEGREES
          • E
          • EXP
          • FLOOR
          • FMOD
          • LN
          • LOG
          • LOG10
          • LOG2
          • MOD
          • MONEY_FORMAT
          • NEGATIVE
          • NORMAL_CDF
          • PI
          • PMOD
          • POSITIVE
          • POW
          • RADIANS
          • RANDOM
          • ROUND_BANKERS
          • ROUND
          • SIGN
          • SIN
          • SQRT
          • TAN
          • TANH
          • TRUNCATE
          • UUID_NUMERIC
          • WIDTH_BUCKET
          • XOR
          • CONVERT_TO
          • ESQUERY
          • FIELD
          • G
          • QUANTILE_PERCENT
          • QUANTILE_STATE_EMPTY
          • TO_QUANTILE_STATE
          • ST_ANGLE_SPHERE
          • ST_ANGLE
          • ST_AREA_SQUARE_KM
          • ST_AREA_SQUARE_METERS
          • ST_ASBINARY
          • ST_ASTEXT
          • ST_AZIMUTH
          • ST_CIRCLE
          • ST_CONTAINS
          • ST_DISJOINT
          • ST_DISTANCE_SPHERE
          • ST_GEOMETRYFROMTEXT
          • ST_GEOMETRYFROMWKB
          • ST_INTERSECTS
          • ST_LINEFROMTEXT
          • ST_POINT
          • ST_POLYGON
          • ST_TOUCHES
          • ST_X
          • ST_Y
          • APPEND_TRAILING_CHAR_IF_ABSENT
          • ASCII
          • AUTO_PARTITION_NAME
          • CHAR_LENGTH
          • CHAR
          • CONCAT_WS
          • CONCAT
          • COUNT_SUBSTRINGS
          • CUT_TO_FIRST_SIGNIFICANT_SUBDOMAIN
          • DATE
          • DIGITAL_MASKING
          • DOMAIN_WITHOUT_WWW
          • DOMAIN
          • ELT
          • ENDS_WITH
          • EXTRACT_URL_PARAMETER
          • FIND_IN_SET
          • FIRST_SIGNIFICANT_SUBDOMAIN
          • FROM_BASE64
          • FROM_ISO8601_DATE
          • HEX
          • INITCAP
          • INSTR
          • INT_TO_UUID
          • LCASE
          • LENGTH
          • LOCATE
          • LPAD
          • LTRIM_IN
          • LTRIM
          • MASK_FIRST_N
          • MASK_LAST_N
          • MASK
          • MULTI_MATCH_ANY
          • MULTI_SEARCH_ALL_POSITIONS
          • NGRAM_SEARCH
          • OVERLAY
          • PARSE_URL
          • PRINTF
          • PROTOCOL
          • QUOTE
          • RANDOM_BYTES
          • REGEXP_COUNT
          • REGEXP_EXTRACT_ALL
          • REGEXP_EXTRACT_OR_NULL
          • REGEXP_EXTRACT
          • REGEXP_REPLACE_ONE
          • REGEXP_REPLACE
          • REGEXP
          • REPEAT
          • REPLACE_EMPTY
          • REPLACE
          • REVERSE
          • RPAD
          • RTRIM_IN
          • RTRIM
          • SPACE
          • SPLIT_BY_STRING
          • SPLIT_PART
          • STARTS_WITH
          • STRCMP
          • STRLEFT
          • STRRIGHT
          • SUB_REPLACE
          • SUBSTRING_INDEX
          • SUBSTRING
          • TO_BASE64
          • TO_ISO8601
          • TOKENIZE
          • TOP_LEVEL_DOMAIN
          • TRANSLATE
          • TRIM_IN
          • TRIM
          • UCASE
          • UNHEX
          • URL_DECODE
          • UUID
          • WEEK_CEIL
          • WEEK_FLOOR
          • XPATH_STRING
          • URL Encode
          • NAMED_STRUCT
          • STRUCT_ELEMENT
          • STRUCT
          • CONNECTION_ID
          • CURRENT_CATALOG
          • CURRENT_USER
          • DATABASE
          • LAST_QUERY_ID
          • SESSION_USER
          • USER
          • VERSION
        • ANY_VALUE
        • APPROX_COUNT_DISTINCT
        • APPROX_TOP_K
        • APPROX_TOP_SUM
        • ARRAY_AGG
        • AVG_WEIGHTED
        • AVG
        • BITMAP_AGG
        • BITMAP_INTERSECT
        • BITMAP_UNION_COUNT
        • BITMAP-UNION-INT
        • BITMAP_UNION
        • COLLECT_LIST
        • COLLECT_SET
        • CORR
        • COUNT_BY_ENUM
        • COUNT
        • COVAR_SAMP
        • COVAR,COVAR_POP
        • GROUP_ARRAY_INTERSECT
        • GROUP_BIT_AND
        • GROUP_BIT_OR
        • GROUP_BIT_XOR
        • GROUP_BITMAP_XOR
        • GROUP_CONCAT
        • GROUPING_ID
        • GROUPING
        • HISTOGRAM
        • HLL_RAW_AGG
        • HLL_UNION_AGG
        • INTERSECT_COUNT
        • KURT,KURT_POP,KURTOSIS
        • LINEAR_HISTOGRAM
        • MAP_AGG
        • MAX_BY
        • MAX
        • MIN_BY
        • MIN
        • PERCENTILE_APPROX
        • PERCENTILE_ARRAY
        • PERCENTILE
        • PERCENTILE_APPROX_WEIGHTED
        • QUANTILE_UNION
        • REGR_INTERCEPT
        • REGR_SLOPE
        • RETENTION
        • SEQUENCE_COUNT
        • SEQUENCE_MATCH
        • SKEW,SKEW_POP,SKEWNESS
        • STDDEV_SAMP
        • STDDEV,STDDEV_POP
        • SUM
        • SUM0
        • TOPN_ARRAY
        • TOPN_WEIGHTED
        • TOPN
        • VAR_SAMP,VARIANCE_SAMP
        • VARIANCE,VAR_POP,VARIANCE_POP
        • WINDOW_FUNNEL
        • FOREACH
        • MERGE
        • STATE
        • UNION
        • CUME_DIST
        • DENSE_RANK
        • FIRST_VALUE
        • LAG
        • LAST_VALUE
        • LEAD
        • NTILE
        • OVERVIEW
        • PERCENT_RANK
        • RANK
        • ROW_NUMBER
        • EXPLODE_BITMAP
        • EXPLODE_JSON_ARRAY_DOUBLE
        • EXPLODE_JSON_ARRAY_INT
        • EXPLODE_JSON_ARRAY_JSON
        • EXPLODE_JSON_ARRAY_STRING
        • EXPLODE_JSON_OBJECT
        • EXPLODE_MAP
        • EXPLODE_NUMBERS
        • EXPLODE_SPLIT
        • EXPLODE
        • POSEXPLODE
        • BACKENDS
        • CATALOGS
        • FRONTENDS
        • FRONTENDS_DISKS
        • HDFS
        • HUDI_META
        • ICEBERG_META
        • JOBS
        • LOCAL
        • MV_INFOS
        • NUMBERS
        • PARTITION_VALUES
        • PARTITIONS
        • QUERY
        • S3
        • TASKS
        • EXPLAIN
        • SELECT
          • INSERT
          • INSERT OVERWRITE
          • SHOW LAST INSERT
          • UPDATE
          • BACKUP
          • DELETE
          • SHOW-DELETE
        • Load and Export
          • CREATE REPOSITORY
          • DROP REPOSITORY
          • SHOW CREATE REPOSITORY
          • SHOW REPOSITORIES
          • BACKUP
          • CANCEL BACKUP
          • RESTORE
          • SHOW RESTORE
          • CANCEL RESTORE
          • SHOW SNAPSHOT
          • Show Backup
          • BROKER LOAD
          • MYSQL LOAD
          • SHOW LOAD
          • SHOW STREAM LOAD
          • SHOW CREATE LOAD
          • SHOW LOAD WARNINGS
          • CREATE ROUTINE LOAD
          • ALTER ROUTINE LOAD
          • PAUSE ROUTINE LOAD
          • RESUME ROUTINE LOAD
          • STOP ROUTINE LOAD
          • SHOW ROUTINE LOAD
          • SHOW ROUTINE LOAD TASK
          • SHOW CREATE ROUTINE LOAD
          • CREATE SYNC JOB
          • PAUSE SYNC JOB
          • RESUME-SYNC-JOB
          • STOP-SYNC-JOB
          • SHOW-SYNC-JOB
          • SYNC
          • EXPORT
          • CANCEL EXPORT
          • SHOW-EXPORT
          • OUTFILE
          • CLEAN LABEL
          • Cancel Load
          • Clean Label
        • CREATE USER
        • ALTER USER
        • DROP USER
        • SET PASSWORD
        • CREATE ROLE
        • ALTER ROLE
        • DROP ROLE
        • SHOW ROLES
        • PAUSE ROUTINE LOAD
        • REVOKE FROM
        • SHOW PRIVILEGES
        • SHOW GRANTS
        • REFRESH LDAP
        • SET LDAP_ADMIN_PASSWORD
        • SET PROPERTY
        • SHOW PROPERTY
        • Set Password
          • USE COMPUTE GROUP
          • SWITCH CATALOG
          • USE DATABASE
          • SET VARIABLE
          • SHOW VARIABLES
          • UNSET VARIABLE
          • CLEAN ALL PROFILE
          • CLEAN ALL QUERY STATS
          • KILL QUERY
          • PLAN REPLAYER DUMP
          • PLAN REPLAYER PLAY
          • SHOW PROCESSLIST
          • SHOW QUERY STATS
          • KILL CONNECTION
        • BEGIN
        • COMMIT
        • ROLLBACK
        • SHOW TRANSACTION
        • ALTER CATALOG
        • CREATE CATALOG
        • DROP CATALOG
        • REFRESH
        • SHOW CATALOG
        • SHOW CATALOGS
        • SHOW CREATE CATALOG
        • ALTER DATABASE
        • CREATE DATABASE
        • DROP DATABASE
        • SHOW CREATE DATABASE
        • SHOW DATABASE ID
        • SHOW DATABASES
          • ALTER ASYNC MATERIALIZED VIEW
          • CANCEL MATERIALIZED VIEW TASK
          • CREATE ASYNC MATERIALIZED VIEW
          • DROP ASYNC MATERIALIZED VIEW
          • PAUSE MATERIALIZED VIEW JOB
          • REFRESH MATERIALIZED VIEW
          • RESUME MATERIALIZED VIEW
          • SHOW CREATE ASYNC MATERIALIZED VIEW
          • ADMIN CHECK TABLET
          • ADMIN COPY TABLET
          • ADMIN SET REPLICA STATUS
          • ADMIN SET REPLICA VERSION
          • CANCEL REBALANCE DISK
          • CANCEL REPAIR TABLE
          • ADMIN CLEAN TRASH
          • COMPACT TABLE
          • DIAGNOSE TABLET
          • REBALANCE DISK
          • REPAIR TABLE
          • SET TABLE PARTITION VERSION
          • SET TABLE STATUS
          • SHOW DATA SKEW
          • SHOW DATA
          • SHOW REPLICA DISTRIBUTION
          • SHOW REPLICA STATUS
          • SHOW TABLET DIAGNOSIS
          • SHOW TABLET STORAGE FORMAT
          • SHOW TABLET
          • SHOW TABLETS BELONG
          • SHOW TRASH
          • BUILD INDEX
          • CANCEL BUILD INDEX
          • CREATE INDEX
          • DROP INDEX
          • SHOW BUILD INDEX
          • SHOW INDEX
          • CREATE SYNC MATERIALIZED VIEW
          • DROP MATERIALIZED VIEW
          • SHOW ALTER TABLE MATERIALIZED VIEW
          • SHOW CREATE SYNC MATERIALIZED VIEW
          • ALTER COLOCATE GROUP
          • ALTER TABLE ADD GENERATED COLUMN
          • ALTER TABLE COLUMN
          • ALTER TABLE COMMENT
          • ALTER TABLE PARTITION
          • ALTER TABLE PROPERTY
          • ALTER TABLE RENAME
          • ALTER TABLE REPLACE
          • ALTER TABLE ROLLUP
          • CANCEL ALTER TABLE
          • CREATE TABLE
          • DESCRIBE
          • DROP TABLE
          • SHOW ALTER
          • SHOW COLUMNS
          • SHOW CONVERT LIGHT SCHEMA CHANGE PROCESS
          • SHOW CREATE TABLE
          • SHOW DYNAMIC PARTITION TABLES
          • SHOW PARTITION ID
          • SHOW PARTITION
          • SHOW PARTITIONS
          • SHOW TABLE ID
          • SHOW TABLE STATUS
          • SHOW TABLES
          • TRUNCATE TABLE
          • ALTER VIEW
          • CREATE VIEW
          • DROP VIEW
          • SHOW CREATE VIEW
          • SHOW VIEW
        • DROP CATALOG RECYCLE BIN
        • RECOVER
        • SHOW CATALOG RECYCLE BIN
        • CREATE FUNCTION
        • DESC FUNCTION
        • DROP FUNCTION
        • SHOW CREATE FUNCTION
        • SHOW FUNCTIONS
        • ALTER STATS
        • ANALYZE
        • DROP ANALYZE JOB
        • DROP STATS
        • KILL ANALYZE JOB
        • SHOW ANALYZE
        • SHOW COLUMN STATS
        • SHOW TABLE STATS
          • ALTER RESOURCE
          • ALTER WORKLOAD GROUP
          • ALTER WORKLOAD POLICY
          • CREATE RESOURCE
          • CREATE WORKLOAD GROUP
          • CREATE WORKLOAD GROUP
          • DROP RESOURCE
          • DROP WORKLOAD GROUP
          • DROP WORKLOAD POLICY
          • SHOW COMPUTE GROUPS
          • SHOW RESOURCES
          • SHOW WORKLOAD GROUPS
          • ADD BACKEND
          • ADD BROKER
          • ADD FOLLOWER
          • ADD OBSERVER
          • CANCEL DECOMMISSION BACKEND
          • DECOMMISSION BACKEND
          • DROP BACKEND
          • DROP BROKER
          • DROP FOLLOWER
          • DROP OBSERVER
          • MODIFY BACKEND
          • MODIFY FRONTEND HOSTNAME
          • SET FRONTEND CONFIG
          • SHOW BACKEND CONFIG
          • SHOW BACKENDS
          • SHOW BROKER
          • SHOW FRONTEND CONFIG
          • SHOW FRONTENDS DISKS
          • SHOW FRONTENDS
          • ALTER STORAGE POLICY
          • ALTER STORAGE VAULT
          • CANCEL WARM UP
          • CREATE STORAGE POLICY
          • CREATE-STORAGE-VAULT
          • DROP STORAGE POLICY
          • SET DEFAULT STORAGE VAULT
          • SHOW CACHE HOTSPOT
          • SHOW STORAGE POLICY USING
          • SHOW STORAGE POLICY
          • SHOW STORAGE VAULTS
          • SHOW WARM UP JOB
          • UNSET DEFAULT STORAGE VAULT
          • WARM UP
        • CREATE ENCRYPTKEY
        • CREATE FILE
        • DROP ENCRYPTKEY
        • DROP FILE
        • SHOW ENCRYPTKEY
        • SHOW FILE
        • ALTER SQL_BLOCK_RULE
        • CREATE ROW POLICY
        • CREATE SQL_BLOCK_RULE
        • DROP ROW POLICY
        • DROP SQL_BLOCK_RULE
        • SHOW ROW POLICY
        • SHOW SQL_BLOCK_RULE
        • CANCEL TASK
        • CREATE JOB
        • DROP JOB
        • PAUSE JOB
        • RESUME JOB
        • INSTALL PLUGIN
        • SHOW PLUGINS
        • UNINSTALL PLUGIN
        • SHOW CHARSET
        • SHOW COLLATION
        • SHOW DATA TYPES
        • SHOW TYPECAST
        • SHOW PROC

    • Install Error
    • Data Operation Error
    • SQL Error
    • Lakehouse FAQ
    • BI FAQ
    • Data Integrity FAQ
    • Load FAQ

    • Security Overview
      • Authentication and Authorization
        • Built-in Authentication
        • Federated Authentication
        • Built-in Authorization
        • Data Access Control
        • Ranger Authorization
    • Audit Log
      • Encryption and Masking Function
        • MySQL Client Certificate
        • FE SSL Certificate
      • Aws Authentication and Authorization
      • Security Features
      • Security Certification
      • Security and Trust Platform

    • Platform Release Notes
    • Core Release Notes
      • v4.0
      • v3.0
      • v2.4
      • v2.3
      • v2.2
      • v2.0

VeloDB Cloud
User Guide
Query Execution
Complex Type

Complex Type

Doris supports complex types such as Array, Map, Struct, and JSON.

Doris provides various functions specifically designed for these complex types.

For detailed information on the supported functions, please refer to the SQL manual - Array functions, SQL manual - Map functions data type, SQL manual - Struct functions, and SQL manual - Json functions.

Java UDF, UDAF, UDTFColumn to Row (Lateral View)
© VeloDB Inc. | Apache, Doris, Apache Doris, the Apache feather logo and the Apache Doris logo are trademarks of The Apache Software Foundation.