[
https://issues.apache.org/jira/browse/HIVE-21411?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16790449#comment-16790449
]
xialu commented on HIVE-21411:
--
set hive.auto.convert.join=false;
> LEFT JOIN CONVERT TO INNER JOIN LEAD TO
[
https://issues.apache.org/jira/browse/HIVE-21411?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16790260#comment-16790260
]
xialu commented on HIVE-21411:
--
[~vgarg] easy to reproduce
show create table lulu.store_sales;
[
https://issues.apache.org/jira/browse/HIVE-21411?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16790246#comment-16790246
]
Vineet Garg commented on HIVE-21411:
[~tianmenglan2016] Can you provide reproducer (including
[
https://issues.apache.org/jira/browse/HIVE-21411?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16789093#comment-16789093
]
xialu commented on HIVE-21411:
--
[~vgarg] ss_sold_date_sk and d_date_sk has no relastionship about fk/pk
[
https://issues.apache.org/jira/browse/HIVE-21411?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16788093#comment-16788093
]
Gopal V commented on HIVE-21411:
Are there any FK/PK relationships between ss_sold_date_sk and d_date_sk
[
https://issues.apache.org/jira/browse/HIVE-21411?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16787745#comment-16787745
]
xialu commented on HIVE-21411:
--
i use left outer join, result is correct, such as select