[KYLIN-4288] 查询样例数据抛出异常

• Type: Bug
• Status: Closed
• Priority: Blocker
• Resolution: Cannot Reproduce
• Affects Version/s: v2.5.2, v2.6.4
• Component/s: Query Engine

Environment

centOS7.2
jdk-8u191-linux-x64.tar.gz
zookeeper-3.4.5.tar.gz
hadoop-2.7.7.tar.gz
hbase-1.1.1-bin.tar.gz , hbase-1.5.0-bin.tar.gz
apache-hive-1.2.1-bin.tar.gz
apache-kylin-2.5.2-bin-hbase1x.tar.gz , apache-kylin-2.6.4-bin-hbase1x.tar.gz

• Assignee: Liang Geng
• Reporter: zjp
• Created: 10/Dec/19 09:35
• Updated: 29/May/20 03:19
• Resolved: 29/May/20 03:19

Description

感谢您百忙之中路过此地,请帮忙看一下:
cube构建完成后,运行任意语句,查询出现:
No registered coprocessor service found for name CubeVisitService in region KYLIN_QLF9A6GPM7,,1575951985092.4ff8b4d4f0ddcfef105bf518e25a30cb.

从网上查到需要更新coprocessor:
$KYLIN_HOME/bin/kylin.sh org.apache.kylin.storage.hbase.util.DeployCoprocessorCLI $KYLIN_HOME/lib/kylin-coprocessor-*.jar all

原来是用的kylin-2.5.2运行报错:
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)

从网上查到这可能是2.5.2的bug,所以更换kylin版本2.6.4,更换之后,查询依然报错,再次运行
 $KYLIN_HOME/bin/kylin.sh org.apache.kylin.storage.hbase.util.DeployCoprocessorCLI $KYLIN_HOME/lib/kylin-coprocessor-*.jar all

2019-12-10 15:16:35,611 INFO [main] util.DeployCoprocessorCLI:136 : Processed time: 104
2019-12-10 15:16:35,611 INFO [main] util.DeployCoprocessorCLI:137 : Processed tables count: 0
2019-12-10 15:16:35,612 INFO [main] util.DeployCoprocessorCLI:138 : Processed tables: []
2019-12-10 15:16:35,612 ERROR [main] util.DeployCoprocessorCLI:139 : Failed tables count: 0
2019-12-10 15:16:35,612 ERROR [main] util.DeployCoprocessorCLI:140 : Failed tables : []
这个不知道是不是运行成功了,但是查询依然还是报错,尝试过重启,也尝试过更换hbase版本,
hbase1.1.1更换hbase1.5.0后错误依旧存在
No registered coprocessor service found for name CubeVisitService in region KYLIN_QLF9A6GPM7,,1575951985092.4ff8b4d4f0ddcfef105bf518e25a30cb.