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 about the different types of join in Hive?

819

What is the definition of Hive?

732

What is the current version of Hive?

766

Explain about ACID transactions in Hive?

732

Is it possible to change the default location of Managed Tables in Hive, if so how?

719

Is it possible to add 100 more nodes when we already have 100 nodes in Hive?

1261

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

647

What is Buckets in Hive?

745

How will you consume CSV file into the Hive warehouse using built SerDe?

807

What is the difference between Hiveserver1 and Hiveserver2?

802

How to Rename a table in Hive

752

What are the advantages and Disadvantages in archieving partition in Hive?

746

When to choose "External Table" in Hive?

805

How to skip header rows from a table in Hive?

821

Where does the data of a Hive table gets stored?

668

Post New Apache Hive Questions

Un-Answered Questions { Apache Hive }

Why do we need hive?

723

How do we write our own custom serde?

706

Write a query to insert a new column(new_col int) into a hiev table (htab) at a position before an existing column (x_col)

788

Is it possible to create multiple table in hive for same data?

691

Mention Hive default read and write classes?

752

Explain how can you change a column data type in Hive?

697

What is the difference between local and remote metastore?

1108

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

663

When executing Hive queries in different directories, why is metastore_db created in all places from where Hive is launched?

837

is HQL case sensitive?

860

What happened after creating a table in hive ?

731

Explain the functionality of object-inspector.

721

What will happen in case you have not issued the command?

762

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

680

What does the "USE" command in hive do?

793

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