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 ________________________________ 发件人: 张龙 <[email protected]> 发送时间: 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"<[email protected]>; Date: Mon, Oct 8, 2018 05:59 PM To: "张龙"<[email protected]>; "[email protected]"<[email protected]>; 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 ________________________________ 发件人: 张龙 <[email protected]> 发送时间: 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
