[ https://issues.apache.org/jira/browse/PHOENIX-1999?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14558696#comment-14558696 ]
Prashant Kommireddi commented on PHOENIX-1999: ---------------------------------------------- So if I understand correctly 1.) Table names are case-sensitive; foo is different from FOO 2.) One can specify lower-case by defining the table within quotes. [~maghamraviki...@gmail.com] is it the same with field names as well? And is this the expected behavior/syntax? > 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)