1. Categories >> Software >> Big Data >> Hadoop >> Apache Hive
  2. Suggest New Category

Explain SHOW and DESCRIBE Commands in Hive?

Question Posted / rajan kumar jaiswal


Explain SHOW and DESCRIBE Commands in Hive?..

Answer / Malik Mohammad Zeshan

SHOW command is used to display information about various objects in Hive, such as tables, databases, partitions, or functions. The DESCRIBE command provides a detailed schema of the specified table or column, including data types, comments, and other metadata.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Apache Hive Interview Questions

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

1 Answers  

How can you configure remote metastore mode in Hive?

1 Answers  

What are the different Data Types available in Hive?

1 Answers  

Mention what are the type of database does Hive support ?

1 Answers  

is HQL case sensitive?

1 Answers  

When you are dealing with static data instead of dynamic data?

1 Answers  

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

1 Answers  

What is the need for custom serde?

1 Answers  

Differentiate between hive and hbase?

1 Answers  

Mention what is HiveServer2 (HS2)?

1 Answers  

How many types of Tables in Hive?

1 Answers  

What kind of applications is supported by Apache Hive?

1 Answers  

For more Apache Hive Interview Questions Click Here
Categories