phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sergey Soldatov (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (PHOENIX-727) UPSERT SELECT does not work with JOIN
Date Tue, 24 Oct 2017 05:25:00 GMT

    [ 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 <maryannxue@apache.org>
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)

Mime
View raw message