[ https://issues.apache.org/jira/browse/HIVE-3186?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16475696#comment-16475696 ]
David Zanter commented on HIVE-3186: ------------------------------------ FYI: This looks to be working now with Hortonworks v3.0/Hive v3.0 > support having without a grouping operation (per ISO-SQL 2011) > -------------------------------------------------------------- > > 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 > Priority: Major > > 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 was sent by Atlassian JIRA (v7.6.3#76005)