MAPREDUCE服务 MRS-SHOW CREATE TABLE:示例

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

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-使用HetuEngine跨源跨域访问数据源:跨域关键技术和优势

下一篇：MAPREDUCE服务 MRS-SELECT:语法