You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Yongzhi Chen (JIRA)" <ji...@apache.org> on 2015/05/20 19:47:00 UTC
[jira] [Created] (HIVE-10771) "separatorChar" has no effect in
"CREATE TABLE AS SELECT" statement
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)