[jira] [Commented] (KYLIN-4876) kylin开启下压后,还是报 No realization found for OLAPContext

["Yaqian Zhang (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/KYLIN-4876?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17295038#comment-17295038 ] 

Yaqian Zhang commented on KYLIN-4876:
-------------------------------------

Hi:
Does this error report appear in kylin.log or in the query result of kylin web page?  If you only find this error in kylin.log, it is normal.
In fact, no matter whether query pushdown is enabled or not, when an SQL fails to hit the cube, NoRealizationFoundException will be reported in the log. However, if query pushdown is enabled, the SQL will continue to be pushed down to the push down engine for query, and then the result will be returned to the kylin query page.

> kylin开启下压后,还是报 No realization found for OLAPContext
> ---------------------------------------------------
>
>                 Key: KYLIN-4876
>                 URL: https://issues.apache.org/jira/browse/KYLIN-4876
>             Project: Kylin
>          Issue Type: Bug
>          Components: Environment , Query Engine
>    Affects Versions: v2.5.0, v3.1.1
>            Reporter: roger wang
>            Priority: Blocker
>             Fix For: v3.1.2
>
>
> kylin在开启查询下压以后,根据文档的步骤,配置了如下配置:
> #### QUERY PUSH DOWN ###
> #
> kylin.query.pushdown.runner-class-name=org.apache.kylin.query.adhoc.PushDownRunnerJdbcImpl
> #
> kylin.query.pushdown.update-enabled=false
> kylin.query.pushdown.jdbc.url=jdbc:hive2://hadoop102:10000/default
> kylin.query.pushdown.jdbc.driver=org.apache.hive.jdbc.HiveDriver
> kylin.query.pushdown.jdbc.username=
> kylin.query.pushdown.jdbc.password=
> #
> kylin.query.pushdown.jdbc.pool-max-total=8
> kylin.query.pushdown.jdbc.pool-max-idle=8
> kylin.query.pushdown.jdbc.pool-min-idle=0
>  
> 执行官网的sql: select max(price) as total_sold from kylin_sales 
> 报错:
> Caused by: org.apache.kylin.metadata.realization.NoRealizationFoundException: No realization found for OLAPContext,
>  



--
This message was sent by Atlassian Jira
(v8.3.4#803005)