Apache Hive Interview Questions
Questions Answers Views Company eMail

Explain the Differences between Hive and Spark SQL?

432

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

423

Explain Clustering in Hive?

415

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

407

What are collection data types in Hive?

450

Can hive queries be executed from script files? How?

417

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

436

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

443

Explain bucketing in Hive?

496

How to optimize Hive Performance?

440

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

418

Explain Hive Thrift server?

423

Differentiate between PigLatin and Hive?

407

How is HCatalog different from Hive?

407

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

418


Post New Apache Hive Questions

Un-Answered Questions { Apache Hive }

Difference between external table and internal table in HIVE ?

618


Difference between order by and sort by in Hive?

470


What are the advantages and Disadvantages in archieving partition in Hive?

457


What is the difference between external table and managed table?

582


Explain when to use explode in Hive?

426






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

534


What is the difference between Hbase and Hive?

416


What are the default read and write classes in Hive?

409


What is a generic udf in hive?

436


In Hive, how can you enable buckets?

475


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

483


What is hive metastore?

441


What are the different Data Types available in Hive?

442


What does the following query do? Insert overwrite table employees partition (country, state) select ..., Se.cnty, se.st from staged_employees se;

616


Mention what is ObjectInspector functionality in Hive?

450