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

Bound predicates optimization doesn't work for InlineView

Attach filesAttach ScreenshotVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • Impala 3.0, Impala 2.12.0, Impala 3.1.0, Impala 3.2.0, Impala 3.3.0
    • Impala 3.4.0
    • Frontend
    • None
    • ghx-label-4

    Description

      Tables for test:

       

      CREATE TABLE test_a (
      id STRING,
      val STRING
      );
      
      CREATE TABLE test_b (
      id STRING,
      val STRING
      );
      
      

       

       

      Bound predicates optimization (implement in Analyzer::getBoundPredicates) works for this sql:

       

      EXPLAIN
      SELECT count(*) FROM test_a a
      LEFT JOIN
      (SELECT * FROM test_b) b
      ON a.id=b.id
      WHERE upper(b.val)='123';

       

      But does't work for this one:

       

      EXPLAIN
      SELECT count(*) FROM test_a a
      LEFT JOIN
      (SELECT *, upper(val) AS upper_val FROM test_b) b
      ON a.id=b.id
      WHERE upper_val='123';
      

       

      Attachments

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            xqhe Xianqing He
            cfreely Fu Lili
            Votes:
            7 Vote for this issue
            Watchers:
            8 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment