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

Apache Hive Interview Questions

Questions Answers Views Company eMail

What is Clustring in Hive?

741

Mention Hive default read and write classes?

752

what are views in Hive?

760

In Hive, how can you enable buckets?

738

Is it possible to change the default location of a managed table?

731

What is the difference between the external table and managed table?

716

What is Bucketing and Clustering in Hive?

688

How to create table in hive for a json input file?

823

what is the difference between order by and sort by in Hive?

703

How Hive distributes the rows into buckets?

802

Why is Hive not suitable for OLTP systems?

762

Why do we perform partitioning in Hive?

748

Wherever (Different Directory) I run the hive query, it creates new metastore_db, please explain the reason for it?

747

What is the difference between local and remote metastore?

1108

What are different modes of metastore deployment in Hive?

700

Post New Apache Hive Questions

Un-Answered Questions { Apache Hive }

UPPER or UCASE function in Hive with example?

799

Hive new version supported Hadoop Versions ?

604

What are the different components of a Hive query processor?

1423

What is SerDe in Apache Hive ?

928

Which java class handles the output record encoding into files which result from Hive queries?

665

What is bucketing ?

683

Explain about the different types of join in Hive?

819

What is the maximum size of string data type supported by Hive?

782

What database are supported by Hive?

706

What is BloomMapFile used for?

670

Are there any problems which can only be solved by MapReduce and cannot be solved by PIG? In which kind of scenarios MR jobs will be more useful than PIG?

775

Can you explain smb join in hive?

721

What kind of data warehouse application is suitable for Hive? What are the types of tables in Hive?

724

What is the difference between sort by and order by in hive?

680

What are the different Data Types available in Hive?

699

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