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

Apache Hive Interview Questions

Questions Answers Views Company eMail

Mention what are the type of database does Hive support ?

739

what Hive is composed of ?

719

Give the command to see the indexes on a table?

958

Can the name of a view be same as the name of a hive table?

801

Explain the Use of Hive?

740

What is the difference between like and rlike operators in hive?

790

How to managed create a table in hive ?

763

what is Metastore in Hive?

715

Mention key components of Hive Architecture?

889

what Hive query processor does?

701

What does the following query do? Insert overwrite table employees partition (country, state) select ..., Se.cnty, se.st from staged_employees se;

956

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

What is a table generating function on hive?

755

As part of optimizing the queries in hive, what should be the order of table size in a join query?

730

When to use Hive?

757

Post New Apache Hive Questions

Un-Answered Questions { Apache Hive }

What is bucketing ?

728

What is Bucket in Hive?

775

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

719

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

724

Mention what are views in Hive?

728

What will happen in case you have not issued the command: ‘set hive.enforce.bucketing=true;’ before bucketing a table in hive in apache hive 0.x or 1.x?

814

Can we change the data type of a column in a hive table?

734

What is the prerequisite for Apache Hive installation?

752

Give examples of the SerDe classes which hive uses to Serialize and Deserialize data?

737

What database are supported by Hive?

739

How do we write our own custom serde?

743

What is the difference between sort by and order by in hive?

713

Hive new version supported Hadoop Versions ?

638

What kind of applications is supported by Apache Hive?

850

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

1198

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