I'm getting an exception when I try using HAVING, and not a very useful one: [search_phase_execution_exception]. It's possible that it doesn't support HAVING. My SQL is super rusty, but I would expect WHERE COUNT(requestuid) = 1 to be basically the same query, but that doesn't work... it doesn't cause an exception, but it also doesn't filter any of the results.
Are you also getting an exception or is something else happening with that query?
@ggajanan additionally to @Joe_Fleming's question, can you also mention how you are running that query and, if possible, include the complete request?
Thanks
Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant
logo are trademarks of the
Apache Software Foundation
in the United States and/or other countries.