walterddr opened a new issue #8045: URL: https://github.com/apache/pinot/issues/8045
Currently datetime objects are either stored as String with simple date format or stored as timestamp which persists as epoch long value. This has several problems. 1. #7804 added validation that requires the underlying string and the simple date format needs to be both time and lexical ordering. 2. timestamp can only return a ISO standardized string There's no way for users to request a customized stringify format return without it to be both time and lexical ordering. Propose to add a new DataType "DateTime". this data type - stores and retrieves the column value as String according to the simple date format, but only order in epoch (e.g. cannot be used as String comparison). This way we can support ingesting data and retrieving them in format such as `mm/dd/yyyy`. -- 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...@pinot.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@pinot.apache.org For additional commands, e-mail: commits-h...@pinot.apache.org
