Is there a function similar to split_part, json_extract_scalar?

dulu
New Contributor III

I am using spark_sql version 3.2.1. Is there a function that can replace

split_part,

json_extract_scalar

are not?

Ankush
New Contributor II

pyspark.sql.functions.

get_json_object

(col, path)[source]

Extracts json object from a json string based on json path specified, and returns json string of the extracted json object. It will return null if the input json string is invalid.

​

dulu
New Contributor III

Thanks @Ankush Jadhao​  for answer, I tried but only returns the first result in the cell. They seem to only take the first character with the correct result. I need out put like the table below.

I have the following input:

hinh22 

I am looking for a way to split the characters in the item_order_detail column into 2 columns itemID and itemName. As below output table uses SQL function in databricks with spark_sql version 3.2.1.

hinh223