文章目录
- Clickhouse—数组函数
-
- 1. empty
- 2. notEmpty
- 3. length
- 4. emptyArray
- 5. emptyArrayToSingle
- 6. range
- 7. array
- 8. arrayConcat
- 9. arrayElement
- 10. has
- 11. hasAny
- 12. hasAll
- 13. indexOf
- 14. countEqual
- 15. arrayEnumerate
- 16. arrayEnumerateUniq
- 17. arrayPop
- 18. arrayPush
- 19. arrayResize
- 20. arraySlice
- 21. arraySort
- 22. arrayReverse
- 23. arrayUniq
- 24. arrayJoin
- 25. arrayDifference
- 26. arrayDistinct
- 27. uniqArray
- 28. arraySum
- 29. arrayEnumerateDense
- 30. arrayIntersect
- 31. arrayReduce
- 32. arrayFilter
- 33. arrayStringConcat
- 34. arrayCompact
- 35. runningDifference
- 36. arrayWithConstant
- 37. neighbor
- 38. arrayMap
- 39. arrayCount
- 40. arrayExists
- 41 arrayFirst
- 42. arrayFirstIndex
- 43. arrayCumSum
- 总结
Clickhouse—数组函数
1. empty
- 判断数组是否为空
- 为空:1
- 不为空:0
SELECT empty([]), empty([1,2,3]);
┌─empty(array()