猪有没有IN子句？

1,apple
2,banana
3,orange
4,grape
5,apple
6,banana

-- 加载数据
data = LOAD 'data.txt' USING PigStorage(',') AS (id:int, fruit:chararray);

-- 过滤出 fruit 列中包含 'apple' 和 'banana' 的记录
filtered_data = FILTER data BY (fruit == 'apple' OR fruit == 'banana');

-- 存储结果
STORE filtered_data INTO 'output.txt' USING PigStorage(',');

apple
banana

-- 加载数据
data = LOAD 'data.txt' USING PigStorage(',') AS (id:int, fruit:chararray);

-- 加载过滤列表
filter_list = LOAD 'filter_list.txt' USING PigStorage(',') AS (fruit:chararray);

-- 进行 JOIN 操作
joined_data = JOIN data BY fruit, filter_list BY fruit;

-- 选择所需的列
filtered_data = FOREACH joined_data GENERATE data::id, data::fruit;

-- 存储结果
STORE filtered_data INTO 'output.txt' USING PigStorage(',');