[
https://issues.apache.org/jira/browse/TRAFODION-2716?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16133352#comment-16133352
]
ASF GitHub Bot commented on TRAFODION-2716:
-------------------------------------------
Github user asfgit closed the pull request at:
https://github.com/apache/incubator-trafodion/pull/1208
> 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)
