Review your oracle date format normaly it look like this : -mm-dd
HH:mm:ss
You can do -- verbose in sqoop to debug error.
Tegards
Le 26 juin 2014 00:01, "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
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.
Probably you meant from_unixtime(timestamp in bigint, "dd-MMM-"). "dd"
vs "DD" does make a difference in the output.
-Deepesh
On Wed, Jun 25, 2014 at 2:30 PM, Matouk IFTISSEN wrote:
> sorry use this : from_unixtime(field_date,'DD-MMM-')
>
>
> 2014-06-25 23:27 GMT+02:00 Matouk IFTISSEN
sorry use this : from_unixtime(field_date,'DD-MMM-')
2014-06-25 23:27 GMT+02:00 Matouk IFTISSEN :
> use ; unix_timestamp(field_date,'DD-MMM-')
>
>
>
> 2014-06-25 23:20 GMT+02:00 rpriaa...@gmail.com :
>
> Hi,
>>
>> Please can someone tell me how to change the date format in hive.
>> I nee
use ; unix_timestamp(field_date,'DD-MMM-')
2014-06-25 23:20 GMT+02:00 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 [im
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