[
https://issues.apache.org/jira/browse/KYLIN-4024?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16859413#comment-16859413
]
XiaoXiang Yu commented on KYLIN-4024:
-------------------------------------
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)
