"default" is a keyword of Calcite. Please quote it with double quotation marks + in upper case: "DEFAULT"."KYLIN_CAL_DT"
Best regards, Shaofeng Shi 史少锋 Apache Kylin PMC Work email: [email protected] Kyligence Inc: https://kyligence.io/ Apache Kylin FAQ: https://kylin.apache.org/docs/gettingstarted/faq.html Join Kylin user mail group: [email protected] Join Kylin dev mail group: [email protected] 林志佳[Forest Lin] <[email protected]> 于2019年1月28日周一 上午10:36写道： > I am using kylin 2.6. > > > > Found that It is caused by the latest *presto-jdbc-300.jar* since the > jdbc.drive > is changed to “io.presto..” instead of “com.facebook..” > > > > Kylin can connect to presto after using presto-jdbc-0.208.jar. However it > can’t execute the pushdown query: select * from hive.default.KYLIN_CAL_DT > to presto > > > > With below error: > > > > Encountered ". default" at line 1, column 19. Was expecting one of: <EOF> > "ORDER" ... "LIMIT" ... "OFFSET" ... "FETCH" ... "NATURAL" ... "JOIN" ... > "INNER" ... "LEFT" ... "RIGHT" ... "FULL" ... "CROSS" ... "," ... "OUTER" > ... "EXTEND" ... "(" ... "MATCH_RECOGNIZE" ... "." ... "AS" ... > <IDENTIFIER> ... <QUOTED_IDENTIFIER> ... <BACK_QUOTED_IDENTIFIER> ... > <BRACKET_QUOTED_IDENTIFIER> ... <UNICODE_QUOTED_IDENTIFIER> ... > "TABLESAMPLE" ... "WHERE" ... "GROUP" ... "HAVING" ... "WINDOW" ... "UNION" > ... "INTERSECT" ... "EXCEPT" ... "MINUS" ... "." <IDENTIFIER> ... "." > <QUOTED_IDENTIFIER> ... "." <BACK_QUOTED_IDENTIFIER> ... "." > <BRACKET_QUOTED_IDENTIFIER> ... "." <UNICODE_QUOTED_IDENTIFIER> ... "." "*" > ... > > > > Best Regards, > > Forest > > *发件人:* ShaoFeng Shi [mailto:[email protected]] > *发送时间:* 2019年1月28日 9:28 > *收件人:* user > *抄送:* nichunen > *主题:* Re: Re:where to put the jdbc driver jar for pushdown > > > > 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 史少锋 > > Apache Kylin PMC > > Work email: [email protected] > > Kyligence Inc: https://kyligence.io/ > > > > Apache Kylin FAQ: https://kylin.apache.org/docs/gettingstarted/faq.html > > Join Kylin user mail group: [email protected] > > Join Kylin dev mail group: [email protected] > > > > > > > > > > Iñigo Martínez <[email protected]> 于2019年1月24日周四 下午10:52写道： > > At kylin.sh, you can see that you should locate new jar in $KYLIN_HOME/ext > or $KYLIN_HOME/lib > > > > export > HBASE_CLASSPATH_PREFIX=${KYLIN_HOME}/conf:${KYLIN_HOME}/lib/*:${KYLIN_HOME}/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=${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, 林志佳[Forest Lin] (< > [email protected]>) escribió: > > Yes, i did the restart but it does not work > > thx, > Forest > > ---Original--- > From: "nichunen"<[email protected]> > Date: Thu, Jan 24, 2019 20:10 PM > To: "[email protected]"<[email protected]>; > 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 > your Kylin after that? > > -- > Best regards, > > Ni Chunen / George > > At 2019-01-24 18:54:42, "林志佳[Forest Lin]" <[email protected]> > wrote: > > Hi all, > > I’d like to set kylin pushdown to presto, below is my setting. > > > > kylin.query.pushdown.runner-class-name=org.apache.kylin.query.adhoc.PushDownRunnerJdbcImpl > # > kylin.query.pushdown.update-enabled=true > kylin.query.pushdown.jdbc.url=jdbc:presto://emr-header-1:9090/hive > kylin.query.pushdown.jdbc.driver=com.facebook.presto.jdbc.PrestoDriver > kylin.query.pushdown.jdbc.username=hive > kylin.query.pushdown.jdbc.password= > # > kylin.query.pushdown.jdbc.pool-max-total=8 > kylin.query.pushdown.jdbc.pool-max-idle=8 > kylin.query.pushdown.jdbc.pool-min-idle=0 > > > 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 > > > > > > > -- > > > > > > > > > > > > *Íñigo Martínez* > > SYSTEMS MANAGER > > [email protected] <[email protected]%3C> > > > > > > > > > > > > > > > > [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 <http://www.telecoming.com/> > > > > > > > > Este correo electrónico y sus archivos adjuntos están dirigidos únicamente > a la(s) dirección(es) indicada(s) anteriormente. El carácter confidencial, > personal e intransferible del mismo está protegido legalmente. Cualquier > publicación, reproducción, distribución o retransmisión no autorizada, ya > sea completa o en parte, se encuentra prohibida. Si ha recibido este > mensaje por equivocación, notifí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. > > > >
