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 : 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
