Apache Hive Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Apache Hive Interview Questions

Questions Answers Views Company eMail

Explain REPEAT function in Hive with example?

804

What does the "USE" command in hive do?

793

Can you give us some examples, how Hadoop is used in real time environment?

703

Write a Hive UDF that returns a sentiment score. For example, if good = 1, bad = -1, and average = 0, then a review of a restaurant states "Good food, bad service," your score might be 1 - 1 = 0.

LinkedIn,

684

Explain Usage of Hive?

692

How can client interact with Hive?

699

How do you write your own SerDe?

764

What is the significance of ‘IF EXISTS” clause while dropping a table?

715

Can we run unix shell commands from the hive? Give example?

746

How Hive organize the data?

709

Mention what are views in Hive?

694

What are the default record and field delimiter used for hive text files?

813

How can you delete the DBPROPERTY in Hive?

638

How do you check if a particular partition exists?

690

Can a partition be archived? What are the advantages and Disadvantages?

756

Post New Apache Hive Questions

Un-Answered Questions { Apache Hive }

What is the difference between external table and managed table?

967

How can you delete the DBPROPERTY in Hive?

638

Mention key components of Hive Architecture?

850

What is hive metastore?

710

What is the work of hive/hcatalog?

749

How can you prevent a large job from running for a long time? What do u think is more popular among the developers - Pig or Hive?

662

What are the different types of tables available in Hive?

697

What types of costs are associated with creating the index on hive tables?

1016

What is the difference between Hbase and Hive?

707

Why is Hive not suitable for OLTP systems?

762

Explain about the smb join in hive?

724

Say when to pick “inward table” and “outside table” in hive?

704

What is Clustring in Hive?

741

What is difference between hive and hdfs?

629

Explain bucketing in Hive?

846

For More Un-Answered { Apache Hive } Questions Click Here