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

"Impala Conditional Functions" documentation errata

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • Impala 3.0
    • Impala 3.1.0
    • Docs
    • None
    • ghx-label-1

    Description

      Consider the documentation page Impala Conditional Functions.

      Multiple functions have ambiguous descriptions. For example:

      isfalse(boolean)

      Purpose: Tests if a Boolean expression is false or not. Returns true if so.

      The above is confusing, it essentially means: "Returns true if a Boolean expression is false or not." This obviously means the function always returns false, which is not accurate.

      Reword to say: "Returns true if the expression is false. Returns false if the expression is true or NULL."

      Other ambiguous descriptions:

      istrue(boolean)

      Purpose: Tests if a Boolean expression is true or not. Returns true if so.

      Better: "Returns true if an expression is true. Returns false if the expression is false or NULL."

      Others:

      nonnullvalue(expression)

      Purpose: Tests if an expression (of any type) is NULL or not. Returns false if so.

      Better: "Returns true if the expression is non-null, tase if the expression is null. Same as expression IS NOT NULL."

      nullvalue(expression)

      Purpose: Tests if an expression (of any type) is NULL or not. Returns true if so.

      Better: "Returns true if the expression is NULL, false otherwise. Same as expression IS NULL"

      Attachments

        Issue Links

          Activity

            People

              arodoni Alexandra Rodoni
              Paul.Rogers Paul Rogers
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: