[VL] Json support in Gluten/Velox tracker

[PHILO-HE]

Currently only get_json_object function is supported.

The below tests are disabled in #5467. We need to re-enable them after facebookincubator/velox#5179 is merged.

// runTest("[1,2,3]", "$0",
// runTest("[1,2,3]", "$",
// runTest("{"a":4}", "$",

BTW, see how wilcard is supported for presto: facebookincubator/velox@4e075a0

[FelixYBW]

What's the json functions Gluten already support? Here is the list:

json func	desc
from_json()	Converts JSON string into Struct type or Map type.
to_json()	Converts MapType or Struct type to JSON string.
json_tuple()	Extract the Data from JSON and create them as a new columns.
get_json_object()	Extracts JSON element from a JSON string based on json path specified.
schema_of_json()	Create schema string from JSON string

With supported function, what's the syntax gap? Could you put a list?

[PHILO-HE]

What's the json functions Gluten already support? Here is the list:

json func desc
from_json() Converts JSON string into Struct type or Map type.
to_json() Converts MapType or Struct type to JSON string.
json_tuple() Extract the Data from JSON and create them as a new columns.
get_json_object() Extracts JSON element from a JSON string based on json path specified.
schema_of_json() Create schema string from JSON string

Hi @FelixYBW, currently only get_json_object is supported.

With supported function, what's the syntax gap? Could you put a list?

We have one issue already created to track result mismatched issue: #4652. I will also help update that issue list.

[FelixYBW]

#5600 add json_tuple function