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?

762

LOWER or LCASE function in Hive with example?

740

What is the functionality of Query Processor in Apached Hive ?

745

Explain Data Type Conversion in Hive?

756

Explain SHOW and DESCRIBE Commands in Hive?

787

What are the views in Hive?

693

What are the different Primitive Data Types available in Hive?

725

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?

817

When to choose "Internal Table" in Hive?

751

What are the different parts of Hive ?

814

What are the types of tables in Hive?

777

Does Hive support record level Insert, delete or update?

725

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

747

Double type in Hive - Important points?

712

TRIM function in Hive with example?

763

Post New Apache Hive Questions

Un-Answered Questions { Apache Hive }

What is the difference between local and remote metastore?

1139

is HQL case sensitive?

892

If you omit the overwrite clause while creating a hive table,what happens to file which are new and files which already exist?

800

Explain REVERSE function in Hive with example?

811

Clarify about the smb join in hive?

709

What is Implicit Type conversion in Hive?

835

How to Rename a table in Hive

791

How to Write a UDF function in Hive?

733

When a large data set is maintained?

773

How can you connect an application, if you run hive as a server?

750

Explain what is Hive?

760

What will be the result when you do cast(‘abc’ as int)?

802

How Hive distributes the rows into buckets?

845

What is skew data in hive?

751

What is Bucketing and Clustering in Hive?

719

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