phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "maghamravikiran (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (PHOENIX-1999) Phoenix Pig Loader does not return data when selecting from multiple tables in a query with a join
Date Fri, 22 May 2015 15:54:17 GMT

    [ https://issues.apache.org/jira/browse/PHOENIX-1999?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14556355#comment-14556355
] 

maghamravikiran commented on PHOENIX-1999:
------------------------------------------

[~xakaseanx]
    Can you please try the following and see if the results are coming. It works for me.

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

> 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)

Mime
View raw message