[ https://issues.apache.org/jira/browse/HIVE-25792?focusedWorklogId=696599&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-696599 ]
ASF GitHub Bot logged work on HIVE-25792: ----------------------------------------- Author: ASF GitHub Bot Created on: 15/Dec/21 12:54 Start Date: 15/Dec/21 12:54 Worklog Time Spent: 10m Work Description: pvary commented on a change in pull request #2865: URL: https://github.com/apache/hive/pull/2865#discussion_r769598125 ########## File path: ql/src/java/org/apache/hadoop/hive/ql/parse/CalcitePlanner.java ########## @@ -673,8 +672,7 @@ Operator genOPTree(ASTNode ast, PlannerContext plannerCtx) throws SemanticExcept } this.ctx.setCboInfo(cboMsg); - // Determine if we should re-throw the exception OR if we try to mark plan as reAnalyzeAST to retry - // planning as non-CBO. + // Determine if we should re-throw the exception OR if we try to mark the query to retry as non-CBO. Review comment: That was my first implementation, but that messed up with the current query outputs (qfiles). I have tried to throw the ReCompileException (CBOException at that time), and then decide based on the exception. The problem arisen when I had to extract and rethrow the cause of the CBOException if the exception was fatal to provide the same outputs. I have chickened out from that path to keep the existing logic in place. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: gitbox-unsubscr...@hive.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org Issue Time Tracking ------------------- Worklog Id: (was: 696599) Time Spent: 4h 10m (was: 4h) > Multi Insert query fails on CBO path > ------------------------------------- > > Key: HIVE-25792 > URL: https://issues.apache.org/jira/browse/HIVE-25792 > Project: Hive > Issue Type: Bug > Reporter: Zoltan Haindrich > Assignee: Peter Vary > Priority: Major > Labels: pull-request-available > Time Spent: 4h 10m > Remaining Estimate: 0h > > {code} > set hive.cbo.enable=true; > drop table if exists aa1; > drop table if exists bb1; > drop table if exists cc1; > drop table if exists dd1; > drop table if exists ee1; > drop table if exists ff1; > create table aa1 ( stf_id string); > create table bb1 ( stf_id string); > create table cc1 ( stf_id string); > create table ff1 ( x string); > explain > from ff1 as a join cc1 as b > insert overwrite table aa1 select stf_id GROUP BY b.stf_id > insert overwrite table bb1 select b.stf_id GROUP BY b.stf_id > ; > {code} -- This message was sent by Atlassian Jira (v8.20.1#820001)