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

Support non-scalar data types enum, set, json

    XMLWordPrintable

Details

    • New Feature
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Duplicate
    • None
    • N/A
    • N/A
    • None
    • Server version: 10.5.5-MariaDB MariaDB Server
      Columnstore: 1.5.4-1

    Description

      At present Columnstore doesn't support non-scalar data types like enum, set, json.

      CREATE TABLE t_enum(col ENUM('min','max','avg'))ENGINE=Columnstore;
      ERROR 1178 (42000): The storage engine for the table doesn't support The syntax or the data type(s) is not supported by Columnstore.

      CREATE TABLE t_set(col SET('x','y','z'))ENGINE=Columnstore;
      ERROR 1178 (42000): The storage engine for the table doesn't support The syntax or the data type(s) is not supported by Columnstore.

      CREATE TABLE t_json(col JSON)ENGINE=Columnstore;
      ERROR 1178 (42000): The storage engine for the table doesn't support The syntax or the data type(s) is not supported by Columnstore.

      Like Innodb we should support the above data types.

      Attachments

        Issue Links

          Activity

            People

              toddstoffel Todd Stoffel (Inactive)
              susil.behera susil.behera
              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.