[Bug] key column with inverted index failed to do match query

[Tanya-W]

Search before asking

• I had searched in the issues and found no similar issues.

Version

master

What's Wrong?

key column with inverted index failed to do match query.

• query error:
  // ATTN: triggered when select *, and table has complex data types, such as array, map, and struct

mysql> SELECT * FROM test_index WHERE user MATCH_ANY 'u1, u2' LIMIT 10;
ERROR 1105 (HY000): errCode = 2, detailMessage = (10.16.10.7)[INTERNAL_ERROR]failed to initialize storage reader. tablet=10439.502700833.f54283d1043937ea-503fd12bee7b3ea4, res=[NOT_IMPLEMENTED_ERROR]
    @     0x5581abb9b214  doris::Status::Error<>()
    @     0x5581ad6ccc63  doris::ArrayTypeInfo::from_string()
    @     0x5581ad06949e  doris::Field::from_string()
    @     0x5581ad0a33d7  doris::RowCursor::from_tuple()
    @     0x5581abcee332  doris::TabletReader::_init_keys_param()
    @     0x5581abcec061  doris::TabletRe

What You Expected?

key column with inverted index can do match query when select *

How to Reproduce?

• create table:

CREATE TABLE `test_index` (
  `user` varchar(500) NULL,
  `followers` array<text> NULL,
  INDEX index_user (`user`) USING INVERTED PROPERTIES("parser" = "english") COMMENT '',
  INDEX index_followers (`followers`) USING INVERTED PROPERTIES("parser" = "english") COMMENT ''
) ENGINE=OLAP
DUPLICATE KEY(`user`)
COMMENT 'OLAP'
DISTRIBUTED BY HASH(`user`) BUCKETS 1
PROPERTIES (
"replication_allocation" = "tag.location.default: 1",
"in_memory" = "false",
"storage_format" = "V2",
"light_schema_change" = "true",
"disable_auto_compaction" = "false"
);

• insert data:

INSERT INTO test_index (user, followers) VALUES ("u1", ["u2","u3"]);
INSERT INTO test_index (user, followers) VALUES ("u2", ["u1","u3","u4"]);
INSERT INTO test_index (user, followers) VALUES ("u3", ["u1"]);
INSERT INTO test_index (user, followers) VALUES ("u4", ["u3"]);

• query:
  // ATTN: triggered when select *

mysql> SELECT * FROM test_index WHERE user MATCH_ANY 'u1, u2' LIMIT 10;

Anything Else?

No response

Are you willing to submit PR?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct