Query array<string> in hive

Question

I am trying to select from an array in Hive and I'm having trouble doing so.

The statement I am trying is as follows:

select * from table where ID = 'tennis'

ID field is of type array

A sample of array data in the id field would look like id = ('tennis', 'soccer', 'football')

A sample of array data in the id field would look like id = ('tennis', 'soccer', 'football') — ravecoder
– ravecoder, Commented Sep 4, 2019 at 17:54

double-beep · Accepted Answer · 2019-09-04 17:24:58Z

1

The array_contains function is probably what you need:

select * from table where array_contains(ID,'tennis')

double-beep

5,67019 gold badges43 silver badges50 bronze badges

answered Sep 4, 2019 at 17:06

leftjoin

38.5k8 gold badges64 silver badges126 bronze badges

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

1 Answer 1