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

[I] 自动分桶数推算功能为何没生效 [doris]

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

   ### Discussed in https://github.com/apache/doris/discussions/27910
   
   <div type='discussions-op-text'>
   
   <sup>Originally posted by **DA1OOO** December  3, 2023</sup>
   建表使用的`BUCKETS AUTO` ，但是建表的时候没有指定参数`"estimate_partition_size" = "100G"` 
   ![image](https://github.com/apache/doris/assets/56857867/5cb1cee3-ba68-4fc7-bf02-516d3fe80ca8)
   
   我看文档写的默认没有指定的话，初次分桶大小按10G来算分桶数，我的第一个分区buckets数确实为10
   ![image](https://github.com/apache/doris/assets/56857867/7f6912ca-3b97-4fd2-a720-5706b3d047a1)
   但是为什么后面的分区buckets全部为10，官方文档不是写着会根据前七天的数据量来推算bucket数吗，我每个分区5G的数据应该分桶数大概是5。
   ![image](https://github.com/apache/doris/assets/56857867/aef4a16b-3815-4ee9-8d6d-0ced67c6a33e)
   我最新的分区数的bucket还是10。
   我看了一些小表bucket还是一直保持在10。
   第一个分区：
   ![image](https://github.com/apache/doris/assets/56857867/334d750e-66c0-4690-ba67-d5ba9ac2e1af)
   最新的分：
   ![image](https://github.com/apache/doris/assets/56857867/47cd8300-326d-46b6-b36e-05f831b7c4cc)
   </div>


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

Re: [I] 自动分桶数推算功能为何没生效 [doris]

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

   新增分区方式：
   ALTER TABLE example_db.my_table
   ADD PARTITION p1 VALUES [("2014-01-01"), ("2014-02-01"));
   没有指定分桶信息。


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

Re: [I] [Bug] 自动分桶数推算功能为何没生效 [doris]

Posted by "DA1OOO (via GitHub)" <gi...@apache.org>.
DA1OOO closed issue #27915: [Bug] 自动分桶数推算功能为何没生效
URL: https://github.com/apache/doris/issues/27915


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