MAPREDUCE服务 MRS-SHOW CREATE TABLE:示例

时间：2024-04-10 09:06:18

MAPREDUCE服务 MRS

示例

显示能够创建orders表的SQL 语句：

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)

上一篇：MAPREDUCE服务 MRS-SHOW TABLE/PARTITION EXTENDED:参数说明

下一篇：MAPREDUCE服务 MRS-将MR任务从Windows上提交到Linux上运行:配置描述