You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@kylin.apache.org by Xiaoxiang Yu <xx...@apache.org> on 2020/01/13 06:47:57 UTC
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" <31...@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
Re: intersect_value raise error
Posted by ShaoFeng Shi <sh...@apache.org>.
Hi ZF，
The intersect_value function wasn't released yet.
Best regards,
Shaofeng Shi 史少锋
Apache Kylin PMC
Email: shaofengshi@apache.org
Apache Kylin FAQ: https://kylin.apache.org/docs/gettingstarted/faq.html
Join Kylin user mail group: user-subscribe@kylin.apache.org
Join Kylin dev mail group: dev-subscribe@kylin.apache.org
Xiaoxiang Yu <xx...@apache.org> 于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" <31...@qq.com> 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"<xx...@apache.org>;
> *发送时间:* 2020年1月13日(星期一) 下午2:47
> *收件人:* "user"<us...@qq.com>;
> *主题:* 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" <31...@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 :
>
> 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
>
>
Re: intersect_value raise error
Posted by Xiaoxiang Yu <xx...@apache.org>.
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" <31...@qq.com> 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"<xx...@apache.org>;
发送时间: 2020年1月13日(星期一) 下午2:47
收件人: "user"<us...@qq.com>;
主题: 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" <31...@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
回复：intersect_value raise error
Posted by ZF <31...@qq.com>.
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"<xxyu@apache.org>;
发送时间: 2020年1月13日(星期一) 下午2:47
收件人: "user"<user@kylin.apache.org>;"ZF"<310866659@qq.com>;
主题: 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" <310866659@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