How do you change a column from NULL to NOT NULL in memSQL.
I have created the table as below.
create table t_tinyint1(c TINYINT,c2 VARCHAR(100), key() USING CLUSTERED COLUMNSTORE);
Trying to alter but no luck
ALTER TABLE t_tinyint1 modify c2 VARCHAR(100) not null ;
Facing the below error.
SQL Error  [HY000]: This version of MemSQL cannot perform an offline ALTER TABLE on a COLUMN STORE table. The requested ALTER TABLE cannot be performed online because it modifies column
c2 from NULL to NOT NULL.