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?
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?
How to skip header rows from a table 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?
Wherever (Different Directory) I run hive query, it creates new metastore_db?
Is it possible to use same metastore by multiple users in case of embedded hive
Hive Integration with Hadoop Ecosystem
How to access HBase tables from Hive?
How to integrate Hive with Apache Spark?
How to use Hive tables from Apache Flink or Presto?
How to use Apache Hive with Apache Kafka for real-time ingestion?
What is Hive Warehouse Connector in HDP environments?
Explain Hive integration with Apache Ranger for data governance
How to connect Hive with BI tools like Tableau or Superset?
Advanced Hive Features
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 Security and Access Control
How do you implement fine-grained access control in Hive?
What are the security concerns with Hive metastore and how to secure it?
How to enable Kerberos authentication for Hive?
What are the auditing capabilities in Hive?
Hive Testing, Debugging, and Best Practices
How do you unit test Hive queries?
How to debug errors from HiveServer2 logs?
Best practices for designing scalable Hive tables
What are the risks of using too many partitions in Hive?
Explain Hive best practices for managing small files
Real-World Scenario-Based Interview Questions
How would you migrate legacy Hive tables to a new cluster?
Design a data pipeline with Hive to handle log analytics
How would you implement GDPR compliance using Hive?
Your Hive query runs without error but returns nulls — how do you troubleshoot
You are asked to speed up a slow-performing Hive dashboard
Scenario based case study Join optimization across 3 partitioned tables
Hive Interview Question Set 14
Scenario Based Question (MySQL and Hive) 1
Scenario Based Question (MySQL and Hive) 2
Does Hive support Unicode?
What is the maximum size of string data type supported by hive?
When Hive is not suitable ?
Is it possible to add 100 nodes when we have 100 nodes already in Hive? How?
How will you remove this error? FAILED ERROR IN SEMANTIC ANALYSIS
Is it possible to create Cartesian join between 2 tables, using Hive?
LOAD DATA clause, how do you specify it is a hdfs file and not a local file?
The following statement failed to execute. What can be the cause?
Give the command to see the indexes on a table.
Are Hive SQL identifiers (e.g. table names, column names, etc) case sensitive?
What does the following query do?
What is SerDe in Apache Hive?
What are the available mechanism for connecting it from application?
What is the difference between LIKE and RLIKE operators in Hive?
How will you convert the string '51.2' to a float value in the price column?
What is ObjectInspector functionality?
How can you delete the DBPROPERTY in Hive?
What will be the result when you do cast('abc' as INT)?
How can Hive avoid mapreduce?
Explain about the different types of join in Hive?
What is a Table generating Function on hive?
What is the need for custom Serde?
if you modify the column how will the changes be tracked?
Mention what Hive query processor does?
What is the usefulness of the DISTRIBUTED BY clause in Hive?
Mention what is (HS2) HiveServer2?
If you omit the OVERWRITE clause while creating a hive table,what happens?
What is the functionality of Query Processor in Apache Hive?
How do you list all databases whose name starts with p?
Create single Hive table for small files without degrading performance in Hive?
Hive Interview Question Set 15
What is the significance of IF EXISTS clause while dropping a table?
What kind of data warehouse application is suitable for Hive?
If you run a select * query in Hive, Why does it not run MapReduce?
What is the definition of Hive?
Mention if we can name view same as the name of a Hive table?
Insert a column(new_col INT) into hive (htab) at a position before exist column?
Explain process to access sub directories recursively in Hive queries?
How is ORC file format optimised for data storage and analysis?
What does the 'USE' command in hive do?
What are the maximum allowed lengths for Hive SQL identifiers?
How do you specify the table creator name when creating a table in Hive?
What do you mean by schema on read?
What is the best way to load xml data into hive?
What are the default record and field delimiter used for hive text files?
What does /*streamtable(table_name)*/ do?
Can we LOAD data into a view?
When running a JOIN query, I see out-of-memory errors?
Can We Change settings within Hive Session? If Yes, How?
How to Run Hive on Windows using Docker Desktop
Mechanism for connecting from applications, when we run hive as a server?
What types of costs are associated in creating index on hive tables?
Explain how can you change a column data type in Hive?
Mention what are the components of a Hive query processor
How to change the column data type in Hive?
Did you used Mysql as Metatstore and faced errors like CommunicationsException?
What is the default location where hive stores table data?
what will happen if multiple clients trying to access Hive at the same time
Mention what are the different modes of Hive?
How will you consume this CSV file into the Hive warehouse using built SerDe?
What is the default maximum dynamic partition that can be created by a mapreduce