wangrupeng created KYLIN-4471:
---------------------------------
Summary: 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
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)
