SHOW TBLPROPERTIES TABLE|VIEW

Syntax

SHOW TBLPROPERTIES table_name|view_name[(property_name)]

Description

If you do not specify an attribute keyword, this statement returns all table attributes. Otherwise, this statement returns the attribute that matches the specified keyword.

Example

-- View all table attributes of show_table1.
SHOW TBLPROPERTIES show_table1;
SHOW TBLPROPERTIES                             
---------------------------------------------------------------------------
        STATS_GENERATED_VIA_STATS_TASK  workaround for potential lack of HIVE-12730 
        numFiles                0                                                     
        numRows                 0                                                     
        orc.compress.size       262144                                                
        orc.compression.codec   GZIP                                                 
        orc.row.index.stride    10000                                                 
        orc.stripe.size         67108864                                              
        presto_query_id         20210322_094034_00306_s4s9e@default@HetuEngine        
        presto_version                                                                
        rawDataSize             0                                                     
        totalSize               0                                                     
        transient_lastDdlTime   1616406034                                           
                                                                           
(1 row)
 
-- View the compression algorithm of show_table1.
SHOW TBLPROPERTIES show_table1('orc.compression.codec');
SHOW TBLPROPERTIES  
---------------------
 GZIP                
(1 row)