arrow_back
Course Introduction
Introduction
Hive Fundamentals and Table Management
How to create HIVE Table with multi character delimiter?
How to load Data from a .txt file to Table Stored as ORC in Hive?
How Hive can improve performance with ORC format tables?
What are managed and external tables?
What are the complex data types in Hive?
Explain complex data types in Hive with Example?
How does bucketing help in the faster execution of queries?
How to enable bucketing in Hive
How to enable dynamic partitioning in Hive?
How does partitioning help in the faster execution of queries?
Hive Querying Techniques
Is there any way to get column name along with the output while execute query?
Explain the concatenation function in Hive with an example?
Explain Trim and Reverse function in Hive with examples?
How to skip header rows from a table in Hive?
When should we use SORT BY instead of ORDER BY?
Mention what is the difference between order by and sort by in Hive?
Explain when to use explode in Hive?
Is there a date data type in Hive?
Hive File Formats, SerDe, and Data Serialization
What is RegexSerDe?
How is SerDe different from File format in Hive?
What are the different file formats in Hive?
Which method has to be overridden when we use custom UDF in Hive?
How do you write your own custom SerDe?
Give examples of SerDe class which hive uses to Serialize and Deserialize data?
Which classes are used by the Hive to Read and Write HDFS Files?
Which java class handles Input record encoding into files which store the table?
Which java class handles the output record encoding into files?
Partitioning and Data Layout
Is it possible to change the default location of a managed table?
How can you add a new partition for the month December in the partitioned table?
When you point a partition of a hive table to a new directory, what happens?
How do you check if a particular partition exists?
Mention how can you stop a partition from being queried?
Hive Query Optimization and Performance Tuning
How to Improve Hive Query Performance With Hadoop
Optimizing queries in Hive, what should be order of table size in a join query?
What is dynamic partitioning and when is it used
How Do You Optimize Joins in Hive with Large Datasets?
Difference between indexing and bucketing — which to use when?
Explain the use of CBO (Cost-Based Optimization) in Hive
What are bloom filters in Hive and how do they help?
How does predicate pushdown work in Hive?
What are common causes for Hive job slowness and how to debug them?
How to solve latency problem and list the steps for solution?
Hive Scripting, Sessions, and Utilities
Can hive queries be executed from script files? How?
Can we run unix shell commands from hive? Give example?
Is multiline comment supported in Hive Script?
Explain what is a Hive variable What do we use it for?
What is the importance of .hiverc file?
Hive Metastore, Configuration, and Sessions
What is the precedence order of HIVE configuration?
How can you configure remote metastore mode in Hive?
What is Hive Metastore?
What is the limitation of Derby database for Hive metastore?
How to change the warehouse.dir location for older tables?
Hive Interview Question Set 7
Explain when to use explode in Hive?
Mention what is the difference between order by and sort by in Hive?
Explain how can you change a column data type in Hive?
Mention if we can name view same as the name of a Hive table?
Mention what are the components of a Hive query processor?
Mention what Hive query processor does?
Mention what is (HS2) HiveServer2?
Mention what is ObjectInspector functionality in Hive?
Mention what are the different modes of Hive?
When Hive is not suitable?
What is the best way to load xml data into hive?
Hive Interview Question Set 8
Are Hive SQL identifiers (e.g. table names, column names, etc) case sensitive?
Does Hive support Unicode?
Did you used Mysql as Metatstore and faced errors like:CommunicationsException?
When running a JOIN query, I see out-of-memory errors?
How to access HBase tables from Hive?
How is ORC file format optimised for data storage and analysis?
What is RegexSerDe?
How is SerDe different from File format in Hive?
What are the different file formats in Hive?
Which method has to be overridden when we use custom UDF in Hive?
How does bucketing help in the faster execution of queries?
Hive Interview Question Set 9
How to enable bucketing in Hive?
How to enable dynamic partitioning in Hive?
How does partitioning help in the faster execution of queries?
What are the complex data types in Hive?
Explain complex data types in Hive with Example?
What are managed and external tables?
What is the limitation of Derby database for Hive metastore?
What is the functionality of Query Processor in Apache Hive?
What is ObjectInspector functionality ?
How do you write your own custom SerDe?
Give examples of SerDe class which hive uses to Serialize and Deserialize data?
Which classes are used by the Hive to Read and Write HDFS Files?
Hive Interview Question Set 10
What is SerDe in Apache Hive?
What are the available mechanism for connecting it from application?
Is multiline comment supported in Hive Script?
Is it possible to use same metastore by multiple users in case of embedded hive?
Wherever (Different Directory) I run hive query, it creates new metastore_db?
What is Hive Metastore?
How to change the warehouse.dir location for older tables?
What kind of data warehouse application is suitable for Hive?
Explain what is a Hive variable. What do we use it for?
What is the definition of Hive?
Hive Interview Question Set 11
Scenario Based Question MySQL1
Scenario Based Question MySQL2
What are the maximum allowed lengths for Hive SQL identifiers?
How to Run Hive on Windows using Docker Desktop
What are ACID transactions in Hive and how do they work?
How does Hive handle schema evolution in ORC Parquet tables?
How do you handle Slowly Changing Dimensions (SCD) in Hive?
What are vectorized queries in Hive and how do they improve performance?
What are the limitations of Hive on Tez and how to mitigate them?
Compare Hive on MR vs Hive on Tez vs Hive on Spark
Explain LLAP (Live Long and Process) and its benefits in Hive
Hive Interview Question Set 12
How to integrate Hive with Apache Spark?
How to use Hive tables from Apache Flink or Presto?
How to connect Hive with BI tools like Tableau or Superset?
Explain Hive integration with Apache Ranger for data governance