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.
        Support for non-correlated Quantified Comparison Predicates Sub-task Resolved Vineet Garg

        100%

        Original Estimate - Not Specified Original Estimate - Not Specified
        Time Spent - 2h 10m
        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 Resolved 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:

                Time Tracking

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