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

DDL for creation of a new table in columnstore produces syntax error when it runs on columnstore

    XMLWordPrintable

    Details

    • Sprint:
      2018-17, 2018-18, 2018-19, 2018-20, 2018-21

      Description

      1. Create a new table in TX:

      CREATE TABLE `test` (
        `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
        `col` varchar(100) DEFAULT NULL,
        UNIQUE KEY `id` (`id`)
      ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
      

      2. Run
      mxs_adapter -c /etc/Columnstore.xml -u cdcuser -p cdcpassword -h localhost -P 4001 cdc_eli test

      Result:
      Table was not found in Columnstore. A DDL statement is suggested to create a respective table in Columnstore. The DDL contains syntax error:

      CREATE TABLE cdc_eli.test (col varchar(100), domain int, event_number int, event_type varchar(50), id serial, sequence int, server_id int, timestamp int) ENGINE=ColumnStore;
      

      Error is:
      Error Code: 1069. Too many keys specified; max 0 keys allowed

      Problem is in id serial. Columnstore doesn't support this.

        Attachments

          Activity

            People

            Assignee:
            winstone Zdravelina Sokolovska (Inactive)
            Reporter:
            elena.kotsinova Elena Kotsinova
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Git Integration