Details

    • Type: Improvement
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 2.1.0
    • Fix Version/s: None
    • Component/s: SQL
    • Labels:
      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
        2.
        Support for double precision data type Sub-task Resolved Zoltan Haindrich
        3.
        Make interval keyword optional while specifying DAY in interval arithmetic Sub-task Closed Zoltan Haindrich
        4.
        E061-14: Search Conditions Sub-task Closed Zoltan Haindrich
        5.
        E061-07 and E061-12: Quantified Comparison Predicates Sub-task Open Unassigned
        6.
        F302-01 and F302-02: INTERSECT DISTINCT and INTERSECT ALL Sub-task Resolved Pengcheng Xiong
        7.
        E071-03: EXCEPT DISTINCT Sub-task Resolved Pengcheng Xiong
        8.
        F304: EXCEPT ALL Sub-task Resolved Pengcheng Xiong
        9.
        F471: Scalar subquery values Sub-task Open Unassigned
        10.
        E061-09: Subqueries in comparison predicate Sub-task Open Unassigned
        11.
        E061-13: Eliminate restrictions that remain on correlated subquery. Sub-task Open Unassigned
        12.
        Support multi-subquery in all cases. Sub-task Open Unassigned
        13.
        Add support for date extract Sub-task Closed Jesus Camacho Rodriguez
        14.
        Introduce || operator Sub-task Closed Zoltan Haindrich
        15.
        Add chr udf Sub-task Resolved Unassigned
        16.
        Add trunc(numeric) udf Sub-task Resolved Chinna Rao Lalam
        17.
        F481: Expanded NULL Predicate Sub-task Open Laszlo Bodor
        18.
        Support integer data type Sub-task Resolved Zoltan Haindrich
        19.
        Allow dec as an alias for decimal Sub-task Closed Ashutosh Chauhan
        20.
        Make cast expressions comply more to sql2011 Sub-task Closed Zoltan Haindrich
        21.
        Support real, double precision and numeric data types Sub-task Resolved Laszlo Bodor
        22.
        Support the MOD function Sub-task Resolved Teddy Choi
        23.
        Support CURRENT_CATALOG and CURRENT_SCHEMA Sub-task Resolved Laszlo Bodor
        24.
        Support standard ARRAY_AGG Sub-task Open Teddy Choi
        25.
        Support regr_* functions Sub-task Resolved Zoltan Haindrich
        26.
        Support character_length and octet_length Sub-task Resolved Teddy Choi
        27.
        Support the all set quantifier Sub-task Resolved Laszlo Bodor
        28.
        Allow empty grouping sets Sub-task Resolved Zoltan Haindrich
        29.
        Support the width_bucket function Sub-task Closed Sahil Takiar
        30.
        Support the named columns join Sub-task Resolved Pengcheng Xiong
        31.
        Allow ALTER TABLE DROP COLUMN Sub-task Open Unassigned
        32.
        Allow the symmetric and asymmetric keywords to the between predicate Sub-task Open Unassigned
        33.
        Support "is [not] distinct from" Sub-task Closed Vineet Garg
        34.
        corr/covar_samp UDAF standard compliance Sub-task Resolved Zoltan Haindrich
        35.
        Support percentile_cont / percentile_disc Sub-task Open Laszlo Bodor
        36.
        Support "unknown" boolean truth value Sub-task Resolved Laszlo Bodor
        37.
        Allow select distinct with group by Sub-task Open Anshuman
        38.
        Support recursive CTEs Sub-task Open Unassigned
        39.
        Standard Table Sampling Sub-task Open Unassigned
        40.
        Support hypothetical set functions and inverse distribution functions as aggregate functions Sub-task Open Unassigned
        41.
        stddev_samp,var_samp standard compliance Sub-task Closed Zoltan Haindrich
        42.
        Rollup of an empty resultset should contain the grouping of the empty grouping set Sub-task Closed Zoltan Haindrich
        43.
        An exception should be raised if the result is outside the range of decimal Sub-task Open Unassigned

          Activity

            People

            • Assignee:
              ashutoshc Ashutosh Chauhan
              Reporter:
              ashutoshc Ashutosh Chauhan
            • Votes:
              0 Vote for this issue
              Watchers:
              20 Start watching this issue

              Dates

              • Created:
                Updated: