logo
  • Release Notes
  • Introduction to CelerData Cloud Serverless
    • What is CelerData Cloud Serverless?
    • Key concepts and architecture
    • Supported cloud platforms and regions
  • Quick Start
    • Sign up for CelerData Cloud Serverless
    • A quick tour of the console
    • Connect to CelerData Cloud Serverless
    • Create an IAM integration
    • Create and assign a warehouse
    • Create an external catalog
    • Load data from cloud storage
    • Load data from Apache Kafka/Confluent Cloud
    • Try your first query
    • Invite new users
    • Design data access control policy
  • Warehouses
    • Overview of warehouses
    • Manage warehouses
  • Catalog, database, table, view, and MV
    • Overview of database objects
    • Catalog
      • Overview
      • Default catalog
      • Hive catalog
      • Iceberg catalog
      • Tabular catalog
      • Hudi catalog
      • Delta Lake catalog
      • Unified catalog
    • Table types
      • Overview
      • Duplicate Key table
      • Aggregate table
      • Unique Key table
      • Primary Key table
    • Asynchronous materialized views
      • Overview
      • Use cases
        • Data modeling
        • Query rewrite
        • Data lake query acceleration
      • Usage
        • CREATE MATERIALIZED VIEW
        • ALTER MATERIALIZED VIEW
        • DROP MATERIALIZED VIEW
        • SHOW MATERIALIZED VIEWS
        • information_schema.materialized_views
        • Troubleshooting
  • Data Loading
    • Batch load data from Amazon S3
    • Load streaming data from Confluent Cloud
      • Overview
      • Load streaming data from Confluent Cloud using Routine Load
      • Load streaming data from Confluent Cloud using Kafka connector
    • Load data from a local file system
  • Data access control
    • Overview of access control
    • Privileges
    • Manage user privileges
    • Column and row-level security
      • Understand column and row-level security
      • Masking policies
      • Row access policies
      • Manage privileges for policies
  • Networking and private connectivity
    • Connect with a Private Link
    • IP Firewall
  • Usage and Billing
    • Understand usage and billing
  • Organization and Account
    • Organization and account
  • Integration
    • Authenticate to AWS resources
    • BI tools
      • Hex
      • Querybook
      • Apache Superset
      • Tableau Desktop
    • IDE tools
      • DataGrip
      • DBeaver
  • Query Acceleration
    • CBO
    • Colocate join
    • Indexing
      • Bitmap indexing
      • Bloomfilter indexing
    • Data Deduplication
      • Use Bitmap for exact count distinct
      • Use HLL for approximate count distinct
    • Lateral join
  • Reference
    • AWS IAM policies
    • Information Schema
      • Overview
      • be_bvars
      • be_cloud_native_compactions
      • be_compactions
      • character_sets
      • collations
      • column_privileges
      • columns
      • engines
      • events
      • global_variables
      • key_column_usage
      • load_tracking_logs
      • loads
      • materialized_views
      • partitions
      • pipe_files
      • pipes
      • referential_constraints
      • routines
      • schema_privileges
      • schemata
      • session_variables
      • statistics
      • table_constraints
      • table_privileges
      • tables
      • tables_config
      • task_runs
      • tasks
      • triggers
      • user_privileges
      • views
    • Data Types
      • Data Type List
      • VARCHAR
      • Map
      • INT
      • JSON
      • DATA
      • STRUCT
      • BITMAP
      • DOUBLE
      • STRING
      • HLL
      • ARRAY
      • DATETIME
      • LARGEINT
      • SMALLINT
      • TINYINT
      • BINARY
      • DECIMAL
      • BIGINT
      • BOOLEAN
      • FLOAT
      • CHAR
    • System Metadatabase
      • Overview
      • grants_to_roles
      • grants_to_users
      • role_edges
      • object_dependencies
      • policy_references
    • Keywords
    • SQL Statements
      • Account Management
        • SET ROLE
        • REVOKE
        • GRANT
        • SHOW GRANTS
        • CREATE ROLE
        • DROP ROLE
        • SET DEFAULT ROLE
        • SHOW USERS
        • SHOW ROLES
        • SET PROPERTY
      • Data Definition
        • CREATE TABLE
        • ALTER TABLE
        • DROP CATALOG
        • CREATE TABLE LIKE
        • REFRESH EXTERNAL TABLE
        • RESTORE
        • SET CATALOG
        • DROP TABLE
        • RECOVER
        • USE
        • CREATE MATERIALIZED VIEW
        • DROP DATABASE
        • ALTER MATERIALIZED VIEW
        • DROP REPOSITORY
        • CANCEL RESTORE
        • DROP INDEX
        • DROP MATERIALIZED VIEW
        • CREATE DATABASE
        • CREATE TABLE AS SELECT
        • BACKUP
        • CANCEL BACKUP
        • CREATE REPOSITORY
        • CREATE INDEX
      • Data Manipulation
        • INSERT
        • SHOW CREATE DATABASE
        • SHOW BACKUP
        • SHOW ALTER MATERIALIZED VIEW
        • SHOW CATALOGS
        • SHOW CREATE MATERIALIZED VIEW
        • SELECT
        • SHOW ALTER
        • SHOW MATERIALIZED VIEW
        • RESUME ROUTINE LOAD
        • ALTER ROUTINE LOAD
        • SHOW TABLES
        • STREAM LOAD
        • SHOW PARTITIONS
        • CANCEL REFRESH MATERIALIZED VIEW
        • SHOW CREATE CATALOG
        • SHOW ROUTINE LOAD TASK
        • SHOW RESTORE
        • CREATE ROUTINE LOAD
        • STOP ROUTINE LOAD
        • SHOW DATABASES
        • BROKER LOAD
        • SHOW ROUTINE LOAD
        • PAUSE ROUTINE LOAD
        • SHOW SNAPSHOT
        • SHOW CREATE TABLE
        • CANCEL LOAD
        • REFRESH MATERIALIZED VIEW
        • SHOW REPOSITORIES
        • SHOW LOAD
      • Administration
        • SHOW PROC
        • EXPLAIN
        • ADMIN SHOW CONFIG
        • ADMIN SET CONFIG
        • SHOW INDEX
      • DESCRIBE
    • SQL Functions
      • Function List
      • String Functions
        • CONCAT
        • HEX
        • LOWER
        • SPLIT
        • LPAD
        • SUBSTRING
        • PARSE_URL
        • INSTR
        • REPEAT
        • LCASE
        • REPLACE
        • HEX_DECODE_BINARY
        • RPAD
        • SPLIT_PART
        • STRCMP
        • SPACE
        • CHARACTER_LENGTH
        • URL_ENCODE
        • APPEND_TAILING_CHAR_IF_ABSENT
        • LTRIM
        • HEX_DECODE_STRING
        • URL_DECODE
        • LEFT
        • STARTS_WITH
        • CONCAT
        • GROUP_CONCAT
        • STR_TO_MAP
        • STRLEFT
        • STRRIGHT
        • MONEY_FORMAT
        • RIGHT
        • SUBSTRING_INDEX
        • UCASE
        • TRIM
        • FIND_IN_SET
        • RTRIM
        • ASCII
        • UPPER
        • REVERSE
        • LENGTH
        • UNHEX
        • ENDS_WITH
        • CHAR_LENGTH
        • NULL_OR_EMPTY
        • LOCATE
        • CHAR
      • Predicate Functions
        • REGEXP
        • REGEXP_EXTRACT_ALL
        • REGEXP_EXTRACT
        • REGEXP_REPLACE
        • LIKE
      • Map Functions
        • MAP_KEYS
        • MAP_VALUES
        • MAP_CONCAT
        • MAP_SIZE
        • MAP_FROM_ARRAYS
        • MAP_APPLY
        • TRANSFORM_KEYS
        • CARDINALITY
        • DISTINCT_MAP_KEYS
        • MAP_FILTER
        • ELEMENT_AT
        • TRANSFORM_VALUES
      • Binary Functions
        • TO_BINARY
        • FROM_BINARY
      • Geospatial Functions
        • ST_X
        • ST_Y
        • S_CIRCLE
        • ST_DISTANCE_SPHERE
        • ST_POINT
        • ST_POLYGON
        • ST_ASTEXT
        • ST_CONTAINS
        • ST_GEOMETRY_FROM_TEXT
        • ST_LINE_FROM_TEXT
      • Lambda Expression
        • Lambda Expression
      • Utility Functions
        • SLEEP
        • UUID
        • IS_NOT_NULL
        • CURRENT_VERSION
        • LAST_QUERY_ID
        • HOST_NAME
        • VERSION
        • UUID_NUMERIC
        • CATALOG
        • IS_NULL
        • CURRENT_ROLE
        • DATABASE
      • Bitmap Functions
        • BITMAP_SUBSET_LIMIT
        • TO_BITMAP
        • BITMAP_AGG
        • BITMAP_FROM_STRING
        • BITMAP_OR
        • BITMAP_REMOVE
        • BITMAP_AND
        • BITMAP_TO_BASE64
        • BITMAP_MIN
        • BITMAP_CONTAINS
        • SUB_BITMAP
        • BITMAP_UNION
        • BITMAP_COUNT
        • BITMAP_UNION_INT
        • BITMAP_XOR
        • BITMAP_UNION_COUNT
        • BITMAP_HAS_ANY
        • BITMAP_INTERSECT
        • BITMAP_AND_NOT
        • BITMAP_TO_STRING
        • BITMAP_HASH
        • INTERSECT_COUNT
        • BITMAP_EMPTY
        • BITMAP_MAX
        • BASE64_TO_ARRAY
        • BITMAP_TO_ARRAY
      • Struct Functions
        • NAMED_STRUCT
        • ROW
      • Aggregate Functions
        • RETENTION
        • MI
        • MULTI_DISTINCT_SUM
        • WINDOW_FUNNEL
        • STDDEV_SAMP
        • GROUPING_ID
        • HLL_HASH
        • AVG
        • HLL_UNION_AGG
        • COUNT
        • BITMAP
        • HLL_EMPTY
        • SUM
        • MAX_BY
        • PERCENTILE_CONT
        • COVAR_POP
        • PERCENTILE_APPROX
        • HLL_RAW_AGG
        • STDDEV
        • CORR
        • COVAR_SAMP
        • MIN_BY
        • MAX
        • VAR_SAMP
        • STD
        • HLL_UNION
        • APPROX_COUNT_DISTINCT
        • MULTI_DISTINCT_COUNT
        • VARIANCE
        • ANY_VALUE
        • COUNT_IF
        • GROUPING
        • PERCENTILE_DISC
      • Array Functions
        • ARRAY_CUM_SUM
        • ARRAY_MAX
        • ARRAY_LENGTH
        • ARRAY_REMOVE
        • UNNEST
        • ARRAY_SLICE
        • ALL_MATCH
        • ARRAY_CONCAT
        • ARRAY_SORT
        • ARRAY_POSITION
        • ARRAY_DIFFERENCE
        • ARRAY_CONTAINS
        • ARRAY_JOIN
        • ARRAY_INTERSECT
        • CARDINALITY
        • ARRAY_CONTAINS_ALL
        • ARRAYS_OVERLAP
        • ARRAY_MIN
        • ARRAY_MAP
        • ELEMENT_AT
        • ARRAY_APPEND
        • ARRAY_SORTBY
        • ARRAY_TO_BITMAP
        • ARRAY_GENERATE
        • ARRAY_AVG
        • ARRAY_FILTER
        • ANY_MATCH
        • REVERSE
        • ARRAY_AGG
        • ARRAY_DISTINCT
        • ARRAY_SUM
      • Condition Functions
        • NULLIF
        • IFNULL
        • IF
        • CASE_WHEN
        • COALESCE
      • Math Functions
        • COT
        • LOG10
        • PMOD
        • RAND
        • GREATEST
        • COS_SIMILARITY
        • ROUND
        • ACOS
        • ATAN
        • EXP
        • MOD
        • SIN
        • RADIANS
        • SQUARE
        • LOG2
        • CONV
        • SINH
        • SIGN
        • COSH
        • FMOD
        • TANH
        • LOG
        • SQRT
        • POSITIVE
        • CEILING
        • POW
        • TRUNCATE
        • FLOOR
        • COS_SIMIlARITY_NORM
        • DIVIDE
        • ABS
        • BIN
        • LEAST
        • CEIL
        • PI
        • DEGREES
        • MULTIPLY
        • ASIN
        • NEGATIVE
        • LN
        • E
        • TAN
        • COS
        • ATAN2
      • Date and Time Functions
        • DAYNAME
        • MINUTE
        • FROM_UNIXTIME
        • HOUR
        • MONTHNAME
        • MONTHS_ADD
        • ADD_MONTHS
        • DATE_SUB
        • PREVIOUS_DAY
        • TO_TERA_DATA
        • MINUTES_SUB
        • WEEKS_ADD
        • HOURS_DIFF
        • UNIX_TIMESTAMP
        • DAY
        • DATE_SLICE
        • DATE
        • CURTIME
        • SECONDS_SUB
        • MONTH
        • WEEK
        • TO_DATE
        • TIMEDIFF
        • MONTHS_DIFF
        • STR_TO_JODATIME
        • WEEK_ISO
        • MICROSECONDS_SUB
        • TIME_SLICE
        • MAKEDATE
        • DATE_TRUNC
        • JODATIME
        • DAYOFWEEK
        • YEARS_SUB
        • TIMESTAMP_ADD
        • HOURS_SUB
        • STR2DATE
        • TIMESTAMP
        • FROM_DAYS
        • WEEK_OF_YEAR
        • YEAR
        • TIMESTAMP_DIFF
        • TO_TERA_TIMESTAMP
        • DAYOFMONTH
        • DAYOFYEAR
        • DATE_FORMAT
        • MONTHS_SUB
        • NEXT_DAY
        • MINUTES_DIFF
        • DATA_ADD
        • MINUTES_ADD
        • CURDATE
        • DAY_OF_WEEK_ISO
        • CURRENt_TIMESTAMP
        • STR_TO_DATE
        • LAST_DAY
        • WEEKS_SUB
        • TO_DAYS
        • DATEDIFF
        • NOW
        • TO_ISO8601
        • TIME_TO_SEC
        • QUARTER
        • SECONDS_DIFF
        • UTC_TIMESTAMP
        • DATA_DIFF
        • SECONDS_ADD
        • ADDDATE
        • WEEKSDIFF
        • CONVERT_TZ
        • MICROSECONDS_ADD
        • SECOND
        • YEARS_DIFF
        • YEARS_ADD
        • HOURS_ADD
        • DAYS_SUB
        • DAYS_DIFF
      • Cryptographic Functions
        • SHA2
        • BASE64_DECODE_BINARY
        • SM3
        • AES_DECRYPT
        • MD5
        • AES_ENCRYPT
        • MD5SUM
        • MD5SUM_NUMERIC
        • FROM_BASE64
        • TO_BASE64
        • BASE64_DECODE_STRING
      • Percentile Functions
        • PERCENTILE_APPROX_RAW
        • PERCENTILE_UNION
        • PERCENTILE_HASH
        • PERCENTILE_EMPTY
      • Bit Functions
        • BITOR
        • BITAND
        • BIT_SHIFT_RIGHT_LOGICAL
        • BITXOR
        • BITNOT
        • BIT_SHIFT_LEFT
        • BIT_SHIFT_RIGHT
      • JSON Functions
        • Overview of JSON functions and operators
        • JSON_KEYS
        • JSON_STRING
        • GET_JSON_INT
        • GET_JSON_STRING
        • GET_JSON_DOUBLE
        • JSON_EACH
        • TO_JSON
        • JSON_LENGTH
        • ARROW FUNCTION
        • CAST
        • JSON_QUERY
        • JSON_EXISTS
        • JSON Operators
        • JSON_ARRAY
        • PARSE_JSON
        • JSON_OBJECT
      • Hash Functions
        • MURMUR_HASH3_32
      • Scalar Functions
        • HLL_CARDINALITY
      • Table Functions
        • GENERATE_SERIES
        • FILES

Copyright © 2024 CelerData