hive Unexpected column vector type LIST

现象描述：
表A

表B

表C

异常SQL：

报表：Unexpected column vector type LIST
select 
A.id , A.path , B.id, C.id
from A 
join C in array_contains(A.path ,C.id)
join B on B.a_id = A.id ;

报表：Unexpected column vector type LIST
select A.id , A.path , B.id 
from A 
join B on B.a_id = A.id ;

以上两条sql join 逻辑一样

正确sql : （调整sql 逻辑解决）

select 
ac.id , ac.path , B.id as b_id, C.c_id
from (
	select  A.id , A.path  , C.id as c_id
	from A 
	join C in array_contains(A.path ,C.id)
) ac
join B on B.a_id = ac.id ;

原因未知，有大佬知道的，可以在下方评论回复，感谢！