1.建表 CREATE TABLE app.csv_question_survey_farmers( ) 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
2023-10-21 19:07:34
1.建表 CREATE TABLE app.csv_question_survey_farmers( ) 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