doris icon indicating copy to clipboard operation
doris copied to clipboard

[Feature] (table function) Support explode_json_array_jsonobject

Open will86 opened this issue 1 year ago • 0 comments

Search before asking

  • [X] I had searched in the issues and found no similar issues.

Description

As Doris has provided some useful table functions, such as explode_json_array_int、explode_json_array_double、explode_json_array_string.

Now I hava a set of JSON like that: [ {"K1”:"V1-1", "K2": "V2-1"}, {"K1”:"V1-2", "K2": "V2-2"} ]

I expect use a explode_json function to get each json item in JsonArray.

As the result, I hope the table function would be like this:

K1 |K2

V1-2 |V2-1 V2-2 |V2-2

Could provided a table function to support the above case. Thanks!

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

will86 avatar Mar 02 '23 04:03 will86