[HIVE-13412] External table - fields terminated by '\u0044' - 0044 is being interpreted as decimal and not hex

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: 0.14.0
• Component/s: Parser
• Assignee: Pengcheng Xiong
• Reporter: Dudu Markovitz
• Created: 02/Apr/16 07:51
• Updated: 01/Jun/16 20:43
• Resolved: 01/Jun/16 20:43

Description

, (comma) as the decimal value of '44' and hex value of '2c'
In the following example I'm using '\u0044' as delimiter which is being interpreted as comma.

hive> create external table test_delimiter_dec_unicode (c1 int,c2 int,c3 int) row format delimited fields terminated by '\u0044';
OK
Time taken: 0.035 seconds
hive> show create table test_delimiter_dec_unicode;
OK
CREATE EXTERNAL TABLE `test_delimiter_dec_unicode`(
`c1` int,
`c2` int,
`c3` int)
ROW FORMAT DELIMITED
FIELDS TERMINATED BY ','
...

Issue Links

• duplicates: HIVE-13434 BaseSemanticAnalyzer.unescapeSQLString doesn't unescape \u0000 style character literals.