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/08/15 23:09:00 UTC

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

Selvaganesan Govindarajan created TRAFODION-2716:
----------------------------------------------------

             Summary: 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
            Reporter: Selvaganesan Govindarajan


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)