编译语句时出错：失败：ParseException 行 10：0 无法识别 serde 属性规范中"partitionedby("附近的输入

Question

Create table d_rel_t.Acty_dim_Csv(acty_cde           int,
                                  acty_nm            string,
                                  acty_typ           string,
                                  gdgs_ind           string, 
                                  dly_growth_ind     string,
                                  grc_ind            string, 
                                  acty_txn_lob_cde   string,
                                  txn_prd_seg_cde    string
                                 ) 
Row format delimited  fields terminated by ','  
partitioned by(acty_ctgry_cde string);  

编译语句时的错误：失败：ParseException行10：0无法识别"分区"''''''''（在Serde属性中规范

中）附近的输入

我遇到了这个错误，请建议

Answer 1

partitioned by在 row format规格之前进行。

create table d_rel_t.Acty_dim_Csv(acty_cde           int,
                                  acty_nm            string,
                                  acty_typ           string,
                                  gdgs_ind           string, 
                                  dly_growth_ind     string,
                                  grc_ind            string, 
                                  acty_txn_lob_cde   string,
                                  txn_prd_seg_cde    string
                                 ) 
partitioned by(acty_ctgry_cde string)
row format delimited fields terminated by ','  
;