hadoop - Apache pig : Easier way to filter by a bunch of values from the same field

Question

假设我想根据同一字段中的值选择数据子集。现在我必须做这样的事情

TestLocationsResults = FILTER SalesData by (StoreId =='17'
or StoreId =='85'
or StoreId =='12'
or StoreId =='45'
or StoreId =='26'
or StoreId =='75'
or StoreId =='13'
) 

在 SQL 中，我们可以简单地这样做:

SELECT * FROM SalesData where StoreID IN (17, 12, 85, 45, 26, 75, 13)

Pig 中是否有我缺少的类似快捷方式？

Answer 1

看起来像Pig 0.12 added an IN operator .

所以你可以这样做

FILTER SalesData BY StoreID IN (17, 12, 85, 45, 26, 75, 13);