kylin-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "wangrupeng (Jira)" <j...@apache.org>
Subject [jira] [Created] (KYLIN-4471) Cannot query inner join and left join
Date Sun, 26 Apr 2020 08:16:00 GMT
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)

Mime
View raw message