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?

677

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.

665

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?

743

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

800

What is the precedence order of hive configuration?

934

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 }

What are the different components of a Hive query processor?

1423

Can we load data into a view?

701

Why do we need buckets?

714

Specify the different types of tables accessible in hive?

799

What is the purpose of exploding in hive?

670

Give some points of hive for hadoop ?

721

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

684

What is metastore?

633

How do you write your own SerDe?

764

What is Hive Present Version ?

1092

What is the difference between piglatin and hiveql?

655

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

730

Wherever (Different Directory) I run hive query, it creates new metastore_db, please explain the reason for it?

663

What are different Hive commands available for hive and beeline CLI?

725

what Hive query processor does?

667

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