Like Innodb engine, we should support for SELECT <col> <operator> <value>.

MariaDB [mysql]> CREATE TABLE t1(i INT) ENGINE=Columnstore;
Query OK, 0 rows affected (0.128 sec)

MariaDB [mysql]> INSERT INTO t1 VALUES(1),(2);
Query OK, 2 rows affected (0.324 sec)
Records: 2 Duplicates: 0 Warnings: 0

MariaDB [mysql]> SELECT i = 10 FROM t1;
ERROR 1178 (42000): The storage engine for the table doesn't support IDB-1001: Function '=' isn't supported.

MariaDB [mysql]> SELECT i < 10 FROM t1;
ERROR 1178 (42000): The storage engine for the table doesn't support IDB-1001: Function '<' isn't supported.