> So I was hoping of using internal Hive CBO to somehow change the AST >generated for the query somehow.
Hive does have an "explain rewrite" but that prints out the query before CBO runs. For CBO, you need to dig all the way down to the ASTBuilder class and work upwards from there. Perhaps add it as an "explain optimized" (there exists "explain logical", "explain extended" and 2 versions of regular "explain"). Cheers, Gopal
