Hive to HDFS transfer

+5 votes
How can you transfer data from Hive to HDFS?
Jun 5, 2018 in Big Data Hadoop by shams
• 3,580 points
776 views

2 answers to this question.

+2 votes

Suppose you want to transfer the data from a hive table "sales" to you HDFS directory "/temp" then you can use the following command

hive> insert overwrite directory '/temp' select * from sales;
answered Jun 5, 2018 by Data_Nerd
• 2,360 points
+3 votes
Hive does not store data. Hive is Sql like interface on top of HDFS and used for data processing. Hive creates MR Jobs from SQL.

Data resides in HDFS and Hive created MR jobs reads the data and stored it back in HDFS
answered Sep 20, 2018 by SM
Yup agreed. Hive does not store data. Maybe what @Data_Nerd wanted to say is, for dumping the data back into HDFS, after processing, that command is used.

Related Questions In Big Data Hadoop

0 votes
1 answer

How can you transfer data from hive to HDFS ?

Hey, Data in Hive tables reside on HDFS, ...READ MORE

answered May 16 in Big Data Hadoop by Gitika
• 25,340 points
109 views
0 votes
1 answer

How can we transfer a PDF file to HDFS?

You can easily upload any file to ...READ MORE

answered Apr 13, 2018 in Big Data Hadoop by nitinrawat895
• 10,710 points
85 views
0 votes
1 answer

How to transfer data from Netezza to HDFS using Apache Sqoop?

Remove the --direct option. It gives issue ...READ MORE

answered Apr 23, 2018 in Big Data Hadoop by kurt_cobain
• 9,260 points
331 views
0 votes
1 answer

Not able to create Hive table from HDFS file

You dont have to specify the file name ...READ MORE

answered Dec 5, 2018 in Big Data Hadoop by Omkar
• 67,660 points
353 views
0 votes
1 answer

How to create a Hive table from sequence file stored in HDFS?

There are two SerDe for SequenceFile as ...READ MORE

answered Dec 17, 2018 in Big Data Hadoop by Omkar
• 67,660 points
589 views
0 votes
1 answer

Hadoop Mapreduce word count Program

Firstly you need to understand the concept ...READ MORE

answered Mar 16, 2018 in Data Analytics by nitinrawat895
• 10,710 points
3,313 views
0 votes
10 answers

hadoop fs -put command?

put syntax: put <localSrc> <dest> copy syntax: copyFr ...READ MORE

answered Dec 7, 2018 in Big Data Hadoop by Aditya
16,323 views
0 votes
1 answer

Hadoop dfs -ls command?

In your case there is no difference ...READ MORE

answered Mar 16, 2018 in Big Data Hadoop by kurt_cobain
• 9,260 points
1,191 views
0 votes
1 answer
0 votes
11 answers

What is the default Namenode port of HDFS. Is it 8020 or 9000 or 50070?

8020/9000 hadoop namenode metadata port number. or ...READ MORE

answered Dec 31, 2018 in Big Data Hadoop by SM
12,978 views