Thanks. Will get it in over the week-end.
Also, note almost all queries worked except one that was a wildcard search
query with a time dimension. If I take out the date, it works fine. here
is the exception --
LIMIT 10": Error when scan from lower key
^@^@^@^@^@^@^C�^@^@^@^@^@^@^K:�^@^@^@^@^@^@^@ to upper key
^@^@^@^@^@^@^C�����������������^@ on table KYLIN_JZ2UCDO0N2.
at org.apache.calcite.avatica.Helper.createException(Helper.java:41)
at
org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:112)
at
org.apache.calcite.avatica.AvaticaStatement.executeQuery(AvaticaStatement.java:130)
at
org.apache.kylin.rest.service.QueryService.execute(QueryService.java:354)
at
org.apache.kylin.rest.service.QueryService.queryWithSqlMassage(QueryService.java:268)
at
org.apache.kylin.rest.service.QueryService.query(QueryService.java:114)
at
org.apache.kylin.rest.service.QueryService$$FastClassByCGLIB$$4957273f.invoke(<generated>)
at _D_ORC.BR_NM like '%%'
AND CST_D_ORC.PRN_CST_NM like '%%'
AND CTY_D_ORC.CTY_NM like '%%'
AND CCY_D_ORC.CCY_NM like '%DO%'
AND DT_D_ORC.DT_KEY >= DATE'2015-01-01'
GROUP BY
CST_DIM_ORC.PRN_CST_NM,CTY_DIM_ORC.CTY_NM,BR_DIM_ORC.BR_NM,CCY_DIM_ORC.CCY_NM
ORDER BY TOT_USD_TXN_AMT DESC
LIMIT 10": Error when scan from lower key
^@^@^@^@^@^@^C�^@^@^@^@^@^@^K:�^@^@^@^@^@^@^@ to upper key
^@^@^@^@^@^@^C�����������������^@ on table KYLIN_JZ2UCDO0N2.
at org.apache.calcite.avatica.Helper.createException(Helper.java:41)
at
org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:112)
at
org.apache.calcite.avatica.AvaticaStatement.executeQuery(AvaticaStatement.java:130)
at
org.apache.kylin.rest.service.QueryService.execute(QueryService.java:354)
at
org.apache.kylin.rest.service.QueryService.queryWithSqlMassage(QueryService.java:268)
at
org.apache.kylin.rest.service.QueryService.query(QueryService.java:114)
at
org.apache.kylin.rest.service.QueryService$$FastClassByCGLIB$$4957273f.invoke(<generated>)
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
at
org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:618)
at
org.apache.kylin.rest.service.QueryService$$EnhancerByCGLIB$$6cdc133b.query(<generated>)
at
org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:618)
at
org.apache.kylin.rest.service.QueryService$$EnhancerByCGLIB$$6cdc133b.query(<generated>)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at
com.thetransactioncompany.cors.CORSFilter.doFilter(CORSFilter.java:205)
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:504)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
at
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:421)
at
org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1074)
at
org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611)
at
org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:314)
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: org.apache.kylin.common.persistence.StorageException: Error when
scan from lower key ^@^@^@^@^@^@^C�^@^@^@^@^@^@^K:�^@^@^@^@^@^@^@ to upper
key ^@^@^@^@^@^@^C�����������������^@ on table KYLIN_JZ2UCDO0N2.
at
org.apache.kylin.storage.hbase.CubeSegmentTupleIterator.doScan(CubeSegmentTupleIterator.java:221)
at
org.apache.kylin.storage.hbase.CubeSegmentTupleIterator.scanNextRange(CubeSegmentTupleIterator.java:202)
at
org.apache.kylin.storage.hbase.CubeSegmentTupleIterator.<init>(CubeSegmentTupleIterator.java:113)
at
org.apache.kylin.storage.hbase.SerializedHBaseTupleIterator.<init>(SerializedHBaseTupleIterator.java:64)
at
org.apache.kylin.storage.hbase.CubeStorageEngine.search(CubeStorageEngine.java:143)
at
org.apache.kylin.query.enumerator.CubeEnumerator.queryStorage(CubeEnumerator.java:149)
at
org.apache.kylin.query.enumerator.CubeEnumerator.moveNext(CubeEnumerator.java:74)
at Baz$1$1.moveNext(Unknown Source)
at
org.apache.calcite.linq4j.EnumerableDefaults.groupBy_(EnumerableDefaults.java:737)
at
org.apache.calcite.linq4j.EnumerableDefaults.groupBy(EnumerableDefaults.java:677)
at
org.apache.calcite.linq4j.DefaultEnumerable.groupBy(DefaultEnumerable.java:301)
at Baz.bind(Unknown Source)
at
org.apache.calcite.jdbc.CalcitePrepare$CalciteSignature.enumerable(CalcitePrepare.java:281)
at
org.apache.calcite.jdbc.CalciteConnectionImpl.enumerable(CalciteConnectionImpl.java:235)
at
org.apache.calcite.jdbc.CalciteMetaImpl.createIterable(CalciteMetaImpl.java:533)
at
org.apache.calcite.avatica.AvaticaResultSet.execute(AvaticaResultSet.java:184)
at
org.apache.calcite.jdbc.CalciteResultSet.execute(CalciteResultSet.java:63)
at
org.apache.calcite.jdbc.CalciteResultSet.execute(CalciteResultSet.java:42)
at
org.apache.calcite.avatica.AvaticaConnection$1.execute(AvaticaConnection.java:473)
at
org.apache.calcite.jdbc.CalciteMetaImpl.prepareAndExecute(CalciteMetaImpl.java:566)
at
org.apache.calcite.avatica.AvaticaConnection.prepareAndExecuteInternal(AvaticaConnection.java:477)
at
org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:109)
... 83 more
*Caused by: java.nio.BufferOverflowException*
at java.nio.Buffer.nextPutIndex(Buffer.java:513)
at java.nio.HeapByteBuffer.put(HeapByteBuffer.java:163)
at
org.apache.kylin.common.util.BytesUtil.writeVLong(BytesUtil.java:122)
at
org.apache.kylin.common.util.BytesUtil.writeVInt(BytesUtil.java:117)
at
org.apache.kylin.common.util.BytesUtil.writeByteArray(BytesUtil.java:309)
at
org.apache.kylin.common.util.BytesUtil.writeUTFString(BytesUtil.java:225)
at
org.apache.kylin.metadata.filter.ConstantTupleFilter.serialize(ConstantTupleFilter.java:87)
at
org.apache.kylin.metadata.filter.TupleFilterSerializer.serializeFilter(TupleFilterSerializer.java:90)
at
org.apache.kylin.metadata.filter.TupleFilterSerializer.internalSerialize(TupleFilterSerializer.java:82)
at
org.apache.kylin.metadata.filter.TupleFilterSerializer.internalSerialize(TupleFilterSerializer.java:76)
at
org.apache.kylin.metadata.filter.TupleFilterSerializer.internalSerialize(TupleFilterSerializer.java:76)
at
org.apache.kylin.metadata.filter.TupleFilterSerializer.serialize(TupleFilterSerializer.java:55)
at
org.apache.kylin.storage.hbase.coprocessor.CoprocessorFilter.fromFilter(CoprocessorFilter.java:188)
at
org.apache.kylin.storage.hbase.coprocessor.observer.ObserverEnabler.scanWithCoprocessorIfBeneficial(ObserverEnabler.java:68)
at
org.apache.kylin.storage.hbase.CubeSegmentTupleIterator.doScan(CubeSegmentTupleIterator.java:216)
... 104 more
--
View this message in context:
http://apache-kylin.74782.x6.nabble.com/jira-Created-KYLIN-1089-Kylin-failed-to-run-on-CDH-with-HBase-1-0-tp2027p3787.html
Sent from the Apache Kylin mailing list archive at Nabble.com.
