[
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)
