Understanding Warehouse Directory

#1

Let us go through the details related to Hive Warehouse Directory.

  • A Database in Hive is nothing but HDFS Directory
  • A Table in Hive is nothing but HDFS Directory
  • A Partition in Hive is nothing but HDFS Directory
  • Warehouse Directory is the base directory where directories related to databases, tables go by default.
  • It is controlled by hive.metastore.warehouse.dir. You can get the value by saying SET hive.metastore.warehouse.dir;

Do not overwrite this property in Hive CLI

  • HDFS directory for a database will have .db extension.

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