apache / doris

Apache Doris is an easy-to-use, high performance and unified analytics database.
https://doris.apache.org
Apache License 2.0
12.4k stars 3.22k forks source link

[Bug] MATCH_PHRASE query failed #21299

Open zhuzhihao94 opened 1 year ago

zhuzhihao94 commented 1 year ago

Search before asking

Version

doris-2.0.0-alpha1

What's Wrong?

MATCH_PHRASE query failed

What You Expected?

MATCH_PHRASE query ok

How to Reproduce?

  1. create table CREATE TABLE hackernews_5 ( id BIGINT, msg String, agent_ip String, INDEX idx_agent_ip (agent_ip) USING INVERTED PROPERTIES("parser" = "chinese", "parser_mode" = "fine_grained", "support_phrase" = "true") COMMENT 'inverted index for comment' ) DUPLICATE KEY(id) DISTRIBUTED BY HASH(id) BUCKETS 1 PROPERTIES ("replication_num" = "1");

  2. write record insert into hackernews_5 values (1,'hello','C:\Windows\Microsoft.NET\Framework64\v4.0.30319\ngentask.exe');

3.query sql select * from hackernews_5 where agent_ip MATCH_PHRASE 'ngentask exe';

  1. error reponse [HY000][1105] errCode = 2, detailMessage = (10.106.40.81)[INTERNAL_ERROR]failed to initialize storage reader. tablet=38468.1719095337.d64e80c20e11f3a2-768709744c2baca5, res=[E-6001], backend=10.106.40.81

image

Anything Else?

No response

Are you willing to submit PR?

Code of Conduct

yuanyuan8983 commented 1 year ago

This issue has been fixed in 2.0-beta, it is recommended to test 2.0-beta.

zhuzhihao94 commented 1 year ago

I upgrade to 2.0-beta, MATCH_PHRASE is ok; but MATCH_ALL query results are incorrect, eg: result not contain flink image

powerLambda commented 1 year ago

I get same issue in v1.2.5, do you have a plan to backport early release?