Proposed changes change explode-json-array-xx func signature from string to json type to improve function behavior Issue Number: close #xxx
New issue Open Description 781015928 781015928 changed the title[Bug][Bug] explode_json_array_sting 无法解析复杂josnon Nov 30, 2022 781015928 changed the title[Bug] explode_json_array_sting 无法解析复杂josn[Bug] explode_json_array_sting 无法解析复杂jsonon Dec 5, 2022...
一个JSONArray为: [{"id":"1","name":"zhangsan"},{"id":"2","name":"lisi"},{"id":"3","name":"wangwu"},...] 1. 用get_json_object() 处理这种并不是很友好: 我们可以这样: SELECT explode(split(regexp_replace( regexp_replace( '[{"id":"1","name":"zhangsan"},{"id":"2"...
importorg.apache.spark.sql.SparkSessionvalspark=SparkSession.builder().appName("JSON to Array Explode Example").getOrCreate()valdata=Seq(("Alice",30,"""["reading", "painting", "traveling"]"""),("Bob",25,"""["swimming", "cooking"]"""))valdf=spark.createDataFrame(data).toDF("name...
I have one column in hive table wherein I have stored entire json data map as string. I am using get_json_object to fetch each element of json. However I have one element which is array of structs. I need to explode that array of structs. Event Sample: {"evtDataMap...