How to get generate the create statement for an existing hive table

Question

Assuming you have  table  already in Hive  is there a quick way like other databases to be able to get the  CREATE  statement for that table

User · Answer

Describe Formatted Extended will show the data definition of the table in hive  hive gt  describe Formatted dbname tablename

User · Answer

Steps to generate Create table DDLs for all the tables in the Hive database and export into text file to run later  step 1  create a  sh file with the below content  say hive table ddl sh    bin bash rm -f tableNames txt rm -f HiveTableDDL txt hive -e  quot use  1  show tables  quot   gt  tableNames txt   wait cat tableNames txt  while read LINE    do    hive -e  quot use  1 show create table  LINE  quot   gt  gt HiveTableDDL txt    echo  -e  quot  n quot   gt  gt  HiveTableDDL txt    done rm -f tableNames txt echo  quot Table DDL generated quot   step 2  Run the above shell script by passing  db name  as paramanter  gt bash hive table dd sh  lt  lt databasename gt  gt   output   All the create table statements of your DB will be written into the HiveTableDDL txt

User · Answer

As of Hive 0 10 this patch-967 implements SHOW CREATE TABLE which  shows the CREATE TABLE statement that creates a given table  or the CREATE VIEW statement that creates a given view    Usage   SHOW CREATE TABLE myTable

[sql] How to get/generate the create statement for an existing hive table?

Examples related to sql

Examples related to hive

Examples related to hiveql