I have a hive table contains columns of type array and map and I want to filter record where array/map column contains more than N elements, how to do that?
DDL:
create table test (id string, v1 array<int>, v2 map<string,string>)
Query:
select * from test where length(v1)>10 or length(v2)>10