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

JSON_ARRAYAGG join failing

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

          duplicates

          New Feature - A new feature of the product, which has yet to be developed. MCOL-5227 Implement JSON_ARRAYAGG

          • Major - Major loss of function.
          • Closed
          is duplicated by

          New Feature - A new feature of the product, which has yet to be developed. MCOL-5227 Implement JSON_ARRAYAGG

          • Major - Major loss of function.
          • Closed

          Activity

            Transition Time In Source Status Execution Times
            alexey vorovich (Inactive) made transition -
            Open In Progress
            		8d 4h 34m 1
            Andrey Piskunov (Inactive) made transition -
            In Progress In Review
            		34d 23h 51m 1
            alexey vorovich (Inactive) made transition -
            In Review Closed
            		19m 29s 1

            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.