+1
Aggregate storage model does cause trouble for new users. -- 此致!Best Regards 陈明雨 Mingyu Chen Email: chenmin...@apache.org At 2019-11-28 09:52:30, "Zhao Chun" <zh...@apache.org> wrote: >Hi all > >Currently, Doris will create table as AGGREGATE type if user don't specify >table's storage model. This default behavior will bring some confusion to >new user of Doris who is familiar with relational database and is not very >familiar with Doris storage model. For example, user load two same rows >into Doris, if the storage model is AGGREGATE Doris will merge these two >rows in one. Besides this, AGGREGATE model has bad performance than >duplicate model when user's query pattern don't match. > >So, I propose changing the default storage model from AGGREGATE to >DUPLICATE. > >Thanks, >Zhao Chun