You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "Gabriel Reid (JIRA)" <ji...@apache.org> on 2014/03/16 08:22:53 UTC

[jira] [Resolved] (PHOENIX-815) self-join doesn't work

     [ https://issues.apache.org/jira/browse/PHOENIX-815?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Gabriel Reid resolved PHOENIX-815.
----------------------------------

    Resolution: Fixed

Bulk resolve of closed issues imported from GitHub. This status was reached by first re-opening all closed imported issues and then resolving them in bulk.

> self-join doesn't work
> ----------------------
>
>                 Key: PHOENIX-815
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-815
>             Project: Phoenix
>          Issue Type: Task
>    Affects Versions: 3.0-Release
>            Reporter: alex kamil
>            Assignee: Maryann Xue
>              Labels: bug
>
> using master branch i get the below error while trying to run join on the same table:
> this works (joining 2 tables) : SELECT t.col1 FROM table1 t JOIN table2 m ON t.col1=m.col1;
> this one fails (joining on the same table):
> SELECT t.col1 FROM table1 t JOIN table1 m ON t.col1=m.col1;
> Error: ERROR 1001 (42I01): Undefined column family. familyName=T.null (state=42I01,code=1001)



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