[ https://issues.apache.org/jira/browse/HIVE-265?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14124876#comment-14124876 ]
Lars Francke commented on HIVE-265: ----------------------------------- I think this is supported using the extended INSERT syntax as of Hive 0.11 https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DML#LanguageManualDML-Writingdataintothefilesystemfromqueries I'll close this for now but feel free to reopen if you think that functionality doesn't cover your request. > Implement COPY TO syntax > ------------------------ > > Key: HIVE-265 > URL: https://issues.apache.org/jira/browse/HIVE-265 > Project: Hive > Issue Type: New Feature > Components: Query Processor > Reporter: Jeff Hammerbacher > > Postgres has a nice syntax for moving data from a file into a table, and vice > versa. It's similar to Hive's "INSERT INTO ... SELECT ..." syntax, but may be > easier to use for Postgres users. In particular, I like the ability to COPY > TO with delimiters specified. This would allow for easy CSV export. > Docs: http://www.postgresql.org/docs/current/interactive/sql-copy.html -- This message was sent by Atlassian JIRA (v6.3.4#6332)