Devopam is right, your date format looks wrong (should be -mm-dd rather
than /mm/dd.
Casting should work, trying this with Hive trunk:
hive> select c1, date_add('1985-01-01', c1) from short1;
FAILED: SemanticException [Error 10014]: Line 1:11 Wrong arguments 'c1':
DATE_ADD() only takes
hi Yashwanth,
Can you please check once if DATE_ADD('1985-01-01', day_key) works for you
regards
Devopam
On Fri, Jan 16, 2015 at 1:12 PM, Yashwanth M
wrote:
> Hi,
>
>
>
> I’ve been facing some issues in using date_add()
>
>
>
> I have column ‘*day_key*’ that is short integer and stores day
