How to create a hive array from sas data set?

[ARC2]

Say I have a SAS dataset (or a hive table) with an id variable plus variables x1-x5 and I want to read this data into a hive table with the x1-x5 in a hive array. What goes in the select statement to get those variables into an array? Or is select not the right way?

Thanks.

[Patrick]

That's not a SAS but a Hive SQL question.

After a quick Google seems there is an array() function for this.

From: https://dwgeek.com/hive-array-functions-usage-and-examples.html/

Following is the syntax of array function.

array(value1, value2, value2,...)

where, value is of type string or integer.