You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@kylin.apache.org by "XiaoXiang Yu (JIRA)" <ji...@apache.org> on 2019/06/09 09:15:00 UTC
[jira] [Comment Edited] (KYLIN-4024) when ad-hoc Push Down by
presto engine Unrecognized column type: INTEGER,TIME,VARBINARY
[ https://issues.apache.org/jira/browse/KYLIN-4024?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16859413#comment-16859413 ]
XiaoXiang Yu edited comment on KYLIN-4024 at 6/9/19 9:14 AM:
-------------------------------------------------------------
I have reproduced the same error in my debug env. The error stacktrace is attached as follow:
{code}kylin.query.pushdown.runner-class-name=org.apache.kylin.query.adhoc.PushDownRunnerJdbcImpl
#
##kylin.query.pushdown.update-enabled=false
kylin.query.pushdown.jdbc.url=jdbc:presto://cdh-master:7060/hive/default
kylin.query.pushdown.jdbc.driver=com.facebook.presto.jdbc.PrestoDriver
kylin.query.pushdown.jdbc.username=test
kylin.query.pushdown.jdbc.password=
{code}
{code:java}
2019-06-09 17:07:53,110 ERROR [Query 9efebfc3-bb51-7d79-560a-aebe6d80821f-69] service.QueryService:989 : pushdown engine failed current query too
java.sql.SQLException: Unrecognized column type: INTEGER
at org.apache.kylin.query.adhoc.PushDownRunnerJdbcImpl.toSqlType(PushDownRunnerJdbcImpl.java:260)
at org.apache.kylin.query.adhoc.PushDownRunnerJdbcImpl.extractColumnMeta(PushDownRunnerJdbcImpl.java:192)
at org.apache.kylin.query.adhoc.PushDownRunnerJdbcImpl.executeQuery(PushDownRunnerJdbcImpl.java:68)
at org.apache.kylin.query.util.PushDownUtil.tryPushDownQuery(PushDownUtil.java:122)
at org.apache.kylin.query.util.PushDownUtil.tryPushDownSelectQuery(PushDownUtil.java:69)
at org.apache.kylin.rest.service.QueryService.pushDownQuery(QueryService.java:986)
at org.apache.kylin.rest.service.QueryService.executeRequest(QueryService.java:943)
at org.apache.kylin.rest.service.QueryService.queryWithSqlMassage(QueryService.java:641)
at org.apache.kylin.rest.service.QueryService.query(QueryService.java:208)
at org.apache.kylin.rest.service.QueryService.queryAndUpdateCache(QueryService.java:468)
at org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryService.java:429)
at org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryService.java:367)
at org.apache.kylin.rest.controller.QueryController.query(QueryController.java:87)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
{code}
was (Author: hit_lacus):
I have reproduced the same error in my debug env. The error stacktrace is attached as follow:
{code:java}
2019-06-09 17:07:53,110 ERROR [Query 9efebfc3-bb51-7d79-560a-aebe6d80821f-69] service.QueryService:989 : pushdown engine failed current query too
java.sql.SQLException: Unrecognized column type: INTEGER
at org.apache.kylin.query.adhoc.PushDownRunnerJdbcImpl.toSqlType(PushDownRunnerJdbcImpl.java:260)
at org.apache.kylin.query.adhoc.PushDownRunnerJdbcImpl.extractColumnMeta(PushDownRunnerJdbcImpl.java:192)
at org.apache.kylin.query.adhoc.PushDownRunnerJdbcImpl.executeQuery(PushDownRunnerJdbcImpl.java:68)
at org.apache.kylin.query.util.PushDownUtil.tryPushDownQuery(PushDownUtil.java:122)
at org.apache.kylin.query.util.PushDownUtil.tryPushDownSelectQuery(PushDownUtil.java:69)
at org.apache.kylin.rest.service.QueryService.pushDownQuery(QueryService.java:986)
at org.apache.kylin.rest.service.QueryService.executeRequest(QueryService.java:943)
at org.apache.kylin.rest.service.QueryService.queryWithSqlMassage(QueryService.java:641)
at org.apache.kylin.rest.service.QueryService.query(QueryService.java:208)
at org.apache.kylin.rest.service.QueryService.queryAndUpdateCache(QueryService.java:468)
at org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryService.java:429)
at org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryService.java:367)
at org.apache.kylin.rest.controller.QueryController.query(QueryController.java:87)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
{code}
> when ad-hoc Push Down by presto engine Unrecognized column type: INTEGER,TIME,VARBINARY
> ----------------------------------------------------------------------------------------
>
> Key: KYLIN-4024
> URL: https://issues.apache.org/jira/browse/KYLIN-4024
> Project: Kylin
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: all, v3.0.0, v2.6.2
> Reporter: wangxiaojing
> Assignee: XiaoXiang Yu
> Priority: Major
> Fix For: Future
>
>
> Hello ,
> When do ad-hoc Push Down query by presto engine ,it throws Unrecognized column type,like INTEGER,TIME,VARBINARY 。
> The field of the table that appears in the hive is defined as an int type. If the Presto query is used, the INTEGER type will be returned.
> At this time, kylin ad-hoc push down will not recognize this type.
>
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)