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 is the difference between Internal Table and External Table in Hive?

759

what are the different modes of Hive?

735

In Hive, can you overwrite Hadoop MapReduce configuration in Hive?

817

Explain how can you change a column data type in Hive?

737

When should we use SORT BY instead of ORDER BY?

743

Mention how can you stop a partition form being queried?

1151

Mention if we can name view same as the name of a Hive table?

721

What are Features of Hive?

754

Difference between HBase vs Hive?

766

Difference between order by and sort by in Hive?

763

What is Internal and External table in Hive?

753

What are the different components of a Hive architecture?

868

Explain how Hive Deserialize and serialize the data?

779

Mention what is ObjectInspector functionality in Hive?

770

Mention what is the difference between Hbase and Hive?

736

Post New Apache Hive Questions

Un-Answered Questions { Apache Hive }

Can you define serde in hive?

722

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

919

What do hive variable means? How can we utilize it?

625

Specify the partitions in hive?

692

Mention what is HiveServer2 (HS2)?

818

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

722

what is Metastore in Hive?

715

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

838

What is hive installation path?

784

Are there any problems which can only be solved by MapReduce and cannot be solved by PIG? In which kind of scenarios MR jobs will be more useful than PIG?

817

What is CTE Table in Hive?

783

what Hive is composed of ?

719

RLIKE in Hive?

834

What is skew data in hive?

751

While loading data into a hive table using the load data clause, how do you specify it is a hdfs file and not a local file ?

765

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