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?

684

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

632

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

649

what is partitions in hive?

646

What do you mean by schema on read?

673

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

727

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

716

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

843

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

603

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

724

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

708

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

750

What is the precedence order of hive configuration?

887

Why hive does not store metadata information in hdfs?

889

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

652

Post New Apache Hive Questions

Un-Answered Questions { Apache Hive }

How can you configure remote metastore mode in Hive?

772

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

1110

How is HCatalog different from Hive?

639

Say what the views are in hive?

636

What is the difference between Internal Table and External Table in Hive?

683

Describe REVERSE function in Hive with example?

666

What is the definition of Hive?

692

What database are supported by Hive?

658

What is the need for custom serde?

690

Why Hive is not suitable for OLTP systems?

675

Mention what is HiveServer2 (HS2)?

741

Explain what is Hive?

678

What kind of datawarehouse application is suitable for Hive?

650

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

638

What is Hive Database?

667

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