hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Damien Carol (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-8001) Error in explain SMB on tez
Date Fri, 05 Sep 2014 14:11:28 GMT

     [ https://issues.apache.org/jira/browse/HIVE-8001?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Damien Carol updated HIVE-8001:
-------------------------------
    Description: 
Trying SMB join with 2 tables on trunk.
Created with :
{code:sql}
CREATE TABLE foo ( ..)
 CLUSTERED BY (id) 
 SORTED BY (id) INTO 4 BUCKETS 
 STORED AS ORC;
{code}

got this :
{code:sql}
explain 
select s.id, count(*) 
from sales e, shops s
where e.id_shop = s.id
group by s.id
{code}

{noformat}
Error: Error while compiling statement: FAILED: ClassCastException org.apache.hadoop.hive.ql.exec.SMBMapJoinOperator
cannot be cast to org.apache.hadoop.hive.ql.exec.MapJoinOperator (state=42000,code=40000)
{noformat}

  was:
Trying SMB join with 2 tables on trunk.

got this :
{code:sql}
explain select e.idmagasin, count(*) from encaissement_1m_smb e, magasin_smb m where e.idmagasin
= m.idmagasin group by e.idmagasin
{code}

{noformat}
Error: Error while compiling statement: FAILED: ClassCastException org.apache.hadoop.hive.ql.exec.SMBMapJoinOperator
cannot be cast to org.apache.hadoop.hive.ql.exec.MapJoinOperator (state=42000,code=40000)
{noformat}


> Error in explain SMB on tez
> ---------------------------
>
>                 Key: HIVE-8001
>                 URL: https://issues.apache.org/jira/browse/HIVE-8001
>             Project: Hive
>          Issue Type: Bug
>         Environment: Hadoop 2.4.0
> Trunk
> Tez
>            Reporter: Damien Carol
>
> Trying SMB join with 2 tables on trunk.
> Created with :
> {code:sql}
> CREATE TABLE foo ( ..)
>  CLUSTERED BY (id) 
>  SORTED BY (id) INTO 4 BUCKETS 
>  STORED AS ORC;
> {code}
> got this :
> {code:sql}
> explain 
> select s.id, count(*) 
> from sales e, shops s
> where e.id_shop = s.id
> group by s.id
> {code}
> {noformat}
> Error: Error while compiling statement: FAILED: ClassCastException org.apache.hadoop.hive.ql.exec.SMBMapJoinOperator
cannot be cast to org.apache.hadoop.hive.ql.exec.MapJoinOperator (state=42000,code=40000)
> {noformat}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message