morningman commented on issue #3930: URL: https://github.com/apache/incubator-doris/issues/3930#issuecomment-652301359
> I suggest that the columns used for keeping order should not exist in the create table statement, but as a hidden column. When creating a unique table, add a property such as sequence=true, so that be can automatically add a hidden one after the key column. The hidden key column is only used for sorting, so that it can be used as a sorting basis when doing compaction and read. A column may be configed as a sequence column during load +1. The only function of the `version` column is to retain the order information of the data in the business logic. So if the `version` column appears in the table schema explicitly, we cannot control the user's query behavior for this column. ---------------------------------------------------------------- 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]
