Uploaded image for project: 'Apache Trafodion (Retired)'
  1. Apache Trafodion (Retired)
  2. TRAFODION-2716

Query compilation gets stuck at listSnapshots() at times

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • any
    • 2.3
    • sql-exe
    • None

    Description

      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.

      Attachments

        Issue Links

          Activity

            People

              selvag Selvaganesan Govindarajan
              selvag Selvaganesan Govindarajan
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: