Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-1549

Add ANSI SQL correlation aggregate function CORR(X,Y).

Log workAgile BoardRank to TopRank to BottomBulk Copy AttachmentsBulk Move AttachmentsVotersWatch issueWatchersCreate sub-taskConvert to sub-taskMoveLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • New Feature
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 0.7.0
    • 0.7.0
    • UDF
    • None
    • Reviewed
    • This CORR udaf is implemented using a stable one-pass algorithm, similar to the one used in the COVAR_POP udaf.

    Description

      Aggregate function that computes the Pearson's coefficient of correlation between a set of number pairs.

      Attachments

        1. HIVE-1549.4.patch
          22 kB
          Pierre Huyn
        2. HIVE-1549.3.patch
          32 kB
          Pierre Huyn
        3. HIVE-1549.2.patch
          32 kB
          Pierre Huyn
        4. HIVE-1549.1.patch
          32 kB
          Pierre Huyn

        Issue Links

        relates to

        Bug - A problem which impairs or prevents the functions of the product. HIVE-3455 ANSI CORR(X,Y) is incorrect

        • Major - Major loss of function.
        • Resolved

        New Feature - A new feature of the product, which has yet to be developed. HIVE-1545 Add a bunch of UDFs and UDAFs

        • Minor - Minor loss of function, or other problem where easy workaround is present.
        • Open

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

          People

            p_huyn Pierre Huyn Assign to me
            p_huyn Pierre Huyn
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Time Tracking

              Estimated:
              Original Estimate - 120h
              120h
              Remaining:
              Remaining Estimate - 120h
              120h
              Logged:
              Time Spent - Not Specified
              Not Specified

              Slack

                Issue deployment