将excel转为csv格式,并将列名删除,只保留数据
2、在HDFS上创建文件夹,并上传本地数据
CREATE EXTERNAL TABLE `abc.info`( `a` string COMMENT 'ID', `b` string COMMENT '名称', `c` string COMMENT '需求' ) row format delimited fields terminated by ',' stored as textfile LOCATION 'hdfs://HDFS/user/test_info'



