Best Data Type for Hive Date Partition

ChineduLB — Fri, 16 Sep 2022 14:17:38 GMT

we need to partition our Hive Table based on date. Date/Month/Year

is it better to use int or string for the partition types.

ex:

CREATE EXTERNAL TABLE partition (id string, event timestamp and so on)
PARTITIONED BY (year INT, month INT, day INT)

Stored as Parquet

CREATE EXTERNAL TABLE partition (id string, event timestamp and so on)
PARTITIONED BY (year string, month string, day string)

Stored as Parquet

Noticed that we couldn't do queries like:

... where day > 10 with the string option

Re: Best Data Type for Hive Date Partition

EricL — Sat, 13 Apr 2019 02:32:55 GMT

Hi,

I would suggest to use INT rather than STRING.

Firstly, searching based INT type is faster, and secondly, like you said, you can do numeric comparison, which will be different from the STRING type comparison.

question Re: Best Data Type for Hive Date Partition in Support Questions

Best Data Type for Hive Date Partition

Re: Best Data Type for Hive Date Partition