WingsGo commented on issue #2262: [Proposal] Support Dynamic Partition in Doris URL: https://github.com/apache/incubator-doris/issues/2262#issuecomment-557958394 > > I think because doris only support int type , date type and datetime type as partition column, and the minimize time unit is day, what about unify the format as yyyyMMdd? > > What I want to emphasize is that how to parse the content of int type, is there an option to specify this? For example, if users store timestamp value in an int column, it also can be used as a partition column, and the dynamic partition function can be applied to it. And user can also store value like "20190101" in int value. If we intent to support both two types, we should provide an option to user to tell Doris how to parse its value. I think you mean that if user store timestamp such as '1546272000000', we should add partition like ```ALTER TABLE ADD PARTITION VALUES LESS THAN("1546358400000")```. If user store value like "2019010100000000", we should add partition like ```ALTER TABLE ADD PARTITION VALUES LESS THAN("2019010200000000")```?
---------------------------------------------------------------- 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] With regards, Apache Git Services --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
