使用sqoop从CSV文件加载到Hive表? [英] Load from CSV File to Hive Table with Sqoop?

问题描述

是否可以借助Sqoop从CSV文件加载配置单元表?

Is it possible to load a hive table from CSV file with help of Sqoop?

推荐答案

Sqoop 并不是为了这个目的，我认为它不能解决您的要求. Sqoop用于在Hadoop和RDBMS之间导入或导出数据.

Sqoop is not meant for that and I don't think it can solve your requirement. Sqoop is to import or export data between Hadoop and RDBMS.

对于您的情况，您不需要sqoop，无需从HDFS或本地到配置单元表中加载CSV文件.下面是它的语法.

For your case, you don't need sqoop, load the CSV file from HDFS or local to hive table. Below is the syntax for it.

LOAD DATA INPATH 'hdfs_file_or_directory_path' [OVERWRITE] INTO TABLE tablename
  [PARTITION (partcol1=val1, partcol2=val2 ...)]

这篇关于使用sqoop从CSV文件加载到Hive表?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！