hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Lars Francke (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-265) Implement COPY TO syntax
Date Sun, 07 Sep 2014 12:02:29 GMT

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

Mime
View raw message