Uploaded image for project: 'Calcite'
  1. Calcite
  2. CALCITE-5827

Add IS_INF and IS_NAN functions (enabled in BigQuery library)

VotersWatch issueWatchersLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • New Feature
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 1.36.0
    • None

    Description

      BigQuery offers the IS_INF and IS_NAN functions. The first returns whether the specified value is infinite, the second returns whether the specified value is NaN.

      Example 1: SELECT IS_INF(3) would return FALSE.
      Example 2: SELECT IS_INF(CAST('Infinity` AS DOUBLE)) would return TRUE.
      Example 3: SELECT IS_NAN(3) would return FALSE.
      Example 4: SELECT IS_INF(CAST('NaN' AS DOUBLE)) would return TRUE.

      Attachments

        Issue Links

        Activity

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

          People

            tanclary Tanner Clary
            tanclary Tanner Clary
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment