Insert empty int array into a hive table

Question

let's say I have a hive table that has only one column of type array<int>.

I can insert into that table by

INSERT INTO TABLE tablename SELECT array(1);

but what if I want to insert an empty int array into that column? Didn't figure out. Tried with array(), [], array<int> and array<int>()

Jiechao Wang · Accepted Answer · 2019-04-11 17:32:34Z

2

this works for me

collect_set(CAST(NULL AS INT))

answered Apr 11, 2019 at 17:32

Jiechao Wang

9522 gold badges15 silver badges33 bronze badges

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

1 Answer 1