Mailing-List: contact issues-help@drill.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@drill.apache.org
Date: Sun, 8 Oct 2017 18:49:00 +0000 (UTC)
From: "N Campbell (JIRA)" <jira@apache.org>
To: issues@drill.apache.org
Message-ID: <JIRA.13107861.1507488529000.1779.1507488540043@Atlassian.JIRA>
In-Reply-To: <JIRA.13107861.1507488529000@Atlassian.JIRA>
References: <JIRA.13107861.1507488529000@Atlassian.JIRA> <JIRA.13107861.1507488529440@jira-lw-us.apache.org>
Subject: [jira] [Created] (DRILL-5856)  invariant violated: conversion
 result not null when aggregate used in a PARTITION
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
archived-at: Sun, 08 Oct 2017 18:49:09 -0000

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)