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 Clustring in Hive?

696

Mention Hive default read and write classes?

700

what are views in Hive?

714

In Hive, how can you enable buckets?

700

Is it possible to change the default location of a managed table?

690

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

671

What is Bucketing and Clustering in Hive?

642

How to create table in hive for a json input file?

771

what is the difference between order by and sort by in Hive?

658

How Hive distributes the rows into buckets?

747

Why is Hive not suitable for OLTP systems?

713

Why do we perform partitioning in Hive?

698

Wherever (Different Directory) I run the hive query, it creates new metastore_db, please explain the reason for it?

715

What is the difference between local and remote metastore?

1063

What are different modes of metastore deployment in Hive?

666

Post New Apache Hive Questions

Un-Answered Questions { Apache Hive }

What is the current version of Hive?

730

What is a generic UDF in the hive?

703

What ate the key components of Hive Architecture?

803

Does Hive support record level Insert, delete or update?

644

Explain the Use of Hive?

657

Differentiate between describe and describe extended?

664

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 ?

691

Is the keyword 'DEFINE' like a function name?

890

What is different table structure available in the hive?

628

what is Metastore in Hive?

634

How do you write your own custom SerDe ?

698

How can hive avoid mapreduce?

624

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

727

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

789

What does the “USE” command in the hive do?

656

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