drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "N Campbell (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-5856) invariant violated: conversion result not null when aggregate used in a PARTITION
Date Sun, 08 Oct 2017 18:49:00 GMT
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)

Mime
View raw message