|
|
|
SPARK-37389
|
SPARK-30374
Check unclosed bracketed comments
|
Jiaan Geng
|
Jiaan Geng
|
|
Resolved |
Fixed
|
|
|
|
|
|
|
|
SPARK-35348
|
SPARK-30374
Support the utils for escapse the regex for ANSI SQL: SIMILAR TO ... ESCAPE syntax
|
Unassigned
|
Jiaan Geng
|
|
In Progress |
Unresolved
|
|
|
|
|
|
|
|
SPARK-34382
|
SPARK-30374
ANSI SQL: LATERAL derived table(T491)
|
Allison Wang
|
Yuming Wang
|
|
Resolved |
Fixed
|
|
|
|
|
|
|
|
SPARK-34274
|
SPARK-30374
Improve performance for last_value over unbounded preceding window frame
|
Unassigned
|
Jiaan Geng
|
|
Resolved |
Later
|
|
|
|
|
|
|
|
SPARK-34257
|
SPARK-30374
Improve performance for last_value over unbounded window frame
|
Unassigned
|
Jiaan Geng
|
|
Resolved |
Won't Fix
|
|
|
|
|
|
|
|
SPARK-34096
|
SPARK-30374
Improve performance for nth_value ignore nulls over offset window
|
Jiaan Geng
|
Jiaan Geng
|
|
Resolved |
Fixed
|
|
|
|
|
|
|
|
SPARK-33687
|
SPARK-30374
ANALYZE command support analyze all tables in a specific database
|
Yuming Wang
|
Yuming Wang
|
|
Resolved |
Fixed
|
|
|
|
|
|
|
|
SPARK-33443
|
SPARK-30374
LEAD/LAG should support [ IGNORE NULLS | RESPECT NULLS ]
|
Jiaan Geng
|
Jiaan Geng
|
|
Resolved |
Fixed
|
|
|
|
|
|
|
|
SPARK-33429
|
SPARK-30374
Support drop column in spark also like in postgresql
|
Unassigned
|
jobit mathew
|
|
Open |
Unresolved
|
|
|
|
|
|
|
|
SPARK-33278
|
SPARK-30374
Improve the performance for FIRST_VALUE
|
Jiaan Geng
|
Jiaan Geng
|
|
Resolved |
Fixed
|
|
|
|
|
|
|
|
SPARK-33186
|
SPARK-30374
Respect ANSI standard and change FIRST_VALUE as pure window function.
|
Unassigned
|
Jiaan Geng
|
|
Resolved |
Later
|
|
|
|
|
|
|
|
SPARK-32934
|
SPARK-30374
Improve the performance for NTH_VALUE and Reactor the OffsetWindowFunction
|
Jiaan Geng
|
Jiaan Geng
|
|
Resolved |
Fixed
|
|
|
|
|
|
|
|
SPARK-32777
|
SPARK-30374
Aggregation support aggregate function with multiple foldable expressions.
|
Jiaan Geng
|
Jiaan Geng
|
|
Resolved |
Fixed
|
|
|
|
|
|
|
|
SPARK-32540
|
SPARK-30374
Eliminate filter clause in aggregate
|
Jiaan Geng
|
Jiaan Geng
|
|
Resolved |
Fixed
|
|
|
|
|
|
|
|
SPARK-32498
|
SPARK-30374
Support grant/revoke access privileges like postgresql
|
Unassigned
|
jobit mathew
|
|
Open |
Unresolved
|
|
|
|
|
|
|
|
SPARK-30825
|
SPARK-30374
Add documents information for window function.
|
Jiaan Geng
|
Jiaan Geng
|
|
Resolved |
Fixed
|
|
|
|
|
|
|
|
SPARK-30789
|
SPARK-30374
Support (IGNORE | RESPECT) NULLS for LEAD/LAG/NTH_VALUE/FIRST_VALUE/LAST_VALUE
|
Apache Spark
|
Jiaan Geng
|
|
Resolved |
Fixed
|
|
|
|
|
|
|
|
SPARK-30758
|
SPARK-30374
Spark SQL can't display bracketed comments well in generated golden files
|
Jiaan Geng
|
Jiaan Geng
|
|
Resolved |
Fixed
|
|
|
|
|
|
|
|
SPARK-30734
|
SPARK-30374
AnalysisException that window RangeFrame not match RowFrame
|
Unassigned
|
Jiaan Geng
|
|
Resolved |
Won't Fix
|
|
|
|
|
|
|
|
SPARK-30727
|
SPARK-30374
ANSI SQL: LAST_VALUE function
|
Unassigned
|
Jiaan Geng
|
|
Closed |
Duplicate
|
|
|
|
|
|
|
|
SPARK-30726
|
SPARK-30374
ANSI SQL: FIRST_VALUE function
|
Unassigned
|
Jiaan Geng
|
|
Closed |
Duplicate
|
|
|
|
|
|
|
|
SPARK-30708
|
SPARK-30374
first_value/last_value window function throws ParseException
|
Unassigned
|
Jiaan Geng
|
|
Resolved |
Won't Fix
|
|
|
|
|
|
|
|
SPARK-30707
|
SPARK-30374
Lead/Lag window function throws AnalysisException without ORDER BY clause
|
Unassigned
|
Jiaan Geng
|
|
In Progress |
Unresolved
|
|
|
|
|
|
|
|
SPARK-30472
|
SPARK-30374
[SQL] ANSI SQL: Throw exception on format invalid and overflow when casting String to IntegerType.
|
Unassigned
|
feiwang
|
|
Resolved |
Duplicate
|
|
|
|
|
|
|
|
SPARK-30396
|
SPARK-30374
When there are multiple DISTINCT aggregate expressions acting on different fields, any DISTINCT aggregate expression allows the use of the FILTER clause
|
Unassigned
|
Jiaan Geng
|
|
Resolved |
Duplicate
|
|
|
|
|
|
|
|
SPARK-30395
|
SPARK-30374
When one or more DISTINCT aggregate expressions operate on the same field, the DISTINCT aggregate expression allows the use of the FILTER clause
|
Unassigned
|
Jiaan Geng
|
|
Resolved |
Duplicate
|
|
|
|
|
|
|
|
SPARK-30276
|
SPARK-30374
Support Filter expression allows simultaneous use of DISTINCT
|
Jiaan Geng
|
Jiaan Geng
|
|
Resolved |
Fixed
|
|
|
|
|
|
|
|
SPARK-30220
|
SPARK-30374
Support Filter expression uses IN/EXISTS predicate sub-queries
|
Tanel Kiis
|
Jiaan Geng
|
|
Resolved |
Fixed
|
|
|
|
|
|
|
|
SPARK-30219
|
SPARK-30374
Support Filter expression reference the outer query
|
Unassigned
|
Jiaan Geng
|
|
Open |
Unresolved
|
|
|
|
|
|
|
|
SPARK-30070
|
SPARK-30374
ANSI-F053: Overlaps datetimes predicate support
|
Unassigned
|
Kent Yao 2
|
|
Open |
Unresolved
|
|
|
|
|
|
|
|
SPARK-29941
|
SPARK-30374
Support dec as shorthand for decimal
|
Kent Yao 2
|
Kent Yao 2
|
|
Resolved |
Fixed
|
|
|
|
|
|
|
|
SPARK-29631
|
SPARK-30374
Support ANSI SQL CREATE SEQUENCE
|
Unassigned
|
Takeshi Yamamuro
|
|
Open |
Unresolved
|
|
|
|
|
|
|
|
SPARK-29587
|
SPARK-30374
Real data type is not supported in Spark SQL which is supporting in postgresql
|
Kent Yao 2
|
jobit mathew
|
|
Resolved |
Fixed
|
|
|
|
|
|
|
|
SPARK-29098
|
SPARK-30374
Test both ANSI mode and Spark mode
|
Unassigned
|
Gengliang Wang
|
|
Open |
Unresolved
|
|
|
|
|
|
|
|
SPARK-29096
|
SPARK-30374
The exact math method should be called only when there is a corresponding function in Math
|
Gengliang Wang
|
Gengliang Wang
|
|
Resolved |
Fixed
|
|
|
|
|
|
|
|
SPARK-28909
|
SPARK-30374
ANSI SQL: delete and update does not support in Spark
|
Unassigned
|
ABHISHEK KUMAR GUPTA
|
|
Resolved |
Duplicate
|
|
|
|
|
|
|
|
SPARK-28880
|
SPARK-30374
ANSI SQL: Nested bracketed comments
|
Jiaan Geng
|
Yuming Wang
|
|
Resolved |
Fixed
|
|
|
|
|
|
|
|
SPARK-28682
|
SPARK-30374
ANSI SQL: Collation Support
|
Unassigned
|
Yuming Wang
|
|
Open |
Unresolved
|
|
|
|
|
|
|
|
SPARK-28674
|
SPARK-30374
Spark should support select <columnname> into <table> from <table> where <condition> as PostgreSQL supports
|
Unassigned
|
ABHISHEK KUMAR GUPTA
|
|
Resolved |
Duplicate
|
|
|
|
|
|
|
|
SPARK-28580
|
SPARK-30374
ANSI SQL: unique predicate
|
Unassigned
|
Jiaan Geng
|
|
Open |
Unresolved
|
|
|
|
|
|
|
|
SPARK-28500
|
SPARK-30374
adds support for `filter` clause
|
Unassigned
|
Dylan Guedes
|
|
Resolved |
Duplicate
|
|
|
|
|
|
|
|
SPARK-28447
|
SPARK-30374
ANSI SQL: Unicode escapes in literals
|
Unassigned
|
Yuming Wang
|
|
Open |
Unresolved
|
|
|
|
|
|
|
|
SPARK-28412
|
SPARK-30374
ANSI SQL: OVERLAY function support byte array(T312)
|
Jiaan Geng
|
Jiaan Geng
|
|
Resolved |
Fixed
|
|
|
|
|
|
|
|
SPARK-28410
|
SPARK-30374
ANSI SQL(E021-05): OCTET_LENGTH function
|
Unassigned
|
Jiaan Geng
|
|
Resolved |
Resolved
|
|
|
|
|
|
|
|
SPARK-28377
|
SPARK-30374
Fully support correlation names in the FROM clause
|
Unassigned
|
Yuming Wang
|
|
Open |
Unresolved
|
|
|
|
|
|
|
|
SPARK-28330
|
SPARK-30374
ANSI SQL: Top-level <result offset clause> in <query expression>
|
Jiaan Geng
|
Yuming Wang
|
|
Resolved |
Fixed
|
|
|
|
|
|
|
|
SPARK-28329
|
SPARK-30374
SELECT INTO syntax
|
Unassigned
|
Yuming Wang
|
|
Open |
Unresolved
|
|
|
|
|
|
|
|
SPARK-28328
|
SPARK-30374
Support ANSI SQL:member predicate
|
Unassigned
|
Jiaan Geng
|
|
Open |
Unresolved
|
|
|
|
|
|
|
|
SPARK-28325
|
SPARK-30374
Support ANSI SQL:SIMILAR TO ... ESCAPE syntax
|
Unassigned
|
Jiaan Geng
|
|
In Progress |
Unresolved
|
|
|
|
|
|
|
|
SPARK-28322
|
SPARK-30374
DIV support decimal type
|
Marco Gaido
|
Yuming Wang
|
|
Resolved |
Fixed
|
|
|
|
|
|
|
|
SPARK-28083
|
SPARK-30374
Support ANSI SQL: LIKE ... ESCAPE syntax
|
Jiaan Geng
|
Yuming Wang
|
|
Resolved |
Fixed
|
|
|
|
|
|
|
|
SPARK-28077
|
SPARK-30374
ANSI SQL: OVERLAY function(T312)
|
Jiaan Geng
|
Yuming Wang
|
|
Resolved |
Fixed
|
|
|
|
|
|
|
|
SPARK-28073
|
SPARK-30374
ANSI SQL: Character literals
|
Unassigned
|
Yuming Wang
|
|
Resolved |
Resolved
|
|
|
|
|
|
|
|
SPARK-27986
|
SPARK-30374
Support Aggregate Expressions with filter
|
Jiaan Geng
|
Yuming Wang
|
|
Resolved |
Fixed
|
|
|
|
|
|
|
|
SPARK-27951
|
SPARK-30374
ANSI SQL: NTH_VALUE function
|
Jiaan Geng
|
Zhu, Lipeng
|
|
Resolved |
Fixed
|
|
|
|
|
|
|
|
SPARK-27924
|
SPARK-30374
Support ANSI SQL Boolean-Predicate syntax
|
Jiaan Geng
|
Yuming Wang
|
|
Resolved |
Fixed
|
|
|
|
|
|
|
|
SPARK-27877
|
SPARK-30374
ANSI SQL: LATERAL derived table(T491)
|
Unassigned
|
Yuming Wang
|
|
Closed |
Won't Fix
|
|
|
|
|
|
|
|
SPARK-27149
|
SPARK-30374
Support LOCALTIMESTAMP when ANSI mode enabled
|
Unassigned
|
Takeshi Yamamuro
|
|
Resolved |
Won't Fix
|
|
|
|
|
|
|
|
SPARK-27148
|
SPARK-30374
Support CURRENT_TIME and LOCALTIME when ANSI mode enabled
|
Unassigned
|
Takeshi Yamamuro
|
|
Resolved |
Later
|
|
|
|
|
|
|
|
SPARK-26976
|
SPARK-30374
Forbid reserved keywords as identifiers when ANSI mode is on
|
Takeshi Yamamuro
|
Takeshi Yamamuro
|
|
Resolved |
Fixed
|
|
|
|
|
|
|
|
SPARK-26218
|
SPARK-30374
Throw exception on overflow for integers
|
Marco Gaido
|
Marco Gaido
|
|
Resolved |
Fixed
|
|
|
|
|
|
|
|
SPARK-26215
|
SPARK-30374
define reserved keywords after SQL standard
|
Takeshi Yamamuro
|
Wenchen Fan
|
|
Resolved |
Fixed
|
|
|
|
|
|
|
|
SPARK-24497
|
SPARK-30374
ANSI SQL: Recursive query
|
Unassigned
|
Yuming Wang
|
|
In Progress |
Unresolved
|
|
|
|
|
|
|
|
SPARK-23179
|
SPARK-30374
Support option to throw exception if overflow occurs during Decimal arithmetic
|
Marco Gaido
|
Marco Gaido
|
|
Resolved |
Fixed
|
|
|
|
|
|
|
|
SPARK-19799
|
SPARK-30374
Support WITH clause in subqueries
|
Peter Toth
|
Giambattista
|
|
Resolved |
Fixed
|
|
|
|
|