Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-1463

Columnstore provided udf median()/avg_mode() not working

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • 1.1.4
    • 1.1.5
    • ExeMgr
    • None
    • Debian
    • 2018-12

    Description

      Enabled median udf provided on article:
      https://mariadb.com/kb/en/library/columnstore-user-defined-aggregate-and-window-functions/

      But mostly 90% of the time that error appears when calling a query with median:

      Error Code: 1815. Internal error: prep2PhasesAggregate: A UDAF function is called but there's no UDAFColumn

      Query is kinda simple:

      SELECT v1, median(v2) as a FROM testtable
      group by v1;

      Attachments

        Activity

          People

            David.Hall David Hall (Inactive)
            DanielW Dalu (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.