Hi, Is there any way we can see/get the cost(CPU & I/O units) of the optimized Hive query plan. Once the query is submitted, it gets parsed, multiple plans gets generated, costs get associated with each plan and finally "the lowest cost plan" gets selected before execution. We were looking at couple of places in git like "hive<https://github.com/apache/hive>/ql<https://github.com/apache/hive/tree/master/ql>/src<https://github.com/apache/hive/tree/master/ql/src>/java<https://github.com/apache/hive/tree/master/ql/src/java>/org<https://github.com/apache/hive/tree/master/ql/src/java/org>/apache<https://github.com/apache/hive/tree/master/ql/src/java/org/apache>/hadoop<https://github.com/apache/hive/tree/master/ql/src/java/org/apache/hadoop>/hive<https://github.com/apache/hive/tree/master/ql/src/java/org/apache/hadoop/hive>/ql<https://github.com/apache/hive/tree/master/ql/src/java/org/apache/hadoop/hive/ql>/optimizer<https://github.com/apache/hive/tree/master/ql/src/java/org/apache/hadoop/hive/ql/optimizer>/calcite/" and not able to find the cost of the lowest cost execution plan. Pl help.
Regards, Vijaya Chander +91 953 538 7755
