Hive warehouse directory
Hive stores table files by default in the Hive Warehouse directory.
Hive 1 and 2
The warehouse directory path is /user/hive/warehouse (CDH) or /apps/hive/warehouse (HDP)
hte warehouse directory path for a managed table is /warehouse/tablespace/managed/hive and the default location for external table is /warehouse/tablespace/external/hive.
As ACID tables reside by default in /warehouse/tablespace/managed/hive and only the Hive service can own and interact with files in this directory, applications accessing the managed tables directly need to change their behavior in Hive3.
|Hive Table before upgrade in Hive1/2||Hive Table after upgrade in Hive3||Spark Refactoring|
|Managed||Managed||Use HWC or HWC Spark Direct Reader|
CDH5, CDH6, HDP2