【产品名称】OceanBase 社区版
【产品版本】3.1.0
【问题描述】用load data 导入数据包含 datetime时间 格式时,通过set来转化时间格式,报ERROR 1235 (0A000): load data set not supported。
sql如下:load data /+ parallel(8) loadbatchsize(100)/ infile ‘/root/cc/msrcard_20211020.txt’ Replace into table msr_info fields terminated by ‘\t’ lines terminated by ‘\n’ (MEMBER_ID,CARD_NUMBER,CARD_STATUS,@DATE_CANCELLED,@EXPIRY_DATE,@PURCHASE_DATE,PURCHASE_STORE,ACTIVECARD_CHANNEL,COMMENT,REASON,CARD_TYPE,DISABLE_LOST,VALID_DAYS,CARD_ID) set EXPIRY_DATE=STRTODATE_(@EXPIRY_DATE_,’%m/%d/%Y’),PURCHASE_DATE=STR_TO_DATE(@PURCHASE_DATE,’%m/%d/%Y %H:%i:%s’),DATE_CANCELLED=STR_TO_DATE(@DATE_CANCELLED,’%m/%d/%Y %H:%i:%s’);