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 CE274200C4F for ; Sat, 18 Mar 2017 03:10:37 +0100 (CET) Received: by cust-asf.ponee.io (Postfix) id CCA3E160B8C; Sat, 18 Mar 2017 02:10:37 +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 C77CC160B80 for ; Sat, 18 Mar 2017 03:10:36 +0100 (CET) Received: (qmail 59865 invoked by uid 500); 18 Mar 2017 02:10:36 -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 59856 invoked by uid 99); 18 Mar 2017 02:10:35 -0000 Received: from mail-relay.apache.org (HELO mail-relay.apache.org) (140.211.11.15) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 18 Mar 2017 02:10:35 +0000 Received: from mail-pg0-f54.google.com (mail-pg0-f54.google.com [74.125.83.54]) by mail-relay.apache.org (ASF Mail Server at mail-relay.apache.org) with ESMTPSA id BCF951A0908 for ; Sat, 18 Mar 2017 02:10:35 +0000 (UTC) Received: by mail-pg0-f54.google.com with SMTP id g2so50948560pge.3 for ; Fri, 17 Mar 2017 19:10:35 -0700 (PDT) X-Gm-Message-State: AFeK/H1UR3iNi/+yCw/hqf7vBXtSd+fuAEFQW6ry0b3h60EJ56W1dJuYL1FGJa5g8pydy9rdjs/NfN7mnqHuOQ== X-Received: by 10.99.173.69 with SMTP id y5mr19427623pgo.35.1489803035194; Fri, 17 Mar 2017 19:10:35 -0700 (PDT) MIME-Version: 1.0 Received: by 10.100.138.39 with HTTP; Fri, 17 Mar 2017 19:09:54 -0700 (PDT) In-Reply-To: References: <2994F254A682DA469C4A75BDABFF9154785076BF@IT-EXMB-16-29.meizu.com> From: ShaoFeng Shi Date: Sat, 18 Mar 2017 10:09:54 +0800 X-Gmail-Original-Message-ID: Message-ID: Subject: Re: Re: Drill integration ? To: user Cc: Sonny Heer Content-Type: multipart/alternative; boundary=94eb2c1bdad0b2bd2d054af7cc3c archived-at: Sat, 18 Mar 2017 02:10:38 -0000 --94eb2c1bdad0b2bd2d054af7cc3c Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable There were discussions about integrating with an alternative engine, like Impala, SparkSQL, etc; but no progress/action on that; If you already made some investigation or development, welcome to share and also contribute back to Kylin. 2017-03-18 1:13 GMT+08:00 Billy Liu : > Thanks Sonny and Tianshuo. It makes sense. Currently, no one is working o= n > this still. It will be a great step to move Kylin to the next level. > > 2017-03-16 23:14 GMT-07:00 =E8=B5=B5=E5=A4=A9=E7=83=81 : > >> great=EF=BC=8Cwe are trying to work on the same direction,which combine = kylin and >> spark(not as cubing engine),drill is also a great choice I think. >> >> ------------------------------ >> >> =E8=B5=B5=E5=A4=A9=E7=83=81 >> >> Kevin Zhao >> >> *zhaotianshuo@meizu.com * >> >> >> >> =E7=8F=A0=E6=B5=B7=E5=B8=82=E9=AD=85=E6=97=8F=E7=A7=91=E6=8A=80=E6=9C=89= =E9=99=90=E5=85=AC=E5=8F=B8 >> >> MEIZU Technology Co., Ltd. >> >> =E5=B9=BF=E4=B8=9C=E7=9C=81=E7=8F=A0=E6=B5=B7=E5=B8=82=E7=A7=91=E6=8A=80= =E5=88=9B=E6=96=B0=E6=B5=B7=E5=B2=B8=E9=AD=85=E6=97=8F=E7=A7=91=E6=8A=80=E6= =A5=BC >> >> MEIZU Tech Bldg., Technology & Innovation Coast >> >> Zhuhai, 519085, Guangdong, China >> >> meizu.com >> >> >> *From:* Sonny Heer >> *Date:* 2017-03-17 06:35 >> *To:* user@kylin.apache.org >> *Subject:* Re: Drill integration ? >> The obvious one I can think of: Drill is a great ad hoc sql execution >> engine. In the case where kylin can't answer via cube, then direct the >> incoming query to drill. Both systems use calcite. The idea is to comb= ine >> quick query response for most frequent queries (kylin predefined analyti= cal >> queries) with more coverage (drill). (e.g. cases of no realization fo= und >> or cross cube join)... >> >> On Thu, Mar 16, 2017 at 12:20 PM, Billy Liu wrote: >> >>> Hi Heer, >>> >>> May I ask more more for this proposal, the benefits or use case? >>> >>> 2017-03-16 7:58 GMT-07:00 Sonny Heer : >>> >>>> Is there any support for Apache Drill within Kylin? Any tickets for >>>> work done around this yet? >>>> >>>> Thanks >>>> >>>> >>> >> >> >> -- >> >> >> Pushpinder S. Heer >> Senior Software Engineer >> m: 360-434-4354 h: 509-884-2574 >> >> > --=20 Best regards, Shaofeng Shi =E5=8F=B2=E5=B0=91=E9=94=8B --94eb2c1bdad0b2bd2d054af7cc3c Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
There were discussions about integrating with an alternati= ve engine, like Impala, SparkSQL, etc; but no progress/action on that; If y= ou already made some investigation or development, welcome to share and als= o contribute back to Kylin.

2017-03-18 1:13 GMT+08:00 Billy Liu <= billyliu@apache.or= g>:
Thanks= Sonny and Tianshuo. It makes sense. Currently, no one is working on this s= till. It will be a great step to move Kylin to the next level.=C2=A0
<= div class=3D"HOEnZb">

2017-03-16 23:14 GMT-07:00 =E8=B5=B5=E5=A4=A9=E7=83= =81 <zhaotianshuo@meizu.com>:
great=EF=BC=8Cwe are trying to work on the same direction= ,which combine kylin and spark(not as cubing engine),drill is also a great = choice I think.

=E8=B5=B5=E5=A4=A9=E7=83=81

Kevin Zhao

zhaotianshuo@meizu.com<= /span>

=C2=A0

=E7=8F=A0=E6=B5=B7=E5=B8= =82=E9=AD=85=E6=97=8F=E7=A7=91=E6=8A=80=E6=9C=89=E9=99=90=E5=85=AC=E5=8F=B8=

MEIZU Technology Co., Ltd.

=E5=B9=BF=E4=B8=9C=E7=9C= =81=E7=8F=A0=E6=B5=B7=E5=B8=82=E7=A7=91=E6=8A=80=E5=88=9B=E6=96=B0=E6=B5=B7= =E5=B2=B8=E9=AD=85=E6=97=8F=E7=A7=91=E6=8A=80=E6=A5=BC=

MEIZU Tech Bldg., Technology & Innovation Coast

Zhuhai, 519085, Guangdong, China

meizu.com

=C2=A0
Sonny Heer
Date:=C2=A02017-03-17=C2=A006:35
Subject:=C2=A0Re: Drill integration ?
The obvious one I can think of: =C2=A0Drill is a great ad = hoc sql execution engine.=C2=A0 In the case where kylin can't answer vi= a cube, then direct the incoming query to drill.=C2=A0 Both systems use cal= cite.=C2=A0 The idea is to combine quick query response for most frequent queries (kylin predefined analytical queries) with more cove= rage (drill). =C2=A0 =C2=A0(e.g. cases of no realization found or cross cub= e join)...

On Thu, Mar 16, 2017 at 12:20 PM, Billy Liu <billyliu@apach= e.org> wrote:
Hi Heer,

May I ask more more for this proposal, the benefits or use case?

2017-03-16 7:58 GMT-07:00 Sonny Heer <sonny= heer@gmail.com>:
Is there any support for Apache Drill within Kylin?=C2=A0 = Any tickets for work done around this yet?

Thanks





--


Pushpinder S. Heer
Senior Software Engineer
m: 360-434-4354 h: 509-884-2574




--
=
Best regards,

Shaofeng Sh= i =E5=8F=B2=E5=B0=91=E9=94=8B

--94eb2c1bdad0b2bd2d054af7cc3c--