[
https://issues.apache.org/jira/browse/HIVE-602?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12726392#action_12726392
]
Zheng Shao commented on HIVE-602:
---------------------------------
Can you try: hive -S -e "SELECT ..." > filename?
I think this is what you want.
> INSERT LOCAL PIPE '/path/to/program' would be lovely
> ----------------------------------------------------
>
> Key: HIVE-602
> URL: https://issues.apache.org/jira/browse/HIVE-602
> Project: Hadoop Hive
> Issue Type: New Feature
> Components: Query Processor, Server Infrastructure
> Reporter: Adam Kramer
>
> INSERT OVERWRITE LOCAL DIRECTORY is great at what it does, but the output is
> never _instantly_ useful. Why? Because it is a whole bunch of gzipped files.
> It would be lovely if I could tell Hive what it should do with its output
> when inserting into a local directory. For example, to automatically pipe its
> output through something. Really, I want to
> gunzip -c *.gz | perl -p -e 's/\cA/\t/g' > filename
> ...but I would settle for piping every reducer's output through gunzip -c |
> perl -p -e 's/\cA/\t/g' and then having Hive save the result to whatever it
> would have used for a filename but without the .gz.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
