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 are hive operators and its types?

788

when to choose “internal table” and “external table” in hive?

718

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

719

what is partitions in hive?

724

What do you mean by schema on read?

751

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

802

If you omit the overwrite clause while creating a hive table,what happens to file which are new and files which already exist?

800

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

919

What is the maximum size of string data type supported by hive? Mention the hive support binary formats.

693

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

806

If you run a select * query in hive, why does it not run mapreduce?

785

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

838

What is the precedence order of hive configuration?

977

Why hive does not store metadata information in hdfs?

992

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

724

Post New Apache Hive Questions

Un-Answered Questions { Apache Hive }

Differentiate between PigLatin and Hive?

727

What are the 2 types of table in hive?

721

Explain the Differences between Hive and Spark SQL?

746

TRIM function in Hive with example?

764

What is Implicit Type conversion in Hive?

836

When we are using queries instead of scripting?

763

What do you mean by schema on read?

751

What is bucketing ?

728

What are different Hive commands available for hive and beeline CLI?

759

Explain about the smb join in hive?

766

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?

815

Can you overwrite Hadoop MapReduce configuration in Hive?

949

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

784

What is CTAS Table in Hive?

777

Difference between external table and internal table in HIVE ?

963

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