-
Type:
Improvement
-
Status: Open
-
Priority:
Major
-
Resolution: Unresolved
-
Affects Version/s: 2.1.0
-
Fix Version/s: None
-
Component/s: SQL
-
Labels:None
There are various gaps in language which needs to be addressed to bring Hive under SQL:2011 compliance
1.
|
F471: Scalar subquery values |
|
Open | Unassigned |
2.
|
E061-09: Subqueries in comparison predicate |
|
Open | Unassigned |
3.
|
E061-13: Eliminate restrictions that remain on correlated subquery. |
|
Open | Unassigned |
4.
|
Support multi-subquery in all cases. |
|
Open | Unassigned |
5.
|
F481: Expanded NULL Predicate |
|
Open | Unassigned |
6.
|
Support standard ARRAY_AGG |
|
Open | Teddy Choi |
7.
|
Allow ALTER TABLE DROP COLUMN |
|
Open | Unassigned |
8.
|
Allow the symmetric and asymmetric keywords to the between predicate |
|
Open | Unassigned |
9.
|
Allow select distinct with group by |
|
Open | Anshuman |
10.
|
Support recursive CTEs |
|
Open | Unassigned |
11.
|
Standard Table Sampling |
|
Open | Unassigned |
12.
|
Support hypothetical set functions and inverse distribution functions as aggregate functions |
|
Open | Unassigned |
13.
|
An exception should be raised if the result is outside the range of decimal |
|
Open | Unassigned |