columnstore - creating columnar tables in memsql -

im interested in studying columnar store in memsql. im trying create columnar tables. query used is,

create table students (     stud_id int,     stud_group int,     joining_date datetime,     key (`stud_group`) using clustered columnstore     );

but query throws me error @ clustered columnstore. don't know leads error.

the reason comma after columnstore. should be

create table students (     stud_id int,     stud_group int,     joining_date datetime,     key (`stud_group`) using clustered columnstore     );

update: apparently not. reason can happen if using old version of memsql (before 4.0).

to see version of memsql, run select @@memsql_version.

JVParth