Handling 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.