[
https://issues.apache.org/jira/browse/KYLIN-4365?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17138332#comment-17138332
]
ASF GitHub Bot commented on KYLIN-4365:
---------------------------------------
zhangayqian commented on pull request #1086:
URL: https://github.com/apache/kylin/pull/1086#issuecomment-645298669
## Design test case
### Test case
- Modify pushdown configuration in kylin.properties to pushdown query to
SQLServer.
```
kylin.query.pushdown.runner-class-name=org.apache.kylin.query.adhoc.PushDownRunnerJdbcImpl
#
kylin.query.pushdown.update-enabled=false
kylin.query.pushdown.jdbc.url=jdbc:sqlserver://10.3.0.221:1433;databasename=temp
kylin.query.pushdown.jdbc.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
kylin.query.pushdown.jdbc.username=sa
kylin.query.pushdown.jdbc.password=
```
- Prepare `kylin_sales` table in SQLserver
- Setup kylin and disable all cube in `learn_kylin`
- Execute sql
```
with tmp as (select buyer_id from kylin_sales),
tmp2 as (select * from kylin_sales)
select * from tmp,tmp2 where tmp.buyer_id = tmp2.buyer_id
```
### Expected result
- SQL executed successfully and returned correct results.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
[email protected]
> RDBMS pushdown failed with with clause
> --------------------------------------
>
> Key: KYLIN-4365
> URL: https://issues.apache.org/jira/browse/KYLIN-4365
> Project: Kylin
> Issue Type: Bug
> Components: Query Engine, RDBMS Source
> Affects Versions: all
> Reporter: rongchuan.jin
> Assignee: rongchuan.jin
> Priority: Major
> Fix For: v3.1.0
>
>
> When use pushdown for RDBMS, I query with following sql:
> `with tmp as (select id from a),tmp2 as (select * from b) select * from
> tmp,tmp2 where tmp.id = tmp2.id` it will cause exception like 'table tmp not
> exists'.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
