[jira] [Created] (HIVE-15209) Set hive.strict.checks.cartesian.product to false by default

["Jesus Camacho Rodriguez (JIRA)" <ji...@apache.org>]

Jesus Camacho Rodriguez created HIVE-15209:
----------------------------------------------

             Summary: 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


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)