apache/pinot
Cast with Alias is not recognized in group by
Fechada
#14.590 aberto em 4 de dez. de 2024
bughelp wantedquerystale
Métricas do repositório
- Stars
- (4.937 estrelas)
- Métricas de merge de PR
- (Mesclagem média 6d 7h) (186 fundiu PRs em 30d)
Description
Sampe query:
SELECT
CAST(DATE_TRUNC('day', CAST(DATETIMECONVERT(ts, '1:MILLISECONDS:EPOCH', '1:MILLISECONDS:EPOCH', '1:MILLISECONDS') AS TIMESTAMP)) AS TIMESTAMP) AS day_epoch_ms,
sum(met) AS "sumMet"
FROM mytable
GROUP BY
CAST(DATE_TRUNC('day', CAST(DATETIMECONVERT(ts, '1:MILLISECONDS:EPOCH', '1:MILLISECONDS:EPOCH', '1:MILLISECONDS') AS TIMESTAMP)) AS TIMESTAMP)
ORDER BY
sum(met) DESC
LIMIT 10000;
Exception:
Error: {'errorCode': 150,
'message': 'SQLParsingError:\n'
'org.apache.pinot.sql.parsers.SqlCompilationException: '
"'as(cast(datetrunc('day', cast(datetimeconvert(ts, "
"'1:MILLISECONDS:EPOCH', '1:MILLISECONDS:EPOCH', "
"'1:MILLISECONDS'), 'TIMESTAMP')), 'TIMESTAMP'), day_epoch_ms)' should "
'appear in GROUP BY clause.\n'