??????intersect_value raise error

[ZF]

have any  SQL Manual which is consistent with kylin version?
otherwise, many people   will have this kind of problem...


since this doc dose not have version information: 
http://kylin.apache.org/docs/tutorial/sql_reference.html




------------------ ???????? ------------------
??????:&nbsp;"Xiaoxiang Yu"<x...@apache.org&gt;;
????????:&nbsp;2020??1??13??(??????) ????2:47
??????:&nbsp;"user"<user@kylin.apache.org&gt;;"ZF"<310866...@qq.com&gt;;

????:&nbsp;Re:intersect_value raise error



Hi friend,
&nbsp; &nbsp; 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&gt; 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&gt;, <CHARACTER&gt;, <CHAR(3) ARRAY&gt;) 
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: &nbsp;intersect_count is ok &nbsp;