drop
The drop statement is used to drop a database or table.
Drop DFS databases
Syntax
drop database [if exists] dbPathArguments
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.tableNameArguments
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] tableNameArguments
tableName is a string indicating the name of an in-memory table.