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, "rpriaa...@gmail.com" <rpriaa...@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 <deepe...@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.iftis...@ysance.com> wrote: >> >>> sorry use this : from_unixtime(field_date,'DD-MMM-YYYY') >>> >>> >>> 2014-06-25 23:27 GMT+02:00 Matouk IFTISSEN <matouk.iftis...@ysance.com>: >>> >>> use ; unix_timestamp(field_date,'DD-MMM-YYYY') >>>> >>>> >>>> >>>> 2014-06-25 23:20 GMT+02:00 rpriaa...@gmail.com <rpriaa...@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 >