创建普通表

create table if not exists dealerinfo
(
  dealerid int,
  dealername string,
  cityid int,
  createtime date
)
row format delimited fields terminated by '\t'
stored as textfile;

row format delimited fields terminated by '\t'是指定列之间的分隔符；

stored as textfile是指定文件存储格式为textfile