You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@hive.apache.org by "Lars Francke (JIRA)" <ji...@apache.org> on 2014/09/07 14:02:29 UTC

[jira] [Commented] (HIVE-265) Implement COPY TO syntax

    [ 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)