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?

753

what are views in Hive?

760

In Hive, how can you enable buckets?

739

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?

824

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?

749

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 }

Differentiate between hive and hbase?

761

In case of embedded Hive, can the same metastore be used by multiple users?

797

When to choose "External Table" in Hive?

805

What is Clustring in Hive?

741

How do you write your own SerDe?

765

Give examples of the SerDe classes whihc hive uses to Serializa and Deserilize data?

735

What is the default location where hive stores table data?

690

Say what the object inspector functionality is in hive?

752

What will happen in case you have not issued the command: ‘set hive.enforce.bucketing=true;’ before bucketing a table in hive in apache hive 0.x or 1.x?

773

What is SerDe in Apache Hive ?

928

How is HCatalog different from Hive?

683

How will you convert the string ’51.2’ to a float value in the price column?

887

In Hive, can you overwrite Hadoop MapReduce configuration in Hive?

771

What ate the key components of Hive Architecture?

854

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

824

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