SHOW CREATE TABLE

Syntax

SHOW CREATE TABLE table_name

Description

This statement is used to display the SQL creating statement for a specified data table.

Example

To display the SQL statements that can be used to create the table orders:

CREATE TABLE orders ( 
 orderkey bigint, 
 orderstatus varchar, 
 totalprice double, 
 orderdate date 
 ) 
 WITH (format = 'ORC', location='/user',orc_compress='ZLIB',external=true, "auto.purge"=false);

show create table orders;
     
                  Create Table                   
-------------------------------------------------
 CREATE TABLE hive.default.orders (              
    orderkey bigint,                             
    orderstatus varchar,                         
    totalprice double,                           
    orderdate date                               
 )                                               
 WITH (                                          
    external_location = 'hdfs://hacluster/user', 
    format = 'ORC',                              
    orc_compress = 'ZLIB',                       
    orc_compress_size = 262144,                  
    orc_row_index_stride = 10000,                
    orc_stripe_size = 67108864                   
 )                                               
(1 row)