[
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)
