Under working with JSON section in the book it is mentioned as
"The equivalent in SQL would be
jsonDF.selectExpr("json_tuple(jsonString, '$.myJSONKey.myJSONValue[1]') as column").show(2)"
but it is not a SQL syntax at first . could you please check and let us know the equivalent SQL expression of JSON transformation.
Under working with JSON section in the book it is mentioned as
"The equivalent in SQL would be
jsonDF.selectExpr("json_tuple(jsonString, '$.myJSONKey.myJSONValue[1]') as column").show(2)"
but it is not a SQL syntax at first . could you please check and let us know the equivalent SQL expression of JSON transformation.