[
https://issues.apache.org/jira/browse/HIVE-621?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Carl Steinbach reopened HIVE-621:
---------------------------------
> Inconsistent reporting of "null" and delimiter across access types
> ------------------------------------------------------------------
>
> Key: HIVE-621
> URL: https://issues.apache.org/jira/browse/HIVE-621
> Project: Hive
> Issue Type: Wish
> Reporter: Adam Kramer
>
> If you INSERT OVERWRITE LOCAL DIRECTORY, you get a bunch of \N fields in your
> output...If you hive -e "SELECT ..." you get a bunch of "null" fields in your
> output. I also recall having seen NULL (in caps) before somewhere, too, but
> maybe I'm dreaming that.
> In any case, it would be nice if this were consistent! Preference: \N
> everywhere.
> Ditto, when you I O L D, your fields are ^A-delimited, but when you SELECT,
> they're ^V (tab)-delimited. It would be nice if this, too, were consistent.
> Preference: tabs everywhere.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira