[
https://issues.apache.org/jira/browse/TRAFODION-2716?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16128094#comment-16128094
]
ASF GitHub Bot commented on TRAFODION-2716:
-------------------------------------------
GitHub user selvaganesang opened a pull request:
https://github.com/apache/incubator-trafodion/pull/1208
[TRAFODION-2716] Query compilation gets stuck at listSnapshots() at t…
…imes
To reduce the impact on the compilation when there are many snapshots,
call Admin.listSnapshots only when cqd TRAF_TABLE_SNAPSHOT_SCAN is set to
LATEST or SUFFIX.
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/selvaganesang/incubator-trafodion
snapshot_perf_issue
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/incubator-trafodion/pull/1208.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #1208
----
commit eb4b4aaa584291fb8ff8588c423b8854897c9c2a
Author: selvaganesang <[email protected]>
Date: 2017-08-15T23:45:39Z
[TRAFODION-2716] Query compilation gets stuck at listSnapshots() at times
To reduce the impact on the compilation when there are many snapshots,
call Admin.listSnapshots only when cqd TRAF_TABLE_SNAPSHOT_SCAN is set to
LATEST or SUFFIX.
----
> Query compilation gets stuck at listSnapshots() at times
> --------------------------------------------------------
>
> Key: TRAFODION-2716
> URL: https://issues.apache.org/jira/browse/TRAFODION-2716
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-exe
> Affects Versions: any
> Reporter: Selvaganesan Govindarajan
> Assignee: Selvaganesan Govindarajan
> Fix For: 2.3-incubating
>
>
> As part of the query compilation, Admin.listSnapshots() is invoked to get the
> latest snapshot of the table unconditionally. listSnapshots is an expensive
> API to be called wen there are hundreds of snapshots.
> Admin.listTableSnapshots API available in HBase 2.0 can list the snapshots
> for a given table.
> To reduce the impact on the compilation when there are many snapshots, call
> this API only when cqd TRAF_TABLE_SNAPSHOT_SCAN is set to LATEST or SUFFIX.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
