[jira] [Resolved] (TRAFODION-1535) Explain and RMS statistics output are not in sync when the vsbb is chosen for Insert/Upsert command

["Selvaganesan Govindarajan (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/TRAFODION-1535?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Selvaganesan Govindarajan resolved TRAFODION-1535.
--------------------------------------------------
    Resolution: Fixed

> Explain and RMS statistics output are not in sync when the vsbb is chosen for Insert/Upsert command
> ---------------------------------------------------------------------------------------------------
>
>                 Key: TRAFODION-1535
>                 URL: https://issues.apache.org/jira/browse/TRAFODION-1535
>             Project: Apache Trafodion
>          Issue Type: Bug
>            Reporter: Selvaganesan Govindarajan
>   Original Estimate: 24h
>  Remaining Estimate: 24h
>
> When a VSBB operation is chosen for insert operations, the explain output may not show it as VSBB. VSBB operation is chosen for index maintenance even when insert command is used and it is not reflected in the explain output.
> Sometimes a VSBB operation is seen in the explain output for upsert command, but the execution is not done in VSBB mode. Upsert into a table using transpose clause command.
> This makes it difficult to analyze the query plans for performance issues.
> VSBB is nothing but using hbase batch operations like List<Put> and List<Delete> .
> This problem was seen when trying to analyze the trafodion performance for the trickle load.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)