Hello,

I am using latest (2.6) version of Kylin and I am following instructions from https://kylin.apache.org/docs/tutorial/cube_streaming.html to build a demo streaming cube.

At a BUILD CUBE job, I can see in monitor tab in "Hive Cleanup" step an error occurs by the following java exception:

java.lang.RuntimeException: Failed to read kylin_hive_conf.xml
        at 
org.apache.kylin.common.util.SourceConfigurationUtil.loadXmlConfiguration(SourceConfigurationUtil.java:87)
        at 
org.apache.kylin.common.util.SourceConfigurationUtil.loadHiveConfiguration(SourceConfigurationUtil.java:61)
        at 
org.apache.kylin.common.util.HiveCmdBuilder.<init>(HiveCmdBuilder.java:48)
        at 
org.apache.kylin.source.hive.GarbageCollectionStep.cleanUpIntermediateFlatTable(GarbageCollectionStep.java:61)
        at 
org.apache.kylin.source.hive.GarbageCollectionStep.doWork(GarbageCollectionStep.java:48)
        at 
org.apache.kylin.job.execution.AbstractExecutable.execute(AbstractExecutable.java:165)
        at 
org.apache.kylin.job.execution.DefaultChainedExecutable.doWork(DefaultChainedExecutable.java:70)
        at 
org.apache.kylin.job.execution.AbstractExecutable.execute(AbstractExecutable.java:165)
        at 
org.apache.kylin.job.impl.threadpool.DefaultScheduler$JobRunner.run(DefaultScheduler.java:114)
        at 
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
        at 
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
        at java.lang.Thread.run(Thread.java:748)

Then if I try to run a SQL query in Insight tab the following exception is thrown:

java.lang.RuntimeException: fail to locate kylin.properties
while executing SQL: "select minute_start, count(*), sum(amount),
sum(qty) from streaming_sales_table group by minute_start order by
minute_start LIMIT 50000"

and generally, it seems that it can't find any Kylin configuration files afterwards.

I have set properly JAVA_HOME, HADOOP_HOME, HIVE_HOME, HBASE_HOME, KYLIN_HOME environment variables.

What could be the reason for that?

Reply via email to