Hi all, I am new to Spark. I have a json in below format : Employee : {"id" : "001","name":"abc", "address" : [ {"state" : "maharashtra","country" : "india" } , {"state" : "gujarat","country" : "india" }]}
I want to parse in such a way that I can query address For e.g Get list of states where "country" = "india" for id=001 Can you please help me with query for this scenario. Best Regards, Radhakrishnan Iyer