In Pig Latin data flows are more linear than SQL, so SQL subqueries
tend to come first in Pig Latin scripts. Given that, your first SQL
query would look roughly like:
-- Find the records from s that will form the 'in' clause
A = load 'supplier' as (); --
B = filter A by s_comment matches '.*
Hi,
I like to know how I can transform a query sql to a script pig especially when
I have a query like that :
selectp_brand,p_type,p_size,count(distinct ps_suppkey) as
supplier_cntfrompartsupp,partwherep_partkey = ps_partkeyand p_brand <>
'[BRAND]'and p_type not like '[TYPE]%'and p_size in ([S