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

[Umbrella] SQL:2011 compliance

          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