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

"Impala Conditional Functions" documentation errata

VotersWatch issueWatchersLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    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

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

          People

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

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment