Support Questions
Find answers, ask questions, and share your expertise

How to remove the elements with value as zero in hive array

How to remove the elements with value as zero in hive array

New Contributor
I have an array column in hive which will be having 7 numbers.

For Ex: [32,4,0,43,23,0,1]

I want my output to be [32,4,43,23,1] (with all the zero elements removed)

Someone help me to accomplish this?