[jira] [Commented] (PHOENIX-3859) Upsert Select query returning updated count as double than actual value when total count is more than configured mutate batch size

["Geoffrey Jacoby (JIRA)" <ji...@apache.org>]

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

Geoffrey Jacoby commented on PHOENIX-3859:
------------------------------------------

This may be a consequence of PHOENIX-3788. There's a patch up for it but it hasn't been committed yet because of some corner cases [~jamestaylor] wanted addressed. 

> Upsert Select query returning updated count  as double than actual value when total count is more than configured mutate batch size
> -----------------------------------------------------------------------------------------------------------------------------------
>
>                 Key: PHOENIX-3859
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-3859
>             Project: Phoenix
>          Issue Type: Bug
>    Affects Versions: 4.10.0
>            Reporter: Maddineni Sukumar
>            Assignee: Maddineni Sukumar
>            Priority: Minor
>
> If I setup driver with below property props.put(QueryServices.MUTATE_BATCH_SIZE_ATTRIB, Integert.toString(50));
> And load more than 50 rows, for example 60 rows and then run below upsert select query.
> int count = conn.createStatement().executeUpdate("Upsert into TableA select * from TableA");
> Count comes as 120 instead of 60. If I increase batch size to more than 60 and try then it gives proper result as 60. 



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)