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

Better handling of non-deterministic expressions in predicates

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Major
    • Resolution: Unresolved
    • Impala 2.5.0, Impala 2.6.0, Impala 2.7.0, Impala 2.8.0
    • None
    • Frontend

    Description

      Predicates that contain non-deterministic expressions like rand() or uuid() can sometimes not be correctly assigned and may lead to wrong or unexpected results.

      Examples:

      select * from functional.alltypes where rand() > 10
      select * from functional.alltypes where rand() > year
      select * from functional.alltypes where rand() > int
      

      The examples above looks similar but each provides a different set of challenges. We should decide how to handle those cases more clearly/consistently.

      Attachments

        Activity

          People

            Unassigned Unassigned
            alex.behm Alexander Behm
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated: