Dremio Software

Getting Started with Dremio on AWS
Getting Started with Dremio on Azure
Getting Started with Dremio on GCP
Getting Started with Dremio on Your Infrastructure
Cluster Deployments
Connecting to Your Data
- Metastores
  - AWS Glue
  - Hive
- Object Storage
Data Formats
Managing Your Data
- Datasets
- Concepts
- Views
- Data Curation
Querying Your Data
Viewing Jobs
Accelerating Queries with Reflections
Managing Security
Connecting from Client Applications
- Drivers
- Clients
Developing Client Applications with Arrow Flight
- Arrow Flight
- Arrow Flight SQL
API Reference
- Catalog
  - Source
    - Source Configuration
  - Home
  - Space
  - Folder
  - File
  - Table
  - View
  - Lineage
  - Tag
  - Wiki
  - Privileges
  - Grants
- Job
  - Job Results
- Node Collections
- LDAP User Cache
- Reflection
  - Reflection Summary (24.0+)
  - Reflection Summary (23.x and earlier)
- Role
  - Role Privileges
- SQL
- Token
- User
  - User Privileges
  - User Tokens
- Workload Management
  - Queue
  - Rule
SQL Reference
- Data Types
- SQL Functions
  - All Functions
    - ABS
    - ACOS
    - AES_DECRYPT
    - AES_ENCRYPT
    - APPROX_COUNT_DISTINCT
    - ARRAY_CONTAINS
    - ASCII
    - ASIN
    - ATAN
    - AVG
    - BASE64
    - BIN
    - BINARY_STRING
    - BIT_AND
    - BIT_LENGTH
    - BIT_OR
    - BOOL_AND
    - BOOL_OR
    - BROUND
    - BTRIM
    - CASE
    - CAST
    - CBRT
    - CEILING
    - CHARACTER_LENGTH
    - CHAR_LENGTH
    - CHR
    - COALESCE
    - COL_LIKE
    - CONCAT
    - CONCAT_WS
    - CONTAINS
    - CONVERT_FROM
    - CONVERT_REPLACEUTF8
    - CONVERT_TIMEZONE
    - CONVERT_TO
    - CORR
    - COS
    - COSH
    - COT
    - COUNT
    - COVAR_POP
    - COVAR_SAMP
    - CRC32
    - CUME_DIST
    - CURRENT_DATE
    - CURRENT_DATE_UTC
    - CURRENT_SCHEMA
    - CURRENT_TIME
    - CURRENT_TIMESTAMP
    - DATEDIFF
    - DATE_ADD
    - DATE_DIFF
    - DATE_PART
    - DATE_SUB
    - DATE_TRUNC
    - DAY
    - DAYOFMONTH
    - DAYOFWEEK
    - DAYOFYEAR
    - DEGREES
    - DENSE_RANK
    - E
    - ENCODE
    - ENDS_WITH
    - EXP
    - EXTRACT
    - FACTORIAL
    - FIRST_VALUE
    - FLATTEN
    - FLOOR
    - FROM_HEX
    - GEO_BEYOND
    - GEO_DISTANCE
    - GEO_NEARBY
    - GREATEST
    - HASH
    - HEX
    - HLL
    - HOUR
    - ILIKE
    - IMAXDIR
    - IMINDIR
    - INITCAP
    - INSTR
    - IS [NOT] DISTINCT FROM
    - ISDATE
    - IS [NOT] FALSE
    - IS [NOT] NULL
    - ISNUMERIC
    - IS [NOT] TRUE
    - IS_BIGINT
    - IS_INT
    - IS_MEMBER
    - IS_SUBSTR
    - IS_UTF8
    - IS_VARCHAR
    - LAG
    - LAST_DAY
    - LAST_QUERY_ID
    - LCASE
    - LEAD
    - LEAST
    - LEFT
    - LENGTH
    - LEVENSHTEIN
    - LIKE
    - LISTAGG
    - LN
    - LOCALTIME
    - LOCALTIMESTAMP
    - LOCATE
    - LOG
    - LOG10
    - LOWER
    - LPAD
    - LSHIFT
    - LTRIM
    - MAP_KEYS
    - MAP_VALUES
    - MASK
    - MASK_FIRST_N
    - MASK_HASH
    - MASK_LAST_N
    - MASK_SHOW_FIRST_N
    - MASK_SHOW_LAST_N
    - MAX
    - MAXDIR
    - MD5
    - MEDIAN
    - MIN
    - MINDIR
    - MINUTE
    - MOD
    - MONTH
    - MONTHS_BETWEEN
    - NDV
    - NEXT_DAY
    - NOW
    - NTILE
    - NULLIF
    - NVL
    - OCTET_LENGTH
    - PERCENTILE_CONT
    - PERCENTILE_DISC
    - PERCENT_RANK
    - PI
    - POSITION
    - POW, POWER
    - QUARTER
    - QUERY_USER
    - QUOTE
    - RADIANS
    - RANDOM
    - RANK
    - REGEXP_EXTRACT
    - REGEXP_LIKE
    - REGEXP_MATCHES
    - REGEXP_REPLACE
    - REGEXP_SPLIT
    - REPEAT
    - REPEATSTR
    - REPLACE
    - REVERSE
    - RIGHT
    - ROUND
    - ROW_NUMBER
    - RPAD
    - RSHIFT
    - RTRIM
    - SECOND
    - SESSION_USER
    - SHA, SHA1
    - SHA256
    - SHA512
    - SIGN
    - SIMILAR_TO
    - SIN
    - SINH
    - SIZE
    - SOUNDEX
    - SPLIT_PART
    - SQRT
    - STARTS_WITH
    - STDDEV
    - STDDEV_POP
    - STDDEV_SAMP
    - STRPOS
    - SUBSTR
    - SUBSTRING
    - SUBSTRING_INDEX
    - SUM
    - SYSTEM_USER
    - TAN
    - TANH
    - TIMESTAMPADD
    - TIMESTAMPDIFF
    - TOASCII
    - TO_CHAR
    - TO_DATE
    - TO_HEX
    - TO_NUMBER
    - TO_TIME
    - TO_TIMESTAMP
    - TRANSACTION_TIMESTAMP
    - TRANSLATE
    - TRIM
    - TRUNCATE
    - TYPEOF
    - UCASE
    - UNBASE64
    - UNHEX
    - UNIX_TIMESTAMP
    - UPPER
    - USER
    - VAR_POP
    - VAR_SAMP
    - WEEK
    - WEEKOFYEAR
    - XOR
    - YEAR
  - Aggregate
    - APPROX_COUNT_DISTINCT
    - AVG
    - BIT_AND
    - BIT_OR
    - CORR
    - COUNT
    - COVAR_POP
    - COVAR_SAMP
    - HLL
    - LISTAGG
    - MAX
    - MIN
    - NDV
    - STDDEV
    - STDDEV_POP
    - STDDEV_SAMP
    - SUM
    - VAR_POP
    - VAR_SAMP
  - Binary
    - BASE64
    - BIN
    - BIT_LENGTH
    - CRC32
    - ENCODE
    - FROM_HEX
    - HEX
    - TO_HEX
    - UNBASE64
    - UNHEX
  - Bitwise
    - BIT_AND
    - BIT_OR
    - LSHIFT
    - RSHIFT
    - XOR
  - Boolean
  - Conditional
    - BOOL_AND
    - BOOL_OR
    - CASE
    - COALESCE
    - GREATEST
    - LEAST
    - NULLIF
    - NVL
  - Conversion
    - BINARY_STRING
    - CAST
    - CONVERT_FROM
    - CONVERT_REPLACEUTF8
    - CONVERT_TIMEZONE
    - CONVERT_TO
    - ENCODE
    - FLATTEN
    - FROM_HEX
    - HASH
    - HEX
    - TOASCII
    - TO_CHAR
    - TO_DATE
    - TO_HEX
    - TO_NUMBER
    - TO_TIME
    - TO_TIMESTAMP
    - UNHEX
  - Cryptography
    - AES_DECRYPT
    - AES_ENCRYPT
    - MD5
    - SHA, SHA1
    - SHA256
    - SHA512
  - Data Generation
    - RANDOM
  - Datatype
    - IS [NOT] DISTINCT FROM
    - ISDATE
    - IS [NOT] FALSE
    - IS [NOT] NULL
    - IS [NOT] TRUE
    - IS_BIGINT
    - IS_INT
    - IS_SUBSTR
    - IS_VARCHAR
    - SIZE
    - TYPEOF
  - Date/Time
    - CONVERT_TIMEZONE
    - CURRENT_DATE
    - CURRENT_DATE_UTC
    - CURRENT_TIME
    - CURRENT_TIMESTAMP
    - DATEDIFF
    - DATE_ADD
    - DATE_DIFF
    - DATE_PART
    - DATE_SUB
    - DATE_TRUNC
    - DAY
    - DAYOFMONTH
    - DAYOFWEEK
    - DAYOFYEAR
    - EXTRACT
    - HOUR
    - LAST_DAY
    - MINUTE
    - MONTH
    - MONTHS_BETWEEN
    - NEXT_DAY
    - QUARTER
    - SECOND
    - TIMESTAMPADD
    - TIMESTAMPDIFF
    - TO_DATE
    - TO_TIME
    - TO_TIMESTAMP
    - UNIX_TIMESTAMP
    - WEEK
    - WEEKOFYEAR
    - YEAR
  - Directory
    - IMAXDIR
    - IMINDIR
    - MAXDIR
    - MINDIR
  - Geospatial
  - Math
    - ABS
    - ACOS
    - ASIN
    - ATAN
    - BROUND
    - CBRT
    - CEILING
    - COS
    - COSH
    - COT
    - DEGREES
    - E
    - EXP
    - FACTORIAL
    - FLOOR
    - LN
    - LOG
    - LOG10
    - MOD
    - PI
    - POW, POWER
    - RADIANS
    - ROUND
    - SIGN
    - SIN
    - SINH
    - SQRT
    - STDDEV
    - STDDEV_POP
    - STDDEV_SAMP
    - TAN
    - TANH
    - TRUNCATE
  - Percentile
  - Regular Expressions
  - Semistructured Data
  - String
    - ASCII
    - BASE64
    - BTRIM
    - CHARACTER_LENGTH
    - CHAR_LENGTH
    - CHR
    - COL_LIKE
    - CONCAT
    - CONCAT_WS
    - CONTAINS
    - CRC32
    - ENDS_WITH
    - FROM_HEX
    - HEX
    - ILIKE
    - INITCAP
    - INSTR
    - IS_UTF8
    - LCASE
    - LEFT
    - LENGTH
    - LEVENSHTEIN
    - LIKE
    - LOCATE
    - LOWER
    - LPAD
    - LTRIM
    - MASK
    - MASK_FIRST_N
    - MASK_HASH
    - MASK_LAST_N
    - MASK_SHOW_FIRST_N
    - MASK_SHOW_LAST_N
    - OCTET_LENGTH
    - POSITION
    - QUOTE
    - REGEXP_EXTRACT
    - REGEXP_LIKE
    - REGEXP_MATCHES
    - REGEXP_REPLACE
    - REGEXP_SPLIT
    - REPEAT
    - REPEATSTR
    - REPLACE
    - REVERSE
    - RIGHT
    - RPAD
    - RTRIM
    - SIMILAR_TO
    - SOUNDEX
    - SPLIT_PART
    - STARTS_WITH
    - STRPOS
    - SUBSTR
    - SUBSTRING
    - SUBSTRING_INDEX
    - TOASCII
    - TO_HEX
    - TRANSLATE
    - TRIM
    - UCASE
    - UNBASE64
    - UNHEX
    - UPPER
  - System
  - Window
    - COUNT
    - COVAR_POP
    - COVAR_SAMP
    - CUME_DIST
    - DENSE_RANK
    - FIRST_VALUE
    - HLL
    - LAG
    - LEAD
    - MAX
    - MIN
    - NDV
    - NTILE
    - PERCENT_RANK
    - RANK
    - ROW_NUMBER
    - SUM
    - VAR_POP
    - VAR_SAMP
- SQL Commands
  - Apache Iceberg Tables
    - ALTER
    - COPY INTO <table>
    - CREATE
    - DELETE
    - DROP
    - INSERT
    - MERGE
    - OPTIMIZE
    - ROLLBACK
    - SELECT
    - TRUNCATE
    - UPDATE
  - Analyze Table
  - Datasets
  - Privileges
  - Queue Routing
  - Reflections
  - Roles
  - Row-Access & Column-Masking
  - SELECT
  - Sources
  - Tables
  - USE
  - User-Defined Functions
  - Users
  - WITH
- Reserved Words
- System Tables
  - Jobs
  - Membership
  - Privileges
  - Reflection Dependencies
  - Reflections
  - Roles
  - Tables
  - Timezone Names
  - User Defined Functions
  - Users
  - Version
  - Views
- Information Schema
  - Catalogs
  - Columns
  - Schemata
  - Tables
  - Views
Knowledge Base
Release Notes
Legacy JDBC Driver Release Notes
ODBC Driver for Arrow Flight SQL Release Notes
- ODBC Driver for Arrow Flight SQL 0.9.1
- ODBC Driver for Arrow Flight SQL 0.9.0
JDBC Driver for Arrow Flight SQL Release Notes
- JDBC Driver for Arrow Flight SQL 10.0.0
Glossary

On this page

Knowledge Base

This section provides Knowledge Base information.

Apache Log4j Vulnerability
G1 Garbage Collection Setup
Kerberos Setup and Troubleshooting
Kubernetes Troubleshooting
Log Monitoring for AKS

Was this page helpful?

Glad to hear it! Thank you for your feedback. Sorry to hear that. Thank you for your feedback.