[
https://issues.apache.org/jira/browse/TRAFODION-2716?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Selvaganesan Govindarajan resolved TRAFODION-2716.
--------------------------------------------------
Resolution: Fixed
> 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)
