[jira] [Assigned] (TAJO-463) ProjectionPushDownRule incorrectly rewrite the output schema of StoreTableNode

["Hyunsik Choi (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/TAJO-463?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Hyunsik Choi reassigned TAJO-463:
---------------------------------

    Assignee: Hyunsik Choi

Thank you Min and DaeMyung for this bug report. I'll dig into this bug.

> ProjectionPushDownRule incorrectly rewrite the output schema of StoreTableNode
> ------------------------------------------------------------------------------
>
>                 Key: TAJO-463
>                 URL: https://issues.apache.org/jira/browse/TAJO-463
>             Project: Tajo
>          Issue Type: Bug
>          Components: planner/optimizer
>            Reporter: Min Zhou
>            Assignee: Hyunsik Choi
>
> When I was implementing CTAS on partitioned table,  I ran into a schema problem if my target column names are different from select clause's output schema.
>  
> {noformat}
> create table tbl (col1 int4, col2 int4, null_col int4) partition by column(key float8)  as select l_orderkey as col1, l_partkey as col2, l_quantity as key from lineitem
> {noformat}
> After debugging,  I found ProjectionPushDownRule would replace StoreTableNode's output schema with its child output schema.
> {noformat}
>   @Override
>   public LogicalNode visitStoreTable(PushDownContext context, LogicalPlan plan, StoreTableNode node,
>                                      Stack<LogicalNode> stack) throws PlanningException {
>     return pushDownCommonPost(context, node, stack);
>   }
>   private LogicalNode pushDownCommonPost(PushDownContext context, UnaryNode node, Stack<LogicalNode> stack)
>       throws PlanningException {
>     stack.push(node);
>     LogicalNode child = visitChild(context, context.plan, node.getChild(), stack);
>     stack.pop();
>     node.setInSchema(child.getOutSchema());
>     node.setOutSchema(child.getOutSchema()); // THIS LINE WILL REWRITE  THE SCHEMA!
>     if (node instanceof Projectable) {
>       pushDownProjectablePost(context, node, isTopmostProjectable(stack));
>     }
>     return node;
>   }
> {noformat}



--
This message was sent by Atlassian JIRA
(v6.1.5#6160)