You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Damien Carol (JIRA)" <ji...@apache.org> on 2015/06/03 09:19:49 UTC
[jira] [Updated] (HIVE-10902) hive fails on virtual columns when
using any joins
[ https://issues.apache.org/jira/browse/HIVE-10902?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Damien Carol updated HIVE-10902:
--------------------------------
Description:
did the following:
{code:sql}
create table t1(id string);
create table t2(id string);
select t1.INPUT__FILE__NAME
from t1 join t2 on t1.id = t2.id;
{code}
{noformat}
fails on: Execution failed with exit status: 2
{noformat}
notice this happens also on self joins:select t1_1.INPUT__FILE__NAME from t1 t1_1 join t1 t1_2 on t1_1.id = t1_2.id
[HIVE-8186] is related to self joins and said the issue has been resolved, but this does not seem to be the case.
thanks for your help.
was:
did the following:
create table t1(id string);create table t2(id string);select t1.INPUT__FILE__NAME from t1 join t2 on t1.id = t2.id
fails on: Execution failed with exit status: 2
notice this happens also on self joins:select t1_1.INPUT__FILE__NAME from t1 t1_1 join t1 t1_2 on t1_1.id = t1_2.id
[HIVE-8186] is related to self joins and said the issue has been resolved, but this does not seem to be the case.
thanks for your help.
> hive fails on virtual columns when using any joins
> --------------------------------------------------
>
> Key: HIVE-10902
> URL: https://issues.apache.org/jira/browse/HIVE-10902
> Project: Hive
> Issue Type: Bug
> Affects Versions: 0.14.0
> Environment: cloudera 5.3.3, but happening also in hdp 2.2 and also on clean installs on linux.
> Reporter: Rani Yaroshinsky
>
> did the following:
> {code:sql}
> create table t1(id string);
> create table t2(id string);
> select t1.INPUT__FILE__NAME
> from t1 join t2 on t1.id = t2.id;
> {code}
> {noformat}
> fails on: Execution failed with exit status: 2
> {noformat}
> notice this happens also on self joins:select t1_1.INPUT__FILE__NAME from t1 t1_1 join t1 t1_2 on t1_1.id = t1_2.id
> [HIVE-8186] is related to self joins and said the issue has been resolved, but this does not seem to be the case.
> thanks for your help.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)