在建表时指定0x0f需要将0x0f从十六进制转换成八进制
create external table IF NOT EXISTS tmp.ODS_HSTA4_TAGENCYINFO_02
(
c_agencyno VARCHAR(9),
c_agencyname VARCHAR(100),
c_agencyaddress VARCHAR(72),
c_agencyzipcode VARCHAR(6),
c_agencycontact VARCHAR(8),
c_agencyphone VARCHAR(36),
c_agencyfaxno VARCHAR(36),
c_agencymail VARCHAR(36)
)
row format delimited fields terminated by ‘\017’
stored as textfile
tblproperties(“skip.header.line.count”=“1”)