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 the Differences between Hive and Spark SQL?

714

Can we change the data type of a column in a hive table?

695

Explain Clustering in Hive?

707

What does the “USE” command in the hive do?

695

What are collection data types in Hive?

721

Can hive queries be executed from script files? How?

660

Give examples of the SerDe classes which hive uses to Serialize and Deserialize data?

700

Is it possible to use the same metastore by multiple users, in case of the embedded hive?

804

Explain bucketing in Hive?

843

How to optimize Hive Performance?

711

What is the difference between CREATE TABLE AND CREATE EXTERNAL TABLE?

698

Explain Hive Thrift server?

696

Differentiate between PigLatin and Hive?

689

How is HCatalog different from Hive?

683

Which java class handles the output record encoding into files which result from Hive queries?

665

Post New Apache Hive Questions

Un-Answered Questions { Apache Hive }

Can we run unix shell commands from hive? Give example?

674

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

988

What do you understand by hive?

681

what are views in Hive?

760

What are the file formats that Hive supports and can use be used for storage?

867

What is a metastore in hive?

699

Mention what is ObjectInspector functionality in Hive?

741

What is the functionality of Query Processor in Apache Hive?

758

What is bucketing ?

683

Explain Data Type Conversion in Hive?

716

What is ObjectInspector functionality?

825

What will be the output of cast ('XYZ' as INT)?

687

What are the Binary Storage formats supported in Hive?

723

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

734

What is the use of "order by" in Hive?

964

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