[jira] [Created] (HIVE-10771) "separatorChar" has no effect in "CREATE TABLE AS SELECT" statement

[Yongzhi Chen (JIRA)]

Yongzhi Chen created HIVE-10771:
-----------------------------------

             Summary: "separatorChar" has no effect in "CREATE TABLE AS SELECT" 
statement
                 Key: HIVE-10771
                 URL: https://issues.apache.org/jira/browse/HIVE-10771
             Project: Hive
          Issue Type: Bug
          Components: Query Planning
            Reporter: Yongzhi Chen
            Assignee: Yongzhi Chen


To replicate:
CREATE TABLE separator_test 
ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.OpenCSVSerde'
WITH SERDEPROPERTIES ("separatorChar" = "|","quoteChar"="\"","escapeChar"="
") 
STORED AS TEXTFILE
AS
SELECT * FROM sample_07;
Then hadoop fs -cat /user/hive/warehouse/separator_test/*
"53-3032","Truck drivers, heavy and tractor-trailer","1693590","37560"
"53-3033","Truck drivers, light or delivery services","922900","28820"
"53-3041","Taxi drivers and chauffeurs","165590","22740"
The separator is till ",", not "|" as specified.



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