adspace


Explain SHOW and DESCRIBE Commands in Hive?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

Where does the data of a Hive table gets stored?

750


How to skip header rows from a table in Hive?

907


What are the different types of tables available in Hive?

767


How can I delete the above index named index_bonuspay?

807


When to use explode in Hive?

832


What is the stable version of Hive ?

2696


When to choose "External Table" in Hive?

867


What is a Hive variable? What for we use it?

881


When we are using queries instead of scripting?

801


Can We Change settings within Hive Session? If Yes, How?

859