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

JSON_ARRAYAGG join failing

    XMLWordPrintable

    Details

    • Type: New Feature
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 6.4.1
    • Fix Version/s: 23.02
    • Component/s: ExeMgr, PrimProc
    • Labels:
      None
    • Environment:
      centos Column store single instance
    • Sprint:
      2021-17, 2022-22

      Description

      Hi

      customer complain and report that this query fail:

       
       
       
       
      MariaDB [dmc_dg_ita_199]> SELECT
      -> ma_id, ma_desc, JSON_ARRAYAGG(DISTINCT cwc_na_id) ma_nas, JSON_ARRAYAGG(DISTINCT cwc_pd_id) ma_pds FROM
      -> (SELECT DISTINCT cwc_ma_id, cwc_na_id, cwc_pd_id FROM dmc_dg_ita_199.campagna_web_codice) CWC JOIN qcommon.marca ON ma_id = cwc_ma_id
      -> GROUP BY ma_id, ma_desc;
      
      

      with the follow errors:

      ERROR 1178 (42000): The storage engine for the table doesn't support Non supported aggregate type on the select clause

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Andrey Andrey Piskunov
              Reporter:
              massimo.disaro Massimo
              Assigned for Review:
              Roman Roman
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.