Migrating Hive Workloads to Cloudera Private CloudPDF version

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.