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

create table ..select * from table...

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Not a Bug
    • Affects Version/s: 1.5.3
    • Fix Version/s: N/A
    • Component/s: N/A
    • Labels:
      None

      Description

      MariaDB 10.5.5 single server.

      create table t2 engine=columnstore... select * from t1

      (regardless if t1 is innodb or columnstore)

      is still slow.

      100 rows / 80 columns in my tests take 8 minutes.
      The same with t2 as innodb take a couple of seconds.

      This is linear.

      200 rows / 80 columns rows take 16 minutes.

      199 row / 40 columns take 4 minutes.

      Innodb on the same machine take 4 seconds.

      A testcase with testdata is attached (p1.sql)

        Attachments

          Activity

            People

            Assignee:
            toddstoffel Todd Stoffel
            Reporter:
            Richard Richard Stracke
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.