[DRILL-5856] invariant violated: conversion result not null when aggregate used in a PARTITION

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.10.0
• Component/s: SQL Parser

Environment

Drill 1.10

• Assignee: Unassigned
• Reporter: N Campbell
• Created: 08/Oct/17 18:48
• Updated: 08/Oct/17 18:48

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`