Sidebar

HPL/SQL is included to Apache Hive since version 2.0

truncate

TRUNCATE TABLE Statement

TRUNCATE TABLE statement removes all rows in the specified table.

Syntax:

TRUNCATE [TABLE] table_name 

Example:

Remove all rows in users2015 table:

truncate table users2015;

Compatibility: Oracle, Microsoft SQL Server, IBM DB2, MySQL, Hive

Version: HPL/SQL 0.3.17

See also: