[
https://issues.apache.org/jira/browse/KYLIN-4104?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17129995#comment-17129995
]
ASF GitHub Bot commented on KYLIN-4104:
---------------------------------------
zhangayqian edited a comment on pull request #928:
URL: https://github.com/apache/kylin/pull/928#issuecomment-641082534
## Design test cases
### Prepare test env
- Prepare Presto env and import kylin_sales
- bin/kylin.sh start
### Test case
#### Case-1
- Verify single query engine(hive) pushdown is available
- Config kylin query pushdown to hive according to
https://github.com/apache/kylin/pull/1027.
- Restart kylin and disable all the cube in `learn_kylin`
- execute `select PART_DT, sum(price) from kylin_sales group by PART_DT
limit 1` in project `learn_kylin`.
#### Expected result
- SQL is pushed down to hive and returns the correct result.
#### Case-2
- Verify single query engine(presto) pushdown is available
- Config kylin query pushdown to presto according to
https://github.com/apache/kylin/pull/1027.
- Restart kylin and disable all the cube in `learn_kylin`
- execute `select PART_DT, sum(price) from kylin_sales group by PART_DT
limit 1` in project `learn_kylin`.
#### Expected result
- SQL is pushed down to presto and returns the correct result.
#### Case-3
- Verify multi Jdbc pushdown is available
- Config kylin query pushdown to mysql, hive and presto according to
https://github.com/apache/kylin/pull/1027.
- Restart kylin and disable all the cube in `learn_kylin`
- execute `select PART_DT, sum(price) from kylin_sales group by PART_DT
limit 1` in project `learn_kylin`.
#### Expected result
- SQL is pushed down to hive and returns the correct result.
----------------------------------------------------------------
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]
> Support multi jdbc pushdown runners to execute query/update
> -----------------------------------------------------------
>
> Key: KYLIN-4104
> URL: https://issues.apache.org/jira/browse/KYLIN-4104
> Project: Kylin
> Issue Type: New Feature
> Reporter: weibin0516
> Assignee: weibin0516
> Priority: Major
> Fix For: v3.1.0
>
>
> Current (version 3.0.0-SNAPSHOT), kylin support only one kind of pushdown
> query engine. In some user's scenario, need pushdown query to mysql, spark
> sql，hive etc.
> I think kylin need support multiple pushdowns.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
