kylin save query error

来源:互联网 发布:英雄无敌3恐怖骑士知乎 编辑:程序博客网 时间:2024/06/03 09:48
HTable 'kylin_hdata_user' already exists
ERROR [http-bio-7070-exec-15] controller.BasicController:44 :
org.apache.hadoop.hbase.regionserver.NoSuchColumnFamilyException: org.apache.hadoop.hbase.regionserver.NoSuchColumnFamilyException:Column family q does not exist in region kylin_hdata_user,,1473476923522.d8cbd1c9c3c41b94ab707f8daf817dcc. in table'kylin_hdata_user', {TABLE_ATTRIBUTES => {METADATA => {'UUID' => 'b897551e-61cc-4501-a55d-2166b3815de0'}}, {NAME => 'a', DATA_BLOCK_ENCODING => 'NONE', BLOOMFILTER => 'ROW', REPLICATION_SCOPE => '0', COMPRESSION => 'NONE', VERSIONS => '1', TTL => 'FOREVER', MIN_VERSIONS => '0', KEEP_DELETED_CELLS => 'FALSE', BLOCKSIZE => '65536', IN_MEMORY => 'true', BLOCKCACHE => 'true'}
        at org.apache.hadoop.hbase.regionserver.HRegion.checkFamily(HRegion.java:7279)
        at org.apache.hadoop.hbase.regionserver.HRegion.get(HRegion.java:6455)
        at org.apache.hadoop.hbase.regionserver.RSRpcServices.get(RSRpcServices.java:1918)
        at org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$2.callBlockingMethod(ClientProtos.java:32201)
        at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2112)
        at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:101)
        at org.apache.hadoop.hbase.ipc.RpcExecutor.consumerLoop(RpcExecutor.java:130)
        at org.apache.hadoop.hbase.ipc.RpcExecutor$1.run(RpcExecutor.java:107)
        at java.lang.Thread.run(Thread.java:745)


        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:322)
        at org.apache.hadoop.hbase.client.HTable$4.call(HTable.java:875)
        at org.apache.hadoop.hbase.client.HTable$4.call(HTable.java:862)
        at org.apache.hadoop.hbase.client.RpcRetryingCaller.callWithRetries(RpcRetryingCaller.java:126)
        at org.apache.hadoop.hbase.client.HTable.get(HTable.java:879)
        at org.apache.hadoop.hbase.client.HTable.get(HTable.java:845)
        at org.apache.kylin.rest.service.QueryService.getQueries(QueryService.java:192)
        at org.apache.kylin.rest.service.QueryService.saveQuery(QueryService.java:129)
        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)


解决:

在hbase shell中

> desc 'kylin_hdata_user'

       发现 families 中没有 q 列族

>disable 'kylin_hdata_user'

>alter  'kylin_hdata_user',{NAME=>'q', VERSIONS>3}}

>enable  'kylin_hdata_user'


0 0