Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Plain View
Pig >> mail # user >> how to filter empty string


Copy link to this message
-
how to filter empty string
Hi,

I have data as following :

Timestamp  itemid  actiontype

"2012-11-01T23:59:59.000+0000" "" "Search"
"2012-11-01T23:59:59.000+0000" "688531" "ShowItemDetail"
..

I want to filter out all the lines that have itemid as empty,
I tried different approach but none of work:

C = FILTER B BY itemid != '';
C = FILTER B BY itemid != null;
Anyone knows how to do it? Thanks.
+
Young Ng 2013-02-27, 01:12
+
Dan Yi 2013-02-27, 01:16
+
Young Ng 2013-02-27, 01:21
+
Jinyuan Zhou 2013-02-27, 01:22