Apache Hive Interview Questions
Questions Answers Views Company eMail

Mention what are the type of database does Hive support ?

443

what Hive is composed of ?

386

Give the command to see the indexes on a table?

471

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

448

Explain the Use of Hive?

415

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

414

How to managed create a table in hive ?

410

what is Metastore in Hive?

400

Mention key components of Hive Architecture?

590

what Hive query processor does?

401

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

603

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 ?

416

What is a table generating function on hive?

408

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

424

When to use Hive?

439


Post New Apache Hive Questions

Un-Answered Questions { Apache Hive }

How can you transfer data from hive to hdfs?

419


How to Write a UDF function in Hive?

411


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

474


Mention what is HiveServer2 (HS2)?

482


What are the different Primitive Data Types available in Hive?

427






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

456


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

426


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

829


Explain the Use of Hive?

415


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

441


What is the need for custom serde?

443


What is CONCATENATE command in Hive?

572


How do you write your own SerDe?

457


Why do we need hive?

410


What types of costs are associated with creating the index on hive tables?

658