Search code examples
singlestorecolumnstore

creating columnar tables in memsql

Im interested in studying columnar store in memsql. Im trying to create columnar tables. The query I used is,

CREATE TABLE students (
    stud_id INT,
    stud_group INT,
    joining_date DATETIME,
    KEY (`stud_group`) USING CLUSTERED COLUMNSTORE
    );

But the query throws me error at clustered columnstore. I don't know what leads to this error.

Solution

  • The reason is the comma after COLUMNSTORE. It should be

    CREATE TABLE students (
    stud_id INT,
    stud_group INT,
    joining_date DATETIME,
    KEY (`stud_group`) USING CLUSTERED COLUMNSTORE
    );

    UPDATE: apparently not. Then the only reason it can happen is if you are using old version of MemSQL (before 4.0).

    To see the version of MemSQL, run SELECT @@memsql_version.