[
https://issues.apache.org/jira/browse/PHOENIX-727?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16216335#comment-16216335
]
Sergey Soldatov commented on PHOENIX-727:
-----------------------------------------
commit be8c2fb500b017f4b8300f8afd2152aea8a70905
Author: maryannxue <[email protected]>
Date: Tue Jan 28 19:22:32 2014 -0500
Fix UPSERT SELECT does not work with JOIN (github #596)
> 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)
