[ https://issues.apache.org/jira/browse/HIVE-15209?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15667837#comment-15667837 ]
Xuefu Zhang commented on HIVE-15209: ------------------------------------ I don't think erring out and saying that "Cartesian products are disabled for safety reasons" violates compliance. Further I'd argue that being compliant is not our ultimate goal. As to b/c, the default has been true since HIVE-12727, which is released in 2.0. I don't think we should make existing user suffer just to make new users happier. > 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)