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