Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-5856

invariant violated: conversion result not null when aggregate used in a PARTITION

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Major
    • Resolution: Unresolved
    • 1.10.0
    • None
    • SQL Parser
    • 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`

      Attachments

        Activity

          People

            Unassigned Unassigned
            the6campbells N Campbell
            Votes:
            1 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated: