liuxiahuiyi commented on issue #5708:
URL: 
https://github.com/apache/incubator-doris/issues/5708#issuecomment-827389558


   > > > 并没有看明白你的问题,能举个栗子吗?
   > > 
   > > 
   > > 例如有三行数据: uuid1,10001,10.5; uuid2,10001,5.5; uuid1,10001,10.5; 
其中第一行和第三行数据是重复的,希望的rollup结果是userid 10001的总消费是10.5+5.5=16,而不是10.5+5.5+10.5=26.5
   > 
   > it is the business logic, doris can not Identify the duplicate rows, 
actually in our production environment, it may occur that
   > two rows are same but they are different records
   
   的确是个business logic,但是想尽可能通过一些数据模型的设计去避免这些问题,如果materialized view 
时候可以改变cost列的aggregation type或者materialized view 
能够支持两列之间的除法,是可以做到的。请问下doris之后的版有可能支持上面说的这两个features吗


-- 
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:
[email protected]



---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to