Apache Hive Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Apache Hive Interview Questions

Questions Answers Views Company eMail

What is the difference between Internal Table and External Table in Hive?

726

what are the different modes of Hive?

702

In Hive, can you overwrite Hadoop MapReduce configuration in Hive?

771

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

694

When should we use SORT BY instead of ORDER BY?

690

Mention how can you stop a partition form being queried?

1115

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

689

What are Features of Hive?

724

Difference between HBase vs Hive?

722

Difference between order by and sort by in Hive?

725

What is Internal and External table in Hive?

714

What are the different components of a Hive architecture?

837

Explain how Hive Deserialize and serialize the data?

737

Mention what is ObjectInspector functionality in Hive?

741

Mention what is the difference between Hbase and Hive?

692

Post New Apache Hive Questions

Un-Answered Questions { Apache Hive }

What is the use of explode in Hive?

728

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

764

Is hive suitable to be used for oltp systems? Why?

795

What is skew data in hive?

698

How can client interact with Hive?

698

When executing Hive queries in different directories, why is metastore_db created in all places from where Hive is launched?

837

What is sample Query in Hive?

699

What is the major difference between local and remote meta-store?

900

What is the man difference between hbase and hive?

667

Is it possible to create cartesian join between 2 tables, using hive?

681

Explain REPEAT function in Hive with example?

803

What kind of applications is supported by Apache Hive?

812

Clarify about the smb join in hive?

657

What is Internal and External table in Hive?

714

Does Pig give any warning when there is a type mismatch or missing field?

897

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