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?

697

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?

846

How to optimize Hive Performance?

714

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

700

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 }

What is the default maximum dynamic partition that can be created by a mapper reducer? How can you change it?

718

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

719

Mention if we can name view same as the name of a Hive table?

690

what is hadoop archive?

921

What is the difference between local and remote metastore?

1108

Can you list few commonly used hive services?

657

What is hive installation path?

741

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

734

How to load data into table created in hive ?

695

What is BloomMapFile used for?

670

Explain REPEAT function in Hive with example?

804

What is the difference between Hive CLI and Beeline?

839

What types of costs are associated with creating the index on hive tables?

1016

what does /*streamtable(table_name)*/ do?

777

How can you configure remote metastore mode in Hive?

829

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