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/29 02:30:07 UTC
[GitHub] [incubator-doris] taoshengyijiua opened a new issue, #9833: [Bug] 中文文档bug
taoshengyijiua opened a new issue, #9833:
URL: https://github.com/apache/incubator-doris/issues/9833
### 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
１.０.０
### What's Wrong?
CREATE TABLE example_db.table_hash
(
k1 BIGINT,
k2 LARGEINT,
v1 VARCHAR(2048) REPLACE,
v2 SMALLINT SUM DEFAULT "10"
)
UNIQUE KEY(k1, k2)
DISTRIBUTED BY HASH (k1, k2) BUCKETS 32
PROPERTIES(
"storage_medium" = "SSD",
"storage_cooldown_time" = "2015-06-04 00:00:00"
);
文档地址：https://doris.apache.org/zh-CN/sql-manual/sql-reference/Data-Definition-Statements/Create/CREATE-TABLE.html#create-table
该语句创建sql报错，UNIQUE_KEYS table should not specify aggregate type for non-key column
value字段不能指定聚合类型
### What You Expected?
修改建表语句，删除v1REPLACE
并且删除V２的聚合字段
CREATE TABLE table_hash
(
k1 BIGINT,
k2 LARGEINT,
v1 VARCHAR(2048)
)
UNIQUE KEY(k1, k2)
DISTRIBUTED BY HASH (k1, k2) BUCKETS 32
;
### How to Reproduce?
在１.０.０版本执行以上语句
### 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] THELEMITED commented on issue #9833: [Bug] 中文文档bug
Posted by GitBox <gi...@apache.org>.
THELEMITED commented on issue #9833:
URL: https://github.com/apache/incubator-doris/issues/9833#issuecomment-1140373477
Hai
--
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] yiguolei closed issue #9833: [Bug] 中文文档bug
Posted by GitBox <gi...@apache.org>.
yiguolei closed issue #9833: [Bug] 中文文档bug
URL: https://github.com/apache/incubator-doris/issues/9833
--
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] hf200012 commented on issue #9833: [Bug] 中文文档bug
Posted by GitBox <gi...@apache.org>.
hf200012 commented on issue #9833:
URL: https://github.com/apache/incubator-doris/issues/9833#issuecomment-1140364591
这里应该是聚合模型
--
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