Apache Hive Interview Question and Answer (100+ FAQ)

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Chapter 2: Hive Interview Question Set 1

Lecture 1: How to create HIVE Table with multi character delimiter?

Lecture 2: How to Improve Hive Query Performance With Hadoop?

Lecture 3: Is there any way to get column name along with the output while execute query?

Lecture 4: How to load Data from a .txt file to Table Stored as ORC in Hive?

Lecture 5: Tips to Improve Your Course Taking Experience

Lecture 6: if you modify the column how will the changes be tracked?

Lecture 7: How can you configure remote metastore mode in Hive?

Lecture 8: Explain about the different types of join in Hive?

Lecture 9: Mechanism for connecting from applications, when we run hive as a server?

Lecture 10: How Hive can improve performance with ORC format tables?

Lecture 11: If you run a select * query in Hive, Why does it not run MapReduce?

Chapter 3: Hive Interview Question Set 2

Lecture 1: What is the precedence order of HIVE configuration?

Lecture 2: What is the maximum size of string data type supported by hive?

Lecture 3: How to skip header rows from a table in Hive?

Lecture 4: Explain process to access sub directories recursively in Hive queries?

Lecture 5: How to change the column data type in Hive?

Lecture 6: Explain Trim and Reverse function in Hive with examples?

Lecture 7: Explain the concatenation function in Hive with an example?

Lecture 8: Is it possible to add 100 nodes when we have 100 nodes already in Hive? How?

Lecture 9: Can We Change settings within Hive Session? If Yes, How?

Lecture 10: Create single Hive table for small files without degrading performance in Hive?

Chapter 4: Hive Interview Question Set 3

Lecture 1: How will you consume this CSV file into the Hive warehouse using built SerDe?

Lecture 2: How will you remove this error? FAILED ERROR IN SEMANTIC ANALYSIS

Lecture 3: What is the default maximum dynamic partition that can be created by a mapreduce

Lecture 4: How can you add a new partition for the month December in the partitioned table?

Lecture 5: How to solve latency problem and list the steps for solution?

Lecture 6: What is dynamic partitioning and when is it used?

Lecture 7: When should we use SORT BY instead of ORDER BY?

Lecture 8: Is it possible to change the default location of a managed table?

Lecture 9: what will happen if multiple clients trying to access Hive at the same time

Lecture 10: How do you specify the table creator name when creating a table in Hive?

Lecture 11: The following statement failed to execute. What can be the cause?

Chapter 5: Hive Interview Question Set 4

Lecture 1: What does /*streamtable(table_name)*/ do?

Lecture 2: Give the command to see the indexes on a table.

Lecture 3: What types of costs are associated in creating index on hive tables?

Lecture 4: Can we LOAD data into a view?

Lecture 5: What will be the result when you do cast('abc' as INT)?

Lecture 6: How will you convert the string '51.2' to a float value in the price column?

Lecture 7: What is the usefulness of the DISTRIBUTED BY clause in Hive?

Lecture 8: Optimizing queries in Hive, what should be order of table size in a join query?

Lecture 9: Is it possible to create Cartesian join between 2 tables, using Hive?

Lecture 10: What is the difference between LIKE and RLIKE operators in Hive?

Lecture 11: How can Hive avoid mapreduce?

Chapter 6: Hive Interview Question Set 5

Lecture 1: What is a Table generating Function on hive?

Lecture 2: What does the following query do?

Lecture 3: If you omit the OVERWRITE clause while creating a hive table,what happens?

Lecture 4: LOAD DATA clause, how do you specify it is a hdfs file and not a local file?

Lecture 5: Insert a column(new_col INT) into hive (htab) at a position before exist column?

Lecture 6: When you point a partition of a hive table to a new directory, what happens?

Lecture 7: What is the significance of IF EXISTS clause while dropping a table?

Lecture 8: Which java class handles the output record encoding into files?

Lecture 9: Which java class handles Input record encoding into files which store the table?

Lecture 10: How do you check if a particular partition exists?

Lecture 11: How can you delete the DBPROPERTY in Hive?

Chapter 7: Hive Interview Question Set 6

Lecture 1: What does the 'USE' command in hive do?

Lecture 2: How do you list all databases whose name starts with p?

Lecture 3: What do you mean by schema on read?

Lecture 4: What are the default record and field delimiter used for hive text files?

Lecture 5: What is the importance of .hiverc file?

Lecture 6: Can hive queries be executed from script files? How?

Lecture 7: Can we run unix shell commands from hive? Give example?

Lecture 8: Is there a date data type in Hive?

Lecture 9: What is the default location where hive stores table data?

Lecture 10: What is the need for custom Serde?

Lecture 11: Mention how can you stop a partition from being queried?

Chapter 8: Hive Interview Question Set 7

Lecture 1: Explain when to use explode in Hive?

Lecture 2: Mention what is the difference between order by and sort by in Hive?

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

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

Lecture 5: Mention what are the components of a Hive query processor?

Lecture 6: Mention what Hive query processor does?

Lecture 7: Mention what is (HS2) HiveServer2?

Lecture 8: Mention what is ObjectInspector functionality in Hive?

Lecture 9: Mention what are the different modes of Hive?

Lecture 10: When Hive is not suitable?

Lecture 11: What is the best way to load xml data into hive?

Chapter 9: Hive Interview Question Set 8

Lecture 1: Are Hive SQL identifiers (e.g. table names, column names, etc) case sensitive?

Lecture 2: Does Hive support Unicode?

Lecture 3: Did you used Mysql as Metatstore and faced errors like:CommunicationsException?

Lecture 4: When running a JOIN query, I see out-of-memory errors?

Lecture 5: How to access HBase tables from Hive?

Lecture 6: How is ORC file format optimised for data storage and analysis?

Lecture 7: What is RegexSerDe?

Lecture 8: How is SerDe different from File format in Hive?

Lecture 9: What are the different file formats in Hive?

Lecture 10: Which method has to be overridden when we use custom UDF in Hive?

Lecture 11: How does bucketing help in the faster execution of queries?

Chapter 10: Hive Interview Question Set 9

Lecture 1: How to enable bucketing in Hive?

Lecture 2: How to enable dynamic partitioning in Hive?