Hi, yiwang. The type of BUYER_ID is bigint. I think the sql should be “select BUYER_ID from KYLIN_SALES where BUYER_ID = 10000002 group by BUYER_ID”. In attach is the result that I run the sql.
[cid:[email protected]]. 发送自 Windows 10 版邮件<https://go.microsoft.com/fwlink/?LinkId=550986>应用 ________________________________ 发件人: yiwang <[email protected]> 发送时间: Wednesday, November 14, 2018 4:27:07 PM 收件人: [email protected] 主题: Re: 答复: Filter return error when using " = " for Integer column type hello, I followed your guide and modified sql to "select BUYER_ID from KYLIN_SALES where BUYER_ID = '10000002' group by BUYER_ID" got the similar error. Error while compiling generated Java code: org.apache.calcite.DataContext root; public org.apache.calcite.linq4j.Enumerable bind(final org.apache.calcite.DataContext root0) { root = root0; final org.apache.calcite.linq4j.Enumerable _inputEnumerable = ((org.apache.kylin.query.schema.OLAPTable) root.getRootSchema().getSubSchema("DEFAULT").getTable("KYLIN_SALES")).executeOLAPQuery(root, 0); final org.apache.calcite.linq4j.AbstractEnumerable child = new org.apache.calcite.linq4j.AbstractEnumerable(){ public org.apache.calcite.linq4j.Enumerator enumerator() { return new org.apache.calcite.linq4j.Enumerator(){ public final org.apache.calcite.linq4j.Enumerator inputEnumerator = _inputEnumerable.enumerator(); public void reset() { inputEnumerator.reset(); } public boolean moveNext() { while (inputEnumerator.moveNext()) { final Long inp7_ = (Long) ((Object[]) inputEnumerator.current())[7]; if (inp7_ != null && inp7_.longValue() == "10000002") { return true; } } return false; } public void close() { inputEnumerator.close(); } public Object current() { return (Long) ((Object[]) inputEnumerator.current())[7]; } }; } }; return child.distinct().take(50000); } public Class getElementType() { return java.lang.Long.class; } while executing SQL: "select BUYER_ID from KYLIN_SALES where BUYER_ID = '10000002' group by BUYER_ID LIMIT 50000" -- Sent from: http://apache-kylin.74782.x6.nabble.com/
