[
https://issues.apache.org/jira/browse/HIVE-11666?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14732241#comment-14732241
]
Ferdinand Xu commented on HIVE-11666:
-------------------------------------
I tried this command on both old and new CLI. They are writing to the same
directory. It's different from the non-embedded mode of beeline which writing
to another directory.
For new cli:
{noformat}
# hive
hive> INSERT OVERWRITE LOCAL DIRECTORY 'nullformat' ROW FORMAT DELIMITED NULL
DEFINED AS 'fooNull' SELECT a,b FROM base_tab;
# updatedb
# lodate nullformat
/root/nullformat
/root/nullformat/.000000_0.crc
/root/nullformat/.hive-staging_hive_2015-09-05_19-26-14_798_5420428485676019574-1
/root/nullformat/000000_0
{noformat}
For old cli:
{noformat}
# export USE_DEPRECATED_CLI=true
# hive
hive> INSERT OVERWRITE LOCAL DIRECTORY 'nullformat' ROW FORMAT DELIMITED NULL
DEFINED AS 'fooNull' SELECT a,b FROM base_tab;
# updatedb
# locate nullformat
/root/nullformat
/root/nullformat/.000000_0.crc
/root/nullformat/.hive-staging_hive_2015-09-05_19-39-54_246_7648272724284767960-1
/root/nullformat/000000_0
{noformat}
For beeline non-embedded mode:
{noformat}
# hive
hive> INSERT OVERWRITE LOCAL DIRECTORY 'nullformat' ROW FORMAT DELIMITED NULL
DEFINED AS 'fooNull' SELECT a,b FROM base_tab;
# updatedb
# lodate nullformat
/nullformat
/nullformat/.000000_0.crc
/nullformat/.hive-staging_hive_2015-09-05_18-35-49_882_8027688617678889251-1
/nullformat/000000_0
{noformat}
Based the test case above, we can see no changes for the new cli, comparing
with old cli since it used the embedded mode beeline.
> Discrepency in INSERT OVERWRITE LOCAL DIRECTORY between Beeline and CLI
> -----------------------------------------------------------------------
>
> Key: HIVE-11666
> URL: https://issues.apache.org/jira/browse/HIVE-11666
> Project: Hive
> Issue Type: Sub-task
> Components: CLI, HiveServer2
> Reporter: Chaoyu Tang
>
> Hive CLI writes to local host when INSERT OVERWRITE LOCAL DIRECTORY. But
> Beeline writes to HS2 local directory. For a user migrating from CLI to
> Beeline, it might be a big chance.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
