[SPARK-28073] ANSI SQL: Character literals

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Resolved
• Affects Version/s: 3.0.0
• Component/s: SQL
• Assignee: Unassigned
• Reporter: Yuming Wang
• Created: 17/Jun/19 05:28
• Updated: 29/Dec/19 00:21
• Resolved: 15/Jul/19 08:35

Description

Feature ID	Feature Name	Feature Description
E021-03	Character literals	— Subclause 5.3, “<literal>”: <quote> [ <character representation>... ] <quote>

Example:

SELECT 'first line' ' - next line' ' - third line' AS "Three lines to one";

Postgresql:https://www.postgresql.org/docs/9.1/features-sql-standard.html

Hive:https://cwiki.apache.org/confluence/display/Hive/Supported+Features%3A+Apache+Hive+2.1