hive 导入csv文件

1.建表
CREATE TABLE app.xxx(

)
ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
STORED AS TEXTFILE;

2.找到数据文件路径
hadoop ls 

3.导入数据
hadoop fs -put xxx.csv            /inceptor1/user/hive/warehouse/app.db/hive/xxx