Retrieve metadata of Hive Tables

#1

As the table is created, let us understand how to get the metadata of a table.

  • We can get metadata of Hive Tables using several commands.
    • DESCRIBE - e.g.: DESCRIBE orders;
    • DESCRIBE EXTENDED - e.g.: DESCRIBE EXTENDED orders;
    • DESCRIBE FORMATTED - e.g.: DESCRIBE FORMATTED orders;
  • DESCRIBE will give only field names and data types.
  • DESCRIBE EXTENDED will give all the metadata, but not in readable format.
  • DESCRIBE FORMATTED will give metadata in readable format.

Practice hive on state of the art Big Data cluster - https://labs.itversity.com
You can sign up for our courses on Udemy using $10 coupons - Udemy Coupons - Big Data Courses


0 Likes