[jira] [Work logged] (TRAFODION-3335) DDL takes a longer time when there are many snapshots
[ https://issues.apache.org/jira/browse/TRAFODION-3335?focusedWorklogId=390383=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-390383 ] ASF GitHub Bot logged work on TRAFODION-3335: - Author: ASF GitHub Bot Created on: 21/Feb/20 01:55 Start Date: 21/Feb/20 01:55 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 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: 390383) Time Spent: 1h 50m (was: 1h 40m) > 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: 1h 50m > 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=390340=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-390340 ] ASF GitHub Bot logged work on TRAFODION-3335: - Author: ASF GitHub Bot Created on: 21/Feb/20 00:44 Start Date: 21/Feb/20 00:44 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-589443579 Test Passed. https://jenkins.esgyn.com/job/Check-PR-master/3298/ 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: 390340) Time Spent: 1h 40m (was: 1.5h) > 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: 1h 40m > 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=390297=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-390297 ] ASF GitHub Bot logged work on TRAFODION-3335: - Author: ASF GitHub Bot Created on: 20/Feb/20 22:27 Start Date: 20/Feb/20 22:27 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-589382995 New Check Test Started: https://jenkins.esgyn.com/job/Check-PR-master/3298/ 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: 390297) Time Spent: 1.5h (was: 1h 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: 1.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=390264=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-390264 ] ASF GitHub Bot logged work on TRAFODION-3335: - Author: ASF GitHub Bot Created on: 20/Feb/20 21:19 Start Date: 20/Feb/20 21:19 Worklog Time Spent: 10m Work Description: selvaganesang 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-589323514 @sureshsubbiah Can you please review this PR 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: 390264) Time Spent: 1h 20m (was: 1h 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: 1h 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=389863=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-389863 ] ASF GitHub Bot logged work on TRAFODION-3335: - Author: ASF GitHub Bot Created on: 20/Feb/20 09:25 Start Date: 20/Feb/20 09:25 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-588836354 Test Failed. https://jenkins.esgyn.com/job/Check-PR-master/3297/ 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: 389863) Time Spent: 1h 10m (was: 1h) > 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: 1h 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] [Work logged] (TRAFODION-3335) DDL takes a longer time when there are many snapshots
[ https://issues.apache.org/jira/browse/TRAFODION-3335?focusedWorklogId=389823=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-389823 ] ASF GitHub Bot logged work on TRAFODION-3335: - Author: ASF GitHub Bot Created on: 20/Feb/20 07:09 Start Date: 20/Feb/20 07:09 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-588651650 New Check Test Started: https://jenkins.esgyn.com/job/Check-PR-master/3297/ 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: 389823) Time Spent: 1h (was: 50m) > 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: 1h > 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=389746=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-389746 ] ASF GitHub Bot logged work on TRAFODION-3335: - Author: ASF GitHub Bot Created on: 20/Feb/20 02:00 Start Date: 20/Feb/20 02:00 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-588570609 Test Failed. https://jenkins.esgyn.com/job/Check-PR-master/3296/ 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: 389746) Time Spent: 50m (was: 40m) > 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: 50m > 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=389682=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-389682 ] ASF GitHub Bot logged work on TRAFODION-3335: - Author: ASF GitHub Bot Created on: 19/Feb/20 23:51 Start Date: 19/Feb/20 23:51 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-588534956 New Check Test Started: https://jenkins.esgyn.com/job/Check-PR-master/3296/ 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: 389682) Time Spent: 40m (was: 0.5h) > 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: 40m > 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=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)
