gt;>
>>
>>
>> 2013/7/3 Paul COURTOIS
>>
>>> Hi jerome,
>>>
>>>
>>>
>>> What about the from_unixtime and unix_timestamp Udf ?
>>>
>>>
>>>
>>>
>>>
>>> from_unixtime() whi
>>
>> my 2 cents
>>
>>
>>
>> Paul
>>
>>
>>
>> *De :* Nitin Pawar [mailto:nitinpawar...@gmail.com]
>> *Envoyé :* mercredi 3 juillet 2013 09:29
>> *À :* user@hive.apache.org
>> *Objet :* Re: Dealing with differents date forma
What about the from_unixtime and unix_timestamp Udf ?
>
>
>
>
>
> from_unixtime() which accept bigint
>
>
>
> my 2 cents
>
>
>
> Paul
>
>
>
> *De :* Nitin Pawar [mailto:nitinpawar...@gmail.com]
> *Envoyé :* mercredi 3 juillet 2013 09:29
> *À
Hi jerome,
What about the from_unixtime and unix_timestamp Udf ?
from_unixtime() which accept bigint
my 2 cents
Paul
*De :* Nitin Pawar [mailto:nitinpawar...@gmail.com]
*Envoyé :* mercredi 3 juillet 2013 09:29
*À :* user@hive.apache.org
*Objet :* Re: Dealing with differents date
easiest way in this kind would be write up a small udf.
As Stephen suggested, its just a number so you can do maths to extract year
and month out of the number and then do the comparison.
also 201307 is not a supported date format anywhere as per my knowledge
On Wed, Jul 3, 2013 at 12:55 PM, Jér
Hi Stephen,
Thanks for your reply.
The problem is that my input date is this : in_co_an_mois (format : MM,
integer), for example, this month, we have 201307
and i have to deal with this date : add one month, compare to over date,
etc...
The problem is that apparently, there is no way to do
not sure i fully understand your dilemma.have you investigated any of
the date functions listed here?
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+UDF#LanguageManualUDF-DateFunctions
seems to me you could pull the year and month from a date. or if you have
an int then do s
Hi,
i trying to translate some PL/SQL script in HiveQL, and dealing with
unusual date format.
i added a variable in my hive script : '${hiveconf:in_co_an_mois}' which is
a year/month date format, like this : 201307 (INT format).
I would like to transform this in date format, because i have to in
