[jira] [Work logged] (TRAFODION-3335) DDL takes a longer time when there are many snapshots
[ https://issues.apache.org/jira/browse/TRAFODION-3335?focusedWorklogId=388697=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-388697 ] ASF GitHub Bot logged work on TRAFODION-3335: - Author: ASF GitHub Bot Created on: 18/Feb/20 07:57 Start Date: 18/Feb/20 07:57 Worklog Time Spent: 10m Work Description: Traf-Jenkins commented on issue #1870: [TRAFODION-3335] DDL takes a longer time when there are many snapshots URL: https://github.com/apache/trafodion/pull/1870#issuecomment-587328443 Test Failed. https://jenkins.esgyn.com/job/Check-PR-master/3295/ 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: us...@infra.apache.org Issue Time Tracking --- Worklog Id: (was: 388697) Time Spent: 0.5h (was: 20m) > 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: 0.5h > 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)
[jira] [Work logged] (TRAFODION-3335) DDL takes a longer time when there are many snapshots
[ https://issues.apache.org/jira/browse/TRAFODION-3335?focusedWorklogId=388671=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-388671 ] ASF GitHub Bot logged work on TRAFODION-3335: - Author: ASF GitHub Bot Created on: 18/Feb/20 05:39 Start Date: 18/Feb/20 05:39 Worklog Time Spent: 10m Work Description: Traf-Jenkins commented on issue #1870: [TRAFODION-3335] DDL takes a longer time when there are many snapshots URL: https://github.com/apache/trafodion/pull/1870#issuecomment-587287822 Check Test Started: https://jenkins.esgyn.com/job/Check-PR-master/3295/ 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: us...@infra.apache.org Issue Time Tracking --- Worklog Id: (was: 388671) Time Spent: 20m (was: 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: 20m > 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)
[jira] [Work logged] (TRAFODION-3335) DDL takes a longer time when there are many snapshots
[ https://issues.apache.org/jira/browse/TRAFODION-3335?focusedWorklogId=388670=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: us...@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)
[jira] [Created] (TRAFODION-3335) DDL takes a longer time when there are many snapshots
Selvaganesan Govindarajan created TRAFODION-3335: Summary: 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 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)
