From user-return-4053-archive-asf-public=cust-asf.ponee.io@kylin.apache.org Mon Jan 28 02:28:38 2019 Return-Path: X-Original-To: archive-asf-public@cust-asf.ponee.io Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by mx-eu-01.ponee.io (Postfix) with SMTP id 45355180600 for ; Mon, 28 Jan 2019 02:28:37 +0100 (CET) Received: (qmail 93395 invoked by uid 500); 28 Jan 2019 01:28: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 93384 invoked by uid 99); 28 Jan 2019 01:28:36 -0000 Received: from mail-relay.apache.org (HELO mailrelay1-lw-us.apache.org) (207.244.88.152) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 28 Jan 2019 01:28:36 +0000 Received: from mail-io1-f50.google.com (mail-io1-f50.google.com [209.85.166.50]) by mailrelay1-lw-us.apache.org (ASF Mail Server at mailrelay1-lw-us.apache.org) with ESMTPSA id 2FDC610F4 for ; Mon, 28 Jan 2019 01:28:35 +0000 (UTC) Received: by mail-io1-f50.google.com with SMTP id b23so12119492ios.10 for ; Sun, 27 Jan 2019 17:28:35 -0800 (PST) X-Gm-Message-State: AHQUAuZLDHeqywaFNJCfo060Egxq5cPTm3Zm3cG5zJ343jCJBG/ZxawG kGf/TmUoWYr/gRwflBA0i/Px/siiPNeyF+UPG68= X-Google-Smtp-Source: AHgI3IaLFGQjUSHWTgiMRFbaUEmkb9xJCtkEa8E66EMbe5htT3/ckfB4hM/PfINXRLe4B/TBF6/N2ZWDxkITYkHtav4= X-Received: by 2002:a6b:8d11:: with SMTP id p17mr8057493iod.74.1548638914623; Sun, 27 Jan 2019 17:28:34 -0800 (PST) MIME-Version: 1.0 References: <367ec1919d9f45c38d4773f766357302@trendy-global.com> In-Reply-To: From: ShaoFeng Shi Date: Mon, 28 Jan 2019 09:27:58 +0800 X-Gmail-Original-Message-ID: Message-ID: Subject: Re: Re:where to put the jdbc driver jar for pushdown To: user Cc: nichunen Content-Type: multipart/alternative; boundary="000000000000643ff205807a9876" --000000000000643ff205807a9876 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable zhijia, What's your Kylin version? Did you ever modify Kylin's bash script? You can also try to put the jar into tomcat/webapps/kylin/WEB-INF/lib . Best regards, Shaofeng Shi =E5=8F=B2=E5=B0=91=E9=94=8B Apache Kylin PMC Work email: shaofeng.shi@kyligence.io Kyligence Inc: https://kyligence.io/ Apache Kylin FAQ: https://kylin.apache.org/docs/gettingstarted/faq.html Join Kylin user mail group: user-subscribe@kylin.apache.org Join Kylin dev mail group: dev-subscribe@kylin.apache.org I=C3=B1igo Mart=C3=ADnez =E4=BA=8E2019=E5=B9=B41= =E6=9C=8824=E6=97=A5=E5=91=A8=E5=9B=9B =E4=B8=8B=E5=8D=8810:52=E5=86=99=E9= =81=93=EF=BC=9A > At kylin.sh, you can see that you should locate new jar in $KYLIN_HOME/ex= t > or $KYLIN_HOME/lib > > export > HBASE_CLASSPATH_PREFIX=3D${KYLIN_HOME}/conf:${KYLIN_HOME}/lib/*:${KYLIN_H= OME}/ext/*:${HBASE_CLASSPATH_PREFIX} > > However, if want to be sure, just add your extra library here: > > #additionally add tomcat libs to HBASE_CLASSPATH_PREFIX > export > HBASE_CLASSPATH_PREFIX=3D${tomcat_root}/bin/bootstrap.jar:${tomcat_root}/= bin/tomcat-juli.jar:${tomcat_root}/lib/*:${HBASE_CLASSPATH_PREFIX}:/PATH/TO= /YOUR/LIBRARY.jar > > > > El jue., 24 ene. 2019 a las 15:37, =E6=9E=97=E5=BF=97=E4=BD=B3[Forest Lin= ] (< > Forest.lin@trendy-global.com>) escribi=C3=B3: > >> Yes, i did the restart but it does not work >> >> thx, >> Forest >> >> ---Original--- >> From: "nichunen" >> Date: Thu, Jan 24, 2019 20:10 PM >> To: "user@kylin.apache.org"; >> Subject: Re:where to put the jdbc driver jar for pushdown >> >> Hi Forest, >> >> As I know, put the jar to $KYLIN_HOME/ext should work, have you restarte= d >> your Kylin after that? >> >> -- >> Best regards, >> >> Ni Chunen / George >> >> At 2019-01-24 18:54:42, "=E6=9E=97=E5=BF=97=E4=BD=B3[Forest Lin]" >> wrote: >> >> Hi all, >> >> I=E2=80=99d like to set kylin pushdown to presto, below is my setting. >> >> >> >> kylin.query.pushdown.runner-class-name=3Dorg.apache.kylin.query.adhoc.Pu= shDownRunnerJdbcImpl >> # >> kylin.query.pushdown.update-enabled=3Dtrue >> kylin.query.pushdown.jdbc.url=3Djdbc:presto://emr-header-1:9090/hive >> kylin.query.pushdown.jdbc.driver=3Dcom.facebook.presto.jdbc.PrestoDriver >> kylin.query.pushdown.jdbc.username=3Dhive >> kylin.query.pushdown.jdbc.password=3D >> # >> kylin.query.pushdown.jdbc.pool-max-total=3D8 >> kylin.query.pushdown.jdbc.pool-max-idle=3D8 >> kylin.query.pushdown.jdbc.pool-min-idle=3D0 >> >> >> However, in run time, it has error: >> java.lang.RuntimeException: com.facebook.presto.jdbc.PrestoDriver >> Caused by: java.lang.ClassNotFoundException: >> com.facebook.presto.jdbc.PrestoDriver >> >> May I know where the presto-jdbc-300.jar should be put to ? I have try >> $KYLIN_HOME/ext and $KYLIN_HOME/lib, but no luck >> >> Thanks >> Forest >> >> >> >> >> > > -- > > > > > > =C3=8D=C3=B1igo Mart=C3=ADnez > SYSTEMS MANAGER > imartinez@telecoming.com > > > > > > > [image: Telecoming - Make it digital] > [image: 5000_empresas] > [image: 1000_empresas] > > Paseo de la Castellana, 95. Torre Europa, pl 16. 28046 Madrid, Spain | > telecoming.com > > > > Este correo electr=C3=B3nico y sus archivos adjuntos est=C3=A1n dirigid= os > =C3=BAnicamente a la(s) direcci=C3=B3n(es) indicada(s) anteriormente. El = car=C3=A1cter > confidencial, personal e intransferible del mismo est=C3=A1 protegido > legalmente. Cualquier publicaci=C3=B3n, reproducci=C3=B3n, distribuci=C3= =B3n o > retransmisi=C3=B3n no autorizada, ya sea completa o en parte, se encuentr= a > prohibida. Si ha recibido este mensaje por equivocaci=C3=B3n, notif=C3=AD= quelo > inmediatamente a la persona que lo ha enviado y borre el mensaje original > junto con sus ficheros anexos sin leerlo ni grabarlo en modo alguno. > --000000000000643ff205807a9876 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
zhijia,

What's your Kylin version? = Did you ever modify Kylin's bash script? You can also try to put the ja= r into tomcat/webapps/kylin/WEB-INF/lib .

=
Best regards,

Shaofeng Shi =E5=8F=B2=E5=B0=91=E9=94=8B<= /div>
Apache Kylin PMC
Work email: shaofeng.shi@kyligence.io
Kyligence Inc:=C2=A0https://kyligence.io/

=
Join Kylin user mail group: user-subscribe@kylin.apache.org
Jo= in Kylin dev mail group: dev-subscribe@kylin.apache.org



=
I=C3= =B1igo Mart=C3=ADnez <imarti= nez@telecoming.com> =E4=BA=8E2019=E5=B9=B41=E6=9C=8824=E6=97=A5=E5= =91=A8=E5=9B=9B =E4=B8=8B=E5=8D=8810:52=E5=86=99=E9=81=93=EF=BC=9A
At kylin.sh, you can see that you should lo= cate new jar in $KYLIN_HOME/ext or $KYLIN_HOME/lib

=C2=A0 =C2=A0 export HBASE_CLASSPATH_PREFIX=3D${KYLIN_HOME}/conf:${KYLIN_H= OME}/lib/*:${KYLIN_HOME}/ext/*:${HBASE_CLASSPATH_PREFIX}

However, if want to be sure, just add your extra library here:
=

=C2=A0 =C2=A0 #additionally add tomcat libs to HBA= SE_CLASSPATH_PREFIX
=C2=A0 =C2=A0 export HBASE_CLASSPATH_PREFIX= =3D${tomcat_root}/bin/bootstrap.jar:${tomcat_root}/bin/tomcat-juli.jar:${to= mcat_root}/lib/*:${HBASE_CLASSPATH_PREFIX}:/PATH/TO/YOUR/LIBRARY.jar
<= /div>



E= l jue., 24 ene. 2019 a las 15:37, =E6=9E=97=E5=BF=97=E4=BD=B3[Forest Lin] (= <Fores= t.lin@trendy-global.com>) escribi=C3=B3:
Yes, i did the restart but it does not wor= k

thx,
Forest

---Original---
From: "nichunen"<nic@apache.org>
Date: Thu, Jan 24, 2019 20:10 PM
To: "user@k= ylin.apache.org"<user@kylin.apache.org>;
Subject: Re:where to put the jdbc driver jar for pushdown

Hi Forest,

As I know, put the jar to $KYLIN_HOME/ext should work, have you restarted y= our Kylin after that?

--
Best regards,

Ni Chunen / George

At 2019-01-24 18:54:42, "=E6=9E=97=E5=BF=97=E4=BD=B3[Forest Lin]"= <Fore= st.lin@trendy-global.com> wrote:

Hi all,

I=E2=80=99d like to set kylin pushdown to presto, below is my setting.


kylin.query.pushdown.runner-class-name=3Dorg.apache.kylin.query.adhoc.PushD= ownRunnerJdbcImpl
#
kylin.query.pushdown.update-enabled=3Dtrue
kylin.query.pushdown.jdbc.url=3Djdbc:presto://emr-header-1:9090/hive
kylin.query.pushdown.jdbc.driver=3Dcom.facebook.presto.jdbc.PrestoDriver kylin.query.pushdown.jdbc.username=3Dhive
kylin.query.pushdown.jdbc.password=3D
#
kylin.query.pushdown.jdbc.pool-max-total=3D8
kylin.query.pushdown.jdbc.pool-max-idle=3D8
kylin.query.pushdown.jdbc.pool-min-idle=3D0


However, in run time, it has error:
java.lang.RuntimeException: com.facebook.presto.jdbc.PrestoDriver
Caused by: java.lang.ClassNotFoundException: com.facebook.presto.jdbc.Prest= oDriver

May I know where the presto-jdbc-300.jar should be put to ?=C2=A0 I have tr= y=C2=A0 $KYLIN_HOME/ext and $KYLIN_HOME/lib, but no luck

Thanks
Forest






--

=C2=A0
=
=C2=A0
=C2=A0
=C2=A0
<= /table>
=C3=8D=C3=B1igo Mart=C3=ADnez
SYSTEMS MANAGER
imartinez@tel= ecoming.com=C2=A0=C2=A0
=C2=A0
=C2=A0
=C2=A0
=C2=A0
=C2=A0
<= td width=3D"8" style=3D"font-size:12px;line-height:14px;white-space:nowrap"= >=C2=A0
=C2=A03D"Telecomi==C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0
3D"5000_e=
=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0
3D"1000_empresas"
=C2=A0
=C2=A0
Paseo de la Castellana, 95. Torre Europ= a, pl 16. 28046 Madrid, Spain |telecoming.com=
=
=C2=A0
=C2=A0Este correo ele= ctr=C3=B3nico y sus archivos adjuntos est=C3=A1n dirigidos =C3=BAnicamente = a la(s) direcci=C3=B3n(es) indicada(s) anteriormente. El car=C3=A1cter conf= idencial, personal e intransferible del mismo est=C3=A1 protegido legalment= e. Cualquier publicaci=C3=B3n, reproducci=C3=B3n, distribuci=C3=B3n o retra= nsmisi=C3=B3n no autorizada, ya sea completa o en parte, se encuentra prohi= bida. Si ha recibido este mensaje por equivocaci=C3=B3n, notif=C3=ADquelo i= nmediatamente a la persona que lo ha enviado y borre el mensaje original ju= nto con sus ficheros anexos sin leerlo ni grabarlo en modo alguno.
--000000000000643ff205807a9876--