Details
-
Bug
-
Status: Open
-
Major
-
Resolution: Unresolved
-
1.10.0
-
None
-
None
-
Drill 1.10
Description
If the partition specification of a windowed aggregate includes a regular aggregate, the query will fail with Error: SYSTEM ERROR: AssertionError: Internal error: invariant violated: conversion result not null
SELECT
`SNO` AS `C1`,
SUM(`QTY`) AS `C2`,
SUM(MAX(`QTY`))
OVER(
PARTITION BY
`SNO`,
MAX(`QTY` * 10)
) AS `C3`
FROM
( values ( 'A', 1) ) T1 ( SNO, QTY )
GROUP BY
`SNO`