How to load csv file converted from excel file into Cloudera Hive or Impala? - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>DataSciences - 数据科学

How to load csv file converted from excel file into Cloudera Hive or Impala?

How to load csv file converted from excel file into Cloudera Hive or Impala?# DataSciences - 数据科学

s*h2015-08-13 07:08

1 楼

I found this jar file:
https://github.com/ogrodnek/csv-serde
However, got error saying the jar file doesn't exist when I run
add jar /user/jarTemp/csv-serde-1.1.2-0.11.0-all.jar;
Any idea?
For Cloudera, the jar file(s) has to be in specific path?
Thanks.

s*h2015-08-13 07:08

2 楼

I prefer the jar file approach, as we might have too many files in future to
load manually in HUE GUI.
Try to follow the link below:
http://gethue.com/hadoop-tutorial-create-hive-tables-with-heade
However, I can't see the action part (create table from file, and create
table manually) in metastore manager.
Any idea?
Our IT dept creates the environment and gives me an account.
I believe they just use the OTB cloudera CDH image.
Is that a privilege issue?
Thanks.

【在 s****h 的大作中提到】

: I found this jar file:
: https://github.com/ogrodnek/csv-serde
: However, got error saying the jar file doesn't exist when I run
: add jar /user/jarTemp/csv-serde-1.1.2-0.11.0-all.jar;
: Any idea?
: For Cloudera, the jar file(s) has to be in specific path?
: Thanks.

s*h2015-08-13 07:08

3 楼

ok, solved
IT team gave the machine access, and we just loaded the jar file to the
machine directly, not through HUE.