support CSV text file format ---------------------------- Key: HIVE-1603 URL: https://issues.apache.org/jira/browse/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: {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 {code} -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.