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.
              		 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: