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                              
-----------------------------------------------------------------------------
        STATS_GENERATED_VIA_STATS_TASK  'workaround for potential lack of HIVE-12730' 
        auto.purge              'false'                                                 
        numFiles                '0'                                                     
        numRows                 '0'                                                     
        orc.compress.size       '262144'                                                
        orc.compression.codec   'GZIP'                                                 
        orc.row.index.stride    '10000'                                                 
        orc.stripe.size         '67108864'                                              
        presto_query_id         '20230909_095107_00042_2hwbg@default@HetuEngine'        
        presto_version          '399'                                                   
        rawDataSize             '0'                                                     
        totalSize               '0'                                                     
        transient_lastDdlTime   '1694253067'                                           

(1 row)
 
-- View the compression algorithm of show_table1.
SHOW TBLPROPERTIES show_table1('orc.compression.codec');
SHOW TBLPROPERTIES  
---------------------
 GZIP                
(1 row)