hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Zoltan Haindrich (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-18243) Cartesian error for joins defined in where clause
Date Thu, 07 Dec 2017 12:56:00 GMT

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

Zoltan Haindrich updated HIVE-18243:
------------------------------------
    Issue Type: Sub-task  (was: Bug)
        Parent: HIVE-17626

> Cartesian error for joins defined in where clause
> -------------------------------------------------
>
>                 Key: HIVE-18243
>                 URL: https://issues.apache.org/jira/browse/HIVE-18243
>             Project: Hive
>          Issue Type: Sub-task
>            Reporter: Zoltan Haindrich
>
> this issue was hidden; because of HIVE-18238
> {code}
> create table agg_01 (amount int, dim_shops_id int);
> create table dim_shops (id int);
> EXPLAIN SELECT agg.amount
> FROM agg_01 agg,
> dim_shops d1
> WHERE agg.dim_shops_id = d1.id
> and agg.dim_shops_id = 1;
> {code}
> emits a cartesian product error
> {code}
> 2017-12-07T04:48:20,612 ERROR [c7a4797b-2635-4e28-9e0b-af2e4d26f2bc main] ql.Driver:
FAILED: SemanticException Cartesian products are disabled for safety reasons. If you know
what you are doing, please sethive.strict.checks.cartesian.product to false and that hive.mapred.mode
is not set to 'strict' to proceed. Note that if you may get errors or incorrect results if
you make a mistake while using some of the unsafe features.
> {code}
> from the plan: 
> https://github.com/apache/hive/blob/7ddd915bf82a68c8ab73b0c4ca409f1a6d43d227/ql/src/test/results/clientpositive/llap/dynamic_partition_pruning_2.q.out#L591
> It doesn't seem to be that a cartesian join being happening...possibly the check is overreacting...



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

Mime
View raw message