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]
