arrow_back
Course Introduction
Introduction
Hive Fundamentals and Table Management
What is the definition of Hive?
When Hive is not suitable?
What do you mean by schema on read?
Default location where hive stores table data
Default record and field delimiter
How to Run Hive on Windows using Docker Desktop
Load xml data into hive
Insert a column into hive at a position before exist column?
Mention if we can name a view same as the name of a Hive table?
Can we LOAD data into a view
How do you specify the table creator name when creating a table in Hive?
How can you delete the DBPROPERTY in Hive?
Hive Querying Techniques
Is there any way to get column name along with the output while execute query?
How to skip header rows from a table in Hive?
How do you list all databases whose name starts with p?
Explain process to access sub directories recursively in Hive queries?
Explain the concatenation function in Hive with an example?
Explain Trim and Reverse function in Hive with examples?
Is there a date data type in Hive?
Mention what is the difference between order by and sort by in Hive?
When should we use SORT BY instead of ORDER BY?
What is a Table generating Function on hive?
Explain when to use explode in Hive?
Give the command to see the indexes on a table.
What does the following query do?
Hive File Formats, SerDe, and Data Serialization
How to load Data from a .txt file to Table Stored as ORC in Hive?
How Hive can improve performance with ORC format tables?
How is ORC file format optimised?
What is SerDe in Apache Hive?
What is the need for custom Serde?
Consume CSV file using built SerDe
What is ObjectInspector functionality
Partitioning and Data Layout
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?
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?
What is dynamic partitioning and when is it used?
Hive Query Optimization and Performance Tuning
Different types of join in Hive
Usefulness of the DISTRIBUTED BY clause
Single Hive table for small files without degrading performance
Out-of-memory errors on JOIN
Default maximum dynamic partition
What does /*streamtable(table_name)*/ do?
What types of costs are associated in creating index on hive tables?
How to Improve Hive Query Performance With Hadoop
Optimizing queries in Hive, what should be order of table size in a join query?
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 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?
Can hive queries be executed from script files? How?
Hive Metastore, Configuration, and Sessions
Mechanism for connecting from applications (HiveServer2)
Mention what is (HS2) HiveServer2?
Change settings within Hive Session
Mysql as Metatstore CommunicationsException
Multiple clients trying to access Hive at the same time
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
Compare Hive on MR vs Hive on Tez vs Hive on Spark
What are the limitations of Hive on Tez and how to mitigate them?
Explain LLAP (Live Long and Process) and its benefits in Hive
What are vectorized queries in Hive and how do they improve performance?
What are ACID transactions in Hive and how do they work?
How do you handle Slowly Changing Dimensions (SCD) in Hive?
How does Hive handle schema evolution in ORC Parquet tables?
Modify column and track changes
Hive Security and Access Control
How to enable Kerberos authentication for Hive?
What are the security concerns with Hive metastore and how to secure it?
How do you implement fine-grained access control in Hive?
What are the auditing capabilities in Hive?
Hive Testing, Debugging, and Best Practices
Best practices for designing scalable Hive tables
Explain Hive best practices for managing small files
What are the risks of using too many partitions in Hive?
How do you unit test Hive queries?
How to debug errors from HiveServer2 logs?
How will you remove this error? FAILED ERROR IN SEMANTIC ANALYSIS
The following statement failed to execute. What can be the cause?
Rapid-Fire HiveQL & Syntax
Does Hive support Unicode?
Maximum size of string data type
Cartesian join between 2 tables
LOAD DATA clause
Hive SQL identifiers length and case sensitivity
LIKE vs RLIKE operators
Convert string '51.2' to float
Result when you cast('abc' as INT)
Omit OVERWRITE clause
IF EXISTS clause
'USE' command
Change a column data type
Real-World Scenario-Based Interview Questions
Scenario Based Question (MYSQL and HIVE) - Part 1
Scenario Based Question (MYSQL and HIVE) - Part 2
Is it possible to add 100 nodes when we have 100 nodes already in Hive? How?
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
Additional Fundamentals & SerDe
What kind of data warehouse application is suitable for Hive?
Mention what are the different modes of Hive?
Mention what are the components of a Hive query processor?
What is the functionality of Query Processor in Apache Hive?
How can Hive avoid mapreduce?
What are the maximum allowed lengths for Hive SQL identifiers?
How to create HIVE Table with multi character delimiter?
What are managed and external tables?
What are the complex data types in Hive?
Explain complex data types in Hive with Example?
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?