0 votes
in Big Data | Hadoop by
Truncate and Alter

Follow the steps given below to truncate and alter.

Truncate:

TRUNCATE TABLE table;
  1. ALTER table:
alter table <tablename>  add columns(car int);
  1. Alter database:
ALTER DATABASE test_db RENAME TO test_db_new;
...