drop
The drop
statement is used to drop a database or table.
Drop DFS databases
Syntax
drop database [if exists] dbPath
Arguments
dbPath is a string indicating the path of a DFS database
Examples
drop database if exists "dfs://test"
Related functions: dropDatabase, existsDatabase
Drop DFS/dimension tables
Syntax
drop table [if exists] dbPath.tableName
Arguments
dbPath is a string indicating the path of a DFS database.
tableName is a string indicating name of a DFS table or dimension table.
Examples
drop table if exists "dfs://test"."pt"
Related functions: dropTable, existsTable
Drop in-memory tables
Syntax
drop table [if exists] tableName
Arguments
tableName is a string indicating the name of an in-memory table.