hdfs文件导入到hive表

 

 1 CREATE TABLE employees (
 2   id INT,
 3   name STRING,
 4   age INT,
 5   salary FLOAT
 6 )
 7 ROW FORMAT DELIMITED
 8 FIELDS TERMINATED BY ','
 9 STORED AS TEXTFILE;
10 
11 -- 将数据上传到HDFS
12 hadoop fs -put employees.csv /input
13 
14 -- 导入数据到Hive表
15 LOAD DATA INPATH '/input/employees.csv' INTO TABLE employees;
16 
17 -- 验证数据导入
18 SELECT * FROM employees;

 

posted @ 2023-09-21 19:13  旺旺大菠萝  阅读(36)  评论(0)    收藏  举报