Hi Team, Are aggregation functions supported with lookup join? I have the below query 

SELECT column1
	,column2
	,lookup('dimTable', 'username', 'orgId', orgId, 'userId', userId) AS username
FROM tableA
WHERE column2 IN ('Good')
	AND column1 != 'Unknown'
	AND username = 'user'
 limit 100

This returns me the result, However, the moment I add either a count(*) in the select statement or a "group by" the query keeps on loading. Eg:

SELECT column1
	,column2
	,orgId
	,lookup('dimTable', 'username', 'orgId', orgId, 'userId', userId) AS username
FROM tableA
WHERE column2 IN ('Good')
	AND column1 != 'Unknown'
	AND username = 'user'
GROUP BY column1, column2, orgId, username
 limit 100

What version of Pinot are you using? There was a UI bug where syntax error in query would not be reported in the UI and it keeps loading

The version is 0.8.0.11

I think this one is probably resolved, can you query broker directly to eliminate this?