arrow_back
Back
lock
Introduction
lock
Introduction
lock
Hive Interview Question Set 1
lock
How to create HIVE Table with multi character delimiter?
lock
How to Improve Hive Query Performance With Hadoop?
lock
Is there any way to get column name along with the output while execute query?
lock
How to load Data from a .txt file to Table Stored as ORC in Hive?
lock
if you modify the column how will the changes be tracked?
lock
How can you configure remote metastore mode in Hive?
lock
Explain about the different types of join in Hive?
lock
Mechanism for connecting from applications, when we run hive as a server?
lock
How Hive can improve performance with ORC format tables?
lock
If you run a select * query in Hive, Why does it not run MapReduce?
lock
Hive Interview Question Set 2
lock
What is the precedence order of HIVE configuration?
lock
What is the maximum size of string data type supported by hive?
lock
How to skip header rows from a table in Hive?
lock
Explain process to access sub directories recursively in Hive queries?
lock
How to change the column data type in Hive?
lock
Explain Trim and Reverse function in Hive with examples?
lock
Explain the concatenation function in Hive with an example?
lock
Is it possible to add 100 nodes when we have 100 nodes already in Hive? How?
lock
Can We Change settings within Hive Session? If Yes, How?
lock
Create single Hive table for small files without degrading performance in Hive?
lock
Hive Interview Question Set 3
lock
How will you consume this CSV file into the Hive warehouse using built SerDe?
lock
How will you remove this error? FAILED ERROR IN SEMANTIC ANALYSIS
lock
What is the default maximum dynamic partition that can be created by a mapreduce
lock
How can you add a new partition for the month December in the partitioned table?
lock
How to solve latency problem and list the steps for solution?
lock
What is dynamic partitioning and when is it used?
lock
When should we use SORT BY instead of ORDER BY?
lock
Is it possible to change the default location of a managed table?
lock
what will happen if multiple clients trying to access Hive at the same time
lock
How do you specify the table creator name when creating a table in Hive?
lock
The following statement failed to execute. What can be the cause?
lock
Hive Interview Question Set 4
lock
What does /*streamtable(table_name)*/ do?
lock
Give the command to see the indexes on a table.
lock
What types of costs are associated in creating index on hive tables?
lock
Can we LOAD data into a view?
lock
What will be the result when you do cast('abc' as INT)?
lock
How will you convert the string '51.2' to a float value in the price column?
lock
What is the usefulness of the DISTRIBUTED BY clause in Hive?
lock
Optimizing queries in Hive, what should be order of table size in a join query?
lock
Is it possible to create Cartesian join between 2 tables, using Hive?
lock
What is the difference between LIKE and RLIKE operators in Hive?
lock
How can Hive avoid mapreduce?
lock
Hive Interview Question Set 5
lock
What is a Table generating Function on hive?
lock
What does the following query do?
lock
If you omit the OVERWRITE clause while creating a hive table,what happens?
lock
LOAD DATA clause, how do you specify it is a hdfs file and not a local file?
lock
Insert a column(new_col INT) into hive (htab) at a position before exist column?
lock
When you point a partition of a hive table to a new directory, what happens?
lock
What is the significance of IF EXISTS clause while dropping a table?
lock
Which java class handles the output record encoding into files?
lock
Which java class handles Input record encoding into files which store the table?
lock
How do you check if a particular partition exists?
lock
How can you delete the DBPROPERTY in Hive?
lock
Hive Interview Question Set 6
lock
What does the 'USE' command in hive do?
lock
How do you list all databases whose name starts with p?
lock
What do you mean by schema on read?
lock
What are the default record and field delimiter used for hive text files?
lock
What is the importance of .hiverc file?
lock
Can hive queries be executed from script files? How?
lock
Can we run unix shell commands from hive? Give example?
lock
Is there a date data type in Hive?
lock
What is the default location where hive stores table data?
lock
What is the need for custom Serde?
lock
Mention how can you stop a partition from being queried?
lock
Hive Interview Question Set 7
lock
Explain when to use explode in Hive?
lock
Mention what is the difference between order by and sort by in Hive?
lock
Explain how can you change a column data type in Hive?
lock
Mention if we can name view same as the name of a Hive table?
lock
Mention what are the components of a Hive query processor?
lock
Mention what Hive query processor does?
lock
Mention what is (HS2) HiveServer2?
lock
Mention what is ObjectInspector functionality in Hive?
lock
Mention what are the different modes of Hive?
lock
When Hive is not suitable?
lock
What is the best way to load xml data into hive?
lock
Hive Interview Question Set 8
lock
Are Hive SQL identifiers (e.g. table names, column names, etc) case sensitive?
lock
Does Hive support Unicode?
lock
Did you used Mysql as Metatstore and faced errors like:CommunicationsException?
lock
When running a JOIN query, I see out-of-memory errors?
lock
How to access HBase tables from Hive?
lock
How is ORC file format optimised for data storage and analysis?
lock
What is RegexSerDe?
lock
How is SerDe different from File format in Hive?
lock
What are the different file formats in Hive?
lock
Which method has to be overridden when we use custom UDF in Hive?
lock
How does bucketing help in the faster execution of queries?
lock
Hive Interview Question Set 9
lock
How to enable bucketing in Hive?
lock
How to enable dynamic partitioning in Hive?
lock
How does partitioning help in the faster execution of queries?
lock
What are the complex data types in Hive?
lock
Explain complex data types in Hive with Example?
lock
What are managed and external tables?
lock
What is the limitation of Derby database for Hive metastore?
lock
What is the functionality of Query Processor in Apache Hive?
lock
What is ObjectInspector functionality ?
lock
How do you write your own custom SerDe?
lock
Give examples of SerDe class which hive uses to Serialize and Deserialize data?
lock
Which classes are used by the Hive to Read and Write HDFS Files?
lock
Hive Interview Question Set 10
lock
What is SerDe in Apache Hive?
lock
What are the available mechanism for connecting it from application?
lock
Is multiline comment supported in Hive Script?
lock
Is it possible to use same metastore by multiple users in case of embedded hive?
lock
Wherever (Different Directory) I run hive query, it creates new metastore_db?
lock
What is Hive Metastore?
lock
How to change the warehouse.dir location for older tables?
lock
What kind of data warehouse application is suitable for Hive?
lock
Explain what is a Hive variable. What do we use it for?
lock
What is the definition of Hive?
lock
Scenario Based Question 1 (MySQL and Hive)
lock
Scenario Based Question 2 (MySQL and Hive)
lock
What are the maximum allowed lengths for Hive SQL identifiers?
Preview - Apache Hive Interview Question and Answer (100+ FAQ)
Discuss (
0
)
navigate_before
Previous
Next
navigate_next