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?

683

what are the different modes of Hive?

650

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

739

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

650

When should we use SORT BY instead of ORDER BY?

657

Mention how can you stop a partition form being queried?

1077

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

642

What are Features of Hive?

701

Difference between HBase vs Hive?

678

Difference between order by and sort by in Hive?

679

What is Internal and External table in Hive?

658

What are the different components of a Hive architecture?

801

Explain how Hive Deserialize and serialize the data?

697

Mention what is ObjectInspector functionality in Hive?

710

Mention what is the difference between Hbase and Hive?

641

Post New Apache Hive Questions

Un-Answered Questions { Apache Hive }

Explain when to use explode in Hive?

648

How can you add a new partition for the month December in the above partitioned table?

638

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

951

What is hive metastore?

676

What is the significance of ‘IF EXISTS” clause while dropping a table?

658

Difference between external table and internal table in HIVE ?

879

how can we access the sub directories recursively?

751

What are the different components of a Hive query processor?

1383

What is the difference between Hiveserver1 and Hiveserver2?

745

What is SerDe in Apache Hive ?

868

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

828

What will happen in case you have not issued the command: ‘set hive.enforce.bucketing=true;’ before bucketing a table in hive in apache hive 0.x or 1.x?

725

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

847

How can you connect an application, if you run hive as a server?

685

What are the different Complex Data Types available in Hive?

869

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