[I] [Bug] 同样的数据，排序键顺序不一样，数据量差30% [doris]

[via GitHub]

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

   ### 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
   
   doris-2.0.9-5c2fca80b0
   
   ### What's Wrong?
   
   建表语句1：
   
![image](https://github.com/user-attachments/assets/9aa7faad-10dc-44ef-b5d9-739ed5999bc9)
   建表语句2：
   
![image](https://github.com/user-attachments/assets/c136764a-88f5-4efe-a3de-8cc411931f1f)
   同样使用lz4压缩方式，唯一的区别就是，主键排序字段不一样
   表一使用lz4压缩，主键顺序event_name(varchar100)排在首位，show data 大小为 5.203 GB
   表一使用lz4压缩，主键顺序event_time(datetime)排在首位，show data 大小为 3.815 GB
   为何仅仅修改了排序键的顺序，占用磁盘空间差距近30%？
   
   ### What You Expected?
   
   主键顺序不同，是否有索引数据占用了空间？
   
   ### 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-unsubscr...@doris.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


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