hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Matouk IFTISSEN <matouk.iftis...@ysance.com>
Subject Re: hive date format
Date Wed, 25 Jun 2014 22:10:35 GMT
Review your oracle date format normaly it look like this : yyyy-mm-dd
HH:mm:ss
You can do -- verbose in sqoop to debug error.
Tegards
Le 26 juin 2014 00:01, "rpriaadaa@gmail.com" <rpriaadaa@gmail.com> a écrit :

> 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