Hi friend,
As far as I know, intersect_value is not available at the moment. I guess
it is not very easy to implement it because this feature need a bidirectional
global dictionary.
--
Best wishes to you !
From ：Xiaoxiang Yu
At 2020-01-13 13:47:21, "ZF" <310866...@qq.com> wrote:
hi,
I apply intersect_value function to query user_ids for some conditions, but I
got error:
From line 2, column 1 to line 2, column 58: No match found for function
signature INTERSECT_VALUE(<NUMERIC>, <CHARACTER>, <CHAR(3) ARRAY>) while
executing SQL: "select * from (select intersect_value(phone_no, label_name,
array['age', 'sex']) from TEST_USER_ATTR_VERTICAL where ( label_name = 'age'
and label_value in ('1', '2') ) or ( label_name = 'sex' and label_value in
('1') )) limit 50000"
here is my kylin version:apache-kylin-3.0.0-beta-bin-hadoop3
Query sql is :
select
intersect_value(phone_no, label_name, array['age', 'sex'])
from TEST_USER_ATTR_VERTICAL
where (
label_name = 'age'and label_value in ('1', '2')
)
or (
label_name = 'sex'and label_value in ('1')
);
btw: intersect_count is ok
