mchangtian opened a new issue, #3264:
URL: https://github.com/apache/doris-website/issues/3264
I am using Doris' FULLTEXT search feature with `MATCH_ANY`, and follow the
official example to retrieve relevance scores via `score()` function. The basic
search works fine, but I cannot filter out records with low relevance
scores—any attempt triggers a syntax error about `score()` being restricted to
SELECT clause only.
I want to ask:
1. Does Doris support filtering low relevance score results for FULLTEXT
search?
2. If yes, what is the correct SQL syntax (based on the official demo below)?
3. If not, is there an alternative approach (without heavy performance cost
like temporary tables)?
# Environment Information
- Doris Version: [Output of `SELECT VERSION();` 4.0.1]
I tried to filter records with relevance > 5 using the following SQL
(ensuring score() is only in SELECT clause of subquery):
```
SELECT a.* FROM (
SELECT *, score() AS relevance
FROM search_demo
WHERE content MATCH_ANY '检索测试'
) a WHERE a.relevance > 5 ORDER BY a.relevance DESC LIMIT 10;
```
Exact Error Message Encountered
```
SQL 错误 [1105] [HY000]: errCode = 2, detailMessage = score() function can
only be used in SELECT clause, not in WHERE clause
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
