HDP2 to CDP Private Cloud Base Two Stage upgradePDF version

Key syntax changes

You need to modify queries affected by changes to Hive syntax after upgrading to CDP. Hive has changed the syntax related to `db.table` references, such as CREATE TABLE `mydb.mytable` … . Other syntax changes involve the LOCATION clause in CREATE TABLE. Hive in CDP supports the enhancement to CREATE TABLE that adds the MANAGEDLOCATION clause.