Repository navigation
Implement array_pop_back function #6997
Description
Is your feature request related to a problem or challenge?
Summary
| Characteristic | Description |
|---|---|
| Function name: | array_pop_back |
| Aliases: | list_pop_back |
| Original function?: | No |
| Function Description: | ClickHouse: Removes the last item from the array. DuckDB: Returns the list without the last element. |
| Sources: | Concept DuckDB ClickHouse |
Examples:
D select array_pop_back([1, 2, 3, 4]);
┌─────────────────────────────────────────────┐
│ array_pop_back(main.list_value(1, 2, 3, 4)) │
│ int32[] │
├─────────────────────────────────────────────┤
│ [1, 2, 3] │
└─────────────────────────────────────────────┘
D select array_pop_back([[1, 2], [3, 4], [4, 2]]);
┌──────────────────────────────────────────────────────────────────────────────────────────────────────┐
│ array_pop_back(main.list_value(main.list_value(1, 2), main.list_value(3, 4), main.list_value(4, 2))) │
│ int32[][] │
├──────────────────────────────────────────────────────────────────────────────────────────────────────┤
│ [[1, 2], [3, 4]] │
└──────────────────────────────────────────────────────────────────────────────────────────────────────┘
Describe the solution you'd like
No response
Describe alternatives you've considered
No response
Additional context
No response
Activity
tanruixiang commentedon Aug 6, 2023
Hi, I'm interested in this issue, can I give it a try?
izveigor commentedon Aug 6, 2023
Hello, @tanruixiang!
Yes, you can give it. It seems to me that the implementation is to use
array_slicefunction, likearray_slice(array, 0, len(array)-1).tanruixiang commentedon Aug 6, 2023
Thank you very much for your advice.❤️
jayzhan211 commentedon Aug 6, 2023
@tanruixiang Also ping me when you are ready for review.
tanruixiang commentedon Aug 21, 2023
@izveigor @jayzhan211 I apologize for the longer delay in this issue due to some other things. It is now ready for REVIEW.