[
https://issues.apache.org/jira/browse/KYLIN-4471?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
wangrupeng updated KYLIN-4471:
------------------------------
Attachment: (was: image-2020-04-26-16-15-15-727.png)
> 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)
