load data
infile '/home/abc.txt'
append
into table temp
FIELDS TERMINATED BY ":"
TRAILING NULLCOLS
(NAME "TRIM(:NAME)",
ACC_NBR "TRIM(:ACC_NBR)",
TAG "DECODE(TRIM(:TAG),'1','1','2')",
MONTH_ID "TRIM(:MONTH_ID)",
CALLS CONSTANT 0,
COUNTS CONSTANT 0)
每个字段后的双引号内的语句语法是什么样的?还能些什么关键字?
infile '/home/abc.txt'
append
into table temp
FIELDS TERMINATED BY ":"
TRAILING NULLCOLS
(NAME "TRIM(:NAME)",
ACC_NBR "TRIM(:ACC_NBR)",
TAG "DECODE(TRIM(:TAG),'1','1','2')",
MONTH_ID "TRIM(:MONTH_ID)",
CALLS CONSTANT 0,
COUNTS CONSTANT 0)
每个字段后的双引号内的语句语法是什么样的?还能些什么关键字?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货