qphien opened a new issue #939:
URL: https://github.com/apache/incubator-kyuubi/issues/939
# Describe the proposal
To perform highly selective file pruning and make queries more efficient,
files must be mutually exclusive in their data. Z-order is a popular data
skipping technique using in a variety of RDBMS systems as well as cloud based
databases to enhance query efficiency with complex filters.
There is some work to do with zorder:
- Support SQL: `OPTIMIZE <table> [WHERE <predicate>] ZORDER BY (col1, col2,
...)`
Optimize data matching the given partition predicate. `WHERE` clause only
supports partition filters.
- Support SQL: `CREATE <table> ... ZORDER BY (col1, col2, ...)`
Data will be sorted by zorder automatically before writing to zorder
table.
# Task list
<!--
Several sub-tasks with the pre-create issues, and it's better to @ the
assignees if you know.
More details can see github docs
https://docs.github.com/en/issues/tracking-your-work-with-issues/about-task-lists.
A simple example:
- [ ] #1
- [ ] #11 @user1
- [ ] #12
- [ ] #13
- [ ] #2 @user2
- [ ] #3
-->
--
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.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
