You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@kylin.apache.org by "wangrupeng (Jira)" <ji...@apache.org> on 2020/04/26 08:17:00 UTC
[jira] [Updated] (KYLIN-4471) Cannot query inner join and left join
[ 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 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! {{}}
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 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: Major
> Fix For: v4.0.0-beta
>
> Attachments: image-2020-04-26-16-15-15-727.png
>
>
> 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! {{}}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)