N Campbell created DRILL-5856: --------------------------------- Summary: invariant violated: conversion result not null when aggregate used in a PARTITION Key: DRILL-5856 URL: https://issues.apache.org/jira/browse/DRILL-5856 Project: Apache Drill Issue Type: Bug Components: SQL Parser Affects Versions: 1.10.0 Environment: Drill 1.10 Reporter: N Campbell
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` -- This message was sent by Atlassian JIRA (v6.4.14#64029)