[jira] [Commented] (PHOENIX-727) UPSERT SELECT does not work with JOIN

["Zhuofu Chen (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/PHOENIX-727?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16216222#comment-16216222 ] 

Zhuofu Chen commented on PHOENIX-727:
-------------------------------------

May I know where is the patch?

> UPSERT SELECT does not work with JOIN
> -------------------------------------
>
>                 Key: PHOENIX-727
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-727
>             Project: Phoenix
>          Issue Type: Task
>    Affects Versions: 3.0-Release
>            Reporter: Nitin Kumar
>            Assignee: Maryann Xue
>
> Issue:-
> Upsert select didn't work with join . :-(
> UPSERT INTO ATTRIBUTE(ENTITY,ATTRIBUTE) select EM.entity,EM.EVCOL_NO_OF_PARTS from EVENT_MANAGEMENT EM(EVCOL_NO_OF_PARTS INTEGER,EVCOL_STANDARD_COST FLOAT,EVCOL_INVENTORY INTEGER,EVCOL_TYPE VARCHAR) INNER JOIN TEMPENTITY MA ON EM.EVENTTIME = MA.EVENTTIME AND EM.ENTITY = MA.ENTITY;
> Error: Joins not supported (state=,code=0)
> But select worked.
>  select EM.entity,EM.EVCOL_NO_OF_PARTS from EVENT_MANAGEMENT EM(EVCOL_NO_OF_PARTS INTEGER,EVCOL_STANDARD_COST FLOAT,EVCOL_INVENTORY INTEGER,EVCOL_TYPE VARCHAR) INNER JOIN TEMPENTITY MA ON EM.EVENTTIME = MA.EVENTTIME AND EM.ENTITY = MA.ENTITY;



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)