ogg 列映射函数使用方法汇总

MAP source.Table_name, target target.Table_name, exceptionsonly,
INSERTALLRECORDS, KEYCOLS (Column1), colmap (usedefaults, gg_dml_type = @GETENV ("LASTERR", "OPTYPE"), gg_db_error = @GETENV ("LASTERR", "DBERRNUM"));

eg:

source.Table_name, target target.Table_name,, exceptionsonly,
INSERTALLRECORDS, colmap (usedefaults, gg_dml_type = @GETENV ("LASTERR", "OPTYPE"), gg_db_error = @GETENV ("LASTERR", "DBERRNUM")GG_DML_FIXFLAG = @COLSTAT (MISSING));

or

source.Table_name, target target.Table_name,, exceptionsonly,
INSERTALLRECORDS, colmap (usedefaults, gg_dml_type = @GETENV ("LASTERR", "OPTYPE"), gg_db_error = @GETENV ("LASTERR", "DBERRNUM") GG_DML_FIXFLAG = 'Y');

MAP cmm_user_center.cst_np_social_rl,target FLUSRTEST.cst_np_social_rl, COLMAP (usedefaults,birthday = @IF(birthday ='',@COLSTAT (NULL),@DATE ('YYYY-MM-DD','YYYY-MM-DD',birthday)));

 

map fguarantee.fgi_tran_info,target fgi_report.fgi_tran_info_his,FILTER(@COMPUTE(@DATEDIFF('DD',crt_tm,'2023-05-17'))>0),colmap (USEDEFAULTS,sub_tm=@IF(@COLTEST(sub_tm,NULL,INVALID),'2000-01-01',sub_tm),crt_tm=@IF(@COLTEST(crt_tm,NULL,INVALID),@DATENOW(),crt_tm),mdf_tm=@IF(@COLTEST(mdf_tm,NULL,INVALID),@DATENOW(),mdf_tm));

上边这个主要是处理按照时间字段分表，还有把NULL字符进行特殊处理