?
> Thank you.
>
> BRs,
> May
>
>
> -- 原始邮件 --
> *发件人:* "王林"<1059790...@qq.com>;
> *发送时间:* 2018年11月21日(星期三) 下午4:50
> *收件人:* "dev";"shaofengshi";
> *主题:* 回复: apache kylin left join 数据查询混乱咨询
>
&g
Hi Lin,
Nice finding!!! Could you open a JIRA to track this issue?
Thank you.
BRs,
May
-- 原始邮件 --
发件人: "王林"<1059790...@qq.com>;
发送时间: 2018年11月21日(星期三) 下午4:50
收件人: "dev";"shaofengshi";
主题: 回复: apache kylin left join
C.DT = D.DT
sql 按照上述修改,查询结果就是正确的,应该是kylin 的bug。
-- 原始邮件 --
发件人: "shaofengshi";
发送时间: 2018年11月20日(星期二) 下午4:40
收件人: "dev";
主题: Re: apache kylin left join 数据查询混乱咨询
Hi Ling,
Could you please provide the Kylin log when executing the f
??
kylin??
sql??
SELECT
c.DT,
COALESCE (C.weekActivityCount, 0),
COALESCE (D.monthActivityCount, 0)
FROM
(
SELECT
DT AS DT,
count(*) AS weekActivityCount
FROM
你好,执行日志见附件。谢谢
-- 原始邮件 --
发件人: "ShaoFeng Shi";
发送时间: 2018年11月20日(星期二) 下午4:40
收件人: "dev";
主题: Re: apache kylin left join 数据查询混乱咨询
Hi Ling,
Could you please provide the Kylin log when executing the first query?
Thanks!
Best regards,
Sha
Hi Ling,
Could you please provide the Kylin log when executing the first query?
Thanks!
Best regards,
Shaofeng Shi 史少锋
Apache Kylin PMC
Work email: shaofeng@kyligence.io
Kyligence Inc: https://kyligence.io/
Apache Kylin FAQ: https://kylin.apache.org/docs/gettingstarted/faq.html
Join Kylin us
??
kylin??
sql??
SELECT
c.DT,
COALESCE (C.weekActivityCount, 0),
COALESCE (D.monthActivityCount, 0)
FROM
(
SELECT
DT AS DT,
count(*) AS weekActivityCount
FROM
Hi Wang Lin,
I hadencountered this problem as well, the E-mail I had sent to SQL developer
is as below. Maybe it is helpful to you too.
PS: You should adapt your SQL to recommended solution.
Window
??
kylin ??
sql??
SELECT
c.DT,
COALESCE (C.weekActivityCount, 0),
COALESCE (D.monthActivityCount, 0)
FROM
(
SELECT
DT AS DT,
count(*) AS weekActivityCount
FROM
ST_DEVICE_INFO_FACT_T