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?

746

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

734

Explain Clustering in Hive?

744

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

737

What are collection data types in Hive?

768

Can hive queries be executed from script files? How?

692

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

737

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

844

Explain bucketing in Hive?

883

How to optimize Hive Performance?

755

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

740

Explain Hive Thrift server?

724

Differentiate between PigLatin and Hive?

725

How is HCatalog different from Hive?

714

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

703

Post New Apache Hive Questions

Un-Answered Questions { Apache Hive }

Why hive does not store metadata information in hdfs?

989

What is the importance of .hiverc file?

895

RLIKE in Hive?

833

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

805

Does Hive support record level Insert, delete or update?

722

What is the man difference between hbase and hive?

717

Why do we perform partitioning in Hive?

786

When Hive is run in embedded mode

1917

What are the different Primitive Data Types available in Hive?

725

What are the key segments of hive architecture?

731

Give some points of hive for hadoop ?

760

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

737

What is the significance of the line set hive.mapred.mode = strict;?

853

What is Bucket in Hive?

775

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

1024

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