You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@kylin.apache.org by "zhengdong (JIRA)" <ji...@apache.org> on 2016/11/23 08:28:59 UTC

[jira] [Commented] (KYLIN-2213) UnsupportedOperationException when excute 'not like' query on cube v1

    [ https://issues.apache.org/jira/browse/KYLIN-2213?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15689343#comment-15689343 ] 

zhengdong commented on KYLIN-2213:
----------------------------------

BuiltInFunctionTupleFilter doesn't support reverse operation and throw UnsupportedOperationException when flatten the filter. 
The patch could fix this bug.

> UnsupportedOperationException when excute 'not like' query on cube v1
> ---------------------------------------------------------------------
>
>                 Key: KYLIN-2213
>                 URL: https://issues.apache.org/jira/browse/KYLIN-2213
>             Project: Kylin
>          Issue Type: Bug
>    Affects Versions: v1.5.3, v1.5.4.1
>            Reporter: zhengdong
>         Attachments: 0001-KYLIN-2213-UnsupportedOperationException-when-excute.patch
>
>
> sql like 'select ....from factTabe join dimTable on ... where dimTable.columnName not like 'a%' ' 
> got UnsupportedOperationException when get flatFilter. Exception stack like this:
>  {noformat} 
> enumerator.OLAPEnumerator:108 : query storage...
>         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
>         at com.thetransactioncompany.cors.CORSFilter.doFilter(CORSFilter.java:195)
>         at com.thetransactioncompany.cors.CORSFilter.doFilter(CORSFilter.java:266)
>         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
>         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
>         at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
>         at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
>         at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:505)
>         at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
>         at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
>         at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:956)
>         at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
>         at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:436)
>         at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1078)
>         at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:625)
>         at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
>         at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
>         at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
>         at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
>         at java.lang.Thread.run(Thread.java:745)
> Caused by: java.lang.UnsupportedOperationException
>         at org.apache.kylin.metadata.filter.TupleFilter.reverse(TupleFilter.java:117)
>         at org.apache.kylin.metadata.filter.TupleFilter.flattenInternal(TupleFilter.java:178)
>         at org.apache.kylin.metadata.filter.TupleFilter.flattenInternal(TupleFilter.java:148)
>         at org.apache.kylin.metadata.filter.TupleFilter.flatFilter(TupleFilter.java:132)
>         at org.apache.kylin.storage.hbase.cube.v1.CubeStorageQuery.flattenToOrAndFilter(CubeStorageQuery.java:409)
>         at org.apache.kylin.storage.hbase.cube.v1.CubeStorageQuery.search(CubeStorageQuery.java:142)
>         at org.apache.kylin.query.enumerator.OLAPEnumerator.queryStorage(OLAPEnumerator.java:123)
>         at org.apache.kylin.query.enumerator.OLAPEnumerator.moveNext(OLAPEnumerator.java:71)
>         at Baz$1$1.moveNext(Unknown Source)
>         at org.apache.calcite.linq4j.EnumerableDefaults$15$1.moveNext(EnumerableDefaults.java:1897)
>         at org.apache.calcite.linq4j.EnumerableDefaults.into(EnumerableDefaults.java:2908)
>         at org.apache.calcite.linq4j.DefaultEnumerable.into(DefaultEnumerable.java:343)
>         at org.apache.calcite.linq4j.EnumerableDefaults.distinct(EnumerableDefaults.java:468)
>         at org.apache.calcite.linq4j.DefaultEnumerable.distinct(DefaultEnumerable.java:210)
> {noformat} 



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)