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 Plain View
Pig >> mail # user >> accessing like array


Copy link to this message
-
accessing like array
Hi,
  I have data in form
1,0.2,0.3
1,0.3,0.4
2,0.8,0.2
2,0.9,0.7
and so on..
so id, va1,val2 format..

This id is already sorted based on val 2
I want to select the 2nd element for each id with val2 (ignoring val1)
for example in the above dataset what i want to return is
1,0.4
2,0.7

How to go about this??
Thanks
+
Mohammad Tariq 2012-11-06, 14:17
+
yogesh dhari 2012-11-07, 05:07
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