Question: how cbo works in hive?
Answer: Hive's Cost-Based Optimizer (CBO) is a core component in Hive's query processing engine. ... The chosen logical plan is then converted by Hive to a physical operator tree, optimized and converted to Tez jobs, and then executed on the Hadoop cluster.