In EMR 5.2, Hive engine is Tez and hence Hive classpath contains Tez jars. However the HIVE_CLASSPATH determined by CDAP does not contain the Tez jars, and hence queries fail.
Release Notes
Include Tez JARs in HIVE_CLASSPATH on Amazon EMR clusters with Tez installed.
In EMR 5.2, Hive engine is Tez and hence Hive classpath contains Tez jars. However the HIVE_CLASSPATH determined by CDAP does not contain the Tez jars, and hence queries fail.