You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by GitBox <gi...@apache.org> on 2021/09/14 02:12:28 UTC
[GitHub] [incubator-doris] stalary opened a new issue #6641: [Feature] show create table support StorageMedium
stalary opened a new issue #6641:
URL: https://github.com/apache/incubator-doris/issues/6641
### Search before asking
- [X] I had searched in the [issues](https://github.com/apache/incubator-doris/issues?q=is%3Aissue) and found no similar issues.
### Description
show create table support StorageMedium/CooldownTime
### Use case
We are currently migrating some tables from HDD to SSD. Currently, we can only check whether the table uses SSD through /dbs, which is not intuitive
### Related issues
_No response_
### Are you willing to submit PR?
- [X] 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
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] [incubator-doris] stalary edited a comment on issue #6641: [Feature] show create table support StorageMedium
Posted by GitBox <gi...@apache.org>.
stalary edited a comment on issue #6641:
URL: https://github.com/apache/incubator-doris/issues/6641#issuecomment-918831851
when use show create test ```CREATE TABLE `test` (
`courseId` int(11) NOT NULL COMMENT "",
`lessonId` int(11) NOT NULL COMMENT "",
`type` int(11) REPLACE_IF_NOT_NULL NULL COMMENT ""
) ENGINE=OLAP
AGGREGATE KEY(`courseId`, `lessonId`)
COMMENT "测试"
DISTRIBUTED BY HASH(`courseId`) BUCKETS 150
PROPERTIES (
"replication_num" = "3",
"in_memory" = "false",
"storage_format" = "V2",
"storage_medium" = "SSD",
"CooldownTime" = "9999-12-31 23:59:59"
);```
--
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] [incubator-doris] stalary edited a comment on issue #6641: [Feature] show create table support StorageMedium
Posted by GitBox <gi...@apache.org>.
stalary edited a comment on issue #6641:
URL: https://github.com/apache/incubator-doris/issues/6641#issuecomment-918831851
when use show create test
```CREATE TABLE `test` (
`courseId` int(11) NOT NULL COMMENT "",
`lessonId` int(11) NOT NULL COMMENT "",
`type` int(11) REPLACE_IF_NOT_NULL NULL COMMENT ""
) ENGINE=OLAP
AGGREGATE KEY(`courseId`, `lessonId`)
COMMENT "测试"
DISTRIBUTED BY HASH(`courseId`) BUCKETS 150
PROPERTIES (
"replication_num" = "3",
"in_memory" = "false",
"storage_format" = "V2",
"storage_medium" = "SSD",
"cooldownTime" = "9999-12-31 23:59:59"
);```
add storage_medium and cooldownTime
--
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] [incubator-doris] morningman commented on issue #6641: [Feature] show create table support StorageMedium
Posted by GitBox <gi...@apache.org>.
morningman commented on issue #6641:
URL: https://github.com/apache/incubator-doris/issues/6641#issuecomment-918814005
Doris do not support setting these property for each partition in `create table stmt`.
So what will you do to support this?
--
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] [incubator-doris] stalary commented on issue #6641: [Feature] show create table support StorageMedium
Posted by GitBox <gi...@apache.org>.
stalary commented on issue #6641:
URL: https://github.com/apache/incubator-doris/issues/6641#issuecomment-918831851
when use show create test
--
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] [incubator-doris] stalary commented on issue #6641: [Feature] show create table support StorageMedium
Posted by GitBox <gi...@apache.org>.
stalary commented on issue #6641:
URL: https://github.com/apache/incubator-doris/issues/6641#issuecomment-918883643
Currently, there is a problem. If there is no show create table, it may cause HDD to be built in the next table reconstruction
--
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