Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id 3DDB0200B5E for ; Wed, 27 Jul 2016 01:46:17 +0200 (CEST) Received: by cust-asf.ponee.io (Postfix) id 3C58D160AA5; Tue, 26 Jul 2016 23:46:17 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id 8457F160AA4 for ; Wed, 27 Jul 2016 01:46:16 +0200 (CEST) Received: (qmail 47873 invoked by uid 500); 26 Jul 2016 23:46:15 -0000 Mailing-List: contact user-help@kylin.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@kylin.apache.org Delivered-To: mailing list user@kylin.apache.org Received: (qmail 47863 invoked by uid 99); 26 Jul 2016 23:46:15 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd3-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 26 Jul 2016 23:46:15 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd3-us-west.apache.org (ASF Mail Server at spamd3-us-west.apache.org) with ESMTP id 47BFF188325 for ; Tue, 26 Jul 2016 23:46:15 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd3-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 1.179 X-Spam-Level: * X-Spam-Status: No, score=1.179 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, HTML_MESSAGE=2, RCVD_IN_DNSWL_LOW=-0.7, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, SPF_PASS=-0.001] autolearn=disabled Authentication-Results: spamd3-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com Received: from mx1-lw-us.apache.org ([10.40.0.8]) by localhost (spamd3-us-west.apache.org [10.40.0.10]) (amavisd-new, port 10024) with ESMTP id 4ENTbhwD8LJb for ; Tue, 26 Jul 2016 23:46:13 +0000 (UTC) Received: from mail-qt0-f173.google.com (mail-qt0-f173.google.com [209.85.216.173]) by mx1-lw-us.apache.org (ASF Mail Server at mx1-lw-us.apache.org) with ESMTPS id 050825F1F5 for ; Tue, 26 Jul 2016 23:46:13 +0000 (UTC) Received: by mail-qt0-f173.google.com with SMTP id 52so20894292qtq.3 for ; Tue, 26 Jul 2016 16:46:12 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:from:date:message-id:subject:to; bh=cOqxVI37WrryH4YU9JQkd6eHLh/l803TjashdqW9pTk=; b=F84FLJ+JQhZpokMTb+5uG9WQdu6r2lDVYFJa3SKc70UBzJiAu5iLSr508vG8Z2gpSu UgdhmXteg9ytBdAq6MWJrnkpwEVt2K3alxqt3IB6KWa3LiMGs5626hna99v42AjWzNdz tNNILCceREm4w/0F/4xh0Prsy8zPO3ZNBmXaRUpV3YKV/PnvLcM4SfSWo0hMQtbedjoN M+ACG4mJ3VfsFwqQ8nwhlPp/pAlRY9DtDxXU7xizKsy1Ml+eb6842Y8cbx6ArzZW9VPN MNZJ2kjG3+Uv9vslCTBkA2cOJtN0VCMwTRk61FJSiujBU2moKNqHZclCMY71thXRO+mr K/nA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to; bh=cOqxVI37WrryH4YU9JQkd6eHLh/l803TjashdqW9pTk=; b=WyuqPxmDk5rwyfqL+Sb+B0BXhh6Tt7eMVK75SrK835pcS4oFxWthmwDN0zB3qOYUyk p/9cqcfWwaKoz6V2s4debRN46y4yvsymhjHuifMwVMbTJc6Nfw8kVXY+79otsD+xG9cg MHV3rPJlcHI6gRJlgMObjjjM9hYJWrgpxmRzxzkpKtTyCpkwBdS3P1QbQt+rVUximtnd OmTgL9w0M7tf+IlZL3h5LXMHfiYILDThrEcUvlzWwl6Vzd21Ep79lBlifpuPLkdJQ5LB EWoDKVABsfNAKLwE9At5RSQGReG9tvRmniean9UPSl+dgTnGPWCYalt5lLQd+pN1kqdn 1mMw== X-Gm-Message-State: AEkoouvkYJydG7tPdlAADEfOW/f+BciBqPo4+HI2W9InQx893K88CuSL3sAkvYJOK3cB6rgZILG4M9sfyiyK/w== X-Received: by 10.237.37.99 with SMTP id w32mr42059429qtc.59.1469576766245; Tue, 26 Jul 2016 16:46:06 -0700 (PDT) MIME-Version: 1.0 Received: by 10.140.18.147 with HTTP; Tue, 26 Jul 2016 16:45:46 -0700 (PDT) In-Reply-To: References: From: Yiming Liu Date: Wed, 27 Jul 2016 07:45:46 +0800 Message-ID: Subject: Re: Multiple Fact Tables in Kylin To: user@kylin.apache.org Content-Type: multipart/alternative; boundary=001a11420f821f4f080538928160 archived-at: Tue, 26 Jul 2016 23:46:17 -0000 --001a11420f821f4f080538928160 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Hi Zhao Jun, Kylin supports start schema, which means only one fact table. Could you try build a view which joins the fact tables as the new fact table=EF=BC=9FIt's the common design pattern. No that plan, as I know. 2016-07-27 7:39 GMT+08:00 =E4=BF=8A =E8=B5=B5 : > Hi Kylin Team, > > I have some questions. > > 1. Does Kylin only support one fact table in building a cube? > > 2. If so, is there a way to analyse a database with several fact tables > using Kylin, except that building a cube per fact table and joining resul= ts > together? > > 3. If so, will Kylin support multi fact tables in the future? > > Many thanks! > > > *Zhao Jun* > --=20 With Warm regards Yiming Liu (=E5=88=98=E4=B8=80=E9=B8=A3) --001a11420f821f4f080538928160 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Hi Zhao Jun,

Kylin supports start= schema, which means only one fact table.=C2=A0

Could yo= u try build a view which joins the fact tables as the new fact table=EF=BC= =9FIt's the common design pattern.=C2=A0

No th= at plan, as I know.=C2=A0

2016-07-27 7:39 GMT+08:00 =E4=BF=8A =E8=B5=B5 <zha= ojun12@outlook.com>:
H= i Kylin Team,

I have some questions.

1. Does Kylin only support one fact table in building a cu= be?
2. = If so, is there a way to analyse a database with several fact tables using = Kylin, except that building a cube per fact table and joining results toget= her?
<= br>
3.= If so, will Kylin support multi fact tables in the future?

Many thanks!


Zhao Jun
=



--
With Warm regards
Yiming Liu (=E5=88=98=E4=B8=80=E9=B8=A3)
--001a11420f821f4f080538928160--