Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-8057

INFORMATION_SCHEMA filter push down is inefficient

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 1.19.0
    • 1.20.0
    • None

    Description

      WHERE clauses in queries against INFORMATION_SCHEMA do not stop Drill from fetching a schema hierarchy from all enabled storage configs.  This results in abysmal performance when unresponsive data sources are enabled, as reported by users in the Apache Drill Slack channels.

      Attachments

        Issue Links

          Activity

            People

              dzamo James Turton
              dzamo James Turton
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: