Deze pagina is nog niet beschikbaar in uw eigen taal. We werken er hard aan om meer taalversies toe te voegen. Bedankt voor uw steun.

MapReduce Service
MapReduce Service

    All results for "" in this service

    Compute
    Elastic Cloud Server
    Bare Metal Server
    Auto Scaling
    Image Management Service
    FunctionGraph
    Management & Governance
    Identity and Access Management
    Cloud Eye
    Resource Formation Service
    Simple Message Notification
    Cloud Trace Service
    Application Operations Management
    Tag Management Service
    Log Tank Service
    Config
    Cloud Ecosystem
    KooGallery
    Partner Center
    User Support
    My Account
    Billing Center
    Cost Center
    My Credentials
    Enterprise Management
    Support Plans
    Partner Support Plans
    Professional Services
    Service Tickets
    Customer Operation Capabilities
    Resource Center
    Security & Compliance
    Web Application Firewall
    Data Encryption Workshop
    Database Security Service
    Data Security Center
    Anti-DDoS
    Host Security Service
    Cloud Firewall
    Cloud Bastion Host
    Cloud Certificate Manager
    SecMaster
    Storage
    Object Storage Service
    Elastic Volume Service
    Cloud Backup and Recovery
    Scalable File Service Turbo
    Scalable File Service
    Databases
    Relational Database Service
    Document Database Service
    Data Replication Service
    Distributed Database Middleware
    GeminiDB
    Data Admin Service
    TaurusDB
    Analytics
    MapReduce Service
    Data Lake Insight
    Cloud Search Service
    GaussDB(DWS)
    DataArts Studio
    Others
    System Permissions
    Common FAQs
    Instructions for Associating with a HUAWEI CLOUD Partner
    Message Center
    Developer Services
    CodeArts
    CodeArts Req
    CodeArts Pipeline
    CodeArts Check
    CodeArts Build
    CodeArts Deploy
    CodeArts TestPlan
    CodeArts Artifact
    CodeArts Repo
    Networking
    Virtual Private Cloud
    Elastic IP
    Elastic Load Balance
    NAT Gateway
    Direct Connect
    Virtual Private Network
    VPC Endpoint
    Global Accelerator
    Enterprise Router
    Cloud Connect
    Migration
    Cloud Data Migration
    Server Migration Service
    Object Storage Migration Service
    AI
    ModelArts
    Graph Engine Service
    Business Applications
    Domain Name Service
    Workspace
    Media Services
    Live
    Containers
    Cloud Container Engine
    SoftWare Repository for Container
    Application Service Mesh
    Middleware
    Distributed Cache Service
    API Gateway
    Distributed Message Service for Kafka
    Distributed Message Service for RocketMQ
    Distributed Message Service for RabbitMQ
    EventGrid
    Developer Tools
    API Request Signing Guide
    Koo Command Line Interface
    Terraform
    Content Delivery & Edge Computing
    Content Delivery Network
    Compute
    Elastic Cloud Server
    Bare Metal Server
    Auto Scaling
    Image Management Service
    FunctionGraph
    Networking
    Virtual Private Cloud
    Elastic IP
    Elastic Load Balance
    NAT Gateway
    Direct Connect
    Virtual Private Network
    VPC Endpoint
    Global Accelerator
    Enterprise Router
    Cloud Connect
    Management & Governance
    Identity and Access Management
    Cloud Eye
    Resource Formation Service
    Simple Message Notification
    Cloud Trace Service
    Application Operations Management
    Tag Management Service
    Log Tank Service
    Config
    Migration
    Cloud Data Migration
    Server Migration Service
    Object Storage Migration Service
    Cloud Ecosystem
    KooGallery
    Partner Center
    AI
    ModelArts
    Graph Engine Service
    User Support
    My Account
    Billing Center
    Cost Center
    My Credentials
    Enterprise Management
    Support Plans
    Partner Support Plans
    Professional Services
    Service Tickets
    Customer Operation Capabilities
    Resource Center
    Business Applications
    Domain Name Service
    Workspace
    Security & Compliance
    Web Application Firewall
    Data Encryption Workshop
    Database Security Service
    Data Security Center
    Anti-DDoS
    Host Security Service
    Cloud Firewall
    Cloud Bastion Host
    Cloud Certificate Manager
    SecMaster
    Media Services
    Live
    Storage
    Object Storage Service
    Elastic Volume Service
    Cloud Backup and Recovery
    Scalable File Service Turbo
    Scalable File Service
    Containers
    Cloud Container Engine
    SoftWare Repository for Container
    Application Service Mesh
    Databases
    Relational Database Service
    Document Database Service
    Data Replication Service
    Distributed Database Middleware
    GeminiDB
    Data Admin Service
    TaurusDB
    Middleware
    Distributed Cache Service
    API Gateway
    Distributed Message Service for Kafka
    Distributed Message Service for RocketMQ
    Distributed Message Service for RabbitMQ
    EventGrid
    Analytics
    MapReduce Service
    Data Lake Insight
    Cloud Search Service
    GaussDB(DWS)
    DataArts Studio
    Developer Tools
    API Request Signing Guide
    Koo Command Line Interface
    Terraform
    Others
    System Permissions
    Common FAQs
    Instructions for Associating with a HUAWEI CLOUD Partner
    Message Center
    Content Delivery & Edge Computing
    Content Delivery Network
    Developer Services
    CodeArts
    CodeArts Req
    CodeArts Pipeline
    CodeArts Check
    CodeArts Build
    CodeArts Deploy
    CodeArts TestPlan
    CodeArts Artifact
    CodeArts Repo

      All results for "" in this service

      On this page

      Show all

      Help Center/ MapReduce Service/ Component Operation Guide (LTS)/ Using HetuEngine/ HetuEngine SQL Syntax/ SQL Syntax/ DDL Syntax/ SHOW TBLPROPERTIES TABLE|VIEW

      SHOW TBLPROPERTIES TABLE|VIEW

      Updated on 2022-11-18 GMT+08:00
      View PDF

      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)
      Parent topic: DDL Syntax
      Feedback

      Feedback

      Feedback

      0/500

      Selected Content

      Submit selected content with the feedback