[ https://issues.apache.org/jira/browse/HIVE-3186?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Carl Steinbach updated HIVE-3186: --------------------------------- Component/s: SQL > support having without a grouping operation (per ISO-SQL 2012) > -------------------------------------------------------------- > > Key: HIVE-3186 > URL: https://issues.apache.org/jira/browse/HIVE-3186 > Project: Hive > Issue Type: Improvement > Components: SQL > Affects Versions: 0.8.0 > Reporter: N Campbell > > select count(*) from cert.tset1 tset1 having count(*) > 2 > granted you can manually write a grouped derived table and filter etc but it > valid to define a having statement (implicit grouped table). > HAVING specified without GROUP BY -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira