Issue with comparing structs (possible bug)

2024-07-26 Thread Dhruv Singla
Hey Everyone Hope you are doing well I am trying to compare structs with structs using the IN clause. Here is what I found. The following query comparing structs gives error SELECT struct(1, 2) IN ( SELECT struct(c1, c2) FROM (VALUES (1, 2), (3, 4)) AS t(c1, c2) ); Error - Cannot resolve "(name

Re: Issue with comparing structs (possible bug)

2024-07-26 Thread Dhruv Singla
The spark version 3.5.1 On Fri, Jul 26, 2024 at 6:54 PM Dhruv Singla wrote: > Hey Everyone > > Hope you are doing well > > I am trying to compare structs with structs using the IN clause. Here is > what I found. > The following query comparing structs gives error > > SELECT struct(1, 2) IN ( > S