It looks like that you are using Hive JDBC driver, and also seems like the driver has transformed the query which become invalid. Two options here: 1. check which version of JDBC driver you using, try use the latest one to see if it helps 2. disable the query transformation in JDBC using UseNativeQuery and set it to 1, please refer to user manual below: http://www.cloudera.com/documentation/other/connectors/hive-jdbc/latest/Cloudera-JDBC-Driver-for-Apache-Hive-Install-Guide.pdf ... View more