Github user myui commented on the issue:
https://github.com/apache/incubator-hivemall/pull/135
```sql
create temporary function array_slice as
'hivemall.tools.array.ArraySliceUDF';
select
array_slice(
array("zero", "one", "two", "three", "four", "five", "six", "seven",
"eight", "nine", "ten"),
0, -- offset
2 -- length
),
array_slice(
array("zero", "one", "two", "three", "four", "five", "six", "seven",
"eight", "nine", "ten"),
6, -- offset
3 -- length
),
array_slice(
array("zero", "one", "two", "three", "four", "five", "six", "seven",
"eight", "nine", "ten"),
6, -- offset
10 -- length
),
array_slice(
array("zero", "one", "two", "three", "four", "five", "six", "seven",
"eight", "nine", "ten"),
6 -- offset
),
array_slice(
array("zero", "one", "two", "three", "four", "five", "six", "seven",
"eight", "nine", "ten"),
-3 -- offset
),
array_slice(
array("zero", "one", "two", "three", "four", "five", "six", "seven",
"eight", "nine", "ten"),
-3, -- offset
2 -- length
);
```
> ["zero","one"] ["six","seven","eight"]
["six","seven","eight","nine","ten"] ["six","seven","eight","nine","ten"]
["eight","nine","ten"] ["eight","nine"]
---
