How do I write out an array literal in Hive?
How do I write out an array literal in Hive?
SELECT PERCENTILE(Col_name, [0.5, 0.15, 0.45, 0.55, 0.85]) AS qty
FROM test_table;
Returns the error
FAILED: ParseException line xx:xx cannot recognize input near '[' '0.5' ',' in select expression