[ https://issues.apache.org/jira/browse/KYLIN-4471?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
wangrupeng updated KYLIN-4471: ------------------------------ Description: The following two sql about left join cannot be processed. {{SELECT seller_id FROM kylin_sales LEFT JOIN kylin_category_groupings AS kylin_category_groupings ON kylin_sales.leaf_categ_id = kylin_category_groupings.leaf_categ_id AND kylin_sales.lstg_site_id = kylin_category_groupings.site_id WHERE lstg_format_name='FP-GTC' GROUP BY seller_id LIMIT 20;}} !image-2020-05-07-10-30-21-252.png|width=872,height=247! was: The following two sql cannot be processed. {{SELECT kylin_cal_dt.cal_dt, kylin_sales.price FROM kylin_sales INNER JOIN kylin_cal_dt AS kylin_cal_dt ON kylin_sales.part_dt**** = kylin_cal_dt.cal_dt;}} {{SELECT seller_id FROM kylin_sales LEFT JOIN kylin_category_groupings AS kylin_category_groupings ON kylin_sales.leaf_categ_id = kylin_category_groupings.leaf_categ_id AND kylin_sales.lstg_site_id = kylin_category_groupings.site_id WHERE lstg_format_name='FP-GTC' GROUP BY seller_id LIMIT 20;}} !image-2020-04-26-16-15-15-727.png|width=1009,height=486! {{}} > Cannot query sql about inner join and left join > ------------------------------------------------ > > Key: KYLIN-4471 > URL: https://issues.apache.org/jira/browse/KYLIN-4471 > Project: Kylin > Issue Type: Bug > Components: Query Engine > Reporter: wangrupeng > Assignee: wangrupeng > Priority: Critical > Fix For: v4.0.0-beta > > Attachments: image-2020-05-07-10-30-21-252.png > > Original Estimate: 96h > Remaining Estimate: 96h > > The following two sql about left join cannot be processed. > > {{SELECT seller_id FROM kylin_sales LEFT JOIN kylin_category_groupings AS > kylin_category_groupings ON kylin_sales.leaf_categ_id = > kylin_category_groupings.leaf_categ_id AND kylin_sales.lstg_site_id = > kylin_category_groupings.site_id WHERE lstg_format_name='FP-GTC' GROUP BY > seller_id LIMIT 20;}} > !image-2020-05-07-10-30-21-252.png|width=872,height=247! -- This message was sent by Atlassian Jira (v8.3.4#803005)