Apache Hive : HPL/SQL - 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

See also:

• DROP TABLE