Spark-The-Definitive-Guide
Spark-The-Definitive-Guide copied to clipboard
Chapter 6 - Working with JSON
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.