Apache Doris 中文技术论坛
Questions Tags Users Badges

官网示例 amazon_reviews 增加索引字段查询没效果,也没有走索引是啥原因啊

Asked Nov 14, 2024 Modified Jan 1, 0001
Viewed 39
2.1

80e869d93ae07b1f39c7af9b1a2944d.png
查询:SELECT
product_id,
any(product_title),
AVG(star_rating) AS rating,
COUNT() AS count
FROM
amazon_reviews
WHERE
review_body LIKE '%is super awesome%'
GROUP BY
product_id
ORDER BY
count DESC,
rating DESC,
product_id
LIMIT 5;

Total: 4s435ms

索引也没有过滤到条数

edited Jan 1, 0001
guanyuaxin3
asked Nov 14, 2024
1 Answers

【问题状态】跟进中
【问题处理】定位中,有进展会更新到论坛

edited Jan 1, 1970
徐振超@SelectDB8111
answered Nov 14, 2024
Related Questions
AUTO LIST PARTITION 分区名长度为何限制 50?能否配置放宽/取消?
doris2.1.11重复建表报错内容异常,不会提示表已经存在
1 answers
我们通过hive catalog外表同步数据,有时候hive表会很大导致内存占满了会杀掉其他任务,限制内存又会导致同步任务失败,有什么方法可以稳定一下呢,同步效率慢一点什么的也没问题
1 answers
doris be启动报错
2 answers
Doris的json解析问题
1 answers
使用docker-compose配置doris FE启动成功 但BE启动失败
1 answers

Terms of service Privacy policy

Powered by Answer - the open-source software that powers Q&A communities.
Made with love © 2026 Apache Doris 中文技术论坛.