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?

751

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

678

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

692

what is partitions in hive?

684

What do you mean by schema on read?

715

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

764

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

753

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

887

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

666

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

769

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

744

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

802

What is the precedence order of hive configuration?

937

Why hive does not store metadata information in hdfs?

939

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

684

Post New Apache Hive Questions

Un-Answered Questions { Apache Hive }

How do you list all databases whose name starts with p?

693

Which java class handles the Input record encoding into files which store the tables in Hive?

732

Mention how can you stop a partition form being queried?

1115

Can you execute Hadoop dfs Commands from Hive CLI? How?

1167

What is the utilization of hcatalog?

686

Can a table be renamed in Hive?

735

What is the difference between Cassandra, Pig and Hive?

987

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

681

Difference between external table and internal table in HIVE ?

924

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

769

Explain how Hive Deserialize and serialize the data?

737

What is difference between hive and hdfs?

629

What is the difference between CREATE TABLE AND CREATE EXTERNAL TABLE?

701

How to stop a partition form being queried?

1159

Is it possible to add 100 more nodes when we already have 100 nodes in Hive?

1264

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