[TAJO-895] ConstEval should not be included in target list of projectable nodes

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.9.0
• Component/s: Planner/Optimizer
• Assignee: Hyunsik Choi
• Reporter: Hyunsik Choi
• Created: 29/Jun/14 04:02
• Updated: 13/Aug/14 05:07
• Resolved: 13/Aug/14 04:47

Description

In some applications, aliased constant values can be used in WHERE, GROUP BY, HAVING, ORDER BY clauses. For those cases, current planner evaluates constant value in target list of projectable nodes.

SELECT '1994' end as year, ... FROM lineitem WHERE group by year;

This approach works well so far, but there are rooms for significant improvement.

The main problem is that constant target requires many workaround code in NamedExprManager, and TargetListManager. As a result, it makes code complexity higher. The second problem is that many constant values evaluated in each row consume unnecessary I/O and network bandwidth for storing and transmitting.

The solution seems to be simple. In logical planning phase, we should rewrite column references which actually indicates constant values.

Issue Links

• is related to: TAJO-914 join queries with constant values can cause schema mismatch in logical plan