Try WHERE dataofbirth=unix_timestamp("2011-10-08 00:00:00");
From: Bhuvana Bellala [mailto:bhuvana.bell...@cormac-corp.com]
Sent: Monday, July 07, 2014 9:01 PM
To: user@hive.apache.org
Subject: Querying a time stamp
Hi,
I have a column called dateofbirth in my hive table and the dat
Hi,
I have a column called dateofbirth in my hive table and the date of birth is
stored as a BigInt (Unix_timestamp). Now I want to query this table using this
query
SELECT * FROM mytable WHERE dataofbirth=unix_timestamp('2011-10-08');
However, this query is returning 0 results but I know ther
