版本: 3.3.x
starrocks on hive 查询报错:
select case when cardinality(split(‘aaa;bbb’, ‘;’)) >= 3 then split(‘aaa;bbb’, ‘;’)[3] else ‘EMPTY’ end;
报错:
Caused by: java.sql.SQLSyntaxErrorException: Array subscript must be less than or equal to array length: 3 > 2
starrocks查询正常。
是否有参数可以适配?