XMLWordPrintableJSON

Details

    • Sub-task
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • None
    • None
    • None
    • None

    Description

      this issue was hidden; because of HIVE-18238

      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;
      

      emits a cartesian product error

      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.
      

      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...

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              kgyrtkirk Zoltan Haindrich
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: