[
https://issues.apache.org/jira/browse/HIVE-15209?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15667839#comment-15667839
]
Jesus Camacho Rodriguez commented on HIVE-15209:
------------------------------------------------
[~sershe], thank you for pointing that out; I did not remember that.
Then I agree with [~xuefuz] that a conscious decision should be made so we do
not flip this back and forth as he said. Probably it all depends on the
direction that we want to give to the project...
> Set hive.strict.checks.cartesian.product to false by default
> ------------------------------------------------------------
>
> Key: HIVE-15209
> URL: https://issues.apache.org/jira/browse/HIVE-15209
> Project: Hive
> Issue Type: Bug
> Components: Parser
> Affects Versions: 2.2.0
> Reporter: Jesus Camacho Rodriguez
> Assignee: Jesus Camacho Rodriguez
> Attachments: HIVE-15209.patch
>
>
> If we aim to make Hive compliant with SQL, w should disable this property by
> default, as expressing a cartesian product, though inefficient, is perfectly
> valid in SQL.
> Further, if we express complex predicates in the ON clause of a SQL query, we
> might not be able to push these predicates to the join operator; however, we
> should still be able to execute the query.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
