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?

707

LOWER or LCASE function in Hive with example?

701

What is the functionality of Query Processor in Apached Hive ?

706

Explain Data Type Conversion in Hive?

716

Explain SHOW and DESCRIBE Commands in Hive?

746

What are the views in Hive?

665

What are the different Primitive Data Types available in Hive?

692

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?

773

When to choose "Internal Table" in Hive?

718

What are the different parts of Hive ?

762

What are the types of tables in Hive?

734

Does Hive support record level Insert, delete or update?

683

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

722

Double type in Hive - Important points?

678

TRIM function in Hive with example?

721

Post New Apache Hive Questions

Un-Answered Questions { Apache Hive }

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

694

What is Hive ?

992

How can the columns of a table in hive be written to a file?

711

What is hive metastore?

710

What is available mechanism for connecting from applications, when we run hive as a server?

769

Mention what is HiveServer2 (HS2)?

787

What is the precedence order of hive configuration?

931

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

How do you write your own SerDe?

761

when to choose “internal table” and “external table” in hive?

673

How to optimize Hive Performance?

709

What is the reason for creating a new metastore_db whenever Hive query is run from a different directory?

988

What is indexing and why do we need it?

825

How to add the partition in existing table without the partition table?

699

What is a partition in Hive?

898

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