Difference between describe and describe extended command in Hive?

When creating the database or table in hive we already seen why we are using if not exists command. After creating the database or table we can use describe command to see the structure of that database or table.

Describe extended command is giving very detailed information about the table as it name says.
When creating the table if we used comment – describe command never gives the comment, However describe extended command gives that comment.

 

hive-describe-command

Whenever we creating the database or table in Hive it should be verified by describe or describe extended command.hive-describe-extended-command

 

Leave a Reply