预设分隔符:
create table school822.score(
s_id string,
c_id string,
score string
)row format delimited
fields terminated by '\t';
row format delimited field terminated by '\t'为分隔符设定语句 其余是建表语句
修改分隔符:
ALTER TABLE school822.score SET SERDEPROPERTIES
('field.delim' = '\t');