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
`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