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
Pig >> mail # user >> Removing chars from a position


Copy link to this message
-
Re: Removing chars from a position
You can use a combination of SUBSTRING and CONCAT. It would just be
easier and more efficient if you wrote your own UDF to do this.

Sent from my iPhone

On Oct 24, 2012, at 7:47 AM, jamal sasha <[EMAIL PROTECTED]> wrote:

> Hi,
> I have data in form
> 12345,1
> 12346,1
>
> From the field one (id), I want to remove 2nd and fourth digit and just
> output the result
> So basically
> Output is
> 12345,1,135
> 12346,1,136
>
> How do I do this in pig?
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