[ https://issues.apache.org/jira/browse/PHOENIX-1999?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
maghamravikiran closed PHOENIX-1999. ------------------------------------ > 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)