filtersource= FILTER source BY NOT ID IN (your condition or joined field);
例子:
HIVE> select * from table where id NOT IN ('1','2','3');
grunt> A = LOAD 'db.table' USING org.apache.hive.hcatalog.pig.HCatLoader() AS (id:int, value:chararray);
grunt> B = FILTER A BY NOT id IN (1,2,3);
2条答案
按热度按时间cyvaqqii1#
是的,你可以在Pig身上这样做:
例子:
qoefvg9y2#
除了@rijulsahu的答案,你还可以使用
MATCHES
-对正则表达式使用java格式的正则表达式匹配。BY NOT(ID MATCHES [123])