Setting Hive/Hadoop property using Hive Query

0 votes

I am preparing for the HDPCD exam and I found out that they have a question where you have to set a Hadoop or Hive configuration properties within the Hive query. Can anyone help me out in solving this problem?

Apr 18, 2018 in Big Data Hadoop by Shubham
• 13,210 points
138 views

1 answer to this question.

0 votes

You can set Hadoop & Hive conf variable using the below command, but the changes will only be applicable to the query session.

Set -v prints all the Hadoop & Hive configuration variables.

SET mapreduce.job.reduces=XX

Using reset in the conf will reset the default value.

answered Apr 18, 2018 by Shubham
• 13,210 points

Related Questions In Big Data Hadoop

0 votes
1 answer

Hadoop: How to keep duplicates in Hive using collect_set()?

SELECT hash_id, COLLECT_LIST(num_of_cats) AS ...READ MORE

answered Nov 2, 2018 in Big Data Hadoop by Omkar
• 67,140 points
190 views
0 votes
1 answer

Hadoop Hive Hbase: How to insert data into Hbase using Hive (JSON file)?

You can use the get_json_object function to parse the ...READ MORE

answered Nov 15, 2018 in Big Data Hadoop by Omkar
• 67,140 points
410 views
0 votes
1 answer

Hadoop Hive query to filter employees

select * from tablename where DOJ> '2018-01-01' ...READ MORE

answered Dec 13, 2018 in Big Data Hadoop by Omkar
• 67,140 points
206 views
+1 vote
2 answers

Failed to restart Hadoop namenode using cloudera quickstart

You can use cloudera manager to manage ...READ MORE

answered Mar 19, 2018 in Big Data Hadoop by kurt_cobain
• 9,240 points
566 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,150 points
2,061 views
0 votes
10 answers

hadoop fs -put command?

copy command can be used to copy files ...READ MORE

answered Dec 7, 2018 in Big Data Hadoop by Sujay
10,554 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,240 points
771 views
0 votes
1 answer
0 votes
3 answers

Can we run Spark without using Hadoop?

No, you can run spark without hadoop. ...READ MORE

answered May 7 in Big Data Hadoop by pradeep
121 views
0 votes
1 answer

How do I include all the Hadoop dependencies using Maven?

This is a dependency mismatch error. I ...READ MORE

answered Apr 10, 2018 in Big Data Hadoop by Shubham
• 13,210 points
410 views