The Hadoop in Real World team shows how you can generate the DDL to create an existing Hive table:
If you have worked with tools like Toad, DB Visualizer or SQL Server Management Studio you know it is quite easy to select an existing table and create a DDL script for the table to get the create script. How do we do the same or get the DDL or create script of an existing Hive table?
The syntax is quite similar to MySQL.