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

[Umbrella] SQL:2011 compliance

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

Details

    • Improvement
    • Status: Open
    • Major
    • Resolution: Unresolved
    • 2.1.0
    • None
    • SQL
    • None

    Description

      There are various gaps in language which needs to be addressed to bring Hive under SQL:2011 compliance

      Attachments

        1.
        Add nullif udf Sub-task Resolved Zoltan Haindrich   Actions
        2.
        Support for double precision data type Sub-task Resolved Zoltan Haindrich   Actions
        3.
        Make interval keyword optional while specifying DAY in interval arithmetic Sub-task Closed Zoltan Haindrich   Actions
        4.
        E061-14: Search Conditions Sub-task Closed Zoltan Haindrich   Actions
        5.
        Support for non-correlated Quantified Comparison Predicates Sub-task Closed Vineet Garg

        100%

        Original Estimate - Not Specified Original Estimate - Not Specified
        Time Spent - 2h 10m
        Actions
        6.
        F302-01 and F302-02: INTERSECT DISTINCT and INTERSECT ALL Sub-task Resolved Pengcheng Xiong   Actions
        7.
        E071-03: EXCEPT DISTINCT Sub-task Resolved Pengcheng Xiong   Actions
        8.
        F304: EXCEPT ALL Sub-task Resolved Pengcheng Xiong   Actions
        9.
        F471: Scalar subquery values Sub-task Open Unassigned   Actions
        10.
        E061-09: Subqueries in comparison predicate Sub-task Open Unassigned   Actions
        11.
        E061-13: Eliminate restrictions that remain on correlated subquery. Sub-task Open Unassigned   Actions
        12.
        Support multi-subquery in all cases. Sub-task Open Unassigned   Actions
        13.
        Add support for date extract Sub-task Closed Jesús Camacho Rodríguez   Actions
        14.
        Introduce || operator Sub-task Closed Zoltan Haindrich   Actions
        15.
        Add chr udf Sub-task Resolved Unassigned   Actions
        16.
        Add trunc(numeric) udf Sub-task Resolved Chinna Rao Lalam   Actions
        17.
        F481: Expanded NULL Predicate Sub-task Open Unassigned   Actions
        18.
        Support integer data type Sub-task Resolved Zoltan Haindrich   Actions
        19.
        Allow dec as an alias for decimal Sub-task Closed Ashutosh Chauhan   Actions
        20.
        Make cast expressions comply more to sql2011 Sub-task Closed Zoltan Haindrich   Actions
        21.
        Support real, double precision and numeric data types Sub-task Closed László Bodor   Actions
        22.
        Support the MOD function Sub-task Resolved Teddy Choi   Actions
        23.
        Support CURRENT_CATALOG and CURRENT_SCHEMA Sub-task Closed László Bodor   Actions
        24.
        Support standard ARRAY_AGG Sub-task Open Teddy Choi   Actions
        25.
        Support regr_* functions Sub-task Resolved Zoltan Haindrich   Actions
        26.
        Support character_length and octet_length Sub-task Resolved Teddy Choi   Actions
        27.
        Support the all set quantifier Sub-task Resolved László Bodor   Actions
        28.
        Allow empty grouping sets Sub-task Resolved Zoltan Haindrich   Actions
        29.
        Support the width_bucket function Sub-task Closed Sahil Takiar   Actions
        30.
        Support the named columns join Sub-task Resolved Pengcheng Xiong   Actions
        31.
        Allow ALTER TABLE DROP COLUMN Sub-task Open Unassigned   Actions
        32.
        Allow the symmetric and asymmetric keywords to the between predicate Sub-task Open Unassigned   Actions
        33.
        Support "is [not] distinct from" Sub-task Closed Vineet Garg   Actions
        34.
        corr/covar_samp UDAF standard compliance Sub-task Resolved Zoltan Haindrich   Actions
        35.
        Support percentile_cont / percentile_disc Sub-task Closed László Bodor   Actions
        36.
        Support "unknown" boolean truth value Sub-task Closed László Bodor   Actions
        37.
        Allow select distinct with group by Sub-task Open Anshuman   Actions
        38.
        Support recursive CTEs Sub-task Open Unassigned   Actions
        39.
        Standard Table Sampling Sub-task Open Unassigned   Actions
        40.
        Support hypothetical set functions and inverse distribution functions as aggregate functions Sub-task Open Unassigned   Actions
        41.
        stddev_samp,var_samp standard compliance Sub-task Closed Zoltan Haindrich   Actions
        42.
        Rollup of an empty resultset should contain the grouping of the empty grouping set Sub-task Closed Zoltan Haindrich   Actions
        43.
        An exception should be raised if the result is outside the range of decimal Sub-task Open Unassigned   Actions

        Activity

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

          People

            ashutoshc Ashutosh Chauhan Assign to me
            ashutoshc Ashutosh Chauhan

            Dates

              Created:
              Updated:

              Time Tracking

              Estimated:
              Original Estimate - Not Specified
              Not Specified
              Remaining:
              Remaining Estimate - 0h
              0h
              Logged:
              Time Spent - 2h 10m
              2h 10m

              Slack

                Issue deployment