create table tb (arr_col array<string>)

insert into tb select array ('A','B') from (select 'temp') x

select tb.arr_col from tb

..in select list returns a complex type 'ARRAY<STRING>'.
Only scalar types are allowed in the select list.

select tb.arr_col.item from tb

ERROR: AnalysisException: Illegal column/field reference 'arr_col.item' with intermediate collection 'item' of type 'ARRAY<STRING>'

select arr_col array.item from tb , tb.arr_col array ;