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?

773

Mention Hive default read and write classes?

791

what are views in Hive?

796

In Hive, how can you enable buckets?

778

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

771

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

748

What is Bucketing and Clustering in Hive?

719

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

859

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

741

How Hive distributes the rows into buckets?

845

Why is Hive not suitable for OLTP systems?

808

Why do we perform partitioning in Hive?

786

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

776

What is the difference between local and remote metastore?

1139

What are different modes of metastore deployment in Hive?

730

Post New Apache Hive Questions

Un-Answered Questions { Apache Hive }

How can you stop a partition form being queried?

800

Explain when to use explode in Hive?

725

Which companies are mostly using Hive ?

821

What is the default database provided by Apache Hive for metastore?

674

Can we load data into a view?

736

What is Hive Database?

737

Can a table be renamed in Hive?

764

What is a generic udf in hive?

769

Describe REVERSE function in Hive with example?

752

When you are dealing with static data instead of dynamic data?

769

Explain Usage of Hive?

737

What is the difference between Hbase and Hive?

755

How can a developer utilize hive?

723

If you run a select * query in hive, why does it not run mapreduce?

785

What is CONCATENATE command in Hive?

961

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