You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "amorynan (via GitHub)" <gi...@apache.org> on 2023/06/28 02:23:13 UTC
[GitHub] [doris] amorynan opened a new issue, #21268: [Enhancement] Improve Json function for doris
amorynan opened a new issue, #21268:
URL: https://github.com/apache/doris/issues/21268
### Search before asking
- [X] I had searched in the [issues](https://github.com/apache/doris/issues?q=is%3Aissue) and found no similar issues.
### Description
Now We have some json functions are not implement , specific semantics for each functions below here can reference mysql
- [ ] -> ([->](https://dev.mysql.com/doc/refman/8.0/en/json-search-functions.html#operator_json-column-path))
->> ([->>](https://dev.mysql.com/doc/refman/8.0/en/json-search-functions.html#operator_json-inline-path))
- [ ] JSON_DEPTH ([JSON_DEPTH()](https://dev.mysql.com/doc/refman/8.0/en/json-attribute-functions.html#function_json-depth))
- [ ] JSON_LENGTH ([JSON_LENGTH()](https://dev.mysql.com/doc/refman/8.0/en/json-attribute-functions.html#function_json-length))
- [ ] JSON_KEYS ([JSON_KEYS()](https://dev.mysql.com/doc/refman/8.0/en/json-search-functions.html#function_json-keys))
- [ ] JSON_SEARCH ([JSON_SEARCH()](https://dev.mysql.com/doc/refman/8.0/en/json-search-functions.html#function_json-search))
- [ ] MERGE_OF ([MEMBER OF()](https://dev.mysql.com/doc/refman/8.0/en/json-search-functions.html#operator_member-of))
- [ ] JSON_INSERT ([JSON_INSERT()](https://dev.mysql.com/doc/refman/8.0/en/json-modification-functions.html#function_json-insert))
- [ ] JSON_REPLACE ([JSON_REPLACE()](https://dev.mysql.com/doc/refman/8.0/en/json-modification-functions.html#function_json-replace))
- [ ] JSON_SET ([JSON_SET()](https://dev.mysql.com/doc/refman/8.0/en/json-modification-functions.html#function_json-set))
- [ ] JSON_OVERLAPS ([JSON_OVERLAPS()](https://dev.mysql.com/doc/refman/8.0/en/json-search-functions.html#function_json-overlaps))
- [ ] JSON_MERGE_PATCH ([JSON_MERGE_PATCH()](https://dev.mysql.com/doc/refman/8.0/en/json-modification-functions.html#function_json-merge-patch))
- [ ] JSON_MERGE_PRESERVE ([JSON_MERGE_PRESERVE()](https://dev.mysql.com/doc/refman/8.0/en/json-modification-functions.html#function_json-merge-preserve))
- [ ] JSON_REMOVE ([JSON_REMOVE()](https://dev.mysql.com/doc/refman/8.0/en/json-modification-functions.html#function_json-remove))
- [ ] JSON_TABLE ([JSON_TABLE()](https://dev.mysql.com/doc/refman/8.0/en/json-table-functions.html#function_json-table))
- [ ] JSON_STORAGE_SIZE ([JSON_STORAGE_SIZE()](https://dev.mysql.com/doc/refman/8.0/en/json-utility-functions.html#function_json-storage-size))
- [ ] JSON_STORAGE_FREE ([JSON_STORAGE_FREE()](https://dev.mysql.com/doc/refman/8.0/en/json-utility-functions.html#function_json-storage-free))
U can pick this according comment below:
"I pick "-> ->> " " and this task could assign to u for one week, if no pr or progress during one week I would re-assign others
### Solution
U can pick this according comment below:
"I pick "-> ->> " " and this task could assign to u for one week, if no pr or progress during one week I would re-assign others
### 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] lovlyhao commented on issue #21268: [Enhancement] Improve Json function for doris
Posted by "lovlyhao (via GitHub)" <gi...@apache.org>.
lovlyhao commented on issue #21268:
URL: https://github.com/apache/doris/issues/21268#issuecomment-1645125713
I pick JSON_TABLE.
--
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] yifei02 commented on issue #21268: [Enhancement] Improve Json function for doris
Posted by "yifei02 (via GitHub)" <gi...@apache.org>.
yifei02 commented on issue #21268:
URL: https://github.com/apache/doris/issues/21268#issuecomment-1614106638
I pick json_array
--
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] yifei02 commented on issue #21268: [Enhancement] Improve Json function for doris
Posted by "yifei02 (via GitHub)" <gi...@apache.org>.
yifei02 commented on issue #21268:
URL: https://github.com/apache/doris/issues/21268#issuecomment-1612612126
I pick "jsonb: json_contains " and "json_contains_path".
--
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] JasonWen1 commented on issue #21268: [Enhancement] Improve Json function for doris
Posted by "JasonWen1 (via GitHub)" <gi...@apache.org>.
JasonWen1 commented on issue #21268:
URL: https://github.com/apache/doris/issues/21268#issuecomment-1643182513
I pick json_insert
--
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] weijiew commented on issue #21268: [Enhancement] Improve Json function for doris
Posted by "weijiew (via GitHub)" <gi...@apache.org>.
weijiew commented on issue #21268:
URL: https://github.com/apache/doris/issues/21268#issuecomment-1612611223
> I pick "jsonb: json_contains " and "json_contains_path".
ok , I pick "jsonb: json_contains " and "json_contains_path".
--
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] weijiew commented on issue #21268: [Enhancement] Improve Json function for doris
Posted by "weijiew (via GitHub)" <gi...@apache.org>.
weijiew commented on issue #21268:
URL: https://github.com/apache/doris/issues/21268#issuecomment-1612610484
I pick "jsonb: json_contains " and "json_contains_path".
--
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] xuefengze commented on issue #21268: [Enhancement] Improve Json function for doris
Posted by "xuefengze (via GitHub)" <gi...@apache.org>.
xuefengze commented on issue #21268:
URL: https://github.com/apache/doris/issues/21268#issuecomment-1713130276
I pick JSON_SET
--
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] weijiew commented on issue #21268: [Enhancement] Improve Json function for doris
Posted by "weijiew (via GitHub)" <gi...@apache.org>.
weijiew commented on issue #21268:
URL: https://github.com/apache/doris/issues/21268#issuecomment-1612600919
I will do it.
--
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] caicancai commented on issue #21268: [Enhancement] Improve Json function for doris
Posted by "caicancai (via GitHub)" <gi...@apache.org>.
caicancai commented on issue #21268:
URL: https://github.com/apache/doris/issues/21268#issuecomment-1614104364
i pick "JSON_INSERT"
--
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] taptao commented on issue #21268: [Enhancement] Improve Json function for doris
Posted by "taptao (via GitHub)" <gi...@apache.org>.
taptao commented on issue #21268:
URL: https://github.com/apache/doris/issues/21268#issuecomment-1646835568
i pick JSON_MERGE_PRESERVE
--
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] amorynan commented on issue #21268: [Enhancement] Improve Json function for doris
Posted by "amorynan (via GitHub)" <gi...@apache.org>.
amorynan commented on issue #21268:
URL: https://github.com/apache/doris/issues/21268#issuecomment-1612605020
> I will do it.
U should choose one or more task , like "I pick "-> ->> " " or "I pick "jsonb: json_contains " "
--
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] Xuxiaotuan commented on issue #21268: [Enhancement] Improve Json function for doris
Posted by "Xuxiaotuan (via GitHub)" <gi...@apache.org>.
Xuxiaotuan commented on issue #21268:
URL: https://github.com/apache/doris/issues/21268#issuecomment-1614101032
I pick "json: JSON_LENGTH"
--
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] niebayes commented on issue #21268: [Enhancement] Improve Json function for doris
Posted by "niebayes (via GitHub)" <gi...@apache.org>.
niebayes commented on issue #21268:
URL: https://github.com/apache/doris/issues/21268#issuecomment-1612800754
I pick "json: json_depth"
--
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] caicancai commented on issue #21268: [Enhancement] Improve Json function for doris
Posted by "caicancai (via GitHub)" <gi...@apache.org>.
caicancai commented on issue #21268:
URL: https://github.com/apache/doris/issues/21268#issuecomment-1614104505
i pick "json:JSON_INSERT"
--
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] yifei02 commented on issue #21268: [Enhancement] Improve Json function for doris
Posted by "yifei02 (via GitHub)" <gi...@apache.org>.
yifei02 commented on issue #21268:
URL: https://github.com/apache/doris/issues/21268#issuecomment-1612609693
I will do it
--
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] cjj2010 commented on issue #21268: [Enhancement] Improve Json function for doris
Posted by "cjj2010 (via GitHub)" <gi...@apache.org>.
cjj2010 commented on issue #21268:
URL: https://github.com/apache/doris/issues/21268#issuecomment-1614105937
i pick "json:JSON_REPLACE"
--
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] niebayes commented on issue #21268: [Enhancement] Improve Json function for doris
Posted by "niebayes (via GitHub)" <gi...@apache.org>.
niebayes commented on issue #21268:
URL: https://github.com/apache/doris/issues/21268#issuecomment-1616018761
I pick json_search
--
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] davedwwang commented on issue #21268: [Enhancement] Improve Json function for doris
Posted by "davedwwang (via GitHub)" <gi...@apache.org>.
davedwwang commented on issue #21268:
URL: https://github.com/apache/doris/issues/21268#issuecomment-1682044304
I pick JSON_REMOVE and JSON_MERGE_PATCH.
--
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] eldenmoon closed issue #21268: [Enhancement] Improve Json function for doris
Posted by "eldenmoon (via GitHub)" <gi...@apache.org>.
eldenmoon closed issue #21268: [Enhancement] Improve Json function for doris
URL: https://github.com/apache/doris/issues/21268
--
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] hammerZh-Z commented on issue #21268: [Enhancement] Improve Json function for doris
Posted by "hammerZh-Z (via GitHub)" <gi...@apache.org>.
hammerZh-Z commented on issue #21268:
URL: https://github.com/apache/doris/issues/21268#issuecomment-1642228944
I pick json_valid.
--
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