Uploaded image for project: 'IMPALA'
  1. IMPALA
  2. IMPALA-3078

Very simple query uses full RUNTIME_FILTER_WAIT_TIME_MS

    XMLWordPrintableJSON

Details

    Description

      Please see below.

      [localhost.localdomain:21000] > use functional;
      Query: use functional
      
      [localhost.localdomain:21000] > SELECT 1
      FROM alltypestiny a1
      RIGHT JOIN alltypestiny a2 ON a2.id = a1.id;
      Query: select 1
      FROM alltypestiny a1
      RIGHT JOIN alltypestiny a2 ON a2.id = a1.id
      +---+
      | 1 |
      +---+
      | 1 |
      | 1 |
      | 1 |
      | 1 |
      | 1 |
      | 1 |
      | 1 |
      | 1 |
      +---+
      Fetched 8 row(s) in 1.45s
      
      [localhost.localdomain:21000] > SET RUNTIME_FILTER_WAIT_TIME_MS=100000;
      RUNTIME_FILTER_WAIT_TIME_MS set to 100000
      
      [localhost.localdomain:21000] > SELECT 1
      FROM alltypestiny a1
      RIGHT JOIN alltypestiny a2 ON a2.id = a1.id;
      Query: select 1
      FROM alltypestiny a1
      RIGHT JOIN alltypestiny a2 ON a2.id = a1.id
      +---+
      | 1 |
      +---+
      | 1 |
      | 1 |
      | 1 |
      | 1 |
      | 1 |
      | 1 |
      | 1 |
      | 1 |
      +---+
      Fetched 8 row(s) in 101.18s
      

      I'm guessing something is wrong because the data is so tiny. What could possibly take 100 seconds? This is on my local machine with nothing else running.

      Version: b9a21432cf1d6c55adfc574f9aff8c5499b1159e

      Attachments

        Activity

          People

            henryr Henry Robinson
            caseyc casey
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: