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

Alessandro Solimando commented on HIVE-26655:
---------------------------------------------

No statistics means no CBO, there are many queries failing for non-CBO path.

 

CBO has been around for long time now, with HIVE-25880 it's now possibile to 
disable specific rules in case of issues so there is no need to turn off CBO 
entirely in the presence of bugs.

All this considered, I guess it's time to consider removing the non-CBO path 
and stop supporting it, rather than trying to fix it

 

> TPC-DS query 17 returns wrong results
> -------------------------------------
>
>                 Key: HIVE-26655
>                 URL: https://issues.apache.org/jira/browse/HIVE-26655
>             Project: Hive
>          Issue Type: Sub-task
>            Reporter: Sungwoo Park
>            Priority: Major
>
> When tested with 100GB ORC tables, the number of rows returned by query 17 is 
> not stable. It returns fewer rows than the correct result (55 rows).
>  



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

Reply via email to