Kylin创建好cube后执行查询语句报错如下:
然后找资料说是,因为做了Hadoop的HA,需要更新HBase的协处理器:
执行的时候报错:
2019-04-15 10:23:55,412 DEBUG [main] cachesync.CachedCrudAssist:118 : Reloading DataModelDesc from kylin_metadata(key='/model_desc')@kylin_metadata@hbase
2019-04-15 10:23:55,445 INFO [main] model.DataModelManager:185 : Model demo1_model1 is missing or unloaded yet
2019-04-15 10:23:55,445 INFO [main] model.DataModelManager:185 : Model demo1_model2 is missing or unloaded yet
2019-04-15 10:23:55,452 INFO [main] model.DataModelManager:185 : Model demo1_model2 is missing or unloaded yet
2019-04-15 10:23:55,453 INFO [main] model.DataModelManager:185 : Model hive_test1_demo1 is missing or unloaded yet
2019-04-15 10:23:55,454 INFO [main] model.DataModelManager:185 : Model hive_test2_demo1 is missing or unloaded yet
2019-04-15 10:23:55,454 INFO [main] model.DataModelManager:185 : Model hive_test1_demo3 is missing or unloaded yet
2019-04-15 10:23:55,456 INFO [main] model.DataModelManager:185 : Model hive_test2_demo1 is missing or unloaded yet
2019-04-15 10:23:55,456 DEBUG [main] cachesync.CachedCrudAssist:127 : Loaded 5 DataModelDesc(s) out of 5 resource
2019-04-15 10:23:55,472 DEBUG [main] cachesync.CachedCrudAssist:127 : Loaded 3 CubeDesc(s) out of 3 resource
2019-04-15 10:23:55,475 DEBUG [main] cachesync.CachedCrudAssist:127 : Loaded 3 CubeInstance(s) out of 3 resource
added new table: KYLIN_A89D8IUEQJ
added new table: KYLIN_JQYGCW0X1B
added new table: KYLIN_LHGP2HCHW0
2019-04-15 10:23:55,475 INFO [main] util.DeployCoprocessorCLI:117 : Identify tables [KYLIN_A89D8IUEQJ, KYLIN_JQYGCW0X1B, KYLIN_LHGP2HCHW0]
2019-04-15 10:23:55,475 INFO [main] util.DeployCoprocessorCLI:129 : Tables after filtering by type all: [KYLIN_A89D8IUEQJ, KYLIN_JQYGCW0X1B, KYLIN_LHGP2HCHW0]
2019-04-15 10:23:55,480 INFO [main] util.DeployCoprocessorCLI:181 : Commit Information: 0e519d859e217fbfadd534313376e532d2c647fa;
2019-04-15 10:23:55,485 INFO [main] util.DeployCoprocessorCLI:191 : Filtered tables don't need to deploy coprocessors: [KYLIN_A89D8IUEQJ, KYLIN_JQYGCW0X1B, KYLIN_LHGP2HCHW0]
2019-04-15 10:23:55,485 INFO [main] util.DeployCoprocessorCLI:132 : Will execute tables []
2019-04-15 10:23:55,485 INFO [main] util.DeployCoprocessorCLI:137 : Old coprocessor jar: []
Exception in thread "main" java.io.FileNotFoundException: /root/all (No such file or directory)
at java.io.FileInputStream.open0(Native Method)
at java.io.FileInputStream.open(FileInputStream.java:195)
at java.io.FileInputStream.<init>(FileInputStream.java:138)
at org.apache.kylin.storage.hbase.util.DeployCoprocessorCLI.uploadCoprocessorJar(DeployCoprocessorCLI.java:455)
at org.apache.kylin.storage.hbase.util.DeployCoprocessorCLI.main(DeployCoprocessorCLI.java:139)
2019-04-15 10:23:55,559 INFO [close-hbase-conn] hbase.HBaseConnection:136 : Closing HBase connections...
2019-04-15 10:23:55,559 INFO [close-hbase-conn] client.ConnectionManager$HConnectionImplementation:2276 : Closing master protocol: MasterService
2019-04-15 10:23:55,559 INFO [close-hbase-conn] client.ConnectionManager$HConnectionImplementation:1847 : Closing zookeeper sessionid=0x369e0f1e2cd8492
2019-04-15 10:23:55,564 INFO [close-hbase-conn] zookeeper.ZooKeeper:684 : Session: 0x369e0f1e2cd8492 closed
2019-04-15 10:23:55,564 INFO [main-EventThread] zookeeper.ClientCnxn:512 : EventThread shut down
2019-04-15 10:23:55,574 INFO [close-hbase-conn] client.ConnectionManager$HConnectionImplementation:2276 : Closing master protocol: MasterService
2019-04-15 10:23:55,578 INFO [close-hbase-conn] client.ConnectionManager$HConnectionImplementation:1847 : Closing zookeeper sessionid=0x369e0f1e2cd8493
2019-04-15 10:23:55,583 INFO [close-hbase-conn] zookeeper.ZooKeeper:684 : Session: 0x369e0f1e2cd8493 closed
2019-04-15 10:23:55,583 INFO [main-EventThread] zookeeper.ClientCnxn:512 : EventThread shut down
我在/root/下没有事没有好到all这个文件夹,这个更新命令也是在官网找来的。。
请教各位大神,谢谢!
执行sql查询报错如下:
org.apache.hadoop.hbase.exceptions.UnknownProtocolException: org.apache.hadoop.hbase.exceptions.UnknownProtocolException: No registered coprocessor service found for name CubeVisitService in region KYLIN_A89D8IUEQJ,,1555293707114.2b06f4a688dd8e3b1c460a02267f395d. at org.apache.hadoop.hbase.regionserver.HRegion.execService(HRegion.java:7972) at org.apache.hadoop.hbase.regionserver.RSRpcServices.execServiceOnRegion(RSRpcServices.java:1986) at org.apache.hadoop.hbase.regionserver.RSRpcServices.execService(RSRpcServices.java:1968) at org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$2.callBlockingMethod(ClientProtos.java:33652) at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2191) at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:112) at org.apache.hadoop.hbase.ipc.RpcExecutor$Handler.run(RpcExecutor.java:183) at org.apache.hadoop.hbase.ipc.RpcExecutor$Handler.run(RpcExecutor.java:163) while executing SQL: "select * from AAUDIT_TEST02 LIMIT 50000"
更新hbase的协处理器:
$KYLIN_HOME/bin/kylin.sh org.apache.kylin.storage.hbase.util.DeployCoprocessorCLI $KYLIN_HOME/lib/kylin-coprocessor-*.jar all
版权声明:本文内容由阿里云实名注册用户自发贡献,版权归原作者所有,阿里云开发者社区不拥有其著作权,亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容,填写侵权投诉表单进行举报,一经查实,本社区将立刻删除涉嫌侵权内容。