hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ning Zhang (JIRA)" <>
Subject [jira] Created: (HIVE-1603) support CSV text file format
Date Fri, 27 Aug 2010 19:39:53 GMT
support CSV text file format

                 Key: HIVE-1603
             Project: Hadoop 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:

-- exporting a table to CSV files in a directory
hive> set;
hive> insert overwrite local directory '/tmp/CSVrepos/' select * from S where ... ;

-- query result in CSV
hive -e 'set; select * from T;' | sql_loader_to_other_systems

This message is automatically generated by JIRA.
You can reply to this email to add a comment to the issue online.

View raw message