kylin-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Li Yang <liy...@apache.org>
Subject Re: URGENT !!! Help needed - Issue executing query in Kylin
Date Sat, 04 Feb 2017 10:26:09 GMT
The metadata and cube data of Kylin 1.5 and 1.6 are compatible by design.
The upgrade was smooth by copying metadata as our limited tests showed.

Cheers


On Sun, Jan 29, 2017 at 9:45 AM, Manoj Jain <mjain@zaloni.com> wrote:

> Thanks for your input. We are able to install Kylin 1.6 successfully on
> CDH 5.9 and able to execute the queries.
>
> We have created a separate folder and hbase metadata for the kylin 1.6.
>
> Is it ok to copy the Kylin 1.5 meta-data and hbase tables on Kylin 1.6
> folders? By doing so I don’t have to rebuild the cubes in kylin 1.6. Please
> confirm if this approach will work.
>
> Thanks,
> Manoj Jain
>
> > On Jan 27, 2017, at 8:37 AM, liuyiming.vip@gmail.com wrote:
> >
> >
> >
> > For item a), correct. In your case, I think this is the root cause.
> >
> > For item b), if the latest kylin could not work for the newer CDH, the
> older one could not work either definetly. The dev team has no resource to
> verify CDH5.9 yet. There is no special APIs used for CDH5.7+. So the CDH
> release should work for you.
> >
> >
> >
> >
> >
> > Yiming Liu
> >
> >
> >
> >
> >
> >
> > 发件人: Manoj Jain
> >
> > 发送时间: 1月27日 星期五 20:48
> >
> > 主题: Re: URGENT !!! Help needed - Issue executing query in Kylin
> >
> > 收件人: user@kylin.apache.org
> >
> > 抄送: dev@kylin.apache.org, Sudeep Dey, Raja Tallapaneni, Sanjeev Singh
> >
> >
> >
> > Thanks for your quick response. Need few clarification:
> >
> >
> >
> > a)  "When you upgrade, please follow the upgrade instructuon, such as
> redeploy the coprocessor jar.” - I believe you are saying when we upgrade
> the kylin version, we need to redeploy the coprocessor jar. Confirm my
> understanding.
> >
> >
> >
> > b) We plan to deploy the newer version of the Kylin. However, the new
> Kylin version does not mention compatibility with CDH 5.9.
> >
> >
> > I need your advice whether we upgrade to newer version of Kylin or apply
> some patch that will resolve the current issue.
> >
> >
> >
> > http://kylin.apache.org/download/
> >
> >
> > 1.6.0
> >
> >
> > In this version Kylin has better support for Kafka as data source, read
> blog New NRT Streaming in Apache Kylin.Release NotesSource download:
> apache-kylin-1.6.0-src.tar.gz [asc] [md5]Binary download:for HBase 0.98
> (includes HDP 2.2, CDH 5.2/5.3) - apache-kylin-1.6.0-bin.tar.gz [asc]
> [md5]for HBase 1.x (includes HDP 2.3/2.4, EMR 5.0) -
> apache-kylin-1.6.0-hbase1.x-bin.tar.gz [asc] [md5]for CDH 5.5/5.7/5.8 -
> apache-kylin-1.6.0-cdh5.7-bin.tar.gz [asc] [md5]
> >
> >
> > Thanks,
> >
> >
> > Manoj Jain
> >
> >
> >
> > On Jan 26, 2017, at 11:59 PM, liuyiming.vip@gmail.com wrote:
> >
> >
> >
> > When you upgrade, please follow the upgrade instructuon, such as
> redeploy the coprocessor jar.
> >
> >
> >
> > Yiming Liu
> >
> >
> >
> >
> >
> >
> >
> > On Fri, Jan 27, 2017 at 12:33 PM +0800, "Manoj Jain" <mjain@zaloni.com>
> wrote:
> >
> >
> >
> >
> >
> >
> >
> >
> > We were running klyin 1.5 on CDH 5.7 and was working fine.
> >
> >
> >
> > Post upgrade to CDH 5.9, we are seeing an exception while running the
> queries in Kylin.
> >
> >
> >
> > I have restarted the Kylin 1.5 instance and also build the test cube
> from scratch. The cube built was successful but seeing an exception in the
> Kylin.log when running the queries (in the Kyiin ‘Insight’ tab).
> >
> >
> >
> >  Please help us to resolve this issue at the earliest. Let us know if
> you need any other information.
> >
> >
> >
> > Kylin Version: 1.5.2
> >
> >
> >
> > Excerpts from the Server Environment
> >
> >
> > HBASE_LOG_DIR = /var/log/hbase
> >
> >
> > HBASE_HOME = /opt/cloudera/parcels/CDH-5.9.0-1.cdh5.9.0.p0.21/lib/hbase/
> bin/..
> >
> >
> > HBASE_OPTS = -Xmx268435456 -XX:+HeapDumpOnOutOfMemoryError
> -XX:+UseConcMarkSweepGC -XX:+CMSIncrementalMode -Djava.net.preferIPv4Stack=true
> -Djava.security.auth.login.config=/etc/hbase/conf/jaas.conf
> -Dhbase.log.dir=/var/log/hbase -Dhbase.log.file=hbase.log
> -Dhbase.home.dir=/opt/cloudera/parcels/CDH-5.9.0-1.
> cdh5.9.0.p0.21/lib/hbase/bin/.. -Dhbase.id.str=hbase
> -Dhbase.root.logger=INFO,console -Djava.library.path=/opt/
> cloudera/parcels/CDH-5.9.0-1.cdh5.9.0.p0.21/lib/hadoop/lib/
> native:/opt/cloudera/parcels/CDH-5.9.0-1.cdh5.9.0.p0.21/
> lib/hbase/bin/../lib/native/Linux-amd64-64 -Dhbase.security.logger=INFO,
> NullAppender
> >
> >
> > HBASE_ENV_INIT = true
> >
> >
> > hbase_dependency = /opt/cloudera/parcels/CDH-5.9.
> 0-1.cdh5.9.0.p0.21/lib/hbase/bin/../lib/hbase-common-1.2.0-cdh5.9.0.jar
> >
> >
> >
> >
> >
> > Kylin log exceprts
> >
> >
> >
> > 2017-01-26 18:33:50,419 INFO  [http-bio-10101-exec-7]
> v2.CubeHBaseRPC:271 : Visiting hbase table KYLIN_XXXXXXXXX: cuboid exact
> match, from 2 to 2 Start: \x00\x00\x00\x00\x00\x0
> >
> >
> > 0\x00\x00\x00\x02\x00 (\x00\x00\x00\x00\x00\x00\x00\x00\x00\x02\x00)
> Stop:  \x00\x00\x00\x00\x00\x00\x00\x00\x00\x02\xFF\x00
> (\x00\x00\x00\x00\x00\x00\x00\x00\x00\x02\xFF\x00),
> >
> >
> > No Fuzzy Key
> >
> >
> > 2017-01-26 18:33:50,419 DEBUG [http-bio-10101-exec-7]
> v2.CubeHBaseEndpointRPC:319 : Submitting rpc to 1 shards starting from
> shard 0, scan range count 1
> >
> >
> > 2017-01-26 18:33:50,419 INFO  [http-bio-10101-exec-7]
> v2.CubeHBaseEndpointRPC:102 : Timeout for ExpectedSizeIterator is: 198000
> >
> >
> > 2017-01-26 18:33:50,420 DEBUG [http-bio-10101-exec-7]
> enumerator.OLAPEnumerator:127 : return TupleIterator...
> >
> >
> > 2017-01-26 18:33:50,430 ERROR [pool-7-thread-5]
> util.LoggableCachedThreadPool:44 : Execution exception when running task
> in pool-7-thread-5
> >
> >
> > 2017-01-26 18:33:50,431 ERROR [pool-7-thread-5]
> util.LoggableCachedThreadPool:54 : Caught exception in thread
> pool-7-thread-5:
> >
> >
> > java.lang.RuntimeException: <sub-thread for GTScanRequest 1c42a42b>
> Error when visiting cubes by endpoint
> >
> >
> >         at org.apache.kylin.storage.hbase.cube.v2.
> CubeHBaseEndpointRPC$1.run(CubeHBaseEndpointRPC.java:344)
> >
> >
> >         at java.util.concurrent.Executors$RunnableAdapter.
> call(Executors.java:471)
> >
> >
> >         at java.util.concurrent.FutureTask.run(FutureTask.java:262)
> >
> >
> >         at java.util.concurrent.ThreadPoolExecutor.runWorker(
> ThreadPoolExecutor.java:1145)
> >
> >
> >         at java.util.concurrent.ThreadPoolExecutor$Worker.run(
> ThreadPoolExecutor.java:615)
> >
> >
> >         at java.lang.Thread.run(Thread.java:745)
> >
> >
> > Caused by: org.apache.hadoop.hbase.DoNotRetryIOException:
> org.apache.hadoop.hbase.DoNotRetryIOException:
> java.lang.NoSuchMethodError: org.apache.hadoop.hbase.coprocessor.
> RegionCoprocessorEnvironment.getRegion()Lorg/apache/hadoop/
> hbase/regionserver/HRegion;
> >
> >
> >         at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:
> 2212)
> >
> >
> >         at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.
> java:109)
> >
> >
> >         at org.apache.hadoop.hbase.ipc.RpcExecutor$Handler.run(
> RpcExecutor.java:185)
> >
> >
> >         at org.apache.hadoop.hbase.ipc.RpcExecutor$Handler.run(
> RpcExecutor.java:165)
> >
> >
> > Caused by: java.lang.NoSuchMethodError: org.apache.hadoop.hbase.
> coprocessor.RegionCoprocessorEnvironment.getRegion()Lorg/apache/hadoop/
> hbase/regionserver/HRegion;
> >
> >
> >         at org.apache.kylin.storage.hbase.cube.v2.coprocessor.
> endpoint.CubeVisitService.visitCube(CubeVisitService.java:177)
> >
> >
> >         at org.apache.kylin.storage.hbase.cube.v2.coprocessor.
> endpoint.generated.CubeVisitProtos$CubeVisitService.callMethod(
> CubeVisitProtos.java:4164)
> >
> >
> >         at org.apache.hadoop.hbase.regionserver.HRegion.
> execService(HRegion.java:7797)
> >
> >
> >         at org.apache.hadoop.hbase.regionserver.RSRpcServices.
> execServiceOnRegion(RSRpcServices.java:1982)
> >
> >
> >         at org.apache.hadoop.hbase.regionserver.RSRpcServices.
> execService(RSRpcServices.java:1964)
> >
> >
> >         at org.apache.hadoop.hbase.protobuf.generated.
> ClientProtos$ClientService$2.callBlockingMethod(ClientProtos.java:33652)
> >
> >
> >         at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:
> 2170)
> >
> >
> >         ... 3 more
> >
> >
> >
> >         at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
> Method)
> >
> >
> >         at sun.reflect.NativeConstructorAccessorImpl.newInstance(
> NativeConstructorAccessorImpl.java:57)
> >
> >
> >         at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(
> DelegatingConstructorAccessorImpl.java:45)
> >
> >
> >         at java.lang.reflect.Constructor.newInstance(Constructor.java:
> 526)
> >
> >
> >         at org.apache.hadoop.ipc.RemoteException.instantiateException(
> RemoteException.java:106)
> >
> >
> >         at org.apache.hadoop.ipc.RemoteException.unwrapRemoteException(
> RemoteException.java:95)
> >
> >
> >         at org.apache.hadoop.hbase.protobuf.ProtobufUtil.
> getRemoteException(ProtobufUtil.java:327)
> >
> >
> >         at org.apache.hadoop.hbase.protobuf.ProtobufUtil.
> execService(ProtobufUtil.java:1631)
> >
> >
> >         at org.apache.hadoop.hbase.ipc.RegionCoprocessorRpcChannel$1.
> call(RegionCoprocessorRpcChannel.java:92)
> >
> >
> >         at org.apache.hadoop.hbase.ipc.RegionCoprocessorRpcChannel$1.
> call(RegionCoprocessorRpcChannel.java:89)
> >
> >
> >         at org.apache.hadoop.hbase.client.RpcRetryingCaller.
> callWithRetries(RpcRetryingCaller.java:126)
> >
> >
> >         at org.apache.hadoop.hbase.ipc.RegionCoprocessorRpcChannel.
> callExecService(RegionCoprocessorRpcChannel.java:95)
> >
> >
> >         at org.apache.hadoop.hbase.ipc.CoprocessorRpcChannel.callMethod(
> CoprocessorRpcChannel.java:56)
> >
> >
> >         at org.apache.kylin.storage.hbase.cube.v2.coprocessor.
> endpoint.generated.CubeVisitProtos$CubeVisitService$Stub.
> visitCube(CubeVisitProtos.java:4225)
> >
> >
> >         at org.apache.kylin.storage.hbase.cube.v2.
> CubeHBaseEndpointRPC$2.call(CubeHBaseEndpointRPC.java:392)
> >
> >
> >         at org.apache.kylin.storage.hbase.cube.v2.
> CubeHBaseEndpointRPC$2.call(CubeHBaseEndpointRPC.java:388)
> >
> >
> >         at org.apache.hadoop.hbase.client.HTable$15.call(HTable.
> java:1797)
> >
> >
> >         ... 4 more
> >
> >
> > Caused by: org.apache.hadoop.hbase.ipc.RemoteWithExtrasException(org.
> apache.hadoop.hbase.DoNotRetryIOException): org.apache.hadoop.hbase.DoNotRetryIOException:
> java.lang.NoSuchMethodError: org.apache.hadoop.hbase.coprocessor.
> RegionCoprocessorEnvironment.getRegion()Lorg/apache/hadoop/
> hbase/regionserver/HRegion;
> >
> >
> >         at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:
> 2212)
> >
> >
> >         at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.
> java:109)
> >
> >
> >         at org.apache.hadoop.hbase.ipc.RpcExecutor$Handler.run(
> RpcExecutor.java:185)
> >
> >
> >         at org.apache.hadoop.hbase.ipc.RpcExecutor$Handler.run(
> RpcExecutor.java:165)
> >
> >
> > Caused by: java.lang.NoSuchMethodError: org.apache.hadoop.hbase.
> coprocessor.RegionCoprocessorEnvironment.getRegion()Lorg/apache/hadoop/
> hbase/regionserver/HRegion;
> >
> >
> >         at org.apache.kylin.storage.hbase.cube.v2.coprocessor.
> endpoint.CubeVisitService.visitCube(CubeVisitService.java:177)
> >
> >
> >         at org.apache.kylin.storage.hbase.cube.v2.coprocessor.
> endpoint.generated.CubeVisitProtos$CubeVisitService.callMethod(
> CubeVisitProtos.java:4164)
> >
> >
> >         at org.apache.hadoop.hbase.regionserver.HRegion.
> execService(HRegion.java:7797)
> >
> >
> >         at org.apache.hadoop.hbase.regionserver.RSRpcServices.
> execServiceOnRegion(RSRpcServices.java:1982)
> >
> >
> >         at org.apache.hadoop.hbase.regionserver.RSRpcServices.
> execService(RSRpcServices.java:1964)
> >
> >
> >         at org.apache.hadoop.hbase.protobuf.generated.
> ClientProtos$ClientService$2.callBlockingMethod(ClientProtos.java:33652)
> >
> >
> >         at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:
> 2170)
> >
> >
> >         ... 3 more
> >
> >
> >
> >         at org.apache.hadoop.hbase.ipc.RpcClientImpl.call(
> RpcClientImpl.java:1269)
> >
> >
> >         at org.apache.hadoop.hbase.ipc.AbstractRpcClient.
> callBlockingMethod(AbstractRpcClient.java:226)
> >
> >
> >         at org.apache.hadoop.hbase.ipc.AbstractRpcClient$
> BlockingRpcChannelImplementation.callBlockingMethod(
> AbstractRpcClient.java:331)
> >
> >
> >         at org.apache.hadoop.hbase.protobuf.generated.
> ClientProtos$ClientService$BlockingStub.execService(
> ClientProtos.java:34118)
> >
> >
> >         at org.apache.hadoop.hbase.protobuf.ProtobufUtil.
> execService(ProtobufUtil.java:1627)
> >
> >
> >         ... 13 more
> >
> >
> >
> >
> >
> > Thanks,
> >
> >
> > Manoj Jain
> >
> >
> >
> >
>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message