You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "dataroaring (via GitHub)" <gi...@apache.org> on 2023/04/13 03:44:38 UTC
[GitHub] [doris] dataroaring opened a new issue, #18621: [Enhancement] duplicate table without key
dataroaring opened a new issue, #18621:
URL: https://github.com/apache/doris/issues/18621
### Search before asking
- [X] I had searched in the [issues](https://github.com/apache/doris/issues?q=is%3Aissue) and found no similar issues.
### Description
Doris skips data by short index, it is resource consuming to sorting data. Sometimes users do not need short index at all, so we can cancel enfore sort property on duplicate table.
### Solution
- ddl which creates a table without key
- load
- compaction
- query
### Are you willing to submit PR?
- [ ] Yes I am willing to submit a PR!
### Code of Conduct
- [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct)
--
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: commits-unsubscribe@doris.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [doris] dataroaring closed issue #18621: [Enhancement] duplicate table without key
Posted by "dataroaring (via GitHub)" <gi...@apache.org>.
dataroaring closed issue #18621: [Enhancement] duplicate table without key
URL: https://github.com/apache/doris/issues/18621
--
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: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [doris] herry2038 commented on issue #18621: [Enhancement] duplicate table without key
Posted by "herry2038 (via GitHub)" <gi...@apache.org>.
herry2038 commented on issue #18621:
URL: https://github.com/apache/doris/issues/18621#issuecomment-1519373576
check todo list
- [ ] 检查Scannode查询路径；确定无需变更；
- [ ] 检查block reader查询路径；确定无需变更；
--
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: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [doris] waywtdcc commented on issue #18621: [Enhancement] duplicate table without key
Posted by "waywtdcc (via GitHub)" <gi...@apache.org>.
waywtdcc commented on issue #18621:
URL: https://github.com/apache/doris/issues/18621#issuecomment-1507955686
Does this mean that duplicate tables can be created in the following way?
CREATE TABLE cc_test.cc32 (
id int NULL,
name varchar(200) default 'cc'
)
DUPLICATE
DISTRIBUTED BY HASH(`id`) BUCKETS 10
--
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: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [doris] nextdreamblue commented on issue #18621: [Enhancement] duplicate table without key
Posted by "nextdreamblue (via GitHub)" <gi...@apache.org>.
nextdreamblue commented on issue #18621:
URL: https://github.com/apache/doris/issues/18621#issuecomment-1506621417
🙋🏻♀️
--
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: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [doris] nextdreamblue commented on issue #18621: [Enhancement] duplicate table without key
Posted by "nextdreamblue (via GitHub)" <gi...@apache.org>.
nextdreamblue commented on issue #18621:
URL: https://github.com/apache/doris/issues/18621#issuecomment-1515669507
before this issue, user can define default DUP_KEYS and some head columns for keys.
after this issue, if user create table without set key type and key columns, will create a DUP_KEYS olap table without key columns.
```
CREATE TABLE `test` (
`user_id` bigint(20) NULL,
`is_delete` tinyint(4) NULL,
`client_version_int` int(11) NULL
) ENGINE=OLAP
COMMENT 'OLAP'
DISTRIBUTED BY HASH(`user_id`) BUCKETS 4
PROPERTIES (
"replication_allocation" = "tag.location.default: 1"
);
```
after this issue, user will get a duplicate table without key columns
--
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: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org