You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@trafodion.apache.org by "Selvaganesan Govindarajan (JIRA)" <ji...@apache.org> on 2017/10/12 21:51:00 UTC

[jira] [Resolved] (TRAFODION-2716) Query compilation gets stuck at listSnapshots() at times

     [ 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)