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 2022/05/06 08:04:43 UTC
[GitHub] [incubator-doris] stalary opened a new issue, #9411: [Bug] list partition error
stalary opened a new issue, #9411:
URL: https://github.com/apache/incubator-doris/issues/9411
### 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.
### Version
master
### What's Wrong?
origin table:
```sql
CREATE TABLE `country_codes` (
`country_code` varchar(2) NOT NULL COMMENT "",
`country_name` varchar(32) NOT NULL COMMENT "",
`calling_code` int(11) NOT NULL COMMENT ""
) ENGINE=OLAP
DUPLICATE KEY(`country_code`)
COMMENT "OLAP"
DISTRIBUTED BY HASH(`country_code`, `country_name`, `calling_code`) BUCKETS 1
PROPERTIES (
"replication_allocation" = "tag.location.default: 1",
"in_memory" = "false",
"storage_format" = "V2"
)
```
create table:
```sql
create table `gaia_test`.`test_incremental` PARTITION BY LIST (country_code)(PARTITION p1 values in ("CA","GB","US","ZH")) PROPERTIES ("replication_num" = "1") as select
*
from gaia_test.country_codes;
```
error
```
[HY000][1105] errCode = 2, detailMessage = Failed to execute CREATE TABLE AS SELECT Reason: errCode = 2, detailMessage = The list partition column must be NOT NULL
```
### What You Expected?
create table success
### How to Reproduce?
_No response_
### Anything Else?
_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.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] hf200012 closed issue #9411: [Bug] CTAS create table by list partition error
Posted by GitBox <gi...@apache.org>.
hf200012 closed issue #9411: [Bug] CTAS create table by list partition error
URL: https://github.com/apache/incubator-doris/issues/9411
--
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