[ 
https://issues.apache.org/jira/browse/HIVE-21090?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

hunshenshi updated HIVE-21090:
------------------------------
    Description: 
If log level is debug,  sql like `select * from table where partition='xx' and 
condition='xx'` ,

the CBO will fail.

 

I find it case by
{code:java}
LOG.debug("Plan After Join Reordering:\n"
+ RelOptUtil.toString(calciteOptimizedPlan, SqlExplainLevel.ALL_ATTRIBUTES));
{code}
in CalcitePlanner.java

 

delete
{code:java}
SqlExplainLevel.ALL_ATTRIBUTES {code}
 , will be all rigth.

  was:
If log level is debug,  sql like `select * from table where partition='xx' and 
condition='xx'` ,

the CBO will fail.

 

I find it case by `

LOG.debug("Plan After Join Reordering:\n"
 + RelOptUtil.toString(calciteOptimizedPlan, SqlExplainLevel.ALL_ATTRIBUTES));

` in CalcitePlanner.java

 

delete `SqlExplainLevel.ALL_ATTRIBUTES` , will be all rigth.

 


> If log level is debug, CBO will fail
> ------------------------------------
>
>                 Key: HIVE-21090
>                 URL: https://issues.apache.org/jira/browse/HIVE-21090
>             Project: Hive
>          Issue Type: Bug
>          Components: CBO
>    Affects Versions: 2.3.2, 2.3.4
>            Reporter: hunshenshi
>            Assignee: hunshenshi
>            Priority: Major
>
> If log level is debug,  sql like `select * from table where partition='xx' 
> and condition='xx'` ,
> the CBO will fail.
>  
> I find it case by
> {code:java}
> LOG.debug("Plan After Join Reordering:\n"
> + RelOptUtil.toString(calciteOptimizedPlan, SqlExplainLevel.ALL_ATTRIBUTES));
> {code}
> in CalcitePlanner.java
>  
> delete
> {code:java}
> SqlExplainLevel.ALL_ATTRIBUTES {code}
>  , will be all rigth.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Reply via email to