hadoop pig :加入条件(例如 tab1.COL1 LIKE (%tab2.col2%) ) [英] hadoop pig : join on a condition (ex. tab1.COL1 LIKE (%tab2.col2%) )

问题描述

如何在 PIG 中实现条件连接?SQL 等效示例:

How to implement a join on a condition in PIG? SQL equivalent Examples:

       select * from tab1, tab2 where instr(t1.col1,t2.col1 ) > 1 ;
       select * from tab1, tab2 where f(t1.col1) =f(t2.col1)  ;

非常感谢.菲利波

推荐答案

试试这个.

1.

Cross_Table = CROSS tab1, tab2;
Filter_Table = FILTER Cross_Table BY NOT(STARTSWITH(tab1::col1, tab2::col1));

2.

Join_Table = JOIN tab1 BY f(col1) INNER JOIN, tab2 BY f(col1); 

这篇关于hadoop pig :加入条件(例如 tab1.COL1 LIKE (%tab2.col2%) )的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！