[SPARK-30374] Feature Parity between PostgreSQL and Spark (ANSI/SQL)

• Type: Umbrella
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 3.0.0
• Component/s: SQL
• Epic Link: ANSI SQL compliance
• Assignee: Unassigned
• Reporter: Takeshi Yamamuro
• Created: 29/Dec/19 00:13
• Updated: 12/Apr/21 13:41

Description

Among the feature parity between Spark/PostgreSQL (SPARK-27764), this umbrella holds issues for the ANSI/SQL standard.

Issue Links

• is related to: SPARK-27764 Feature Parity between PostgreSQL and Spark
• relates to: SPARK-33459 Commonly used Teradata extension syntax
• links to: GitHub Pull Request #27152

Sub-Tasks

• ANSI-F053: Overlaps datetimes predicate support: Open
• Support ANSI SQL CREATE SEQUENCE: Open
• ANSI SQL: Recursive query: In Progress
• Test both ANSI mode and Spark mode: Open
• ANSI SQL: Collation Support: Open
• ANSI SQL: unique predicate: Open
• Support ANSI SQL:SIMILAR TO ... ESCAPE syntax: In Progress
• ANSI SQL: Unicode escapes in literals: Open
• Support ANSI SQL:member predicate: Open
• Support Filter expression reference the outer query: Open
• SELECT INTO syntax: Open
• Fully support correlation names in the FROM clause: Open
• Lead/Lag window function throws AnalysisException without ORDER BY clause: In Progress
• Support grant/revoke access privileges like postgresql: Open
• Support drop column in spark also like in postgresql: Open
• Support the utils for escapse the regex for ANSI SQL: SIMILAR TO ... ESCAPE syntax: In Progress