[HIVE-13554] [Umbrella] SQL:2011 compliance

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 2.1.0
• Component/s: SQL
• Assignee: Ashutosh Chauhan
• Reporter: Ashutosh Chauhan
• Created: 20/Apr/16 05:59
• Updated: 14/Nov/16 07:07

Description

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

Sub-Tasks

• Add nullif udf: Resolved
• Support for double precision data type: Resolved
• Make interval keyword optional while specifying DAY in interval arithmetic: Closed
• E061-14: Search Conditions: Closed
• Support for non-correlated Quantified Comparison Predicates: Resolved
• F302-01 and F302-02: INTERSECT DISTINCT and INTERSECT ALL: Resolved
• E071-03: EXCEPT DISTINCT: Resolved
• F304: EXCEPT ALL: Resolved
• F471: Scalar subquery values: Open
• E061-09: Subqueries in comparison predicate: Open
• E061-13: Eliminate restrictions that remain on correlated subquery.: Open
• Support multi-subquery in all cases.: Open
• Add support for date extract: Closed
• Introduce || operator: Closed
• Add chr udf: Resolved
• Add trunc(numeric) udf: Resolved
• F481: Expanded NULL Predicate: Open
• Support integer data type: Resolved
• Allow dec as an alias for decimal: Closed
• Make cast expressions comply more to sql2011: Closed
• Support real, double precision and numeric data types: Resolved
• Support the MOD function: Resolved
• Support CURRENT_CATALOG and CURRENT_SCHEMA: Resolved
• Support standard ARRAY_AGG: Open
• Support regr_* functions: Resolved
• Support character_length and octet_length: Resolved
• Support the all set quantifier: Resolved
• Allow empty grouping sets: Resolved
• Support the width_bucket function: Closed
• Support the named columns join: Resolved
• Allow ALTER TABLE DROP COLUMN: Open
• Allow the symmetric and asymmetric keywords to the between predicate: Open
• Support "is [not] distinct from": Closed
• corr/covar_samp UDAF standard compliance: Resolved
• Support percentile_cont / percentile_disc: Resolved
• Support "unknown" boolean truth value: Resolved
• Allow select distinct with group by: Open
• Support recursive CTEs: Open
• Standard Table Sampling: Open
• Support hypothetical set functions and inverse distribution functions as aggregate functions: Open
• stddev_samp,var_samp standard compliance: Closed
• Rollup of an empty resultset should contain the grouping of the empty grouping set: Closed
• An exception should be raised if the result is outside the range of decimal: Open