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 SOURCE
  • ALTER TABLE
  • ALTER VIEW
  • ANALYZE TABLE
  • COPY INTO
  • CREATE FOLDER
  • CREATE FUNCTION
  • CREATE ROLE
  • CREATE TABLE
  • CREATE TABLE AS
  • CREATE USER
  • CREATE VIEW
  • DESCRIBE FUNCTION
  • DESCRIBE TABLE
  • DROP FOLDER
  • DROP FUNCTION
  • DROP ROLE
  • DROP TABLE
  • DROP USER
  • DROP VIEW
  • GRANT ROLE
  • GRANT TO ROLE
  • GRANT TO USER
  • RESET ENGINE
  • REVOKE FROM ROLE
  • REVOKE FROM USER
  • REVOKE ROLE
  • SET ENGINE
  • SET TAG
  • SHOW CREATE TABLE
  • SHOW CREATE VIEW
  • SHOW FUNCTIONS
  • SHOW TABLES
  • SHOW VIEWS
  • RESET ENGINE
  • RESET TAG
  • 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