CODEWITHSUNDEEP
hiveunix-timestamphiveql
Younes
Younes

Reputation: 18

what data type to use when to store unix time stamps in a Hive table

Sample of time stamps I'm working with: - 874833878 - 887736532 - 879196566 - 892430094 do I just store them as (my_date TIMESTAMP)?

Upvotes: 0

Views: 454

Answers (1)

Jeremy Beard
Jeremy Beard

Reputation: 2725

The Hive date UDFs expect UNIX timestamps in the BIGINT data type, so using that for your field would be most compatible.

Upvotes: 1

Related Questions