You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@kylin.apache.org by "胡志华 (万里通科技及数据中心商务智能团队数据分析组)" <HU...@pingan.com.cn> on 2016/08/18 01:04:12 UTC
答复: About lookup table fileds in filter
Hello,
Anybody?
发件人: 胡志华
发送时间: 2016年8月17日 16:40
收件人: dev@kylin.apache.org
主题: About lookup table fileds in filter
Hi all,
I am encountering a problem, when I create model, I put lookup table fields as filter fields .But job monitor page told me “invalid table alias or column reference”，
It means I can’t use lookup table fields as filter fields, I must use fact table fields as filter?
If I want to filter lookup table, what can I do?
********************************************************************************************************************************
The information in this email is confidential and may be legally privileged. If you have received this email in error or are not the intended recipient, please immediately notify the sender and delete this message from your computer. Any use, distribution, or copying of this email other than by the intended recipient is strictly prohibited. All messages sent to and from us may be monitored to ensure compliance with internal policies and to protect our business.
Emails are not secure and cannot be guaranteed to be error free as they can be intercepted, amended, lost or destroyed, or contain viruses. Anyone who communicates with us by email is taken to accept these risks.
收发邮件者请注意：
本邮件含保密信息，若误收本邮件，请务必通知发送人并直接删去，不得使用、传播或复制本邮件。
进出邮件均受到本公司合规监控。邮件可能发生被截留、被修改、丢失、被破坏或包含计算机病毒等不安全情况。
********************************************************************************************************************************
Re: About lookup table fileds in filter
Posted by ShaoFeng Shi <sh...@gmail.com>.
I know there is such an issue; please open a JIRA; and try this workaround: find the HQL that kylin uses to create the flat table, get the table alias, and the use this alias in the model's "filter condition"
Regards，
Shaofeng Shi
shaofengshi@gmail.com
From Outlook Mobile
On Fri, Aug 19, 2016 at 2:13 PM +0800, "胡志华(万里通科技及数据中心商务智能团队数据分析组)" <HU...@pingan.com.cn> wrote:
Sorry, that's my fault. So lete me describe it again.
Problem happened at step 5 "Settings" when I create a model.
I put a field from lookup table into the filter , like "where activity=1" (no where ,I just describe)
The field "activity" is a field from lookup table.
So, when I build the cube, the job monitor page told me , can't find "activity" from the fields of fact table.
It means I can't put field of loopup table in filter, right?
And if I want to filter lookup table ,what can I do?
-----邮件原件-----
发件人: Li Yang [mailto:liyang@apache.org]
发送时间: 2016年8月18日 19:12
收件人: dev@kylin.apache.org
主题: Re: 答复: About lookup table fileds in filter
I read the description but don't understand the question....
On Thu, Aug 18, 2016 at 9:04 AM, 胡志华(万里通科技及数据中心商务智能团队数据分析组) < HUZHIHUA160@pingan.com.cn> wrote:
> Hello,
> Anybody?
>
> 发件人: 胡志华
> 发送时间: 2016年8月17日 16:40
> 收件人: dev@kylin.apache.org
> 主题: About lookup table fileds in filter
>
> Hi all,
>
> I am encountering a problem, when I create model, I put lookup
> table fields as filter fields .But job monitor page told me “invalid
> table alias or column reference”，
>
> It means I can’t use lookup table fields as filter fields, I must use
> fact table fields as filter?
>
> If I want to filter lookup table, what can I do?
>
>
>
>
> ************************************************************
> ********************************************************************
> The information in this email is confidential and may be legally
> privileged. If you have received this email in error or are not the
> intended recipient, please immediately notify the sender and delete
> this message from your computer. Any use, distribution, or copying of
> this email other than by the intended recipient is strictly
> prohibited. All messages sent to and from us may be monitored to
> ensure compliance with internal policies and to protect our business.
> Emails are not secure and cannot be guaranteed to be error free as
> they can be intercepted, amended, lost or destroyed, or contain
> viruses. Anyone who communicates with us by email is taken to accept these risks.
>
> 收发邮件者请注意：
> 本邮件含保密信息，若误收本邮件，请务必通知发送人并直接删去，不得使用、传播或复制本邮件。
> 进出邮件均受到本公司合规监控。邮件可能发生被截留、被修改、丢失、被破坏或包含计算机病毒等不安全情况。
> ************************************************************
> ********************************************************************
>
********************************************************************************************************************************
The information in this email is confidential and may be legally privileged. If you have received this email in error or are not the intended recipient, please immediately notify the sender and delete this message from your computer. Any use, distribution, or copying of this email other than by the intended recipient is strictly prohibited. All messages sent to and from us may be monitored to ensure compliance with internal policies and to protect our business.
Emails are not secure and cannot be guaranteed to be error free as they can be intercepted, amended, lost or destroyed, or contain viruses. Anyone who communicates with us by email is taken to accept these risks.
收发邮件者请注意：
本邮件含保密信息，若误收本邮件，请务必通知发送人并直接删去，不得使用、传播或复制本邮件。
进出邮件均受到本公司合规监控。邮件可能发生被截留、被修改、丢失、被破坏或包含计算机病毒等不安全情况。
********************************************************************************************************************************
答复: 答复: About lookup table fileds in filter
Posted by "胡志华 (万里通科技及数据中心商务智能团队数据分析组)" <HU...@pingan.com.cn>.
Sorry, that's my fault. So lete me describe it again.
Problem happened at step 5 "Settings" when I create a model.
I put a field from lookup table into the filter , like "where activity=1" (no where ,I just describe)
The field "activity" is a field from lookup table.
So, when I build the cube, the job monitor page told me , can't find "activity" from the fields of fact table.
It means I can't put field of loopup table in filter, right?
And if I want to filter lookup table ,what can I do?
-----邮件原件-----
发件人: Li Yang [mailto:liyang@apache.org]
发送时间: 2016年8月18日 19:12
收件人: dev@kylin.apache.org
主题: Re: 答复: About lookup table fileds in filter
I read the description but don't understand the question....
On Thu, Aug 18, 2016 at 9:04 AM, 胡志华(万里通科技及数据中心商务智能团队数据分析组) < HUZHIHUA160@pingan.com.cn> wrote:
> Hello,
> Anybody?
>
> 发件人: 胡志华
> 发送时间: 2016年8月17日 16:40
> 收件人: dev@kylin.apache.org
> 主题: About lookup table fileds in filter
>
> Hi all,
>
> I am encountering a problem, when I create model, I put lookup
> table fields as filter fields .But job monitor page told me “invalid
> table alias or column reference”，
>
> It means I can’t use lookup table fields as filter fields, I must use
> fact table fields as filter?
>
> If I want to filter lookup table, what can I do?
>
>
>
>
> ************************************************************
> ********************************************************************
> The information in this email is confidential and may be legally
> privileged. If you have received this email in error or are not the
> intended recipient, please immediately notify the sender and delete
> this message from your computer. Any use, distribution, or copying of
> this email other than by the intended recipient is strictly
> prohibited. All messages sent to and from us may be monitored to
> ensure compliance with internal policies and to protect our business.
> Emails are not secure and cannot be guaranteed to be error free as
> they can be intercepted, amended, lost or destroyed, or contain
> viruses. Anyone who communicates with us by email is taken to accept these risks.
>
> 收发邮件者请注意：
> 本邮件含保密信息，若误收本邮件，请务必通知发送人并直接删去，不得使用、传播或复制本邮件。
> 进出邮件均受到本公司合规监控。邮件可能发生被截留、被修改、丢失、被破坏或包含计算机病毒等不安全情况。
> ************************************************************
> ********************************************************************
>
********************************************************************************************************************************
The information in this email is confidential and may be legally privileged. If you have received this email in error or are not the intended recipient, please immediately notify the sender and delete this message from your computer. Any use, distribution, or copying of this email other than by the intended recipient is strictly prohibited. All messages sent to and from us may be monitored to ensure compliance with internal policies and to protect our business.
Emails are not secure and cannot be guaranteed to be error free as they can be intercepted, amended, lost or destroyed, or contain viruses. Anyone who communicates with us by email is taken to accept these risks.
收发邮件者请注意：
本邮件含保密信息，若误收本邮件，请务必通知发送人并直接删去，不得使用、传播或复制本邮件。
进出邮件均受到本公司合规监控。邮件可能发生被截留、被修改、丢失、被破坏或包含计算机病毒等不安全情况。
********************************************************************************************************************************
Re: 答复: About lookup table fileds in filter
Posted by Li Yang <li...@apache.org>.
I read the description but don't understand the question....
On Thu, Aug 18, 2016 at 9:04 AM, 胡志华(万里通科技及数据中心商务智能团队数据分析组) <
HUZHIHUA160@pingan.com.cn> wrote:
> Hello,
> Anybody?
>
> 发件人: 胡志华
> 发送时间: 2016年8月17日 16:40
> 收件人: dev@kylin.apache.org
> 主题: About lookup table fileds in filter
>
> Hi all,
>
> I am encountering a problem, when I create model, I put lookup
> table fields as filter fields .But job monitor page told me “invalid table
> alias or column reference”，
>
> It means I can’t use lookup table fields as filter fields, I must use fact
> table fields as filter?
>
> If I want to filter lookup table, what can I do?
>
>
>
>
> ************************************************************
> ********************************************************************
> The information in this email is confidential and may be legally
> privileged. If you have received this email in error or are not the
> intended recipient, please immediately notify the sender and delete this
> message from your computer. Any use, distribution, or copying of this email
> other than by the intended recipient is strictly prohibited. All messages
> sent to and from us may be monitored to ensure compliance with internal
> policies and to protect our business.
> Emails are not secure and cannot be guaranteed to be error free as they
> can be intercepted, amended, lost or destroyed, or contain viruses. Anyone
> who communicates with us by email is taken to accept these risks.
>
> 收发邮件者请注意：
> 本邮件含保密信息，若误收本邮件，请务必通知发送人并直接删去，不得使用、传播或复制本邮件。
> 进出邮件均受到本公司合规监控。邮件可能发生被截留、被修改、丢失、被破坏或包含计算机病毒等不安全情况。
> ************************************************************
> ********************************************************************
>