You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by GitBox <gi...@apache.org> on 2022/10/26 01:55:17 UTC
[GitHub] [doris] stitch-k opened a new issue, #13666: [Feature] SUBSTRING_INDEX() 不支持且无替换方案
stitch-k opened a new issue, #13666:
URL: https://github.com/apache/doris/issues/13666
### Search before asking
- [X] I had searched in the [issues](https://github.com/apache/incubator-doris/issues?q=is%3Aissue) and found no similar issues.
### Description
SUBSTRING_INDEX() 不支持且无替换方案
### Use case
_No response_
### Related issues
_No response_
### Are you willing to submit PR?
- [ ] 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
[GitHub] [doris] wwek commented on issue #13666: [Feature] SUBSTRING_INDEX() 不支持且无替换方案
Posted by GitBox <gi...@apache.org>.
wwek commented on issue #13666:
URL: https://github.com/apache/doris/issues/13666#issuecomment-1292891847
SUBSTRING_INDEX() 是另外一个需求了，这个后面也可以支持下。
和MySQL中的等效实现，这样让用户平滑迁移
--
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
[GitHub] [doris] wwek commented on issue #13666: [Feature] SUBSTRING_INDEX() 不支持且无替换方案
Posted by GitBox <gi...@apache.org>.
wwek commented on issue #13666:
URL: https://github.com/apache/doris/issues/13666#issuecomment-1292886841
> 也就是split_part支持倒取就满足需求了？
split_part 如果支持了用负数就行倒取字段是可以满足我的需求的。相关issue已提
https://github.com/apache/doris/issues/13712
--
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
[GitHub] [doris] Gabriel39 closed issue #13666: [Feature] SUBSTRING_INDEX() 不支持且无替换方案
Posted by GitBox <gi...@apache.org>.
Gabriel39 closed issue #13666: [Feature] SUBSTRING_INDEX() 不支持且无替换方案
URL: https://github.com/apache/doris/issues/13666
--
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
[GitHub] [doris] wwek commented on issue #13666: [Feature] SUBSTRING_INDEX() 不支持且无替换方案
Posted by GitBox <gi...@apache.org>.
wwek commented on issue #13666:
URL: https://github.com/apache/doris/issues/13666#issuecomment-1292874686
>
这个只支持正取，不支持倒取
也就是MySQL中 SUBSTRING_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
[GitHub] [doris] LOVEGISER commented on issue #13666: [Feature] SUBSTRING_INDEX() 不支持且无替换方案
Posted by GitBox <gi...@apache.org>.
LOVEGISER commented on issue #13666:
URL: https://github.com/apache/doris/issues/13666#issuecomment-1292870444
1. use split("hello world", " "); return:["hello", "world"]
2.use array_slice(["hello", "world"], 1, 1)
--
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
[GitHub] [doris] dataalive commented on issue #13666: [Feature] SUBSTRING_INDEX() 不支持且无替换方案
Posted by GitBox <gi...@apache.org>.
dataalive commented on issue #13666:
URL: https://github.com/apache/doris/issues/13666#issuecomment-1291570156
https://doris.apache.org/docs/dev/sql-manual/sql-functions/string-functions/split_part is close to your needs.
--
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
[GitHub] [doris] LOVEGISER commented on issue #13666: [Feature] SUBSTRING_INDEX() 不支持且无替换方案
Posted by GitBox <gi...@apache.org>.
LOVEGISER commented on issue #13666:
URL: https://github.com/apache/doris/issues/13666#issuecomment-1292876742
也就是split_part支持倒取就满足需求了？
--
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
[GitHub] [doris] LOVEGISER commented on issue #13666: [Feature] SUBSTRING_INDEX() 不支持且无替换方案
Posted by GitBox <gi...@apache.org>.
LOVEGISER commented on issue #13666:
URL: https://github.com/apache/doris/issues/13666#issuecomment-1292876331
你的需求是不是返回一个数据就行，但是要支持正取和倒取？
--
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