Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> How to conver into date in hive


Copy link to this message
-
Re: How to conver into date in hive
Probably you could hardcode those in a ternary operator or a
switch/case or if/else expression.

Ruslan

On Tue, Oct 16, 2012 at 10:16 AM,  <[EMAIL PROTECTED]> wrote:
> Hi all,
>
> Is there any way to convert months in names.
> like.
>
> 1   to   Jan
> 2   to   Feb
> 3   to   Mar
>
> and so on....  (here 1, 2, 3 are having string data type)
>
>
> Please suggest.
>
> Thanks & Regards
> Yogesh Kumar
>
> The information contained in this electronic message and any attachments to
> this message are intended for the exclusive use of the addressee(s) and may
> contain proprietary, confidential or privileged information. If you are not
> the intended recipient, you should not disseminate, distribute or copy this
> e-mail. Please notify the sender immediately and destroy all copies of this
> message and any attachments.
>
> WARNING: Computer viruses can be transmitted via email. The recipient should
> check this email and any attachments for the presence of viruses. The
> company accepts no liability for any damage caused by any virus transmitted
> by this email.
>
> www.wipro.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB