HIVE array<string>

Question

I need to get the empty array as NULL in my result set:

 select id,name,
 case when type = [] then NULL 
 else type 
 end as type
from table

Here type is defined as array<string> I am getting error for the above.

leftjoin · Accepted Answer · 2021-04-19 18:00:33Z

1

Check size(type) = 0

   select t.id, t.name, 
          case when size(t.type) = 0 then NULL 
               else t.type 
           end as type
    from mytable t

answered Apr 19, 2021 at 15:54

leftjoin

38.5k8 gold badges64 silver badges126 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1