Return-Path: X-Original-To: apmail-kylin-dev-archive@minotaur.apache.org Delivered-To: apmail-kylin-dev-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id F262A177F3 for ; Mon, 23 Mar 2015 05:11:12 +0000 (UTC) Received: (qmail 11044 invoked by uid 500); 23 Mar 2015 05:11:12 -0000 Delivered-To: apmail-kylin-dev-archive@kylin.apache.org Received: (qmail 10991 invoked by uid 500); 23 Mar 2015 05:11:12 -0000 Mailing-List: contact dev-help@kylin.incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@kylin.incubator.apache.org Delivered-To: mailing list dev@kylin.incubator.apache.org Received: (qmail 10975 invoked by uid 99); 23 Mar 2015 05:11:12 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 23 Mar 2015 05:11:12 +0000 X-ASF-Spam-Status: No, hits=1.5 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of luke.hq@gmail.com designates 209.85.213.175 as permitted sender) Received: from [209.85.213.175] (HELO mail-ig0-f175.google.com) (209.85.213.175) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 23 Mar 2015 05:11:08 +0000 Received: by igbqf9 with SMTP id qf9so29692584igb.1 for ; Sun, 22 Mar 2015 22:10:48 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type; bh=e3xquTj2d/Y7ZANjlB8IDzZNnJ/N11SO6J7WekGgdYc=; b=p1Ml48BMtgmYtuhkmdjsgS8JVDLB+f7muJmC1GAfi/t0yPIhbaRJaNfU0GvDLOAB1Y RW00ghK97smYVx6uhdz4wXKxUj6NGyPwKHLs0Q9Qn+797QKhmzEjboDxz5gokbWOlmLs dF/kn7Pm+SO0JlsK1cDK2sIctOZSrEHmx0gm1agPKVPJvwoyNzfawBkh3kjxu3N/SRA3 Pv5iSmXt3HPcEkyU1C4IPUi+f6EY9RgvgvNV5GiBYeXTHpEtVA33GltJJQFhKVAhBW0j yEri/NJOo/QG/KRFBujY+0oVht7VD/45XoPUvB6U/icWqV6h66kO07QMXwMHcN7pUxnc jbrw== MIME-Version: 1.0 X-Received: by 10.42.186.130 with SMTP id cs2mr17162259icb.74.1427087446945; Sun, 22 Mar 2015 22:10:46 -0700 (PDT) Received: by 10.36.117.85 with HTTP; Sun, 22 Mar 2015 22:10:46 -0700 (PDT) In-Reply-To: References: Date: Sun, 22 Mar 2015 22:10:46 -0700 Message-ID: Subject: Re: Kylin vs Druid From: Luke Han To: "dev@kylin.incubator.apache.org" Content-Type: multipart/alternative; boundary=20cf303bf56256b4b40511edb033 X-Virus-Checked: Checked by ClamAV on apache.org --20cf303bf56256b4b40511edb033 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable 9. Previous version, Druid is under GPL v2 license, the latest version of Druid is changed to Apache license 2, Apache Kylin is under Apache License v2. Both Druid and Kylin are aim to resolve some big problems in Big Data area, but go with different approach and serve for different purpose. As definition, Kylin provides SQL interface and OLAP capability. Since the industry and technology changes so frequency, each of them is evolving very much. Thanks. Best Regards! --------------------- Luke Han 2015-03-21 19:24 GMT-07:00 Li Yang : > 8. Kylin relies on Hadoop for cube build and HBase for storage. Druid has > its own computation and storage cluster. For those who already running > Hadoop & HBase, Kylin is a small addition to deployment. Druid always > require its own cluster be deployed. > > Thanks Xu! Great answer! (FAQ also updated.) > > On Sun, Mar 22, 2015 at 1:33 AM, hongbin ma wrote: > > > thanks jiangxu > > > > i have included your answer as a FAQ: > > > > > https://github.com/KylinOLAP/Kylin/blob/staging/docs/MISC/FAQ%20on%20Kyli= n%20Installation%20and%20Usage.md#what-is-the-difference-between-kylin-and-= druid > > > > On Sat, Mar 21, 2015 at 8:30 AM, =E8=92=8B=E6=97=AD wrote: > > > > > Let me give some simple explanations as below. Since I am more famili= ar > > > with Kylin, these explanations may not be 100% accurate. :-) > > > > > > > > > 1. Druid is more suitable for realtime analysis. Kylin is more focus = on > > > OLAP case. > > > > > > > > > 2. Druid has good integration with Kafka as realtime streaming. The > > > realtime capability of Kylin is still under development. > > > > > > > > > 3. Druid use bitmap index as internal data structure. Kylin use bitma= p > > > index for realtime data and molap cube for historical data. > > > > > > > > > 4. Kylin provide ANSI SQL. Druid provide specific query language. > > > > > > > > > 5. Druid has limitation on table join. Kylin support star schema. > > > > > > > > > 6. Kylin has good intergration with BI tools, such as Tableau or Exce= l. > > > Druid can't integrate with existed BI tools. > > > > > > > > > 7. Since Kylin support molap cube, it has very good performance for > > > complex query on billion level data set. Since Druid need to scan the > > full > > > index, the performance may be hurt if the data set and query range is > too > > > big. > > > > > > > > > Thanks > > > Jiang Xu > > > > > > > > > ------------------ =E5=8E=9F=E5=A7=8B=E9=82=AE=E4=BB=B6 -------------= ----- > > > =E5=8F=91=E4=BB=B6=E4=BA=BA: =E3=83=AF=E3=83=B3=E3=83=AC=E3=82=A4(=E3= =82=B1=E3=83=93=E3=83=B3Kevin) > > > =E5=8F=91=E9=80=81=E6=97=B6=E9=97=B4: 2015=E5=B9=B403=E6=9C=8820=E6= =97=A5 14:44 > > > =E6=94=B6=E4=BB=B6=E4=BA=BA: dev > > > =E6=8A=84=E9=80=81: shigira > > > =E4=B8=BB=E9=A2=98: Kylin vs Druid > > > > > > > > > > > > Hi, > > > > > > A quick question, how do you look at Kylin differently from Druid, > > another > > > tool that is built for providing large quantity of analytic data with > low > > > latency? Are two tools to solve the similar problem with different > > > approaches? > > > > > > Thanks! > > > Kevin > > > > > > > > > > > -- > > Regards, > > > > *Bin Mahone | =E9=A9=AC=E6=B4=AA=E5=AE=BE* > > Apache Kylin: http://kylin.io > > Github: https://github.com/binmahone > > > --20cf303bf56256b4b40511edb033--