How to enable column storage in docker deployment?

[donbing007]

The mirror used is "manticoresearch/manticore:5.0.2"

mysql> SHOW GLOBAL VARIABLES;
+--------------------------+-----------+
| Variable_name            | Value     |
+--------------------------+-----------+
| autocommit               | 1         |
| auto_optimize            | 1         |
| optimize_cutoff          | 24        |
| collation_connection     | libc_ci   |
| query_log_format         | sphinxql  |
| session_read_only        | 0         |
| log_level                | info      |
| max_allowed_packet       | 134217728 |
| character_set_client     | utf8      |
| character_set_connection | utf8      |
| grouping_in_utc          | 0         |
| last_insert_id           |           |
| pseudo_sharding          | 1         |
| secondary_indexes        | 1         |
+--------------------------+-----------+

An error occurs when I want to create an index using column storage.

mysql> create table oqsindex2
    -> (
    ->     attrf        text indexed,
    ->     entityclassf text indexed,
    ->     tx           bigint,
    ->     commitid     bigint engine='columnar',
    ->     createtime   bigint engine='columnar',
    ->     updatetime   bigint engine='columnar',
    ->     maintainid   bigint,
    ->     oqsmajor     int,
    ->     attr         json
    -> ) engine='rowwise' charset_table='non_cjk,cjk' rt_mem_limit='1024m';
ERROR 1064 (42000): error adding index 'oqsindex2': columnar library not loaded

What else do I need to do to open the secondary index?

[sanikolaev]

As said in the docs you just need to use env. var. MCL=1 :

snikolaev@dev:~$ docker run -e MCL=1 --name manticore --rm -d manticoresearch/manticore:5.0.2-extra2 && sleep 3 && docker exec -it manticore mysql && docker stop manticore
3636836189f5a6005742438fa473ddb4e48b3e1d42cc1f9f7eaf6231bc837184
mysql> show status like 'version';
+---------+-----------------------------------------------------------------------------------------------+
| Counter | Value                                                                                         |
+---------+-----------------------------------------------------------------------------------------------+
| version | 5.0.2 348514c86@220530 dev (columnar 1.15.4 2fef34e@220522) (secondary 1.15.4 2fef34e@220522) |
+---------+-----------------------------------------------------------------------------------------------+
mysql> create table oqsindex2
    ->      (
    ->          attrf        text indexed,
    ->          entityclassf text indexed,
    ->          tx           bigint,
    ->          commitid     bigint engine='columnar',
    ->          createtime   bigint engine='columnar',
    ->          updatetime   bigint engine='columnar',
    ->          maintainid   bigint,
    ->          oqsmajor     int,
    ->          attr         json
    ->      ) engine='rowwise' charset_table='non_cjk,cjk' rt_mem_limit='1024m';
mysql> desc oqsindex2;
+--------------+--------+---------------------+
| Field        | Type   | Properties          |
+--------------+--------+---------------------+
| id           | bigint |                     |
| attrf        | text   | indexed             |
| entityclassf | text   | indexed             |
| oqsmajor     | uint   |                     |
| tx           | bigint |                     |
| commitid     | bigint | columnar fast_fetch |
| createtime   | bigint | columnar fast_fetch |
| updatetime   | bigint | columnar fast_fetch |
| maintainid   | bigint |                     |
| attr         | json   |                     |
+--------------+--------+---------------------+

The latest release tag is 5.0.2-extra2 (https://github.com/manticoresoftware/docker/releases/tag/5.0.2-extra2). Just 5.0.2 doesn't support that yet.

[donbing007]

Thank you.