Abhijeet Kushe
04/20/2022, 7:24 PMselect taskName, taskResult, distinctcount(personId) from events where accountId = 1100609261882 AND workId = '40d9652e-c543-4bd2-aa4d-a11c7b23a6df' group by taskName, taskResult order by mode(createdOn) asc limit 10000
but this throws an exception
select taskName, taskResult, distinctcount(personId) from events where accountId = 1100609261882 AND workId = '40d9652e-c543-4bd2-aa4d-a11c7b23a6df' group by taskName, taskResult order by createdOn asc limit 10000
[
{
"message": "QueryExecutionError:\nProcessingException(errorCode:450, message:InternalError:\njava.lang.NullPointerException\n\tat org.apache.pinot.core.operator.combine.GroupByOrderByCombineOperator.mergeResults(GroupByOrderByCombineOperator.java:230)\n\tat org.apache.pinot.core.operator.combine.BaseCombineOperator.getNextBlock(BaseCombineOperator.java:120)\n\tat org.apache.pinot.core.operator.combine.BaseCombineOperator.getNextBlock(BaseCombineOperator.java:50)",
"errorCode": 200
}
]
mode(createdOn) asc
is the difference
what makes it work ..is this a bug ?Neha Pawar
Abhijeet Kushe
04/20/2022, 8:41 PMtaskName,taskResult ,distinctcount
will be sorted by createdOn in other words the first taskName and taskResult will be displayed first in the output …I want a consistent or a guaranteed sort order either ascending or descending. I don’t want to group by each createdOn timestampNeha Pawar
select taskName, taskResult, distinctcount(personId),max(createdOn) from events where accountId = 1100609261882 AND workId = '40d9652e-c543-4bd2-aa4d-a11c7b23a6df' group by taskName, taskResult order by max(createdOn) desc limit 10000
Abhijeet Kushe
04/20/2022, 8:54 PMselect taskName, taskResult, distinctcount(personId) from events where accountId = 1100609261882 AND workId = '40d9652e-c543-4bd2-aa4d-a11c7b23a6df' group by taskName, taskResult order by max(createdOn) desc limit 10000
Neha Pawar
Abhijeet Kushe
04/20/2022, 8:57 PM