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

Implement DISTRIBUTED JSON functions



    • Type: New Feature
    • Status: Open (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 1.1.0
    • Fix Version/s: Icebox
    • Component/s: ExeMgr
    • Labels:


      As of 6.2.2 Columnstore doesn't support [1] JSON_* functions doing Select Handler execution.

      We want to add support for the mentioned JSON_* functions into the existing functions and expressions runtime framework(FuncExp).
      Here are the phases for the project:

      1. - get familiar with the code base, compilation and bootstrap process [2]
      2. - split the list of JSON_* functions into those suitable for distributed Select Handler execution and those aren't
      3. - get familiar with FuncExp details [3]
      4. - get familiar with MTR testing framework MCS [4] leverages
      5. - implement/borrow tests from MDB MTR test suite
      6. - implement suitable(see phase 2) JSON_* functions

      There will be an additional simple task to add JSON data type as an alias for LONGTEXT(flex/bison parser tiny project).

      Plz get in touch either here or in MariaDB Zulip chat

      1. There are two query execution modes in MCS: fast distributed Select Handler execution and relatively slow but MDB-compatable Table execution.
      2. Here is the automated bootstrap script.
      3. FuncExp is a number of classes to describe an arbitrary tree of expressions doing projection, e.g. SELECT COS(c1 + c2) or doing filtering, e.g. SELECT c1 from t1 WHERE LENGTH(SUBSTRING(c1,2,2)) > 5. In most cases the implementation of a function looks as simple as this. An abstract part for FuncExp can be found in the MCS repo here.
      4. Plz see this for the short info.


          Issue Links



              David.Hall David Hall
              dleeyh Daniel Lee
              1 Vote for this issue
              8 Start watching this issue



                  Git Integration

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