[ 
https://issues.apache.org/jira/browse/HIVE-1603?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Thejas M Nair resolved HIVE-1603.
---------------------------------
    Resolution: Duplicate

Duplicate of HIVE-7777

> support CSV text file format
> ----------------------------
>
>                 Key: HIVE-1603
>                 URL: https://issues.apache.org/jira/browse/HIVE-1603
>             Project: Hive
>          Issue Type: New Feature
>    Affects Versions: 0.7.0
>            Reporter: Ning Zhang
>
> Comma Separated Values (CSV) text format are commonly used in exchanging 
> relational data between heterogeneous systems. Currently Hive uses TextFile 
> format when displaying query results. This could cause confusions when column 
> values contain new lines or tabs. A CSVTextFile format could get around this 
> problem. This will require a new CSVTextInputFormat, CSVTextOutputFormat, and 
> CSVSerDe. 
> A proposed use case is like:
> {code}
> -- exporting a table to CSV files in a directory
> hive> set hive.io.output.fileformat=CSVTextFile;
> hive> insert overwrite local directory '/tmp/CSVrepos/' select * from S where 
> ... ;
> -- query result in CSV
> hive -e 'set hive.io.output.fileformat=CSVTextFile; select * from T;' | 
> sql_loader_to_other_systems
> -- query CSV files directory from Hive
> hive> create table T (...) stored as CSVTextFile;
> hive> load data local inpath '/my/CSVfiles' into table T;
> hive> select * from T where ...;
> {code}



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

Reply via email to