You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "maghamravikiran (JIRA)" <ji...@apache.org> on 2015/10/06 00:52:27 UTC

[jira] [Resolved] (PHOENIX-1999) Phoenix Pig Loader does not return data when selecting from multiple tables in a query with a join

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

maghamravikiran resolved PHOENIX-1999.
--------------------------------------
    Resolution: Invalid

> Phoenix Pig Loader does not return data when selecting from multiple tables in a query with a join
> --------------------------------------------------------------------------------------------------
>
>                 Key: PHOENIX-1999
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-1999
>             Project: Phoenix
>          Issue Type: Bug
>    Affects Versions: 4.1.0
>         Environment: Pig 0.14.3, Hadoop 2.5.2
>            Reporter: Seth Brogan
>            Assignee: maghamravikiran
>
> The Phoenix Pig Loader does not return data in Pig when selecting specific columns from multiple tables in a join query.
> Example:
> {code}
> DESCRIBE my_table;
> my_table: {a: chararray, my_id: chararray}
> DUMP my_table;
> (abc, 123)
> DESCRIBE join_table;
> join_table: {x: chararray, my_id: chararray}
> DUMP join_table;
> (xyz, 123)
> A = LOAD 'hbase://query/SELECT "t1"."a", "t2"."x" FROM "my_table" AS "t1" JOIN "join_table" AS "t2" ON "t1"."my_id" = "t2"."my_id"' using org.apache.phoenix.pig.PhoenixHBaseLoader('localhost');
> DUMP A;
> (,)
> {code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)