[
https://issues.apache.org/jira/browse/KYLIN-4024?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16859439#comment-16859439
]
XiaoXiang Yu commented on KYLIN-4024:
-------------------------------------
Manual test by following kylin.properties.
{code}kylin.query.pushdown.runner-class-name=org.apache.kylin.query.adhoc.PushDownRunnerJdbcImpl
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}
And push to presto successfully.
{code}2019-06-09 20:01:04,608 DEBUG [Query
42668ba8-098d-0356-bb4a-99a1cc55345c-67] util.PushDownUtil:98 : Query Pushdown
runner org.apache.kylin.query.adhoc.PushDownRunnerJdbcImpl@40bc413c
2019-06-09 20:01:04,899 WARN [Query 42668ba8-098d-0356-bb4a-99a1cc55345c-67]
common.QueryContext:196 : Cannot find CubeSegmentStatisticsResult for context 0
2019-06-09 20:01:04,899 INFO [Query 42668ba8-098d-0356-bb4a-99a1cc55345c-67]
service.QueryService:1142 : Processed rows for each storageContext:
2019-06-09 20:01:04,900 INFO [Query 42668ba8-098d-0356-bb4a-99a1cc55345c-67]
service.BadQueryDetector:203 : Pushdown query has been running 0.327 seconds
(project:learn_kylin, thread: 0x43, user:ADMIN, query
id:42668ba8-098d-0356-bb4a-99a1cc55345c) -- select * from KYLIN_COUNTRY
2019-06-09 20:01:04,902 DEBUG [Query 42668ba8-098d-0356-bb4a-99a1cc55345c-67]
badquery.BadQueryHistoryManager:65 : Loaded 2 Bad Query(s)
2019-06-09 20:01:04,905 INFO [Query 42668ba8-098d-0356-bb4a-99a1cc55345c-67]
service.QueryService:481 : Stats of SQL response: isException: false, duration:
332, total scan count 0
2019-06-09 20:01:04,905 DEBUG [Query 42668ba8-098d-0356-bb4a-99a1cc55345c-67]
util.CheckUtil:40 : query does not hit cube nor hybrid
2019-06-09 20:01:04,905 INFO [Query 42668ba8-098d-0356-bb4a-99a1cc55345c-67]
service.QueryService:354 :
==========================[QUERY]===============================
Query Id: 42668ba8-098d-0356-bb4a-99a1cc55345c
SQL: select * from KYLIN_COUNTRY
User: ADMIN
Success: true
Duration: 0.332
Project: learn_kylin
Realization Names: []
Cuboid Ids: []
Total scan count: 0
Total scan bytes: 0
Result row count: 244
Accept Partial: true
Is Partial Result: false
Hit Exception Cache: false
Storage cache used: false
Is Query Push-Down: true
Is Prepare: false
Trace URL: null
Message: null
==========================[QUERY]===============================
{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)
