We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
2.0.13
我是用以下创建了一个倒排索引 logData TEXT NULL COMMENT '日志原文', INDEX idx_name1 (logData) USING INVERTED PROPERTIES("parser" = "english", "lower_case" = "true") COMMENT '日志原文倒排索引'
logData
logData 字段 存储的数据结构为json类型的字符串。 例: "{"ip": "127.0.0.1"}" 表的分区字段为 date 。按天分区 使用以下sql片段查询 where p_date='2024-12-01' and logData MATCH_ANY "127 0 0 1" 经测试,以上功能正常
在线上运行一段时间后,概率出现一个分区,不能通过倒排索引查询到数据的问题 例: 分区p20241201 通过 where p_date='2024-12-01' and logData MATCH_ANY "127 0 0 1" 可以查询到数据 分区p20241202 通过 where p_date='2024-12-02' and logData MATCH_ANY "127 0 0 1" 不能查询到数据 分区p20241203 通过 where p_date='2024-12-03' and logData MATCH_ANY "127 0 0 1" 可以查询到数据
以上问题,通过 DROP INDEX idx_name ON table_name; 并重新创建索引后,分区p20241202 可以正常使用
是否有方法查询每个分区 倒排索引 的状态或者其他详细信息? 目前有没有调查方案或者解决方案
No response
The text was updated successfully, but these errors were encountered:
you can use this way to check index status https://doris.apache.org/docs/sql-manual/sql-statements/table-and-view/index/SHOW-BUILD-INDEX
Sorry, something went wrong.
No branches or pull requests
Search before asking
Version
2.0.13
What's Wrong?
我是用以下创建了一个倒排索引
logData
TEXT NULL COMMENT '日志原文',INDEX idx_name1 (
logData
) USING INVERTED PROPERTIES("parser" = "english", "lower_case" = "true") COMMENT '日志原文倒排索引'logData 字段 存储的数据结构为json类型的字符串。 例: "{"ip": "127.0.0.1"}"
表的分区字段为 date 。按天分区
使用以下sql片段查询
where p_date='2024-12-01' and logData MATCH_ANY "127 0 0 1"
经测试,以上功能正常
在线上运行一段时间后,概率出现一个分区,不能通过倒排索引查询到数据的问题
例:
分区p20241201 通过 where p_date='2024-12-01' and logData MATCH_ANY "127 0 0 1" 可以查询到数据
分区p20241202 通过 where p_date='2024-12-02' and logData MATCH_ANY "127 0 0 1" 不能查询到数据
分区p20241203 通过 where p_date='2024-12-03' and logData MATCH_ANY "127 0 0 1" 可以查询到数据
以上问题,通过 DROP INDEX idx_name ON table_name; 并重新创建索引后,分区p20241202 可以正常使用
What You Expected?
是否有方法查询每个分区 倒排索引 的状态或者其他详细信息?
目前有没有调查方案或者解决方案
How to Reproduce?
No response
Anything Else?
No response
Are you willing to submit PR?
Code of Conduct
The text was updated successfully, but these errors were encountered: