I have a spark dataset that has fields: "identifier_id", "inner_blob" , "json_blob" "inner_blob": { "identifier_id": 2.0, "name": "test1", "age": 30.0 }, "identifier_id": 2.0, "json_blob": { "identifier_id": 2.0, "order_id": 2.0, "inner_blob": [ { "item_id": 23.0, "item_name": "airpods2", "item_price": 300.0 }, {…
What query would transpose the following JSON value to multiple rows. Examples with nested JSON objects are sparse. [{"a":{"b":"val", "c":1}},{"a":{"b":"val", "c":4}}] Tried combinations of JSONExtract but having difficulty with nested object
I have a Json string, after parsing I want it to remain in decimal form. import play.api.libs.json._ val jsonString = """{"value":2.0}""" println(jsonString) println(Json.parse(jsonString)) The output of the code above is: {"value":2.0} {"value":2} I need it to be {"value":2.0} {"value":2.0}
I was wondering if someone could tell me what I'm doing wrong. Below is a sample json I'm looking to extract the value in the 'details' list, but for some reason I just can't figure out how to achieve it.…
I'm trying to pull out from this JSON column - "toTimestamp" & "fromTimestamp" so I can calculate instances when the video is above a certain number of seconds. (Postgresql) *Metadata column "videoMetadata": [ { "cameraId":"74", "toTimestamp":"2023-02-15T13:06:43.050Z", "fromTimestamp":"2023-02-15T13:06:39.050Z" }, { "cameraId":"236",…
My source JSON file have : in the key as mentioned below "Dimension 4 : 4 : 4" : "4k TV" My JSON to XML converter fails as this is not allowed and throws this exception System.Xml.XmlException: The ':' character,…
I am trying to loop through my JSON data and form an array of objects. I am counting the number of fruits in each State. My JSON data is as below: const data = [ { “State”: “California”, “Fruits”: [{"name":…
I'm trying to extract data from Json stored in a column and save as relational data in tables. The Json represents submissions of a pre-start checklist by a driver. The input data is stored in a table, with SubmitId being…
do you guys know how to parse an array of json objects but without square brackets { "jsonValue1": "val1", "jsonValue2": [1, 1, 2, 2]} { "jsonValue1": "val1", "jsonValue2": [1, 1, 2, 2]} { "jsonValue1": "val1", "jsonValue2": [1, 1, 2, 2]}…
I have the following CSV (truncated): "adfebb","a-f-A-M-F-R-Z","95-00123","C560","USAF" "ae0133","a-f-A-M-F-R-Z","97-00102","C560","USAF" I need the following JSON: { "adfebb":["a-f-A-M-F-R-Z","95-00123","C560","USAF"], "ae0133":["a-f-A-M-F-R-Z","97-00102","C560","USAF"] } I have been tinkering with jq and came close but I haven't managed to get it just right. What I currently have is:…