logstash filter logs are output to manticore search, but cannot be queried

[WellYixuanDu]

hello, I have a question about manticore's query.
I ran the configuration file of logstash, and then generated a table.
The configuration is below.

input {
    file {
        path => ["/data/task_code/search/demo.log"]
        start_position => "beginning"
        sincedb_path => "/dev/null"
        mode => "read"
        exit_after_read => "true"
        file_completed_action => "log"
        file_completed_log_path => "/dev/null"
    }

}

filter {
  # 使用 grok 过滤器解析日志
  grok {
    match => {
      "message" => "%{TIMESTAMP_ISO8601:logtime}\s+\[%{LOGLEVEL:loglevel}\]\s+%{DATA:logid}\s+%{DATA:method}\s+%{GREEDYDATA:msg}"
    }
  }
}

output {
    elasticsearch {
        index => "test_log6"
        hosts => ["http://localhost:9308"]
        ilm_enabled => false
        manage_template => false
    }
}

And the table is as follows.

mysql> DESCRIBE test_log6;
+------------+--------+----------------+
| Field      | Type   | Properties     |
+------------+--------+----------------+
| id         | bigint |                |
| path       | text   | indexed stored |
| logtime    | text   | indexed stored |
| logid      | text   | indexed stored |
| msg        | text   | indexed stored |
| method     | text   | indexed stored |
| host       | text   | indexed stored |
| message    | text   | indexed stored |
| @version   | text   | indexed stored |
| @timestamp | text   | indexed stored |
| loglevel   | text   | indexed stored |
+------------+--------+----------------+
11 rows in set (0.00 sec)

But I can't query from it.

mysql> select * from test_log6 where logid = 'logid:000';
ERROR 1064 (42000): index test_log6: unsupported column 'logid' (stored field, NOT attribute)

Can you tell me what went wrong, what configuration needs to be modified or other problems, how to solve it?
If it is convenient, please give me an example, I will be very grateful

[tomatolog]

you could create table with string attributes instead of autoschema creates and use filtering for these

For now autochema create full-text fields for incoming string data and you could use full text search there

select * from test_log6 where MATCH (' ( @logid logid:000 ) ')