开发者社区 > 大数据与机器学习 > 大数据计算 MaxCompute > 正文

maxcomputer外部表怎么修改分隔符

这是建表语句

            
   custom1 string COMMENT '保留字段1',                
   custom2 string COMMENT '保留字段2',                
   custom3 string COMMENT '保留字段3')     
    comment ''  partitioned by (
  month_id string
  )
ROW FORMAT SERDE
   'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
 WITH SERDEPROPERTIES (
 'mcfed.field.delim' = ',',
 'mcfed.serialization.null.format'='',
 'odps.text.option.gzip.input.enabled'='true')
stored as textfile
location "odps://xxx/abc_external/";

展开

收起

游客wpiaonxbbco42 2022-12-28 10:32:01 204 0

1 条回答

写回答

取消提交回答

三掌柜666

十分耕耘，一定会有一分收获！

楼主你好，看看这个例子： -- insert overwrite table total_revenues partition(region) -- select total_price as revenue, region from sale_detail;

-- set odps.sql.allow.fullscan=true; -- INSERT OVERWRITE TABLE rise_bigdata.tmp_ads_cbc_quitschool_con_analysis_detail_da PARTITION (pt) -- select actual_recruit_num,new_recruit_num,con_approval_date,con_approvaldate,org_name,centra_name -- ,city_name,con_contract_code,def1,def2,def3,def4,def5,def6,def7,def8,def9,def10,def11, -- def12,def13,def14,def15,dt_refresh,pt -- FROM rise_bigdata.ads_cbc_quitschool_con_analysis_detail_da; -- drop table rise_bigdata.ads_cbc_quitschool_con_analysis_detail_da; -- ALTER table rise_bigdata.tmp_ads_cbc_quitschool_con_analysis_detail_da RENAME TO ads_cbc_quitschool_con_analysis_detail_da;

2022-12-30 08:05:29

赞同展开评论打赏