Hi, yiwang Hope this can help you. http://kylin.apache.org/docs/gettingstarted/faq.html.
In this page, you can search “select *” for the answer. 发送自 Windows 10 版邮件<https://go.microsoft.com/fwlink/?LinkId=550986>应用 ________________________________ 发件人: yiwang <[email protected]> 发送时间: Wednesday, November 14, 2018 2:41:48 PM 收件人: [email protected] 主题: Filter return error when using " = " for Integer column type Hello Kylin Team, In sample cube, data type of BUYER_ID is Integer. select * from KYLIN_SALES where "BUYER_ID" = '10000002' this query works in db,but failed in kylin, Error detail as below. 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() { final Object[] current = (Object[]) inputEnumerator.current(); return new Object[] { current[0], current[1], current[2], current[3], current[4], current[5], current[6], current[7], current[8], current[9]}; } }; } }; return child.take(50000); } public Class getElementType() { return java.lang.Object[].class; } while executing SQL: "select * from KYLIN_SALES where "BUYER_ID" = '10000002' LIMIT 50000" Thanks Yi -- Sent from: http://apache-kylin.74782.x6.nabble.com/
