hadoop-hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ning Zhang (JIRA)" <j...@apache.org>
Subject [jira] Created: (HIVE-948) more query plan optimization rules
Date Mon, 23 Nov 2009 20:35:41 GMT
more query plan optimization rules 

                 Key: HIVE-948
                 URL: https://issues.apache.org/jira/browse/HIVE-948
             Project: Hadoop Hive
          Issue Type: Improvement
            Reporter: Ning Zhang

Many query plans are not optimal in that they contain redundant operators. Some examples are
unnecessary select operators (select followed by select, select output being the same as input
etc.). Even though these operators are not very expensive, they could account for around 10%
of CPU time in some simple queries. It seems they are low-hanging fruits that we should pick

BTW, it seems these optimization rules should be added at the last stage of the physical optimization
phase since some redundant operators are added to facilitate physical plan generation. 

This message is automatically generated by JIRA.
You can reply to this email to add a comment to the issue online.

View raw message