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 ALTER Table statement in Hive?

665

LOWER or LCASE function in Hive with example?

663

What is the functionality of Query Processor in Apached Hive ?

657

Explain Data Type Conversion in Hive?

673

Explain SHOW and DESCRIBE Commands in Hive?

712

What are the views in Hive?

628

What are the different Primitive Data Types available in Hive?

657

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?

737

When to choose "Internal Table" in Hive?

671

What are the different parts of Hive ?

706

What are the types of tables in Hive?

689

Does Hive support record level Insert, delete or update?

646

Explain what is a Hive variable. What do we use it for?

681

Double type in Hive - Important points?

648

TRIM function in Hive with example?

679

Post New Apache Hive Questions

Un-Answered Questions { Apache Hive }

What is the stable version of Hive ?

2594

Where does the data of a Hive table gets stored?

636

What is different table structure available in the hive?

629

Mention what is ObjectInspector functionality in Hive?

710

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)

760

What is dynamic partitioning and when is it used?

980

What do you mean by schema on read?

673

Explain about the different types of join in Hive?

764

What is a generic udf in hive?

697

Differentiate between PigLatin and Hive?

655

Can hive queries be executed from script files? How?

627

As part of optimizing the queries in hive, what should be the order of table size in a join query?

673

In which scenario Hive is good fit?

934

How Hive organize the data?

673

Mention Hive default read and write classes?

705

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