HIVE2: HAVING specified without GROUP BY ----------------------------------------- Key: TEIID-2801 URL: https://issues.jboss.org/browse/TEIID-2801 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 8.6 Environment: Teiid with HIVE1 and HIVE2 Reporter: Ivan Chan Assignee: Steven Hawkins Labels: teiid Fix For: 8.7 If SQL contains HAVING, with group by. HIVE2 will throw the following exception: HAVING specified without GROUP BY, errorCode:40000, SQLState:42000) at org.apache.hadoop.hive.service.ThriftHive$execute_result$execute_resultStandardScheme.read(ThriftHive.java:1494) at org.apache.hadoop.hive.service.ThriftHive$execute_result$execute_resultStandardScheme.read(ThriftHive.java:1480) at org.apache.hadoop.hive.service.ThriftHive$execute_result.read(ThriftHive.java:1430) at org.apache.thrift.TServiceClient.receiveBase(TServiceClient.java:78) at org.apache.hadoop.hive.service.ThriftHive$Client.recv_execute(ThriftHive.java:116) at org.apache.hadoop.hive.service.ThriftHive$Client.execute(ThriftHive.java:103) at org.apache.hadoop.hive.jdbc.HivePreparedStatement.executeImmediate(HivePreparedStatement.java:175)