DDL statement in hive
DDL (Data Definition Language):
- The outline of the database schema typically change by SQL statements they are creating, deleting, or modifying schema objects such as databases, tables, and views.
- Most statements starts with the keywords CREATE, DROP, or ALTER.
Some of Data Definition Language statements are:
- CREATE – To create an object.
- ALTER – To alter the structure of the existing object·
- DROP – It used to delete objects.
- TRUNCATE – Remove all records from a table, including spaces.
- MSCK REPAIR TABLE – Refresh metadata information.
The DML statement define as INSERT statement, it involves metadata that must be have nodes, and is also damage the SYNC_DDL query option.
