Hi ZF， The intersect_value function wasn't released yet.
Best regards, Shaofeng Shi 史少锋 Apache Kylin PMC Email: [email protected] Apache Kylin FAQ: https://kylin.apache.org/docs/gettingstarted/faq.html Join Kylin user mail group: [email protected] Join Kylin dev mail group: [email protected] Xiaoxiang Yu <[email protected]> 于2020年1月13日周一 下午9:46写道： > Thank you for your suggestion, I think it is very valuable. > Currently, doc's maintainer choose to use "/docs" as url for the LATEST > documentation, and "/docsxx" (such as /docs24) as url for the specific > version. > > > > > -- > *Best wishes to you ! * > *From ：**Xiaoxiang Yu* > > At 2020-01-13 18:27:51, "ZF" <[email protected]> wrote: > > 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 > > > ------------------ 原始邮件 ------------------ > *发件人:* "Xiaoxiang Yu"<[email protected]>; > *发送时间:* 2020年1月13日(星期一) 下午2:47 > *收件人:* "user"<[email protected]>;"ZF"<[email protected]>; > *主题:* Re:intersect_value raise error > > 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" <[email protected]> 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 : > > 1. select > 2. > intersect_value(phone_no, label_name, array['age', 'sex']) > 3. > from TEST_USER_ATTR_VERTICAL > 4. > where ( > 5. > label_name = 'age' and label_value in ('1', '2') > 6. > ) > 7. > or ( > 8. > label_name = 'sex' and label_value in ('1') > 9. > ); > > > btw: intersect_count is ok > >
