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

Apache Hive Interview Questions

Questions Answers Views Company eMail

Explain REPEAT function in Hive with example?

737

What does the "USE" command in hive do?

737

Can you give us some examples, how Hadoop is used in real time environment?

658

Write a Hive UDF that returns a sentiment score. For example, if good = 1, bad = -1, and average = 0, then a review of a restaurant states "Good food, bad service," your score might be 1 - 1 = 0.

LinkedIn,

641

Explain Usage of Hive?

655

How can client interact with Hive?

653

How do you write your own SerDe?

725

What is the significance of ‘IF EXISTS” clause while dropping a table?

655

Can we run unix shell commands from the hive? Give example?

716

How Hive organize the data?

672

Mention what are views in Hive?

656

What are the default record and field delimiter used for hive text files?

783

How can you delete the DBPROPERTY in Hive?

604

How do you check if a particular partition exists?

650

Can a partition be archived? What are the advantages and Disadvantages?

709

Post New Apache Hive Questions

Un-Answered Questions { Apache Hive }

What is the difference between piglatin and hiveql?

606

What is Clustring in Hive?

696

When to choose "External Table" in Hive?

745

What is the maximum size of string data type supported by Hive?

744

What kind of data warehouse application is suitable for Hive? What are the types of tables in Hive?

689

Double type in Hive - Important points?

646

What are the default read and write classes in Hive?

611

Explain SHOW and DESCRIBE Commands in Hive?

710

What is bucketing ?

635

How Hive distributes the rows into buckets?

747

if you run Hive as a server?

871

What is the utilization of hcatalog?

646

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

727

What is the difference between the external table and managed table?

671

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

1110

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