I am trying to get the email from the array json, but it returns null value
[
{
"name": "Arun",
"email": "arun@arun.com"
},
{
"name": "Arun kumar",
"email": "arunkumar@gmail.com"
}
]
and my Json query is select json->>"$.name" as email from json
But this query is return null value