try it on the console. load a small set of data, then dump it right away. seems like you also need to handle "", if you are using the default loader
On Feb 26, 2013, at 5:16 PM, Dan Yi <[email protected]> wrote: > Hi,Young, > > I tried that one too, still won't work > > On 2/26/13 5:12 PM, "Young Ng" <[email protected]> wrote: > >> C = FILTER B BY itemid is null; >> >> you cant use == or != for null value >> >> On 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. >>> >>> >>> >>> >>> >> >
