Migrating Data to Cloudera on CloudPDF version

Table locations

After migration from HDP 2.x, the relative paths for databases, tables, and partitions on the destination Cloudera cluster are different from HDP 2.x.

  • HDP 2.x managed table location: /apps/hive/warehouse
  • HDP 2.x external table location: /user/hive/warehouse”
After migration from HDP 3.x, the relative paths for databases, tables, partitions on the destination Cloudera cluster are the same as the HDP 3.x:
  • HDP 3.x and Cloudera managed table location: /warehouse/tablespace/managed/hive
  • HDP 3.x and Cloudera external table location: /warehouse/tablespace/external/hive