SQL Commands

• SELECT — structure of SQL queries in Dremio.

• Data Definition Language (DDL) commands are used to create, manipulate, and modify objects in Dremio:

  • ALTER BRANCH
  • ALTER PIPE
  • ALTER SOURCE
  • ALTER TABLE
  • ALTER TAG
  • ALTER VIEW
  • ANALYZE TABLE
  • COPY INTO
  • CREATE BRANCH
  • CREATE FOLDER
  • CREATE FUNCTION
  • CREATE PIPE
  • CREATE ROLE
  • CREATE TABLE
  • CREATE TABLE AS
  • CREATE TAG
  • CREATE USER
  • CREATE VIEW
  • DESCRIBE FUNCTION
  • DESCRIBE PIPE
  • DESCRIBE TABLE
  • DROP BRANCH
  • DROP FOLDER
  • DROP FUNCTION
  • DROP PIPE
  • DROP ROLE
  • DROP TABLE
  • DROP TAG
  • DROP USER
  • DROP VIEW
  • GRANT ROLE
  • GRANT TO ROLE
  • GRANT TO USER
  • MERGE BRANCH
  • REVOKE FROM ROLE
  • REVOKE FROM USER
  • REVOKE ROLE
  • SHOW BRANCHES
  • SHOW CREATE TABLE
  • SHOW CREATE VIEW
  • SHOW FUNCTIONS
  • SHOW LOGS
  • SHOW TABLES
  • SHOW TAGS
  • SHOW VIEWS
  • USE
  • VACUUM CATALOG
  • VACUUM TABLE
  • WITH

• Data Manipulation Language (DML) commands are used to manipulate data and, in Dremio, are currently applicable only to Apache Iceberg tables:

  • DELETE
  • INSERT
  • MERGE
  • OPTIMIZE TABLE
  • ROLLBACK TABLE
  • TRUNCATE
  • UPDATE