Nick Bowles
02/24/2021, 12:08 AMSELECT COUNT(*)
FROM mytable
GROUP BY DATETIMECONVERT(item_date, '1:DAYS:SIMPLE_DATE_FORMAT:yyyy-MM-dd', '1:WEEKS:EPOCH', '1:WEEKS')
error
"errorCode": 200,
"message": "QueryExecutionError:\norg.apache.pinot.core.query.exception.BadQueryRequestException: Caught exception while initializing transform function: datetimeconvert\n\tat org.apache.pinot.core.operator.transform.function.TransformFunctionFactory.get(TransformFunctionFactory.java:207)\n\tat
table date config
"dateTimeFieldSpecs": [
{
"name": "item_date",
"dataType": "STRING",
"format": "1:DAYS:SIMPLE_DATE_FORMAT:yyyy-MM-dd",
"granularity": "1:DAYS"
}
]
Xiang Fu
DATETIMECONVERT
doesn’t support week,Nick Bowles
02/24/2021, 12:09 AMXiang Fu
Nick Bowles
02/24/2021, 12:10 AMXiang Fu
Nick Bowles
02/24/2021, 12:10 AMXiang Fu
Nick Bowles
02/24/2021, 12:10 AM