[
https://issues.apache.org/jira/browse/HCATALOG-25?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13100768#comment-13100768
]
Ashutosh Chauhan commented on HCATALOG-25:
------------------------------------------
There is a simple workaround for this.
{code}
grunt> d = foreach c generate x as x, y as y;
grunt> describe d;
d: {x: int, y: int}
grunt> store d into 'tbl' using org.apache.hcatalog.pig.HCatStorer();
{code}
> HowlStorer fails on storing data from joined tables
> ---------------------------------------------------
>
> Key: HCATALOG-25
> URL: https://issues.apache.org/jira/browse/HCATALOG-25
> Project: HCatalog
> Issue Type: Bug
> Affects Versions: 0.2
> Reporter: Mac Yang
>
> The following will fail,
> hcat_client -e "create table tbl (x int, y int) stored as RCFILE"
> grunt> a = load 'tbl1' as (x:int);
> grunt> b = load 'tbl2' as (y:int);
> grunt> c = join a by x, b by y;
> grunt> store c into 'tbl' using org.apache.hcatalog.pig.HCatStorer();
> Reason is,
> grunt> describe c;
> {a::x:int, b::y:int}
> After join (or flatten or cross) Pig prepends name of the relation in front
> of aliases, which then fails the validation
> since alias in Howl Table are simply x and y respectively.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira