[jira] [Created] (PHOENIX-1044) Phoenix-Pig: No results returned unless all used columns are selected

["Josh Mahonin (JIRA)" <ji...@apache.org>]

Josh Mahonin created PHOENIX-1044:
-------------------------------------

             Summary: Phoenix-Pig: No results returned unless all used columns are selected
                 Key: PHOENIX-1044
                 URL: https://issues.apache.org/jira/browse/PHOENIX-1044
             Project: Phoenix
          Issue Type: Bug
    Affects Versions: 5.0.0
            Reporter: Josh Mahonin
            Priority: Minor


Not critical, but a bit frustrating:

I'm creating a PhoenixPigConfiguration using via the following:
> conf.setSelectColumns("FOO,BAR")
> conf.setSelectStatement("SELECT FOO, BAR FROM MYTABLE WHERE BAZ=123")

In SQuirrel, that query returns with results, but the going through Pig, it returns nothing.

I also get the same results if I try like so:
> conf.setSelectColumns("FOO,BAR,BAZ")
> conf.setSelectStatement("SELECT FOO, BAR FROM MYTABLE WHERE BAZ=123")

The workaround is to modify the select statement to also include the 'BAZ' column, even though I don't need it for computation:
> conf.setSelectStatement("SELECT FOO, BAR, BAZ FROM MYTABLE WHERE BAZ=123")



--
This message was sent by Atlassian JIRA
(v6.2#6252)