First, I would debug the results of your expression to ensure the COUNT(*) portion of the query matches what you're expecting, before applying the AVG(). Details on debugging elements can be found in this blog post:
I would imagine COUNT(*) is returning you a single number-- the count of results-- rather than a collection of counts to average.
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.