[jira] [Work logged] (TRAFODION-3335) DDL takes a longer time when there are many snapshots

["ASF GitHub Bot (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/TRAFODION-3335?focusedWorklogId=388670&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-388670 ]

ASF GitHub Bot logged work on TRAFODION-3335:
---------------------------------------------

                Author: ASF GitHub Bot
            Created on: 18/Feb/20 05:34
            Start Date: 18/Feb/20 05:34
    Worklog Time Spent: 10m 
      Work Description: selvaganesang commented on pull request #1870: [TRAFODION-3335] DDL takes a longer time when there are many snapshots
URL: https://github.com/apache/trafodion/pull/1870
 
 
   Avoided use of the HBaseAdmin.listSnapshots() that causes unnecessary overhead whereever it is possible
   
   HBaseAdmin.listSnapshots will continue to be called when CQD TRAF_TABLE_SNAPSHOT_SCAN is set to 'LATEST'.
   
   Removed latest snapshot name being part of table descriptor and NATable
     Added code to get the latest snapshot at the time of code generation
     It was done unconditionally at times and this was causing performance problems during DDL
        when there are many snapshots in the cluster.
 
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
users@infra.apache.org


Issue Time Tracking
-------------------

            Worklog Id:     (was: 388670)
    Remaining Estimate: 0h
            Time Spent: 10m

> DDL takes a longer time when there are many snapshots
> -----------------------------------------------------
>
>                 Key: TRAFODION-3335
>                 URL: https://issues.apache.org/jira/browse/TRAFODION-3335
>             Project: Apache Trafodion
>          Issue Type: Bug
>          Components: sql-general
>            Reporter: Selvaganesan Govindarajan
>            Assignee: Selvaganesan Govindarajan
>            Priority: Major
>          Time Spent: 10m
>  Remaining Estimate: 0h
>
> When there are many snapshots the HBaseAdmin.listSnapshots can take considerably long time.  There is no method to get the snapshot for a given table name in HBase 1.1. So, it is prudent to avoid using HBaseAdmin.listSnapshots wherever it is possible,



--
This message was sent by Atlassian Jira
(v8.3.4#803005)