[ 
https://issues.apache.org/jira/browse/PIG-989?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12761347#action_12761347
 ] 

Alan Gates commented on PIG-989:
--------------------------------

I agree the error message here is bad.

It is not clear to me that we should do this join though.  It's hard to see why 
people would want to join on two different key types when one of those is 
numeric and one is string.  If they really want that, I think we should require 
an explicit cast, as in most cases I suspect this is a user error rather than 
desired behavior.

> Allow type merge between numerical type and non-numerical type
> --------------------------------------------------------------
>
>                 Key: PIG-989
>                 URL: https://issues.apache.org/jira/browse/PIG-989
>             Project: Pig
>          Issue Type: Bug
>          Components: impl
>    Affects Versions: 0.5.0
>            Reporter: Daniel Dai
>
> Currently, we do not allow type merge between numerical type and 
> non-numerical type. And the error message is confusing. 
> Eg, if you run:
> a = load '1.txt' as (a0:chararray, a1:chararray);
> b = load '2.txt' as (b0:long, b1:chararray);
> c = join a by a0, b by b0;
> dump c;
> And the error message is "ERROR 1051: Cannot cast to Unknown"
> We shall:
> 1. Allow the type merge between numerical type and non-numerical type
> 2. Or at least, provide more meaningful error message to the user

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

Reply via email to