[
https://issues.apache.org/jira/browse/KYLIN-1033?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Shaofeng SHI updated KYLIN-1033:
--------------------------------
Affects Version/s: v1.1
> 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.1, v1.0
> Reporter: liyang
> Assignee: liyang
> Labels: QE
> Fix For: v2.0, v1.2
>
> Attachments:
> 1.x-0001-KYLIN-1033-Error-when-joining-two-sub-queries.patch,
> 2.x-0001-KYLIN-1033-Error-when-joining-two-sub-queries.patch
>
>
> Copy from mail list:
> 奔跑的蜗牛 [email protected] 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)
