Surendra
06/15/2021, 5:38 PM2021/06/10 16:53:02.084 WARN [BaseBrokerRequestHandler] [jersey-server-managed-async-executor-100] Caught exception while updating Column names in Query 13040: Illegal AstNode type for TransformExpressionTree: org.apache.pinot.pql.parsers.pql2.ast.StarExpressionAstNode
and if we update else null
in case clause to else 'null'
it's working in .7.1 , any clues ?
select emp_id ,
id ,
max(timestampMs) as last_updated,
count(DISTINCT case when emp_type = 'admin' then user_count else null end) as admin_counts
from emp_events
where org_id = 987
AND timestampMs >= 1620892156939
AND timestampMs < 1621630122162
group by emp_id, id
limit 10
Jackie
06/15/2021, 6:08 PMnull
in query as of now. In the old version it might somehow be overridden to string 'null'
but that is not the correct semantic of the query thoughnull
as real null
instead of string 'null'
Surendra
06/15/2021, 6:17 PMJackie
06/15/2021, 6:20 PMnull
to make it a string 'null'
Surendra
06/15/2021, 6:21 PMJackie
06/15/2021, 6:22 PMemp_type
filteringSurendra
06/15/2021, 6:23 PMJackie
06/15/2021, 6:23 PMselect emp_id ,
id ,
max(timestampMs) as last_updated,
from emp_events
where org_id = 987
AND timestampMs >= 1620892156939
AND timestampMs < 1621630122162
group by emp_id, id
limit 10
Q2
select emp_id ,
id ,
count(DISTINCT user_count) as admin_counts
from emp_events
where org_id = 987
AND emp_type = 'admin'
AND timestampMs >= 1620892156939
AND timestampMs < 1621630122162
group by emp_id, id
limit 10