AnsweredAssumed Answered

Storing dates in Hive

Question asked by dobbyssock87 on Aug 9, 2018
Latest reply on Aug 16, 2018 by MichaelSegel

My team is trying to determine the best practice for storing dates in hive tables. The two options we have debated are storing it as a string in the format yyyymmdd or as a date in the format yyyy-mm-dd (as it most often comes to us from the source). Is there a standard industry best approach? This seems to be especially relevant when your date column is a partition column because it impacts the folder names when loading partitions dynamically.

Outcomes