[ 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)