DDL statement in hive

webhcat server

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.

Categorized in:

Tagged in:

, , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,