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

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

    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

            People

              p_huyn Pierre Huyn
              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