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
SQL Reference
SQL Functions
Scalar Functions
Json Functions
JSON_EXTRACT_BOOL

JSON_EXTRACT_BOOL

JSON_EXTRACT_BIGINTJSON_EXTRACT_DOUBLE
© VeloDB Inc. | Apache, Doris, Apache Doris, the Apache feather logo and the Apache Doris logo are trademarks of The Apache Software Foundation.