create external table emp (empno int,ename varchar(64),job varchar(64),mgr int,hiredate date,sal float,comm float,deptno int ) row format delimited fields terminated by ',' location '/files';
如下:
ALTER TABLE newemp SET SERDEPROPERTIES ('serialization.encoding'='gbk');