[ 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)