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?

805

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,

685

Explain Usage of Hive?

692

How can client interact with Hive?

699

How do you write your own SerDe?

765

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?

710

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 }

Explain the functionality of object-inspector.

721

While loading data into a hive table using the load data clause, how do you specify it is a hdfs file and not a local file ?

734

What are the components of a Hive query processor?

732

Clarify how hive de-serialize and serialize the information?

644

What are the different parts of Hive ?

764

Why Hive is not suitable for OLTP systems?

736

How will you read and write HDFS files in Hive?

688

How can a developer utilize hive?

679

How do you specify the table creator name when creating a table in hive?

692

What is the difference between local and remote metastore?

1108

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

839

Explain REVERSE function in Hive with example?

767

What are types of hive built-in functions?

742

The partition of hive table has been modified to point to a new directory location. Do I have to move the data to the new location or the data will be moved automatically to the new location?

1000

Is it possible to overwrite Hadoop MapReduce configuration in Hive?

715

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