[GitHub] [incubator-doris] chaoyli commented on issue #1867: Too many segments in one singleton rowset

[GitBox <gi...@apache.org>]

chaoyli commented on issue #1867: Too many segments in one singleton rowset
URL: https://github.com/apache/incubator-doris/issues/1867#issuecomment-534883622
 
 
   You can create table with hyperloglog type to reproduce the problem.
   ```
   CREATE TABLE `store_sales` (
     `ss_item_sk` int(11) NULL COMMENT "",
     `ss_ticket_number` int(11) NULL COMMENT "",
     `ss_sold_date_sk` int(11)  NULL COMMENT "",
     `ss_sold_time_sk` int(11)  NULL COMMENT "",
     `ss_customer_sk` int(11)  NULL COMMENT "",
     `ss_cdemo_sk` int(11)  NULL COMMENT "",
     `ss_hdemo_sk` int(11)  NULL COMMENT "",
     `ss_addr_sk` int(11)  NULL COMMENT "",
     `ss_store_sk` int(11)  NULL COMMENT "",
     `ss_promo_sk` int(11)  NULL COMMENT "",
     `ss_quantity` int(11)  NULL COMMENT "",
     `ss_wholesale_cost` decimal(7, 2) replace NULL COMMENT "",
     `ss_list_price` decimal(7, 2) replace  NULL COMMENT "",
     `ss_sales_price` decimal(7, 2) replace  NULL COMMENT "",
     `ss_ext_discount_amt` decimal(7, 2) replace  NULL COMMENT "",
     `ss_ext_sales_price` decimal(7, 2) replace  NULL COMMENT "",
     `ss_ext_wholesale_cost` decimal(7, 2) replace  NULL COMMENT "",
     `ss_ext_list_price` decimal(7, 2) replace  NULL COMMENT "",
     `ss_ext_tax` decimal(7, 2) replace  NULL COMMENT "",
     `ss_coupon_amt` decimal(7, 2) replace  NULL COMMENT "",
     `ss_net_paid` decimal(7, 2) replace  NULL COMMENT "",
     `ss_net_paid_inc_tax` decimal(7, 2) replace  NULL COMMENT "",
     `ss_net_profit` decimal(7, 2) replace  NULL COMMENT "",
     `hll_col` HLL HLL_UNION
   ) ENGINE=OLAP
   DISTRIBUTED BY HASH(`ss_item_sk`, `ss_ticket_number`) BUCKETS 1
   PROPERTIES (
   "replication_num" = "1"
   );
   ```

----------------------------------------------------------------
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.
 
For queries about this service, please contact Infrastructure at:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org