MAPREDUCE服务 MRS-SHOW TBLPROPERTIES TABLE|VIEW:示例

时间:2024-11-28 20:08:12

示例

如下为示例:

  • 查看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)
  • 查看show_table1的压缩算法
    SHOW TBLPROPERTIES show_table1('orc.compression.codec');
    SHOW TBLPROPERTIES  
    ---------------------
     GZIP                
    (1 row)
support.huaweicloud.com/cmpntguide-lts-mrs/mrs_01_300155.html