[
https://issues.apache.org/jira/browse/HIVE-560?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12722140#action_12722140
]
Yongqiang He commented on HIVE-560:
-----------------------------------
>From the explan, i think src1.value is pruned, isn't it?
{noformat}
STAGE PLANS:
Stage: Stage-1
Map Reduce
Alias -> Map Operator Tree:
src2
Reduce Output Operator
key expressions:
expr: key
type: string
sort order: +
Map-reduce partition columns:
expr: key
type: string
tag: 1
value expressions:
expr: value
type: string
src1
Reduce Output Operator
key expressions:
expr: key
type: string
sort order: +
Map-reduce partition columns:
expr: key
type: string
tag: 0
value expressions:
expr: key
type: string
Reduce Operator Tree:
Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
0 {VALUE._col0}
1 {VALUE._col1}
Select Operator
expressions:
expr: _col0
type: string
expr: _col3
type: string
Select Operator
expressions:
expr: UDFToInteger(_col0)
type: int
expr: _col1
type: string
File Output Operator
compressed: false
GlobalTableId: 1
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format:
org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest_j1
{noformat}
> column pruning not working with map joins
> -----------------------------------------
>
> Key: HIVE-560
> URL: https://issues.apache.org/jira/browse/HIVE-560
> Project: Hadoop Hive
> Issue Type: Bug
> Components: Query Processor
> Affects Versions: 0.4.0
> Reporter: Namit Jain
> Assignee: Yongqiang He
> Attachments: hive-560-2009-06-19-2.patch, hive-560-2009-06-19-5.patch
>
>
> drop table tst1;
> drop table tst2;
> create table tst1(a1 string, a2 string, a3 string, a4 string);
> create table tst2(b1 string, b2 string, b3 string, b4 string);
> explain select /*+ MAPJOIN(a) */ a.a1, a.a2 from tst1 a join tst2 b ON
> a.a2=b.b2;
> the select is after the join - column pruning is not happening
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.