for null: itemid is not null should be used On Tue, Feb 26, 2013 at 3:41 PM, Dan Yi <[email protected]> wrote:
> 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. > > > > > > -- -- Jinyuan (Jack) Zhou
