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
-- storm mailing list [email protected] Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/storm
