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

Remove row size limitation of 65535

    XMLWordPrintable

Details

    • New Feature
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Fixed
    • None
    • 1.1.0
    • MDB Plugin
    • None

    Description

      Copied from the thread:
      https://mariadb.com/kb/en/mariadb/mariadb-columnstore-can-we-extend-the-max-length-of-the-data-types-varchar-/

      I think my use case is very common. We have a 1500 columns table where each row stores all the data of a single transaction. In order to create the table in the columnstore engine, we kept getting the error: "Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535"

      The row size (and max number of columns of 4096) is a limit enforced by the mariadb server derived from the original mysql code base.

      Two options:
      1. Remove the row size limitation of 65535 so that we can create more columns to accommodate the content of Text/Blob data type. Frankly, I don't like this option for I have to split the content before inserting and concatenate them together before returning results.
      2. Set high priority of supporting Text (MCOL-267) and Blob (MCOL-356) data types.

      I set this issue as major priority for it will impact on the marketing of MariaDB ColumnStore. Thanks for your great support.

      Attachments

        Activity

          People

            LinuxJedi Andrew Hutchings (Inactive)
            zengchun Zeng Chun
            Votes:
            1 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.