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 35ACF200CBD for ; Thu, 6 Jul 2017 19:31:16 +0200 (CEST) Received: by cust-asf.ponee.io (Postfix) id 34167166FBF; Thu, 6 Jul 2017 17:31:16 +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 52A46166FBE for ; Thu, 6 Jul 2017 19:31:15 +0200 (CEST) Received: (qmail 67331 invoked by uid 500); 6 Jul 2017 17:31:14 -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 67321 invoked by uid 99); 6 Jul 2017 17:31:14 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd2-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 06 Jul 2017 17:31:14 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd2-us-west.apache.org (ASF Mail Server at spamd2-us-west.apache.org) with ESMTP id F06E01AF8C4 for ; Thu, 6 Jul 2017 17:31:13 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd2-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: -0.891 X-Spam-Level: X-Spam-Status: No, score=-0.891 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_NONE=-0.0001, RCVD_IN_MSPIKE_H2=-2.8, SPF_PASS=-0.001, T_REMOTE_IMAGE=0.01] autolearn=disabled Authentication-Results: spamd2-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=xactlycorp.com Received: from mx1-lw-us.apache.org ([10.40.0.8]) by localhost (spamd2-us-west.apache.org [10.40.0.9]) (amavisd-new, port 10024) with ESMTP id VtZ88QDX_QBy for ; Thu, 6 Jul 2017 17:31:10 +0000 (UTC) Received: from mail-pg0-f47.google.com (mail-pg0-f47.google.com [74.125.83.47]) by mx1-lw-us.apache.org (ASF Mail Server at mx1-lw-us.apache.org) with ESMTPS id 1F83F5FD0C for ; Thu, 6 Jul 2017 17:31:10 +0000 (UTC) Received: by mail-pg0-f47.google.com with SMTP id k14so4252080pgr.0 for ; Thu, 06 Jul 2017 10:31:10 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=xactlycorp.com; s=corpmail; h=mime-version:in-reply-to:references:from:date:message-id:subject:to; bh=1JI7gzVVk6gbcm5aHMbR5wdalxmhEASevC5r4ZOyHhU=; b=T/KU4YMmR1PLLHJ9iCkhwortimYIHYYaMM+LKgdgZmWzxAJjLmE66M2UehdFhEZs/6 vhXsABOEaNWrCggskSjQCHtlkL3Rzv9gleC8YMoXW2tWvqC9jnJqdroavICGimAqfu1w 0cMZu/y6mLHHGd+a5Kl0MsQsgCFSszXOtqSk/yr2OTIr+2OpGfD83RN5w+4H4dLKEF+8 QsX4VyRmd48uMlhqb6g1DfTxDuQNJdJkxl+wUGi77gk4bVgD5t5/fFnPt3adrnlJF4Ie 39dzWkcXQC+C0bd4LZuc3n9FXJGFS43Gy6Rn+qSpUUfXL7rBGtvw/Tk2U0X8vl/7T/zP nDKA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to; bh=1JI7gzVVk6gbcm5aHMbR5wdalxmhEASevC5r4ZOyHhU=; b=JvUmKh/nvLJ3HlkVa+n6Gv1EpR/pc0KbhHxlDkqS2SuFGzYzsluLtlrhG3mQmDUO16 gq5JmuSjJNc8R04/cEpfcDyiHxQ9f025WLHBVLho6fgyVC+rzB/GppgoILS12a/rLxhE 3YkCUnx5dQbFb6F1F44vVnDXtLCcUdwBzS/Y6HYL2AwZey8OW8e0uEp8ruLSUymTpi1v LKSUJcMAmfs34CXzz8kwGaXmJYSzv1I5pQko9ZGHyCsRWvJBNZ67E5TdXtJZoMEyE4Mq ekpVixSIC6t+/d6jcbPdbUiIp6niaPC3PGG0N516HUiwFuvcMvWDo+P+qEOPveChd4O/ mAdw== X-Gm-Message-State: AIVw111/2eMZOP9qXcKfkIQU1+mQZuT+0CjSQI77IggUNbdoCb7kOKCy FZGeBXDZy+Wo2LXk5Efc6SY7wL9TI0Jx6QU8hUj/qMpJM4IDYb7rc66bFJCuuZ924UG9SH0fFMv qX8fxODwdgtvQSA== X-Received: by 10.84.133.69 with SMTP id 63mr29227948plf.225.1499362268991; Thu, 06 Jul 2017 10:31:08 -0700 (PDT) MIME-Version: 1.0 Received: by 10.100.161.209 with HTTP; Thu, 6 Jul 2017 10:31:08 -0700 (PDT) In-Reply-To: References: From: Nirav Patel Date: Thu, 6 Jul 2017 10:31:08 -0700 Message-ID: Subject: Re: Multiple fact tables To: user@kylin.apache.org Content-Type: multipart/alternative; boundary="94eb2c130b786ee5630553a97bf6" archived-at: Thu, 06 Jul 2017 17:31:16 -0000 --94eb2c130b786ee5630553a97bf6 Content-Type: text/plain; charset="UTF-8" Got it. Thanks! On Thu, Jun 29, 2017 at 3:48 AM, Li Yang wrote: > The support of "multiple fact" is by allowing very big lookup table. Try > create a lookup table, with "skip snapshot" checked. > > On Tue, Jun 27, 2017 at 3:11 AM, Nirav Patel > wrote: > >> following thread that suggest that with kylin 2.x it supports multiple >> fact table in one cube. However, when I try to build Model via UI it only >> allows me to add one Fact table. >> >> http://apache-kylin.74782.x6.nabble.com/Re-Hive-table-design >> -multiple-fact-tables-or-rolled-up-td7396.html >> >> Am I missing something here? >> >> Or do I just create multiple Models and Cubes for fact tables and do Join >> at run time. >> >> Thanks >> >> >> >> [image: What's New with Xactly] >> >> [image: LinkedIn] >> [image: Twitter] >> [image: Facebook] >> [image: YouTube] >> > > > -- [image: What's New with Xactly] [image: LinkedIn] [image: Twitter] [image: Facebook] [image: YouTube] --94eb2c130b786ee5630553a97bf6 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Got it.

Thanks!

On Thu, Jun 29, 2017 at 3:4= 8 AM, Li Yang <liyang@apache.org> wrote:
The support of "multiple fact" is= by allowing very big lookup table. Try create a lookup table, with "s= kip snapshot" checked.

On Tue, Jun 27, 2017 at 3:11 AM,= Nirav Patel <npatel@xactlycorp.com> wrote:
f= ollowing thread that suggest that with kylin 2.x it supports multiple fact = table in one cube. However, when I try to build Model via UI it only allows= me to add one Fact table.=C2=A0


Am I missing something here?

Or do I just create multiple Models and Cubes for fa= ct tables and do Join at run time.

Thanks



3D"What's

=C2=A0=C2=A03D"LinkedIn"=C2=A0=C2=A03D"Twitter"=C2=A0=C2=A03D"Facebook"=C2=A0=C2=A03D"YouTube"





3D"What's

=C2=A0=C2=A03D"LinkedIn"=C2=A0=C2=A03D"Twitter"=C2=A0=C2=A03D"Facebook"=C2=A0=C2=A03D"YouTube" --94eb2c130b786ee5630553a97bf6--