You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "cst4049 (via GitHub)" <gi...@apache.org> on 2024/01/11 08:51:04 UTC

[I] [Bug] doris倒排索引数据大部分都是uuid类型时, 在上亿数据时性能居然比like还要低 [doris]

cst4049 opened a new issue, #29863:
URL: https://github.com/apache/doris/issues/29863

   ### Search before asking
   
   - [X] I had searched in the [issues](https://github.com/apache/doris/issues?q=is%3Aissue) and found no similar issues.
   
   
   ### Version
   
   2.0.3
   
   ### What's Wrong?
   
   遇到一个文本类型, 其中数据大多是uuid,  数据量大时, 性能比like还要慢。 
   1亿条数据时, like 40几秒返回数据, match_any 居然得要2分钟
   
   ### What You Expected?
   
   性能优化
   
   ### How to Reproduce?
   
   _No response_
   
   ### Anything Else?
   
   _No response_
   
   ### Are you willing to submit PR?
   
   - [X] Yes I am willing to submit a PR!
   
   ### Code of Conduct
   
   - [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct)
   


-- 
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: commits-unsubscribe@doris.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [I] [Bug] doris倒排索引数据大部分都是uuid类型时, 在上亿数据时性能居然比like还要低 [doris]

Posted by "airborne12 (via GitHub)" <gi...@apache.org>.
airborne12 commented on issue #29863:
URL: https://github.com/apache/doris/issues/29863#issuecomment-2144234099

   @cst4049 any update here?


-- 
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: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [I] [Bug] doris倒排索引数据大部分都是uuid类型时, 在上亿数据时性能居然比like还要低 [doris]

Posted by "ihadoop (via GitHub)" <gi...@apache.org>.
ihadoop commented on issue #29863:
URL: https://github.com/apache/doris/issues/29863#issuecomment-1894971404

   文本是中文吗?如果是 parser="unicode" 应该换成Chinese


-- 
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: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [I] [Bug] doris倒排索引数据大部分都是uuid类型时, 在上亿数据时性能居然比like还要低 [doris]

Posted by "airborne12 (via GitHub)" <gi...@apache.org>.
airborne12 commented on issue #29863:
URL: https://github.com/apache/doris/issues/29863#issuecomment-2144235803

   If we use a UUID string, using a parser is not a good option. Using Unicode is an even worse option. Simply add an index, like USING INVERTED.


-- 
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: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [I] [Bug] doris倒排索引数据大部分都是uuid类型时, 在上亿数据时性能居然比like还要低 [doris]

Posted by "morningman (via GitHub)" <gi...@apache.org>.
morningman closed issue #29863: [Bug] doris倒排索引数据大部分都是uuid类型时, 在上亿数据时性能居然比like还要低
URL: https://github.com/apache/doris/issues/29863


-- 
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: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [I] [Bug] doris倒排索引数据大部分都是uuid类型时, 在上亿数据时性能居然比like还要低 [doris]

Posted by "cst4049 (via GitHub)" <gi...@apache.org>.
cst4049 commented on issue #29863:
URL: https://github.com/apache/doris/issues/29863#issuecomment-1893032719

   > pls show your table schema,probably it may not query with inverted index
   
   ![image](https://github.com/apache/doris/assets/16145670/e4c1aea7-26ea-4bd5-b8c1-4aad8a6eeba8)
   


-- 
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: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [I] [Bug] doris倒排索引数据大部分都是uuid类型时, 在上亿数据时性能居然比like还要低 [doris]

Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #29863:
URL: https://github.com/apache/doris/issues/29863#issuecomment-3287227536

   We're closing this issue because it hasn't been updated in a while.
   If you'd like to revive this issue, please reopen it and feel free a maintainer to remove the Stale tag!


-- 
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: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [I] [Bug] doris倒排索引数据大部分都是uuid类型时, 在上亿数据时性能居然比like还要低 [doris]

Posted by "cst4049 (via GitHub)" <gi...@apache.org>.
cst4049 commented on issue #29863:
URL: https://github.com/apache/doris/issues/29863#issuecomment-1891201123

   ![image](https://github.com/apache/doris/assets/16145670/ba2e730b-e3ee-4408-83cc-cd76b3722887)
   


-- 
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: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [I] [Bug] doris倒排索引数据大部分都是uuid类型时, 在上亿数据时性能居然比like还要低 [doris]

Posted by "airborne12 (via GitHub)" <gi...@apache.org>.
airborne12 commented on issue #29863:
URL: https://github.com/apache/doris/issues/29863#issuecomment-1890223768

   pls show your table schema,probably it may not query with inverted index


-- 
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: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org