[HIVE-7276] BaseSemanticAnalyzer.unescapeSQLString fails to parse Windows like path

• Type: Bug
• Status: Resolved
• Priority: Critical
• Resolution: Cannot Reproduce
• Affects Version/s: 0.13.0
• Component/s: Query Processor, Windows

Environment

Windows Server 2008 R2

• Assignee: Xiaobing Zhou
• Reporter: Xiaobing Zhou
• Created: 24/Jun/14 05:09
• Updated: 01/Nov/14 23:40
• Resolved: 01/Nov/14 23:40

Description

BaseSemanticAnalyzer.unescapeSQLString fails to parse windows-like path, e.g. C:\Users\xzhou\hworks. This will cause a large quantity of queries on windows to fail.

For example, 'C:\Users\xzhou\hworks\workspace\hwx-hive-ws\hive\hcatalog\core\target\tmp\hive-junit-960740885870900' will be parsed as 'C:Usersxzhouhworksworkspacehwx-hive-wshivehcatalogcore arget mphive-junit-960740885870900', since \ is interpreted as start char in unicode string, e.g. \002 for delimiter, and thus swallowed.

\0, \b, \n, \r, \t, \Z, and so on within normal Windows like path will also be swallowed.