can we store hive output in hadoop hdfs

0 votes
Feb 22 in Big Data Hadoop by Radhika
• 120 points
501 views

1 answer to this question.

0 votes

Hi,

You can save your hive output to Hdfs. First start your hadoop cluster and then use the below command.

INSERT OVERWRITE DIRECTORY "set your HDFS Path " ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t'
SELECT * FROM table LIMIT 10;

Thank You

answered Feb 24 by MD
• 78,020 points

Related Questions In Big Data Hadoop

0 votes
1 answer

Can we use HDFS to store git repositories?

Yes, it is possible to use HDFS ...READ MORE

answered May 7, 2018 in Big Data Hadoop by nitinrawat895
• 10,950 points
471 views
0 votes
1 answer

How can we list files in HDFS directory as per timestamp?

No, there is no other option to ...READ MORE

answered May 8, 2018 in Big Data Hadoop by nitinrawat895
• 10,950 points
4,204 views
0 votes
1 answer

In Hadoop MapReduce, how can i set an Object as the Value for Map output?

Try this and see if it works: public ...READ MORE

answered Nov 20, 2018 in Big Data Hadoop by Omkar
• 69,030 points
154 views
0 votes
1 answer

Hadoop: How to get the column name along with the output in Hive?

You can get the column names by ...READ MORE

answered Nov 20, 2018 in Big Data Hadoop by Omkar
• 69,030 points
2,056 views
0 votes
1 answer

How to concatenate hdfs files and store in output file?

You can use a combination of cat and put command. Something ...READ MORE

answered Dec 5, 2018 in Big Data Hadoop by Omkar
• 69,030 points
1,696 views
–1 vote
1 answer

How we can run spark SQL over hive tables in our cluster?

Open spark-shell. scala> import org.apache.spark.sql.hive._ scala> val hc = ...READ MORE

answered Dec 26, 2018 in Big Data Hadoop by Omkar
• 69,030 points
282 views
0 votes
1 answer

How can we access data with simple SQL knowledge in hive?

Hey, The following examples are simple, common data ...READ MORE

answered May 16, 2019 in Big Data Hadoop by Gitika
• 48,800 points
108 views
0 votes
1 answer

How to create a Hive Database and store it in HDFS?

You will have to exclusively mention the ...READ MORE

answered May 20, 2019 in Big Data Hadoop by Jishnu
367 views
0 votes
1 answer

can we add hadoop in docker or online server or cloud

Hi@Rajan, If you are asking, can we configure hadoop ...READ MORE

answered May 1 in Big Data Hadoop by MD
• 78,020 points
122 views
0 votes
1 answer

Where does Hive store files in HDFS?

Hi@akhtar, It depends on what you set in ...READ MORE

answered Oct 5 in Big Data Hadoop by MD
• 78,020 points
34 views