Apache Hive Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Apache Hive Interview Questions

Questions Answers Views Company eMail

What are hive operators and its types?

788

when to choose “internal table” and “external table” in hive?

717

How do you specify the table creator name when creating a table in hive?

719

what is partitions in hive?

724

What do you mean by schema on read?

749

What will be the result when you do cast(‘abc’ as int)?

802

If you omit the overwrite clause while creating a hive table,what happens to file which are new and files which already exist?

800

How will you convert the string ’51.2’ to a float value in the price column?

919

What is the maximum size of string data type supported by hive? Mention the hive support binary formats.

693

What is available mechanism for connecting from applications, when we run hive as a server?

805

If you run a select * query in hive, why does it not run mapreduce?

784

Can we run unix shell commands from hive? Can hive queries be executed from script files? How? Give an example.

837

What is the precedence order of hive configuration?

977

Why hive does not store metadata information in hdfs?

989

Whenever we run hive query, new metastore_db is created. Why?

724

Post New Apache Hive Questions

Un-Answered Questions { Apache Hive }

Is it possible to use the same metastore by multiple users, in case of the embedded hive?

844

Explain about ACID transactions in Hive?

775

How to create table in hive for a json input file?

858

What is CTE Table in Hive?

783

Is it possible to create cartesian join between 2 tables, using hive?

723

Where is table data stored in Apache Hive by default?

845

As part of optimizing the queries in hive, what should be the order of table size in a join query?

730

When a large data set is maintained?

773

In which scenario Hive is good fit?

1017

Differentiate between PigLatin and Hive?

725

What is Apache Hive?

867

What is the usefulness of the distributed by clause in hive?

771

Can you overwrite Hadoop MapReduce configuration in Hive?

949

CONCAT function in Hive with Example?

859

How can you add a new partition for the month December in the above partitioned table?

710

For More Un-Answered { Apache Hive } Questions Click Here