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

JSON_ARRAYAGG join failing

    XMLWordPrintable

Details

    • New Feature
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 6.4.1
    • 22.08.8
    • ExeMgr, PrimProc
    • None
    • centos Column store single instance
    • 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

              Andrey Andrey Piskunov (Inactive)
              massimo.disaro Massimo
              Roman Roman
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.