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 75824200C31 for ; Wed, 8 Mar 2017 22:21:24 +0100 (CET) Received: by cust-asf.ponee.io (Postfix) id 740B9160B86; Wed, 8 Mar 2017 21:21:24 +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 BF1DE160B73 for ; Wed, 8 Mar 2017 22:21:23 +0100 (CET) Received: (qmail 20376 invoked by uid 500); 8 Mar 2017 21:21:22 -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 20366 invoked by uid 99); 8 Mar 2017 21:21:22 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd4-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 08 Mar 2017 21:21:22 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd4-us-west.apache.org (ASF Mail Server at spamd4-us-west.apache.org) with ESMTP id 53DD6C18EC for ; Wed, 8 Mar 2017 21:21:22 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd4-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 2.398 X-Spam-Level: ** X-Spam-Status: No, score=2.398 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=-0.001, RCVD_IN_SORBS_SPAM=0.5, SPF_PASS=-0.001] autolearn=disabled Authentication-Results: spamd4-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 (spamd4-us-west.apache.org [10.40.0.11]) (amavisd-new, port 10024) with ESMTP id eocgf-D8RbAu for ; Wed, 8 Mar 2017 21:21:21 +0000 (UTC) Received: from mail-ua0-f176.google.com (mail-ua0-f176.google.com [209.85.217.176]) by mx1-lw-us.apache.org (ASF Mail Server at mx1-lw-us.apache.org) with ESMTPS id 34E8360DFC for ; Wed, 8 Mar 2017 21:21:21 +0000 (UTC) Received: by mail-ua0-f176.google.com with SMTP id q7so44232858uaf.2 for ; Wed, 08 Mar 2017 13:21:21 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:from:date:message-id:subject:to; bh=uq3uZKG5nbJx0af6L77wSpkLDvDksw+Wgw+hoJd2/8k=; b=pxRyyZ7sHxvn+eZt+knSds63GLhGkaitZ/LcbuB/xFduQKq0HqzBbv1I74SMQkSNBT u618dfeNb1G2NinSr28ihm4rlV7pGaz1mn4av7cMbLYDlBJIp2S49moDR8OkFocI1uvX /N7GyG/IOILLQjeY30gL3oZ97WZkuSE+l1GREkwPl+4MIUQonC7oeoOsQOhIlyDVSdwy prTSNVAAfFMH8DkYRb3ox9htBVlRC0jWRnR54/0D1ZxkB+KjG7pzUpfLJ6y1VBOWDgf6 ggDsYZpQCU5RMvZUcVUqpWgu9lsdcO9yGyZh8c52IQTddUQFsrOqwzPtIFa/iFatriTX bXAA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:from:date:message-id:subject:to; bh=uq3uZKG5nbJx0af6L77wSpkLDvDksw+Wgw+hoJd2/8k=; b=r2QL+H+JwefCICqDhYGXHkIqy3+DI0WkZDCkF5Whn9YKZqwPEXqeTdXxc4x504NP5z xAeJHDsHJuedExod45gdn9P1V8C191lH9zOSodF8XIPUDWnAIhpUVNCuZSw5LQfApu73 PzIJmmtZ92pmwajvSl1FJqlb1mV1dlDNkQACndlmj4kKjUu1f+l39Qy5pCIJL1lMfip7 rR4+/B7nd7MMK62j4c45kv3oHBKu+xd7cp4h88DUxqxTAACA+IT/oTEtvVLc1yj37NRS LHgrZJc0/mEnDKmzS0AawzlKskuDxHdyStZ/YAMi6kCmL0y3S8rdwOB76YvHFgSual8Z m3/w== X-Gm-Message-State: AMke39mAU3mMWCPDFpevO8+zP6sTPQV21ocro6rVk3K0mCxau8pX+TjpIVCqj8AmoL3RhCIe0m0bAvnPePkE8Q== X-Received: by 10.31.109.71 with SMTP id i68mr5101876vkc.89.1489006125725; Wed, 08 Mar 2017 12:48:45 -0800 (PST) MIME-Version: 1.0 Received: by 10.176.74.85 with HTTP; Wed, 8 Mar 2017 12:48:45 -0800 (PST) From: Sonny Heer Date: Wed, 8 Mar 2017 12:48:45 -0800 Message-ID: Subject: Hive table design (multiple fact tables or rolled up) To: user@kylin.apache.org Content-Type: multipart/alternative; boundary=94eb2c0925b2314044054a3e4180 archived-at: Wed, 08 Mar 2017 21:21:24 -0000 --94eb2c0925b2314044054a3e4180 Content-Type: text/plain; charset=UTF-8 Hi I'm somewhat new to Kylin. we have a relational db schema imported into hive as is at the moment. The schema is highly normalized with lots of tables. I can see this database having multiple fact tables or a handful of fact tables. In Kylin I see when creating a model (star) you have the option to pick a single fact table...meaning there is a single cube per fact table. Please provide pros/cons on running transformations to denormalize the tables into a single table vs keeping lots of tables with many fact/lookup tables. In short: should we do any transformations in Hive before presenting the tables to kylin for cubing?... Thanks --94eb2c0925b2314044054a3e4180 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Hi I'm somewhat new to K= ylin. =C2=A0we have a relational db schema imported into hive as is at the = moment.=C2=A0 The schema is highly normalized with lots of tables.=C2=A0 I = can see this database having multiple fact tables or a handful of fact tabl= es.

In Kylin I see when creating= a model (star) you have the option to pick a single fact table...meaning t= here is a single cube per fact table.=C2=A0 Please provide pros/cons on run= ning transformations to denormalize the tables into a single table vs keepi= ng lots of tables with many fact/lookup tables.=C2=A0

<= div>In short:
should we do any transformations in Hive before pre= senting the tables to kylin for cubing?...

Thanks<= /div>
--94eb2c0925b2314044054a3e4180--