You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hive.apache.org by "rpriaadaa@gmail.com" <rp...@gmail.com> on 2014/06/25 23:20:44 UTC
hive date format
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
Re: hive date format
Posted by Matouk IFTISSEN <ma...@ysance.com>.
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" <rp...@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 <de...@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 <ma...@ysance.com>:
>>>
>>> use ; unix_timestamp(field_date,'DD-MMM-YYYY')
>>>>
>>>>
>>>>
>>>> 2014-06-25 23:20 GMT+02:00 rpriaadaa@gmail.com <rp...@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
>
Re: hive date format
Posted by "rpriaadaa@gmail.com" <rp...@gmail.com>.
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 <de...@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 <ma...@ysance.com>:
>>
>> use ; unix_timestamp(field_date,'DD-MMM-YYYY')
>>>
>>>
>>>
>>> 2014-06-25 23:20 GMT+02:00 rpriaadaa@gmail.com <rp...@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
Re: hive date format
Posted by D K <de...@gmail.com>.
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 <ma...@ysance.com>:
>
> use ; unix_timestamp(field_date,'DD-MMM-YYYY')
>>
>>
>>
>> 2014-06-25 23:20 GMT+02:00 rpriaadaa@gmail.com <rp...@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/>*
>
Re: hive date format
Posted by Matouk IFTISSEN <ma...@ysance.com>.
sorry use this : from_unixtime(field_date,'DD-MMM-YYYY')
2014-06-25 23:27 GMT+02:00 Matouk IFTISSEN <ma...@ysance.com>:
> use ; unix_timestamp(field_date,'DD-MMM-YYYY')
>
>
>
> 2014-06-25 23:20 GMT+02:00 rpriaadaa@gmail.com <rp...@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/>*
Re: hive date format
Posted by Matouk IFTISSEN <ma...@ysance.com>.
use ; unix_timestamp(field_date,'DD-MMM-YYYY')
2014-06-25 23:20 GMT+02:00 rpriaadaa@gmail.com <rp...@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/>*