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

["Dudu Markovitz (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/HIVE-13412?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15256258#comment-15256258 ] 

Dudu Markovitz commented on HIVE-13412:
---------------------------------------

It appears as a general bug (the way '\uxxxx' is treated) and not specific for field terminators


> select ascii('\u0010');
10

-- should have been 16

> External table -  fields terminated by '\u0044' - 0044 is being interpreted as decimal and not hex
> --------------------------------------------------------------------------------------------------
>
>                 Key: HIVE-13412
>                 URL: https://issues.apache.org/jira/browse/HIVE-13412
>             Project: Hive
>          Issue Type: Bug
>          Components: Parser
>    Affects Versions: 0.14.0
>            Reporter: Dudu Markovitz
>            Assignee: Pengcheng Xiong
>
> , (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 ','
> ...



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)