[
https://issues.apache.org/jira/browse/KYLIN-5227?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17579388#comment-17579388
]
liyang commented on KYLIN-5227:
-------------------------------
Without group by and aggregate function, this is a raw query. It is expected
that raw query will go to spark pushdown and may take longer than aggregated
queries that are answered by pre-computed data.
Things look normal suggest close this JIRA.
{code:java}
select：
b.boname,
h.hdrcode
from
b_booklist b
inner join b_holding h
on h.borecno=b.borecno{code}
> Kylin association query does not use ad hoc query, but push down spark query
> ----------------------------------------------------------------------------
>
> Key: KYLIN-5227
> URL: https://issues.apache.org/jira/browse/KYLIN-5227
> Project: Kylin
> Issue Type: Bug
> Reporter: huang song
> Priority: Major
> Attachments: image-2022-08-12-09-24-42-891.png
>
>
> The query statement is as follows
> select：
> b.boname,
> h.hdrcode
> from
> b_booklist b
> inner join b_holding h
> on h.borecno=b.borecno
> Build cube fields as follows，
> All other steps are default
> !image-2022-08-12-09-24-42-891.png!
> Execute the push-down query of the above sql walk；
> take a long time
> I don't know where to build what's the problem
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
