[jira] [Commented] (HIVE-11666) Discrepency in INSERT OVERWRITE LOCAL DIRECTORY between Beeline and CLI
[ https://issues.apache.org/jira/browse/HIVE-11666?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16334356#comment-16334356 ] Ashok commented on HIVE-11666: -- Hello, Has this been resolved? > 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 >Priority: Major > > 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 (v7.6.3#76005)
[jira] [Commented] (HIVE-11666) Discrepency in INSERT OVERWRITE LOCAL DIRECTORY between Beeline and CLI
[ https://issues.apache.org/jira/browse/HIVE-11666?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=1499#comment-1499 ] Xuefu Zhang commented on HIVE-11666: On the other hand, the described problem for beeline in general exists, similar to its counterpart in "load data local inpath ...". However, this needs some serious discussion as changing it would means backward incompatibility. > 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)
[jira] [Commented] (HIVE-11666) Discrepency in INSERT OVERWRITE LOCAL DIRECTORY between Beeline and CLI
[ https://issues.apache.org/jira/browse/HIVE-11666?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14743800#comment-14743800 ] Yongzhi Chen commented on HIVE-11666: - Based on the discussion, Beeline's two modes can handle all the cases of CLI, so there will be no issue for customer to migrate from cli to beeline. Is that right? > 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)
[jira] [Commented] (HIVE-11666) Discrepency in INSERT OVERWRITE LOCAL DIRECTORY between Beeline and CLI
[ https://issues.apache.org/jira/browse/HIVE-11666?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14744632#comment-14744632 ] Ferdinand Xu commented on HIVE-11666: - Yes, I think so. > 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)
[jira] [Commented] (HIVE-11666) Discrepency in INSERT OVERWRITE LOCAL DIRECTORY between Beeline and CLI
[
https://issues.apache.org/jira/browse/HIVE-11666?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=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/.00_0.crc
/root/nullformat/.hive-staging_hive_2015-09-05_19-26-14_798_5420428485676019574-1
/root/nullformat/00_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/.00_0.crc
/root/nullformat/.hive-staging_hive_2015-09-05_19-39-54_246_7648272724284767960-1
/root/nullformat/00_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/.00_0.crc
/nullformat/.hive-staging_hive_2015-09-05_18-35-49_882_8027688617678889251-1
/nullformat/00_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)
[jira] [Commented] (HIVE-11666) Discrepency in INSERT OVERWRITE LOCAL DIRECTORY between Beeline and CLI
[ https://issues.apache.org/jira/browse/HIVE-11666?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14726609#comment-14726609 ] Ferdinand Xu commented on HIVE-11666: - Hi [~ctang.ma], for the new CLI mode, it actually is the embedded mode for beeline. And it was not able to connect remote server. In another word, HS2 local directory is the same as local host directory. So the question may not exist. Feel free to figure it out if I misunderstand this issue. Thank you! > 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)
