Hadoop / Hive：从本地计算机上的.csv加载数据 [英] Hadoop/Hive : Loading data from .csv on a local machine

问题描述

因为这是来自新手...

As this is coming from a newbie...

我为Hadoop和Hive设置了，所以我可以在我的电脑上运行Hive查询访问数据AWS集群。
我可以使用存储在我的计算机上的.csv数据运行Hive查询，就像我使用MS SQL Server一样？

I had Hadoop and Hive set up for me, so I can run Hive queries on my computer accessing data on AWS cluster. Can I run Hive queries with .csv data stored on my computer, like I did with MS SQL Server?

如何将.csv数据加载到Hive中？它与Hadoop和哪个模式应该运行那个模式有什么关系？

How do I load .csv data into Hive then? What does it have to do with Hadoop and which mode I should run that one?

我应该关心什么设置，所以如果我做错了我可以总是回去

What settings I should care about so that if I did something wrong I can always go back and run queries on Amazon without compromising what was set up for me earlier?

推荐答案

如果你有一个蜂巢设置，你可以把本地数据集直接在hdfs / s3中使用Hive load命令。

if you have a hive setup you can put the local dataset directly using Hive load command in hdfs/s3.

在编写加载命令时，您需要使用Local关键字。

You will need to use "Local" keyword when writing your load command.

hiveload命令的语法

Syntax for hiveload command

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

有关详细信息，请参阅以下链接。
https://cwiki.apache.org/confluence/display/Hive/ LanguageManual％20DML＃LanguageManualDML-Loadingfilesintotables

Refer below link for more detailed information. https://cwiki.apache.org/confluence/display/Hive/LanguageManual%20DML#LanguageManualDML-Loadingfilesintotables

这篇关于Hadoop / Hive：从本地计算机上的.csv加载数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！