You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@kylin.apache.org by Ge Silas <go...@live.cn> on 2018/10/08 09:59:32 UTC
答复: The same SQL returns different results on different server
Hi Long,
Can you check the log files on both Server A and Server B and compare any difference in for example cuboid selection, scan byte, scan rows etc.?
Thanks,
Silas
________________________________
发件人: 张龙 <zh...@mafengwo.com>
发送时间: 2018年10月8日 15:29
收件人: user
主题: The same SQL returns different results on different server
Hi all:
The same SQL can be executed correctly on server A, and the returned result is not empty. The result returned by server B is empty. After restarting server B, server B can be executed correctly.
This is not the first time the problem has arisen.
kylin version: 2.3.1
答复: Re:答复: The same SQL returns different results on different server
Posted by Ge Silas <go...@live.cn>.
Hi Long,
It looks to me that the metadata are not properly broadcasted so on server A it sees a segment [20181007000000_20181008000000] however on server B it does not see this segment. You may check when this segment is being built, whether the metadata broadcast continued to be successful.
Thanks,
Silas
________________________________
发件人: 张龙 <zh...@mafengwo.com>
发送时间: 2018年10月9日 8:57
收件人: user
主题: Re:答复: The same SQL returns different results on different server
Segment: 20181007000000_20181008000000 build success at 2018-10-08 08:34:38
------------------ Original ------------------
From: "Ge Silas"<go...@live.cn>;
Date: Mon, Oct 8, 2018 05:59 PM
To: "张龙"<zh...@mafengwo.com>; "user@kylin.apache.org"<us...@kylin.apache.org>;
Subject: 答复: The same SQL returns different results on different server
Hi Long,
Can you check the log files on both Server A and Server B and compare any difference in for example cuboid selection, scan byte, scan rows etc.?
Thanks,
Silas
________________________________
发件人: 张龙 <zh...@mafengwo.com>
发送时间: 2018年10月8日 15:29
收件人: user
主题: The same SQL returns different results on different server
Hi all:
The same SQL can be executed correctly on server A, and the returned result is not empty. The result returned by server B is empty. After restarting server B, server B can be executed correctly.
This is not the first time the problem has arisen.
kylin version: 2.3.1
Re:答复: The same SQL returns different results on different server
Posted by 张龙 <zh...@mafengwo.com>.
Segment: 20181007000000_20181008000000 build success at 2018-10-08 08:34:38
------------------ Original ------------------
From: "Ge Silas"<go...@live.cn>;
Date: Mon, Oct 8, 2018 05:59 PM
To: "张龙"<zh...@mafengwo.com>; "user@kylin.apache.org"<us...@kylin.apache.org>;
Subject: 答复: The same SQL returns different results on different server
Hi Long,
Can you check the log files on both Server A and Server B and compare any difference in for example cuboid selection, scan byte, scan rows etc.?
Thanks,
Silas
发件人: 张龙 <zh...@mafengwo.com>
发送时间: 2018年10月8日 15:29
收件人: user
主题: The same SQL returns different results on different server
Hi all:
The same SQL can be executed correctly on server A, and the returned result is not empty. The result returned by server B is empty. After restarting server B, server B can be executed correctly.
This is not the first time the problem has arisen.
kylin version: 2.3.1