1. Excel導出逗號文件.csv
2. 將CSV文件導入到hive服務器制定目錄
3. 轉換編碼格式
轉換編碼格式趁蕊，在指定目錄下執(zhí)行如下命令：piconv -f gb2312 -t UTF-8 CompanyCode.txt ?> ?c.txt
4. 在hive中建表
create table sf_staff_info(
uid string,
department string,
phone string
)
ROW format delimited
fields terminated by ','
STORED AS TEXTFILE;
5. 加載數據到hive表中
load data local inpath '/home/rd/xiang/sf_staff_info.csv' into table sf_staff_info;
