[GitHub] [hive] klcopp commented on pull request #1938: HIVE-24693: Convert timestamps to zoned times without string operations

[GitBox <gi...@apache.org>]

klcopp commented on pull request #1938:
URL: https://github.com/apache/hive/pull/1938#issuecomment-775286514


   I've seen a couple users come back and ask why 0 shows up as 0001 but they seemed satisfied with the explanation that year 0 doesn't exist. I mean they don't represent all other users but... since it's not a real year I'm not sure we should let users use it.
   
   According to the wiki Hive doesn't support dates/timestamps outside of years 0001–9999. AFAIK currently Hive accepts negative years (though I'm not sure they're displayed/stored correctly?) and auto-converts 0000 to 0001 since 0000 doesn't exist. I think we should decide what we want and change either the wiki or Hive's behavior to not accept pre-0001 and post-9999 dates – don't know how feasible this is though.
   
   @jcamachor  I'd be interested in what you think too!


----------------------------------------------------------------
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:
users@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: gitbox-unsubscribe@hive.apache.org
For additional commands, e-mail: gitbox-help@hive.apache.org