Seth Brogan created PHOENIX-1999:
------------------------------------
Summary: 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
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)
