hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "rpriaadaa@gmail.com" <rpriaa...@gmail.com>
Subject Re: hive date format
Date Wed, 25 Jun 2014 22:00:40 GMT
I am actually trying to sqoop a hive table to oracle. The date
format(25-JUN-2014 in oracle) pose to be a problem. guessed may be if i
have the date format changed in the hive table itself will resolve the
issue. But now im not sure if it is the right approach, Can some one help
with this please.


On Wed, Jun 25, 2014 at 2:41 PM, D K <deepeshk@gmail.com> wrote:

> Probably you meant from_unixtime(timestamp in bigint, "dd-MMM-yyyy"). "dd"
> vs "DD" does make a difference in the output.
>
> -Deepesh
>
>
> On Wed, Jun 25, 2014 at 2:30 PM, Matouk IFTISSEN <
> matouk.iftissen@ysance.com> wrote:
>
>> sorry use this : from_unixtime(field_date,'DD-MMM-YYYY')
>>
>>
>> 2014-06-25 23:27 GMT+02:00 Matouk IFTISSEN <matouk.iftissen@ysance.com>:
>>
>> use ; unix_timestamp(field_date,'DD-MMM-YYYY')
>>>
>>>
>>>
>>> 2014-06-25 23:20 GMT+02:00 rpriaadaa@gmail.com <rpriaadaa@gmail.com>:
>>>
>>> Hi,
>>>>
>>>> Please can someone tell me how to change the date format in hive.
>>>> I need it in the format  '25-JUN-2014'
>>>>
>>>> --
>>>> Regards,
>>>> riad
>>>>
>>>
>>>
>>>
>>> --
>>>
>>> *Matouk IFTISSEN | Consultant BI & Big Data [image:
>>> http://www.ysance.com] *
>>> 24 rue du sentier - 75002 Paris - www.ysance.com
>>> <http://www.ysance.com/>
>>> Fax : +33 1 73 72 97 26
>>> *Ysance sur* :*Twitter* <http://twitter.com/ysance>* | Facebook
>>> <https://www.facebook.com/pages/Ysance/131036788697> | Google+
>>> <https://plus.google.com/u/0/b/115710923959357341736/115710923959357341736/posts>
| LinkedIn
>>> <http://www.linkedin.com/company/ysance> | Newsletter
>>> <http://www.ysance.com/nous-contacter.html>*
>>> *Nos autres sites* : *ys4you* <http://wwww.ys4you.com/>* | labdecisionnel
>>> <http://www.labdecisionnel.com/> | decrypt <http://decrypt.ysance.com/>*
>>>
>>
>>
>>
>> --
>>
>> *Matouk IFTISSEN | Consultant BI & Big Data [image:
>> http://www.ysance.com] *
>> 24 rue du sentier - 75002 Paris - www.ysance.com <http://www.ysance.com/>
>> Fax : +33 1 73 72 97 26
>> *Ysance sur* :*Twitter* <http://twitter.com/ysance>* | Facebook
>> <https://www.facebook.com/pages/Ysance/131036788697> | Google+
>> <https://plus.google.com/u/0/b/115710923959357341736/115710923959357341736/posts>
| LinkedIn
>> <http://www.linkedin.com/company/ysance> | Newsletter
>> <http://www.ysance.com/nous-contacter.html>*
>> *Nos autres sites* : *ys4you* <http://wwww.ys4you.com/>* | labdecisionnel
>> <http://www.labdecisionnel.com/> | decrypt <http://decrypt.ysance.com/>*
>>
>
>


-- 
Regards,
riad

Mime
View raw message