Lenses not Grouping-by correctly in SQL Statement - showing only 1 result

[james1985]

I’m trying to do a GROUP BY with a parsed timestamp in Lenses. My example is:

SELECT MINUTE(_meta.timestamp) as min, count(*) as sum FROM mytopic GROUP BY min

But the GROUP BY only seems to show one result

[guillaume.ayme]

You can’t GROUP BY on the alias in the projection. You need to call out the Projection: eg. GROUP BY MINUTE(_meta.timestamp)

SELECT name, MINUTE(_meta.timestamp) as min, count(*) FROM foo2 GROUP BY MINUTE(_meta.timestamp)