[FLINK-17965] Hive dialect doesn't properly handle special character escaping with SQL CLI

• Type: Bug
• Status: Closed
• Priority: Blocker
• Resolution: Fixed
• Fix Version/s: 1.11.0
• Component/s: Table SQL / Client
• Labels: pull-request-available
• Assignee: Rui Li
• Reporter: Rui Li
• Created: 27/May/20 11:42
• Updated: 11/Jun/20 06:53
• Resolved: 11/Jun/20 06:51

Description

The following DDL runs fine with table api but doesn't work with sql-client:

create table tbl (x int) row format delimited lines terminated by '\n'

In sql-client, '\' will be escaped and therefore we'll have "\n", instead of new line character, as the line terminator.

Issue Links

• links to: GitHub Pull Request #12378