Uploaded image for project: 'Kylin'
  1. Kylin
  2. KYLIN-1033

Error when joining two sub-queries

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: v1.0, v1.1
    • Fix Version/s: v1.2, v1.4.0
    • Component/s: None
    • Labels:

      Description

      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

        Attachments

          Activity

            People

            • Assignee:
              liyang.gmt8@gmail.com liyang
              Reporter:
              liyang.gmt8@gmail.com liyang
            • Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: