You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "quicklyfast (via GitHub)" <gi...@apache.org> on 2023/04/21 02:29:33 UTC

[GitHub] [doris] quicklyfast opened a new issue, #18881: [Bug] use show create table xxxx, then give me a error distribution_desc

quicklyfast opened a new issue, #18881:
URL: https://github.com/apache/doris/issues/18881

   ### Search before asking
   
   - [X] I had searched in the [issues](https://github.com/apache/doris/issues?q=is%3Aissue) and found no similar issues.
   
   
   ### Version
   
   version doris-1.2.2-rc01(AVX2) RELEASE (build file://be0ca7388ef3@Unknown)
   Built on Fri, 10 Feb 2023 16:46:09 UTC by be0ca7388ef3
   
   ### What's Wrong?
   
   I created a table `test` with `DISTRIBUTED BY RANDOM BUCKETS 10`, and then executed `show create table test`. The returned DDL statement could not be executed, and upon investigation, it was found that there was round brackets after `RANDOM`.
   
   1. create table `test`
   ```sql
   CREATE TABLE `test` (
     `id` int(11) NULL,
     `col1` text NULL,
     `col2` text NULL
   ) ENGINE=OLAP
   DUPLICATE KEY(`id`)
   distributed by random buckets 10
   PROPERTIES (
   "replication_num" = "1"
   );
   ```
   2. show create table test
   ```
   CREATE TABLE `test` (
     `id` int(11) NULL,
     `col1` text NULL,
     `col2` text NULL
   ) ENGINE=OLAP
   DUPLICATE KEY(`id`)
   COMMENT 'OLAP'
   DISTRIBUTED BY RANDOM() BUCKETS 10
   PROPERTIES (
   "replication_allocation" = "tag.location.default: 1",
   "in_memory" = "false",
   "storage_format" = "V2",
   "disable_auto_compaction" = "false"
   );
   ```
   
   ### What You Expected?
   
   ```
   CREATE TABLE `test` (
     `id` int(11) NULL,
     `col1` text NULL,
     `col2` text NULL
   ) ENGINE=OLAP
   DUPLICATE KEY(`id`)
   COMMENT 'OLAP'
   DISTRIBUTED BY RANDOM BUCKETS 10
   PROPERTIES (
   "replication_allocation" = "tag.location.default: 1",
   "in_memory" = "false",
   "storage_format" = "V2",
   "disable_auto_compaction" = "false"
   );
   ```
   
   ### How to Reproduce?
   
   _No response_
   
   ### Anything Else?
   
   _No response_
   
   ### 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] yiguolei closed issue #18881: [Bug] use show create table xxxx, then give me a error distribution_desc

Posted by "yiguolei (via GitHub)" <gi...@apache.org>.
yiguolei closed issue #18881: [Bug]  use show create table xxxx, then give me a error distribution_desc 
URL: https://github.com/apache/doris/issues/18881


-- 
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 #18881: [Bug] use show create table xxxx, then give me a error distribution_desc

Posted by "nextdreamblue (via GitHub)" <gi...@apache.org>.
nextdreamblue commented on issue #18881:
URL: https://github.com/apache/doris/issues/18881#issuecomment-1517377410

   let me fix it


-- 
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