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

Add LEAD/LAG/FIRST/LAST analytical windowing functions to Hive.

    XMLWordPrintableJSON

    Details

    • Type: New Feature
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 0.11.0
    • Component/s: OLAP, UDF
    • Labels:
      None

      Attachments

      1. HIVE-896.5.patch.txt
        2.30 MB
        Harish Butani
      2. HIVE-896.4.patch
        1.19 MB
        Gunther Hagleitner
      3. hive-896.3.patch.txt
        1.18 MB
        Harish Butani
      4. Hive-896.2.patch.txt
        1.14 MB
        Harish Butani
      5. DataStructs.pdf
        339 kB
        Harish Butani
      6. HIVE-896.1.patch.txt
        614 kB
        Harish Butani

        Issue Links

        is related to

        Bug - A problem which impairs or prevents the functions of the product. HIVE-5087 Rename npath UDF to matchpath

        • Blocker - Blocks development and/or testing work, production could not run
        • Closed
        relates to

        Bug - A problem which impairs or prevents the functions of the product. HIVE-4197 Bring windowing support inline with SQL Standard

        • Major - Major loss of function.
        • Closed

        New Feature - A new feature of the product, which has yet to be developed. HIVE-1304 add row_sequence UDF

        • Major - Major loss of function.
        • Closed
        requires

        Bug - A problem which impairs or prevents the functions of the product. HIVE-4037 Merge a PTFOp for PTF invocation and a PTFOp for Windowing if possible

        • Major - Major loss of function.
        • Open

        Bug - A problem which impairs or prevents the functions of the product. HIVE-3984 Maintain a clear separation between Windowing & PTF at the specification level.

        • Major - Major loss of function.
        • Closed

        Bug - A problem which impairs or prevents the functions of the product. HIVE-3985 Update new UDAFs introduced for Windowing to work with new Decimal Type

        • Major - Major loss of function.
        • Closed

        Bug - A problem which impairs or prevents the functions of the product. HIVE-3986 Fix select expr processing in PTF Operator

        • Major - Major loss of function.
        • Closed

        Bug - A problem which impairs or prevents the functions of the product. HIVE-3987 Update PTF invocation and windowing grammar

        • Major - Major loss of function.
        • Closed

        Bug - A problem which impairs or prevents the functions of the product. HIVE-4028 Bring paranthesis handling in windowing specification in compliance with sql standard

        • Major - Major loss of function.
        • Closed

        Bug - A problem which impairs or prevents the functions of the product. HIVE-4030 Name windowing function in consistence with sql standard

        • Major - Major loss of function.
        • Closed

        Bug - A problem which impairs or prevents the functions of the product. HIVE-4034 Should be able to specify windowing spec without needing Between

        • Major - Major loss of function.
        • Closed

        Bug - A problem which impairs or prevents the functions of the product. HIVE-4035 Column Pruner for PTF Op

        • Major - Major loss of function.
        • Closed

        Bug - A problem which impairs or prevents the functions of the product. HIVE-4036 remove use of FunctionRegistry during PTF Op initialization

        • Major - Major loss of function.
        • Closed

        Bug - A problem which impairs or prevents the functions of the product. HIVE-4041 Support multiple partitionings in a single Query

        • Major - Major loss of function.
        • Closed

        Bug - A problem which impairs or prevents the functions of the product. HIVE-4052 Disallow partition/sort and distribute/order combinations in windowing and partitioning spec

        • Major - Major loss of function.
        • Closed

        Bug - A problem which impairs or prevents the functions of the product. HIVE-4080 Add Lead & Lag UDAFs

        • Major - Major loss of function.
        • Closed

        Bug - A problem which impairs or prevents the functions of the product. HIVE-4081 allow expressions with over clause

        • Major - Major loss of function.
        • Closed

        Bug - A problem which impairs or prevents the functions of the product. HIVE-4040 fix ptf negative tests

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

        New Feature - A new feature of the product, which has yet to be developed. HIVE-4019 Ability to create and drop temporary partition function

        • Major - Major loss of function.
        • Closed

        New Feature - A new feature of the product, which has yet to be developed. HIVE-4048 Allow partition by/order by in partitioning spec in over clause and partition function

        • Major - Major loss of function.
        • Closed

        Task - A task that needs to be done. HIVE-3981 Split up tests in ptf_general_queries.q

        • Major - Major loss of function.
        • Closed

        Task - A task that needs to be done. HIVE-3982 Merge PTFDesc and PTFDef classes

        • Major - Major loss of function.
        • Closed

        Task - A task that needs to be done. HIVE-4031 Add apache headers in new files

        • Major - Major loss of function.
        • Closed
        supercedes

        New Feature - A new feature of the product, which has yet to be developed. HIVE-952 Support analytic NTILE function

        • Major - Major loss of function.
        • Resolved

          Activity

            People

            • Assignee:
              rhbutani Harish Butani
              Reporter:
              aaa Amr Awadallah
            • Votes:
              13 Vote for this issue
              Watchers:
              47 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: