[storm] Selecting a count on a group

[Bryan Ward]

I have written an sql query that I would like to implement in storm, but I
can't seem to figure out how.  Here is the MySQL query I am trying to
replicate:

SELECT h.*,COUNT(f.height_id) AS factorsCount
FROM height AS h
LEFT JOIN factors AS f ON (f.height_id = h.id)
GROUP BY h.id
HAVING factorsCount=4
ORDER BY h.id;

I can't figure out a way to access the the column aliased as factorsCount.
Is this type of query supported or do I need to do I need to drop into raw
SQL for these types of queries?

Thanks,
Bryan
-------------- next part --------------
An HTML attachment was scrubbed...
URL: https://lists.ubuntu.com/archives/storm/attachments/20090310/82354d68/attachment.htm