【SAP HANA 36】HANA数组函数 (ARRAY Functions)的使用

SAP HANA支持数组类型和函数，可以处理多值字段。

-- 创建包含数组的表
CREATE TABLE Projects (
    ProjectID INT PRIMARY KEY,
    ProjectName NVARCHAR(100),
    TeamMembers NVARCHAR(50)[]
);

-- 插入数据
INSERT INTO Projects (ProjectID, ProjectName, TeamMembers)
VALUES (1, 'Project A', ARRAY('John', 'Jane', 'Mike'));

-- 查询数组长度
SELECT ProjectName, CARDINALITY(TeamMembers) AS TeamSize FROM Projects;

-- 查询数组中的特定元素
SELECT ProjectName, TeamMembers[1] AS FirstMember FROM Projects;