[jira] [Created] (KYLIN-1033) Error when joining two sub-queries

["liyang (JIRA)" <ji...@apache.org>]

liyang created KYLIN-1033:
-----------------------------

             Summary: Error when joining two sub-queries
                 Key: KYLIN-1033
                 URL: https://issues.apache.org/jira/browse/KYLIN-1033
             Project: Kylin
          Issue Type: Bug
    Affects Versions: v1.0
            Reporter: liyang


Copy from mail list:
奔跑的蜗牛 99089865@qq.com via apache.org 

We create two cubes in one project.  We want to join the two query (querying  data from two cube) together.
But we got the error :
null while executing SQL: "with a as ( select part_dt,sum(price) amount from kylin_sales group by part_dt ), b as (select part_dt,count(price) cn from kylin_sales group by part_dt) select * from a join b on a.part_dt= b.part_dt LIMIT 50000"


The example for learn_kylin  as following.
We can get data using query select * from  a , select * from b . But when join together,we get error.


with a as (
select part_dt,sum(price) amount
from kylin_sales
group by part_dt ),
b as (select part_dt,count(price) cn
from kylin_sales
group by part_dt)


--select * from a
--select * from b
select * from a
join b on a.part_dt= b.part_dt



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)