My query got an error: "Feature 'FOR UPDATE on a columnstore table' is not supported by SingleStore"

Help Procedural SQL
1

Hello, I’m a newbie to memsql. I have created the following table:

CREATE TABLE people (
people_id bigint(11) NOT NULL,
people_idf blob DEFAULT NULL,
KEY id (people_id) USING HASH,
KEY __UNORDERED () USING CLUSTERED COLUMNSTORE
, SHARD KEY ()
) AUTOSTATS_CARDINALITY_MODE=INCREMENTAL AUTOSTATS_HISTOGRAM_MODE=CREATE AUTOSTATS_SAMPLING=ON SQL_MODE=‘STRICT_ALL_TABLES’

And when I run this SQL query: “SELECT people_id FROM people FOR UPDATE”, I have got an error:
ERROR 1706 ER_MEMSQL_FEATURE_LOCKDOWN: Leaf Error (127.0.0.1:3307): Feature ‘FOR UPDATE on a columnstore table’ is not supported by SingleStore.
My SingleStore DB Version is 7.5.6
Please let me know what this error is and how can I fix it
Thanks a lot!

2

Hi,

As of Singlestore 7.5 all tables are columnstore by default. You need to use CREATE ROWSTORE TABLE (..) to get a rowstore table. We don’t support FOR UPDATE on columnstore yet, so you’ll need to switch to rowstore to be able to run the query ( CREATE ROWSTORE TABLE people …).

Keep in mind rowstore tables are stored in-memory.

-Adam