[GitHub] [incubator-doris] yangzhg commented on issue #2412: [CHANGE] change default storage model from aggregate to duplicate(#2318)

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

yangzhg commented on issue #2412: [CHANGE] change default storage model from aggregate to duplicate(#2318)
URL: https://github.com/apache/incubator-doris/pull/2412#issuecomment-563575408
 
 
   > > > Maybe the `first 36 bytes` is a more appropriate value for selecting sort columns.
   > > 
   > > 
   > > When the first column is a varchar who's length is larger than 36 bytes, it may be a not good idea to make it the only key column. In this case, the second and the thrid columns are locally ordered, so the statistics(min/max) of column block can also be used to skip data to accelerate query speed.
   > > I think it's OK to make the first max(`first 36 bytes`, 3) column as the key columns.
   > 
   > Agree.
   
   Done

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