You can use dot notations.
select myList.vList from t where myList.nm=IP'
On Fri, Aug 12, 2016 at 9:11 AM, vr spark wrote:
> Hi Experts,
> Please suggest
>
> On Thu, Aug 11, 2016 at 7:54 AM, vr spark wrote:
>
>>
>> I have data which is json in this format
>>
>> myList: array
>> |||-
Hi Experts,
Please suggest
On Thu, Aug 11, 2016 at 7:54 AM, vr spark wrote:
>
> I have data which is json in this format
>
> myList: array
> |||-- elem: struct
> ||||-- nm: string (nullable = true)
> ||||-- vList: array (nullable = true)
> ||||
