Tim Armstrong created IMPALA-7778:
-------------------------------------

             Summary: RCFile parser ignores escape characters
                 Key: IMPALA-7778
                 URL: https://issues.apache.org/jira/browse/IMPALA-7778
             Project: IMPALA
          Issue Type: Bug
          Components: Backend
    Affects Versions: Impala 3.0, Impala 2.11.0, Impala 2.10.0, Impala 2.9.0, 
Impala 2.8.0, Impala 2.7.0, Impala 2.6.0, Impala 2.4.0, Impala 2.5.0, Impala 
2.3.0, Impala 2.2, Impala 2.1, Impala 2.0, Impala 3.1.0
            Reporter: Tim Armstrong


If an RCFile table has an escape character specified then it is ignored by 
Impala.

{code}
-- HIVE
CREATE TABLE rc_escape ( s string)
ROW FORMAT delimited fields terminated by ','  escaped by '\\'
STORED AS RCFILE;
insert into rc_escape select '\\"';
select length(s), s from rc_escape;
-- +-----+-----+
-- | c0  |  s  |
-- +-----+-----+
-- | 2   | \"  |
-- +-----+-----+

-- IMPALA
invalidate metadata rc_escape;
select length(s), s from rc_escape;
-- +-----------+-----+
-- | length(s) | s   |
-- +-----------+-----+
-- | 3         | \\" |
-- +-----------+-----+
{code}

I reproduced on my dev env with "beeline -n $USER -u 
jdbc:hive2://localhost:11050/default" for Hive and "impala-shell" for Impala.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to