[jira] [Created] (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>]

Selvaganesan Govindarajan created TRAFODION-1535:
----------------------------------------------------

             Summary: 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


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)